how to insert values entered in datagridview into database table?

Question

I want to insert the numbers entered in a datagridview to a database table. Whenever I do this, only 0 is entered in the table no matter whatever number is entered in the datagridview. Here is my code..

decimal num=Convert.ToDecimal(amountdataGridView.Rows[0].Cells["amountColumn"].Value);
cmd = new SqlCeCommand("insert into Deposit values('" + num + "')", con);
cmd.ExecuteNonQuery();

Do you want to store 1 value or all values in the datagridview? — NoChance
– NoChance, Commented Nov 5, 2013 at 6:28
only 1 value from a particular row.. table consists of only 1 column — Jayesh Babu
– Jayesh Babu, Commented Nov 5, 2013 at 6:34
I have edited your title. Please see, "Should questions include “tags” in their titles?", where the consensus is "no, they should not". — John Saunders
– John Saunders, Commented Nov 5, 2013 at 6:37

Edper · Accepted Answer · 2013-11-05 06:27:08Z

1

Try to remove the single quote and num to String using ToString():

cmd = new SqlCeCommand("insert into Deposit values('" + num + "')", con);

So, that it would become

cmd = new SqlCeCommand("insert into Deposit values(" + num.ToString() + ")", con);

answered Nov 5, 2013 at 6:27

Edper

9,3621 gold badge32 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

lauCosma · Accepted Answer · 2013-11-05 06:24:57Z

0

Make sure num is not null before inserting into database and try to remove the quotes around the value in the insert statement :

cmd = new SqlCeCommand("insert into Deposit values( " + num + ")", con);

And also try to output your sql statement and manualy insert it yourself to see if the insert is ok like:

MessageBox.Show("INSERT INTO Deoposit VALUES("+num+")");

Hope this helps.

answered Nov 5, 2013 at 6:24

lauCosma

15410 bronze badges

4 Comments

Jayesh Babu Over a year ago

its still not working.. when i enter the value of num as 100, the value entered in the table is 0.

lauCosma Over a year ago

Your table has any other columns, do you have some validation on the database side? What database are you using ? And what type is the Deposit column?

Jayesh Babu Over a year ago

im using ms sql server compact edition 3.5 . column is a float datatype.. there is only 1 column in the table..

lauCosma Over a year ago

try to change from float to decimal datatype because decimal requires more storage space.

Masoumeh Karvar · Accepted Answer · 2013-11-05 06:57:15Z

0

try 'Text' instead of 'Value', I tried this and it works: SearchResultGridView.Rows[0].Cells[0].Text

note that Convert return 0 if amountdataGridView.Rows[0].Cells["amountColumn"].Value be null. did you check if your value is correct?

edited Nov 5, 2013 at 6:57

answered Nov 5, 2013 at 6:41

Masoumeh Karvar

7911 gold badge16 silver badges33 bronze badges

3 Comments

Jayesh Babu Over a year ago

i checked the value of num. its always null. is there any problem in convertion..?

Masoumeh Karvar Over a year ago

did you try replacing "amountColumn" with an index (like 0)? replace "amountColumn" with your cell index and try again.

Jayesh Babu Over a year ago

i hav only one cell.. then cell index will be 0. isn't it..?

Collectives™ on Stack Overflow

how to insert values entered in datagridview into database table?

3 Answers 3

Comments

4 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related