public class BaseClass
{
String strconn;
public BaseClass()
{
//
// TODO: 在此处添加构造函数逻辑
//连接数据库
strconn = ConfigurationManager.AppSettings["conn"];
}
public DataTable readtable(String strsql)
{//用于从数据库中读取数据,并返回一个DataTable对象
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlDataAdapter cmd = new SqlDataAdapter(strsql, conn);
cmd.Fill(dt);
conn.Close();
return dt;
}
public DataSet readdataset(String strsql)
{//用于从数据库中读取数据,并返回一个DataSet对象
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlDataAdapter cmd = new SqlDataAdapter(strsql, conn);
cmd.Fill(ds);
conn.Close();
return ds;
}
public DataSet getdataset(String strsql,String tablename)
{//用于从数据库中读取数据,并返回一个DataSet对象,填充到具体表中ablename
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlDataAdapter cmd = new SqlDataAdapter(strsql, conn);
cmd.Fill(ds, tablename);
conn.Close();
return ds;
}
public SqlDataReader readrow(String sql)
{//用于执行sql查询,并返回一个Reader对象
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlCommand comm = new SqlCommand(sql, conn);
SqlDataReader reader = comm.ExecuteReader();
if (reader.Read())
{
comm.Dispose();
return reader;
}
else
{
comm.Dispose();
return null;
}
}
public string readstr(String strsql,int flag)
{//返回查询结果第一行中的某以字段
DataSet ds = new DataSet();
String str;
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlDataAdapter cmd = new SqlDataAdapter(strsql, conn);
cmd.Fill(ds);
str = ds.Tables[0].Rows[0].ItemArray[flag].ToString();
conn.Close();
return str;
}
public void execsql(String strsql)
{//用于执行sql更新语句
SqlConnection conn = new SqlConnection(strconn);
SqlCommand comm = new SqlCommand(strsql, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
}
{
String strconn;
public BaseClass()
{
//
// TODO: 在此处添加构造函数逻辑
//连接数据库
strconn = ConfigurationManager.AppSettings["conn"];
}
public DataTable readtable(String strsql)
{//用于从数据库中读取数据,并返回一个DataTable对象
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlDataAdapter cmd = new SqlDataAdapter(strsql, conn);
cmd.Fill(dt);
conn.Close();
return dt;
}
public DataSet readdataset(String strsql)
{//用于从数据库中读取数据,并返回一个DataSet对象
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlDataAdapter cmd = new SqlDataAdapter(strsql, conn);
cmd.Fill(ds);
conn.Close();
return ds;
}
public DataSet getdataset(String strsql,String tablename)
{//用于从数据库中读取数据,并返回一个DataSet对象,填充到具体表中ablename
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlDataAdapter cmd = new SqlDataAdapter(strsql, conn);
cmd.Fill(ds, tablename);
conn.Close();
return ds;
}
public SqlDataReader readrow(String sql)
{//用于执行sql查询,并返回一个Reader对象
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlCommand comm = new SqlCommand(sql, conn);
SqlDataReader reader = comm.ExecuteReader();
if (reader.Read())
{
comm.Dispose();
return reader;
}
else
{
comm.Dispose();
return null;
}
}
public string readstr(String strsql,int flag)
{//返回查询结果第一行中的某以字段
DataSet ds = new DataSet();
String str;
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlDataAdapter cmd = new SqlDataAdapter(strsql, conn);
cmd.Fill(ds);
str = ds.Tables[0].Rows[0].ItemArray[flag].ToString();
conn.Close();
return str;
}
public void execsql(String strsql)
{//用于执行sql更新语句
SqlConnection conn = new SqlConnection(strconn);
SqlCommand comm = new SqlCommand(strsql, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
}
}
在web.config中添加
<appSettings>
<add key="conn" value ="server=localhost;uid=sa;pwd=123456;database=pressweb"/>
</appSettings>