I have used data table for retrive selected items from previous page selected and updates its column value in data base using C# code

Question

0.00/5 (No votes)

See more:

i am uses sql server for data base and i am developing a shopping website and based on selected items and quantity i want to reduce the particular selected items quantity from my database i am using datatable dt= session["byeitms"]

What I have tried:

please help me . i have tried quantity=quantity -dropdownlist1.selecteditems and many of things to solve this problems but not getting solution . please help me

Posted 10-Jan-19 20:29pm

Member 14066382

Updated 11-Jan-19 2:13am

Add a Solution

Comments

F-ES Sitecore 11-Jan-19 4:56am

Datatables aren't very good for things like this. What you need to do is look into Entity Framework, if you google you'll find "getting started" articles or you can get a book on it. You can use Entity Framework to manipulate any data in your database you want, so reading it, updating it etc.

Member 14066382 11-Jan-19 8:17am

ok i will try thanks

1 solution

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)

MadMyche · Answer 1 · 2019-01-11T02:13:00

Mr recommendation would not be doing in directly in the product DataTable directly; rather the DataTable should be refreshed at the time of view based on the product table which has the actual stock level already in it.

You have already asked and been answered on how to do this:
==> Reduce stock available from table in ASP .NET[^]

If further help is needed, it is generally recommended to include related questions so people can have a better picture of what is already going on. If this solution is not working or you don't know to implement, just say so and someone may be able to help you with that portion.