I am using web services for my application using asp.net. For my information, if I apply the web services for my application, then, I only can access the database using Port 80.
So, my question now is:
if only port 80 will be opened all the time, then, am I able to use SqlCommand in my application?Am I able to use SQL Statement directly in my application?

Kindly help will be much more appreaciate.

Thanks.

Regards,
YuenYong

You can access web services thru any port. The port access is a setting in IIS and your network hardware. You configure IIS to expose a "web site" on the ports you wish to use (the default being port 80). As long as you have the web service in a application directory (virtual or not) within that IIS "web site" node, you can access the web service.

The application runs within the IIS process. As long as you can see the SQL Server from that web server machine (inside your network) then you can use it. The public HTTP port you use has nothing to do with your access to SQL Server.

-Peter

Thanks for your reply.

I have another question to post here.
Are there any other ways to create datatable object inside the dataset object except using the SqlDataAdapter? Coz, I need to create DataRelation between the Dataset.

Any help will be most appreciate.

Regards,
YuenYong

You can create many DataTables inside a single dataset. DataSet.Add()

Then you can create DataRelation instances that relate tables together so you can get associated rows.

-Peter