[C#] MSSQL Update

[C#] MSSQL Update

 

mssql 프로시저 Update 사용법입니다.

public async Task<bool> UpdateContents(AdvertiserModel model)
{
    try
    {
        using (SqlConnection con = new SqlConnection(Startup.DBConnectionString))
        {
            SqlCommand cmd = new SqlCommand("UPDATE_AdvertiserInfo", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(DBCommon.MakeParam("@ID", model.ID));
            cmd.Parameters.Add(DBCommon.MakeParam("@CorporateRegistrationNumber", model.CorporateRegistrationNumber));
            cmd.Parameters.Add(DBCommon.MakeParam("@Name", model.Name));
            cmd.Parameters.Add(DBCommon.MakeParam("@ManagerName", model.ManagerName));
            cmd.Parameters.Add(DBCommon.MakeParam("@ManagerPhone", model.ManagerPhone));
            cmd.Parameters.Add(DBCommon.MakeParam("@UserID", model.UserID));
            con.Open();
            SqlDataReader rdr = await cmd.ExecuteReaderAsync();
 
            if (rdr != null)
            {
                rdr.Close();
            }
            con.Close();
        }
        return true;
    }
    catch (Exception e)
    {
        Debug.WriteLine(e.Message);
        return false;
    }
}