第2个回答 2011-07-09
using System.Data.SqlClient; //引用
public static DataTable squery(string sqlvalues) //sqlvalues 为要更新的SQL语句
{
SqlConnection connsql = new SqlConnection();
connsql.ConnectionString = "Data Source=服务器IP;Initial Catalog=数据库名;User ID=账号;password=密码";;
connsql.Open(); //打开连接
try
{
connsql.Open();
//写入库存数据
SqlCommand update = connsql.CreateCommand();
update.CommandText = sqlvalues;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = update;
DataSet ds = new DataSet();
da.Fill(ds, "querydate");
return ds.Tables["querydate"];
}
finally
{
connsql.Close();
}
}
供参考