private void button1_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=DELL-PC\\SQLEXPRESS;Initial Catalog=NGOIdatabase;Integrated Security=True"); conn.Open(); try { SqlCommand comd = conn.CreateCommand(); comd.CommandType = CommandType.Text; DateTime d = Convert.ToDateTime(dateTimePicker1.Text); if (textBox1.Text == "") { //MessageBox.Show("I will create new"); comd.CommandText = "INSERT INTO Customers (Cus_name, Cus_phone, Date_created, Cus_address) values ('" + textBox2.Text + "','" + textBox3.Text + "','" + d.Year + "-" + d.Month + "-" + d.Day + "','" + textBox5.Text + "')"; } else { //MessageBox.Show("I will update"); comd.CommandText = "UPDATE Customers SET Cus_name='" + textBox2.Text + "',Cus_Phone='" + textBox3.Text + "',Cus_address='" + textBox5.Text + "',date_created='" + d.Year + "-" + d.Month + "-" + d.Day + "' where Cus_id=" + textBox1.Text; } comd.ExecuteNonQuery(); dataGridView1.DataSource = cdb.selectall(); conn.Close(); } catch (Exception e2) { MessageBox.Show(e2.Message); } reset_layout(); this.Close(); Customer a = new Customer(); a.Show(); }
private void Customer_Load(object sender, EventArgs e) { FormBorderStyle = FormBorderStyle.None; WindowState = FormWindowState.Maximized; TopMost = false; dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 10); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; customerdb cdb = new customerdb(); dataGridView1.DataSource = cdb.selectall(); }