blocks|key|1551223|text|我不确定如何在没有BindingSource的情况下做到这一点，下面是如何用它做到的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1551224|var+drv+=+bindingSoure1.Current+as+DataRowView;
if+(drv+!=+null)
++var+row+=+drv.Row+as+MyRowType;|code-block|syntax|javascript|1551225|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I'm not sure how to do it w/o a BindingSource, here is how to do it with one:

<pre><code>var drv = bindingSoure1.Current as DataRowView;
if (drv != null)
 var row = drv.Row as MyRowType;
</code></pre>

blocks|key|1551279|text|DataRowView+currentDataRowView+=+(DataRowView)dgv1.CurrentRow.DataBoundItem
DataRow+row+=+currentDataRowView.Row|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1551280|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>DataRowView currentDataRowView = (DataRowView)dgv1.CurrentRow.DataBoundItem
DataRow row = currentDataRowView.Row
</code></pre>

blocks|key|1335744|text|您应该能够将所选行直接转换为绑定到DataGridView的强类型行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1335745|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You should be able to directly cast your selected row into the strongly typed row that was bound to the DataGridView.

blocks|key|1551292|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1551293|DataRow+row+=+gridView1.GetDataRow(gridView1.FocusedRowHandle);+`++++++++
if+(row+!=+null)
{
+++++XtraMessageBox.Show(row["ID"].ToString());
}|code-block|syntax|javascript|1551294|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this:

<pre><code>DataRow row = gridView1.GetDataRow(gridView1.FocusedRowHandle); ` 
if (row != null)
{
 XtraMessageBox.Show(row["ID"].ToString());
}
</code></pre>

blocks|key|1551346|text|如果您已将datagridview绑定到数据库中的表或视图，则可以将数据作为强类型对象获取。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1551347|此答案适用于在设计时使用DataSet连接到数据库的Windows窗体。示例名称为DataSet1，示例表名为Customer_Info。|1551348|//+cast+the+data+bound+item+to+DataRowView+so+you+have
//+access+to+"Row",+which
//+has+the+actual+data+for+the+row+in+typed+fields.+
DataRowView+drv+=+dgv.SelectedRows(0).DataBoundItem+as+DataRowView;
//+run+the+code+and+look+at+the+debugger+value+of+drv.Row+--+
//+the+type+will+be+shown
//+which+is+the+type+created+by+the+data+binding,+representing+
//+your+table+or+view
//{YourDataSetName.YourTableOrViewType}+tmpTableData+=+drv.Row+as+{YourDataSetName.YourTableOrViewType};
DataSet1.Customer_InfoRow+tmpTableData+=+drv.Row+as+DataSet1.Customer_InfoRow;|code-block|syntax|javascript|1551349|这个链接就是答案。我希望我已经在上面增加了清晰度和一个例子。https://social.msdn.microsoft.com/Forums/windows/en-US/f252e395-58e6-4703-ba7b-0740efcbecf3/can-i-convert-the-selected-row-in-a-bound-datagridview-to-a-typed-datarow?forum=winformsdatacontrols|offset|length|1551350|此链接显示以编程方式添加到数据源的数据，而不是从现有数据库中提取该数据。这让我找到了答案的一部分：https://msdn.microsoft.com/en-us/library/4wszzzc7(v=vs.110).aspx|1551351|entityMap|0|LINK|mutability|MUTABLE|url|https://social.msdn.microsoft.com/Forums/windows/en-US/f252e395-58e6-4703-ba7b-0740efcbecf3/can-i-convert-the-selected-row-in-a-bound-datagridview-to-a-typed-datarow?forum=winformsdatacontrols|1|https://msdn.microsoft.com/en-us/library/4wszzzc7(v=vs.110).aspx^0|0|0|0|U|5C|0|0|1D|1S|1|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|11|8|@]|9|@$K|12|L|13|1|14]]|A|$]]|$1|M|3|N|5|6|7|15|8|@]|9|@$K|16|L|17|1|18]]|A|$]]|$1|O|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]|W|$5|R|S|T|A|$U|X]]]]

If you have bound your datagridview to a table or view in a database, you can get the data out as a strongly-typed object. 

