DataSet binding to the WebGrid in asp.net mvc3

Accepted answer

Hi,

Try this.

List items = resultSet.AsEnumerable().Select(row =>
new SelectSiteModel
{
SiteID = row.Field("SiteID"),
SiteName= row.Field("SiteName")
}).ToList();

0

Sachin R11y ago

I I am removing this part in webgrid.gethtml

//columns:new[] {g.Column("productname"),g.Column("price"),g.Column("description")},

getting output as below with no data displayed - BUT PAGINATION IN CORRECT - 3 PAGES

< 1 2 3

;

0

Sachin R11y ago

Hi Jagan/Nagaraju,

I have the similar kind of problem .Can u please help me to over come this.

Issue is column names are not recognized
source code

controller

public class ADONETController : Controller

{

//

// GET: /ADONET/

public ActionResult Index()

{

Read r = new Read();

//List data = r.read().Rows.AsQueryable().

return View(r.read());

}

model

public class Read

{

public string productname;

public decimal price;

public string description;

public IEnumerable read()

{

DataAccess da=new DataAccess();

SqlConnection cn = DataAccess.connectionstring();

string q = "select productname,price,description from testinternetmvc..products";

SqlCommand cmd = new SqlCommand(q,cn);

cn.Open();

SqlDataAdapter sda=new SqlDataAdapter(q,cn);

DataSet ds = new DataSet();

DataTable dt = new DataTable();

//ds.Clear();

//sda.Fill(ds.Tables[0]);

sda.Fill(dt);

//ds = cmd.ExecuteReader();

//SqlDataReader d = cmd.ExecuteReader();

cn.Close();

List dtlist = dt.AsEnumerable().Select(row => new Read

{

productname = row.Field("productname"),

price = row.Field("price"),

description = row.Field("description")

}).ToList();

return dtlist;

}

view

@*@model List*@

@using System.Data;

@{

WebGrid g = new WebGrid(source: Model,

//columnNames:null,

defaultSort:null,

rowsPerPage:2,

canPage:true,

canSort:true,

ajaxUpdateContainerId:null,

ajaxUpdateCallback:null,

fieldNamePrefix:null,

pageFieldName:null,

selectionFieldName:null,

sortFieldName:null,

sortDirectionFieldName:null);

}

@g.GetHtml(tableStyle: "webgrid-table",

headerStyle: "webgrid-header",

footerStyle: "webgrid-footer",

alternatingRowStyle: "webgrid-alternating-row",

selectedRowStyle: "webgrid-selected-row",

rowStyle: "webgrid-row-style",

caption:null,

displayHeader:true,

fillEmptyRows:false,

emptyRowCellValue:null,

columns:new[] {g.Column("productname"),g.Column("price"),g.Column("description")},

exclusions:null,

firstText:null,

previousText:null,

nextText:null,

lastText:null,

htmlAttributes:null);

error:

Column "productname" does not exist.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Column "productname" does not exist.

Source Error:

Line 26:  Line 27:  Line 28: @g.GetHtml(tableStyle: "webgrid-table", Line 29:         headerStyle: "webgrid-header", Line 30:         footerStyle: "webgrid-footer",

0

Jaganathan Bantheswaran13y ago

Mark it as Answer if it helped you. So that others can use the solution.

0

NAGARAJU TAMADA13y ago

Thank you for Answer sir

My Application working fine now

Regards
Nagaraju T

0

Jaganathan Bantheswaran13y ago

Hi,

@model Mvc3CssApp.Models.List -> this is not correct.

@model List -> this is correct

0

NAGARAJU TAMADA13y ago

I already added the following on top

@model Mvc3CssApp.Models.SelectSiteModel

but still there is no use

if i use this
@model Mvc3CssApp.Models.List

Exception raises like
The type or namespace name 'SelectSiteModel' could not be found (are you missing a using directive or an assembly reference?)

0

Jaganathan Bantheswaran13y ago

Hi,

Return type of your method should be List but not IEnumerable.
&
Add @model List at top of your View.

0

NAGARAJU TAMADA13y ago

Here is my code

My Model is

public class SelectSiteModel

{

[Required]

public string SiteID { get; set; }

[Required]

public string SiteName { get; set; }

[Required]

public string SiteAddress { get; set; }

[Required]

public string WorkOrderNo { get; set; }

public IEnumerable GetAllSiteDetails()

{

string connectionString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

SqlConnection con = new SqlConnection(connectionString);

SqlCommand cmd = new SqlCommand("Select * From Site", con);

DataTable ds = new DataTable();

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds);

List items = ds.AsEnumerable().Select(row =>new SelectSiteModel

{

SiteID = row.Field("SiteID"),

SiteName = row.Field("SiteName"),

SiteAddress = row.Field("SiteAddress"),

WorkOrderNo = row.Field("WorkOrderNo")

}).ToList();

return items;

}

My Controller is

public ActionResult Index()

{

SelectSiteModel selectSiteModel = new SelectSiteModel();

var resultSet = selectSiteModel.GetAllSiteDetails();

return View(resultSet);

}

View is

@{

var grid = new WebGrid(source:Model,rowsPerPage: 3);

}

Employee List

@grid.GetHtml(

tableStyle: "grid",

headerStyle: "head",

alternatingRowStyle: "alt",

columns: grid.Columns(

grid.Column("SiteID"),

grid.Column("SiteName"),

grid.Column("SiteAddress"),

grid.Column("WorkOrderNo")

)

0

Jaganathan Bantheswaran13y ago

Can you upload your source code?

0

NAGARAJU TAMADA13y ago

Thanks for your reply sir

Still the exception raises like,

The best overloaded method match for 'System.Web.Helpers.WebGrid.WebGrid(System.Collections.Generic.IEnumerable, System.Collections.Generic.IEnumerable, string, int, bool, bool, string, string, string, string, string, string, string)' has some invalid arguments

Source Error:

Line 51:
Line 52: @{ Line 53: var grid = new WebGrid(source:Model,rowsPerPage: 3);

Line 54: }
Line 55:

Employee List

0

NAGARAJU TAMADA13y ago

Thanks for your reply

Again showing the error is

'object' does not contain a definition for 'Columns' and no extension method 'Columns' accepting a first argument of type 'object' could be found

0

Jaganathan Bantheswaran13y ago

Updated,

var source = new List();

foreach(var row in resultSet.Table[0].Rows)
{
var site = new SelectSiteModel();
site.SiteName = row.Columns["SiteName"].ToString();
......
.....
source.Add(site);
}

return source;

0

NAGARAJU TAMADA13y ago

Thanks for your reply sir

There is a error like

"Cannot apply indexing with [] to an expression of type 'object' "

var source = new List();

foreach(var row in resultSet.Table[0].Rows)
{
var site = new SelectSiteModel();
site.SiteName = row["SiteName"].ToString(); //error occured here
......
.....
source.Add(site);
}

return source;

0

Jaganathan Bantheswaran13y ago

Hi,

you have to map the DataTable values with your SelectSiteModel.

Something like,

var source = new List();

foreach(var row in resultSet.Table[0].Rows)
{
var site = new SelectSiteModel();
site.SiteName = row["SiteName"].ToString();
......
.....
source.Add(site);
}

return source;

0