gridview editing

[sandhyascs]

Hi everyone

I’m using the GridView in asp.net and populating the grid dynamically using c#.net.To edit the rows i i m using GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e).
Now if I run the application and click the “Edit” Button then the complete row is generating the textboxes to edit the data in that particular row and also the “Update” and “Cancel” buttons are generated.When I change the data in any of the textboxes in that row then how should I Update that data to the Database(Sql server) using stored procedure . and display the updated data in the grid.Plzzz provide the code for this and also Is the same thing applies to the delete button.Plzzzzz help..
i m sending my code plz tell me where is d error..

gridview.aspx

<asp:GridView ID="GridView1" AutoGenerateColumns="false" runat="server" OnRowEditing="GridView1_RowEditing"
OnRowUpdating="GridView1_RowUpdating" >
        <Columns>           
         <asp:TemplateField HeaderText="userid">
            <ItemTemplate>
              <asp:Label runat="server" ID="uid" Text='<%# DataBinder.Eval(Container.DataItem,"uid") %>'/>
            </ItemTemplate>
            <EditItemTemplate>
           <asp:TextBox runat="server" ID="Textuid" Text='<%# DataBinder.Eval(Container.DataItem,"uid") %>' EnableViewState="true" />
            </EditItemTemplate>
 
         </asp:TemplateField>
        <asp:TemplateField HeaderText="password">
            <ItemTemplate>
              <asp:Label runat="server" ID="pwd" Text='<%# DataBinder.Eval(Container.DataItem,"pwd") %>' />
            </ItemTemplate>
            <EditItemTemplate>
            <asp:TextBox runat="server" ID="txtpwd"  Text='<%# DataBinder.Eval(Container.DataItem,"pwd") %>' EnableViewState="true"/>
            </EditItemTemplate>
         </asp:TemplateField>
      <asp:TemplateField HeaderText="Action">
      <ItemTemplate>
      <asp:LinkButton ID="btnEdit" Text="Edit" runat="server" CommandName="Edit" />
     <br />
      <asp:LinkButton ID="btnDelete" Text="Delete" runat="server" CommandName="Delete" />
      </ItemTemplate>
      <EditItemTemplate>
      <asp:LinkButton ID="btnUpdate" Text="Update" runat="server" CommandName="Update"  />
      <asp:LinkButton ID="btnCancel" Text="Cancel" runat="server" CommandName="Cancel" />
      </EditItemTemplate>
      </asp:TemplateField>
  </Columns>
        </asp:GridView>

stored procedure

Editdata
 
ALTER PROCEDURE [dbo].[EditData]
 
@name as varchar(50)    ,
@password as varchar(20)
 
AS
BEGIN
 
    SET NOCOUNT ON;
update [dbo].[Login] set  [pwd]= @password where [uid]=@name
END
 

gridview.aspx.cs

public partial class gridview : System.Web.UI.Page
{
    dbconn obj = new dbconn();
    protected void Page_Load(object sender, EventArgs e)
    {
 
        bindGrid();
    }
    public static DataTable  GetAllData()
    {
        DataTable alldata=new DataTable();
        string dbcon = ConfigurationManager.AppSettings["connectioninfo"];
        SqlConnection con = new SqlConnection(dbcon);
        con.Open();
        SqlCommand cmd = new SqlCommand("GetData",con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.ExecuteNonQuery();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(alldata);
        return alldata;
    }
    protected void bindGrid()
    {
 
 
        GridView1.DataSource = GetAllData();
        GridView1.DataBind();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
 
        GridView1.EditIndex = e.NewEditIndex;
 
        bindGrid();
 
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
 
{
 TextBox uidtext = GridView1.Rows[e.RowIndex].FindControl("Textuid") as TextBox;
    TextBox pwdtext = GridView1.Rows[e.RowIndex].FindControl("txtpwd") as TextBox;
string dbcon = ConfigurationManager.AppSettings["connectioninfo"];
 
        SqlConnection con = new SqlConnection(dbcon);
        con.Open();
        SqlCommand cmd = new SqlCommand("EditData", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@name", uidtext.Text);
        cmd.Parameters.AddWithValue("@password", pwdtext.Text);
        cmd.ExecuteNonQuery();
}

we.config

public class dbconn
{
 
        public  SqlConnection  GetConnection()
        {
            SqlConnection con = default(SqlConnection);
            string connectioninfo = ConfigurationManager.AppSettings["connectionstring"];
            con = new  SqlConnection(connectioninfo);
            //if (con.State = ConnectionState.Closed)
            //    con.Open();
            return con;
 
 
 
        }
    public DataSet ExecuteDataset(string sql)
    {
        SqlConnection conn = GetConnection();
        if (conn.State== ConnectionState.Closed)
            conn.Open();
        DataSet ds=new DataSet();
 
        SqlDataAdapter da = new SqlDataAdapter(sql,conn);
        da.Fill(ds);
        return (ds);
 
 
    }
    public void ExecuteCommand(string sql)
    {
        SqlConnection con = GetConnection();
        if (con.State == ConnectionState.Closed)
            con.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.ExecuteNonQuery();
 
    }
}

[tlhintoq]

TIP: When you are writing your question, there is a button on the tool bar that wraps the [code] tags around your copy/pasted code. It helps a bunch. Its the button with a '#' on it. More on tags. They're cool. Check'em out.

[tlhintoq]

Please read the guidelines about posting a question. The use of SMS speak and unnecessary abbreviations just makes it hard to read your question. Personally when I see a bunch of this my thinking is "If it's not important enough for the poster to type the extra few characters to make a real word, then it must not be very important." But that's just me and I don't claim to have insight on how the other volunteers here think.

i m sending.......... I am sending.
Plzzzzz........ Actually longer than "Please"
where is d error............ Just makes you sound like a wannabe rapper

[Frinavale]

Do not call the bindGrid() method in your page load without checking if it ispostback = false (the first time the page is loading).

Instead, move this method to the Page PreRender event.

What's happening is that you're binding the GridView to a "new" datasource every time the page posts back to the server.

When you bind the GridView to the new datasource when you're trying to Edit something, all of the values entered by the user (during editing) will be lost....

If you moved this function call to the PreRender event instead, then the grid will be bound to the new datasource (updated datasource) after the Edit has occurred (whereas if you do this in the PageLoad event it occurs before the edit does) and everything will work nicely....

[sandhyascs]

i hve moved bindgrid method in Page_PreRender event bt the prob arising is that text boxes are containing null value instead of updated values.so update method is not having any effect.

[Frinavale]

This should not happen if you are no longer calling the DataBind method on the GridView before the Update event.

Post your updated code so that I can see what you're doing now.