连接SQL Server执行SQL语句

最新推荐文章于 2024-10-14 10:31:31 发布

转载最新推荐文章于 2024-10-14 10:31:31 发布 · 206 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/fourw/p/3768602.html

文章标签：

#数据库

public static DataTable GetData()
{
string Connect = ConfigurationManager.AppSettings["ConnectionString"].ToString();
SqlConnection sc = new SqlConnection(Connect);
sc.Open();
SqlCommand cm = new SqlCommand("select * from Department");
cm.Connection = sc;
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(cm);
sda.Fill(ds, "abc");
DataTable dt = ds.Tables["abc"];
return dt;
}
public static string ExecSQL(string sql)
{
string Connect = ConfigurationManager.AppSettings["ConnectionString"].ToString();
SqlConnection sc = new SqlConnection(Connect);
sc.Open();
SqlCommand cm = new SqlCommand(sql);
cm.Connection = sc;
string str = cm.ExecuteNonQuery().ToString();
sc.Close();
return str;
}