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.

 

[Guest]

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

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.