我在Page_Load事件中写:
Dim strConn As String
Dim selectcommand As SqlClient.SqlDataAdapter
Dim ds As DataSet
Dim strUsername as string strUsername=Session("user")
strConn = ConfigurationManager.AppSettings("SQLConnString")
conn2 = New SqlClient.SqlConnection(strConn)
If conn2.State = ConnectionState.Closed Then
conn2.Open()
End If
selectcommand = New SqlClient.SqlDataAdapter("select * from contestregist where username='" + strUsername + "'", conn2)
ds = New DataSet
selectcommand.Fill(ds)
school.Text = ds.Tables(0).Rows(0).Item(2).ToString
系统就报错
而我把上述代码写到一个按钮中就没有任何问题,这是为什么
请问我想在页面加载后就将满足条件的数据显示出来而不需要点击任何按钮,该如何实现,望指教,谢谢
Dim strConn As String
Dim selectcommand As SqlClient.SqlDataAdapter
Dim ds As DataSet
Dim strUsername as string strUsername=Session("user")
strConn = ConfigurationManager.AppSettings("SQLConnString")
conn2 = New SqlClient.SqlConnection(strConn)
If conn2.State = ConnectionState.Closed Then
conn2.Open()
End If
selectcommand = New SqlClient.SqlDataAdapter("select * from contestregist where username='" + strUsername + "'", conn2)
ds = New DataSet
selectcommand.Fill(ds)
school.Text = ds.Tables(0).Rows(0).Item(2).ToString
系统就报错
而我把上述代码写到一个按钮中就没有任何问题,这是为什么
请问我想在页面加载后就将满足条件的数据显示出来而不需要点击任何按钮,该如何实现,望指教,谢谢
if(!IsPostBack)
BindData();
加try catch单步看看什么错误
注意加上
if(!IsPostBack)