Click here to Skip to main content
15,896,348 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
my typed dataset is not submitted to database .Anybody can help me. my code is as below.

C#
protected void grid1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            GridViewRow GridRow = (GridViewRow)grid1.Rows[e.RowIndex];
            LinkButton btn = (LinkButton)GridRow.FindControl("lnkEdit");
            Label personalid = (Label)GridRow.FindControl("lblpersonid");
            TextBox City = (TextBox)GridRow.FindControl("txtcity");
            TextBox Salary = (TextBox)GridRow.FindControl("txtsalary");
            TextBox PName = (TextBox)GridRow.FindControl("txtname");


            PersonalDataset dataset = new PersonalDataset();

            SqlDataAdapter da = new SqlDataAdapter("select  * from PersonalDetails", cn);
            da.Fill(dataset, "PersonalDetail");


            //PersonalDataset persondataset = new PersonalDataset();
            PersonalDataset.PersonalDetailRow personalrow = dataset.PersonalDetail.FindByPersonID(Convert.ToInt16(personalid.Text));

            personalrow.City = City.Text;
            personalrow.Name = PName.Text;
            personalrow.Salary = Convert.ToInt32(Salary.Text);
            personalrow.AcceptChanges();
            dataset.PersonalDetail.AcceptChanges();
            SqlDataAdapter data_adapter = new SqlDataAdapter();
            data_adapter.TableMappings.Add("Table", "PersonalDetail");

            SqlCommandBuilder command_builder = new SqlCommandBuilder(data_adapter);

            da.Update(dataset.Tables ["PersonalDetail"]);
}
Posted
Updated 18-Nov-11 1:07am
v2
Comments
thatraja 27-Nov-11 13:38pm    
Whats the problem? any error?

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900