DropDownList and numbered SQL databases

See more:

ASP.NET

DropDownList

I have populated a DropDownList with values from an SQL statement and it works.

Try
     cmdStr = "SELECT [idt],[col1] FROM [test];"
     Using conn As New SqlConnection(connStr)
         Using cmd As New SqlCommand(cmdStr, conn)
             conn.Open()
             cmd.ExecuteNonQuery()
             Using da As New SqlDataAdapter(cmd)
                 da.Fill(ds)
                 DropDownList1.DataSource = ds.Tables(0)
                 DropDownList1.DataTextField = "idt"
                 DropDownList1.DataValueField = "col1"
                 DropDownList1.DataBind()
             End Using
             cmd.Dispose()
             conn.Close()
             conn.Dispose()
         End Using
     End Using
 Catch ex As Exception
     TextBox1.Text = ex.Message
 End Try

The problem is the SQL list starts with idt=68 but DropDownList1 equals DropDownList1.DataTextField="" instead of 68.

Try
   cmdStr = "SELECT [datetime],[col1],[col2],[col3] FROM [test] WHERE [idt]=@idt;"
   Using conn As New SqlConnection(connStr)
       Using cmd As New SqlCommand(cmdStr, conn)
           conn.Open()
           cmd.Parameters.AddWithValue("@idt", DropDownList1.DataTextField)
           cmd.ExecuteNonQuery()
 ...

How do I retrieve the number 68?