C#++数据库

C#怎样与SQL数据库连接？

SqlConnection con = new SqlConnection("server=localhost;uid="sa";pwd="";database="anyv"");
con.open();
执行SQL命令:
SqlCommand com = new Sqlcommand("select * from table",con);
下面可以用好多种方法,举一例:
SqlDataReader dr = com.ExecuteReader();
显示数据,方法很多,举一例:
this.DataGrid1.DataSource=dr;
.DataGrid1.DataBind();

string ACconnStr = "Provider=SQLOLEDB;Data Source=;Initial Catalog=;User ;
        //创建数据库对像
        OleDbConnection ACconn = new OleDbConnection(ACconnStr);
        ACconn.Open();
        string ACsql;
        //定义SQL语句
        ACsql = "select * from yt_product where +Label1.Text + "'";

        //创建Command对像
        OleDbCommand ACcomm = new OleDbCommand(ACsql, ACconn);
        //通过执行Command实例化DataReader类
        OleDbDataReader ACdr = ACcomm.ExecuteReader();

        //string test;
        if (ACdr.Read())
        {
                              
        ACdr.Close();//切记一定要关闭阅读器
      
      
      
    }

c#和access数据库连接

using System.Data.OleDb

public string myConnstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+HttpContext.Current.Server.MapPath("data.mdb"); //data.mdb是你的数据库名称

OleDbConnection MyConnection;
MyConnection = new OleDbConnection(myConnstring); 这两句可以改为：OleDbConnection MyConnection=new                                                     new OleDbConnection(myConnstring);

strInsert=""; //strinsert是你的sql语句

OleDbCommand MyCommand = new OleDbCommand(strInsert,MyConnection);

MyConnection.Open();

MyCommand.ExecuteNonQuery();

MyConnection.Close();