how to insert newly datagrid values into database

Posted by Oswaldlily under VB.NET on 4/3/2014 | Points: 10 | Views : 1413 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I need to insert newly entering values into database..

So i m using Datagridview_Rowsadded which gets called even while screen gets load.

As a result,all old values in datagridview also gets inserted newly again & again...

How shall i avoid it by making insert possible only for newly entering values???????????????

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Vinothkumar on: 4/11/2014 [Member] Starter | Points: 25

0	Check it in db while inserting with some primary column.. IF EXISTS(SELECT 1 FROM TableName WHERE ID=@YouID) --UPDATE ELSE --INSERT END Hope this helps you.. Regards, Vinoth kumar Oswaldlily, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts

How to get the exact property name while getting error (0)
PDB file is not showing Line Number in dot net application hosted on server (0)
Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different (0)
how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON) (1)
can't receive data after success login ? (1)
Implement Multi-Tenant in Azure Logic Apps (0)
Why ASP.Net Core 7.0 Web API showing as Connection refused? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
More ...