62,074
社区成员
发帖
与我相关
我的任务
分享
protected void Session_Start(Object sender, EventArgs e)
{
//读取数据库连接字符串
Session["str_connection"] = System.Configuration.ConfigurationSettings.AppSettings["Connectionstring"];
}
<appSettings>
<add key="Connectionstring" value="server=localhost;user id=sa;password=12345;database =user_register"/>
<add/>
</appSettings>
private void databind() //定义数据查询与绑定私有过程
{
int curPage = Convert.ToInt32(this.Label2.Text);
SqlConnection conn = new SqlConnection(Session["str_connection"].ToString());
conn.Open();
String mysql = "SELECT * FROM book order by id desc";
SqlDataAdapter mybook = new SqlDataAdapter(mysql, conn);
DataSet ds = new DataSet();
}
<!--数据库连接字段-->
<connectionStrings>
<add name="connectionStrings" connectionString="server=ip;database=数据库名;uid=用户名;pwd=密码" providerName="System.Data.SqlClient"/>
</connectionStrings>
//连接数据库类
public static class DBHelpM
{
private static SqlConnection conn;
public static SqlConnection Conn
{
get
{
string con = ConfigurationManager.ConnectionStrings["connectionString1"].ConnectionString.ToString();
conn = new SqlConnection(con);
return conn;
}
}
public static object getSR(string str)
{
Conn.Open();
SqlCommand com = new SqlCommand(str, conn);
int result = Convert.ToInt32(com.ExecuteScalar());
return result;
}
public static object getSR(string str, params SqlParameter[] values)
{
Conn.Open();
SqlCommand com = new SqlCommand(str, conn);
com.CommandType = CommandType.StoredProcedure;
if(values!=null)
{
com.Parameters.AddRange(values);
}
int reslut = Convert.ToInt32(com.ExecuteScalar());
return reslut;
}
public static int getEQ(string str, params SqlParameter[] values)
{
Conn.Open();
SqlCommand com = new SqlCommand(str, conn);
com.CommandType = CommandType.StoredProcedure;
if(values!=null)
{
com.Parameters.AddRange(values);
}
int reslut = Convert.ToInt32(com.ExecuteNonQuery());
return reslut;
}
public static DataSet getDate(string str, params SqlParameter[] values)
{
Conn.Open();
SqlCommand com = new SqlCommand(str, conn);
com.CommandType = CommandType.StoredProcedure;
if(values!=null)
{
com.Parameters.AddRange(values);
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(com);
da.Fill(ds);
return ds;
}
}
}
SqlConnection conn = new SqlConnection(Session["str_connection"].ToString());
<configuration>
<appSettings/>
<connectionStrings>
<add name="SqlConnectionString" connectionString="Data Source=.;Initial Catalog=学生;User ID=sa"/>
</connectionStrings>
......
<connectionStrings> <add name="SYXTConnectionString" connectionString="Data Source=LEIKE;Initial Catalog=SYXT;User ID=sa;Password=sa" providerName="System.Data.SqlClient" /> </connectionStrings>