c#数据库操作大全

《c#数据库操作大全》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、C#数据库操作大全1.提取单条记录/*usingSystem.Data;usingSystem.Data.SqlClient;*/using(SqlConnectioncn=newSqlConnection(%%1))//ConfigurationManager.ConnectionStrings["db2ConnectionString"].ConnectionString//"DataSource=127.0.0.1;InitialCatalog=myDataBase;UserId=;Password=;"{SqlCommand

2、cmd=newSqlCommand(%%2,cn);//"SelectCount(*)Fromjobs"cn.Open();%%2=cmd.ExecuteScalar();//Message.InnerHtml}2.单值比较/*usingSystem.Data;usingSystem.Data.SqlClient;*/using(SqlConnectioncn=newSqlConnection(%%1))//ConfigurationManager.ConnectionStrings["db2ConnectionString"].C

3、onnectionString//"DataSource=127.0.0.1;InitialCatalog=myDataBase;UserId=;Password=;"{SqlCommandcmd=newSqlCommand(%%2,cn);//"SelectCount(*)Fromjobs"cn.Open();%%2=cmd.ExecuteScalar();//Message.InnerHtmlif(%%2==%%3){%%4}}3.显示表格/*usingSystem.Data;usingSystem.Data.SqlClient

4、;*/DataSetds=null;using(SqlConnectioncn=newSqlConnection(%%1))//ConfigurationManager.ConnectionStrings["db2ConnectionString"].ConnectionString//"DataSource=127.0.0.1;InitialCatalog=myDataBase;UserId=;Password=;"{cn.Open();SqlDataAdaptercmd=newSqlDataAdapter(%%2,cn);//"

5、Select*Fromjobs"ds=newDataSet();cmd.Fill(ds,%%3);//"作者"MyDataGrid.DataSource=ds.Tables(%%3).DefaultView;//"作者"MyDataGrid.DataBind();}4.操作表格/*usingSystem.Data;usingSystem.Data.SqlClient;*/using(SqlConnectioncn=newSqlConnection(%%1))//ConfigurationManager.ConnectionStrin

6、gs["db2ConnectionString"].ConnectionString//"DataSource=127.0.0.1;InitialCatalog=myDataBase;UserId=;Password=;"{cn.Open();SqlDataAdaptercmd=newSqlDataAdapter(%%2,cn);//"Select*Fromjobs"ds=newDataSet();cmd.Fill(ds,%%2);//"作者"MyDataGrid.DataSource=ds.Tables(%%2).DefaultV

7、iew;//"作者"MyDataGrid.DataBind();}5.数值范围查询/*usingSystem.Data;usingSystem.Data.SqlClient;*/using(SqlConnectioncn=newSqlConnection(%%1))//ConfigurationManager.ConnectionStrings["db2ConnectionString"].ConnectionString//"DataSource=127.0.0.1;InitialCatalog=myDataBase;UserId

8、=;Password=;"{cn.Open();intmin=Int32.Parse(jcb1.selectedItem);intmax=Int32.Parse(jcb2.selectedItem);SqlDataAdaptercmd