Select conection string from label value c#

Goran Bibic

I have two conections added in app

"1.0" encoding="utf-8" ?>
"test_2017_2018.Properties.Settings.TEST_2017" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=2017;Integrated Security=True"
providerName="System.Data.SqlClient" />
"test_2017_2018.Properties.Settings.TEST_2018" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=2018;Integrated Security=True"
providerName="System.Data.SqlClient" />
"v4.0" sku=".NETFramework,Version=v4.6.1" />

Define conections in c# app winform

When login choose in combobox value (2017 or 2018)

Use that

That is ok...now i need

To fill datagrid

private void Izvjestajoprodanimartiklima()
{
using (SqlConnection openCon = new SqlConnection(PullData))
{
String saveStaff = "SELECT * from partners ";
Console.WriteLine(saveStaff);
openCon.Open();
using (SqlDataAdapter querySaveStaff = new SqlDataAdapter(saveStaff, cs))
{
DataTable dt = new DataTable();
DataColumn column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "Redni broj";
column.AutoIncrement = true;
column.AutoIncrementSeed = 1;
column.AutoIncrementStep = 1;
dt.Columns.Add(column);
int index = -1;
foreach (DataRow row in dt.Rows)
{
row.SetField(column, ++index);
}
querySaveStaff.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Update();
dataGridView1.Refresh();
}
}
}

Error is this line Pulldata when fill datagrid

Some help_

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Thank you

where did you calling PullData() method,

you have to call this on page load or before using connection

Error is

The ConnectionString property has not been initialized

Line 15

private void Izvjestajoprodanimartiklima()
{
using (SqlConnection openCon = new SqlConnection(con))
{
String saveStaff = "SELECT * from partners ";
Console.WriteLine(saveStaff);
openCon.Open();
using (SqlDataAdapter querySaveStaff = new SqlDataAdapter(saveStaff, con))
{
DataTable dt = new DataTable();
DataColumn column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "Redni broj";
column.AutoIncrement = true;
column.AutoIncrementSeed = 1;
column.AutoIncrementStep = 1;
dt.Columns.Add(column);
int index = -1;
foreach (DataRow row in dt.Rows)
{
row.SetField(column, ++index);
}
querySaveStaff.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Update();
dataGridView1.Refresh();
}
}
}

hi,

first modify below function

then modify below line