Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET WCF WebService , +
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 21:28pm
Edited 26-Apr-13 21:30pm
v2
Comments
Sandeep Mewara at 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 at 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 at 27-Apr-13 7:22am
   
problem occurring when i insert a rows in database.
can i handle manually
tumbledDown2earth at 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 at 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
0 OriginalGriff 476
1 Sergey Alexandrovich Kryukov 200
2 CHill60 195
3 TheRealSteveJudge 120
4 F-ES Sitecore 120
0 Sergey Alexandrovich Kryukov 9,061
1 OriginalGriff 7,920
2 Peter Leow 4,774
3 Kornfeld Eliyahu Peter 3,210
4 Maciej Los 2,176


Advertise | Privacy | Mobile
Web01 | 2.8.150327.1 | Last Updated 27 Apr 2013
Copyright © CodeProject, 1999-2015
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