有3个需要循环更新的字段分别是 jd1 jd2 jd3希望在vs2005的gridview中循环更新
我的思路非常混乱.希望强人给全部代码.(要VB的)我的混乱代码如下.
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim constr As String = "data source=10.61.224.1;user id=sa;password=sa;database=ZKJRL ;Asynchronous Processing=true"
Dim sqlstr As String = "SELECT * FROM [HTCPSGTZD_JRLJDQKB2] "
Dim objconn As New System.Data.SqlClient.SqlConnection(constr)
Dim objAdapter As New System.Data.SqlClient.SqlDataAdapter(sqlstr, objconn)
Dim objdataset As New System.Data.DataSet objAdapter.Fill(objdataset, "HTCPSGTZD_JRLJDQKB2")
Dim textbox13 As String = "" Dim i As Integer
Dim jd1 As String = Trim(textbox13) 'GridView1.Rows(i).FindControl("textbox13")
For i = 0 To objdataset.Tables("jd1").Rows.Count() - 1 objdataset.Tables("HTCPSGTZD_JRLJDQKB2").Rows(i)("jd1") = jd1 Dim dd As New System.Data.SqlClient.SqlCommandBuilder(objAdapter)
objAdapter.Update(objdataset, "HTCPSGTZD_JRLJDQKB2")
Next
objconn.Close()
End Sub
我的思路非常混乱.希望强人给全部代码.(要VB的)我的混乱代码如下.
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim constr As String = "data source=10.61.224.1;user id=sa;password=sa;database=ZKJRL ;Asynchronous Processing=true"
Dim sqlstr As String = "SELECT * FROM [HTCPSGTZD_JRLJDQKB2] "
Dim objconn As New System.Data.SqlClient.SqlConnection(constr)
Dim objAdapter As New System.Data.SqlClient.SqlDataAdapter(sqlstr, objconn)
Dim objdataset As New System.Data.DataSet objAdapter.Fill(objdataset, "HTCPSGTZD_JRLJDQKB2")
Dim textbox13 As String = "" Dim i As Integer
Dim jd1 As String = Trim(textbox13) 'GridView1.Rows(i).FindControl("textbox13")
For i = 0 To objdataset.Tables("jd1").Rows.Count() - 1 objdataset.Tables("HTCPSGTZD_JRLJDQKB2").Rows(i)("jd1") = jd1 Dim dd As New System.Data.SqlClient.SqlCommandBuilder(objAdapter)
objAdapter.Update(objdataset, "HTCPSGTZD_JRLJDQKB2")
Next
objconn.Close()
End Sub
解决方案 »
- 怎么实现转播微博功能
- asp.net 和javascript 问题
- RenderControl的Excel导出后看不懂
- 有关ActiveX控件制作条形码打印
- javascript读取XML文件
- 我的网站放在租用的空间上,访问速度很慢
- img 能响应鼠标事件吗?
- 怎么样让绑定数据产生的RadioButtonList在page_load时有一个item被自动选择?
- **请教高手*** 如何可以让自定义控件拖入页面后,其它的标准控件可以拖到标准控件里面
- 如何向DataSet的具体表的具体行的具体列赋值和取值?
- 关于动态生成一个xml文件的疑问
- 请问GridView中有像DataList那样的每行间隔模板么?
{
objdataset.Tables[0].Rows[i]["jd1"] = jd1;
????
}
{
objdataset.Tables[0].Rows[i]["jd1"] = jd1;
objdataset.Tables[0].Rows[i]["jd2"] = jd2;
objdataset.Tables[0].Rows[i]["jd3"] = jd3;
}
大概就是这样了!
不是要用循环语句吗?
我不会写.而且怎么写更新我也不会.反正就是要VB的详细代码.140分相送.
System.Data.SqlClient.SqlCommandBuilder cb = new System.Data.SqlClient.SqlCommandBuilder(objAdapter);
objAdapter.Update(objdataset);
mytxt.text = "xxxxxx"Nextps:gridview按業顯示,例:有3頁,你就必須 點3次按鈕去update gridview
诸如 Dim sqlstr As String = "SELECT * FROM [HTCPSGTZD_JRLJDQKB2] "
Dim objconn As New System.Data.SqlClient.SqlConnection(constr)
这类的声明怎么写也来点详细的,我很苯的,不会举一反三.
vb不会
用批量更新:先对datatable更新完了再objAdapter.Update(objdataset, "HTCPSGTZD_JRLJDQKB2")更新到数据库
別人只能給你一個思路而已..
Dim str As String
Dim StrSource As String
Dim Rs As ADODB.Recordset
Dim I As Long
str = TextBox1.Text
Rs = New ADODB.Recordset
StrSource = "select * from HTCPSGTZD_JRLJDQKB2 where jdrq = '" & str & "' "
'=====================
'注意打开方式为,静态、成批
Rs.Open(StrSource, constr, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockBatchOptimistic)
'=====================
If Rs.RecordCount > 0 Then
Rs.MoveFirst()
Do While Rs.EOF = False
For I = 0 To Rs.Fields.Count - 1
If Not System.Data.DataRow.IsNull(Rs.Fields(I).Value) Then '判断是否为NULL
If TypeName(Rs.Fields(I).Value) = "String" Then '判断字段是否为String型
Rs.Fields(I).Value = Trim(Rs.Fields(I).Value)
End If
End If
Next I
Rs.MoveNext() '移向下一条记录
Loop
Rs.UpdateBatch(ADODB.AffectEnum.adAffectAllChapters) '一次性成批修改记录集
End If又寻思一下午,这个代码居然提示我"多步 OLE DB 操作产生错误。如果可能,请检查每个 OLE DB 状态值。没有工作被完成。"怎么回事?