fetch data from database & display using entity framework asp.net c#

Question

Fetch or retrive data and display in textbox using entity framework in asp.net C#

Sachin Singh · Answer

@Nivi yes how linq to Entites will recognize it, its wrong sorry for that first convert the session to string before using it in linq query like below string UName=Convert.ToString(Session["UserName"]); then use it in query var query = (from c in context.Users where c.userName==UName select new {}

Sachin Singh · Answer

So you are allowing users to edit their profile. There is no need to create two forms follow below steps:- 1.Ask user to log in by his username and psd. 2.Save the username in session (if you are not using identity) 3.On Edit profile click WallpaperEntities3 context = new WallpaperEntities3(); var query = (from c in context.Users where c.userName==Convert.ToString(session[userName]); select new { c.Name, c.UserName, c.EmailID, c.Password, c.Confirm_Password }).FirstOrDefault(); if (query != null) { TxtName.Text = query.Name; TxtUserName.Text = query.UserName; TxtEmailID.Text = query.EmailID; TxtPassword.Text = query.Password; TxtConfirmPassword.Text = query.Confirm_Password; } } }

Guest User · Answer

Thank you so much aashima khatoon

Guest User · Answer

hi aashima khatoon, when i use ur senerio its throe this exception... LINQ to Entities does not recognize the method 'System.String ToString(System.Object)' method, and this method cannot be translated into a store expression.

Jenith Thakkar · Answer

Hi Nivi I read your code it seems like okay Please update here what kiind of error throwing Thank you

Guest User · Answer

Hi...Here is my code.. aspx(design) .style1 { width: 50%; text-align: center; padding: 50px 0 24px 134px; margin: 30px 0 0 170px; } body, html { font-family: 'Open Sans', sans-serif; width: 100% !important; height: 100% !important; } .intro { display: table; width: 100%; height: auto; text-align: center; color: #fff; } td{ padding: 11px 5px 6px 50px; font-size: 21px; font-weight: bold; } h1{ padding: 6px 8px 1px 0px; color: black; } .btn{ padding: 0px 8px 0px 8px; display: block; margin: auto; } User Profile Name: UserName: EmailID: Password: Confirm Password: onclick="Button1_Click" /> .style1 { width: 50%; text-align: center; padding: 50px 0 24px 134px; margin: 30px 0 0 170px; } body, html { font-family: 'Open Sans', sans-serif; width: 100% !important; height: 100% !important; } .intro { display: table; width: 100%; height: auto; text-align: center; color: #fff; } td{ padding: 11px 5px 6px 50px; font-size: 21px; font-weight: bold; } h1{ padding: 6px 8px 1px 0px; color: black; } .btn{ padding: 0px 8px 0px 8px; display: block; margin: auto; } User Profile Name: UserName: EmailID: Password: Confirm Password: onclick="Button1_Click" /> aspx.. using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace WalPaper { public partial class WebForm4 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { { WallpaperEntities3 context = new WallpaperEntities3(); string Id = Request.QueryString["Id"]; // string UserName = TxtUserName.Text; var query = (from c in context.Users where TxtUserName.Text == c.UserName select new { c.Name, c.UserName, c.EmailID, c.Password, c.Confirm_Password }).FirstOrDefault(); if (query != null) { TxtName.Text = query.Name; TxtUserName.Text = query.UserName; TxtEmailID.Text = query.EmailID; TxtPassword.Text = query.Password; TxtConfirmPassword.Text = query.Confirm_Password; } } } } protected void Button1_Click(object sender, EventArgs e) { } } }

Jignesh Kumar · Answer

Hi Nivi, Use this link which will help you, https://www.c-sharpcorner.com/article/entity-framework-basic-guide-to-perform-fetch-filter-insert-update-and-dele/

Sachin Singh · Answer

YourDbContext db=new YourDbContext(); var yourEntity=db.yourDbSet.Any(x=>x.id); // i hope you are passing something like id to filter. YourTextbox.Text=YourEntity.Name ; // any property of your entity

Atul Warade · Answer

Hi Nivi, Can you please share your code so that I can look into it and let you know

Santhakumar Munuswamy · Answer

Hi Nivi, you can share your code what you have tried so far. i will check and let you know

Guest User · Answer

hi Atul Warade,, not working '

Guest User · Answer

Hi Santhakumar Munuswamy, Its nt working.

Santhakumar Munuswamy · Answer

Hi Nivi Sharma, you can check out the below link and I think, this reference will give you some idea to find a way to your question https://www.c-sharpcorner.com/article/entity-framework-basic-guide-to-perform-fetch-filter-insert-update-and-dele/ https://www.aspsnippets.com/Articles/Retrieve-Display-data-from-Database-in-TextBoxes-in-ASPNet-MVC.aspx Let me know if you have the opportunity to get some ideas.

Atul Warade · Answer

Hi Nivi, Please go through below URL it might help you https://www.youtube.com/watch?v=kSFkF4TVDIs