How to retrieve data according to the user name into grid

Question

Hi all How to retrieve data according to the user name into gridview in asp.net web forms. I tried a lot but it doesn't work. I have created an online food diary i want to retrieve data according to the user name from the table. Thank you.

Laxmidhar Sahoo · Answer

hi In the Kasuni code try to made some changes Kasuni code using (DataTable dt = new DataTable()) { sda.Fill(dt); GridView1.DataSource = dt; } Changes code Dataset ds = new Dataset(); sda.Fill(ds); GridView1.DataSource = ds.tables[0];

Kasuni Abegunawardana · Answer

I did it like this but it doesn't work. Nothing can view. protected void Page_Load(object sender EventArgs e) { lbl_userNameDisplay.Text = Session[U_Email] as String; Session[U_Email] = lbl_userNameDisplay.Text.Trim(); BindGrid(); } private void BindGrid() { string constring = @Data Source=ADMIN;Initial Catalog=FoodCalorieCalculator_db;Integrated Security=True; using (SqlConnection con = new SqlConnection(constring)) { using (SqlCommand cmd = new SqlCommand(SELECT * FROM AddToDiary_tb where U_EmailAddress=' + Session[U_Email].ToString() + ' con)) { cmd.CommandType = CommandType.Text; using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); GridView1.DataSource = dt; } } } } }

Kasuni Abegunawardana · Answer

Yeah i can understand this one. How to select it. I just want to know to fill a grid view. usually we are using sqldatasources. For this time i cannt use a datasource.

Rathrola Prem Kumar · Answer

Try this For eg : SqlCommand cmd = new SqlCommand(SELECT CustomerId ContactName City Country FROM Customers where Contactname = loggedinuser)) First get filtered records base on user then dispaly it in gridview

Kasuni Abegunawardana · Answer

Yeah i got it. But the thing is how can i get it into a grid view

Rathrola Prem Kumar · Answer

As per my understanding if u login on ur machine then you want see only the records related to you isnt? Solution 1: Get the current loggedin Username from below statement string userName = System.Security.Principal.WindowsIdentity.GetCurrent().Name; Then filter with this username in you inline query statement.. Solution 2: You can implement WINDOWS AUTHENTICATION for your application. Reference: http://www.c-sharpcorner.com/UploadFile/dacca2/implement-windows-authentication-in-Asp-Net/

Kasuni Abegunawardana · Answer

Hi Mr.Rathrola Usually we fill the grid view using a sqldata source. Then it brings all the records of the table. But i want to take only for one user records. Imagine my UserName is kasuni and want to see what are things i have done.Not other users records. How can do that? Please can you say what i wanna do. Thank you in advance.

Rathrola Prem Kumar · Answer

Hi Ms.Kasuni Implement Forms authentication or else go for Roles Authentication. Let me know if you need any assistance regards to this. Thank you Rathrola