executing content of *.sql script in C# language

Question

hi, I have a windows form application, which in some case needs to run a sql script so the database on users server would be built. I tried taking the content of sql script using streamreader class and then putting the text into a sqlCommand and executing. I know that I have to read it line by line, but I need to know how to put a new line in C# because it does not work when you just execute the text. do you have any suggestions? thank you, vitek

Answer 1

Check this link:

http://chandradev819.wordpress.com/2011/01/27/how-to-create-crud-operation-in-asp-net-using-wcf/

Answer 2

thank u Sanjeeb...Lemme try it out...:)

Answer 3

check this code:

public int SaveEmp(Emp objEmp)
{
using (SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True"))
{
 string query = "Emplyentry";  //stored procedure name
using (SqlCommand cmd = new SqlCommand(query , con))
{
cmd.Parameters.AddWithValue("@EmpName", objEmp.EmpName);
cmd.Parameters.AddWithValue("@EmpSal", objEmp.EmpSal);
con.Open();
int a = cmd.ExecuteNonQuery();
con.Close();
return a;
}

}
}

Answer 4

Thanx a lot for ur kind reply Sanjeeb,That linkhelped me a lot...
But in dat example, database tables are used... But i need stored procedures usage... kindly help:)