放数据indatagridview [英] Put data indatagridview

问题描述

大家好，

我不知道如何显示一些数据。

我在DB中有一组这样的数据，其中数字是工作时间和工作是完成的工作类型：

Hi all,
I do not know how to display some data.
I have a set of data in DB like this, where the number are the hours worked and the job is the type of work done:

paul 1  jobA
john 2  jobA
mark 3  jobA
paul 1  jobA
paul 1  jobA

paul 2	jobB
john 2	jobB
mark 2	jobB

paul 3	jobC
john 2	jobC
mark 1	jobC

paul 5  jobD

mark 3  jobE

然后我将它与linq分组，得到这个：

I then grouped it with linq, getting this:

paul 
    paul 1  jobA
    paul 1  jobA
    paul 1  jobA
    paul 2  jobB
    paul 3  jobC
    paul 5  jobD
john 
    john 2  jobA
    john 2  jobB
    john 2  jobC
mark 
    mark 3  jobA
    mark 2  jobB
    mark 1  jobC
    mark 3  jobE

此时我获得一份独特的工作：

At this point I make a distinct job by getting:

jobA
jobB
jobC
jobD
jobE

上面我可以使用column.Add创建datagridview列。 。$


但是如何点击正确的数据浏览单元？



在实践中我想这样：

with this above I can create the datagridview columns using column.Add...

But how do I hit the right datagriview cells?

In practice I would like this:

	jobA	jobB	jobC	jobD	jobE
paul	3	2	3	5
john	2	2	2
mark	3	2	1		3

但我无法弄清楚如何将它们放在正确位置的datagridview中。

有什么建议吗？



谢谢你


d。

But I can not figure out how to put them in the datagridview at the right place.
any suggestion?

thanks

d.

推荐答案

你好duppino，

Hi duppino,

datagridview可以在表中显示一些数据，这个表存储在数据库中，所以如果如果您想在datagridview中显示数据，我建议您在数据库中定义数据表，如下所示：

The datagridview can display some data in a table, and this table is stored in the database, so if you want to display the data as you said above in datagridview, I suggest you define the datatable within database as below:

CREATE TABLE [dbo].[T_Jobs]
(
    [Id] INT identity NOT NULL PRIMARY KEY, 
    [Name] NVARCHAR(50) NULL,
    [jobA] INT NULL, 
    [jobB] INT NULL, 
    [jobC] INT NULL, 
    [jobD] INT NULL, 
    [jobE] INT NULL
)

然后添加一些记录：

然后代码：

        private DataTable dt = new DataTable();
        private DataSet ds = new DataSet();

        private void Form1_Load(object sender, EventArgs e)
        {
            string sqlCon = @"sqlConnection";

            string sqlSelect = @"select Name,jobA,jobB,jobC,jobD,jobE from T_Jobs";
            using (SqlConnection conn = new SqlConnection(sqlCon))
            {
                using (SqlCommand cmd = new SqlCommand(sqlSelect, conn))
                {
                    using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
                    {
                        adapter.Fill(ds);
                        dt = ds.Tables[0];
                        conn.Close();
                    }
                }
            }
            dataGridView1.DataSource = dt;
        }

结果：

问候，

Stanly

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