This answer is for a Windows form that connected to a database using a DataSet at design time. Example name is DataSet1, and example table name is Customer_Info.

<pre><code>// cast the data bound item to DataRowView so you have
// access to "Row", which
// has the actual data for the row in typed fields. 
DataRowView drv = dgv.SelectedRows(0).DataBoundItem as DataRowView;
// run the code and look at the debugger value of drv.Row -- 
// the type will be shown
// which is the type created by the data binding, representing 
// your table or view
//{YourDataSetName.YourTableOrViewType} tmpTableData = drv.Row as {YourDataSetName.YourTableOrViewType};
DataSet1.Customer_InfoRow tmpTableData = drv.Row as DataSet1.Customer_InfoRow;
</code></pre>

This link is the answer. I hope I have added clarity and an example above. 
<a href="https://social.msdn.microsoft.com/Forums/windows/en-US/f252e395-58e6-4703-ba7b-0740efcbecf3/can-i-convert-the-selected-row-in-a-bound-datagridview-to-a-typed-datarow?forum=winformsdatacontrols" rel="nofollow noreferrer">https://social.msdn.microsoft.com/Forums/windows/en-US/f252e395-58e6-4703-ba7b-0740efcbecf3/can-i-convert-the-selected-row-in-a-bound-datagridview-to-a-typed-datarow?forum=winformsdatacontrols</a>

This link shows data programmatically added to the data source, not pulling that data from an existing database. This got me part of the way to the answer:
<a href="https://msdn.microsoft.com/en-us/library/4wszzzc7(v=vs.110).aspx" rel="nofollow noreferrer">https://msdn.microsoft.com/en-us/library/4wszzzc7(v=vs.110).aspx</a>

blocks|key|1551572|text|如果未在dataset内使用tableadapter，则不可能具有对datagridview的强类型访问。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1551573|要在datagridview通过bindingsource绑定到datatable时访问强类型变量，请执行以下操作：|1551574|创建新项目。|1551575|插入一个名为ds1的DataSet和一个名为dt99的DataTable，其中包含名为DataColumn1和DataColumn2的列，这两种类型都是字符串类型。|1551576|​|1551577|📷|atomic|offset|length|1551578|1551579|在主窗体中添加datagridView并将其绑定到dt99|1551580|1551581|1551582|1551583|这样dt99BindingSource就可以连接datagridview和datatable|1551584|1551585|1551586|1551587|为datagridview的选择更改添加和事件处理程序，并插入以下代码|1551588|private+void+dataGridView1_SelectionChanged(对象发送者，EventArgs+e)+{|1551589|++ds1.dt99Row+d=+((ds1.dt99Row)((DataRowView)dt99BindingSource.Current).Row);

++Debug.WriteLine(d.DataColumn1+%2B+"+"+%2B+d.DataColumn2);|code-block|syntax|javascript|1551590|}|1551591|现在，您已经拥有了强类型变量(d.DataColumn1和d.DataColumn2)来访问在datagridview上选择的单元格|1551592|另一个有趣的特性是，插入到dataset中的datatable提供了一组公共类，这些类在处理数据表时非常有用，例如|1551593|++++++++private+void+Form1_Load(Object+sender,+EventArgs+e)
++++{
++++++++ds1.dt99.Adddt99Row("K",+"B");
++++++++ds1.dt99.Adddt99Row("L",+"D");
++++++++ds1.dt99.Adddt99Row("M",+"F");
++++++++ds1.dt99.Adddt99Row("N",+"H");

++++++++ds1.dt99Row+dr+=+ds1.dt99.Newdt99Row();
++++++++dr.DataColumn1+=+"X";
++++++++dr.DataColumn2+=+"Y";
++++++++ds1.dt99.Adddt99Row(dr);

++++}|1551594|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/b65a29fdd380f4611d5ff2c8909d9fb1.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/9d661a94fee05dc59da143a6cbc9f76e.png|2|https://ask.qcloudimg.com/http-save/yehe-900000/1eec4d94d40acc357b98255cd3a0f165.png^0|0|0|0|0|0|0|1|0|0|0|0|0|0|1|1|0|0|0|0|0|1|2|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1V|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1X|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1Y|8|@]|9|@$M|1Z|N|20|1|21]]|A|$]]|$1|O|3|I|5|6|7|22|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|23|8|@]|9|@]|A|$]]|$1|R|3|I|5|6|7|24|8|@]|9|@]|A|$]]|$1|S|3|K|5|L|7|25|8|@]|9|@$M|26|N|27|1|28]]|A|$]]|$1|T|3|I|5|6|7|29|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|2A|8|@]|9|@]|A|$]]|$1|W|3|I|5|6|7|2B|8|@]|9|@]|A|$]]|$1|X|3|K|5|L|7|2C|8|@]|9|@$M|2D|N|2E|1|2F]]|A|$]]|$1|Y|3|I|5|6|7|2G|8|@]|9|@]|A|$]]|$1|Z|3|10|5|6|7|2H|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|2I|8|@]|9|@]|A|$]]|$1|13|3|14|5|15|7|2J|8|@]|9|@]|A|$16|17]]|$1|18|3|19|5|6|7|2K|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|2L|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|6|7|2M|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|15|7|2N|8|@]|9|@]|A|$16|17]]|$1|1G|3|-4|5|6|7|2O|8|@]|9|@]|A|$]]]|1H|$1I|$5|1J|1K|1L|A|$1M|1N|1O|-4]]|1P|$5|1J|1K|1L|A|$1M|1Q|1O|-4]]|1R|$5|1J|1K|1L|A|$1M|1S|1O|-4]]]]

