类型化数据集探针 [英] typed dataset probelm

问题描述

我没有找到错误的地方.

数据未提交到数据库.

Where is there error I did not find.

Data is not submitted to database.

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

推荐答案

而不是
达Update(dataset.Tables ["PersonalDetail"]);
试试这个，
data_Adapter.Update(dataset.Tables ["PersonalDetail"]));

Instead of
da. Update(dataset.Tables["PersonalDetail"]);
Try this,
data_Adapter.Update(dataset.Tables["PersonalDetail"]);

我认为您错过了该命令对象
即执行标量，执行读取器，执行非查询，找到合适的代码并将其放置.

希望它能工作

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

这篇关于类型化数据集探针的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！