SQL Server 2000 & asp.net2.0

Question

we are using sql server 2005 in visual studio 2005...... i just want to know that ..is this possible to use sql server2000 in vs 2005...

Niradhip Chakraborty · Answer

It should not be as datagrid1.bind(); It should be as datagrid1.DataBind(); Search for DataBind()instead of Bind().

Rekha S C · Answer

hi i am new to this .net....... i want some info about .net we use below code to show the contents of databse in datagrid using .net1.1... sqlconnection con = new sqlconnection(server=localhost;userid=sa;password=;database=employee.mdf); sqlcommnd cmd = new sqlcommand(select * from emp); sqldatareader dr = cmd.executereader; datagrid1.datasourse=dr; datagrid1.bind(); but in .net 2.0 bind() fun is not present then how to show the contents of table in datagrid thanx in advance

Niradhip Chakraborty · Answer

Its simple just specify the connectionstring in web.config. Below is my connection string with sql server 2000 database: Below is my connection string with sql server 2005 database:

Rekha S C · Answer

how to connect the database ... using c#.net 2.0 and sql server2000

Niradhip Chakraborty · Answer

Yes it is possible.You can use any one of those with vs2005.