private List <Customers1> GetCustomers()
{
var conn = Database.ConnectDB();
conn.Open();
string query = "select * from Customers";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader reader = cmd.ExecuteReader();
//ArrayList list = new ArrayList();
List <Customers1> list = new List <Customers1>();
while (reader.Read())
{
Customers1 c = new Customers1();
c.CustomerId = reader.GetInt32(reader.GetOrdinal("CustomerId"));
c.CustomerName = reader.GetString(reader.GetOrdinal("CustomerName"));
c.CustomerContact = reader.GetString(reader.GetOrdinal("CustomerContact"));
c.CustomerRoomNo = reader.GetString(reader.GetOrdinal("CustomerRoomNo"));
c.Payment = reader.GetString(reader.GetOrdinal("Payment"));
list.Add(c);
}
return(list);
}
private void BtnSearch_Click(object sender, EventArgs e)
{
int c_id = Int32.Parse(tbCId.Text);
var conn = Database.ConnectDB();
conn.Open();
string query = string.Format("select * from Customers where CustomerId={0}", c_id);
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader reader = cmd.ExecuteReader();
Customers1 c = new Customers1();
while (reader.Read())
{
c.CustomerName = reader.GetString(reader.GetOrdinal("CustomerName"));
c.CustomerContact = reader.GetString(reader.GetOrdinal("CustomerContact"));
c.CustomerRoomNo = reader.GetString(reader.GetOrdinal("CustomerRoomNo"));
c.Payment = reader.GetString(reader.GetOrdinal("Payment"));
c.CustomerId = reader.GetInt32(reader.GetOrdinal("CustomerId"));
}
tbCName.Text = c.CustomerName;
tbCContact.Text = c.CustomerContact;
tbCRoom.Text = c.CustomerRoomNo;
tbCPayment.Text = c.Payment;
}