private void label3_Click(object sender, EventArgs e) { StudenHome Peron = new StudenHome(); this.Hide(); Peron.Show(); }
private void cmdInfo_Click(object sender, EventArgs e) { try { String str = "Data Source=HAIER-PC\\NIMRASQLSERVER;Initial Catalog=ProjectA;Integrated Security=True"; String query = "INSERT INTO Student (Id,RegistrationNo)VALUES((select MAX(Id) FROM Person),('" + (txtRegno.Text).ToString() + "'));"; SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("Data insert"); StudenHome Info = new StudenHome(); this.Hide(); Info.Show(); con.Close(); } catch (Exception es) { MessageBox.Show(es.Message); } }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { //label1.Show(); //label2.Show(); //label3.Show(); //textBox1.Show(); //textBox2.Show(); //comboBox1.Show(); String str = "Data Source=HAIER-PC\\NIMRASQLSERVER;Initial Catalog=ProjectA;Integrated Security=True"; SqlConnection con = new SqlConnection(str); con.Open(); if (e.RowIndex >= 0 && e.ColumnIndex == 9) { DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex]; String query = "Delete from Student where Id = '" + row.Cells[0].Value + "';"; String query1 = "Delete from Person where Id = '" + row.Cells[0].Value + "';"; String query2 = "Delete from GroupStudent where StudentId = '" + row.Cells[0].Value + "';"; SqlCommand cmd = new SqlCommand(query2, con); cmd.ExecuteNonQuery(); SqlCommand cmd1 = new SqlCommand(query, con); cmd1.ExecuteNonQuery(); SqlCommand cmd2 = new SqlCommand(query1, con); cmd2.ExecuteNonQuery(); MessageBox.Show("Student is deleted"); StudenHome ne = new StudenHome(); this.Hide(); ne.Show(); } if (e.RowIndex >= 0 && e.ColumnIndex == 8) { //Editstudent edit = new Editstudent(); panel1.Show(); textBox5.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); textBox1.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString(); textBox2.Text = this.dataGridView1.CurrentRow.Cells[3].Value.ToString(); textBox3.Text = this.dataGridView1.CurrentRow.Cells[4].Value.ToString(); textBox4.Text = this.dataGridView1.CurrentRow.Cells[6].Value.ToString(); dateTimePicker1.Text = this.dataGridView1.CurrentRow.Cells[5].Value.ToString(); comboBox1.Text = this.dataGridView1.CurrentRow.Cells[7].Value.ToString(); //edit.Show(); } } catch (Exception es) { MessageBox.Show(es.Message); } }
private void button1_Click(object sender, EventArgs e) { try { int key = Convert.ToInt32(textBox5.Text); String str = "Data Source=HAIER-PC\\NIMRASQLSERVER;Initial Catalog=ProjectA;Integrated Security=True"; String query = "Update Person Set FirstName=('" + textBox1.Text.ToString() + "'),LastName=('" + textBox2.Text.ToString() + "'),Contact=('" + textBox3.Text.ToString() + "'),Email=('" + textBox4.Text.ToString() + "'),DateOfBirth=('" + Convert.ToDateTime(dateTimePicker1.Text) + "'),Gender=(select Id from Lookup where Lookup.Value ='" + comboBox1.Text + "') where Id = '" + Convert.ToInt32(textBox5.Text) + "';"; SqlConnection con = new SqlConnection(str); SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("Data Updated"); con.Close(); panel1.Hide(); StudenHome ne = new StudenHome(); this.Hide(); ne.Show(); } catch (Exception es) { MessageBox.Show(es.Message); } }