//数据库连接
SqlConnectionobjSqlConnection = newSqlConnection("server=127.0.0.1;uid=sa;pwd=1;database=mysql");
objSqlConnection.Open();
// MessageBox.Show("数据库连接成功","好");
//数据库添加 CMD 对象执行插入语句
//stringInsert = "insert into sticalleakage(plantname,boiler,faulttime,leakagelocation,leakagereason) values('";
//Insert+= "333" + "',";
//Insert+= "'" + "222" + "',";
//Insert+= "'" + "2011-06-01"+ "',";
//Insert +="'" + "222" + "',";
//Insert+= "'" + "222" + "')";
//SqlCommandsqlcom = new SqlCommand(Insert, objSqlConnection);
//sqlcom.ExecuteNonQuery();
//数据库的修改代码:和插入操作相同
//stringupdate = "update sticalleakage setplantname=4 where id=3 ";
//SqlCommandsqlcom = new SqlCommand(update, objSqlConnection);
//sqlcom.ExecuteNonQuery();
//删除呢也一样
//stringdelet = "delete from sticalleakagewhere id=3 ";
//SqlCommandsqlcom = new SqlCommand(delet, objSqlConnection);
//sqlcom.ExecuteNonQuery();
//查询
//stringsql = "select boiler from sticalleakage ";
//SqlCommandsqlcom = new SqlCommand(sql, objSqlConnection);
//SqlDataReaderdatareader = sqlcom.ExecuteReader();
//while(datareader.Read())
//{
// MessageBox.Show((string)datareader["boiler"], "好");
//}
//datareader.Close();
//dataset的用法
//SqlConnectionthisConnection = newSqlConnection(@"server=192.168.1.183;database=energy_cts;uid=sa;pwd=1");
//SqlDataAdapterthisAdapter = new SqlDataAdapter("select * from Controltime",thisConnection);
//SqlCommandBuilderthisBuilder = new SqlCommandBuilder(thisAdapter);
//DataSetthisDataSet = new DataSet();
//thisAdapter.Fill(thisDataSet,"Controltime");
stringsRouter = "~/db/db1.mdb";
//获得当前Access数据库在服务器端的绝对路径
stringstrCon = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " + System.Web.HttpContext.Current.Server.MapPath(sRouter);