Forced to display to the label after last row selected

Israel

Hi!

Anyone can help please. I have these code and I need to display only the last row of datagrid on my label.

This first line it's works:

dgvNprint.CurrentCell = dgvNprint.Rows[dgvNprint.Rows.Count - 2].Cells[0];

the whole code:

...On Button_Click

dgvNprint.CurrentCell = dgvNprint.Rows[dgvNprint.Rows.Count - 2].Cells[0];
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test\\table.mdb;Persist Security Info=False";
OleDbConnection sqlCon = newOleDbConnection(connectionString);
sqlCon.Open();
string commandString = "select * from companyname where S='order by ID" + '*' + "'";
OleDbCommand sqlCmd = newOleDbCommand(commandString, sqlCon);
OleDbDataReader read = sqlCmd.ExecuteReader();
while (read.Read())
{
lblNumberprint.Text = read["ID"].ToString(); // it will show your friend's name
}
sqlCon.Close();

5 Replies

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

Israel8y ago
The problem should be here: lblNumberprint.Text = read["ID"].ToString();
Its doesnt display on my lablel lblNumberprint.Text
What can I do? I need a help
Laxmidhar Sahoo8y ago
sir kindly display the loading method of gridview
Israel8y ago
thank you, but the problem is its should display on the label. Its doesnt display.
Laxmidhar Sahoo8y ago
sir the select query will be
select top 1 * from companyname order by ID desc
Lahiru Mahagamage8y ago
I think the issue is with the select statement where you select all. Find the name of the field of the last row that you need to show on the data gird, then write the SQL query as follows
This will surely work.
string commandString = "select yourfieldname from companyname where S='order by ID" + '*' + "'";