如何更新数据网格. [英] how to update datagrid.

问题描述

你好程序员.
我在更新数据网格中的数据时遇到问题.

我不使用任何代码.
我只是使用对象数据源在数据库中获取数据.

我的问题是，当我单击更新时，什么都没有发生.


我希望你能帮助我.
谢谢.

hello programmers.
i have a problem in updating my data in my datagrid.

i don''t use any code.
i just use object datasource to get my data on my database.

my problem is, when i clicked update, nothing happen.


i hope you can help me guys.
thank you.

推荐答案

你好，我的朋友.添加编辑命令后，请执行以下步骤:

1.)将此方法用于绑定
void BindGrid()
{
sqlDataAdapter1.Fill(dataSet1);
DataGrid1.DataSource = dataSet1;
DataGrid1.DataKeyField ="xxxID";
DataGrid1.DataBind();
}

2.)处理此事件

私有void DataGrid1_EditCommand(对象源，System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = e.Item.ItemIndex;
BindGrid();
}

3.)处理此事件

私有void DataGrid1_CancelCommand(对象源，System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = -1;
BindGrid();
}

4.)和此事件...

私有void DataGrid1_UpdateCommand(对象源，System.Web.UI.WebControls.
DataGridCommandEventArgs e)
{
//从DataGrid检索TextBox控件
TextBox txtProductName =(TextBox)e.Item.Cells [2] .Controls [0];
TextBox txtUnitPrice =(TextBox)e.Item.Cells [3] .Controls [0];

//将参数分配给SqlCommand
sqlCommand1.Parameters ["@ field1"].Value = txtField1.Text;
sqlCommand1.Parameters ["@ field2"].Value = txtField2.Text;
sqlCommand1.Parameters ["@ xxxID"].Value = DataGrid1.DataKeys [e.Item.ItemIndex];

//执行SqlCommand
sqlConnection1.Open();
sqlCommand1.ExecuteNonQuery();

//取消选择要编辑的行
DataGrid1.EditItemIndex = -1;
BindGrid();
sqlConnection1.Close();
}

Hello my friend. After having add the edit command, do this steps:

1.) make this method for binding
void BindGrid()
{
sqlDataAdapter1.Fill( dataSet1 );
DataGrid1.DataSource = dataSet1;
DataGrid1.DataKeyField = "xxxID";
DataGrid1.DataBind();
}

2.) handle this event

private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = e.Item.ItemIndex;
BindGrid();
}

3.) handle this event

private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = -1;
BindGrid();
}

4.) and this event...

private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.
DataGridCommandEventArgs e)
{
// Retrieve TextBox Controls from DataGrid
TextBox txtProductName = (TextBox)e.Item.Cells[2].Controls[0];
TextBox txtUnitPrice = (TextBox)e.Item.Cells[3].Controls[0];

// Assign Parameters to SqlCommand
sqlCommand1.Parameters["@field1"].Value= txtField1.Text;
sqlCommand1.Parameters["@field2"].Value = txtField2.Text;
sqlCommand1.Parameters["@xxxID"].Value = DataGrid1.DataKeys[ e.Item.ItemIndex ];

// Execute SqlCommand
sqlConnection1.Open();
sqlCommand1.ExecuteNonQuery();

// Deselect Row for Editing
DataGrid1.EditItemIndex = -1;
BindGrid();
sqlConnection1.Close();
}

页面加载

dim strSQL as String
Dim connection As SqlClient.SqlConnection = New SqlClient.SqlConnection("connection")     
 strSQL =   "Your Query"    
connection.Open()
Dim myCommand As SqlClient.SqlCommand = New SqlClient.SqlCommand(strSQL, connection)
GridView1.DataSource = myCommand.ExecuteReader()
GridView1.DataBind()
myCommand.Dispose()
connection.close

然后按照上述代码操作gridview

Then follow the above codes for manipulating gridview

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