heading wise value bind

siva balan

Hello guys, I have two table

1)tblVariety

DID Dishtype AddedDate

DT001 Veg 2016-09-30

DT002 Non-Veg 2016-09-30

DT003 Coffee 2016-09-30

DT004 Cakes 2016-09-30

2)tblProducts

ProId ProductName ProductDescription ProductPrice VNV

MN001 Dosa South indian famous food 60 Veg

MN002 Meals Rice and chenna fry and more indian culture 150 Veg

MN003 Burger Its chines made culture and fastfoods 80 Veg

MN004 Chettinadu chicken Its very tasty and spicy 100 Non-Veg

MN005 chicken Loipop this chicken leg piece fry 120 Non-Veg

MN006 Grill chicken its very fry in grill machines 350 Non-Veg

MN007 choco cofee its hard choco and sweetest without milk 100 Coffee

MN008 Mintmojiti mint tast its feel fresh 100 Coffee

MN009 Straberry Milkshake Its healthy and sweetest items 150 Coffee

MN010 Home Strawberry its a sweetest and tasty 90 Coffee

MN011 Chocolate cake its a dark choco and soft emmy 300 Cakes

MN012 Mary Berry its formal and crunchi cake 200 Cakes

MN013 Buttar confetti its a milk mixed made cake 150 Cakes

I want output in:

Veg

Dosa Meals Burger

South indian famous food Rice and chenna fry and more indian culture cheinese ffood

60 150 80

Non-Veg

Chettinadu chicken

Its very tasty and spicy

100

Cofee

(values)...................................

Cakes

(Values).............................................

Any one please help me

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp10y ago
Accepted answer
Hi,
Please check the attached file.
0
siva balan10y ago
Midhun sir can you try to in sql
0
Midhun Tp10y ago
Hi,
There were some conflict in the first file I attached with the format you provided. Please check this attached file. And regarding sql, it will be little difficult to implement.
0
siva balan10y ago
If its possible in sql its easy for me..
0
siva balan10y ago
Thank you so much Midhun sir
0
siva balan10y ago
I am using repeater concept to binding the value

Please see this link i want output looking like this please help me guys
http://www.lstanza.com/Menu.aspx
0
Jitendra Kumar10y ago
Hello,
try below approach.

first fetch the records from tblVariety

var rec=db.tblVariety.tolist();

then fetch product using foreach loop and show as require.

foreach(var item in rec)
{
string str=item.Dishtype.tostring();
var product=db.tblProducts.where(x=>x.prod==item.did).tolist();

// show data in table

}
0
siva balan10y ago
c#
0
Midhun Tp10y ago
Hi,
You are trying to do this in SQL or C#?
0