hi i need to use stored procedure instead of sql query. howcan i use here
My coding here
index.cshtml
@{
var db = Database.Open("EduCon");
var selectQueryString = "select firstname,lastname,emailaddress from person2";
var data = db.Query(selectQueryString);
var grid1 = new WebGrid(source: data,
defaultSort: "firstname",
rowsPerPage: 5,
sortFieldName:"firstname"
);
<style type="text/css"> .grid { margin: 4px; border-collapse: collapse; width: 600px; } .head { background-color: #E8E8E8; font-weight: bold; color: #FFF; } .grid th, .grid td { border: 1px solid #C0C0C0; padding: 5px; } .alt { background-color: #E8E8E8; color: #000; } </style>
<div id="grid">
@grid1.GetHtml(
tableStyle: "grid",
headerStyle: "head",
alternatingRowStyle: "alt",
columns: grid1.Columns(
grid1.Column("firstname", format: @<i>@item.firstname</i>),
grid1.Column("lastname", format: @<i>@item.lastname</i>),
)
)
</div>