开发者

Selecting multiple table values and binding the data into multiple grids

开发者 https://www.devze.com 2023-01-18 22:45 出处:网络
I have multiple tables . I have created one stored proced开发者_JAVA技巧ure where I am selecting the table values.

I have multiple tables .

I have created one stored proced开发者_JAVA技巧ure where I am selecting the table values.

like

  create proc myProc
  as
        select col1, col2, col3 from table1
        select cola, colb, colc from table2
        select colp, colq, colr from table3
        select colx, coly, colz from table4

I am using LINQ to retrieve the Data. So Using Linq I am calling the stored procedure. So I ll get the table values in the C# Code the table values.

so in my UI i have 4 gridviews.

I want split the output values into four source and bind it to the grid.

So Please give me some example and source which ll help me the best.

Thanking you in Advance

Umakanta.


Check out these blogs, it may help you:

http://blogs.msdn.com/b/swiss_dpe_team/archive/2008/02/04/linq-to-sql-returning-multiple-result-sets.aspx

http://blogs.microsoft.co.il/blogs/bursteg/archive/2007/10/05/linq-to-sql-stored-procedures-with-multiple-results-imultipleresults.aspx

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号