Comments by Noze (Top 13 by date)

thank you very much
look i write this code it is succeeded
static void Main(string[] args)
{
string connsql = "Data Source=" + Environment.MachineName + ";Integrated Security=True;Pooling=False;MultipleActiveResultSets=False;Packet Size=4096";
SqlConnection conn = new SqlConnection(connsql);
conn.Open();
StreamReader readfilequery = new StreamReader(@"J:\Project\Finelf\Dental lab and Storeff\Main Form\query\script.sql");
string query = "";
string line = readfilequery.ReadLine();
while (line != null)
{
if (line.IndexOf("GO") == -1)
{
query = query + line;
}
else
{

SqlCommand commqnd = new SqlCommand(query, conn);
commqnd.ExecuteNonQuery();
query = null;
}
line = readfilequery.ReadLine();
}

}