using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;/// <summary>
/// sql 的摘要说明
/// </summary>
public class sql
{
public sql()
{
//
// TODO: 在此处添加构造函数逻辑
//
} public static string connstring = "Data Source=dudu;Initial Catalog=welcome;User ID=sa;Password=saku"; public static DataSet GreatDs(string sql)
{
SqlClientDataAdapter Dar = new SqlClientDataAdapter(sql, connstring); DataSet ds = new DataSet();
Dar.Fill(ds);
return ds;
}
public static void DoSql(string sql)
{
SqlClientConnection conn = new SqlClientConnection();//创建连接对象
conn.ConnectionString = connstring;//给连接字符串赋值
conn.Open();//打开数据库
SqlClientCommand cmd = new SqlClientCommand(sql, conn);
cmd.ExecuteNonQuery();//
conn.Close();//关闭数据库
}}
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;/// <summary>
/// sql 的摘要说明
/// </summary>
public class sql
{
public sql()
{
//
// TODO: 在此处添加构造函数逻辑
//
} public static string connstring = "Data Source=dudu;Initial Catalog=welcome;User ID=sa;Password=saku"; public static DataSet GreatDs(string sql)
{
SqlClientDataAdapter Dar = new SqlClientDataAdapter(sql, connstring); DataSet ds = new DataSet();
Dar.Fill(ds);
return ds;
}
public static void DoSql(string sql)
{
SqlClientConnection conn = new SqlClientConnection();//创建连接对象
conn.ConnectionString = connstring;//给连接字符串赋值
conn.Open();//打开数据库
SqlClientCommand cmd = new SqlClientCommand(sql, conn);
cmd.ExecuteNonQuery();//
conn.Close();//关闭数据库
}}
这个没用过~
改sqldataadapter 试试
SqlDataAdapter Dar = new SqlDataAdapter(sql, connstring);
有这个东东嘛?
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
引入这个做什么
这个using System.Data.SqlClient;