数据库

//数据库连接

            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);