请问有人能帮我解决这个代码问题吗?我正在尝试将数据绑定到DataGridView上。查询在SQL Server中返回了值,但是DataGridView没有绑定任何值...
private void CheckMembers()
{
try
{
string query = "Select id, id-no, status From Members Where Head=@Head";
sqlCommand = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
sqlCommand.Parameters.AddWithValue("@Head", "2288885858");
sqlDataReader = sqlCommand.ExecuteReader();
if (sqlDataReader.HasRows)
{
fmGview.Visible = true;
DataTable dt = new DataTable();
dt.Load(sqlDataReader);
MessageBox.Show(dt.ToString());
fmGview.DataSource = dt;
}
}
catch (Exception exp)
{
MessageBox.Show(exp.ToString(), "Exception in CheckMembers");
}
finally
{
CheckConnectionStatus();
}
}
dt中行的计数器为3
- Mistr Mowgli