2024年4月26日发(作者：)

c#连接SQL数据库的使用方法

最佳答案

1.提取单条记录

//using ;

//using ent;

using (SqlConnection cn = new SqlConnection(%%1))

//tionStrings["db2ConnectionString"].Connectio

nString

//Data Source=myServerAddress;Initial Catalog=myDataBase;User

Id=myUsername;Password=myPassword;

{

SqlCommand cmd = new SqlCommand("Select Count(*) From

jobs",cn);

();

%%2=eScalar(); //tml

}

2.单值比较

//using ;

//using ent;

using (SqlConnection cn = new SqlConnection(%%1))

//tionStrings["db2ConnectionString"].Connectio

nString

//Data Source=myServerAddress;Initial Catalog=myDataBase;User

Id=myUsername;Password=myPassword;

{

SqlCommand cmd = new SqlCommand("Select Count(*) From

jobs",cn);

();

%%2=eScalar(); //tml

if(%%2==%%3)

{

%%4

}

}

3.显示表格

//using ;

//using ent;

DataSet ds=null;

using (SqlConnection cn = new SqlConnection(%%1))

//tionStrings["db2ConnectionString"].Connectio

nString

//Data Source=myServerAddress;Initial Catalog=myDataBase;User

Id=myUsername;Password=myPassword;

{

();

cmd=new SqlDataAdapter("Select * From Author",cn);

ds=new DataSet();

(ds,%%2); //"作者"

urce=(%%2).DefaultView; //"作者"

nd();

}

4.操作表格

//using ;

//using ent;

using (SqlConnection cn = new SqlConnection(%%1))

//tionStrings["db2ConnectionString"].Connectio

nString

//Data Source=myServerAddress;Initial Catalog=myDataBase;User

Id=myUsername;Password=myPassword;

{

();

cmd=new SqlDataAdapter("Select * From Author",cn);

ds=new DataSet();

(ds,%%2); //"作者"

urce=(%%2).DefaultView; //"作者"

nd();

}

5.数值范围查询

//using ;

//using ent;

using (SqlConnection cn = new SqlConnection(%%1))

//tionStrings["db2ConnectionString"].Connectio

nString

//Data Source=myServerAddress;Initial Catalog=myDataBase;User

Id=myUsername;Password=myPassword;

{

}

6.关闭时断开连接