How to find the Datarow of a datagrid?

Hi There,
I have a datagrid with 4 columns. I need to update a row. For that, I am doing this..

DataRow[] adrEdit = dsOvertureAccounts.Tables["AllAccountConstraints"].Select("Account='"+dgAllAccountConstraints.DataKeys[e.Item.ItemIndex] + "'");

This is returning an array of datarows. But how do I find out which row to update??

Any suggestions appreciated!!
Who is Participating?
mmarinovConnect With a Mentor Commented:
Hi jackrock79,

have you tried to just call cmdUpdate.ExecuteNonQuery() method BUT not adapter.Update() method ?
it must be executed

if your datakey is a unique key, the row you need to update should always be the first one.
jackrock79Author Commented:
Unfortunately, the datakey is not unique. That is the reason I am getting array of rows for the selection criteria.
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Your datakeyfield should be unique, it really serves no purpose if it isn't.  Can you put use another unique field?
jackrock79Author Commented:
Yeah that's what I am planning to. Put a invisible column with Rowid number and make it the datakeyfield. But I have to number the RowId. I am thinking how I can automatically assign rowid number to that column. Probably shud do it in the Item databound?
Your data should be presented to the datagrid with a unique key already in place.  Even if you fumbled through what you propsed, you still are probably going to need to update the original database eventually..right?
jackrock79Author Commented:
Do you know how to dynamically add a new column with row values equal to the rows in the datagrid??
Raterus is pointing you in the right direction here.  It will help to know what your data source is (SQL Server? Access?).  If it either SQL or Access, you can have an Auto Numbering field for your unique id.  Make sure your data table also has this column and you are returning it in your Select statement.  Then in your grid, turn AutoGenerateColumns to false, and add each column manually.  If you open the Properties window for the grid, you will see a Columns property with a "..." button.  Click this for a dialog that will allow you to do this.  Add the auto num column first, and set uncheck the Visible check box.  The column will be available as a datakey and as the first Cell in a DataGridItem.Cells collection, but it will not show in the browser.  Then do your Select statement using this value and you wil always get one row in the array.

jackrock79Author Commented:
Hi John And Raterus,
This is what I did..and my dB is Sql Server 2000. It doesnt update the dB(doesnt even call the procedure)

SqlCommand cmdOverture = new SqlCommand("dbo.sp_AgentUIGetAllAccountConstraints",GetConnection("Overture").Connection);
                        cmdOverture.CommandType = CommandType.StoredProcedure;

                        adapter.SelectCommand = cmdOverture;
                        adapter.Fill(dsOvertureAccounts, "AllAccountConstraints");

                        //Session["SessionDataSetOvAccounts"]= dsOvertureAccounts;

                        DataTable dt = dsOvertureAccounts.Tables[0];
                        dt.Columns.Add(new DataColumn("Identity",Type.GetType("System.Int32")));
                        int count = dt.Columns.Count;
                        for(int i=0;i<dt.Rows.Count;i++)
                              dt.Rows[i][count-1]= i+1;
                        dgAllAccountConstraints.DataSource = dsOvertureAccounts.Tables[0];
                        Session["SessionDataSetOvAccounts"]= dsOvertureAccounts;
                        DataView ViewOvAccounts = dsOvertureAccounts.Tables[0].DefaultView;
                        Session["SessionDataViewOvAccounts"]= ViewOvAccounts;
                        //dgAccounts.DataSource = dsOverture;
                        //dgAccounts.DataMember = "AccountOverview";

And in the Update Command of the datagrid..I am doing this...

private void dgAllAccountConstraints_UpdateCommand(object source, DataGridCommandEventArgs e)
                  DataSet dsOvertureAccounts = (DataSet)Session["SessionDataSetOvAccounts"];
                  SqlCommand cmdUpdate;
                  //dsOvertureAccounts.Tables[0].TableName = "AllAccountConstraints";
                  DataRow[] adrEdit = dsOvertureAccounts.Tables[0].Select("Identity='"+dgAllAccountConstraints.DataKeys[e.Item.ItemIndex] + "'");
                  if(adrEdit.Length > 0)
                  Label lblEngine = new Label();
                  lblEngine = (Label)(e.Item.Cells[0].FindControl("lblEngine"));
                  Label lblAccount = new Label();
                  lblAccount = (Label)(e.Item.Cells[1].FindControl("lblAccount"));
                  adrEdit[0]["Account"] = lblAccount.Text;
                  Label lblConstraint = new Label();
                  lblConstraint = (Label)(e.Item.Cells[2].FindControl("lblConstraint"));
                  adrEdit[0]["Constraint"] = lblConstraint.Text;

                  TextBox txtValue = (TextBox) e.Item.Cells[3].Controls[0];
                  adrEdit[0]["Value"] = txtValue.Text;            

                  if(lblEngine.Text.ToString() =="Overture")
                        cmdUpdate = new SqlCommand("dbo.sp_AgentUIUpdateAccountConstraints", GetConnection("Overture").Connection);
                        cmdUpdate = new SqlCommand("dbo.sp_AgentUIUpdateAccountConstraints", GetConnection("Google").Connection);

                  cmdUpdate.CommandType = CommandType.StoredProcedure;

                  cmdUpdate.Parameters.Add("@Account", SqlDbType.VarChar,255,"Acccount");
                  //cmdUpdate.Parameters["@Account"].Value = lblAccount.Text;
                  //cmdUpdate.Parameters["@Constraint"].Value = lblConstraint.Text;

                  cmdUpdate.Parameters.Add("@Value",SqlDbType.Float, 8,"Value");
                  //cmdUpdate.Parameters["@Value"].Value = txtValue.Text;
                  adapter = new SqlDataAdapter();

                  adapter.UpdateCommand = cmdUpdate;


                              dsOvertureAccounts.Tables["AllAccountConstraints"].TableName = "AllAccountConstraints";
                              adapter.Update(dsOvertureAccounts, "AllAccountConstraints");
                              dgAllAccountConstraints.EditItemIndex = -1;

                              //dgAllAccountConstraints.DataSource = dsOvertureAccounts;                  
                              DataView ViewOvAccounts = dsOvertureAccounts.Tables["AllAccountConstraints"].DefaultView;
                              Session["SessionDataViewOvAccounts"]= ViewOvAccounts;
                              dgAllAccountConstraints.DataSource = ViewOvAccounts;
//                        catch (DBConcurrencyException ex)
//                        {
//                              string customErrorMessage;
//                              customErrorMessage = "Concurrency violation\n";
//                              customErrorMessage += ex.ToString();                  
//                        }
                        catch (Exception ex)
                              throw new Exception("Unable to update account constraints", ex);


It doesnt update the database. Can you please tell me what could be wrong??


Hi jackrock79,

can you explain the B Grade?
Please read this :

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.