retrive multiple records from one table in one label, (bind all cities from tbl_city table in one label.)

Question

4.00/5 (1 vote)

See more:

hi i want to
retrive multiple records from one table in one label,
bind all cities from tbl_city table in one label.

tbl_cities
----------
ahmedabad
surat
bhavnagar
rajkot
delhi
mumbai
chennai
----------
label1.text

i want all cities in label1.text using datatable

Posted 9-Mar-14 16:11pm

Manish Dalwadi

Add a Solution

5 solutions

Solution 1

Iterate through all the rows like the following :

C#

Label1.Text = string.Empty;
foreach(DataRow dr in dt_cities.Rows)
{
    Label1.Text += dr[0].ToString() +"\n";
}

-KR

Posted 9-Mar-14 17:29pm

Krunal Rohit

Solution 2

Do ur work in sql server itself

SQL

select

 maskdetail = STUFF((
          SELECT ',' + p.Name
          FROM dbo.tbl_cities p

          FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')

label1.text = dt.rows[0][0].tostring();

Hope this helps

Posted 9-Mar-14 17:48pm

AndrewCharlz

Updated 9-Mar-14 17:50pm

v3

Solution 3

Hi,
U can do it like this

C#

lblcity.Text=string.Empty;
        lblcity.Text += "All Cities"+"\n";
        lblcity.Text += "------------"+"\n";
        foreach (DataRow dr in dt.Rows)
        {
            lblcity.Text+=dr.ItemArray[0]+"\n";
        }

Posted 9-Mar-14 19:26pm

SanSkun

Solution 4

If you want to take data from datatable then follow Solution1

but if you want to get data from the SQL server and directly put it into label then follow the below snippet of SQL Query

Declare @strCity VARCHAR(MAX)
SELECT @strCity=COALESCE(@strCity + ',','') + City from Table1
PRINT @strCity

Put this code in your stored procedure and return it using out parameter.

Posted 9-Mar-14 20:19pm

Singh Rajan

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)

Karthik_Mahalingam · Accepted Answer · 2014-03-09T20:53:00

Try this sample

C#

DataTable dt = new DataTable();
        dt.Columns.Add("City", typeof(string));
        dt.Rows.Add("ahmedabad");
        dt.Rows.Add("surat");
        dt.Rows.Add("bhavnagar");
        dt.Rows.Add("rajkot");
        dt.Rows.Add("delhi");

        string cities = "";
        string splitter = ",";
        foreach (DataRow row in dt.Rows)  
            cities += row["City"] + splitter;
        cities = cities.Trim(new char[] { ','});

        Label1.Text = cities;