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

Guest User

6y1.1kLearn iOS Programming

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

14 Replies

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

Sachin Singh6y ago
Accepted 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
{}
+3
Guest User6y ago
Thank you so much
aashima khatoon
+1
Guest User6y ago
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.
+1
Jenith Thakkar6y ago
Hi Nivi
I read your code it seems like okay
Please update here what kiind of error throwing

Thank you
+1
Sachin Singh6y ago
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;

}

}
}

+2

Guest User6y ago

Hi...Here is my code..

aspx(design)

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Profile.aspx.cs" Inherits="WalPaper.WebForm4" %>

User Profile

Name:
UserName:
EmailID:
Password:
Confirm Password:

onclick="Button1_Click" />

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Profile.aspx.cs" Inherits="WalPaper.WebForm4" %>

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 Kumar6y ago
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/
+1
Sachin Singh6y ago
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
+1
Atul Warade6y ago
Hi Nivi, Can you please share your code so that I can look into it and let you know
+1
Santhakumar Munuswamy6y ago
Hi Nivi,

you can share your code what you have tried so far. i will check and let you know
+1
Guest User6y ago
hi
Atul Warade,,
not working

'
+1
Guest User6y ago
Hi
Santhakumar Munuswamy,
Its nt working.
+1
Atul Warade6y ago
Hi Nivi,

Please go through below URL it might help you

https://www.youtube.com/watch?v=kSFkF4TVDIs
0
Santhakumar Munuswamy6y ago
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.
+1

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

aashima khatoon

aashima khatoon,

User Profile

User Profile

Atul Warade,,

Santhakumar Munuswamy,