c#连接SQL 数据库的使用方法 最佳答案 1.提取单条记录 //using System.Data; //using System.Data.SqlClient; using (SqlConnection cn = new SqlConnection(%%1)) //ConfigurationManager.ConnectionStrings["db2ConnectionString"].ConnectionString //Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; { SqlCommand cmd = new SqlCommand("Select Count(*) From jobs",cn); 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=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; { SqlCommand cmd = new SqlCommand("Select Count(*) From jobs",cn); 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=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; { cn.Open(); cmd=new SqlDataAdapter("Select * From Author",cn); ds=new DataSet(); cmd.Fill(ds,%%2); //"作者" MyDataGrid.DataSource=ds.Tables(%%2).DefaultView; //"作者" MyDataGrid.DataBind(); } 4.操作表格 //using System.Data; //using System.Data.SqlClient; using (SqlConnection cn = new SqlConnection(%%1)) //ConfigurationManager.ConnectionStrings["db2ConnectionString"].ConnectionString //Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; { cn.Open(); cmd=new SqlDataAdapter("Select * From Author",cn); ds=new DataSet(); cmd.Fill(ds,%%2); //"作者" MyDataGrid.DataSource=ds.Tables(%%2).DefaultView; //"作者" MyDataGrid.DataBi...
