Loading

Reportviewer - Mysql - StoredProcedures

Kavi suja

Hi,
I have to generate report using reportviewer in .net using c#.I use mysql as DB.Now i've to write stored procedures for retriving data from three tables,having id as common field in tables.i'm new to stored procedures.Can u help me guys......
Guide me about stored procedures.

2 Replies

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

Pankaj Pandey13y ago
try it..

DELIMITER //
CREATE PROCEDURE GetAllProducts()
BEGIN
SELECT T1.A,T1.B,T2.C,T2.D.T3.E FROM table1 T1 left join table2 T2 on T1.id=T2.Id
left join table3 T3 on T1.id=T3.Id and T2.id=T3.id
END //
DELIMITER ;
0
Sunny Sharma13y ago
I think you've posted the same question twice. Just answered I here, PS:

http://www.c-sharpcorner.com/Forums/Thread/212568/retrive-data-from-multible-tables-using-stored-procedures.aspx

Thanks.
0