database insertion and updation

Question

1.00/5 (1 vote)

See more:

Hi i am developing an application in asp.net in which i am sending multiple numbers with id and in response i get msgid and id in sequential order that i hv sent.

Now i want to store the number, msgid in sqldatabase. How can it b done????

Posted 16-Mar-14 9:31am

mayank.bhuvnesh

Add a Solution

Comments

Maciej Los 16-Mar-14 15:37pm

Yes, it can be done ;)

adriancs 16-Mar-14 22:49pm

by using SQL database.
You have to learn it. Search for tutorials in Google.

mayank.bhuvnesh 19-Mar-14 7:48am

Maciej

I am very much aware of SQL and SQL Queries....

thatraja 17-Mar-14 2:59am

Not clear little bit, update your question with clear & complete details

2 solutions

Add a Solution

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

CHill60 · Answer 1 · 2014-03-16T09:37:00

Solution 1

Google is your friend.

Here is a list of resources[^] that will answer the question as you have asked it.

Posted 16-Mar-14 9:37am

CHill60

Comments

mayank.bhuvnesh 19-Mar-14 7:41am

Hi

I am sending a request with sender, multiple numbers and ID say
Sender is same for each request

sender, number, ID

A, 9999, 1
A, 8888, 2
A, 7777, 3

For ths request when I get a msgID against each number. The response contains only the msgID and the ID I hav send in the request say

msgID, ID
ABC, 1 (for 1st number)
DEF, 2 (for 2nd number)
GHI, 3 (for 3rd number)

Now I have a table in SQl as below

Number
msgID
ID

I want to store the number and the corresponding msgID in this table.How can dis b achieved with best possible way.
My prob is in case a issue occur say at dat particular time msg ID is not genarated or the updation was not successful and another request is fired with the same sender ID and numbers so the corresponding data shoul get updated not all the data .

Say

I am sending the below req.

sender, number, ID

A, 9999, 1
A, 8888, 2
A, 7777, 3

and the updation fails but the msgID is gnerated and user sent another request say

sender, number, ID

A, 9999, 1
A, 8888, 2
A, 6666, 3

and in this case msgID is generated, den how it will update obnlly dis record not the previos one that was sent earlier.

mayank.bhuvnesh · Answer 2 · 2014-03-19T01:40:00

Hi

I am sending a request with sender, multiple numbers and ID say
Sender is same for each request

sender, number, ID

A, 9999, 1
A, 8888, 2
A, 7777, 3

For ths request when I get a msgID against each number. The response contains only the msgID and the ID I hav send in the request say

msgID, ID
ABC, 1 (for 1st number)
DEF, 2 (for 2nd number)
GHI, 3 (for 3rd number)

Now I have a table in SQl as below

Number
msgID
ID

I want to store the number and the corresponding msgID in this table.How can dis b achieved with best possible way.
My prob is in case a issue occur say at dat particular time msg ID is not genarated or the updation was not successful and another request is fired with the same sender ID and numbers so the corresponding data shoul get updated not all the data .

Say

I am sending the below req.

sender, number, ID

A, 9999, 1
A, 8888, 2
A, 7777, 3

and the updation fails but the msgID is gnerated and user sent another request say

sender, number, ID

A, 9999, 1
A, 8888, 2
A, 6666, 3

and in this case msgID is generated, den how it will update obnlly dis record not the previos one that was sent earlier.

database insertion and updation

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

database insertion and updation

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us