.net/c#連接sqlserver

Webconfig代碼

<configuration>

<appSettings>

<add key="myconnect" value="server=.;UID=sa;passWord='1';database=test" />

</appSettings>

</configuration>

?

數據庫類代碼

using System;

using System.Data;

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;

?

/// <summary>

///DB_class 的摘要說明

/// </summary>

public class DB_class

{

SqlConnection myconn;

SqlCommand mycmd;

DataSet ds; //數據集

SqlDataAdapter adapt;

????public DB_class()

????{

????????//

????????//TODO: 在此處添加構造函數邏輯

????????//

????}

public SqlConnection GetConnection()

{

string mystr = ConfigurationManager.AppSettings["myconnect"].ToString();

SqlConnection myconn = new SqlConnection(mystr);

return myconn;

}

?

public int ExecNonQuery(string strSql)

{

?

try

{

myconn = GetConnection();//與數據庫連接

mycmd = new SqlCommand();//初始化SqlCommand類對象

mycmd.Connection = myconn;

mycmd.CommandText = strSql;

if (mycmd.Connection.State != ConnectionState.Open)

{

mycmd.Connection.Open();//打開與數據庫的連接

}

int a=mycmd.ExecuteNonQuery();//執行Sql操作，并返回受影響的行數

return a;

?

}

catch (Exception ex)

{

throw new Exception(ex.Message, ex);

?

}

finally

{

if (mycmd.Connection.State == ConnectionState.Open)

{//斷開連接，釋放資源

mycmd.Connection.Close();

myconn.Dispose();

mycmd.Dispose();

?

}

}

}

?

public string ExecScalar(string strSql)

{

try

{

myconn = GetConnection();//與數據庫連接

mycmd = new SqlCommand();//初始化SqlCommand類對象

mycmd.Connection = myconn;

mycmd.CommandText = strSql;

if (mycmd.Connection.State != ConnectionState.Open)

{

mycmd.Connection.Open();//打開與數據庫的連接

}

//使用SqlCommand對象的ExecuteScalar方法返回第一行第一列的值

//strSql = Convert.ToString(mycmd.ExecuteScalar());

string another = Convert.ToString(mycmd.ExecuteScalar());

return another;

}

catch (Exception ex)

{

throw new Exception(ex.Message, ex);

?

}

finally

{

if (mycmd.Connection.State == ConnectionState.Open)

{//斷開連接，釋放資源

myconn.Dispose();

mycmd.Connection.Close();

mycmd.Dispose();

?

}

}

}

?

public DataTable GetDataSet(string strSql, string TableName)

{

ds = new DataSet();

try

{

myconn = GetConnection();//與數據庫連接

adapt = new SqlDataAdapter(strSql, myconn); //實例化SqlDataAdapter類對象

adapt.Fill(ds, TableName);//填充數據集

return ds.Tables[TableName];//返回數據集DataSet的表的集合

?

}

catch (Exception ex)

{

throw new Exception(ex.Message, ex);

?

}

finally

{//斷開連接，釋放資源

myconn.Close();

adapt.Dispose();

ds.Dispose();

myconn.Dispose();

}

?

}

}