how to add dropdown in webgrid and get load from database.

Question

i want to populate dropdown in webgrid,when row get edit . i have to table

Create table  tblUser (UserID int,UserName varchar(50))

Create table Customer ([CustomerId] [int] IDENTITY(1,1) NOT NULL, 	[Name] [varchar](50) NULL, 	[Country] [varchar](50) NULL, 	[UserID] [int] NULL)


Insert into tblUser  values(1,'Alkt')
Insert into tblUser values(2,'DGDE')

Insert into (1,'AAAA','USA',1)
Insert into (2,'ADDD','KSA'2)

i display data in webgrid without dropdown,on edit action

@model IEnumerable

@{
    Layout = null;
    WebGrid webGrid = new WebGrid(source: Model, canPage: true, canSort: false);
}





    
    Index
    


    @webGrid.GetHtml(
    htmlAttributes: new { @id = "WebGrid", @class = "Grid" },
    columns: webGrid.Columns(
     webGrid.Column(header: "Customer Id", format: @@item.CustomerId, style: "CustomerId"),
                   webGrid.Column(header: "Name", format: @ @item.Name  , style: "Name"),
                                webGrid.Column(header: "Country", format: @@item.Country , style: "Country"),
                                 
        
        
        
        webGrid.Column(header: "User", format: @
                                    @item.UserName
                               
                                    
                                  
                                , style: "User"),
                                            

                                                                             webGrid.Column(format:@EditUpdateCancel)))

Controller

  public ActionResult Index()
        {


            var custom = DB.Customers.ToList();
            var user = DB.tblUsers.ToList();



            var investerlist = from e in custom
                               join u in user on e.UserID equals u.UserID into table1
                               from u in table1.ToList()
                               select new CustomerMV
                               {
                                  CustomerId=e.CustomerId,
                                  Country=e.Country,
                                  Name=e.Name,
                                  UserName = u.UserName

                               };


            var UserID = 0;
            ViewBag.U_ID = new SelectList(DB.tblUsers.Where(bt => bt.UserID > UserID), "UserID", "UserName", "0");
            return View(investerlist);

        }

        [HttpPost]
        public ActionResult UpdateCustomer(Customer customer)
        {
           
            {
                Customer updatedCustomer = (from c in DB.Customers
                                            where c.CustomerId == customer.CustomerId
                                            select c).FirstOrDefault();
                updatedCustomer.Name = customer.Name;
                updatedCustomer.Country = customer.Country;
                DB.SaveChanges();
            }

            return new EmptyResult();
        }

Accepted Answer

Hi @Analyst_SQL,

From my understanding you want to show the user a drop down menu when editing.

You can refer to the code below and replace with @Html.DropDownList.

webGrid.Column(header: "User", format: 
@
    @item.UserName
     @Html.DropDownList("UserName", (IEnumerable)ViewBag.U_ID)
, style: "User"),

Best regards,

Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

how to add dropdown in webgrid and get load from database.

0 additional answers

Your answer