Dim strSql As String = "select * from 入库任务表" Dim strCNN As String = "initial catalog=nzdb;user id=sa;password=neary" Dim myCNN As new SqlClient.SqlConnection() Dim myDA As new SqlClient.SqlDataAdapter() Dim myDS As New Data.DataSet() Dim myDRCmdBuilder As new SqlCommandBuilder()Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If Not Page.IsPostBack Then myCNN = New SqlConnection(strCNN) myDA = New SqlClient.SqlDataAdapter(strSql, myCNN) myDRCmdBuilder = New SqlCommandBuilder(myDA) With myDA .Fill(myDS, "nz") End With
With DBs2 .DataSource = myDS.Tables("nz") .DataBind() End With end if End SubPrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click myDS.Tables("nz").Rows(1)(0) = "A" + myDS.Tables("nz").Rows(0)(0) myDA.Update(myDS, "nz") With DBs2 .DataSource = myDS.Tables("nz") .DataBind() End With End Sub
Dim strSql As String = "select * from 入库任务表" Dim strCNN As String = "initial catalog=nzdb;user id=sa;password=neary" Dim myCNN As new SqlClient.SqlConnection() Dim myDA As new SqlClient.SqlDataAdapter() Dim myDS As New Data.DataSet() Dim myDRCmdBuilder As new SqlCommandBuilder()Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If Not Page.IsPostBack Then myCNN = New SqlConnection(strCNN) myDA = New SqlClient.SqlDataAdapter(strSql, myCNN) myDRCmdBuilder = New SqlCommandBuilder(myDA) With myDA .Fill(myDS, "nz") End With
With DBs2 .DataSource = myDS.Tables("nz") .DataBind() End With end if End SubPrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click myDS.Tables("nz").Rows(1)(0) = "A" + myDS.Tables("nz").Rows(0)(0) myDA.Update(myDS, "nz") With DBs2 .DataSource = myDS.Tables("nz") .DataBind() End With End Sub
Dim strSql As String = "select * from 入库任务表" Dim strCNN As String = "initial catalog=nzdb;user id=sa;password=neary" Dim myCNN As new SqlClient.SqlConnection() Dim myDA As new SqlClient.SqlDataAdapter() Dim myDS As New Data.DataSet() Dim myDRCmdBuilder As new SqlCommandBuilder()Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If Not Page.IsPostBack Then myCNN = New SqlConnection(strCNN) myDA = New SqlClient.SqlDataAdapter(strSql, myCNN) myDRCmdBuilder = New SqlCommandBuilder(myDA) With myDA .Fill(myDS, "nz") End With
With DBs2 .DataSource = myDS.Tables("nz") .DataBind() End With end if End SubPrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click myDS.Tables("nz").Rows(1)(0) = "A" + myDS.Tables("nz").Rows(0)(0) myDA.Update(myDS, "nz") With DBs2 .DataSource = myDS.Tables("nz") .DataBind() End With End Sub
Dim strCNN As String = "initial catalog=nzdb;user id=sa;password=neary"
Dim myCNN As new SqlClient.SqlConnection()
Dim myDA As new SqlClient.SqlDataAdapter()
Dim myDS As New Data.DataSet()
Dim myDRCmdBuilder As new SqlCommandBuilder()Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not Page.IsPostBack Then
myCNN = New SqlConnection(strCNN)
myDA = New SqlClient.SqlDataAdapter(strSql, myCNN) myDRCmdBuilder = New SqlCommandBuilder(myDA)
With myDA
.Fill(myDS, "nz")
End With
With DBs2
.DataSource = myDS.Tables("nz")
.DataBind()
End With
end if
End SubPrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
myDS.Tables("nz").Rows(1)(0) = "A" + myDS.Tables("nz").Rows(0)(0)
myDA.Update(myDS, "nz")
With DBs2
.DataSource = myDS.Tables("nz")
.DataBind()
End With
End Sub
Dim strCNN As String = "initial catalog=nzdb;user id=sa;password=neary"
Dim myCNN As new SqlClient.SqlConnection()
Dim myDA As new SqlClient.SqlDataAdapter()
Dim myDS As New Data.DataSet()
Dim myDRCmdBuilder As new SqlCommandBuilder()Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not Page.IsPostBack Then
myCNN = New SqlConnection(strCNN)
myDA = New SqlClient.SqlDataAdapter(strSql, myCNN) myDRCmdBuilder = New SqlCommandBuilder(myDA)
With myDA
.Fill(myDS, "nz")
End With
With DBs2
.DataSource = myDS.Tables("nz")
.DataBind()
End With
end if
End SubPrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
myDS.Tables("nz").Rows(1)(0) = "A" + myDS.Tables("nz").Rows(0)(0)
myDA.Update(myDS, "nz")
With DBs2
.DataSource = myDS.Tables("nz")
.DataBind()
End With
End Sub
Dim strCNN As String = "initial catalog=nzdb;user id=sa;password=neary"
Dim myCNN As new SqlClient.SqlConnection()
Dim myDA As new SqlClient.SqlDataAdapter()
Dim myDS As New Data.DataSet()
Dim myDRCmdBuilder As new SqlCommandBuilder()Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not Page.IsPostBack Then
myCNN = New SqlConnection(strCNN)
myDA = New SqlClient.SqlDataAdapter(strSql, myCNN) myDRCmdBuilder = New SqlCommandBuilder(myDA)
With myDA
.Fill(myDS, "nz")
End With
With DBs2
.DataSource = myDS.Tables("nz")
.DataBind()
End With
end if
End SubPrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
myDS.Tables("nz").Rows(1)(0) = "A" + myDS.Tables("nz").Rows(0)(0)
myDA.Update(myDS, "nz")
With DBs2
.DataSource = myDS.Tables("nz")
.DataBind()
End With
End Sub
是PostBack还是not postback
然后把对数据库的所有操作写成一个方法,
在需要使用的时候就调用这个方法就成了