g对数据库对象的操作可以编码实现,当然.NET提供了更加方便的可视化机制可以帮助我们省却很多麻烦。
首先,在项目中增加新项,选择Dataset数据集,如图所示:
![C#中DataSet <wbr>可视化设计使用方法 C#中DataSet <wbr>可视化设计使用方法](https://i-blog.csdnimg.cn/blog_migrate/c2a1a692f78bea73b05fdda467f84157.jpeg)
比如新建一个CustomersXSD.xsd的数据集,下面将NorthWind数据库中的Customers表拖到当前设计面板,如下如所示:
![C#中DataSet <wbr>可视化设计使用方法 C#中DataSet <wbr>可视化设计使用方法](https://i-blog.csdnimg.cn/blog_migrate/a953fd62cf543a7aa7a2076e720e3a30.jpeg)
如图所示,自动生成名为CustomersTableAdapter的Adapter对象,手动设置增加图上三个方法,
其中GetByPrimaryKey方法如图所示配置:
![C#中DataSet <wbr>可视化设计使用方法 C#中DataSet <wbr>可视化设计使用方法](https://i-blog.csdnimg.cn/blog_migrate/da70907ffbee2af3ff4f289b00ccf370.jpeg)
![C#中DataSet <wbr>可视化设计使用方法 C#中DataSet <wbr>可视化设计使用方法](https://i-blog.csdnimg.cn/blog_migrate/052b4a50e781b67f108bf67c928b9deb.jpeg)
![C#中DataSet <wbr>可视化设计使用方法 C#中DataSet <wbr>可视化设计使用方法](https://i-blog.csdnimg.cn/blog_migrate/15e65a81d46ef02f037f3a9c3adecf22.jpeg)
![C#中DataSet <wbr>可视化设计使用方法 C#中DataSet <wbr>可视化设计使用方法](https://i-blog.csdnimg.cn/blog_migrate/7f2254c1be4e98cf20750da500a493cc.jpeg)
下面代码演示如何使用CustomerXSD, CustomersTableAdapter来实现对数据表Customers增加一条记录:
首先假设代码中已经生成了表Customer对象类CustomersModel,代码如下:注意加红的部分
using Model;//数据库实体类Model
using CustomersXSDTableAdapters;//引入Adapter命名空间
public class CustomersDAL
{
private CustomersTableAdapter _CustomersTableAdapter = null;
protected CustomersTableAdapter Adapter
{
get
{
if (_CustomersTableAdapter == null)
_CustomersTableAdapter = new CustomersTableAdapter();
return _CustomersTableAdapter;
}
}
//Get方法,得到表中所有的数据
public DataTable Get()
{
return Adapter.GetData();
}
// 根据主键得到数据表
public DataTable GetByPrimaryKey(String CustomerID)
{
return Adapter.GetByPrimaryKey(CustomerID);
}
//增加一条记录
public bool Add(CustomersModel model)
{
CustomersXSD.CustomersDataTable TargetTable = new CustomersXSD.CustomersDataTable();
CustomersXSD.CustomersRow TargetRow = TargetTable.NewCustomersRow();
TargetRow.CustomerID = model.CustomerID;
TargetRow.CompanyName = model.CompanyName;
TargetRow.ContactName = model.ContactName;
TargetRow.ContactTitle = model.ContactTitle;
TargetRow.Address = model.Address;
TargetRow.City = model.City;
TargetRow.Region = model.Region;
TargetRow.PostalCode = model.PostalCode;
TargetRow.Country = model.Country;
TargetRow.Phone = model.Phone;
TargetRow.Fax = model.Fax;
TargetTable.AddCustomersRow(TargetRow);
int rowaffected = Adapter.Update(TargetTable);
return rowaffected == 1;
}
//更新一条记录
public bool Update(CustomersModel model)
{
CustomersXSD.CustomersDataTable TargetTable = Adapter.GetByPrimaryKey(model.CustomerID);
if (TargetTable.Count == 0)
return false;
CustomersXSD.CustomersRow TargetRow = TargetTable[0];
TargetRow.CustomerID = model.CustomerID;
TargetRow.CompanyName = model.CompanyName;
TargetRow.ContactName = model.ContactName;
TargetRow.ContactTitle = model.ContactTitle;
TargetRow.Address = model.Address;
TargetRow.City = model.City;
TargetRow.Region = model.Region;
TargetRow.PostalCode = model.PostalCode;
TargetRow.Country = model.Country;
TargetRow.Phone = model.Phone;
TargetRow.Fax = model.Fax;
int rowsaffected = Adapter.Update(TargetRow);
return rowsaffected == 1;
}
//删除一条记录
public bool Delete(String CustomerID)
{
int rowsaffected = Adapter.DeleteByCustomerID(CustomerID);
return rowsaffected == 1;
}
}