converted async progrmme to normal getting error with table parameters type
using (SqlCommand cmd = new SqlCommand("USP_UploadAFISupportFiles"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@fileAttachments", dtfileAttachments);
con.Open();
var res2 = cmd.ExecuteNonQuery();
con.Close();
if (res2 == -1)
{
result.ID = "0";
result.Message = "Failed to upload";
result.Status = "false";
}
else
{
result.ID = "0";
result.Message = "Files uploaded successfully";
result.Status = "true";
}
}
No comments:
Post a Comment