01.SqlConnection Cn = new SqlConnection();
02. SqlCommand Cm = new SqlCommand();
03. Cn.ConnectionString = Properties.Settings.Default.cnStr;
04. SqlDataAdapter Da;
05. DataSet ds = new DataSet();
06. string SqlStr;
07.
08. SqlStr = "Select member_id,book_id from rent where rent_return = '" + dtpChargeDate1.Text + "'";
09. Cn.Open();
10. Da = new SqlDataAdapter(SqlStr, Cn);
11. Da.Fill(ds);
12.
13. ds.Dispose();
14. Da.Dispose();
15. Cn.Close();
16. Cn.Dispose();
17. dtgshow.DataSource = ds.Tables[0].DefaultView;
18. dtgshow.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
19.
20. dtgshow.Columns[0].Width = 0;
Load balance : Server 02
