using Out put Parameter in c#

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