c#数据库操作大全

c#数据库操作大全

2009-09-29 13:15319人阅读评论(0)收藏举报

1.提取单条记录

//using System.Data;

//using System.Data.SqlClient;

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

//ConfigurationManager.ConnectionStrings["db2ConnectionString"].ConnectionString //Data Source=myServerAddress;Initial Catalog=myDataBase;User

Id=myUsername;Password=myPassword;

{

SqlCommand cmd = new SqlCommand("Select Count(*) From jobs",cn); cn.Open();

%%2=cmd.ExecuteScalar(); //Message.InnerHtml

}

2.单值比较

//using System.Data;

//using System.Data.SqlClient;

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

//ConfigurationManager.ConnectionStrings["db2ConnectionString"].ConnectionString //Data Source=myServerAddress;Initial Catalog=myDataBase;User

Id=myUsername;Password=myPassword;

{

SqlCommand cmd = new SqlCommand("Select Count(*) From jobs",cn); cn.Open();

%%2=cmd.ExecuteScalar(); //Message.InnerHtml

if(%%2==%%3)

{

%%4

}

}

3.显示表格

//using System.Data;

//using System.Data.SqlClient;

DataSet ds=null;

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

//ConfigurationManager.ConnectionStrings["db2ConnectionString"].ConnectionString //Data Source=myServerAddress;Initial Catalog=myDataBase;User

Id=myUsername;Password=myPassword;

{

cn.Open();