how to display the student name in the Label4

See more:

C#

Studetn id txt_student(textbox) Show (Button)

Label4

i want to display the student name in the label2.

when i click the show button the output will display in the Gridview.

Show Button code as follows;

SQl = "SELECT S.StudetnName,S.Marks, S.QPName,B.Class,B.BthNo,B.Batchdate,B.Attender FROM STUDDET S,Batch B ";
SQl = SQl + " where S.BthId = B.BthId and  s.StudId = '" + txt_Studid.Text.ToString() + "'";
        try
        {
            Dr = SCon.ReadSql(SQl);
            this.GridView1.DataSource = Dr;
            this.GridView1.DataBind();
            Dr.Close();
        }
        catch (Exception e1)
        {
            Label4.Text = e1.Message.ToString();
            return;
        }

Output as follows;

Marks QPName Class BthNo Batchdate Attender
56 REO_2011 REO 37 2011-09-26 NIRANJAN
64 REO_2011 REO 37 2011-09-26 NIRANJAN

the above output is retrieving correctly, but i want to display the student name in the Label4.



for that how can i do, how to display the student name in the Label4.

Please help me.

Regards,
Narasiman P.