UC知道我使用.net 进行SQL server进行数据库连接，读可以，写不可以？
来源：百度知道 编辑：UC知道 时间：2024/09/27 05:44:53
我用.net与sql server2000进行数据库连接，主要是读可以读到用户重复，但是增加用户时写不进去？
部分写数据库的代码如下：
connectionstring = "server=FRICKFANG;uid=sa;pwd=Password;database=users"
myconnection = New SqlConnection(connectionstring)
Dim strinsert As String
strinsert = "insert into userinfo1(uname,upassword,uemail) values('" + Username.Text + "','" + Password.Text + "','" + Email.Text + "')"
mycommand = New SqlCommand(strinsert, myconnection)
Dim added As Integer
Try
myconnection.Open()
added = mycommand.ExecuteNonQuery
If added > 0 Then
Response.Redirect("good.aspx")
End If
Catch err As Exception
Trace.Write(err.Message)
Finally
If (Not myconnectio
部分写数据库的代码如下：
connectionstring = "server=FRICKFANG;uid=sa;pwd=Password;database=users"
myconnection = New SqlConnection(connectionstring)
Dim strinsert As String
strinsert = "insert into userinfo1(uname,upassword,uemail) values('" + Username.Text + "','" + Password.Text + "','" + Email.Text + "')"
mycommand = New SqlCommand(strinsert, myconnection)
Dim added As Integer
Try
myconnection.Open()
added = mycommand.ExecuteNonQuery
If added > 0 Then
Response.Redirect("good.aspx")
End If
Catch err As Exception
Trace.Write(err.Message)
Finally
If (Not myconnectio
我不太会VB写的,我用C#,但是原因我也看出来了
你没有让控件获得数据渊,也没绑定啊
你应该这么写
added = mycommand.ExecuteNonQuery
this.DataSource = added
this.DataBind();
我也是是ASP.NET,要是WinForm我就不知道了
myCommand.ExecuteNonQuery()
应该可以啊！