亲自试试

考试 [ ^ ]

请参阅以下链接： -

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[^]