Change table rows in database instead manual table using ASP.NET core C#

Question

1.00/5 (3 votes)

See more:

I want to change table rows in my database, instead manual table.

This is my code:

public interface IMainMenuService
{
    List<MainMenuTable> GetAllMenu();
}

public class MainMenuService : IMainMenuService
{
        public List<MainMenuTable> GetAllMenu()
        {
            return new List<MainMenuTable>()
            {
                new MainMenuTable() {Link = "link1", Title = "Title1"},
                new MainMenuTable() {Link = "link2", Title = "Title2"},
                new MainMenuTable() {Link = "link3", Title = "Title3"},
                new MainMenuTable() {Link = "link4", Title = "Title4"}
            };
        }
    }

What I have tried:

I want to change table rows in my database, instead manual table.

Posted 14-Aug-22 10:01am

Member 10618364

Updated 14-Aug-22 22:19pm

Add a Solution

Comments

OriginalGriff 14-Aug-22 16:33pm

And?
What does it do that you didn't expect, or not do that you did?
What have you tried to do to find out why?
Are there any error messages, and if so, where and when? What did you do to make them happen?

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with.
Use the "Improve question" widget to edit your question and provide better information.

Member 10618364 15-Aug-22 0:19am

the question is crystalClear it isnt matter what did this code. in this code "return new List<mainmenutable>()" i load data manually but i want load data from my table "MainMenuTable" in database.

OriginalGriff 15-Aug-22 0:49am

"the question is crystalClear"
No, it isn't. It may be to you, but all we get to work with is exactly what you type - we have no other context. And you haven't asked a question at all - just shown us some code which doesn't seem relevant, and told us you want to change rows we can't see, in a table we can't see, in a database we can't see - using "instead manual table" which makes no sense to us at all in isolation.

Imagine this: you go for a drive in the country, but you have a problem with the car. You call the garage, say "it broke" and turn off your phone. How long will you be waiting before the garage arrives with the right bits and tools to fix the car given they don't know what make or model it is, who you are, what happened when it all went wrong, or even where you are?

That's what you've done here. So stop typing as little as possible and try explaining things to people who have no way to access your project!

It would also be a good idea if you go here Asking questions is a skill[^] and think about what you need to know, and what you need to tell us in order to get help.

We're not trying to be awkward, we just can't work in a vacuum!

Member 10618364 15-Aug-22 1:54am

OK this is my table: "MainMenuTable" i want to Return All Of Rows in "MainMenuTable" from this Function= "public List<mainmenutable> GetAllMenu()"

OriginalGriff 15-Aug-22 2:02am

:sigh:

OK. You have a table - I know the name. What I don't know is where it is, what DB it is stored in, what DB type that is, what the columns might be called, or even what the class "MainMenuTable" or "mainmenutable" might contain.

Or what you have tried, where you are stuck, or what actual help - other than "write me code for me" - you might need.

So, we're peachy really. No more info could possibly be wanted.

I am serious when I say we only get exactly what you type to work with ... Go follow the link I gave you, and read up on how to ask a question. Please?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Answer 1 · 2022-08-14T22:19:00

Based on the limited information available, and the lack of DB code, I understand the question as "How do I work with SQL Server to maintain my data?"

There are fantastic tutorial websites that will answer these questions and more better than we can here in this limited forum.

For Dot Net Core apps, like Asp.Net Core, I recommend the following 2 (depends on your preference):
1. Entity Framework Core Tutorials[^]
2. Entity Framework Core Documentation And Tutorials | Learn Entity Framework Core[^]

Member 10618364 · Answer 2 · 2022-08-14T20:46:00

ok I Want Load Main Menu of MySite Dynamically With SqlServer DataBase.
my project is "asp.net core razor page"
I using ComponentView for MainMenu.
I use Service to load mainmenu
this is IMainMenuService Code:

namespace WebApplication4.Utilities.Services.MainMenu
{
    public interface IMainMenuService
    {
        List<MainMenuTable> GetAllMenu();
    }

    public class MainMenuService : IMainMenuService
    {
         public List<MainMenuTable> GetAllMenu()
        {
            return new List<MainMenuTable>()
            {
                new MainMenuTable() {Link = "link1", Title = "عنوان1"},
                new MainMenuTable() {Link = "link2", Title = "عنوان2"},
                new MainMenuTable() {Link = "link3", Title = "عنوان 3"},
                new MainMenuTable() {Link = "link4", Title = "عنوان 4"}
            };
        }
}

this is _Layout file:

C#

@await Component.InvokeAsync("MainMenuComponent")

this is MainMenuComponent:

<pre>namespace WebApplication4.Pages.Shared.Components
{
    public class MainMenuComponent : ViewComponent
    {
        private IMainMenuService _mainMenuService;

        public MainMenuComponent(IMainMenuService mainMenuService)
        {
            _mainMenuService = mainMenuService;
        }

        public async Task<IViewComponentResult> InvokeAsync()
        {
            return View("/Pages/Shared/Components/_MainMenu.cshtml", _mainMenuService.GetAllMenu());
        }
    }
}

Now i Want to Return MainMenuTable Rows in

public List<MainMenuTable> GetAllMenu()

Change table rows in database instead manual table using ASP.NET core C#

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0