Asp.net connect SQL server?

[wattha]

Hi,everbody
My os is Winxp (pro) , Studio.net2003 and create asp.net with vb.net, i have a problems this:

1. I have a *.xls(xp) and need to change to SQL server 2000 but i don't how can i do??? Please let'me show step by step, please....

2. How can i connect my SQl files with asp.net or Do you have a tutorial about connect SQL server, read data from sql database or another... please, help me

3. I use web control but when i try to open my project at another computer(Winxp pro) by copy My project folder to wwwroot and open http:\\localhost\Myproject\myfile.aspx

but Something wrong....???

The web control ( textbox, combobox and Linkimage), it's disappear but html control okay (not disappear).why???

perhaps the another computer can't install .Net framework???

Thanks everbody

[mendhak]

1. Import data from XLS to SQL Server: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

2. http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/adoplusoverview.aspx

3. I don't understand, explain in more detail what you're doing.

[wattha]

My purpose is Test web application on another computer...

I design my web page by use Textbox, Link, Combobox (web control ) and when i copy my project folder and paste to another computer at C:\inetpub\wwwroot\myproject this computer do not install .net. I open my project by "http:\\localhost\myproject\myfile.aspx" But these web control do not show on webpage in other hand html controls are normally..... why??? how can i fix?


Thank you very much...

[CommanderEl]

3. I use web control but when i try to open my project at another computer(Winxp pro) by copy My project folder to wwwroot and open http:\\localhost\Myproject\myfile.aspx

but Something wrong....???

The web control ( textbox, combobox and Linkimage), it's disappear but html control okay (not disappear).why???

perhaps the another computer can't install .Net framework???

Thanks everbody

when you are running your web app on this "other computer", does this "other computer" have IIS installed and updated to .NET 1.1?

You did not specify but you will need to run a web server that can handle the serving of .NET pages so MS IIS will do the trick as it comes with windows already.

[wattha]

Yes, The another computer doesn't install .net framwork but i install IIS ready.... it's need both..?

Thanks

[CommanderEl]

you will need to install .net framework and update your iis server to include the updates

there is another thread that explains this... i just cant find it