Query does not wrap
Hi all.
Why this query response with error: ?
<script runat="server">
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
using(OdbcConnection con = new OdbcConnection(ConnStr))
using(OdbcCommand cmd = new OdbcCommand
("SELECT * FROM _tbl " &_
"WHERE 1 AND NAME <> 'NULL' LIMIT 0, 20", con))
{
con.Open();
dgrAllNames.DataSource = cmd.ExecuteReader(
CommandBehavior.CloseConnection |
CommandBehavior.SingleResult);
dgrAllNames.DataBind();
con.Close();
}
}
</script>
11: using(OdbcCommand cmd = new OdbcCommand
12:
13: ("SELECT * FROM tbl " &
14: “WHERE 1 AND NAME <> ‘NULL’ LIMIT 0, 20”, con))
15:
Can u help me?
It’s because your code is written in C#, but you are using VB.NET characters.Try…
("SELECT * FROM _tbl " +
"WHERE 1 AND NAME <> 'NULL' LIMIT 0, 20", con))
Thanks Sir.
But I have another question, I’m sorry.
With ASP I have this query:
strTIME = replace(time(), ".", ":")
SQL = " SELECT * FROM "
SQL = SQL & " tbl_1 "
SQL = SQL & " WHERE "
SQL = SQL & " myDate = '" & formatGMTDate(DATE(),0,"yyyy-mm-dd") & "' "
if strTIME >= "00:00:00" AND strTIME =< "05:59:59" then
SQL = SQL & " AND "
SQL = SQL & " _myTime BETWEEN '00:00:00' AND '05:59:59' "
end if
How do I write the same string with .net?
Thanks