Iam new to MVC I have problem in loading data in grid view
Iam getting error
"The best overloaded method match for 'System.Web.Helpers.WebGrid.WebGrid(System.Collections.Generic.IEnumerable
my controller class
public ActionResult ShowAllMobileDetails(mobileda MB)
{
DAL.DBdata objDB = new DAL.DBdata(); //calling class DBdata
MB.StoreAllData = objDB.SelectAllData();
return View(MB);
}
-------------------]
-------my model class
public class mobileda
{
public int MobileID { get; set; }
[Required(ErrorMessage = "Please Enter Mobile Name")]
[Display(Name = "Enter Mobile Name")]
[StringLength(50, MinimumLength = 3, ErrorMessage = "Mobile Name must be between 3 and 50 characters!")]
public string MobileName { get; set; }
[Required(ErrorMessage = "Please Enter MobileIMEno")]
[Display(Name = "Enter MobileIMEno")]
[MaxLength(100, ErrorMessage = "Exceeding Limit")]
public string MobileIMEno { get; set; }
[Required(ErrorMessage = "Please Enter Mobile Price")]
[Display(Name = "Enter Mobile Price")]
[DataType(DataType.Currency)]
public string mobileprice { get; set; }
[Required(ErrorMessage = "Please Enter Mobile Manufacured")]
[Display(Name = "Enter Mobile Manufacured")]
[DataType(DataType.Text)]
public string mobileManufacured { get; set; }
public DataSet StoreAllData { get; set; }
}
--------
--My DAL
public DataSet SelectAllData()
{
SqlConnection con = null;
string result = "";
DataSet ds = null;
try
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["mycon"].ToString());
SqlCommand cmd = new SqlCommand("Usp_InsertUpdateDelete", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MobileID", 0); // i will pass zero to MobileID beacause its Primary .
cmd.Parameters.AddWithValue("@MobileName", null);
cmd.Parameters.AddWithValue("@MobileIMEno", null);
cmd.Parameters.AddWithValue("@mobileprice", 0);
cmd.Parameters.AddWithValue("@mobileManufacured", null);
cmd.Parameters.AddWithValue("@Query", 4);
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
ds = new DataSet();
da.Fill(ds);
return ds;
}
catch
{
return ds;
}
finally
{
con.Close();
}
}
----------
Myview
@{
ViewBag.Title = "ShowAllMobileDetails";
}
ShowAllMobileDetails
@{
insertupdatedelete.Models.mobileda product = new insertupdatedelete.Models.mobileda();
}
@{
var grid = new WebGrid(Model, canPage: true, rowsPerPage: 5, selectionFieldName: "selectedRow",ajaxUpdateContainerId: "gridContent");
grid.Pager(WebGridPagerModes.NextPrevious);}
@grid.GetHtml(tableStyle: "webGrid",
headerStyle: "header",
alternatingRowStyle: "alt",
selectedRowStyle: "select",
columns: grid.Columns(
grid.Column("MobileID", format: (item) => item.GetSelectLink(item.Id)),
grid.Column("MobileName", " MobileName"),
grid.Column("MobileIMEno", "MobileIMEno"),
grid.Column("mobileprice", "mobileprice"),
grid.Column("mobileManufacured", "mobileManufacured")
))
Iam getting error on this line in view \\
var grid = new WebGrid(Model, canPage: true, rowsPerPage: 5, selectionFieldName: "selectedRow",ajaxUpdateContainerId: "gridContent");
can any one help me
Thanks
1 Reply
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Suraj SahooPosted Apr 17, 2016, 8:34 AM