◆简单实用的数据读取,数据操作方法,贴到程...... 简单实用的数据读取,数据操作方法,贴到程序里面直接调用 读取方法: 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; } |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 19:25 , Processed in 0.210900 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.