Monday, 6 May 2024

Dapper tabled params

 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

css of bayt.com