用数据显示coloumn名称 [英] show coloumn name with data

问题描述

我想用指定的值显示每个coloumn，但我的程序需要ID coloumn并且只显示Id它显示名称和地址....请告诉我我必须做什么







SP在这里

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

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

和代码在这里

and code is here

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();
        }
    }
}

推荐答案

为什么使用存储过程进行简单选择？



如果您只使用选择语句，则更容易：

Why do you use stored procedures for a simple selection?

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

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();

我刚刚结束foreach colomn循环以获取所有coloumns < br $> b $ b

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

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(" ");
                        }


                    }
                }

这篇关于用数据显示coloumn名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！