SQL Select Query in ASP.Net

Question

I have a table that contains information like(examId, examActive) and I want  to display a particular examId in a textbox. I am new
in ASP.Net and SQL. Please Help me. Here is my code, what
else I have to do.
vcon.Open();
SqlDataAdapter da = new SqlDataAdapter("select examId from ExamConfig where examActive='1'", vcon);
DataTable dt = new DataTable();
DataSet ds = new DataSet();
da.Fill(ds);
txtExamId.Text = dt.Rows[1]["examId"].ToString();
vcon.Close();

Ravi Shekhar · Answer

if your query returns single row then
SqlDataAdapter da = new SqlDataAdapter("select examId from ExamConfig where examActive='1'", vcon); DataTable dt = new DataTable(); da.Fill(dt);
txtExamId.Text = dt.Rows[0]["examId"].ToString();
==============================================
Now, If your query returns multiple row then you have to take any data container like datagridview, datalist etc. and do coding like below...
SqlDataAdapter da = new SqlDataAdapter("select examId from ExamConfig where examActive='1'", vcon); DataTable dt = new DataTable(); da.Fill(dt);
if(dt.Rows.Count>0)
{
datagridview1.datasource=dt;
datagridview1.databind();
}
Regards,
ravi
mark it as answer if it helped you

Kunal Vaishya · Answer

Hi ,
you can do like this first and check data not null if null then i have write that query for that below.
vcon.Open(); SqlDataAdapter da = new SqlDataAdapter(" Select IsNull (examId,'') as  examId from ExamConfig where examActive='1 '", vcon); DataTable dt = new DataTable(); da.Fill(dt);
if( dt.Rows.Count > 0 ) { //Record Found txtExamId.Text = Convert.ToString (dt.Rows[0]["examId"] ) // First row data } else { //There is no record found  //Record Not Found Please check Query in to Query Editor run and check Query Proper //If Query proper the check data are there or not }

Sanjeeb Lenka · Answer

try this:
SqlDataAdapter da = new SqlDataAdapter("select examId from ExamConfig where examActive='1'", vcon);
DataSet ds = new DataSet();
da.Fill(ds);
txtExamId.Text =ds.Tables[0].Rows[0][0].ToString();

Riyaz Akhtar · Answer

try this
txtExamId.Text = ds.Tables[0].Rows[0]["examId"].ToString();

Sayed Hassan · Answer

No it's provides Error at txtExamId.Text = dt.Rows[1]["examId"].ToString();

Anurag Sarkar · Answer

You simply need to bind the data to textbox.
SqlConnection con = new SqlConnection("Data Source=hightech;Initial Catalog=session; User ID=sa; password=sa");
String str = "select ename,job from emp";
SqlCommand cmd = new SqlCommand(str, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
TextBox1.Text = dr["ename"].ToString();
Label1.Text = dr["job"].ToString();
}
con.Close();
Thanx

Riyaz Akhtar · Answer

is ur sql query returning multiple row?