Bind Data into table / grid
Hello.I want to create 1 view where I need to bind data.
What is the good way to bind the data.
Also, table and grid, what is the useful for this.
You must Sign In to post a response.
Category: ASP.Net MVC
I want to create 1 view where I need to bind data.
What is the good way to bind the data.
Also, table and grid, what is the useful for this.
#768189
Hi,
We have many simple methods to implement this,
Following will be one of the basic method to implement grid/table in the view page.
Below is the coding which you have to do with the Controller. Before Controller you should already declared the Model along with columns you are expected to shown in the grid.
Below is the coding for the View page, where we are using this Details object and creating Grid.
Thanks,
Mani
We have many simple methods to implement this,
Following will be one of the basic method to implement grid/table in the view page.
Below is the coding which you have to do with the Controller. Before Controller you should already declared the Model along with columns you are expected to shown in the grid.
public ViewResult Index()
{
var Details = db.Details.AsEnumerable<Detail>();
return View(Details); //You just passed details as a model
}
Below is the coding for the View page, where we are using this Details object and creating Grid.
@model IEnumerable<Project.Details>
@foreach (var item in Model)
{
//Design for your DataGrid
}
Thanks,
Mani
#768190
Hi,
You want to create a view, and that view data you want to bind to grid. Is it?
Please refer the below..
Hope this will help you.
Regards,
SonyShiva
Never lose hope..You never know what tomorrow will bring
You want to create a view, and that view data you want to bind to grid. Is it?
Please refer the below..
//To bind data to the grid using ASP.net
string strCon = "Server=192.2.3.4;Database=sample;Uid=sa;Pwd=sn";
SqlConnection con = new SqlConnection(strCon);
string strSQL = "SELECT * from yourview1";
SqlCommand cmd = new SqlCommand(strSQL, con);
try
{
con.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
}
catch (Exception ex)
{
Label1.Text = "SQL Query failed: " + ex.Message;
}
Hope this will help you.
Regards,
SonyShiva
Never lose hope..You never know what tomorrow will bring
#768202
Hai Pranjal,
If you are working with ASP.Net MVC, then you can have the partial view, or View to bind the whole Model.
To do this, you need to a controller and get the Model data as the List and then generate the View for the Model and fill the view.
It will be simplest way where you need not to write lot of code as the code can be generated automatically using Scaffolding option. You just need to create the Model which you want to display in the View.
Create Model:
The mode part is done here.
Now you can right click on the controller and choose this model as the List template in Scaffolding option.
Provide the controller name and click OK.
it will generate the controller with all the action items and will generate the views as well
Hope it will be helpful to you.
Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com
If you are working with ASP.Net MVC, then you can have the partial view, or View to bind the whole Model.
To do this, you need to a controller and get the Model data as the List and then generate the View for the Model and fill the view.
It will be simplest way where you need not to write lot of code as the code can be generated automatically using Scaffolding option. You just need to create the Model which you want to display in the View.
Create Model:
//Customer.cs
public class Customer
{
// customer id
public int Id{get;set;
// customer name
public string Name {get; set;}
}.
The mode part is done here.
Now you can right click on the controller and choose this model as the List template in Scaffolding option.
Provide the controller name and click OK.
it will generate the controller with all the action items and will generate the views as well
Hope it will be helpful to you.
Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com
Return to Return to Discussion Forum