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;
}
}
