Click here to Skip to main content
15,887,175 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
C#
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

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.
 
Share this answer
 
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)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900