Get data from SQL Server database into label

Question

In my ASP.Net webpage, I have a label and need the label's text to be retrieved from my database.

I have no problem writing to my database, but it seems trying to retieve the data again is a mission...

What I need is to get the data from the Price column in my database, from the table Tickets, from the record where the ConcertName data is the same as my webpage's title, or a string associated with my webpage.

I have tried many tutorials already, but all just throw me errors, so I decided to try one last place before I just give in and make my labels static.

In case it helps, I have tried the following:

PraveenVenu · Accepted Answer · 2012-03-24 15:02:49Z

5

Hopes you use c#

string MyPageTitle="MyPageTitle"; // your page title here
string myConnectionString = "connectionstring"; //you connectionstring goes here

SqlCommand cmd= new SqlCommand("select Price from Tickets where ConcertName ='" + MyPageTitle.Replace("'","''") + "'" , new SqlConnection(myConnectionString));
cmd.Connection.Open();
labelPrice.Text= cmd.ExecuteScalar().ToString(); // assign to your label
cmd.Connection.Close();

answered Mar 24, 2012 at 15:02

PraveenVenu

8,3674 gold badges32 silver badges39 bronze badges

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

1 Comment

Andre C Over a year ago

Worked out that all my existing code was right, just needed the command string. It worked, so thanks.

Coltech · Accepted Answer · 2012-03-24 15:19:39Z

1

Looks like you want to bind the label to a data source. Here is a great example that works.

answered Mar 24, 2012 at 15:19

Coltech

1,7704 gold badges17 silver badges32 bronze badges

Comments

NuNn DaDdY · Accepted Answer · 2012-03-25 00:17:30Z

0

Here is an example protecting against SQL Injection and implicity disposes the SqlConnection object with the "using" statement.

string concert = "webpage title or string from webpage";

using(SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["connString"].ConnectionString))
{
   string sqlSelect = @"select price 
                        from tickets 
                        where concert_name = @searchString";
   using(SqlCommand cmd = new SqlCommand(strSelect, conn)) 
   {
      cmd.Parameters.AddWithValue("@searchString", concert);
      conn.Open();
      priceLabel.Text = cmd.ExecuteScalar().ToString();
   }
}

If you're interested in researching ADO .Net a bit more, here is a link to the MSDN documentation for ADO .Net with framework 4.0

http://msdn.microsoft.com/en-us/library/h43ks021(v=vs.100).aspx

edited Mar 25, 2012 at 0:17

answered Mar 24, 2012 at 23:57

NuNn DaDdY

3,0122 gold badges17 silver badges19 bronze badges

1 Comment

Bridge Over a year ago

SqlCommand implements IDisposable too - why not have that in a using statement as well?

Collectives™ on Stack Overflow

Get data from SQL Server database into label

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related