private void Btndelete_Click(object sender, EventArgs e) { if (Txt_co_name.Text == "") { MessageBox.Show("نام شرکتی که می خواهید حذف شود را وارد نمایید"); Txt_co_name.Focus(); return; } if (MessageBox.Show("آیا از حذف این رکورد مطمئن هستید؟", "دقت کنید", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { SqlConnection cn = new SqlConnection(); cn.ConnectionString = @"Data Source=.;Initial Catalog=arsyserp;Integrated Security=True"; cn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandText = "delete from [dbo].[Table_presentedco] where [corporation_name]='" + Txt_co_name.Text + "'"; cmd.ExecuteNonQuery(); Txt_co_name.Text = ""; combo_work.Text = ""; Txt_contact.Text = ""; datepickerpresent.Text = ""; combo_res.Text = ""; Txt_coadress.Text = ""; Txt_description.Text = ""; Txt_co_name.Focus(); Namayesh(); } else { Txt_co_name.Focus(); } }
private void button2_Click(object sender, EventArgs e) { Namayesh(); Txt_co_name.Text = ""; combo_work.Text = ""; Txt_contact.Text = ""; datepickerpresent.Text = ""; combo_res.Text = ""; Txt_coadress.Text = ""; Txt_description.Text = ""; Txt_co_name.Focus(); }
private void Btnedith_Click(object sender, EventArgs e) { SqlConnection cn = new SqlConnection(); cn.ConnectionString = @"Data Source=.;Initial Catalog=arsyserp;Integrated Security=True"; cn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandText = "update [dbo].[Table_presentedco] set [corporation_name]='" + Txt_co_name.Text + "',[field]='" + combo_work.Text + "',[contact_info]='" + Txt_contact.Text + "',[date]='" + datepickerpresent.Text + "',[result]='" + combo_res.Text + "',[adress]='" + Txt_coadress.Text + "',[description]='" + Txt_description.Text + "'where corporation_name='" + Txt_co_name.Text + "'"; cmd.ExecuteNonQuery(); Txt_co_name.Text = ""; combo_work.Text = ""; Txt_contact.Text = ""; datepickerpresent.Text = ""; combo_res.Text = ""; Txt_coadress.Text = ""; Txt_description.Text = ""; Txt_co_name.Focus(); Namayesh(); }
private void btnsave_Click(object sender, EventArgs e) { if (Txt_co_name.Text == "") { MessageBox.Show("لطفا نام شرکت را وارد نمایید"); Txt_co_name.Focus(); return; } if (combo_work.Text == "") { MessageBox.Show("لطفا زمینه فعالیت شرکت را وارد نمایید"); combo_work.Focus(); return; } if (Txt_contact.Text == "") { MessageBox.Show("لطفا شماره تماس شرکت را وارد نمایید"); Txt_contact.Focus(); return; } SqlConnection cn = new SqlConnection(); cn.ConnectionString = @"Data Source=.;Initial Catalog=arsyserp;Integrated Security=True"; cn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandText = "INSERT INTO [dbo].[Table_presentedco]([corporation_name],[field],[contact_info],[date],[result],[adress],[description]) VALUES('" + Txt_co_name.Text + "','" + combo_work.Text + "','" + Txt_contact.Text + "','" + datepickerpresent.Text + "','" + combo_res.Text + "','" + Txt_coadress.Text + "','" + Txt_description.Text + "')"; cmd.ExecuteNonQuery(); Txt_co_name.Text = ""; combo_work.Text = ""; Txt_contact.Text = ""; datepickerpresent.Text = ""; combo_res.Text = ""; Txt_coadress.Text = ""; Txt_description.Text = ""; Txt_co_name.Focus(); Namayesh(); }
private void button1_Click(object sender, EventArgs e) { SqlConnection cn = new SqlConnection(); cn.ConnectionString = @"Data Source=.;Initial Catalog=arsyserp;Integrated Security=True"; cn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cn; cmd.CommandText = "select * [dbo].[Table_presentedco] where [corporation_name]='" + Txt_co_name.Text + "'"; SqlDataAdapter da = new SqlDataAdapter(cmd.CommandText, cn); DataTable dt = new DataTable(); da.Fill(dt); dataGridView1.DataSource = dt; if (Txt_co_name.Text == "") { MessageBox.Show("نام شرکتی که می خواهید جست و جو شود را وارد نمایید"); Txt_co_name.Focus(); return; } }