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)
Thanx in advance
With regards,
Rakesh Sharma