c#连接SQL数据库的使用方法

c#连接SQL数据库的使用方法

最佳答案

1.提取单条记录

//using System.Data;

//using System.Data.SqlClient;

using (SqlConnection cn = new SqlConnection(%%1))

//ConfigurationManager.ConnectionStrings["db2ConnectionString"].Connectio nString

//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"].Connectio nString

//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"].Connectio nString

//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"].Connectio nString

//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();

}

5.数值范围查询

//using System.Data;

//using System.Data.SqlClient;

using (SqlConnection cn = new SqlConnection(%%1))

//ConfigurationManager.ConnectionStrings["db2ConnectionString"].Connectio nString

//Data Source=myServerAddress;Initial Catalog=myDataBase;User

Id=myUsername;Password=myPassword;

{

}

6.关闭时断开连接

//using System.Data;

//using System.Data.SqlClient;

using (SqlConnection cn = new SqlConnection(%%1))

//ConfigurationManager.ConnectionStrings["db2ConnectionString"].Connectio nString

//Data Source=myServerAddress;Initial Catalog=myDataBase;User

Id=myUsername;Password=myPassword;

{

}

7.执行命令

//using System.Data;

//using System.Data.SqlClient;

using (SqlConnection cn = new SqlConnection(%%1))

//ConfigurationManager.ConnectionStrings["db2ConnectionString"].Connectio nString

//Data Source=myServerAddress;Initial Catalog=myDataBase;User

Id=myUsername;Password=myPassword;

{

SqlCommand cmd = new SqlCommand("insert userRegister_t values('"

+ TextBox1.Text + "','" + TextBox2.Text + "')",cn);

cn.Open();

cmd.ExecuteNonQuery();

}

7.Oracle8/8i/9i数据库（thin模式）

//using System.Data;

Oracle Set Your custom connection strings values

ODBC

New version

Driver={Microsoft ODBC for

Oracle};Server=myServerAddress;Uid=myUsername;Pwd=myPassword;

Old version

Driver={Microsoft ODBC Driver for

Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassw ord;