簡單實(shí)用的數(shù)據(jù)讀取，數(shù)據(jù)操作方法，貼到程序里面直接調(diào)用

讀取方法：

public dataset query(string sqltext)
  {
   sqlconnection myconnection=new sqlconnection(configurationsettings.appsettings["conn"]); 
   dataset ds = new dataset();
   sqldataadapter mycommand = new sqldataadapter(sqltext,myconnection);
   mycommand.fill(ds);
   return ds;
  }

操作方法：

//執(zhí)行查詢,返回sqldatareader
  public  sqldatareader querybyreader(string sqlstr)
  {
   if (sqlstr==string.empty)
    return null;
   
   sqlconnection myconnection = new sqlconnection(configurationsettings.appsettings["connstring"]);
   sqlcommand mycommand = new sqlcommand(sqlstr, myconnection);

   myconnection.open();
   sqldatareader result = mycommand.executereader(commandbehavior.closeconnection);
   
   return result;
  }

  //操作數(shù)據(jù)庫,不返回結(jié)果
  public  bool operatedb(string sqlstr)
  {
   if (sqlstr==string.empty)
    return false;

   sqlconnection myconnection = new sqlconnection(configurationsettings.appsettings["connstring"]);
   sqlcommand mycommand = new sqlcommand(sqlstr, myconnection);

   myconnection.open();
   mycommand.executenonquery();
   myconnection.close();

   return true;
  }