private SqlConnection konekDBnya()
{
SqlConnection koneksiAktip;
string dbName;
string instance;
string port;
string username;
string pass;
TextReader tR = new StreamReader("kasdanya.ini");
string reader = null;
List<settingList> grupSetting = new List<settingList>();
while ((reader = tR.ReadLine()) != null)
{
settingList itemSettingList = new settingList();
itemSettingList.iniFile = reader.ToString();
grupSetting.Add(itemSettingList);
}
dbName = grupSetting[0].iniFile.ToString();
instance = grupSetting[1].iniFile.ToString();
port = grupSetting[2].iniFile.ToString();
username = grupSetting[3].iniFile.ToString();
pass = grupSetting[4].iniFile.ToString();
tR.Close();
string koneksi = @"Initial Catalog=REALANGGAR;" +
@"Data Source=" + instance + "," + port + ";" +
@"User ID='" + username + "';" +
@"Password='******'";
koneksiAktip = new SqlConnection(koneksi);
return koneksiAktip;
}
private void fillTxt()
{
TextReader tR = new StreamReader("settings.ini");
string reader = null;
List<settingList> grupSetting = new List<settingList>();
while ((reader = tR.ReadLine()) != null)
{
settingList itemSettingList = new settingList();
itemSettingList.iniFile = reader.ToString();
grupSetting.Add(itemSettingList);
}
txtNama.Text = grupSetting[0].iniFile.ToString();
txtPort.Text = grupSetting[1].iniFile.ToString();
txtUser.Text = grupSetting[2].iniFile.ToString();
txtPass.Text = grupSetting[3].iniFile.ToString();
tR.Close();
}
