GridView Inside Repeater Control in ASP.Net

Vishal Gilbile
11y
55.8k
0
1

Article

This article is an extension of my previous article. If you have not taken a look at it kindly click the following link.

http://www.c-sharpcorner.com/UploadFile/17e8f6/nested-repeater-control-in-Asp-Net-4-0/

Well in the preceding article we have nested a repeater control inside one another, but the scenario changes every time, you might want to display data in a more standardized and sophisticated way than just displaying it inside a table control or something like that. Now in this article we will basically learn how to display a GridView control inside a repeater control.

For demonstrating this article we will use a scenario of members placing orders in an online shopping website. Let's say we have a member who place orders for 7 different items respective to the quantity. Now for displaying that member's private data (such as their mailing address, any member instruction given for dispatching data, orderDate, OrderID, Member Name, Membership_ID etc.) along with the products that he/she has added to the cart (details such as productName,Quantities of the product, MRP's of the products etc.) to the administrator of the website. Now from the preceding scenario we will try to create a front end for the administrator who will learn the latest order details placed by the member.

The final output of what we will display will be like the following:

OK now let's start with the code. For demonstrating the preceding I've used an Oracle Database. The script for it has been included in the article folder.

The following is it:

CREATE TABLE HQM_ADMIN.MEMBERSHIP

(

MEMBERSHIP_ID VARCHAR2(30 BYTE),

MEMBERTITLE VARCHAR2(6 BYTE),

MEMBERNAME VARCHAR2(30 BYTE),

USERNAME VARCHAR2(100 BYTE) NOT NULL,

WORD VARCHAR2(20 BYTE) NOT NULL,

ADDRESS VARCHAR2(500 BYTE)

)

CREATE SEQUENCE HQM_ADMIN.MEMBERSHIP_SEQ

START WITH 5

MAXVALUE 9999999999999999999999999999

MINVALUE 1

NOCYCLE

NOCACHE

NOORDER;

CREATE OR REPLACE PROCEDURE HQM_ADMIN.prc_addmember (

v_title VARCHAR2,

v_name VARCHAR2,

v_address VARCHAR2,

v_username VARCHAR2,

v_word VARCHAR2

)

v_memid VARCHAR (20) := '';

n_memid NUMBER := 0;

BEGIN

n_memid := membership_seq.NEXTVAL;

IF (n_memid < 10)

THEN

v_memid := 'M00' || n_memid;

ELSE

v_memid := 'M0' || n_memid;

END IF;

INSERT INTO membership

(membership_id, membertitle, membername, username, WORD,

address

)

VALUES (v_memid, v_title, v_name, v_username, v_word,

v_address

);

END;

NOTE: here you could use the Lpad function of Oracle for appending the M00 or M0 with the v_memid variable.

select * from Membership

CREATE TABLE HQM_ADMIN.TBL_MST_ORDERS

(

ORDERID VARCHAR2(30 BYTE),

MEM_ID VARCHAR2(30 BYTE) NOT NULL,

ORDER_VALUE FLOAT(126) NOT NULL,

CUSTOMER_INSTRUCTION VARCHAR2(2000 BYTE),

ORDER_COMMENTS VARCHAR2(2000 BYTE),

ORDER_DATE DATE DEFAULT sysdate,

ORDER_DELIVEREDSTATUS INTEGER DEFAULT 0,

ORDER_DELIVERYDATE DATE DEFAULT null,

ORDER_CANCELLEDFLAG INTEGER DEFAULT 0

)

CREATE SEQUENCE HQM_ADMIN.ORDER_SEQ

START WITH 5

MAXVALUE 9999999999999999999999999999

MINVALUE 1

NOCYCLE

NOCACHE

NOORDER;

CREATE OR REPLACE PROCEDURE HQM_ADMIN.prc_addorder (

v_memberid VARCHAR,

f_ordervalue FLOAT,

v_custinfo VARCHAR

)

n_orderid NUMBER;

v_orderid VARCHAR (30);

BEGIN

n_orderid := order_seq.NEXTVAL;

IF (n_orderid < 10)

THEN

v_orderid := 'O00' || n_orderid;

ELSE

v_orderid := 'O0' || n_orderid;

END IF;

INSERT INTO tbl_mst_orders

(orderid, mem_id, order_value, customer_instruction

)

VALUES (v_orderid, v_memberid, f_ordervalue, v_custinfo

);

END;

NOTE: here you could use the Lpad function of Oracle for appending the O00 or O0 with the v_orderID variable.

CREATE TABLE HQM_ADMIN.TBL_MST_ORDERDESCRIPTION

(

ORDERID VARCHAR2(30 BYTE) NOT NULL,

PRODNAME VARCHAR2(30 BYTE) NOT NULL,

QUANTITY INTEGER NOT NULL,

MRP FLOAT(126) DEFAULT 0,

ITEM_CANCELLEDFLAG INTEGER DEFAULT 0,

ITEM_COMMENTS VARCHAR2(4000 BYTE) DEFAULT 'No Comments'

)

Insert into TBL_MST_ORDERDESCRIPTION