private void cmdOk_Click(object sender, EventArgs e) { string strSql = null; dynamic intRowsAffected = null; try { using (OleDbConnection cnOle = new OleDbConnection(MyModules.MSAccessCn)) { cnOle.Open(); strSql = "UPDATE SvrParam SET [ServerName] = '" + cboServerName.Text.Trim() + "', [UserID] = '" + txtUserID.Text.Trim() + "' ,[Password] = '" + txtPassword.Text.Trim() + "' ,[AttachName] = '" + txtAttachName.Text.Trim() + "',[IntegratedSecurity] = " + chkWinAuthen.Checked + " ,[Owner] = '" + txtOwner.Text.Trim() + "'"; OleDbCommand cmOle = new OleDbCommand(strSql, cnOle); intRowsAffected = cmOle.ExecuteNonQuery(); cnOle.Close(); cmOle.Dispose(); cnOle.Dispose(); MyModules.InitialiseEntireSystem(); MessageBox.Show("Update Successfull" + char.ConvertFromUtf32(13) + "Pls. Restart", MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information); //InitialiseEntireSystem() System.Environment.Exit(0); //Me.Close() } if (intRowsAffected != 1) { MessageBox.Show("Update Failed.", MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception er) { MessageBox.Show(er.Message, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void cmdOk_Click(object sender, EventArgs e) { try { SqlConnection cnSQL = new SqlConnection(MyModules.strConnect); SqlCommand cmSQL = new SqlCommand("FetchUserAccessByPwd", cnSQL); // SqlDataReader drSQL; cnSQL.Open(); byte[] arrayLogo = { 0 }; //byte[] arrayLogo = null; if ((OwnerLogo.Image == null) == false) { using (MemoryStream m = new MemoryStream()) { OwnerLogo.Image.Save(m, System.Drawing.Imaging.ImageFormat.Jpeg); //image.Save(m, image.RawFormat); arrayLogo = m.ToArray(); } } cmSQL.CommandText = "UpdateSysParam4CoySetup"; cmSQL.CommandType = CommandType.StoredProcedure; cmSQL.Parameters.AddWithValue("@NName", tName.Text); cmSQL.Parameters.AddWithValue("@Address", tAddress.Text); cmSQL.Parameters.AddWithValue("@Phone", tPhone.Text); cmSQL.Parameters.AddWithValue("@Email", temail.Text); cmSQL.Parameters.AddWithValue("@wwweb", tWebsite.Text); cmSQL.Parameters.AddWithValue("@logo", arrayLogo); cmSQL.Parameters.AddWithValue("@eDocPath", tDocFile.Text); cmSQL.Parameters.AddWithValue("@BackupPath", tBackupPath.Text); cmSQL.ExecuteNonQuery(); //cmSQL.Connection.Close() cmSQL.Dispose(); // cnSQL.Close() //cnSQL.Dispose() MyModules.InitialiseEntireSystem(); MessageBox.Show("Pls. restart...", MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information); System.Environment.Exit(1); return; } catch (Exception ex) { MessageBox.Show("Ooops! ERROR :" + char.ConvertFromUtf32(13) + ex, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } }