display individual columns from sql result in asp.net c#

Question

I'm coding a simple application using c# asp.net. I'm getting the averages of columns. How can I get the individual values from the result and display it in a new label (label1, label2, label3....)?

I tried ExecuteScalar().ToString(); but it returns only the first column.

Below is my code:

SqlConnection con;
con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\STATDB.MDF;Integrated Security=True;User Instance=True");
SqlCommand com = new SqlCommand();

SqlDataAdapter da = new SqlDataAdapter();
string result = "SELECT AVG(p_tan) AS p_tang, AVG(e_tan) AS e_tang, AVG(p_rel) AS p_reli FROM statistics";
SqlCommand showresult = new SqlCommand(result, con);
con.Open();

Label1.Text = showresult.ExecuteScalar().ToString();
//Label2.Text = p_tang
//Label3.Text = e_tang
//Label4.Text = p_reli
con.Close();

Any help will be appreciated.

Please read SqlCommand.ExecuteReader

huMpty duMpty
– huMpty duMpty

2013-07-08 16:40:00 +00:00
Commented Jul 8, 2013 at 16:40 — huMpty duMpty
– huMpty duMpty, Commented Jul 8, 2013 at 16:40

Sachin · Accepted Answer · 2013-07-08 16:30:06Z

3

Use showresult.ExecuteReader() and then iterate over the row to get the values

SqlDataReader reader=showresult.ExecuteReader();
while (reader.Read())
{
  Label1.Text= reader["p_tang"].ToString().Trim();
  Label2.Text= reader["e_tang"].ToString().Trim();
  Label3.Text= reader["p_reli"].ToString().Trim();
}

answered Jul 8, 2013 at 16:30

Sachin

41.1k7 gold badges94 silver badges107 bronze badges

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

Comments

logixologist · Accepted Answer · 2013-07-08 16:32:08Z

0

ExecuteScalar will only pull one value. You will need do either use a DataReader or DataAdapter to get multiple values from the database.

answered Jul 8, 2013 at 16:32

logixologist

3,8644 gold badges34 silver badges47 bronze badges

Collectives™ on Stack Overflow

display individual columns from sql result in asp.net c#

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