private void تعديل_البطاقة_العلاجية_لمريض_Load(object sender, EventArgs e) { con.OpenConection(); MessageBox.Show(f.ToString()); try { string[] s = new string[] { "@x" }; string[] s2 = new string[] { f.ToString() }; SqlDbType[] s3 = new SqlDbType[] { SqlDbType.VarChar }; dataGridView1.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("update_medical_card", s, s2, s3); } catch (Exception ex) { MessageBox.Show(ex.Message); } //Connection con = new Connection("server=localhost,database=hospital,uid=); //MySqlDataAdapter da = new MySqlDataAdapter("select *from Registeration_patientRegisteration where patient_id=f", con); //DataSet c= new DataSet(); //dataGridView1.DataSource = c.Tables[0]; }
private void Form30_Load(object sender, EventArgs e) { con.OpenConection(); dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("productt"); con.CloseConnection(); //dataGridView1.DataSource = null; //ds.Tables.Clear(); //dataGridView1.Rows.Clear(); //dataGridView1.Refresh(); //SqlCommand cmd = new SqlCommand("productt", con); //cmd.CommandType = CommandType.StoredProcedure; //da = new SqlDataAdapter(cmd); //SqlCommandBuilder cb = new SqlCommandBuilder(da); //da.Fill(ds); //dataGridView1.DataSource = ds.Tables[0]; }
private void Form36_Load(object sender, EventArgs e) { con.OpenConection(); dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("fservice"); con.CloseConnection(); //dataGridView1.DataSource = null; //ds.Tables.Clear(); //dataGridView1.Rows.Clear(); //dataGridView1.Refresh(); //SqlCommand cmd = new SqlCommand("fservice", con); //cmd.CommandType = CommandType.StoredProcedure; //da = new SqlDataAdapter(cmd); ////da = new SqlDataAdapter("select * from services", @"Server=DEMIANA\SQLEXPRESS;Database=PHIS;integrated security=true"); //SqlCommandBuilder cb = new SqlCommandBuilder(da); //da.Fill(ds); //dataGridView1.DataSource = ds.Tables[0]; }
private void label3_Click(object sender, EventArgs e) { connect.OpenConection(); string procName = "Traing_Jobs"; string[] paramNames = { }; string[] paramValues = { }; SqlDbType[] paramType = { }; dataGridView1.DataSource = connect.ShowDataInGridViewUsingStoredProc(procName); /* * connect.ShowDataInGridViewUsingStoredProc(procName); * connect.ShowDataInGridViewUsingStoredProc(procName, paramNames, paramValues, paramType); * connect.ExecuteInsertOrUpdateOrDeleteUsingStoredProc(procName, paramNames, paramValues, paramType); */ connect.CloseConnection(); }
private void A_FRM_Accommodation_Degree_Load(object sender, EventArgs e) { #region object x = new object(); try { con.OpenConection(); x = con.ShowDataInGridViewUsingStoredProc("sp_Accommodation_Degrees_Select"); dt = (DataTable)x; DGV.DataSource = dt; } catch (Exception) { throw; } #endregion }
private void radiology_Load(object sender, EventArgs e) { Connection con = new Connection(); try { con.OpenConection(); object dt = con.ShowDataInGridViewUsingStoredProc("radiology"); reportViewer1.LocalReport.DataSources.Clear(); var rtds = new ReportDataSource("DataSet1", dt); reportViewer1.LocalReport.DataSources.Add(rtds); reportViewer1.RefreshReport(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.CloseConnection(); } }
private void Salvage_Report_Load(object sender, EventArgs e) { this.reportViewer1.RefreshReport(); Connection sqlCon = new Connection(); try { sqlCon.OpenConection(); object xx = sqlCon.ShowDataInGridViewUsingStoredProc("asset_sal_select"); comboBox1.DataSource = xx; comboBox1.ValueMember = "code"; comboBox1.DisplayMember = "arabic_name"; label2.DataBindings.Add("text", xx, "code"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sqlCon.CloseConnection(); } }
private void button4_Click(object sender, EventArgs e) { Connection mycon = new Connection(); mycon.OpenConection(); //con.Open(); string[] pname = { "@id_dif" }; string[] pvalue = { textBox3.Text }; SqlDbType[] ptype = { SqlDbType.Int }; DataTable dt = (DataTable)mycon.ShowDataInGridViewUsingStoredProc("p10", pname, pvalue, ptype); //SqlDataReader dr = dt.CreateDataReader(); for (int i = 0; i < dt.Rows.Count; i++) { comboBox1.Items.Add(dt.Rows[i].ItemArray[i].ToString()); } mycon.CloseConnection(); // rd.Close(); /* * conn.Open(); * * SqlDataReader rd; * * conn.Open(); * SqlCommand cmd = new SqlCommand("p10", conn); * cmd.CommandType = CommandType.StoredProcedure; * cmd.Parameters.AddWithValue("@id_dif", textBox3.Text); * //string s = "select select all from differentservices where id_differentservices ="+textBox3.Text+" ;"; * //SqlCommand cmd = new SqlCommand(s, conn); * * rd = cmd.ExecuteReader(); * while (rd.Read()) * { * * comboBox1.Items.Add(rd["select all"]); * * } * * rd.Close(); * rd.Dispose(); * conn.Close();*/ }
private void label3_Click(object sender, EventArgs e) { connect.OpenConection(); string procName = "TRAINING_COURSE_NAMETRAININGCOURSE"; string[] paramNames = { }; //"@cl_name" }; string[] paramValues = { }; //textBox2.Text }; SqlDbType[] paramType = { }; //SqlDbType.VarChar }; dataGridView1.DataSource = connect.ShowDataInGridViewUsingStoredProc(procName); /* * connect.ShowDataInGridViewUsingStoredProc(procName); * connect.ShowDataInGridViewUsingStoredProc(procName, paramNames, paramValues, paramType); * connect.ExecuteInsertOrUpdateOrDeleteUsingStoredProc(procName, paramNames, paramValues, paramType); */ connect.CloseConnection(); }
private void button1_Click(object sender, EventArgs e) { try { con.OpenConection(); String[] x = { dateTimePicker1.Value.ToString(), dateTimePicker2.Value.ToString() }; String[] y = { "@x", "@y" }; SqlDbType [] z = { SqlDbType.Date, SqlDbType.Date }; object dt = con.ShowDataInGridViewUsingStoredProc("demand_account", y, x, z); reportViewer1.LocalReport.DataSources.Clear(); var rtds = new ReportDataSource("DataSet1", dt); reportViewer1.LocalReport.DataSources.Add(rtds); reportViewer1.RefreshReport(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.CloseConnection(); } this.reportViewer1.RefreshReport(); }
private void catogrical_reservation_Load(object sender, EventArgs e) { // con = new MySqlConnection("server=localhost;uid=root;pwd=root;database=hospital1"); con.OpenConection(); dataGridView1.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("cateogirical_reservation"); //string s = "select catog_code as 'كود الجهه',name as 'اسم الجهه' from catogricals;"; //cmd = new MySqlCommand(s, con); //MySqlDataReader dr = cmd.ExecuteReader(); //DataTable d = new DataTable(); //d.Load(dr); //dataGridView1.DataSource = d; //dr.Close(); //con.Close(); con.CloseConnection(); }
private void الاطباء_Load(object sender, EventArgs e) { con.OpenConection(); dataGridView1.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("emergency_doctor1"); //con = new MySqlConnection("server=localhost;uid=root;pwd=root;database=hospital1"); //con.Open(); //string s = "select doctor_code as 'كود الطبيب',doctor_name as 'اسم الطبيب' from doctors;"; //cmd = new MySqlCommand(s, con); //MySqlDataReader dr = cmd.ExecuteReader(); //DataTable d = new DataTable(); //d.Load(dr); //dataGridView1.DataSource = d; //dr.Close(); //con.Close(); con.CloseConnection(); }
private void button1_Click(object sender, EventArgs e) { try { con.OpenConection(); //not find table [0] string[] pramname = new string[6]; string[] pramvalue = new string[6]; SqlDbType[] pramtype = new SqlDbType[6]; pramname[0] = "@x1"; pramname[1] = "@x2"; pramname[2] = "@x3"; pramname[3] = "@x4"; pramname[4] = "@x5"; pramname[5] = "@x6"; pramvalue[0] = comboBox2.SelectedItem.ToString(); pramvalue[1] = textBox1.Text; pramvalue[2] = comboBox1.SelectedItem.ToString(); pramvalue[3] = dateTimePicker4.Value.ToString(); pramvalue[4] = dateTimePicker1.Value.ToString(); pramvalue[5] = textBox3.Text; pramtype[0] = SqlDbType.VarChar; pramtype[1] = SqlDbType.Int; pramtype[2] = SqlDbType.VarChar; pramtype[3] = SqlDbType.VarChar; pramtype[4] = SqlDbType.VarChar; pramtype[5] = SqlDbType.Int; //con.OpenConection(); dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("Cancel_claims_delivery", pramname, pramvalue, pramtype); //MessageBox.Show(""); con.CloseConnection(); } catch (Exception) { MessageBox.Show("من فضلك ادخل البيانات كاملة "); } }
private void btn_search_Click(object sender, EventArgs e) { try { connect.OpenConection(); string pName = "planing_job_name"; string[] paramNames = { "@j_code" }; string[] paramValues = { textBox2.Text }; SqlDbType[] paramType = { SqlDbType.VarChar }; dataGridView1.DataSource = connect.ShowDataInGridViewUsingStoredProc(pName, paramNames, paramValues, paramType); } catch (Exception) { MessageBox.Show("قم بادخال الكود للبحث "); } connect.CloseConnection(); }
private void A_FRM_Contracting_Entities_Load(object sender, EventArgs e) { object x = new object(); try { con.OpenConection(); x = con.ShowDataInGridViewUsingStoredProc("sp_Contracting_Entities_Select"); dt = (DataTable)x; DGV.DataSource = dt; DGV.Columns[0].HeaderText = "الكود"; DGV.Columns[1].HeaderText = "الاسم العربى"; DGV.Columns[2].HeaderText = "الاسم اللاتينى"; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public void generate_reports() { Connection sqlCon = new Connection(); try { sqlCon.OpenConection(); object dt = sqlCon.ShowDataInGridViewUsingStoredProc("asset_report"); reportViewer1.LocalReport.DataSources.Clear(); var rtds = new ReportDataSource("DataSet1", dt); reportViewer1.LocalReport.DataSources.Add(rtds); reportViewer1.RefreshReport(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sqlCon.CloseConnection(); } }
private void button1_Click(object sender, EventArgs e) { con.OpenConection(); try { dataGridView1.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("disp_emergency_services"); // string s = "select serv_code as 'كود الخدمة',serv_name as 'اسم الخدمة',serv_time as 'توقيت الخدمة' from emergency_emergency_services;"; // cmd1 = new MySqlCommand(s, con); // dr = cmd1.ExecuteReader(); // DataTable dt = new DataTable(); // dt.Load(dr); // dataGridView1.DataSource = dt; // dr.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } con.CloseConnection(); }
private void button1_Click(object sender, EventArgs e) { try { x.OpenConection(); String[] arr1 = { "@z" }; String[] arr2 = { comboBox1.SelectedItem.ToString() }; SqlDbType[] arr3 = { SqlDbType.Int }; object dt = x.ShowDataInGridViewUsingStoredProc("spgy", arr1, arr2, arr3); reportViewer1.LocalReport.DataSources.Clear(); var rtds = new ReportDataSource("DataSet1", dt); reportViewer1.LocalReport.DataSources.Add(rtds); reportViewer1.RefreshReport(); } catch (Exception ex) { MessageBox.Show(" من فضلك أدخل السنة "); } }
private void toolStripLabel2_Click(object sender, EventArgs e) { string[] a = { name.Text, website.Text, address.Text, type.Text, natureOfActivity.Text, e_mail.Text, phoneNumber.Text }; string[] b = { "@name", "@website", "@address", "@type", "@natureOfActivity", "@e_mail", "@phoneNumberint" }; SqlDbType[] c = { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Int }; conn.OpenConection(); conn.ShowDataInsertUsingStoredProc("supplier_insert", b, a, c); conn.CloseConnection(); conn.OpenConection(); dataGridView1.DataSource = conn.ShowDataInGridViewUsingStoredProc("supplier_Select"); clear.Clear(this); conn.CloseConnection(); }
private void button1_Click(object sender, EventArgs e) { Connection con = new Connection(); con.OpenConection(); if (con.DataReader("pharmacy_select_patientDescription").HasRows) { con.ShowDataInGridViewUsingStoredProc("pharmacy_select_patientDescription"); } else { MessageBox.Show("لا يوجد مرضى....."); } //cmd = new SqlCommand("select visit_id as 'رقم الزيارة', entranceoffice_visit.pat_id As ' رقم المريض ', Registeration_patientRegisteration.patient_name as ' اسم المريض' from follow_up_sheet_slected_med, follow_up_sheet, entranceoffice_visit,Registeration_patientRegisteration where follow_up_sheet_slected_med.inventry_id=follow_up_sheet.inventry_id and follow_up_sheet.inventry_id=entranceoffice_visit.visit_id and entranceoffice_visit.pat_id=Registeration_patientRegisteration.patient_id", connection); //dr = cmd.ExecuteReader(); //DataTable dt = new DataTable(); //dt.Load(dr); //dataGridView1.DataSource = dt; //dr.Close(); }
private void button1_Click(object sender, EventArgs e) { Connection con = new Connection(); try { con.OpenConection(); String [] a = { "@x", "@y" }; String [] b = { dateTimePicker1.Value.ToString(), dateTimePicker2.Value.ToString() }; SqlDbType[] c = { SqlDbType.Date, SqlDbType.Date }; object dt = con.ShowDataInGridViewUsingStoredProc("occupation_rate", a, b, c); reportViewer1.LocalReport.DataSources.Clear(); var rtds = new ReportDataSource("DataSet1", dt); reportViewer1.LocalReport.DataSources.Add(rtds); reportViewer1.RefreshReport(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.CloseConnection(); } }
private void lab_serviceName_Load(object sender, EventArgs e) { Connection con = new Connection(); try { con.OpenConection(); //SqlCommand cmd = new SqlCommand("lab_serviceName", con); //cmd.CommandType = CommandType.StoredProcedure; //SqlDataReader dr = cmd.ExecuteReader(); //DataTable dt = new DataTable(); //dt.Load(dr); object dt = con.ShowDataInGridViewUsingStoredProc("lab_serviceName"); reportViewer1.LocalReport.DataSources.Clear(); var rtds = new ReportDataSource("DataSet1", dt); reportViewer1.LocalReport.DataSources.Add(rtds); reportViewer1.RefreshReport(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.CloseConnection(); } }
private void button1_Click(object sender, EventArgs e) { try { int device_code = int.Parse(comboBox3.SelectedValue.ToString()); string[] pramname = new string[1]; string[] pramvalue = new string[1]; SqlDbType[] pramtype = new SqlDbType[1]; pramname[0] = "@Device_code"; pramvalue[0] = device_code.ToString(); pramtype[0] = SqlDbType.Int; con.OpenConection(); dt.Clear(); object x = new object(); x = con.ShowDataInGridViewUsingStoredProc("physiotherapy_execute_plan_select", pramname, pramvalue, pramtype);; dataGridView1.DataSource = (DataTable)x; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.CloseConnection(); } }
private void button1_Click(object sender, EventArgs e) { try { string[] s = new string[] { "@g", "@x", "@y" }; string[] s2 = new string[] { comboBox1.Text, textBox1.Text, textBox2.Text }; SqlDbType[] s3 = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.Int, SqlDbType.Int }; dataGridView1.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("registration_report_list", s, s2, s3); //string s = "select patient_name,address_of_patient,nationality ,marital_status from Registeration_patientRegisteration where gender=@g and age between @x and @y"; //cmd = new MySqlCommand(s, con); //cmd.Parameters.AddWithValue("@g", comboBox1.SelectedItem); //cmd.Parameters.AddWithValue("@x", textBox1.Text); //cmd.Parameters.AddWithValue("@y", textBox2.Text); //da = new MySqlDataAdapter(cmd); //MySqlCommandBuilder cb = new MySqlCommandBuilder(da); //da.Fill(ds); //bs.DataSource = ds.Tables[0]; //dataGridView1.DataSource = bs; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Form1_Load(object sender, EventArgs e) { sqlCon.OpenConection(); String[] a = { "@table" }; String[] b = { "asset_store" }; SqlDbType[] c = { SqlDbType.NVarChar }; object dt = sqlCon.ShowDataInGridViewUsingStoredProc("asset_get_code", a, b, c); DataTable dtt = (DataTable)dt; int code = 0; if (dtt.Rows.Count != 0) { code = Convert.ToInt32(dtt.Rows[0][0]) + 1; } else { code = 1; } textBox1.Text = code.ToString(); }
private void حذفToolStripMenuItem_Click(object sender, EventArgs e) { con.OpenConection(); string[] pramname = new string[1]; string[] pramvalue = new string[2]; SqlDbType[] pramtype = new SqlDbType[1]; pramname[0] = "@x"; pramvalue[0] = textBox1.Text; pramtype[0] = SqlDbType.Int; object x = new object(); con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentPhoto_deleteRecord_byID", pramname, pramvalue, pramtype); MessageBox.Show("تم عمليه الحذف بنجاح"); con.CloseConnection(); }
private void button1_Click(object sender, EventArgs e) { try { sqlCon.OpenConection(); String[] a = { "@t", "@c", "@ar", "@la", "@flag" }; String[] b = { "asset_re_evaluation_reasons", "0", textBox2.Text, textBox3.Text, "0" }; if (textBox1.Text != "") { b[4] = "1"; b[1] = textBox1.Text; } SqlDbType[] c = { SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int }; dataGridView1.DataSource = sqlCon.ShowDataInGridViewUsingStoredProc("search_conditional1", a, b, c); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sqlCon.CloseConnection(); } }
private void button1_Click(object sender, EventArgs e) { con.OpenConection(); try { dataGridView1.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("add_emegency_doctors_dispaly"); //string s = "select * from emergency_emergency_doctors;"; //cmd1 = new MySqlCommand(s, con); //dr = cmd1.ExecuteReader(); //DataTable d = new DataTable(); //d.Load(dr); //dataGridView1.DataSource = d; //dr.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } con.CloseConnection(); }
private void Form22_Load(object sender, EventArgs e) { try { con.OpenConection(); dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("bill_show"); con.CloseConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.CloseConnection(); } //dataGridView1.DataSource = null; //ds.Tables.Clear(); //dataGridView1.Rows.Clear(); //dataGridView1.Refresh(); //da = new SqlDataAdapter("bill_show", con); //SqlCommandBuilder cb = new SqlCommandBuilder(da); //da.Fill(ds); //dataGridView1.DataSource = ds.Tables[0]; }
private void Form13_Load(object sender, EventArgs e) { /*dataGridView1.DataSource = null; * ds.Tables.Clear(); * dataGridView1.Rows.Clear(); * dataGridView1.Refresh(); * da = new sqlDataAdapter("select * from subactor", "server=localhost;database=final;uid=root;pwd=root"); * sqlCommandBuilder cb = new sqlCommandBuilder(da); * da.Fill(ds); * dataGridView1.DataSource = ds.Tables[0];*/ try { con.OpenConection(); dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("data_subactor"); con.CloseConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.CloseConnection(); } }