Ms SQL7 linking problem

i have tried linking all my aspx scripts with ms access, they all worked,now i have switched on to ms sql7...iam not familier with the codes used for sql...my main problem is the data source syntax...in case of access i had given the file address along with extension...eg: C:\Data\Nortwind.mdb...so what should i do in case of sql... i have also given my code below

sub Page_load(sender as object, E as eventargs)

dim objconnection As sqlconnection
dim objcommand as sqlCommand
dim objadapter as sqlDataAdapter
dim objdata As DataSet
dim strsearch as String
dim sqlquery as String

strsearch = tb1.text

if Len(trim(strSearch))>0 then

objConnection = new sqlconnection("Data Source=(localhost);")

sqlquery= "select * from mayank where (name"&strsearch.ToString()&")"

objcommand = new sqlcommand(sqlquery, objconnection)

objadapter = new sqlDataAdapter(objcommand)

objdata = new DataSet()
objadapter.Fill(objdata)

DataGrid1.DataSource = objdata

DataGrid1.DataBind()

objConnection.close

Else
tb1.text= "enter your search here"
end if
end sub

Checkwww.connectionstrings.com

Regards

MS SQL 2005 generate separate table scripts

How do you generate separate scripts for all the objects such as
Tables or Store Procedures? This was an option in SQL 2000Are you referring to Right-click the database, Tasks, "Generate Scripts"?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CompSci" <ruchir.jaipuriyar@.gmail.com> wrote in message
news:1170260018.511018.128670@.j27g2000cwj.googlegroups.com...
> How do you generate separate scripts for all the objects such as
> Tables or Store Procedures? This was an option in SQL 2000
>|||This is supported in SP2
(http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/WhatsNewSQL2005SP2.htm#BKMK_ManagementStudio).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||On Jan 31, 10:44 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> This is supported in SP2
> (http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-...).
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.
there is no other way to do this untill sp2 comes out?|||Some options at: http://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CompSci" <ruchir.jaipuriyar@.gmail.com> wrote in message
news:1170334953.424668.248760@.a75g2000cwd.googlegroups.com...
> On Jan 31, 10:44 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
>> This is supported in SP2
>> (http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-...).
>> Cheers,
>> Paul Ibison SQL Server MVP,www.replicationanswers.com.
> there is no other way to do this untill sp2 comes out?
>

MS SQL 2005 generate separate table scripts

How do you generate separate scripts for all the objects such as
Tables or Store Procedures? This was an option in SQL 2000Are you referring to Right-click the database, Tasks, "Generate Scripts"?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CompSci" <ruchir.jaipuriyar@.gmail.com> wrote in message
news:1170260018.511018.128670@.j27g2000cwj.googlegroups.com...
> How do you generate separate scripts for all the objects such as
> Tables or Store Procedures? This was an option in SQL 2000
>|||This is supported in SP2
(http://download.microsoft.com/downl...anagementStudio).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||On Jan 31, 10:44 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> This is supported in SP2
> (http://download.microsoft.com/downl...7-423d-bc8f-...)
.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.
there is no other way to do this untill sp2 comes out?|||Some options at: http://www.karaszi.com/SQLServer/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CompSci" <ruchir.jaipuriyar@.gmail.com> wrote in message
news:1170334953.424668.248760@.a75g2000cwd.googlegroups.com...
> On Jan 31, 10:44 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> there is no other way to do this untill sp2 comes out?
>

MS SQL 2005 generate separate table scripts

This is supported in SP2
(http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/WhatsNewSQL2005SP2.htm#BKMK_ManagementStudio).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
On Jan 31, 10:44 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> This is supported in SP2
> (http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-...).
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.
there is no other way to do this untill sp2 comes out?