level 1
jageme
楼主
Dim sqlcon As New SqlConnection()
Dim constr As String
Dim table1 As Data.DataRow
Dim dr As DataRow
constr = "user id=sa;password=sa;initial catalog=zxgl;data source=(local)"
sqlcon.ConnectionString = constr
sqlcon.Open()
Dim sqlcom As New SqlCommand
sqlcom.CommandText = "select * from wangguan where id='" & Label8.Text & "'"
sqlcom.Connection = sqlcon
Dim myds As New DataSet
Dim myadapter As New SqlDataAdapter
myadapter.SelectCommand = sqlcom
myadapter.Fill(myds, "wangguan")
dr = myds.Tables("wangguan").Rows(0)
dr.Item(1) = TextBox1.Text
'这里修改数据库表
sqlcon.Close()
请问如果我在这里修改数据表内容，应该怎么做？？？
如果是新增或删除呢？
我是新手，以前都是做ＶＢ的，现在改做VB.NET了，但做的时候才发现原来差别太大了，，
2011年09月07日 10点09分
1
Dim constr As String
Dim table1 As Data.DataRow
Dim dr As DataRow
constr = "user id=sa;password=sa;initial catalog=zxgl;data source=(local)"
sqlcon.ConnectionString = constr
sqlcon.Open()
Dim sqlcom As New SqlCommand
sqlcom.CommandText = "select * from wangguan where id='" & Label8.Text & "'"
sqlcom.Connection = sqlcon
Dim myds As New DataSet
Dim myadapter As New SqlDataAdapter
myadapter.SelectCommand = sqlcom
myadapter.Fill(myds, "wangguan")
dr = myds.Tables("wangguan").Rows(0)
dr.Item(1) = TextBox1.Text
'这里修改数据库表
sqlcon.Close()
请问如果我在这里修改数据表内容，应该怎么做？？？
如果是新增或删除呢？
我是新手，以前都是做ＶＢ的，现在改做VB.NET了，但做的时候才发现原来差别太大了，，
