gridview (refresh gridview and edit row)

[dorandoran]

I followed this link to add new record from gridview. So far it's good
but I need to modify the last piece to edit the record that I will
supply the record id.

http://asptutorials.net/ASP/gridview...dit-blank-row/


I am using stored proc to insert a new record and returning the id.
Now I can get the id in my asp.net (c$) environment. I added a label
and I was able to populated the label with the newly added record's
id.


I would like to use this new id to following code to edit. Also, my
gridview does not refresh after adding the new record
(gridview2.data bind() not doing what it supposed to).


Instead of getting empty row, i would like to get a row by record id
and put it in edit mode.

int totalrows = GridView1.Rows.Count; 
for (int r = 0; r < totalrows; r++) 
{ 
   if (GridVIew1.DataKeys[r].Values[1].ToString() == "") 
   { 
      GridVIew1.EditIndex = r; 
      break; 
   }
}
 

[tlhintoq]

Ok. Lots of statements in your post. No questions though. What part do you need help with? What error are you getting if any? What variations have you tried so far that has been close, but not quite?

[dorandoran]

I having 2 issues.

1. My datagrid is not refreshing after I insert a record.
2. I would like to open the record in edit mode that i have just inserted. I am getting the id back. (refering to last paragraph of my post). I change this line to this GridVIew1.DataK eys[r].Values[1].ToString() == id) but not working. getting error.

Here is the code

    protected void btnAddRecord_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConn"].ConnectionString);
        {
            try
            {
                string sp = "sp_AddUser";
                SqlCommand command = new SqlCommand(sp, conn);
                command.CommandType=CommandType.StoredProcedure;
                conn.Open();
                int id; 
                id =  Convert.ToInt32(command.ExecuteScalar());
                Label1.Text = Convert.ToString(id);
                GridView2.DataBind();
                int totalrows = GridView2.Rows.Count;
    int empId = Convert.ToInt32(dgEmployees.DataKeys e.RowIndex].Value);
      for (int r = 0; r < totalrows; r++)
      {
        if (GridVIew1.DataKeys[r].Values[1].ToString() == id)
         {
               GridVIew2.EditIndex = id;
               break;
        }
         }                
           }
            catch (SqlException sqlEx)
            {
                throw sqlEx;
            }
            finally
            {
                conn.Close();
                GridView2.DataBind();
            }
 
 
    }
}
 

[tlhintoq]

What error are you getting?
Is it the exception you are throwing on line 28?

[dorandoran]

no is not on line 28. the last part of the code is messed up.

[Frinavale]

What is the error?
What line does the "last part of the code" start messing up on?
How does it mess up?

[dorandoran]

Error on line 16

'System.EventAr gs' does not contain a definition for 'RowIndex'

[tlhintoq]

@dorandoran
That makes sense.
'e' is the EventArgs of the Button.Click event (line 1). From when you clicked on the btnAddRecord. A button does not have a "RowIndex" property.

You probably just grabbed the wrong variable. Who *does* have a "RowIndex"? dgEmployees maybe?

HINT: When you started typing 'e.' intellisense would have given you a list of properties that exist within 'e'. If RowIndex did not appear in that list, then it does not exist in 'e'.

[Frinavale]

Oh that's because you're in a method that handles Button Click Event..........

In that case, don't use e.RowIndex. The "e" parameter in this case is a System.EventArg s Object which does not contain information about the GridView's RowIndex. The when you are handling events that are generated by a GridView the "e" parameter is a System.Web.UI.W ebControls.Grid ViewRowEventArg s Object....which does contain this property.

To fix the problem use the GridView.Select edRow or whatever to access your row.

[dorandoran]

1. When I click on the "Add" button, I can see a record being added but gridview2 does not get refreshed.

2. I am using the code below to edit the newly added record.
when I put an 'r' for this code then the row gets added and the very first record on the grid becomes editable

GridView2.EditI ndex = r;

but GridView2.EditI ndex = id; does not do anything.

    protected void btnAddRecord_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConn"].ConnectionString);
        {
            try
            {
                string sp = "sp_AddUser";
                SqlCommand command = new SqlCommand(sp, conn);
                command.CommandType=CommandType.StoredProcedure;
                conn.Open(); 
 
                int id; 
                id =  Convert.ToInt32(command.ExecuteScalar());
                Label1.Text = Convert.ToString(id);
 
                GridView2.SelectedIndex = -1;  // NOT REFRESHING
                GridView2.DataBind();              // NOT refreshing gridview
                GridView2.SelectedIndex = -1;  // NOT WORKING
 
                int totalrows = GridView2.Rows.Count;
                Label2.Text = Convert.ToInt32(totalrows);
                for (int r = 0; r < totalrows; r++)
                {
                        GridView2.EditIndex = id;
                        break;
                }
             }
            catch (SqlException sqlEx)
            {
                throw sqlEx;
            }
            finally
            {
                conn.Close();
                GridView2.DataBind();
            }