Dim index As Integer
Dim oRow As DataRow
For index = 0 To 1
oRow = oDS.Tables("cust").NewRow
oRow.Item("account") = TextBox1.Text
oRow.Item("custtype") = TextBox2.Text
oDS.Tables("cust").Rows.Add(oRow)
Next
MyConn.Open()
Try
MySda.Update(oDS, "cust")
Response.Write("<script language=javascript>alert('插入记录成功!!!')</SCRIPT>")
Catch Exp As SqlClient.SqlException
If Exp.Number = 2627 Then
Response.Write("<script language=javascript>alert('您插入的记录已经存在!!!')</SCRIPT>")
Else
Response.Write("<script language=javascript>alert('没有插入记录!!!')</SCRIPT>")
End If
End Try
描述:
对数据库操作的时候,有时候需要多条数据的操作,使用sql语句消耗资源大
解决办法:
举例如下
Dim myDataAdapter As New SqlClient.SqlDataAdapter()
myDataAdapter.SelectCommand = New SqlClient.SqlCommand("select * from 表 where 条件", DeviceConnection)
Dim custCB As SqlClient.SqlCommandBuilder = New SqlClient.SqlCommandBuilder(myDataAdapter)
DeviceConnection.Open()
Dim custDS As DataSet = New DataSet()
Dim dr As DataRow
myDataAdapter.Fill(custDS, "设备备件关系表")
'更改dataset的datatable的datarow
dr = custDS.Tables("设备_备件关系表").NewRow
'你可以在此添加数据
custDS.Tables("设备_备件关系表").Rows.Add(dr)
myDataAdapter.Update(custDS, "设备备件关系表")
'更新所作的修改
DeviceConnection.Close()