C#中连接数据库的语句？

答案：c#数据库连接代码
///系统引用
using System.Data;
using System.Data.OleDb;//Access数据库需要
using System.Data.SqlClient;//SQL数据库需要
 
c#本地MDB数据库连接
private void menuItem2_Click(object sender, System.EventArgs e)
{
     //创建一个 OleDbConnection对象 
    string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = ../../database/MDB数据库名称.mdb" ; 
    OleDbConnection myConn = new OleDbConnection ( strCon ) ; 
}
#本地SQL数据库连接
private void menuItem3_Click(object sender, System.EventArgs e)
{
    //创建一个 SqlConnection对象 
    string strCon = "Integrated Security=SSPI;Initial Catalog='数据库名称';Data Source='本地计算机名';User ID='登录用户名';Password='登录用户密码';Connect Timeout=30"; 
    SqlConnection myConn = new SqlConnection ( strCon ) ;    
} 
SQL是           
 SqlConnection con = new SqlConnection("database=***;Server=.;User ID=sa;Password=;Persist Security Info=True");
access是
 string connst = "Provider=Microsoft.Jet.OleDb.4.0;";
 connst += @"Data Source=" + Application.StartupPath + "/***.mdb";
 OleDbConnection con = new OleDbConnection(connst);

 if (Session["CheckCode"] != null)  {  string vstr = Session["CheckCode"].ToString();
 if (TextBox5.Text == vstr)  {  Session["user"] = TextBox1.Text;  string sql = "select top 1 * from [user] where u_name='"   TextBox1.Text   "' and u_pwd='"   TextBox2.Text   "'";  if (DBAccess.GetDB.Query(sql).Rows.Count > 0)  {
 Response.Redirect("mainform.aspx", true);
 }  else  {  TextBox1.Text = "";  TextBox2.Text = "";
 ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('密码或用户名不正确!')</script>");  }  }  else  {  ClientScript.RegisterStartupScript(this.GetType (), "", "<script>alert('验证码不对!')</script>");  }  }

上一个：这道C#题目怎么做？
下一个：给几个C#基础编程题