简单实用的数据读取,数据操作方法,贴到程序里面直接调用
读取方法:
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; }
操作方法:
//执行查询,返回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; }
//操作数据库,不返回结果 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; }
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18