C_数据库操作大全.docVIP

1.提取单条记录 /* using System.Data; using System.Data.SqlClient; */ using (SqlConnection cn = new SqlConnection(%%1)) //ConfigurationManager.ConnectionStrings[db2ConnectionString].ConnectionString //Data Source=;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].ConnectionS