如何使用数据集创建数据访问层. XSD文件 [英] How to Create Data Acces Layer Using DataSet . Xsd file

问题描述

我在创建DataSet.Xsd时遇到问题，以及如何从DataSet.Xsd文件访问数据.

Hi,

Iam facing problem with creating DataSet.Xsd, and How to Access data from the DataSet .Xsd file.

推荐答案

请检查以下链接可能有帮助.

http://www.asp.net/learn/data-access/tutorial-01- vb.aspx [^ ]

和

http://www.asp.net/learn/data-access/#advanced [ ^ ]

谢谢

Hi,

Please check the following link might help.

http://www.asp.net/learn/data-access/tutorial-01-vb.aspx[^]

and

http://www.asp.net/learn/data-access/#advanced[^]

thanks

我解决了这个问题.

下面是代码片段........

键入数据集示例编辑，删除，更新到DataSet.xsd文件.


使用系统；
使用System.Collections.Generic;
使用System.Linq;
使用System.Web;
使用System.Web.UI;
使用System.Web.UI.WebControls;
使用System.Data.SqlClient;
使用System.Data.Sql;
使用System.Data.OleDb;
使用System.Data.Odbc;
使用System.Data;
使用System.IO;
使用System.Text;
使用System.ComponentModel.Design.Serialization;


公共局部类_Default:System.Web.UI.Page
{



受保护的void Page_Load(对象发送者，EventArgs e)
{


ProductDataSetTableAdapters.ProductsTableAdapter适配器=新的ProductDataSetTableAdapters.ProductsTableAdapter();
ProductDataSet.ProductsDataTable表= adapter.GetData();
GridView1.DataSource =表;
GridView1.DataBind();


}
受保护的void GridView1_PageIndexChanging(对象发送者，GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
ProductDataSetTableAdapters.ProductsTableAdapter适配器=新的ProductDataSetTableAdapters.ProductsTableAdapter();
ProductDataSet.ProductsDataTable表= adapter.GetData();

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


}
受保护的void GridView1_SelectedIndexChanged(对象发送者，EventArgs e)
{

}
受保护的void GridView1_PageIndexChanged(对象发送者，EventArgs e)
{
//GridView1.PageIndex = e.NewPageIndex;
//bindGridView();

}



受保护的void BtnCreate_Click(对象发送者，EventArgs e)
{
ProductDataSetTableAdapters.ProductsTableAdapter适配器=新的ProductDataSetTableAdapters.ProductsTableAdapter();
ProductDataSet.ProductsDataTable表= 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)，短.Parse(TextBox7.Text)，short.Parse(TextBox8.Text)，short.Parse(TextBox9.Text)，Convert.ToBoolean(CheckBox1.Checked));
//adapter.DeleteQuery(94);
//SqlCommand命令=适配器.

GridView1.DataSource =表;
GridView1.DataBind();
}
受保护的void BtnCancel_Click(对象发送者，EventArgs e)
{
//foreach(此控件中的控件c)

//(c作为TextBox).Clear();

}


受保护的void On_RowEditing(对象发送者，GridViewEditEventArgs e)
{
LinkBut​​ton EditButton = GridView1.Rows [e.NewEditIndex] .FindControl("lnkDelete")作为LinkBut​​ton;
int productID = Convert.ToInt32(EditButton.CommandArgument);
ProductDataSetTableAdapters.ProductsTableAdapter适配器=新的ProductDataSetTableAdapters.ProductsTableAdapter();
ProductDataSet.ProductsDataTable表= adapter.GetData();
adapter.UpdateQuery(Convert.ToString(TextBox2.Text)，Convert.ToInt32(TextBox3.Text)，Convert.ToInt32(TextBox4.Text)，Convert.ToString(TextBox5.Text)，Convert.ToInt16(TextBox6.Text)，简短.Parse(TextBox7.Text)，short.Parse(TextBox8.Text)，short.Parse(TextBox9.Text)，Convert.ToBoolean(CheckBox1.Checked)，productID);
GridView1.DataSource =表;
GridView1.DataBind();


}

受保护的void On_RowDeleting(对象发送者，GridViewDeleteEventArgs e)
{
LinkBut​​ton DeleteButton = GridView1.Rows [e.RowIndex] .FindControl("lnkDelete")作为LinkBut​​ton;
int ProductID = Convert.ToInt32(DeleteButton.CommandArgument);
ProductDataSetTableAdapters.ProductsTableAdapter适配器=新的ProductDataSetTableAdapters.ProductsTableAdapter();
ProductDataSet.ProductsDataTable表= adapter.GetData();
adapter.DeleteQuery(ProductID);
GridView1.DataSource =表;
GridView1.DataBind();


}

}



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

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

请仔细阅读本文.
http://www.asp.net/learn/data-access/tutorial-01- cs.aspx [^ ]

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

这篇关于如何使用数据集创建数据访问层. XSD文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！