欢迎来到天天文库
浏览记录
ID:14385772
大小:66.00 KB
页数:26页
时间:2018-07-28
《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
2、=;"{SqlCommandcmd=newSqlCommand(%%2,cn);//"SelectCount(*)Fromjobs"cn.Open();%%2=cmd.ExecuteScalar();//Message.InnerHtml}2.单值比较/*usingSystem.Data;usingSystem.Data.SqlClient;*/using(SqlConnectioncn=newSqlConnection(%%1))//ConfigurationManager.ConnectionStri
3、ngs["db2ConnectionString"].ConnectionString//"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.显示表格/*u
4、singSystem.Data;usingSystem.Data.SqlClient;*/DataSetds=null;using(SqlConnectioncn=newSqlConnection(%%1))//ConfigurationManager.ConnectionStrings["db2ConnectionString"].ConnectionString//"DataSource=127.0.0.1;InitialCatalog=myDataBase;UserId=;Password=;"{c
5、n.Open();SqlDataAdaptercmd=newSqlDataAdapter(%%2,cn);//"Select*Fromjobs"ds=newDataSet();cmd.Fill(ds,%%3);//"作者"MyDataGrid.DataSource=ds.Tables(%%3).DefaultView;//"作者"MyDataGrid.DataBind();}4.操作表格/*usingSystem.Data;usingSystem.Data.SqlClient;*/using(SqlCon
6、nectioncn=newSqlConnection(%%1))//ConfigurationManager.ConnectionStrings["db2ConnectionString"].ConnectionString//"DataSource=127.0.0.1;InitialCatalog=myDataBase;UserId=;Password=;"{cn.Open();SqlDataAdaptercmd=newSqlDataAdapter(%%2,cn);//"Select*Fromjobs"
7、ds=newDataSet();cmd.Fill(ds,%%2);//"作者"MyDataGrid.DataSource=ds.Tables(%%2).DefaultView;//"作者"MyDataGrid.DataBind();}5.数值范围查询/*usingSystem.Data;usingSystem.Data.SqlClient;*/using(SqlConnectioncn=newSqlConnection(%%1))//ConfigurationManager.ConnectionStrin
8、gs["db2ConnectionString"].ConnectionString//"DataSource=127.0.0.1;InitialCatalog=myDataBase;UserId=;Password=;"{cn.Open();intmin=Int32.Parse(jcb1.selectedItem);intmax=Int32.Parse(jcb2.selectedItem);SqlDataAdaptercmd
此文档下载收益归作者所有