I create class
class ConnectionClass
{
static string BSS_2019 = Properties.Settings.Default.MG_SISTEM_2019CS;
static string con;
public static string PullData(string numYear)
{
switch (numYear)
{
case "2019":
con = BSS_2019;
break;
}
return con;
}
}
How to implement to forms?
I put in from
string conString = ConnectionClass.PullData(yearlabel.Text);
Butt error is
connection string proprerty has not intialized.
private void Ulazni_racun_roba_lista_fill()
{
string conString = ConnectionClass.PullData(godinalabel.Text);
using (SqlConnection openCon = new SqlConnection(conString))
{
String saveStaff = "SELECT * from dbo.popis_lista";
Console.WriteLine(saveStaff);
openCon.Open();
using (SqlDataAdapter querySaveStaff = new SqlDataAdapter(saveStaff, conString))
{
DataTable dt = new DataTable();
querySaveStaff.Fill(dt);
PopisListaDataGridView.DataSource = dt;
PopisListaDataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
PopisListaDataGridView.Update();
PopisListaDataGridView.Refresh();
}
}
}