Loading

How to get specified user name records in grid view ASP.net

Kasuni Abegunawardana

8y1.3k.NET

Hi all,

I created a shopping cart and save them into database.

I want to show those shopping cart data according to the logged in user.

But when I'm retrieving data from database using a grid view it shows every user's data.

How to retrieve data without filtering (using textbox or dropdown)

I want to do it code behind.How can I do that?

Thank you n advance.

2 Replies

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

Ankit Sharma8y ago
Accepted answer
Hi,

since you hace not posted your SQL code, So i suggest you to please put a where clause in the query to filter data for userid of logged in user only, while binding to gridview.
You may need to use join user's data table to user login details table.
Nithya Mathan8y ago
Refer the following article in this Link : http://www.c-sharpcorner.com/UploadFile/0c1bb2/searching-records-from-database-and-display-in-gridview-usin/