GridView取到e.RowIndex行当前行数据(RowUpdating)再绑定数据

今天改程序遇到取GridView当前行数据，是要在GridView1_RowUpdating才能取到e.RowIndex行的对象。

 1 Protected Sub GridView1_RowUpdating(sender As Object, e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView1.RowUpdating
 2         Dim cbDealWith As CheckBox = CType(Me.GridView1.Rows(e.RowIndex).FindControl("cbDealWith"), CheckBox)
 3         Dim txtStrAssetID As TextBox = CType(Me.GridView1.Rows(e.RowIndex).FindControl("txtStrAssetID"), TextBox)
 4         Dim txtRemark As TextBox = CType(Me.GridView1.Rows(e.RowIndex).FindControl("txtRemark"), TextBox)
 5         Dim txtsubmitTime As TextBox = CType(Me.GridView1.Rows(e.RowIndex).FindControl("txtsubmitTime"), TextBox)
 6 
 7         If Not cbDealWith Is Nothing Then
 8             Dim sql As New SqlDataSource
 9             sql.ConnectionString = Me.sds1.ConnectionString
10             sql.SelectCommand = String.Format(" SELECT *  FROM [Windows64bitInstalled] where strAssetID='" + txtStrAssetID.Text.Trim + "'")
11             sql.DataSourceMode = SqlDataSourceMode.DataSet
12             Dim dv As Data.DataView = sql.Select(DataSourceSelectArguments.Empty)
13             If Not dv Is Nothing AndAlso dv.Count > 0 Then
14                 Dim sql_i As String = "UPDATE [Windows64bitInstalled] SET DealWith = '" + cbDealWith.Checked.ToString + "' , Remark ='" + txtRemark.Text + "' ,submitTime ='" + Date.Now.ToString() + "'  WHERE (strAssetID = '" + txtStrAssetID.Text + "')"
15                 SQLTools.RunQuery_Server03(sql_i)
16             Else
17             End If
18         End If
19     End Sub

SQLHelper:

 1 Public Shared Function RunQuery_Server03(ByVal QueryString As String) As DataSet
 2 
 3         Dim DBConnection As System.Data.SqlClient.SqlConnection
 4         DBConnection = New System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("webConnectionString").ToString)
 5         DBConnection.Open()
 6         Dim DBAdapter As SqlDataAdapter
 7         Dim ResultsDataSet As DataSet = New DataSet
 8 
 9         Try
10             DBAdapter = New SqlDataAdapter(QueryString, DBConnection)
11             DBAdapter.Fill(ResultsDataSet)
12             DBConnection.Close()
13 
14         Catch ex As Exception
15 
16             If DBConnection.State = ConnectionState.Open Then
17                 DBConnection.Close()
18             End If
19         End Try
20         Return ResultsDataSet
21     End Function

 

posted @ 2016-03-24 13:22  iDennis  阅读(499)  评论(0)    收藏  举报