Пример #1
0
        public void CallDB2(string strCodeSql, string msg)
        {
            try{
                SqlConnection con = new SqlConnection();


                //  string s3 = "Data Source=.;Initial Catalog=db2;Integrated Security=true;";
                //string s3 = @"provider=microsoft.jet.oledb.4.0;" + @"data source=..\\Debug\\db\\db2.mdb";


                string str1 = "";
                str1 = ConfigurationManager.ConnectionStrings["cn1"].ConnectionString;
                con  = new SqlConnection(str1);



                SqlCommand cmd = new SqlCommand(strCodeSql, con);
                con.Open();


                cmd.ExecuteNonQuery();

                MessageBoxFrmEx.Show(msg);

                con.Close();
            }
            catch (Exception er)
            {
                MessageBoxFrmEx.Show(er.Message.ToString(), "خطا ");
            }
        }
Пример #2
0
        public void CallDB2(string strCodeSql, string msg)
        {
            try
            {
                SqlConnection con = new SqlConnection();

                //  string s3 = "Data Source=.;Initial Catalog=db2;Integrated Security=true;";
                //string s3 = @"provider=microsoft.jet.oledb.4.0;" + @"data source=..\\Debug\\db\\db2.mdb";


                string str1 = "";
                str1 = ConfigurationManager.ConnectionStrings["cn1"].ConnectionString;
                con  = new SqlConnection(str1);



                SqlCommand cmd = new SqlCommand(strCodeSql, con);
                con.Open();


                cmd.ExecuteNonQuery();



                MessageBoxFrmEx.Show(msg);

                con.Close();

                // groupBox2.Enabled = false;
                //  groupBox3.Enabled = false;

                //  textBox1.Text = "";
                // textBox2.Text = "";
            }
            catch (Exception er)
            {
                // MsgBox.ShowMessage(this.Handle.ToInt32(), er.Message.ToString(), "خطا ", "تایید", "", "", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RightAlign);

                MessageBoxFrmEx.Show(er.Message.ToString(), "خطا ");
            }
        }