O‘quv kurslari bilan shug‘ullanuvchi kompaniya ma’lumotlar bazasini yaratish
![int id;
MySqlCommand command;
MySqlConnection connection ;
MySqlDataAdapter adapter;
DataSet dataset;
String connectionString = "Database=kompaniya;Password=12345;Server=localhost;User=root";
private void selectAll(String comanda,DataGridView dataGrid)
{
dataset = new DataSet();
command = new MySqlCommand(comanda, connection);
adapter = new MySqlDataAdapter(command);
adapter.Fill(dataset);
dataGrid.DataSource = dataset.Tables[0];
}
private void InsertDelete(String comanda)
{
command = new MySqlCommand(comanda, connection);
adapter = new MySqlDataAdapter(command);
command.ExecuteNonQuery();
}
private void Form1_Load(object sender, EventArgs e)
PAGE \* MERGEFORMAT1](https://docx.uz/documents/12a35ca2-2c58-48f4-af03-f6cbe28a3461/page_17.png?v=1)
![{
connection = new MySqlConnection(connectionString);
connection.Open();
selectAll("SELECT oquvmarkazlar.Id, oquvmarkazlar.Nomi,
oquvmarkazlar.Address,oquvmarkazlar.Tel,oquvmarkazlar.Email,raxbarlar.Ism,raxbarlar.Familiya,raxbarlar.Sharif,raxbarlar.Tel,raxbarlar.Email
FROM oquvmarkazlar LEFT JOIN raxbarlar ON oquvmarkazlar.Raxbar_id = raxbarlar.Id", dataGridView1);
dataGridView1.Columns[5].Visible = false;
time.Text = DateTime.Now.ToLongTimeString();
date.Text = DateTime.Now.ToShortDateString();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" && comboBox1.Text != "Qidiruv turi")
{
if(comboBox1.Text == "Nomi")
selectAll("SELECT oquvmarkazlar.Id, oquvmarkazlar.Nomi, o‘quv
markazlar.Address,oquvmarkazlar.Tel,oquvmarkazlar.Email,raxbarlar.Ism,raxbarlar.Familiya,raxbarlar.Sharif,raxbarlar.Tel,raxbarlar.Email
FROM oquvmarkazlar LEFT JOIN raxbarlar ON oquvmarkazlar.Raxbar_id = raxbarlar.Id WHERE oquvmarkazlar.Nomi LIKE
'"+textBox1.Text+"'", dataGridView1);
if (comboBox1.Text == "Address")
selectAll("SELECT oquvmarkazlar.Id, oquvmarkazlar.Nomi,
oquvmarkazlar.Address,oquvmarkazlar.Tel,oquvmarkazlar.Email,raxbarlar.Ism,raxbarlar.Familiya,raxbarlar.Sharif,raxbarlar.Tel,raxbarlar.Email
FROM oquvmarkazlar LEFT JOIN raxbarlar ON oquvmarkazlar.Raxbar_id = raxbarlar.Id WHERE oquvmarkazlar.Address LIKE '" +
textBox1.Text + "'", dataGridView1);
if (comboBox1.Text == "Raxbari")
PAGE \* MERGEFORMAT1](https://docx.uz/documents/12a35ca2-2c58-48f4-af03-f6cbe28a3461/page_18.png?v=1)
![}
else
{
command = new MySqlCommand("UPDATE raxbarlar SET Ism = @Ism,Familiya = @Familiya,Sharif = @Sharif,Yosh = @Yosh,Tel =
@Tel,Email = @Email,Address = @Address WHERE Id = @Id", connection);
adapter = new MySqlDataAdapter(command); command.Parameters.Add("@Ism",textBox2.Text);
command.Parameters.Add("@Familiya", textBox3.Text);
command.Parameters.Add("@Sharif", textBox4.Text);
command.Parameters.Add("@Yosh", textBox5.Text);
command.Parameters.Add("@Tel", textBox6.Text);
command.Parameters.Add("@Email", textBox7.Text);
command.Parameters.Add("@Address", textBox8.Text);
command.Parameters.Add("@Id", id);
command.ExecuteNonQuery();
selectAll("SELECT * FROM raxbarlar",dataGridView2);
}
}
private void dataGridView2_CellMouseDoubleClick(object sender,
DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex >= 0)
{
rowIndex = e.RowIndex;
id = Convert.ToInt32(dataGridView2[0, rowIndex].Value);
DialogResult result = MessageBox.Show("Siz ushbu raxbar nomiga yangi o‘quv markaz ochmoqchimisiz ?", "ASKING",
MessageBoxButtons.YesNo, MessageBoxIcon.Information);
PAGE \* MERGEFORMAT1](https://docx.uz/documents/12a35ca2-2c58-48f4-af03-f6cbe28a3461/page_21.png?v=1)
![if (result == DialogResult.No)
{
textBox2.Text = dataGridView2[1, rowIndex].Value.ToString();
textBox3.Text = dataGridView2[2, rowIndex].Value.ToString();
textBox4.Text = dataGridView2[3, rowIndex].Value.ToString();
textBox5.Text = dataGridView2[4, rowIndex].Value.ToString();
textBox6.Text = dataGridView2[5, rowIndex].Value.ToString();
textBox7.Text = dataGridView2[6, rowIndex].Value.ToString();
textBox8.Text = dataGridView2[7, rowIndex].Value.ToString();
button3.Text = "Yangilash";
}
}
}
private void timer1_Tick(object sender, EventArgs e)
{
time.Text = DateTime.Now.ToLongTimeString();
date.Text = DateTime.Now.ToShortDateString();
}
private void button5_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Rostdan ham ushbu ma'lumolarni o‘chirvormqchimisiz ? ","ASKING" ,MessageBoxButtons.YesNo,
MessageBoxIcon.Information);
if (result == DialogResult.Yes)
{
PAGE \* MERGEFORMAT1](https://docx.uz/documents/12a35ca2-2c58-48f4-af03-f6cbe28a3461/page_22.png?v=1)
![command.Parameters.Add("@Email", textBox15.Text);
command.Parameters.Add("@Id", id);
command.ExecuteNonQuery();
selectAll("SELECT * FROM oqituvchilar", dataGridView3);
}
}
private void dataGridView3_CellClick(object sender, DataGridViewCellEventArgs
e)
{
if (e.RowIndex >= 0)
{
rowIndex = e.RowIndex;
id = Convert.ToInt32(dataGridView3[0, rowIndex].Value);
}
}
private void button7_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Rostdan ham ushbu ma'lumolarni o‘chirvormqchimisiz ? ", "ASKING", MessageBoxButtons.YesNo,
MessageBoxIcon.Information);
if (result == DialogResult.Yes)
{
InsertDelete("DELETE FROM oqituvchilar WHERE Id LIKE '" + id + "'");
selectAll("SELECT * FROM oqituvchilar", dataGridView3);
}
PAGE \* MERGEFORMAT1](https://docx.uz/documents/12a35ca2-2c58-48f4-af03-f6cbe28a3461/page_24.png?v=1)
O‘quv kurslari bilan shug‘ullanuvchi kompaniya ma’lumotlar bazasini yaratish