try
{sConstring = "Data Source =" + Host.Text.Trim() + ";Initial Catalog=" + catalogDb.Text.Trim() + ";Integrated Security=SSPI;";con =
new SqlConnection(sConstring);con.Open();
SqlCommand cmd = new SqlCommand("sp_ValidateSqlSyntax", con);cmd.CommandType =
CommandType.StoredProcedure;
SqlParameter Squery = new SqlParameter("@CustomQuery", SqlDbType.NVarChar);
SqlParameter Status = new SqlParameter("@StatusMsg", SqlDbType.VarChar);
FileInfo file = new FileInfo(txtqueryval.Text.Trim());
string script = file.OpenText().ReadToEnd();Squery.Direction =
ParameterDirection.Input;Status.Direction =
ParameterDirection.Output;Status.Size = 100000;
Squery.Value = script.ToString().Trim();
Status.Value =
"@StatusMsg";cmd.Parameters.Add(Squery);
cmd.Parameters.Add(Status);
object reader = cmd.ExecuteScalar();
if (reader != null){
lberror44.Text = reader.ToString().Trim();
}
else{
lberror44.Text = "Success";}
}
catch (Exception ex){
MessageBox.Show(ex.Message, "Sql Sytax Reviewer", MessageBoxButtons.OK, MessageBoxIcon.Information);}
Comments
Post a Comment