UC知道asp.net 读取sql数据库的值赋给一个labe.text
来源：百度知道 编辑：UC知道 时间：2024/05/02 21:22:29
小弟原来用php，这两天想学asp.net遇到问题
原来php中很容易的一个事到.net里怎么也不会了请问如何读取sql数据库的值赋给一个labe.text 。我写了一段可是怎么也不对
<%@ import Namespace ="system.data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="vb" runat="server">
Sub page_load(ByVal send As Object, ByVal e As EventArgs)
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim dr As SqlDataReader
Dim text1 As String
myConnection = New SqlConnection("server=localhost;database=SCOA;uid=sa;pwd=bilanz")
myConnection.Open()
myCommand = New SqlCommand("select * form users where username=yangtao", myConnection)
dr = myCommand.ExecuteReader()
text1.text = dr.GetString(dr.GetOrdinal("pwd"))
myConnection.Close()
End Sub
</script>
再问一个，
原来php中很容易的一个事到.net里怎么也不会了请问如何读取sql数据库的值赋给一个labe.text 。我写了一段可是怎么也不对
<%@ import Namespace ="system.data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="vb" runat="server">
Sub page_load(ByVal send As Object, ByVal e As EventArgs)
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim dr As SqlDataReader
Dim text1 As String
myConnection = New SqlConnection("server=localhost;database=SCOA;uid=sa;pwd=bilanz")
myConnection.Open()
myCommand = New SqlCommand("select * form users where username=yangtao", myConnection)
dr = myCommand.ExecuteReader()
text1.text = dr.GetString(dr.GetOrdinal("pwd"))
myConnection.Close()
End Sub
</script>
再问一个，
要判断一下DataReader中是否有数据：
dr = myCommand.ExecuteReader()
if(dr.Read()){
text1.text = dr.GetString(dr.GetOrdinal("pwd"))
}
应该改成这样吧.我好久不用VB了,用C#的.不知道VB这样写是不是.
SqlDataReader这个要reda()一下,它才移到下一个记录读取数据.
dr = myCommand.ExecuteReader()
if dr.read() then
text1.text = dr.getstring("pwd")
else
text1.text=""
end if
myConnection.Close()
同 brotherdeep