SQL数据库未通过datagridview的vb.net命令进行更新 [英] SQL database not getting updated by vb.net command from datagridview
问题描述
我使用以下命令从datagridview更新sql数据库,但数据库未更新。他们没有错。请帮助..提前感谢
昏暗更新为新SqlCommand(更新FAGR SET FAGRN = @ FAGRN,FAGRU = @ FAGRU WHERE FAGRC = @ FAGRC,连接)
update.Parameters.Add(New SqlParameter(@ FAGRC,SqlDbType.NChar,3))
update.Parameters。添加(New SqlParameter(@ FAGRN,SqlDbType.NVarChar,50))
update.Parameters.Add(New SqlParameter(@ FAGRU,SqlDbType.NChar,3))
Dim i As Integer
i = 0
Do while i< DataGridView1.Rows.Count
尝试
update.Parameters(0).Value = DataGridView1.Rows(i).Cells(0).ToString
update.Parameters(1).Value = DataGridView1.Rows(i).Cells(1).ToString
update.Parameters(2).Value = DataGridView1.Rows(i).Cells( 2).ToString
vartemp1 = update.ExecuteNonQuery()
Catch ex As Exception
MsgBox(例外:&vbCrLf&ex.Message
最后
Me.Close()
结束尝试
循环
I am using following command to update sql database from datagridview but the database is not updated. and their is no error. pls help.. thanks in advance
Dim update As New SqlCommand("Update FAGR SET FAGRN=@FAGRN,FAGRU=@FAGRU WHERE FAGRC=@FAGRC", connection)
update.Parameters.Add(New SqlParameter("@FAGRC", SqlDbType.NChar, 3))
update.Parameters.Add(New SqlParameter("@FAGRN", SqlDbType.NVarChar, 50))
update.Parameters.Add(New SqlParameter("@FAGRU", SqlDbType.NChar, 3))
Dim i As Integer
i = 0
Do While i < DataGridView1.Rows.Count
Try
update.Parameters(0).Value = DataGridView1.Rows(i).Cells(0).ToString
update.Parameters(1).Value = DataGridView1.Rows(i).Cells(1).ToString
update.Parameters(2).Value = DataGridView1.Rows(i).Cells(2).ToString
vartemp1 = update.ExecuteNonQuery()
Catch ex As Exception
MsgBox("Exception:" & vbCrLf & ex.Message)
Finally
Me.Close()
End Try
Loop
推荐答案
尝试更改设置参数值的行:
Try changing the lines where you set the parameter values from:
update.Parameters(0).Value = DataGridView1.Rows(i).Cells(0).ToString
到
to
update.Parameters(0).Value = DataGridView1.Item(i, 0).Value.ToString
或
or
update.Parameters(0).Value = DataGridView1.Rows(i).Cells(0).Value.ToString
问候,
Johan
Regards,
Johan
这篇关于SQL数据库未通过datagridview的vb.net命令进行更新的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!