how to fill labels with a select query?

Question

0.00/5 (No votes)

See more:

hi.
how can i fill labels or textboxes from a select query?
for examle my select reture the four fields ( name , brand , model , price)
i want to do that in asp.net
thanks all

Posted 2-Aug-15 5:20am

Member 11829564

Add a Solution

Comments

[no name] 2-Aug-15 11:29am

You set the text property of the controls. Do you have an actual question?

2 solutions

Solution 1

Instead of writing the data yourself. I would recommend that you use DataGrid controls. Just pass the result of the query to the DataGrid and it would take care of it itself. DataGrid uses the data you pass, and iterates over the data and fills the table. It creates the column and rows itself.

https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.datagrid(v=vs.110).aspx[^]
https://msdn.microsoft.com/en-us/library/aa479316.aspx[^]

If you do not use the control, you would have to manually implement the algorithm. To generate a table and write header rows using the column names and for each record loop the other rows and fill up the table. It would take a lot of time.

Posted 2-Aug-15 5:38am

Afzaal Ahmad Zeeshan

Updated 2-Aug-15 5:39am

v2

Comments

Member 11829564 2-Aug-15 12:41pm

yeah, i don't want use any control!
thanks for your time

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)

DamithSL · Accepted Answer · 2015-08-02T06:28:00

if you searching and display single item from database you can do as below

C#

using (var connection = new SqlConnection("connection string"))
{
    connection.Open();
    using (var cmd = new SqlCommand("SELECT name , brand , model , price  FROM Product WHERE ProductID=@MYVALUE", connection))
    {
        cmd.Parameters.AddWithValue("@MYVALUE", txtID.Text);
        SqlDataReader re = cmd.ExecuteReader();

        if (re.Read())
        {
            txtName.Text = (string)re["name"]; 
            txtBrand.Text = (string)re["brand"];
            txtModel.Text = (string)re["model"];
            txtPrice.Text = (string)re["price"];
        }
        else
        {
            MessageBox.Show("Please enter a valid product id");
        }
    }
}

based on user input, sql command will fetch the data and it will display the record details on UI labels.

if you need to show multiple records, you better use controls like DataGridView or ListView.