Database Connectivity using WebService

Thank you for this article. if i have application A with a db and Application B with its own db. and I want any changes i made in Application B db to update a table from Application A. How can i achieve that using web services

Thanks u very much........it working.............

Thanks a lot....

thank you

Its very good artical for dotnet using dot.net web service but i want dotnet application which is use php webservice to check database connected or not connected before call any webservice methodes. Rakesh

Very good, you help me so much, thank you.

Raj, I tried to use your code without doing anything to it. I am getting the following error: Object reference not set to an instance of an object. on this line of code: using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["dataConnectionString"].ConnectionString))

Raj, You certainly make webservices look easy. I do not see a connection string to the Northwinds database. Where is that located? DO you have to add a datagridview to a form or is it created dynamically from the webservice? Thanks Steve Stacel [email protected]

Thanks you very much!

Hai its ok that you open the data base connection, but at what point the connection must be closed.

Hi... My problem is that my ms access database is on my server & i want to connect with that database from c#.Net window application using web service or any thing. pls it's urgent for me.

using (SqlConnection connection = new SqlConnection (ConfigurationManager.ConnectionString"dataConnectionString"].ConnectionString)) A simpe slip of key that may produce error --ConfigurationManager.ConnectionString"dataConnectionString"].ConnectionString It should be like this ConfigurationManager.ConnectionString["dataConnectionString"].ConnectionString Thanks

I was stuck with a webservice to display data in datagrid. This article helped me to resolve it...