It is not possible to have strongly typed access to a datagridview if a tableadapter is not being used inside the dataset.

To have access to strongly typed variables when a datagridview is bound to a datatable through a bindingsource, do as follow:

Create a New Project.

Insert a DataSet named ds1 and a DataTable named dt99 with columns named DataColumn1 and DataColumn2, both string type.

<a href="https://i.stack.imgur.com/fyY9U.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fyY9U.png" alt="enter image description here"></a>

Add a datagridView to the main form and bind it to the dt99 

<a href="https://i.stack.imgur.com/9tYlG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9tYlG.png" alt="enter image description here"></a>

So that the dt99BindingSource connects the datagridview and the datatable

<a href="https://i.stack.imgur.com/00QyS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/00QyS.png" alt="enter image description here"></a>

Add and event handler for the Selection Change of the datagridview, and insert the following piece of code

private void dataGridView1_SelectionChanged(Object sender, EventArgs e)
{

<pre><code> ds1.dt99Row d= ((ds1.dt99Row)((DataRowView)dt99BindingSource.Current).Row);

 Debug.WriteLine(d.DataColumn1 + " " + d.DataColumn2);
</code></pre>

}

Now you have strongly typed variables (d.DataColumn1 and d.DataColumn2) to access the cells being selected on the datagridview

Another interesting feature is that a datatable inserted inside a dataset provides a set of public classes that helps a lot when handling datatables, for example

<pre><code> private void Form1_Load(Object sender, EventArgs e)
 {
 ds1.dt99.Adddt99Row("K", "B");
 ds1.dt99.Adddt99Row("L", "D");
 ds1.dt99.Adddt99Row("M", "F");
 ds1.dt99.Adddt99Row("N", "H");

 ds1.dt99Row dr = ds1.dt99.Newdt99Row();
 dr.DataColumn1 = "X";
 dr.DataColumn2 = "Y";
 ds1.dt99.Adddt99Row(dr);

 }
</code></pre>

I have a DataTable bound to a DataGridView. I have FullRowSelect enabled in the DGV. Is there a way to get the selected row as a DataRow so that I can get strongly typed access to the selected row's values?

How Do I Get the Selected DataRow in a DataGridView?

数据库

Windows

我有一个绑定到DataGridView的DataTable。我在DGV中启用了FullRowSelect。有没有一种方法可以将所选行作为DataRow，这样我就可以强类型访问所选行的值？

问如何在DataGridView中获取选定的DataRow？
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在DataGridView中获取选定的DataRow？EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在DataGridView中获取选定的DataRow？
EN