更新&中的错误删除 [英] Error in update & Delete

问题描述

你好朋友，
我正在使用数据集页面dataset.xsd.在其中，我有一个名为asp3的表，每当我尝试通过DataSet1TableAdapters.asp31TableAdapter类将数据插入表中时，都会插入数据，但是如果我尝试更新或删除数据，则会出现错误.我的代码是:

Hello freinds,
I am using a dataset page dataset.xsd. In it i am having a table named asp3, Whenever i am trying to insert the data in the table through DataSet1TableAdapters.asp31TableAdapter class, data is inserted but if i am trying to update or delete the data it is giving an error. My code is :

 protected void insrt_btn_Click(object sender, EventArgs e)
        {
            int emp_id = int.Parse(id_txtbx.Text);
            int sal = int.Parse(sal_txtbx.Text);
            DataSet1TableAdapters.asp31TableAdapter da3 = new DataSet1TableAdapters.asp31TableAdapter();
            da3.Insert(emp_id, name_txtbx.Text, sal);
            GridView2.DataSource = da3.GetData();
            GridView2.DataBind();
        }

        protected void updt_btn_Click(object sender, EventArgs e)
        {
            int emp_id = int.Parse(id_txtbx.Text);
            int sal = int.Parse(sal_txtbx.Text);
            DataSet1TableAdapters.asp31TableAdapter da3 = new DataSet1TableAdapters.asp31TableAdapter();
            da3.Update(emp_id, name_txtbx.Text, sal);
            GridView2.DataSource = da3.GetData();
            GridView2.DataBind();
        }

        protected void dlt_btn_Click(object sender, EventArgs e)
        {
            int emp_id = int.Parse(id_txtbx.Text);
            int sal = int.Parse(sal_txtbx.Text);
            DataSet1TableAdapters.asp31TableAdapter da3 = new DataSet1TableAdapters.asp31TableAdapter();
            da3.Delete(emp_id);
            GridView2.DataSource = da3.GetData();
            GridView2.DataBind();
        }
    }
}

粗线显示错误.

The bold lines are giving error.

Error	2	'DAL_BLL.DataSet1TableAdapters.asp31TableAdapter' does not contain a definition for 'Delete' and no extension method 'Delete' accepting a first argument of type 'DAL_BLL.DataSet1TableAdapters.asp31TableAdapter' could be found (are you missing a using directive or an assembly reference?)	C:\Users\KANHA\Documents\Visual Studio 2010\Projects\DAL BLL\DAL BLL\WebForm1.aspx.cs	63	17	DAL BLL (dataset)

Error	1	No overload for method 'Update' takes 3 arguments	C:\Users\KANHA\Documents\Visual Studio 2010\Projects\DAL BLL\DAL BLL\WebForm1.aspx.cs	53	13	DAL BLL (dataset)

提前感谢

问候，
Rakesh Sharma

Thanx in advance

With regards,
Rakesh Sharma

推荐答案

检查您的asp31TableAdapter 是否具有与您的需求相匹配的UpdateCommand 和DeleteCommand ，并尝试执行它们.从设计器中查询以确保其正常运行，然后重新构建应用程序
最好的问候
M.Mitwalli

Hi ,
Check your asp31TableAdapter if it has UpdateCommand and DeleteCommand match to your need and try to execute them Query from the Designer to make sure it works fine then rebuild your application
Best Regards
M.Mitwalli

要使用表适配器进行更新和删除，您需要为tableadapter设置更新命令和删除命令

请参考以下URL设置更新命令和删除命令
1 [ http://msdn.microsoft.com/en-us/library/ms171933％28v = vs.80％29.aspx [ ^ ]

to update and delete using table adapters you need to set update command and delete command for tableadapter

Refer following URL to set update command and delete command
1[^]

http://msdn.microsoft.com/en-us/library/ms171933%28v=vs.80%29.aspx[^]

您可以使用此

为了读取数据，我们使用状态表，函数为

You can use this

For reading data we use state table and function is

//for read data 
 public void readstate()
        {
            //Insert
            dataAdState.SelectCommand = new SqlCommand("select * from state_master", con);
           
            dataAdState.InsertCommand = new SqlCommand("insert into state_master(state_id,state_name) values(@state_id,@state_name)", con);
            dataAdState.InsertCommand.Parameters.Add("@state_name", SqlDbType.Text).SourceColumn="state_name";
            dataAdState.InsertCommand.Parameters.Add("@state_id", SqlDbType.Int).SourceColumn = "state_id";
            //Update
            dataAdState.UpdateCommand = new SqlCommand("update state_master set state_name=@state_name where state_id=@state_id",con);
            dataAdState.UpdateCommand.Parameters.Add("@state_name", SqlDbType.Text).SourceColumn = "state_name";
            dataAdState.UpdateCommand.Parameters.Add("@state_id", SqlDbType.Int).SourceColumn = "state_id";
//Delete
            dataAd.DeleteCommand = new SqlCommand("delete from state_master where state_id=@state_id");
            dataAdState.DeleteCommand.Parameters.Add("@state_id", SqlDbType.Int).SourceColumn = "state_id";
            dataAdState.Fill(dataset, "State");
            dataset.Tables["State"].PrimaryKey = new DataColumn[] { dataset.Tables["State"].Columns["state_id"] };
        }

并用于更新数据.

And this for update data.

public void updateState(int state_id, string name)
       {

           dataset.Tables["State"].PrimaryKey = new DataColumn[] { dataset.Tables["State"].Columns["state_id"] };

           DataRow row = dataset.Tables["State"].Rows.Find(state_id);

           row["state_name"] = name;

           DataTable d = dataset.Tables["State"].GetChanges(DataRowState.Modified);
           dataAdState.Update(d);
       }

与删除相同

same for delete

这篇关于更新&中的错误删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！