al momento de querer correr mi aplicacion para mostrar datos desde un dropdownlistfor con una base de datos en mvc
me aparece este error: Object reference not set to an instance of an object.
mi modelo esta asi :Modelo
namespace GenericServiceAccountproject.Models
{
public class StatusAccountModel
{
public List<SelectListItem> Values { get; set; }
public int? value1 { get; set; }
}
}
mi controlador:
Controller:
public class AddAccountController : Controller
{
// GET: AddAccount
public ActionResult Index()
{
Models.StatusAccountModel SAM = new Models.StatusAccountModel();
SAM.Values = SeleccionarStatus();
return View(SAM);
}
private static List<SelectListItem> SeleccionarStatus()
{
List<SelectListItem> items = new List<SelectListItem>();
string constr = ConfigurationManager.ConnectionStrings["GSARCon"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
string query = " FindStatus";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
items.Add(new SelectListItem
{
Text = sdr["Value"].ToString(),
Value = sdr["value1"].ToString()
});
}
}
con.Close();
}
}
return items;
}
}
y mi vista:
View
@model GenericServiceAccountproject.Models.StatusAccountModel
@{
Layout = null;
}
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>AddAccount</title>
</head>
<body>
<div>
}
@Html.DropDownListFor(model => model.value1, Model.Values, "Please select")
</div>
</body>
</html>
