Click here to Skip to main content
16,016,744 members
Please Sign up or sign in to vote.
2.00/5 (4 votes)
See more:
Where is there error I did not find.

Data is not submitted to database.
C#
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

namespace Personal_Dataset
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        SqlConnection cn;
        
         
        protected void Page_Load(object sender, EventArgs e)
        {

            cn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PragnyaConnectionString"].ConnectionString);
            cn.Open();
            if (!IsPostBack)
            {
                bind();
            }


        }

        public void bind()
        {
            PersonalDataset dataset = new  PersonalDataset();
            PersonalDataset.PersonalDetailDataTable ds = new PersonalDataset.PersonalDetailDataTable();
            SqlDataAdapter da = new SqlDataAdapter("select  * from PersonalDetails",cn);
            da.Fill(dataset, "PersonalDetail");
             //Bind data to gridView
            grid1.DataSource = dataset.Tables ["PersonalDetail"];
            grid1.DataBind();
        }

        public void fillds()
        {
            PersonalDataset dataset = new PersonalDataset();
            SqlDataAdapter da = new SqlDataAdapter("select  * from PersonalDetails", cn);
            da.Fill(dataset, "PersonalDetails");
        }

        protected void grid1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            grid1.EditIndex = -1;
            bind();
        }

        protected void grid1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        { 
        }

        protected void grid1_RowEditing(object sender, GridViewEditEventArgs e)
        {
            grid1.EditIndex = e.NewEditIndex;
            bind();
        }

        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();
            if (dataset.HasChanges())
            {
                SqlDataAdapter data_adapter = new SqlDataAdapter();
                data_adapter.TableMappings.Add("Table", "PersonalDetail");

                SqlCommandBuilder command_builder = new SqlCommandBuilder(data_adapter);

                da.Update(dataset.Tables["PersonalDetail"]);

            }
            //PersonalDataset dataset1 = new PersonalDataset();
            //dataset1.Merge(dataset);
            //dataset.AcceptChanges();
            //dataset.PersonalDetail.AcceptChanges();
            //da.Update(dataset.Tables["PersonalDetail"]);
          
               //DataRow[] PersaldetailRow = dataset.Tables["PersonalDetail"].Select("PersonID= '" + Convert.ToInt16(personalid.Text) + "'");
            //PersaldetailRow[0]["Name"] = PName.Text;
            //PersaldetailRow[0]["City"] = City.Text;
            //PersaldetailRow[0]["Salary"] = Salary.Text;
            //dataset.Tables["PersonalDetail"].AcceptChanges();
            //da.Update(dataset.Tables ["PersonalDetail"] );
             
           
           
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            PersonalDataset dataset = new PersonalDataset();
            SqlDataAdapter da = new SqlDataAdapter();
            // Fill the dataset from DB
         string    sq = "select sum(salary)  from PersonalDetails ";
            da = new SqlDataAdapter(sq, cn);
            da.Fill(dataset);
        }
    }
}


data are not stored in database
Posted
Updated 6-Aug-12 5:05am
v4
Comments
Sergey Alexandrovich Kryukov 19-Nov-11 0:47am    
What's the problem?
--SA

Instead of
da. Update(dataset.Tables["PersonalDetail"]);
Try this,
data_Adapter.Update(dataset.Tables["PersonalDetail"]);
 
Share this answer
 
i think u missed that command object
i.e-execute scalar ,execute reader,execute nonquery, find the suitale one and place it.

hope it ll work
 
Share this answer
 

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