|
«amaliy matematika va informatika»
|
| bet | 19/19 | | Sana | 23.01.2024 | | Hajmi | 1,39 Mb. | | #143634 |
Bog'liq «amaliy matematika va informatika» kafedrasi «dasturlash asoslar 10-mavzu suv resursi va uni muhofazasi reja, Аvtomatika relelari, 10-mavzu, talim, pYyL9TzZmnw0-W-ezNU38dSTIPC1Usb4, Маъруза №4, Hujjat 1, TEMA, TOZA KOD, 2, 4, 4-javobsiz, 14-amaliy, 15-amaliy, 12 lab// TODO: This line of code loads data into the 'hospitalDataSet3.checkout' table. You can move, or remove it, as needed.
this.checkoutTableAdapter.Fill(this.hospitalDataSet3.checkout);
using (SqlConnection con1 = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\SmartCity\Downloads\HospitalManagementSystem_C#\HospitalManagementSystemCSharp\HospitalManagementSystemCSharp\hospital.mdf;Integrated Security=True"))
{
string str2 = "SELECT * FROM checkout";
SqlCommand cmd2 = new SqlCommand(str2, con1);
SqlDataAdapter da = new SqlDataAdapter(cmd2);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = new BindingSource(dt, null);
}
}
private void button1_Click(object sender, EventArgs e)
{
using (SqlConnection con1 = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\SmartCity\Downloads\HospitalManagementSystem_C#\HospitalManagementSystemCSharp\HospitalManagementSystemCSharp\hospital.mdf;Integrated Security=True"))
{
string str2 = "SELECT * FROM checkout where id='"+textBox1.Text +"'";
SqlCommand cmd2 = new SqlCommand(str2, con1);
SqlDataAdapter da = new SqlDataAdapter(cmd2);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = new BindingSource(dt, null);
}
}
}
}
|
| |
