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.Web.SessionState;
using System.Collections;
using System.Collections.Generic;
using System.Text;namespace SQLConn
{
public class Conn { } #region 尝试创建数据库连接 public void class SqlConnection dbconn()
{
SqlConnection db = new SqlConnection();
try
{
string str="server=(local);uid=sa;Pwd=sa;database=store;"; // string str = ConfigurationSettings.AppSettings["sqlstr"];
db.ConnectionString = str;
}
catch(Exception e)
{
HttpContext.Current.Response.Write("数据库无法连接");
HttpContext.Current.Response.End();
}
return db;
}
#endregion
#region 建立一个DataTable 输出缓存
public static DataTable Select(string sql)
{
SqlConnection db = dbconn();
DataSet ds = new DataSet();
try
{
SqlDataAdapter da = new SqlDataAdapter(sql, db);
da.Fill(ds);
return ds.Tables[0];
}
catch
{
return new DataTable();
}
}
#endregion
public static string Update(string sql)
{
SqlConnection db = dbconn();
try
{
if (db.State == ConnectionState.Open) db.Close();
SqlCommand comm = new SqlCommand(sql, db);
db.Open();
comm.ExecuteNonQuery();
sql = "ok";
}
catch
{
sql = "no";
}
return sql;
}
}
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.Web.SessionState;
using System.Collections;
using System.Collections.Generic;
using System.Text;namespace SQLConn
{
public class Conn { } #region 尝试创建数据库连接 public void class SqlConnection dbconn()
{
SqlConnection db = new SqlConnection();
try
{
string str="server=(local);uid=sa;Pwd=sa;database=store;"; // string str = ConfigurationSettings.AppSettings["sqlstr"];
db.ConnectionString = str;
}
catch(Exception e)
{
HttpContext.Current.Response.Write("数据库无法连接");
HttpContext.Current.Response.End();
}
return db;
}
#endregion
#region 建立一个DataTable 输出缓存
public static DataTable Select(string sql)
{
SqlConnection db = dbconn();
DataSet ds = new DataSet();
try
{
SqlDataAdapter da = new SqlDataAdapter(sql, db);
da.Fill(ds);
return ds.Tables[0];
}
catch
{
return new DataTable();
}
}
#endregion
public static string Update(string sql)
{
SqlConnection db = dbconn();
try
{
if (db.State == ConnectionState.Open) db.Close();
SqlCommand comm = new SqlCommand(sql, db);
db.Open();
comm.ExecuteNonQuery();
sql = "ok";
}
catch
{
sql = "no";
}
return sql;
}
}
如你用的 SqlConnection db = new SqlConnection();
如果不引用using System.Data.SqlClient;
也可以写成:System.Data.SqlClient.SqlConnection db = new System.Data.SqlClient.SqlConnection();
慢慢就会熟悉的。多做多练多思。