ansaurus

Question

Display specific data on asp.net webpage from a microsoft sql express data table

Answer 1

A:

You probably want to have a look at some of these tutorials on asp.net and databinding

http://www.learnvisualstudio.net/content/series/ASPDotNet%5F2%5F0%5FData%5FAccess%5Fand%5FDataBinding.aspx

John Boker 2009-11-19 17:43:06

Answer 2

A:

If you want to have exactly one value from one single record, you can use the ExecuteScalar method of the SqlCommand class:

string title = null;
using (SqlConnection conn = new SqlConnection("your-connection-string"))
using (SqlCommand cmd = new SqlCommand(
    "select ContentTitle from {put table name here} where id = 4", conn))
{
    conn.Open();
    title = (string)conn.ExecuteScalar();
}

if (!string.IsNullOrEmpty(title))
{
    // assign title to suitable asp.net control property
}

If you want to be able to do this for various ids, do not just concatenate a new sql string. I will repeat that: do not just concatenate a new sql string. Use parameters instead:

string title = null;
using (SqlConnection conn = new SqlConnection("your-connection-string"))
using (SqlCommand cmd = new SqlCommand(
    "select ContentTitle from {put table name here} where id = @id", conn))
{
    SqlParameter param  = new SqlParameter();
    param.ParameterName = "@id";
    param.Value = yourIdGoesHere;
    cmd.Parameters.Add(param);

    conn.Open();
    title = (string)conn.ExecuteScalar();
}

if (!string.IsNullOrEmpty(title))
{
    // assign title to suitable asp.net control property
}

Update
Sample aspx page. First some markup (let's say the file is called example.aspx):

<body>
   <form id="Form1" runat="server">
      Title: <asp:Label id="_titleLabel" 
                 Text="{no title assigned yet}" 
                 runat="server"/>
   </form>
</body>

...and in the code-behind (that would be called example.aspx.cs; I have included only the Page_Load event for simplicity):

protected void Page_Load(object sender, EventArgs e)
{
    int id;
    try
    {
        if (int.TryParse(Request.QueryString["id"], out id))
        {
            _titleLabel.Text = GetContentTitle(id);
        }
        else
        {
            _titleLabel.Text = "no id given; cannot look up title";
        }
    }
    catch (Exception ex)
    {
        // do something with the exception info
    }
}

private static string GetContentTitle(int id)
{ 
    using (SqlConnection conn = new SqlConnection("your-connection-string"))
    using (SqlCommand cmd = new SqlCommand(
        "select ContentTitle from {put table name here} where id = @id", conn))
    {
        SqlParameter param  = new SqlParameter();
        param.ParameterName = "@id";
        param.Value = yourIdGoesHere;
        cmd.Parameters.Add(param);

        conn.Open();
        return (string)conn.ExecuteScalar();
    }
}

Disclaimer: the code is written directly into the answer window and not tested (I don't have access to a development environment right now) so there may be errors

Fredrik Mörk 2009-11-19 17:46:05

I am sure this works. I just don't know how to implement it in a example.aspx webpage. Please post an example of the asp.net code.

Gabe Martin 2009-11-19 18:17:00

Oh and what file do I put the first paragraph of CS code that you showed into. I am only 15 years old, and I am trying to learn asp.net.

Gabe Martin 2009-11-19 18:44:23

Thanks. I will give it a try when I have a chance.

Gabe Martin 2009-11-19 20:19:41

@Gabriel: do that. I hope it works out :o)

Fredrik Mörk 2009-11-19 20:24:19

What code do I insert where it says "your-connection-string". Thanks for all of your time.

Gabe Martin 2009-11-19 20:36:04

The connection string depends on your database. This is a good resource for connection strings: http://connectionstrings.com/

Fredrik Mörk 2009-11-19 20:49:05

ansaurus

tags:

views:

answers:

Display specific data on asp.net webpage from a microsoft sql express data table

related questions