connection from c# to sql server 2005

[roshan]

hi all,
I am new to this group and also new to c#.I am trying to learn c# right
now.
I am doing a small asssignment in which i have to create a small
file with .sql extension in windows.then write a code in c# to access
that file and then connect to sql server 2005 and execute the query
present in that .sql file.
please help me to finish this assignment.
thank you.

[Michael Nemtsev]

And what's the question?
To create file and write text into it use File.Create/StreamWrite.Write
methods (see msnd)
To connect the SQLServer and execute the script use SQLConnection,
SQLCommand classes

"roshan" wrote:

hi all,
I am new to this group and also new to c#.I am trying to learn c# right
now.
I am doing a small asssignment in which i have to create a small
file with .sql extension in windows.then write a code in c# to access
that file and then connect to sql server 2005 and execute the query
present in that .sql file.
please help me to finish this assignment.
thank you.

--
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

If you want to learn then you have to figure it out, if we tell you how todo
this (or give you the code) you will learn nothing

Do you have a book of C#? I had Professional C# programming and it was very
good. You could also look into the MS Press books, they are good.
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"roshan" <ro**********@gmail.com> wrote in message
news:11**********************@j33g2000cwa.googlegr oups.com...

hi all,
I am new to this group and also new to c#.I am trying to learn c# right
now.
I am doing a small asssignment in which i have to create a small
file with .sql extension in windows.then write a code in c# to access
that file and then connect to sql server 2005 and execute the query
present in that .sql file.
please help me to finish this assignment.
thank you.