Click here to Skip to main content
14,664,481 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hello Every One,

I have one webservice for sync Local to server,
I have local 10 client or more want to send all local database transaction on server at a time.
i am using following code
for (int i = 0; i < ds.Tables.Count; i++)
               {
                   if (ds.Tables[i].TableName != "Table")
                   {
                       if (ds.Tables[i].Rows.Count > 0)
                       {
                           string tblName = string.Empty;
                           tblName = ds.Tables[i].TableName;
                           SqlDataAdapter oOrderDetailsDataAdapter = new SqlDataAdapter(new SqlCommand("SELECT * FROM " + tblName, sqlConn));
                           SqlCommandBuilder oOrderDetailsCmdBuilder = new SqlCommandBuilder(oOrderDetailsDataAdapter);
                           oOrderDetailsDataAdapter.FillSchema(ds, SchemaType.Source);
                           count = oOrderDetailsDataAdapter.Update(ds, tblName);
                         
                       }
                   }
                   if (ds.Tables.Contains("Table"))
                       ds.Tables.Remove("Table");
                   if (count != 0)
                       count = 1;
               }

for Bulk transaction entry save in database as per table wise.
web service is integrate with C# windows application. and used XML FOR data transmission For local to server.(On Local Made XML file for day wise transaction.and this XML file pass to Web service for DATA Posting On server )
when a single request is hit to web service it will work.But when run my exe On multiple client system it will stuck, Not posted any transaction on server database.
and task is running for longer time.
Please Help Me how to Post data at time On server.

Thanks In Advance...!!!

What I have tried:

I tried to send data shorter amount of multiple file.
but it not work..
help mi to send data at a time from Multiple client PC.
And How it will Do.
Thanks In Advance.
Posted
Updated 22-May-16 21:31pm

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Did you try adding some logging to your client application to pin point the issue ?. 10 is a very small number and concurrency should not be an issue.
   
Comments
Member 10271164 25-May-16 2:03am
   
Yes I logged But Not Getting Any failed MSG. But not also posed data in table.
I used Exception Handling. as well as logger.
Not not yet get any ensue.

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



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