Tables:
Create Database with the name as "NestedGridView" and create following tables in that database.
Stored Procedures:
Create Procedure sp_GetFileDetails(@FileId int)AS
Begin
select * from tbl_Files where FileId = @FileId End
Create procedure sp_GetFilesFromCartAs
begin
select * from tbl_Cart c inner join tbl_Files f on
f.FileId = c.FileId end
begin
select * from tbl_Cart c inner join tbl_Files f on
f.FileId = c.FileId end
Create procedure sp_GetPrintSizeAs
Begin
select * from tbl_PrintSize End
Begin
select * from tbl_PrintSize End
READ MORE>>
0 comments:
Post a Comment