使用linq将datagrid视图绑定到sql而不填充记录 [英] binding datagrid view with linq to sql without filling records

问题描述

朋友们，
我有以下代码用于绑定datagridview，

Hi friends,
I have following piece of code for binding datagridview,

dataGridViewheader.DataSource = from v in context.transectionHeaders
                                                           select v;

它在datagrid视图上的transectionheaders表中填充数据.我不想显示这些数据.我想将datagridview绑定到表中只是为了插入新记录.
我希望你能明白我的意思.
请帮忙.

It populates data in transectionheaders table on datagrid view. I don''t want to show that data. I want to bind the datagridview to the table just for inserting new records.
I hope you are getting what I meant.
Please help.

推荐答案

据我了解我是否正确，您只想获取transectionHeaders表的结构

所以首先
私人transectionHeader AddRowTolIst
(
transectionHeaders row = new transectionHeaders();
row.column1 =默认值
row.column2 =默认值
....
返回行；
)

********************
私人名单< transectionheaders> FillList()
{
list< transectionheaders> _list = new list< transectionheaders>();
list.add(addrowtolist());
}

********************
私有void fillgrid()
{
gridview1.datasource = FillList();
gridview.databind();
}

并且gridview列将转换为文本框&的模板内容下拉列表Datetimepicker取决于您的列类型
希望这对u

as i understand if i was correct u just want to get the structre of the transectionHeaders table

so first
private transectionHeaders AddRowTolIst
(
transectionHeaders row=new transectionHeaders ();
row.column1=defaultvalue
row.column2=defaultvalue
....
return row;
)

********************
private list<transectionheaders> FillList()
{
list<transectionheaders> _list=new list<transectionheaders>();
list.add(addrowtolist());
}

********************
private void fillgrid()
{
gridview1.datasource=FillList();
gridview.databind();
}

and the gridview columns convert to template content of textbox & dropdownlist & Datetimepicker depend on your columns type
hope this is be helpfull for u

这篇关于使用linq将datagrid视图绑定到sql而不填充记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！