how to update datagrid.

Question

0.00/5 (No votes)

See more:

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.

Posted 10-May-11 20:44pm

chaosgray

Add a Solution

Comments

Sandeep Mewara 11-May-11 2:59am

Until you share your code (creation/implementation of object data-source), it would be difficult to comment.

chaosgray 11-May-11 3:25am

i don't have codes sir. im just using the datasource.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sachida.Ind · Accepted Answer · 2011-05-10T21:32:00

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();
}

janwel · Accepted Answer · 2011-05-10T22:17:00

Solution 2

on your page load

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

Then follow the above codes for manipulating gridview

Posted 10-May-11 22:17pm

janwel

Comments

chaosgray 11-May-11 4:18am

thank you sir.

you are the great one!

janwel 11-May-11 4:18am

did you understand my instruction ?

chaosgray 11-May-11 4:19am

a bit.

janwel 11-May-11 4:20am

mark solved if finish