更新问题 [英] Update problem

问题描述

有人请帮助我，我无法在任何地方得到答案。


我不知道我做错了什么。



当我对datagrid进行更改并单击具有以下代码的按钮时，由于某种原因它不会更新。


DataGrid1 .Update（）

SqlDataAdapter1.Update（DataSet11）


请帮忙......

解决方案

将你复制到.NET以防万一有人对这些控件有更多经验

非常感谢

aceaceace，


您的datagrid有一个名为OnUpdateCommand的属性。

它设置了单击更新按钮时运行的功能。

让我假装该函数被称为dgUpdate，意思是OnUpdateCommand =" dgUpdate。"


你必须设置一个叫做gdUpdate的子：

Sub dgUpdat e（ByVal source As Object，ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs）

...

在此处插入代码

...

结束子


您必须将更新代码放入该区块。

我这样做：

Sub dgUpdate（ByVal source As Object，ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs）

Dim Param1 As String = Trim（e.Item .Cells（1）.Text.ToString（））''对于文本

Dim Param2 As String =" 2" ''硬编码

Dim Param 3 As String = Trim（CType（e.Item.FindControl（" txtBoxID"），TextBox）.Text）''用于文本框

Dim sSqlStr As String

Dim sSqlConnection As SqlConnection

Dim cSqlCommand As SqlCommand

sSqlStr =" EXEC dbo.uspUpdate" &安培; _

" @参数1 =" &安培; Param1& _

"，@ param2 =''" &安培; Param2& "" &安培; _

"，@ param3 =''" &安培; Param3& "''"


sSqlConnection =新的SqlConnection（ConfigurationSettings.AppSettings（" C onnStr））

cSqlCommand =新的SqlCommand（sSqlStr，sSqlConnection） ）

sSqlConnection.Open（）

cSqlCommand.ExecuteNonQuery（）

sSqlConnection.Close（）

End Sub

Someone please help me and I can''t get an answer anywhere.

I don''t know what I''m doing wrong.


When I make a change to the datagrid and click the button that has the following code it doesn''t update for some reason.

DataGrid1.Update()
SqlDataAdapter1.Update(DataSet11)


Please help...

解决方案

Copied you to .NET just in case someone there has more experience with these controls

Thank you very much

aceaceace,

Your datagrid has a property called OnUpdateCommand.
It sets up the function that will run when you click the update button.

Lets pretend that that function is called dgUpdate meaning OnUpdateCommand="dgUpdate."

You must set up a Sub called gdUpdate:

Sub dgUpdate(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs )
...
Insert Code here
...
End Sub

You must place your update code into that block.
I do it this way:
Sub dgUpdate(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs )

Dim Param1 As String = Trim(e.Item.Cells(1).Text.ToString()) ''For text
Dim Param2 As String = "2" ''hard coded
Dim Param 3 As String = Trim(CType(e.Item.FindControl("txtBoxID"), TextBox).Text) ''for text boxes
Dim sSqlStr As String
Dim sSqlConnection As SqlConnection
Dim cSqlCommand As SqlCommand
sSqlStr = "EXEC dbo.uspUpdate " & _
" @param1=" & Param1 & _
",@param2=''" & Param2 & "''" & _
",@param3=''" & Param3 & "''"

sSqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("C onnStr"))
cSqlCommand = New SqlCommand(sSqlStr, sSqlConnection)
sSqlConnection.Open()
cSqlCommand.ExecuteNonQuery()
sSqlConnection.Close()
End Sub

这篇关于更新问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！