inserting values in the database

Question

0.00/5 (No votes)

See more:

ASP.NET

hello,
Can I update a column of a table by the values of an array?

Posted 23-Jul-12 19:30pm

Pradeep_kaushik

Updated 23-Jul-12 19:40pm

_Amy

v2

Add a Solution

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)

Abhinav S · Answer 1 · 2012-07-23T19:45:00

Solution 2

You question is not very clear but, yes, you can.
Just select the value using the particular index in the array and then save it to the database.

Posted 23-Jul-12 19:45pm

Abhinav S

Comments

_Amy 24-Jul-12 1:46am

Anyway Abhinav, for selecting the particular index he needs an ID. Right?

Abhinav S 26-Jul-12 1:47am

Yes that is correct. He will need something to get the id to access the array element.

_Amy · Answer 2 · 2012-07-23T19:44:00

Solution 1

Hi,
I don't think so that you can update a table value with an array without having ID. For ID you can use HashTable(Key & Value pair). It will help you to update only those record which is having an unique ID.
Anyway check this out:
Update table using SqlDataAdapter[^]

--Amit

Posted 23-Jul-12 19:44pm

_Amy

Updated 23-Jul-12 19:52pm

v2