hi Uma, Hope the following link might be of help to you.
http://gps678.com/1/8f68cab863dbbe9e.html Thanks, Siva On Fri, Jun 13, 2008 at 5:31 PM, Uma Devi <[EMAIL PROTECTED]> wrote: > Sql file I mentioned here is just contains the set of sql queries with soem > Exec statements in it. > It is not a stored procedure.But it uses some variables that needs to be > passed through command line. > Eg : sqlcmd -S server -E -i someinput.sql -v dname='DBName' > dbpath="C:\somedir" -o output.log > > i want to execute this programmatically > > > > On Thu, Jun 12, 2008 at 9:49 AM, Uma Devi <[EMAIL PROTECTED]> wrote: > >> Hi, >> I need to execute sql file through c# program.Some sql file takes some >> parameters that I need to pass the variables through C# program.Is there any >> way to do it.I found out that sqlcmd can be used by passing all parameters >> to sql file using Process class.But I am trying to find whether we can do >> this programmatically in C#. >> >> Please help. >> Thanks, >> Uma. >> > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups ".NetIndia" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/TechdotNetIndia?hl=en http://www.satheeshbabu.com http://www.satheeshbabu.blogspot.com/ -~----------~----~----~----~------~----~------~--~---
