数据库的连接代码

{
mandType = CommandType.Text;
mandText = mysql;
mycommand.Connection = myconnection;
myadapter.SelectCommand = mycommand;
public static OleDbCommand mycommand = new OleDbCommand();
public static int nonconnection()//利用返回值temp来判断是否成功
{
mycommand = new OleDbCommand(mysql, myconnection);
OleDbCommand mycommand = new OleDbCommand();//建立Command,主要执行SQL语句
mandType = CommandType.Text;//SQL为文本型
mandText = mysql; //将SQL语句给command，mysql为你的SQL语句
string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +connection . load + "";//连接数据库，load是数据库的地址，此为无密码登陆
//"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath("~/App_Data/judgement_system.mdb") + ";User Id=admin;Password=;";//System.Web.HttpContext.Current.Server.MapPath("~/App_Data/judgement_system.mdb")为获取程序所在目录下的地址，相当于debug的地址。此为有密码登陆
又返回数据的连库操作：
DataSet de = new DataSet(); //建立数据集，这主要用于又返回值的连库
OleDbConnection myconnection = new OleDbConnection(ConnectionString);//建立连接对象，并将连接串给它
ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=trace;server=localhost;Connect Timeout=30";//此为windows登陆，连接的是trace库
OleDbCommandBuilder builder = new OleDbCommandBuilder(myadapter);
}
使用时：
mysql="select * from list";
connection();
myadapter.Fill(myset,"list");
public static string mysql;
public static DataSet myset=new DataSet ();//静态数据集
public static OleDbConnection myconnection = new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;DataSource="+System.Web.HttpContext.Current.Server.MapPath("~/App_Data/judgement_system.mdb") + "");//建立连接
}
else
{
HttpContext.Current.Response.Write("<script>alert('" + "密码修改失败，请重新尝试！" + "')</script>");
}
如果数据库使用的事SQL sever：
连接字符串：
myconnection.close(); //千万别忘记关闭连接
无返回数据的连库操作：
public static string mysql;
public static OleDbConnection myconnection = new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;DataSource="+System.Web.HttpContext.Current.Server.MapPath("~/App_Data/judgement_system.mdb") + "");//建立连接
mysql = "update Superuser set PW='000' where UserId='008'";
int temp = Connection.nonconnection();
if (temp == 1)
{
HttpContext.Current.Response.Write("<script>alert('" + "密码修改成功！" + "')</script>");
mycommand.Connection = myconnection;//把连接给command
OleDbDataAdapter myadapter = new OleDbDataAdapter(mysql, myconnection);//与下一句所起的作用相同，不过想要使用adapter的updata方法时，最好adapter是独立的
myadapter.SelectCommand = mycommand;
OleDbCommandBuilder builder = new OleDbCommandBuilder(myadapter);
myadapter.Fill(de, "score");//成绩表的连接
如果使用静态方法可如此设置：
connectionString="Data Source=server;Initial Catalog=DB07;Persist Security Info=True;User ID=sa;Password=sa"//此为数据库登陆，注意密码，用户使用为sa
public static OleDbCommand mycommand = new OleDbCommand();
public static OleDbDataAdapter myadapter = new OleDbDataAdapter();
public static void connection() //查询并且需填充dataset的连接方法
mandText = mysql;
myconnection.Open();
int Temp = mycommand.ExecuteNoClose();
}
使用时：