private System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("workstation id=ZHAOLIREN;packet size=4096;user id=sa;data source=localhost;persist security info=True;initial catalog=kiddle;password=asdf;Max Pool Size=75; Min Pool Size=5");
private void button1_Click(object sender, System.EventArgs e)
{
conn.Open();
string sql = "select 收费项目编码,姓名 from 会员信息";
SqlCommand sqlcommand = new SqlCommand(sql,conn);
SqlDataReader sdr = sqlcommand.ExecuteReader();
while(sdr.Read())
{
this.listBox1.Items.Add(sdr.GetString(0) + "|" + sdr.GetString(1));
GetChargeItemDescript(sdr.GetString(0)); //还是不能这样作啊,我想这样作怎么办.连接池表现在什么地方了?
}
sdr.Close();
conn.Close();
}
private void GetChargeItemDescript(string ChargeItemCode)
{
string sql = "select 描述,编码 from 收费项目";
SqlCommand sqlcommand = new SqlCommand(sql,conn);
SqlDataReader sdr = sqlcommand.ExecuteReader();
while(sdr.Read())
{
this.listBox1.Items.Add(sdr.GetString(0) + "|" + sdr.GetString(1));
}
sdr.Close();
}
{
SqlConnection cn = new SqlConnection(Connection);
cn.Open();
myConnectionArray.Add(cn); }