如何读取数据库中的单列 [英] How to read single column in database

问题描述

大家好，

我正在使用SqlClient for Database.我想借助SQLdatareader从数据库表中仅读取1列.我该如何在C#代码中做到这一点.有人可以告诉我吗?吗?

我要读取的值是整数类型.从表中读取后，我必须将其存储在整数数组中.

Hi all,

I am using SqlClient for Database. I want to read only 1 column from table in database with the help of SQLdatareader. How can i do it in code of C#. Can anybody tell me????

The Values which i am going to read are of type integer.After Reading that from table i have to stor it in integer array.

推荐答案

Hi，

请按照以下方式使用DataReader从数据库获取列-

Hi,

Please follow below way to get column from database using DataReader -

SqlConnection conn = new SqlConnection(ConnectionString);
    SqlCommand objCommand = new SqlCommand();
    DataSet dsMailingInfo = new DataSet();
    conn.Open();
    objCommand.Parameters.Clear();
    objCommand.Connection = conn;
    objCommand.CommandText = "Select <Column_Name> from <Table_Name>";
    SqlDataReader reader = comm.ExecuteReader();
    strFileName = reader.GetString(reader.GetOrdinal("<Column_name>"));
conn.close()

问候，

尼罗什·沙(Nilesh Shah)

Regards,

Nilesh Shah

这篇关于如何读取数据库中的单列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！