How to Create Data Acces Layer Using DataSet . Xsd file

I Solved this Issue.

Below is the Code Snippet........

Typed DataSet Example Edit,Delete,Update to the DataSet.xsd file .


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Data.OleDb;
using System.Data.Odbc;
using System.Data;
using System.IO;
using System.Text;
using System.ComponentModel.Design.Serialization;


public partial class _Default : System.Web.UI.Page
{



protected void Page_Load(object sender, EventArgs e)
{


ProductDataSetTableAdapters.ProductsTableAdapter adapter=new ProductDataSetTableAdapters.ProductsTableAdapter ();
ProductDataSet.ProductsDataTable table = adapter.GetData();
GridView1.DataSource = table;
GridView1.DataBind();


}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
ProductDataSetTableAdapters.ProductsTableAdapter adapter = new ProductDataSetTableAdapters.ProductsTableAdapter();
ProductDataSet.ProductsDataTable table = adapter.GetData();

GridView1.DataSource = table;
GridView1.DataBind();


}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{

}
protected void GridView1_PageIndexChanged(object sender, EventArgs e)
{
//GridView1.PageIndex = e.NewPageIndex;
//bindGridView();

}



protected void BtnCreate_Click(object sender, EventArgs e)
{
ProductDataSetTableAdapters.ProductsTableAdapter adapter = new ProductDataSetTableAdapters.ProductsTableAdapter();
ProductDataSet.ProductsDataTable table = adapter.GetData();
//adapter.InsertProduct("a", 2, 2, "10.2", 1, 1, 100, 1, true);
adapter.InsertProduct(Convert.ToString(TextBox2.Text), Convert.ToInt32(TextBox3.Text),Convert.ToInt32(TextBox4.Text), Convert.ToString(TextBox5.Text),Convert.ToInt16(TextBox6.Text),short.Parse(TextBox7.Text), short.Parse(TextBox8.Text),short.Parse(TextBox9.Text),Convert.ToBoolean(CheckBox1.Checked));
//adapter.DeleteQuery(94);
//SqlCommand command = adapter.

GridView1.DataSource = table;
GridView1.DataBind();
}
protected void BtnCancel_Click(object sender, EventArgs e)
{
//foreach (Control c in this.Controls)

// (c as TextBox).Clear();

}


protected void On_RowEditing(object sender, GridViewEditEventArgs e)
{
LinkButton EditButton = GridView1.Rows[e.NewEditIndex].FindControl("lnkDelete") as LinkButton;
int productID = Convert.ToInt32(EditButton.CommandArgument);
ProductDataSetTableAdapters.ProductsTableAdapter adapter = new ProductDataSetTableAdapters.ProductsTableAdapter();
ProductDataSet.ProductsDataTable table = adapter.GetData();
adapter.UpdateQuery(Convert.ToString(TextBox2.Text), Convert.ToInt32(TextBox3.Text), Convert.ToInt32(TextBox4.Text), Convert.ToString(TextBox5.Text), Convert.ToInt16(TextBox6.Text), short.Parse(TextBox7.Text), short.Parse(TextBox8.Text), short.Parse(TextBox9.Text), Convert.ToBoolean(CheckBox1.Checked),productID);
GridView1.DataSource = table;
GridView1.DataBind();


}

protected void On_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
LinkButton DeleteButton = GridView1.Rows[e.RowIndex].FindControl("lnkDelete") as LinkButton;
int ProductID = Convert.ToInt32(DeleteButton.CommandArgument);
ProductDataSetTableAdapters.ProductsTableAdapter adapter = new ProductDataSetTableAdapters.ProductsTableAdapter();
ProductDataSet.ProductsDataTable table = adapter.GetData();
adapter.DeleteQuery(ProductID);
GridView1.DataSource = table;
GridView1.DataBind();


}

}



-----------------Prasanna Y

please go through this article.
http://www.asp.net/learn/data-access/tutorial-01-cs.aspx[^]