Hello, Please am in need to how to implement a simple webservice to transfer the database from a client computer to a central computer.

Nana

Thank you for your reply. The thing is I don't know what to do and I do not understand the cross post. Please explain further for me. thank you.

Nana

Hello, So I am working on a project to transfer database data from different locations into one central database via webservices. My initial thought was to install the webservice on the database servers in the different locations and have the consumer webservice installed on the central database server invoke the webservices at each of these locations to update the central database. Now I don't know if that is the right way to do it as I have no clue as to how to differentiate between the webservices in these different locations and how to even call them. Please help. Suggestions and coments as to how I can go about this will be appreciated. Than you.

Nana

Hello, So I am working on a project to transfer database data from different locations into one central database via webservices. My initial thought was to install the webservice on the database servers in the different locations and have the consumer webservice installed on the central database server invoke the webservices at each of these locations to update the central database. Now I don't know if that is the right way to do it as I have no clue as to how to differentiate between the webservices in these different locations and how to even call them. Please help. Suggestions and coments as to how I can go about this will be appreciated. Than you.

Nana

Hello, So i have a windows application and I want to be able to set up an auto download and installation of updates when the user starts up the software. Do i need some kind up FTP connection or webservices or what. I am at a lose as to how to approach. I am a beginning programmer and I need help. Thank you.

Nana

hi the code below throws this exception "ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized." on the update statement in the try catch block. Please help. DatabaseDataSet.PersonnalInfoDataTable ds = new DatabaseDataSet.PersonnalInfoDataTable(); DatabaseDataSetTableAdapters.PersonnalInfoTableAdapter adapter = new Testing.DatabaseDataSetTableAdapters.PersonnalInfoTableAdapter(); adapter.Fill(ds); DatabaseDataSet.PersonnalInfoRow newrow = ds.NewPersonnalInfoRow(); newrow["firstname"] = this.textBoxFirstName.Text; newrow["lastname"] = this.textBoxLastName.Text; newrow["telephone"] = this.textBoxTelephone.Text; ds.AddPersonnalInfoRow(newrow); adapter.Connection.Open(); SqlTransaction myTrans= adapter.Connection.BeginTransaction(); try { adapter.Update(ds); myTrans.Commit(); ds.AcceptChanges(); } catch(Exception l) { myTrans.Rollback(); ds.RejectChanges(); } adapter.Connection.Close();

Nana

I have posted this question before but didn't post the code. The thing is for some reason, i cannot programatically Insert new row or update the database. However, I could fill the dataset after manaually populating the database. Could any help me. The permissions are set right and the folder that contains the database file is also writable. thank you. below is what i have ProductItemDataSet = new DataSet.DatabaseDataSet.ProductItemTableDataTable(); DataSet.DatabaseDataSetTableAdapters.ProductItemTableTableAdapter ProdAdapter = new DataSet.DatabaseDataSetTableAdapters.ProductItemTableTableAdapter(); ProdAdapter.Fill(ProductItemDataSet); ProdAdapter.Insert("man", "mango", "mango tree", ""); The database is in project Dataset. And this code exist in a different project but references the Dataset project.

Nana

Question to anyone please. Is SQl Server express Edition read only from an application. Insert and Update doesn't work. I cannot find the answers anywhere. thx

Nana

Well thanks for your suggestion. I tried it and its still not working. Insert and update statement do not work on the database cope in the debug directory too. The select statement works if i populate the database manually. I create insert and update commands to no success. I will appreciate anymore sugestions. Thanks

Nana

Well thanks for your suggestion. I tried it and its still not working. Insert and update statement do not work on the database cope in the debug directory too. The select statement works if i populate the database manually. I create insert and update commands to no success. I will appreciate anymore sugestions. Thanks

Nana

Thank you for your help. I am afraid to say its still not working. Only select statements work after i have manually populated the database. Insert and updates still don't. i added a connection to the copy in the debug. It also has the same data as the one in the local folder. Insert still not working on that one too. I will appreciate anymore suggestions

Nana

I am using VS2005 with SQLServer Express Edition. Select SQL statement work fine but not Insert or update. Is there something am doing wrong? Sample insert code. DataSet.DatabaseDataSetTableAdapters.SaleTransactionTableTableAdapter SaleTransAdapter = new DataSet.DatabaseDataSetTableAdapters.SaleTransactionTableTableAdapter(); SaleTransAdapter.Insert(7, (decimal)NetTotal, DateTime.Now);

Nana

thank you

Nana

It is a C# project i am working. I do not have lots of back apps running. This is because I am running below the physical memory. Yes it has been fragmented . Thank you. Nana

I have a program that was running really well on my computer. For sometime now, it has been running really slow and I find it hard to understand. I have scanned for viruses and spyware but couldn't find any and no possible reasons as the why the program is running that slow. Any suggestions? My computer specification is : pentium4, 3.40GH, 512MB Nana

Any one please. Nana

Is there a quick way of retrieving the hearder from an RTF? thx Nana

thanks Nana

how do i convert a string to a rich text format thx Nana

Thanks. But it is not working. I used the enter key to return to the next line. I did that through a couple of lines before typing the data. Now what I need to do is remove those return characters from the beginning while keeping the format. thx Nana