ExecuteReader return just "System.Data.SqlClient.SqlDataReader" in text box

Question

I have problem with this code and I don't know why that is.

Code:

SqlConnection getconn = new SqlConnection(somthing secured);              
string sql = "select  pk_stu_id , stu_name   from MRK , STU , LSN where fk_stu_id = pk_stu_id and fk_lsn_id = pk_lsn_id AND pk_lsn_id="
      + int.Parse(textBoxSearchStudentID.Text)
      + " and pk_stu_id="
      + int.Parse(textBoxSearchLessonID.Text); 



SqlCommand cmd = new SqlCommand(sql, getconn);
getconn.Open();
SqlDataReader result  = cmd.ExecuteReader();
while (result.Read())
{
    textBoxDataSend.Text = string.Empty;
    textBoxDataSend.Text = result.ToString();
}
getconn.Close();

But it just always returns: "System.Data.SqlClient.SqlDataReader".

Does anyone know how to fix this?

are you able to run it now?

Sudhakar Tillapudi
– Sudhakar Tillapudi

2013-12-08 14:39:16 +00:00
Commented Dec 8, 2013 at 14:39 — Sudhakar Tillapudi
– Sudhakar Tillapudi, Commented Dec 8, 2013 at 14:39
yes bro it works.thnx

user3079982
– user3079982

2013-12-13 05:25:39 +00:00
Commented Dec 13, 2013 at 5:25 — user3079982
– user3079982, Commented Dec 13, 2013 at 5:25

Sudhakar Tillapudi · Accepted Answer · 2013-12-08 14:26:41Z

2

Problem : you are directly assigning SqlDataReader obect to your TextBox.

Solution : you need to access the required columns returned by your query using SqlDataReader object by providing either by column name or column index.

Replace this:

textBoxDataSend.Text = result.ToString();

with this:

textBoxDataSend.Text = result["stu_name"].ToString();//or you can give any other column name here

answered Dec 8, 2013 at 14:26

Sudhakar Tillapudi

26.3k5 gold badges43 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bharadwaj · Accepted Answer · 2013-12-08 14:52:12Z

0

Any object if ToString() is used for that will give you what kind of object it is, unless ToString() is override specifically inside the class.

answered Dec 8, 2013 at 14:52

Bharadwaj

2,5511 gold badge25 silver badges35 bronze badges

Collectives™ on Stack Overflow

ExecuteReader return just "System.Data.SqlClient.SqlDataReader" in text box

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related