c#数据库操作大全 sql operator

1.提取单条记录
/*
using System.Data;
using System.Data.SqlClient;
*/
 using (SqlConnection cn = new SqlConnection(%%1))
//ConfigurationManager.ConnectionStrings["db2ConnectionString"].ConnectionString
//"Data Source=127.0.0.1;Initial Catalog=myDataBase;User Id=;Password=;"
      {
          SqlCommand cmd = new SqlCommand(%%2,cn); //"Select Count(*) From jobs"
          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=127.0.0.1;Initial Catalog=myDataBase;User Id=;Password=;"
      {
          SqlCommand cmd = new SqlCommand(%%2,cn); //"Select Count(*) From jobs"
          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=127.0.0.1;Initial Catalog=myDataBase;User Id=;Password=;"
      {
          cn.Open();
SqlDataAdapter cmd=new SqlDataAdapter(%%2,cn); //"Select * From jobs"
ds=new DataSet();
cmd.Fill(ds,%%3); //"作者"
MyDataGrid.DataSource=ds.Tables(%%3).DefaultView; //"作者"
MyDataGrid.DataBind();
      }

4.操作表格
/*
using System.Data;
using System.Data.SqlClient;
*/
using (SqlConnection cn = new SqlConnection(%%1))
//ConfigurationManager.ConnectionStrings["db2ConnectionString"].ConnectionString
//"Data Source=127.0.0.1;Initial Catalog=myDataBase;User Id=;Password=;"
      {
          cn.Open();