public static LoginDS Load() { LoginDS dsProfile = new LoginDS(); FileStream fsWriteXml = new FileStream(ProfilePath, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite); try { if (fsWriteXml.Length < 10) { LoginDS.DBProfileRow row = dsProfile.DBProfile.NewDBProfileRow(); row.DataBase = ""; row.DBLogin = "******"; row.DBPassword = ""; row.ServerName = "localhost\\SQLExpress"; dsProfile.DBProfile.Rows.Add(row); dsProfile.WriteXml(fsWriteXml, XmlWriteMode.WriteSchema); } else { dsProfile.ReadXml(fsWriteXml); } fsWriteXml.Close(); return(dsProfile); } catch { dsProfile.WriteXml(fsWriteXml, XmlWriteMode.WriteSchema); return(dsProfile); } }
private void btnCheck_Click(object sender, EventArgs e) { bool IsChk = true; try { dbConString.ServerName = txtServerName.Text.Trim(); dbConString.DBName = txtDatabaseName.Text.Trim(); dbConString.Sa = txtUsername.Text.Trim(); dbConString.SaPassword = txtPassword.Text.Trim(); IsChk = dbConString.CheckOpenConn(); if (IsChk) { if (tblLogin.DBProfile.Count > 0) { tblLogin.DBProfile[0].ServerName = txtServerName.Text.Trim(); tblLogin.DBProfile[0].DataBase = txtDatabaseName.Text.Trim(); tblLogin.DBProfile[0].DBLogin = txtUsername.Text.Trim(); tblLogin.DBProfile[0].DBPassword = txtPassword.Text.Trim(); } else { LoginDS.DBProfileRow dr = tblLogin.DBProfile.NewDBProfileRow(); dr.ServerName = txtServerName.Text.Trim(); dr.DataBase = txtDatabaseName.Text.Trim(); dr.DBLogin = txtUsername.Text.Trim(); dr.DBPassword = txtPassword.Text.Trim(); tblLogin.DBProfile.AddDBProfileRow(dr); } ProfileConfig.Save(tblLogin); MessageBox.Show("บันทึกข้อูลตั้งค่า ระบบฐานข้อมูล", "POS_Smart", MessageBoxButtons.OK); } } catch { MessageBox.Show("ข้อูลตั้งค่า ระบบฐานข้อมูล ไม่ถูกต้องกรุณาตรวจสอบ", "คำเตือน", MessageBoxButtons.OK); txtServerName.Focus(); return; } }