Question

c#连接数据库后，如何实现对表中数据的增删改查！拜托了各位 谢谢

代码大致是怎么样的？

Answer 1

弄个通用DAO，即通用 增删改 一个方法，一个通用查询方法 通用增删改方法： public bool ExecuteNonquery(string sql,CommandType type,ref string msg,params SqlParameter [] lists) { SqlCommand command = new SqlCommand(); command.CommandText=sql; command.CommandType=type; command.Connection= connection; command.Parameters.Clear(); foreach(SqlParameter p in lists) { command.Parameters.Add(p); } try { if(connection.State!=ConnectionState.Open) connection.Open(); int result = command.ExecuteNonQuery(); if(result>0) { msg="操作成功"; return true; } else { msg="操作失败"; return false; } } catch(Exception ex) { msg=ex.Message; return false; } } 通用查询： public SqlDataReader sqlReader(string sql,CommandType type,ref string msg,params SqlParameter[] lists) { SqlCommand command = new SqlCommand(); command.CommandText=sql; command.CommandType=type; command.Connection=connection; command.Parameters.Clear(); SqlDataReader reader = null; foreach(SqlParameter p in lists) { command.Parameters.Add(p); } try { if(connection.State!=ConnectionState.Open) connection.Open(); reader=command.ExecuteReader(CommandBehavior.CloseConnection); } catch(Exception ex) { msg=ex.Message; } return reader; }

Answer 2

是ADO把，，什么DAO，，，，晕，，，你可以写个专门用来出来数据的类，， class DBHelper { #region 数据库操作方法 public static SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=MyQQ;Integrated Security=True"); /// <summary> /// 返回首行首列 /// </summary> /// <param name="sql"></param> /// <returns></returns> public static object GetFristCells(string sql) { SqlCommand cmd = new SqlCommand(sql, con); if (con.State.ToString().ToLower() == "closed") { con.Open(); } object obj = cmd.ExecuteScalar(); CloseConnection(); return obj; } /// <summary> /// 获取datareader对象 /// </summary> /// <param name="sql"></param> /// <returns></returns> public static SqlDataReader GetDataReader(string sql) { SqlCommand cmd = new SqlCommand(sql, con); if (con.State.ToString().ToLower() == "closed") { con.Open(); } return cmd.ExecuteReader(); } /// <summary> /// 执行增、删、改操作 /// </summary> /// <param name="sql"></param> /// <returns></returns> public static int ExecuteUpdate(string sql) { SqlCommand cmd = new SqlCommand(sql, con); if (con.State.ToString().ToLower() == "closed") { con.Open(); } int cnt = cmd.ExecuteNonQuery(); CloseConnection(); return cnt; } /// <summary> /// 获取DataSet数据集对象 /// </summary> /// <param name="sql"></param> /// <param name="tableName"></param> /// <returns></returns> public static DataSet GetDataSet(string sql, string tableName) { SqlDataAdapter da = new SqlDataAdapter(sql, con); if (con.State.ToString().ToLower() == "closed") { con.Open(); } DataSet ds = new DataSet(); da.Fill(ds, tableName); return ds; } /// <summary> /// 关闭数据库连接 /// </summary> public static void CloseConnection() { if (con.State == ConnectionState.Open) { con.Close(); } } 如果看不懂你就要去先学习ADO.NET的4个常用对象了