Conect manualy from MS sql to datagrid?

I need to conect line 8 and statement from line 13 to end

private void trenutne_zalihe2()
{
using (SqlConnection openCon = new SqlConnection(cs))
{
string saveStaff = "Select id as 'id', roba as 'Naziv artikla', kolicina as 'Kolicina' from mp_faktura_roba";
using (SqlDataAdapter querySaveStaff = new SqlDataAdapter(saveStaff, cs))
{
DataTable dt = new DataTable();
querySaveStaff.Fill(dt);
trenutnazalihadataGridView.DataSource = dt;
trenutnazalihadataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
trenutnazalihadataGridView.Columns["id"].Visible = false;
trenutnazalihadataGridView.Columns["redni_broj"].FillWeight = 100;
trenutnazalihadataGridView.Columns["naziv_artikla"].FillWeight = 571;
trenutnazalihadataGridView.Update();
trenutnazalihadataGridView.Refresh();
}
}
}

3 Replies

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

Goran Bibic8y ago
This is result
Nitin Sontakke8y ago
@Mohan,

The question is with respect to the Microsoft SQL Server only. Not MySQL.
Mohan Arumugam8y ago
1]To communicate with mysql you need to add mysql.data.dll in your project.

2]After that add the namespace
Using MySql.Data.MySqlClient;

3]
MySqlConnection con = new MySqlConnection(ConnectionStrings);
MySqlCommand cmd= new MySqlCommand(Your sql query);
MySqlDataReader dr = cmd.ExecuteReader();

gridview.DataSource = dr;
gridview.BataBind();

4] ConnectionString

I hope this will helpful for you