Query does not wrap

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