Click here to Skip to main content
13,048,584 members (91,048 online)
Rate this:
Please Sign up or sign in to vote.
i am creating one 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 to insert those records in my site
Posted 26-Apr-13 20:28pm
Updated 26-Apr-13 20:30pm
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:
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;
i = cmd.ExecuteNonQuery();
if (i > 0)
return i;
return i;

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

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170713.1 | Last Updated 27 Apr 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100