Question

c# 中的 SqlDataReader 能不能获取某一行的值?

如题.

用哪个方法呢?

Answer 1

using (SqlConnection conObj = new SqlConnection(connString))
{
SqlCommand cmdObj = new SqlCommand(dboOwner +".usp_SelectStudentInfoByLoginID",conObj);
cmdObj.CommandType = CommandType.StoredProcedure;
cmdObj.Parameters.Add("@LoginID", SqlDbType.NVarChar, 50).Value = loginID;
conObj.Open();
using (SqlDataReader reObj = cmdObj.ExecuteReader(CommandBehavior.CloseConnection))
{
if (reObj.Read())
{
student.LoginID = Convert.ToString(reObj["LoginID"]);
student.StudentNo = Convert.ToString(reObj["StudentNO"]);
student.StudentName = Convert.ToString(reObj["StudentName"]);
student.Sex = Convert.ToString(reObj["Sex"]);
//student.
student.StudentIDNO = Convert.ToString(reObj["StudentIDNO"]);
student.Phone = Convert.ToString(reObj["Phone"]);
}
}
conObj.Close();
conObj.Dispose();
}

自己改一下吧,获取的哪一行必须能被唯一标识 的