how to store the list string values in one short to database

Question

hi sir i have a gridview and that containes some list of rows, i'm storing all that gridview data to datbase, but here i'm looping each row of the gridview and storing it.

it is taking too much of time to store.

 

is there any other way so that i can store all griview data to database in one short of query 

 

note: Here i'm using mysql database

 

 

plz help me to fix this problem 

Answer 1

I managed to resolve the issue by deleting a phantom user (It was a people icon with a ? mark.  I've never actually seen it before) in the Remote Desktop Users screen and then rebooting the server.  I suspect this may have been causing a problem with the remote connection; although the error message definitely wasn't pointing that way.  Thanks for your help and suggestions.  You pointed me in the direction of looking at the permissions.

Answer 2

I would still check the permissions on the folders/files you are trying to access through your code.  Check the permissions on a server that is working verses the one that isn't.  Even if you are using Administrator, the permissions could still be off, I know just from experience.  Good Luck

Answer 3

I had thought that might be the issue, too, but the id I'm using to get in is an Administrator.

Answer 4

The only thing I can think of is that there might be some permissions error on that one server.