C_数据库操作大全/*
using ;
using nt;
*/
using (SqlC onn ecti on cn = new SqlC onn ecti on( %%1))
//Con figurati onMan onn ection Stri ngs["db2C onn ection Stri ng"].C onn ecti on Stri ng
//"Data Source=;l nitial Catalog=myDataBase;User Id=;Password=;"
{
SqlComma nd cmd = new SqlComma nd(%%2,cn); //"Select Cou nt(*) From jobs" cn. Ope n();
%%2=(); // nn erHtml
}
单值比较
/*
using ;
using nt;
*/
using (SqlC onnection cn = new SqlC onnection( %%1))
//Con figurati onMan onnection Stri ngs["db2C onnection Stri ng"].C onn ecti on Stri ng //"Data Source=;I nitial Catalog=myDataBase;User Id=;Password=;"
{
SqlComma nd cmd = new SqlComma nd(%%2,cn); //"Select Cou nt(*) From jobs" cn. Ope n();
%%2=(); // nn erHtml
if(%%2==%%3)
{
%%4
}
}
显示表格
/*
using ;
using nt;
*/
DataSet ds=null;
using (SqlC onnection cn = new SqlC onnection( %%1))
//Con figurati onMan onnection Stri ngs["db2C onnection Stri ng"].C onn ecti on Stri ng
//"Data Source=;I nitial Catalog=myDataBase;User Id=;Password=;"
{
cn. Ope n();
ds=new DataSet();
(ds,%%3); 〃"作者"
=(%%3).DefaultView; //" 作者”
nd();
}
操作表格
/*
using ;
using nt;
*/
using (SqlC onnection cn = new SqlC onnection( %%1))
//Con figurati onMan onnection Stri ngs["db2C onnection Stri ng"].C onn ecti on Stri ng
//"Data Source=;l nitial Catalog=myDataBase;User Id=;Password=;"
{
cn. Ope n();
SqlDataAdapter cmd=new SqlDataAdapter(%%2,c n); //"Select * From jobs"
ds=new DataSet();
(ds,%%2); 〃"作者"
=(%%2).DefaultView; //" 作者”
nd();
}
数值范围查询
/*
using ;
using nt;
*/
using (SqlC onnection cn = new SqlC onnection( %%1))
//Con figurati onMan
C 数据库操作大全 来自淘豆网www.taodocs.com转载请标明出处.