DBHlper C#链接SqlServer数据库封装类
public static string ConnString = "server=.;database=studentDB;Integrated Security=True;";
public static SqlConnection Conn ;
public static void InitConnection()
{
if (Conn == null)
Conn = new SqlConnection(ConnString);
if (Conn.State == ConnectionState.Closed)
Conn.Open();
if (Conn.State == ConnectionState.Broken)
{
Conn.Close();
Conn.Open();
}
}
public static SqlDataReader GetDataReader(string sqlStr)
{
InitConnection();
SqlCommand cmd = new SqlCommand(sqlStr, Conn);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
public static DataTable GetDataTable(string sqlStr)
{
InitConnection();
DataTable table = new DataTable();
SqlDataAdapter dap = new SqlDataAdapter(sqlStr, Conn);
dap.Fill(table);
Conn.Close();
return table;
}
public static bool ExecuteNonQuery(string sqlStr)
{
InitConnection();
SqlCommand cmd = new SqlCommand(sqlStr, Conn);
int result = cmd.ExecuteNonQuery();
Conn.Close();
return result > 0;
}
public static object ExecuteScalar(string sqlStr)
{
InitConnection();
SqlCommand cmd = new SqlCommand(sqlStr, Conn);
object result = cmd.ExecuteScalar();
Conn.Close();
return result;
}
附加方式链接字符串
<add name="ConnectionString" connectionString="Data Source=.;AttachDbFilename=E:\作业\db_khshop.mdf;Integrated Security=True;User Instance=false" providerName="System.Data.SqlClient" />