private void Search_2_Click(object sender, EventArgs e)
{
connection.Open();
Search_result.Text = string.Empty;
string name = TxtDname.Text;
cmd = new SqlCommand("select * From Drug where D_name = '" + name + "' ", connection);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Search_result.AppendText("Drug Number: " + dr["D_nom"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug Name: " + dr["D_name"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug Price: " + dr["D_price"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug Place: " + dr["D_place"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug Quantity: " + dr["Quantity"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug EX._date: " + dr["EX_date"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug Prescription: " + dr["prescription"].ToString() + Environment.NewLine);
Search_result.AppendText("Drug_classification: " + dr["classification"].ToString() + Environment.NewLine);
Search_result.AppendText("Producer Name: " + dr["producer_name"].ToString() + Environment.NewLine);
Search_result.AppendText("Provider_num: " + dr["provider_num"].ToString() + Environment.NewLine);
Search_result.AppendText("Branch Number: " + dr["Br_num"].ToString() + Environment.NewLine);
}
dr.Close();
connection.Close();
}
private void Search_Click(object sender, EventArgs e)
{
Search_result.Text = string.Empty;
string name = TxtBname.Text;
cmd = new SqlCommand("select * From Branch where Place = '" + name + "' ", connection);
connection.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
Search_result.AppendText("Branch Name: " + dr["Place"].ToString() + Environment.NewLine);
Search_result.AppendText("Branch Phone: " + dr["B_phone"].ToString() + Environment.NewLine);
Search_result.AppendText("Branch Address: " + dr["Address"].ToString() + Environment.NewLine);
}
dr.Close();
connection.Close();
}
private void Search_2_Click(object sender, EventArgs e)
{
connection.Open();
Search_result.Text = string.Empty;
string name = TxtAname.Text;
cmd = new SqlCommand("select * From Accessories where A_name = '" + name + "' ", connection);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Search_result.AppendText("Accessory Number: " + dr["A_num"].ToString() + Environment.NewLine);
Search_result.AppendText("Accessory Name: " + dr["A_name"].ToString() + Environment.NewLine);
Search_result.AppendText("Accessory Place: " + dr["A_place"].ToString() + Environment.NewLine);
Search_result.AppendText("Accessory Quantity: " + dr["Quantity"].ToString() + Environment.NewLine);
Search_result.AppendText("Accessory EX._date: " + dr["EX_date"].ToString() + Environment.NewLine);
Search_result.AppendText("Accessory classification: " + dr["Classification"].ToString() + Environment.NewLine);
Search_result.AppendText("Branch Number: " + dr["Br_num"].ToString() + Environment.NewLine);
}
dr.Close();
connection.Close();
}
