1
public class db
{
string ServerStr;
public db()
{
//
// TODO: 在此处添加构造函数逻辑
ServerStr = ConfigurationSettings.AppSettings["sql"].ToString();
//
}
public SqlDataReader read(string strtb,string zd)
{
// string strcon = ConfigurationSettings.AppSettings["sql"].ToString();
SqlConnection conn = new SqlConnection(ServerStr);
SqlDataReader DataReader ;
SqlCommand cmd = new SqlCommand("select * from "+ strtb + " where ProId = " + zd,conn);
conn.Open();
DataReader = cmd.ExecuteReader();
// DataReader.Close();
// conn.Close();
return DataReader;
}
public DataView GetGrid(string Sql,string Tb)
{
SqlConnection objConn = new SqlConnection(ServerStr);
SqlDataAdapter objAdapter = new SqlDataAdapter(Sql,ServerStr);
DataSet objDataSet = new DataSet();
objAdapter.Fill(objDataSet,Tb);
DataView result = objDataSet.Tables[Tb].DefaultView;
return result;
}
}
函数 如下
private void show()
{
db d1 = new db();
SqlDataReader dr1 = d1.read("t_Pro","2");
// Trace.Warn(dr1.ToString());
ProNo.Text = dr1["ProNo"].ToString();
ProName.Text = dr1["ProName"].ToString();
TimeSt.Text = dr1["TimeSt"].ToString();
TimeFsh.Text = dr1["TimeFsh"].ToString();
DesMan.Text = dr1["DesMan"].ToString();
gbh.Text = dr1["CDPath"].ToString();
FzMan.Text = dr1["FzMan"].ToString();
Add.Text = dr1["PicPath"].ToString();
}