Retrieve single column data

Question

1.00/5 (12 votes)

See more:

Hi!
I am new to .NET .
I have to get two column of data from a table on an SQL-Server. I have to add them up and display the result in an HTML table.

Note: I am not using a gridview!

Thank you!

Posted 15-Dec-10 23:39pm

srinivasvempa

Updated 16-Dec-10 0:46am

v6

Add a Solution

Comments

Hiren solanki 16-Dec-10 7:27am

Just bind datasource with returned query result to gridview. It will be rendered as a HTML table only.

5 solutions

Solution 3

The 1st part of your answer has already been answered.
I will try to answer the 2nd part.

srinivasvempa wrote:
I have to add them up and display the result in an HTML table.

In your aspx page, add a label in the <td> part of the html table where you want to display the value. Initially set it's visibility to false.
After you get the values from the database, add them (that's easy).
Assign the value to the label and set it's visibility to true.

Let me know if I got your question wrong.

Posted 16-Dec-10 0:26am

Ankur^\m/

Solution 2

To select only 2 rows from sql server,

Select Top 2 from tablename

and add two rows in the sense what?
If columns datatype are decimal, integer, etc. then you can add in sql query only using Sum() operator.

Posted 15-Dec-10 23:45pm

Toniyo Jackson

Updated 15-Dec-10 23:47pm

v2

Comments

Toniyo Jackson 16-Dec-10 7:45am

Question changed

Solution 5

This is actually a fairly ambiguous question. Do you mean that you have to get the sum of both columns individually? If so, you would just use

SQL

SELECT SUM(Column1) As SumOfColumn1, SUM(Column2) As SumOfColumn2 FROM MyTable WHERE SomeCondition

Posted 16-Dec-10 1:54am

Pete O'Hanlon

Solution 6

You could easily have found this using google.

select top 2 * from table

EDIT =========================

This was the original text which I responded to:

Hi I am new to .net i have to get two rows of data from sqlserver table and i have to add both rows how can i get rows from table . i dont need all table info

You COMPLETELY changed the question, and then voted my answer a 1.

EDIT #2 =========================

I hope you saw the original version of this because the last sentence still stands. It's really too bad the thought police have endorsed your action by deleting my original message.

Posted 16-Dec-10 10:58am

#realJSOP

Updated 16-Dec-10 11:17am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

justinonday · Accepted Answer · 2010-12-16T01:16:00

using System.Text;//namesspace
using System.Data;

public void ConvertToHtml(DataTable dt)
{
StringBuilder sb=new StringBuilder();
sb.Append("<'table'>");
sb.Append("<body>");
sb.Append("<'tr'>");
sb.Append("<'td'>ColumnFirst<'td>ColumnSecond /td /tr>");
for(int i=0;i'<'dt.Rows.Count;i++)
{
sb.Append("<'tr><table><tbody><tr><td>"+dt.rows[i][ColumnFirst]+"/td /tr");
sb.Append("<'tr><table><tbody><tr><td>"+dt.rows[i][ColumnSecond]+"/td /tr");
}
sb.Append("</body>/table");
Div1.InnerHtml=sb.ToString();// add this to div runat="server" in aspx page
}
</td></tr></tbody></table></td></tr></tbody></table>

//Note Remove All ' occurrence.
//give proper closing HTML Tag.