namespace final2 { public partial class Form1 : Form { private SqlConnection con; private SqlCommand command; private SqlDataAdapter adapter; private DataSet dataset; public DataGridView dg; public Form1() { InitializeComponent(); con = new SqlConnection(); command = con.CreateCommand(); con.ConnectionString = "Data Source=CASSINI-003-PC;Initial Catalog=studentdb;Integrated Security=True"; adapter = new SqlDataAdapter(command); dataset = new DataSet(); } private void button1_Click(object sender, EventArgs e) { command.Parameters.Clear(); command.Parameters.AddWithValue("@StudentID", textBox1.Text); command.Parameters.AddWithValue("@Name", textBox2.Text); command.Parameters.AddWithValue("@Age", textBox3.Text); command.Parameters.AddWithValue("@Gender", textBox4.Text); command.Parameters.AddWithValue("@Courseno", listBox1.SelectedItem); command.CommandText = "INSERT into details" + "(StudentID,Name,Age,Gender,Courseno)VALUES" + "(@StudentID,@Name,@Age,@Gender,@Courseno)"; try { con.Open(); int result = command.ExecuteNonQuery(); if (result > 0) MessageBox.Show("student successfully updated"); else MessageBox.Show("failed to update"); } catch (SqlException ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } ClearFields(); } private void button2_Click(object sender, EventArgs e) { command.Parameters.Clear(); command.Parameters.AddWithValue("@StudentID", textBox1.Text); command.CommandText = "SELECT * FROM details WHERE StudentID=@StudentID"; dataset.Tables.Clear(); int result = adapter.Fill(dataset, "details"); if (result > 0) { DataRow srow = dataset.Tables["details"].Rows[0]; textBox1.Text = srow["StudentID"].ToString(); textBox2.Text = srow["Name"].ToString(); textBox3.Text = srow["Age"].ToString(); textBox4.Text = srow["Gender"].ToString(); listBox1.SelectedItem = srow["Courseno"].ToString(); } else { MessageBox.Show("Student does not exist"); } } void ClearFields() { textBox1.Text = String.Empty; textBox2.Text = String.Empty; textBox3.Text = String.Empty; textBox4.Text = String.Empty; } private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { string currentitem = listBox1.SelectedItem.ToString(); } private void button3_Click(object sender, EventArgs e) { command.Parameters.Clear(); command.Parameters.AddWithValue("@Courseno", listBox1.SelectedValue); command.CommandText = "SELECT * FROM results WHERE Courseno=@Courseno"; try { con.Open(); command.ExecuteNonQuery(); } catch (SqlException ex) { MessageBox.Show(ex.Message); } adapter.Fill(dataset); dataGridView1.DataSource = dataset; } private void Form1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'studentdbDataSet1.result' table. You can move, or remove it, as needed. this.resultTableAdapter.Fill(this.studentdbDataSet1.result); } } }
private void button3_Click(object sender, EventArgs e) { //command.Parameters.AddWithValue("@Courseno", listBox1.SelectedValue); command.CommandText = "SELECT * FROM results WHERE Courseno = " + listBox1.SelectedValue; adapter.Fill(dataset); dataGridView1.DataSource = dataset; }
command.CommandText = "SELECT * FROM results WHERE Courseno = '" + listBox1.SelectedValue + "'";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)