how to execute multiple insert statements at a same point through web service

Question

0.00/5 (No votes)

See more:

i am creating one website.in my website i am creating on web service.i want to handle flush amount of requests at a single point and store flush amount of inputs from client at a single time
for example 100 clients registering on my site.all clients click on submit button at single point.how to insert those records in my site

Posted 26-Apr-13 20:28pm

Member 9714428

Updated 26-Apr-13 20:30pm

v2

Add a Solution

Comments

Sandeep Mewara 27-Apr-13 6:41am

Insert will happen sequentially, one by one. What is the problem? Do you face any issue in insertion when you try such scenario?

Member 9714428 27-Apr-13 7:20am

i am facing problem when i insert rows in database between different system at a point..some times rows are not inserted...

my code is:
in web service:
<pre>[WebMethod]
public int insertion(string name,double salary,int mgrid) {
MySqlConnection con = new MySqlConnection("database=master;data source=server;user id=root;password=manager");
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "insert into details(name,salary,mgrid) values('" + name + "'," + salary + "," + mgrid + ")";
cmd.Connection = con;
int i = 0;
con.Open();
i = cmd.ExecuteNonQuery();
con.Close();
if (i > 0)
{
return i;
}
else
{
return i;
}

}
</pre>

Member 9714428 27-Apr-13 7:22am

problem occurring when i insert a rows in database.
can i handle manually

tumbledDown2earth 28-Apr-13 11:16am

Did you check for exceptions from your service? You can try putting the code in a try-catch block and log exceptions if any. Your observation seems to suggest that some of the requests either dont reach or are not successfully processed

Member 9714428 30-Apr-13 22:47pm

i tried using try catch block also...
no exceptions were occured

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)