查询的结果插入到数组/列表中，区分为2列。？ [英] the result of the query inserted in an array/list with distinction of 2 columns.?

问题描述

前。

A 01/01/2011

B 01/01/2011

C 01/01/2011

D 01/01/2011

A 01/02/2011

B 01/02/2011

D 01 / 02/2011

A 01/03/2011

D 01/03/2011



该查询计划使用？



SELECT DISTINCT字母，dateReceive FROM

数据库

按字母排序



使用List< string>



我们的预期输出

[{A，B，C，D}，{A，B，D}，{A，D}

ex.
A 01/01/2011
B 01/01/2011
C 01/01/2011
D 01/01/2011
A 01/02/2011
B 01/02/2011
D 01/02/2011
A 01/03/2011
D 01/03/2011

The query were planning to use ?

SELECT DISTINCT Alphabets, dateReceive FROM
database
ORDER BY Alphabets

using List<string>

Our expected output
[{A,B,C,D},{A,B,D},{A,D}

using (var conn = new SqlConnection("Data Source=SERV-PC\\MSQLSERVER;Initial Catalog=MyDatabase;Integrated Security=True"))
            {
                using (var cmd = new SqlCommand())
                {
                    cmd.Connection = conn;
                    cmd.CommandText = "SELECT DISTINCT [ColumnA], [DateReceive] FROM [MyDatabase].[dbo].[dummy] WHERE [ColumnA]=@loca  AND [DateReceive] BETWEEN '01/01/2013' and '01/07/2013' ";
                    cmd.Parameters.AddWithValue("@loca", DropDownList1.SelectedValue.ToString());
                    conn.Open();

                    using (var reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            var tmp = reader["ColumnA"];
                            if (tmp != DBNull.Value)
                            {
                                ListBox1.Items.Add(reader["ColumnA"].ToString());
                            }
                        }
                    }
                }
            }

推荐答案

你问了两次。如果被要求，请询问一次并编辑您的问题以添加详细信息。

You asked this twice. Please ask once and EDIT your question to add detail if asked for it.

这篇关于查询的结果插入到数组/列表中，区分为2列。？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！