将数据库绑定到datagridview [英] bind database to datagridview

问题描述

嗨



我有这个查询

 选择 Team_Leader，items，Sum（qty） as  Total_Qty，avg（Rate） as  Average_Rate  FROM  [Material_database]。[dbo]。[mat_utiAndtrans] m，[Material_database]。[dbo]。[code] c 其中 c.Codes = m.code  group   by  Team_leader，items 

我需要使用此查询将数据库绑定到我的datagridview ....任何人都可以通过编码帮助帮助我这样做。

Datagridview应该像



Team_Leader项目总数量Average_Rate





谢谢

解决方案

亲自试试

考试 [ ^ ]

请参阅以下链接： -

http://www.aspdotnet-suresh.com/2010/12/v-behaviorurldefaultvmlo_27.html [ ^ ]

http://dotprogramming.blogspot.com/2013/09/how-to-bind-datagridview-with-dataset。 html [ ^ ]

http://www.aspsnippets.com/Article s / Bind-Fill-DataGridView-in-Windows-Forms-WinForms-Application-in-C-and-VBNet.aspx [ ^ ]

http://csharp.net-informations.com/datagridview/csharp-datagridview-sql -server.htm [ ^ ]

Hi

I have this query

select Team_Leader ,items ,Sum(qty) as Total_Qty,avg(Rate) as Average_Rate FROM [Material_database].[dbo].[mat_utiAndtrans] m, [Material_database].[dbo].[code] c where c.Codes=m.code group by Team_leader ,items

I need to bind database using this query to my datagridview.... can anyone help me do this with coding help.
Datagridview should be like

Team_Leader items Total Qty Average_Rate


Thanks

解决方案

Try it yourself
example[^]

refer below links:-
http://www.aspdotnet-suresh.com/2010/12/v-behaviorurldefaultvmlo_27.html[^]
http://dotprogramming.blogspot.com/2013/09/how-to-bind-datagridview-with-dataset.html[^]
http://www.aspsnippets.com/Articles/Bind-Fill-DataGridView-in-Windows-Forms-WinForms-Application-in-C-and-VBNet.aspx[^]
http://csharp.net-informations.com/datagridview/csharp-datagridview-sql-server.htm[^]

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