c#！连！接！sql！server！200！8！的！几！种方式

        OleDbConnection conn = new OleDbConnection("Provider=SQLNCLI10;Data Source=localhost;Database=mydatabase812;User Id=sa;Password=yp17233455");
        conn.Open();
        OleDbCommand com = new OleDbCommand("select * from news", conn);
        OleDbDataReader dataReader = com.ExecuteReader();
        //Response.Write("Ok");
        while (dataReader.Read())   //while循环依次读取table中的每条记录给dataReader
        {
            div1.InnerHtml += dataReader["date1"].ToString() + "<br />";    //dataReader[""]取某个字段的值
        }

        conn.Close();

或：

 OleDbConnection _sqlCon = new OleDbConnection("Provider=SQLNCLI10;server=localhost;database=test0922;UID=sa;PWD=yp17233455");
            OleDbDataAdapter _adapter = new OleDbDataAdapter("select * from t_userInfo", _sqlCon);
            DataTable _dataTable = new DataTable("t_userInfo");
            _adapter.Fill(_dataTable);
            dataGridView1.DataSource = _dataTable;

SqlConnection连接sql：

        string str_sql = "server=localhost;DATABASE=mydatabase812;user id=sa;password=yp17233455";
        SqlConnection conn = new SqlConnection(str_sql);
        conn.Open();
        SqlCommand com = new SqlCommand("select * from news",conn);
        SqlDataReader dataReader = com.ExecuteReader();
        Response.Write("OK");
        conn.Close();

OleDbConnection链接access的mdb文件：

             string _strDBpath = Application.StartupPath + "\\iccard.mdb";
                string _strCon = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + _strDBpath;
                OleDbConnection _oledb = new OleDbConnection(_strCon);
                _oledb.Open();
                string _strCMD11 = "select * from userInfo";
                //string _strCMD = "insert into userInfo ()";
                //string _strCMD = "insert into userInfo (name,pw) values(" + "'" + _strUserName + "'" + "," + "'" + _strCardPW + "'" + ")";
                OleDbCommand _com11 = new OleDbCommand(_strCMD11, _oledb);
                OleDbDataReader _reader11 = _com11.ExecuteReader();

或者：

                  string _strDBpath = Application.StartupPath + "\\iccard.mdb";
                string _strCon = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + _strDBpath;
                OleDbConnection _oledb = new OleDbConnection(_strCon);
                _oledb.Open();
                string _strCMD = "select * from userInfo";//
                //string _strCMD = "insert into userInfo (name,pw) values(" + "'" + _strName + "'" + "," + "'" + _strPW + "'" + ")";


                OleDbDataAdapter _adapter=new OleDbDataAdapter(_strCMD,_oledb);
                DataSet _set=new DataSet();
                _adapter.Fill(_set,"userInfo");
                DataTable _table=_set.Tables[0];
                delegate_voidDataTable updateCombobox = new delegate_voidDataTable((param_string) =>
                    {
                        string _text = comboBox5.Text;
                        comboBox5.DataSource = param_string;
                        comboBox5.DisplayMember = "name";
                        comboBox5.Text = _text;
                        comboBox5.Select(comboBox5.Text.Length,0);
                    });
                    comboBox5.Invoke(updateCombobox, _table);
                _oledb.Close();

SqlConnection：

OleDbConnection：

OdbcConnection：

。NET访问数据库：

sqlconnection对象

sqlcommand对象

sqldataReader对象

sqlDataAdapter对象

dataSet对象

sqlTransaction对象（事务对象）--con.beginTransaction()//开始事务

sqlDataAdapter，dataSet :

sqlTransaction :