i cant solve this error please help me

Guest User

8y1k.NET

//ERROR

There is no ViewData item of type 'IEnumerable' that has the key 'ProductID'.

[HttpGet
public bool SelectProduct(clproduct clproduct)
{
using (MySqlConnection con = new MySqlConnection())
{
con.ConnectionString = constr;
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "insert into clientproduct (ProductId,ClientProductDetail,Act_Date,Exp_Date,CLProductId,ParentProductId) values ('" + clproduct.ProductId + "','" + clproduct.ClientProductDetail + "',"
+ "'" + clproduct.Act_Date + "','" + clproduct.Exp_Date + "','" + clproduct.CLProductId + "','" + clproduct.ParentProductId + "')";
con.Open();
i = cmd.ExecuteNonQuery();
con.Close();
return true;
}
return false;
}
}
]
public ActionResult SelectedProduct()
{
MySqlConnection con = new MySqlConnection(constr);
MySqlDataAdapter da = new MySqlDataAdapter("SELECT ProductId,ProductName,Description FROM ProductMaster", con);
DataTable dt = new DataTable();
da.Fill(dt);
ViewBag.ProductNM = ToSelectList(dt, "ProductID", "ProductName");
ViewBag.productid = ToSelectList(dt, "ProductId", "ProductId");
ViewBag.desc = ToSelectList(dt, "ProductId", "Description");
return View();
}
[HttpPost]
public ActionResult SelectedProduct( clproduct cl)
{
string msg;
if (ModelState.IsValid)
{
ModelState.Clear();
try
{
if(i > 1)
{
SelectProduct(cl);
Response.Write("
"http://ajax.aspnetcdn.com/ajax/jquery.ui/1.9.2/jquery-ui.min.js" type="text/javascript">*@
@* *@
"text/javascript">
$(function () {
$('#ADate').datepicker({
dateFormat: 'mm-dd-yy'
})
$('#EDate').datepicker({
dateFormat: 'mm-dd-yy'
})
})

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nanddeep Nachan8y ago
Accepted answer
In view try using productid instead of ProductNM
@Html.DropDownList("ProductID", (IEnumerable)ViewBag.productid, "Select Product", new { @class = " form-control", @style = "width:200px" })
0
Nanddeep Nachan8y ago
Please check, are you getting any values to your Product model inside view?
0
Ruchi Sharavat8y ago
I tried using your code and it worked perfectly. Did you debug the code and checked what values have been filled to your viewbag in below code before returing to view?
ViewBag.ProductNM = ToSelectList(dt, "ProductID", "ProductName");
ViewBag.productid = ToSelectList(dt, "ProductId", "ProductId");
ViewBag.desc = ToSelectList(dt, "ProductId", "Description");
return View();
I tried with below static values it worked for me:
DataTable dt = new DataTable();
            dt.Columns.Add("ProductName");
            dt.Columns.Add("ProductId");
            dt.Columns.Add("Qty");
            DataRow dr;
            dr = dt.NewRow();

            dr["ProductName"] ="P1";
            dr["Qty"] =2;
            dr["ProductId"] =12345;
            dt.Rows.Add(dr);
            dr = dt.NewRow();

            dr["ProductName"] = "P2";
            dr["Qty"] = 4;
            dr["ProductId"] = 98745;
            dt.Rows.Add(dr);
            ViewBag.ProductNM = ToSelectList(dt, "ProductID", "ProductName");
            ViewBag.productid = ToSelectList(dt, "ProductId", "ProductId");
0
Guest User8y ago
hi Ruchi ,
thnx
I already written this code ..but its not working
0
Ruchi Sharavat8y ago
Hi sona,

did you use this as well? I use this number of times and it works fine. Just need to use (SelectList) before viewbag

@Html.DropDownList("ProductID", (SelectList)ViewBag.ProductNM, "Select Product", new { @class = " form-control", @style = "width:200px" })
0
Guest User8y ago
@nanddeep i used this code

ViewData["ProdID"] = new SelectList(db.Products, "ProdId", "ProdName"); but not useful getting same error
0
Nanddeep Nachan8y ago
In Index method, have you tried to set the ViewData, something like below:
public ActionResult Index()
{
        ViewData["ProdID"] = new SelectList(db.Products, "ProdId", "ProdName");
        return View();
}
0
Ruchi Sharavat8y ago
1. @Html.DropDownList("ProductID", (SelectList)ViewBag.ProductNM, "Select Product", new { @class = " form-control", @style = "width:200px" })
Try this.
0