On SQL Server Express, the name of the datasource is like "SERVERNAME\SQLEXPRESS" where SERVERNAME is replaced by the name of your server. Rather than localhost, may be you can try the above syntax and check if it works. In faith there is enough light for those who want to believe and enough shadows to blind those who don't. - Blaise Pascal

You should save the .xls file as a .csv file. Then give the .csv file as the input to your program. You can parse the .csv file like the way you parse a text file. In faith there is enough light for those who want to believe and enough shadows to blind those who don't. - Blaise Pascal

I think SQL server is a better option. In faith there is enough light for those who want to believe and enough shadows to blind those who don't. - Blaise Pascal

Save the Excel sheet as a CSV(Comma seperated value). You can then parse the csv file and manipulate the contents and display it. In faith there is enough light for those who want to believe and enough shadows to blind those who don't. - Blaise Pascal

Look in this site: http://searchvb.techtarget.com/vsnetTip/1,293823,sid8\_gci864207\_tax293033,00.html or type 'setting the focus on an ASP.NET page' in google and hit search...you will get this page. In faith there is enough light for those who want to believe and enough shadows to blind those who don't. - Blaise Pascal

I think you should accept the changes after updating for the change to be committed. Add 'dt.AcceptChanges();' statement after 'da.update(dt);' statement. Hope this solves your problem In faith there is enough light for those who want to believe and enough shadows to blind those who don't. - Blaise Pascal

I got the answer from a friend's friend....I had to enable the application to work on port 80. It was using some other port before that In faith there is enough light for those who want to believe and enough shadows to blind those who don't. - Blaise Pascal

First of all, thanks a lot for your reponse.. Actually, I am not trying to access it using a client program. I just wanted to access the webservice on 192.168.10.3 from the machine 192.168.10.5. When I use the url http://192.168.10.3/Project1/LoginWS it gaves a HTTP 500 Internal server error and says that the page can not be displayed. In faith there is enough light for those who want to believe and enough shadows to blind those who don't. - Blaise Pascal

Hi, I have created a webservice LoginWS for login authentication on a machine with the ip address as 192.168.10.3. I can access the webservice on that machine with the url http://192.168.10.3/Project1/LoginWS.asmx. The web service for login authentication works like a charm when I access it on the localhost. Now, I have another machine 192.168.10.5 on the same network. How do I access the above mentioned webservice from this machine? I used the above mentioned URL, it gave a internal server error.:confused: Could any of you kindly let me know how to make it work?? Thanks in advance for your help.... In faith there is enough light for those who want to believe and enough shadows to blind those who don't. - Blaise Pascal