Web Grid MVC

-
@model MvcApplication30.Models.PagedStudentModel
@{
    ViewBag.Title = "WebGrid CRUD Operations";
    WebGrid grid = new WebGrid(rowsPerPage: Model.PageSize);
    grid.Bind(Model.It_Student,
              autoSortAndPage: false,
              rowCount: Model.TotalRows
    );
}






Add New Student


@grid.GetHtml(
htmlAttributes: new { id = "grid" },
    fillEmptyRows: false,
    mode: WebGridPagerModes.All,
    firstText: "<< First",
    previousText: "< Prev",
    nextText: "Next >",
    lastText: "Last >>",
     columns: new[] {
       
        grid.Column("StudentID",
                    header: "ID", canSort: true),
        grid.Column(header: "Student_Name",format: @ @item.Name @Html.TextBox("Student_Name_" + (int)item.StudentID, (string)item.Name, new { @style = "display:none" })),
        grid.Column(header: "Branch",format: @ @item.Branch @Html.TextBox("Student_Branch_" + (int)item.StudentID, (string)item.Branch, new { @style = "display:none" })),
        grid.Column(header: "City",format: @ @item.City @Html.TextBox("Student_City_" + (int)item.StudentID, (string)item.City, new { @style = "display:none" })),
        grid.Column(header: "State",format: @ @item.State @Html.TextBox("Student_State_" + (int)item.StudentID, (string)item.State, new { @style = "display:none" })),

        grid.Column
        (header: "State",format:
        @ 
        @item.State
        @*@Html.TextBox("Student_State_" + (int)item.StudentID, (string)item.State, new { @style = "display:none" })*@
             @Html.DropDownList("Text", new SelectList(ViewBag.State, "Text", "Text"), "--Select--", new { @id = "Student_State_" + (int)item.StudentID, @class = "textfield" })
       
        ),

        grid.Column(header: "Action",format:@ EditDelete)
})

Comments

Post a Comment

Popular posts from this blog

Querying a Data Table Using Select Method and Lambda Expressions in Dot Net

-
Image
.Net Questions and Ans.. Q. 1 Querying a Data Table Using Select Method and Lambda Expressions in Dot Net Suppose we have a DataTable object having four fields: SSN, NAME, ADDRESS and AGE. We could create a data table and add columns in the following way: DataTable  dt =  new   DataTable (); dt.Columns.Add( "SSN" ,  typeof ( string )); dt.Columns.Add( "NAME" ,  typeof ( string )); dt.Columns.Add( "ADDR" ,  typeof ( string )); dt.Columns.Add( "AGE" ,  typeof ( int )); // Showing how to set Primary Key(s) in a Data table (Although it's not compulsory to have one) DataColumn [] keys =  new   DataColumn [1]; keys[0] = dt.Columns[0]; dt.PrimaryKey = keys; Now we store some data in our data table "dt" to show how we can perform several queries on the DataTable object like filtering some data, finding a person's record...
Read more

StringToTable

-
ALTER FUNCTION [dbo].[udf_StringToTable] (       @list NVARCHAR(MAX) ,       @delimiter NCHAR(1) = ',' --Defaults to CSV ) RETURNS @tableList TABLE ( value nvarchar(MAX) ) AS BEGIN     DECLARE @value NVARCHAR(MAX)     DECLARE @position INT     SET @list = LTRIM(RTRIM(@list))+ ','     SET @position = CHARINDEX(@delimiter, @list, 1)     IF REPLACE(@list, @delimiter, '') <> ''     BEGIN         WHILE @position > 0         BEGIN             SET @value = LTRIM(RTRIM(LEFT(@list, @position - 1)))             IF @value <> ''             BEGIN                 INSERT INTO @tableList (value)   ...
Read more

GetPhoneSSNFormat

-
ALTER FUNCTION [dbo].[udf_GetPhoneSSNFormat] (     -- Add the parameters for the function here     @TypeId        INT,     @DataValue    NVARCHAR(MAX) ) RETURNS NVARCHAR(MAX) AS BEGIN     DECLARE @FormattedValue    NVARCHAR(MAX)     SET @FormattedValue = ''     -- Will Remove all white spaces, brackets, hyphens     DECLARE @OriginalValue    NVARCHAR(MAX)     SET @OriginalValue = ISNULL(REPLACE(REPLACE(REPLACE(REPLACE(@DataValue,'(',''),')',''),'-',''),' ',''),'')         -- Type Id : 1 For Phone #     -- Type Id : 2 For SSN #     IF @TypeId = 1         BEGIN             SELECT @FormattedValue =              ...
Read more