一.连接数据库
1.打开Visual Studio 2015
创建一个Windows Forms Application,命名为CustomerProject(Lab4),其布局参照下图(Id和Update、Delete是后面再次添加的)
它们所对应的属性如下
2.打开SQL Server 2014
右键Database,新建一个,命名为CustomerDB。
右键CustomerDB里的Tables,新建一个表格。
依次添加几个列,并命名为tblCustomer,如下图所示
CustomerId下方的Column Properties中的Identity Specification改为Yes,如图
3.在Visual Studio 2015创建BusinessLogicCustomer
BusinessLogicCustomer为Class Library,其类更名为BLCustomer,其代码如下
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace BusinessLogicCustomer
{
public class BLCustomer
{
public int CustomerId { get; set; }
public string CustomerName { get; set; }
public string PhoneNumber { get; set; }
public string ProductName { get; set; }
public decimal BillAmount { get; set; }
public bool Validate()
{
if (CustomerName.Length == 0)
{
throw new Exception("Customer Name is required");
}
if (PhoneNumber.Length == 0)
{
throw new Exception("Phone Name is required");
}
if (ProductName.Length == 0)
{
throw new Exception("Product Name is required");
}
if (BillAmount == 0)
{
throw new Exception("Bill Amount is required");
}
return true;
}
}
}
右键Customer里的Reference,在弹出对话框中的Projects里的Solution中添加BusinessLogicCustomer
二.数据库的增加数据
1.在Visual Studio 2015创建Dal
Dal为Class Library,其类更名为DALCustomer和CustomerDal(DALCustomer为数据实体,CustomerDal为数据关系),其代码如下
其中的Add为ADO.NET语法
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
namespace Dal
{
public