集成sql 语句集成

集成sql非查询语句

namespace SQLHelper
{
    public class SQLHelper
    {
        public static int ExecuteNonQuery(string sql, params SqlParameter[] Parameters) //执行非查询 insert、 delete、update
        {
            string connStr = ConfigurationManger.ConnectionString["ConnStr"].connectionString;
            using(SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using(SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sql;
                    foreach (SqlParameter parameter in Parameters)
                    {
                        cmd.Parameters.Add(parameter);
                    }
                    return cmd.ExecuteNonQuery();
                }
            }
        }

public static int DataTable ExecuteDataTable(string sql, params SqlParameter[] Parameters) //执行DataSet查询语句
       {
            string connStr = ConfigurationManger.ConnectionString["ConnStr"].connectionString;
            using(SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using(SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sql;
                    foreach (SqlParameter parameter in Parameters)
                    {
                        cmd.Parameters.Add(parameter);
                    }

                    DataSet dataset = new DataSet();

                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);

                     adapter.Fill(dataset);
                    return dataset.tables[0];
                }
            }
        }    }
}
\\\\\\\\\\\\\\\\\\\\调用\\\\\\\\\\\\\\\\\\\\\\\\\

SQLHelper.ExecuteNonQuery("Insert into t_table(Name,Age)values(@Name,@Age)",new SqlParameter("Name","tom"),new SqlParameter("Age","30"));

DataTable dt= SQLHelper.ExecuteDataTable("select * from t_table");

for(int i=0;i<dt.rows.cont;i++)

{

      dataRow row = dt.Rows[i];

      string name =Convert.ToString(row["name"]);

}