一.WCF
1.打开visual studio (我用的vs2015),并新建一个WCF项目
2.工具->连接到数据库->更改->sql server 数据库文件
3.浏览->选择你要保存数据库文件的路径、文件名写一个你要命名的文件名(文件不存在也没事,它会自动创建)
4. 打开IService1.cs->在接口IService1中添加如下代码声明函数
[OperationContract]
void CreateTable();
[OperationContract]
string GetDataByTable();
[OperationContract]
void AddDataToTable(string x, string y);
5. 打开Service1.svc.cs->添加using指令并在里面添加代码完成IService1.cs中声明的函数
Using指令:
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
函数:
public void CreateTable()
{
string connstring1 = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\zcc9618_CSDN\blog\Web\w1\1.mdf;Integrated Security=True;Connect Timeout=30";
string commstring1 = @"CREATE TABLE StuDatabase(num CHAR(20) PRIMARY KEY,name CHAR(20));INSERT INTO StuDatabase VALUES('01','zhao');INSERT INTO StuDatabase VALUES('02','qian');INSERT INTO StuDatabase VALUES('03','sun');INSERT INTO StuDatabase VALUES('04','li');";
SqlConnection conn1 = new SqlConnection(connstring1);
try
{
conn1.Open();
SqlCommand comm1 = new SqlCommand(commstring1, conn1);
comm1.ExecuteNonQuery();
conn1.Close();
}
catch (Exception)
{
throw;
}
}
public string GetDataByTable()
{
string connstring = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\zcc9618_CSDN\blog\Web\w1\1.mdf;Integrated Security=True;Connect Timeout=30";
string message = "";
SqlConnection conn = new SqlConnection(connstring);