How to create Data Access Layer using Dataset.xsd file. [Answered]RSS

• • Reply
  prasanna.yel...

  Member

  10 Points

  44 Posts

  How to create Data Access Layer using Dataset.xsd file.

  Feb 03, 2010 06:07 AM|prasanna.yelsangikr|LINK

  Hi,

  Iam facing the problem with creating the Data Access layer using Dataset.xsd file and How to access the data from the file.
  

  
  

  <input id="gwProxy" type="hidden"><input onclick="jsCall();" id="jsProxy" type="hidden">

  <div id="refHTML"></div>
• • Reply
  prasanna.yel...

  Member

  10 Points

  44 Posts

  Re: How to create Data Access Layer using Dataset.xsd file.

  Feb 03, 2010 09:06 AM|prasanna.yelsangikr|LINK

  I solved this problem.

  Step 1: Download NorthWind Data base.

  Step2: Create Dataset.xsd file, save as ProductDataset.xsd.

  Step3: Drag & Drop the Products Table from the Server explorer.

  Put This code in Default.aspx.cs

   

  protected void Page_Load(object sender, EventArgs e)
      {
          ProductDataSetTableAdapters.ProductsTableAdapter adapter=new ProductDataSetTableAdapters.ProductsTableAdapter ();
          ProductDataSet.ProductsDataTable table = adapter.GetDataBy();
          GridView1.DataSource = table;
          GridView1.DataBind();
  
  
      }

  In Default.aspx page

  Drag & Drop GridView.

   

  This is Typed DataSet in ASP.net

   

  
  

• • Reply
  prasanna.yel...

  Member

  10 Points

  44 Posts

  Re: How to create Data Access Layer using Dataset.xsd file.

  Feb 04, 2010 11:50 AM|prasanna.yelsangikr|LINK

  How to create .xsd file from Command prompt any IDEA.

  
  

  Prasanna Y