show coloumn name with data

Question

0.00/5 (No votes)

See more:

i want to show each coloumn with its specified value but my program takes ID coloumn and to show only Id it shows name and adress too.... plz let me know what i have to do

SP is here

SQL

ALTER PROCEDURE [dbo].[GetEmpInfo ]
AS
BEGIN
    select * from EmpData
END

and code is here

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;


namespace DataBaseConnectivity2
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection conect = new SqlConnection("Data Source=SHARP-ITECH-PC\\SQLEXPRESS;Initial Catalog=EmployeeRecord;Integrated Security=True");
            SqlCommand comand = new SqlCommand("GetEmpInfo", conect);
            comand.CommandType = CommandType.StoredProcedure;
            try
            {
                conect.Open();
                SqlDataAdapter DAdapt = new SqlDataAdapter(comand);
                DataSet dsEmployeeData = new DataSet();
                DAdapt.Fill(dsEmployeeData);
                <pre lang="cs">if (dsEmployeeData != null && dsEmployeeData.Tables.Count > 0)
                {
                    foreach (DataTable dt in dsEmployeeData.Tables)
                    {
                        foreach (DataColumn dc in dt.Columns)
                        {
                            Console.Write(dc.ColumnName);
                            {
                                foreach(DataRow dr in dt.Rows)
                                {
                                    foreach (object value in dr.ItemArray)
                                    {
                                        Console.Write(value + " ");
                                    }
                                    Console.WriteLine(" ");
                                }
                            }
                        }
                    }
                }

            }
            finally
            {
                conect.Close();
            }
            Console.ReadKey();
        }
    }
}

Posted 17-Sep-13 22:41pm

Innocent910

Updated 17-Sep-13 22:44pm

CPallini

v2

Add a Solution

2 solutions

Solution 1

Why do you use stored procedures for a simple selection?

If you use just a select statment it is even easier:

C#

SqlConnection conect = new SqlConnection("Data Source=SHARP-ITECH-PC\\SQLEXPRESS;Initial Catalog=EmployeeRecord;Integrated Security=True");

SqlCommand comand = new SqlCommand("select * from EmpData", conect);

try
{
    conect.Open();

    using (SqlDataReader reader = comand.ExecuteReader())
    {
        while (reader.Read())
        {
           for (int i = 0; i < reader.FieldCount; i++)
	   {
                Console.Write(reader.GetName(i) + ": ");
                Console.WriteLine(reader.GetValue(i));
	   }

   	   Console.WriteLine();
        }
    }
}

finally
{
    conect.Close();
}

Console.ReadKey();

Posted 17-Sep-13 23:31pm

norbitrial

Updated 17-Sep-13 23:37pm

v3

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)

Innocent910 · Accepted Answer · 2013-09-17T23:58:00

Solution 2

i have just end the foreach colomn loop to get all coloumns

C#

if (dsEmployeeData != null && dsEmployeeData.Tables.Count > 0)
                {
                    foreach (DataTable dt in dsEmployeeData.Tables)
                    {
                        foreach (DataColumn dc in dt.Columns)// just enclose loop
                        {
                            Console.Write(dc.ColumnName + " ");
                        }

                        foreach (DataRow dr in dt.Rows)
                        {
                            foreach (object value in dr.ItemArray)
                            {
                                Console.Write(value + " ");
                            }
                            Console.WriteLine(" ");
                        }


                    }
                }

Posted 17-Sep-13 23:58pm

Innocent910

Updated 17-Sep-13 23:59pm

v2

Comments

Innocent910 18-Sep-13 6:03am

but ther is a problem now i am geting output like this
Id name addrees 1 khawar khawaraddress
but i want this type of output
Id name addrees
1 khawar khawaraddress
how can i get this??????

Pheonyx 18-Sep-13 6:08am

Add the results of the each for each to a stringbuilder
then Use Console.WriteLine instead of Console.Write

So the first for loop looks like this:

StringBuilder sb = new StringBuilder();
foreach (DataColumn dc in dt.Columns)
{
sb.Append(dc.ColumnName + " ");
}
Console.WriteLine(sb.ToString().Trim());

Then the second loop should look like this:

foreach(DataRow dr in dt.Rows)
{
sb = new StringBuilder();
foreach(var value in dr.ItemArray)
{
sb.Append(value + " ");
}
Console.WriteLine(sb.ToString().Trim());
}

Innocent910 18-Sep-13 6:18am

got the right answer thnx alot

Innocent910 19-Sep-13 4:18am

can u plz show me how to use appendformat....

Innocent910 19-Sep-13 4:19am

can u plz show me how to use appendformat....i want specific coloumn lenght

Pheonyx 23-Sep-13 17:26pm

Sorry I've not replied, I've been away.

What is appendformat?
What do you mean when you say you want "specific column length" ? is that so your output on the console looks like an actual table?

Mas11 18-Sep-13 6:10am

What kind of output you will get as per above solution.. Please post here.