Question

用VS2010中获取数据库字段的值怎么写语句?

请 大神帮忙 指点一下 id= 表的id 表达式用vb怎么写？
代码如下：
Private Sub btnOk_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOk.Click
Dim id As Integer
Dim sqlConnection1 As SqlClient.SqlConnection
sqlConnection1 = New System.Data.SqlClient.SqlConnection(sqlConnect)
sqlConnection1.Open()
Dim sql As String = "select count(*) from View_Users where Users_Name='" & txtUserName.Text.Trim() & "' and Password='" & MD5(LTrim(RTrim(txtPassword.Text())), 32) & "'"
Dim sqlCmd As SqlCommand = New SqlCommand(sql, sqlConnection1)
Dim count As Integer
count = sqlCmd.ExecuteScalar
If count > 0 Then
id = 数据库 表 id字段的值 '这个地方不会写表达式
main.Show()
Me.Hide()
Else
TextBox1.Text = MD5(LTrim(RTrim(txtPassword.Text())), 32)
txtPassword.Text = ""
End If
sqlConnection1.Close()
End Sub

Answer 1

你没有 返回任何column，得不到值
你用
select ID from View_Users where Users_Name= 返回datatable,用Rows.Count判断大小，再用id
Convert.ToInt32(datatable.Row[0]["ID"])得到ID