如何在datagridview中显示数据库中的数据? [英] how to show data from database in datagridview?

问题描述

要在datagridview中显示数据库中的数据，请编写此代码

to show data from database in datagridview i code this

string p_code = P1.Text;
string p_design = P2.Text;
SqlDataAdapter pgrid = new SqlDataAdapter("Select * From Product Where Item_Code = @p_code OR Design = @p_design", connection_v);
pgrid.SelectCommand.Parameters.AddWithValue("@p_code", @p_code);
pgrid.SelectCommand.Parameters.AddWithValue("@p_design", @p_design);
DataTable pt = new DataTable();
pgrid.Fill(pt);
dgv_p.DataSource = pt;

这工作正常，n的输出是这样的
项目代码设计...........
55555 RM-5

但是我想要这样的输出
编号55555
设计RM-5
.
.

this is working fine n its output is like this
Item Code Design ...........
55555 RM-5

but i want output like this
Item Code 55555
Design RM-5
.
.

推荐答案

我认为没有直接的方法可以做到这一点.一种简单的方法是:

1.在执行操作时获取数据
2.转置数据表中的数据
3.插入第一列，并输入列名称
4.为第一列设置适当的单元格样式，使其看起来像标题
5.隐藏datagridview的实际标题.

I do not think there is s straight fwd way to do it. One of the easy ways is to:

1. Get the data as you are doing it
2. Transpose the data in the datatable
3. Insert first column with the column names
4. Set the appropriate cell style for first column so it looks like header
5. Hide actual heade of datagridview.

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