UC知道C# DataReader数据读出来了，但是不知道怎么取？？？？
来源：百度知道 编辑：UC知道 时间：2024/05/04 06:49:56
string bigid = string.Empty;
string subid = string.Empty;
try
{
//创建Connection连接
objMysqlconnThree = new MySqlConnection(conn);
querySecond = "SELECT bigid, subid From gs_device WHERE devnumber =" + chStationNumber + "";
objMysqlcmdThree = new MySqlCommand(querySecond, objMysqlconnThree);
objMysqlconnThree.Open();
objMysqlRdSecond = objMysqlcmdThree.ExecuteReader();
while (objMysqlReader.Read())
{
bigid = Convert.ToString(objMysqlReader[0]);
subid = Convert.ToString(objMysqlReader[1]);
}
string subid = string.Empty;
try
{
//创建Connection连接
objMysqlconnThree = new MySqlConnection(conn);
querySecond = "SELECT bigid, subid From gs_device WHERE devnumber =" + chStationNumber + "";
objMysqlcmdThree = new MySqlCommand(querySecond, objMysqlconnThree);
objMysqlconnThree.Open();
objMysqlRdSecond = objMysqlcmdThree.ExecuteReader();
while (objMysqlReader.Read())
{
bigid = Convert.ToString(objMysqlReader[0]);
subid = Convert.ToString(objMysqlReader[1]);
}
bigid = Convert.ToString(rs("bigid"));
subid = Convert.ToString(rs(subid));
如果要像你那样赋值的话,最好用DataSet
DataReader提供一个来自数据库的快速、仅向前、只读数据流。
比如给一个combobox或datagridview赋一个datareader