SQL script with variables, how to call them from C#

Question

I want to work with SQL scripts in my desktop application. But I can not write any sql statements with parameters and call them.

INSERT INTO table 
VALUES (..., ..., ...)

Above should my SQL statement; where I want to fill the values at c# side. How should my SQL statement; what is its notation? And how can I add at c# parameters to it.

Thanks !

wsanville · Accepted Answer · 2010-12-31 01:12:32Z

4

You're going to want to use parameterized SQL queries. Here's an example using the SqlParameter class.

answered Dec 31, 2010 at 1:12

wsanville

37.6k8 gold badges78 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

softwaremonster Over a year ago

I know this. Thanks but this is not the answer of my question. I want to use an sql-script file, your answer is using directly a string as command text.

Pauli Østerø Over a year ago

wtf? his answer is very much correct! whether your sql-statement is written directly in code or is being read from some text files doesn't matter.

BrokenGlass · Accepted Answer · 2010-12-31 01:39:44Z

1

If you need to use external sql script files you can use SQLCMD, a command line tool available for SQL Server 2005 or later.

You can just trigger sqlcmd with Process.Start from C# and pass it the necessary parameters. Here's an article explaining how to pass in variables for starters.

If you are just looking for table update/inserts though I'd recommend going with SqlCommand/SqlParameters as wsanville suggested.

answered Dec 31, 2010 at 1:39

BrokenGlass

161k28 gold badges297 silver badges339 bronze badges

Collectives™ on Stack Overflow

SQL script with variables, how to call them from C#

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related