This is what i have tried. I get no errors but the database is not changing as per the stored procedure which does work when run within sql.
private void approveestBN_Click(object sender, EventArgs e)
{
int @estno;
int.TryParse(startestnoCB.Text,out estno);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "EstimateApproval";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@estno", SqlDbType.Int);
}
end quote.
Where is your SqlConnection assignment to the SqlCommand ?
Where is your value assignment to the cmdParameter ?
Where is your Execute command on cmd ?