Loading

update data on button click using linq in asp.net Entity Framework

update data on button click using linq in asp.net Entity Framework

Guest User

6y1.2kLearn iOS Programming

I am trying to do update data...i use linq but cant take

FirstOrDefault()

First()

protected void BtnUpdate_Click(object sender, EventArgs e)
{
using (var context = new WallpaperEntities7())
{
var CategoryName = TxtCategoryName.Text;
var Category = int.Parse(Request["Id"])
WallPaperCategory std = (from x in context.WallPaperCategries
where x.CategoryName == CategoryName
select x)

7 Replies

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

Varun Setia6y ago
Accepted answer
I hope std is not empty and you are not getting any exception and Your complete code looks like this?
protected void BtnUpdate_Click(object sender, EventArgs e)
{
using (var context = new WallpaperEntities7())
{
var CategoryName = TxtCategoryName.Text;
var Category = int.Parse(Request["Id"]);


WallPaperCategory std = (from x in context.WallPaperCategries
where x.CategoryName == CategoryName
select x).
std.[Property] = [New-value];
context.SaveChanges();

} //End of using

}
Guest User6y ago
hi Varun Setia

now i am try this bt still not

var CategoryName = TxtCategoryName.Text;
var Category = int.Parse(Request["Id"]);
WallPaperCategory std = (from x in context.WallPaperCategries
where x.CategoryName == CategoryName
select x).
if (std != null)
{
std.CatergoryName = TxtCategoryName.Text;
context.SaveChanges();
Guest User6y ago
var CategoryName = TxtCategoryName.Text;
var Category = int.Parse(Request["Id"]);
WallPaperCategory std = (from x in context.WallPaperCategries
where x.CategoryName == CategoryName
select x).

std is not empty...bt still doesnt work...????
Guest User6y ago
hi
Varun Setia

its doesnt work
Varun Setia6y ago
1. WallPaperCategory std = (from x in context.WallPaperCategries
2. where x.CategoryName == CategoryName
3. select x).First();
5. std.[PropertyName] = [NewValue] //Update value
6. context.SaveChanges(); //make sure to call this after changing value

Guest User6y ago

hi

Rajanikant Hawaldar...

its doesnt work for my senerio....Refer something else

Rajanikant Hawaldar

Rajanikant Hawaldar6y ago

Hello Nivi Sharma, refer below article

https://www.c-sharpcorner.com/article/bind-add-update-delete-data-using-mvc-entity-framework-and-linq/