小弟用vb.net中的asp.net web 应用程序写练习,手边没有书籍,帮忙指点。
代码如下:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim ds As DataSet = New DataSet
Dim aa, bb, cc, dd, ee, ff, gg, hh As String
aa = TextBox1.Text
bb = TextBox2.Text
cc = TextBox3.Text Dim adapter As SqlDataAdapter = New SqlDataAdapter("Insert Into T_B_LPNS_tele(tele_id, tele_name , source) Values(aa, bb, cc)", myConnection)
adapter.Fill(ds, "T_B_LPNS_tele")
MyDataGrid.DataSource = ds.Tables("T_B_LPNS_tele").DefaultView
MyDataGrid.DataBind()
End Sub
要实现保存功能,不知道这句错在哪了?帮忙指点。Dim adapter As SqlDataAdapter = New SqlDataAdapter("Insert Into T_B_LPNS_tele(tele_id, tele_name , source) Values(aa, bb, cc)", myConnection)
代码如下:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim ds As DataSet = New DataSet
Dim aa, bb, cc, dd, ee, ff, gg, hh As String
aa = TextBox1.Text
bb = TextBox2.Text
cc = TextBox3.Text Dim adapter As SqlDataAdapter = New SqlDataAdapter("Insert Into T_B_LPNS_tele(tele_id, tele_name , source) Values(aa, bb, cc)", myConnection)
adapter.Fill(ds, "T_B_LPNS_tele")
MyDataGrid.DataSource = ds.Tables("T_B_LPNS_tele").DefaultView
MyDataGrid.DataBind()
End Sub
要实现保存功能,不知道这句错在哪了?帮忙指点。Dim adapter As SqlDataAdapter = New SqlDataAdapter("Insert Into T_B_LPNS_tele(tele_id, tele_name , source) Values(aa, bb, cc)", myConnection)
如果你要用insert的话应该用Command.
拿什么FILL啊,你执行的是INSERT语句啊换成COMMAND先执行插入,然后用Sqldataadaper。FILL DATASET
这里错了SqlDataAdapter("Insert Into T_B_LPNS_tele(tele_id, tele_name , source) Values('"&aa&"','"&bb&"','"&cc&")", myConnection)