Pulling SQL data into an ASP.net web page

Question

I tried searching for this, but I can't find an answer that works. All I need to do is find a way to display SQL data from a simple query onto an aspx page. I'm using C# to connect to the database. I have not trouble posting to the database. My code seems correct. I'm not getting any errors, however, the web page doesn't display anything.

Here is the code on the C# file:

public int GetResults( )
{
    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Data"].ConnectionString); 
    SqlCommand cmd = new SqlCommand("select count (ColumnA) from TableA",conn);
    cmd.CommandType = CommandType.Text;

    conn.Open();
    int Rslt= (Int32)cmd.ExecuteNonQuery();
    return (Rslt);
}

And here is the aspx page:

<div class="lc">      
  the results are=  <%GetResults();%>
</div>

Rahul · Accepted Answer · 2016-06-22 01:05:23Z

1

You should use ExecuteScalar() rather like

int Rslt= (int)cmd.ExecuteScalar();

Again, the calling doesn't looks correct. It rather should be

<%# GetResults() %>

As @Jacob pointed: <% %> is for executing a code block; whereas <%= %> or <%# %> is for outputting content.

edited Jun 22, 2016 at 1:05

answered Jun 22, 2016 at 0:59

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

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

3 Comments

Jacob Over a year ago

To explain the last part, <% %> is for executing a code block; <%= %> or <%# %> is for outputting content.

Jacob Over a year ago

But I'd use <%: GetResults() %> to automatically HTML-encode the output.

Robert Over a year ago

Thank you, Jacob! The <%: GetResults() %> worked.

Collectives™ on Stack Overflow

Pulling SQL data into an ASP.net web page

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related