private void btn_ConectaBD_Click(object sender, EventArgs e) { var appSettings = ConfigurationSettings.AppSettings; string result = appSettings["srcDB"] ?? "C:/SF/CardioSys/CardioSys.mdb"; string mensaje = ""; //public InfoDB(string src = "C:/CS/CardioSys.mdb", string user = "******", string pwd = "sfa080808528") //DBConnectClass db = new DBConnectClass("C:/CS/CardioSys.mdb", "sfa080808528"); DBConnectClass db = new DBConnectClass(result, "sfa080808528"); try { bool ok = db.Conecta(out mensaje); botonEstatus(ok); } catch (Exception ex) { } //MessageBox.Show(ok.ToString()+" /mensaje:\n"+mensaje, "Conexion", MessageBoxButtons.OK, MessageBoxIcon.Information); txt_respuesta.Text = ""; txt_respuesta.Text = mensaje; }
protected void yesDeleteASPxButton_Click(object sender, EventArgs e) { //replaySqlDataSource.InsertCommand = "Insert into tblmsgsyndicateReplay values(" + Session["ChassisID"] + //replaySqlDataSource.Insert(); //try //{ if (titleASPxTextBox.Text == string.Empty || ASPxHtmlEditor1.Html == null) { DisplayMessage("من فضلك قم بإدخال جميع البيانات المطلوبة المميزة بـ(*)", false); readMsgASPxPopupControl.ShowOnPageLoad = true; } else { // readSqlDataSource.InsertCommand = "insert into tblmsgsyndicateReplay values(" + Convert.ToInt32(Session["msgid"]) + "," + Convert.ToInt32(Session["SyndicateID"]) + ",'" + DateTime.Now + "','" + sendMsgASPxMemo.Text + "')"; // readSqlDataSource.Insert(); // replayMsgASPxPopupControl.ShowOnPageLoad = false; //}catch{} //if (Request.QueryString["CourseId"] == null) //{ // DisplayMessage("من فضلك اختار دوره قبل الارسال", false); // return; //}, string strInsert = @"Insert into TBLFriendsArticles(ArticleTitle,UserName) values('" + titleASPxTextBox.Text +"','"+Session["UserName"]+ "')"; DBConnectClass conn = new DBConnectClass("AriscFriend.mdb"); OleDbCommand cmd = new OleDbCommand(strInsert, DBConnectClass.conn); //friendsSqlDataSource.InsertCommand = ""; //friendsSqlDataSource.InsertCommand = strInsert; //friendsSqlDataSource.Insert(); cmd.ExecuteNonQuery(); OleDbDataAdapter da = new OleDbDataAdapter("select max(ArticleID) from TBLFriendsArticles", DBConnectClass.conn); DataTable dt=new DataTable(); da.Fill(dt); int id = Convert.ToInt32(dt.Rows[0][0]); string detailsFile = Server.MapPath("ArticleFiles\\" + id); File.WriteAllText(detailsFile, ASPxHtmlEditor1.Html); DSCdArticles.UpdateCommand = "update TBLFriendsArticles set ArticleDetailsFile='" + detailsFile + "' where ArticleID=" + id; DSCdArticles.Update(); //if (ResultMsg != string.Empty) //{ DisplayMessage("تم الحفظ بنجاح", false); readMsgASPxPopupControl.ShowOnPageLoad=true; //RBtnClear_Click(RBtnClear, new EventArgs()); //} //else // DisplayMessage(ResultMsg, false); } }
protected void yesDeleteASPxButton_Click(object sender, EventArgs e) { //replaySqlDataSource.InsertCommand = "Insert into tblmsgsyndicateReplay values(" + Session["ChassisID"] + //replaySqlDataSource.Insert(); //try //{ if (RTxtTraineeName.Text == string.Empty || RTxtNameInEnglish.Text == string.Empty || RCBCityId.Value == null || passwordASPxTextBox.Text == string.Empty || fieldRTxt.Text == string.Empty || phoneASPxTextBox.Text == string.Empty || genderASPxRadioButtonList.Value == null || jobRTxt.Text==string.Empty || emailASPxTextBox.Text == string.Empty|| EventImageTextBox.Text==string.Empty) { DisplayMessage("من فضلك قم بإدخال جميع البيانات المطلوبة المميزة بـ(*)", false); readMsgASPxPopupControl.ShowOnPageLoad = true; } else { // readSqlDataSource.InsertCommand = "insert into tblmsgsyndicateReplay values(" + Convert.ToInt32(Session["msgid"]) + "," + Convert.ToInt32(Session["SyndicateID"]) + ",'" + DateTime.Now + "','" + sendMsgASPxMemo.Text + "')"; // readSqlDataSource.Insert(); // replayMsgASPxPopupControl.ShowOnPageLoad = false; //}catch{} //if (Request.QueryString["CourseId"] == null) //{ // DisplayMessage("من فضلك اختار دوره قبل الارسال", false); // return; //} string strInsert = @"update TBLFriends set FriendArabicName='" + RTxtTraineeName.Text + "',FriendEnglishName='" + RTxtNameInEnglish.Text + "',GenderID=" + genderASPxRadioButtonList.Value + ",Mobile='" + phoneASPxTextBox.Text + "',Email='" + emailASPxTextBox.Text + "',FacebookEmail='" + facebookASPxTextBox.Text + "',City=" + RCBCityId.Value + ",FieldText='" + fieldRTxt.Text + "',JobName='" + jobRTxt.Text + "',Pass='******',Photo='" + EventImageTextBox.Text + "' where FriendID=" + ViewState["fid"]; DBConnectClass conn = new DBConnectClass("AriscFriend.mdb"); OleDbCommand cmd = new OleDbCommand(strInsert, DBConnectClass.conn); //friendsSqlDataSource.InsertCommand = ""; //friendsSqlDataSource.InsertCommand = strInsert; //friendsSqlDataSource.Insert(); cmd.ExecuteNonQuery(); string user = Session["UserName"].ToString(); string pass = passwordASPxTextBox.Text; string mail = emailASPxTextBox.Text ; //if (ResultMsg != string.Empty) //{ SendMail(user,pass,mail); DisplayMessage("تم الحفظ بنجاح و تم إرسال رسالة لكم بمعلومات الدخول على بريدكم الالكتروني", false); readMsgASPxPopupControl.ShowOnPageLoad=true; //RBtnClear_Click(RBtnClear, new EventArgs()); //} //else // DisplayMessage(ResultMsg, false); } }