Hi all ,
Im very new to mvc . I have a webgrid in which values are populated using stored procedure. I need to add a dropdownlist in this webgrid in which values are also populated from database.I tried everything on internet. Could anyone help me please.Any help will be really appreciated .Thanks in advance .
What I have tried:
@model List< RealEstate.Models.SP002_DETAILS_Result >
@{
Layout = null;
var grid = new WebGrid(Model, canSort: false, canPage: false);
}
<div id="gridContent" style=" padding:20px; ">
@grid.GetHtml(
tableStyle: "webgrid-table",
headerStyle: "webgrid-header",
footerStyle: "webgrid-footer",
alternatingRowStyle: "webgrid-alternating-row",
selectedRowStyle: "webgrid-selected-row",
rowStyle: "webgrid-row-style",
mode: WebGridPagerModes.All,
columns:
grid.Columns(
grid.Column(header: "No.",
format: item => item.WebGrid.Rows.IndexOf(item) + 1 + Math.Round(Convert.ToDouble(grid.TotalRowCount / grid.PageCount) / grid.RowsPerPage) * grid.RowsPerPage * grid.PageIndex),
@*grid.Column("Roomid", "ID", format: @<text> @item.Roomid
<label id="UserID" class="edit-mode">@item.Roomid</label> </text>, style: "col1Width"),*@
grid.Column("Roomname", "Room Name", format: @<text>
<label id="lblName">@item.Roomname</label>
Html.DropDownList(@item.Roomname, @item.getrooms) </ text >, style: "col2Width"),
@*< input type = "text" id = "Roomname" value = "@item.Roomname" class="edit-mode" /></text>, style: "col2Width"),*@
grid.Column("Tenantname", "Tenant name", format: @<text>
<label id="lblSurName">@item.Tenantname</label>
<input type="text" id="Tenantname" value="@item.Tenantname" class="edit-mode" />
</text>, style: "col2Width"),
grid.Column("tenantrent", "Rent Amnt", format: @<text>
<label id="lbltenantrent">@item.tenantrent</label>
<input type="text" id="tenantrent" value="@item.tenantrent" class="edit-mode" />
</text>, style: "col2Width"),
grid.Column("tenantunid", "ID", format: @<text>
<label id="lbltenantunid">@item.tenantunid</label>
<input type="text" id="tenantunid" value="@item.tenantunid" class="edit-mode" />
</text>, style: "col2Width"),
grid.Column("tenantstartdate", "Start Date", format: @<text>
<label id="lbltenantstartdate">@item.tenantstartdate.ToString("dd-MMM-yyyy")</label>
<input type="text" id="Startdate" value="@item.tenantstartdate.ToString("dd-MMM-yyyy")" class="edit-mode" />
</text>, style: "col2Width"),
grid.Column("tenantenddate", "End Date", format: @<text>
<label id="lbltenantenddate">@item.tenantenddate.ToString("dd-MMM-yyyy")</label>
<input type="text" id="enddate" value="@item.tenantenddate.ToString("dd-MMM-yyyy")" class="edit-mode" />
</text>, style: "col2Width"),
grid.Column("depositmant", "Deposit Amnt", format: @<text>
<label id="lbldepositmant">@item.depositmant</label>
<input type="text" id="depositmant" value="@item.depositmant" class="edit-mode" />
</text>, style: "col2Width"),
grid.Column("remarks", "Remarks", format: @<text>
<label id="lblremarks">@item.remarks</label>
<input type="text" id="remarks" value="@item.remarks" class="edit-mode" />
</text>, style: "col2Width"),
grid.Column("Action", format: @<text>
<button class="edit-user display-mode1"><img src="~/Images/Edit.png" width="15" height="15" title="Click here to edit Tenant Details" /></button>
<button class="save-user edit-mode1"><img src="~/Images/suc.png" width="15" height="15" title="Click here to save Tenant Details" /></button>
<button class="delete-user delete-mode1"><img src="~/Images/Delete12.png" width="15" height="15" title="Click here to delete Tenant Details" /></button>
<button class="cancel-user edit-mode1"><img src="~/Images/err.png" width="15" height="15" title="Click here to cancel" /></button>
</text>, style: "col3Width", canSort: false),
grid.Column(format: @<label id="UserID" style="visibility:hidden;width:5px;">@item.tenantid</label>, style: "col3Width")))
</div>