How to bind a grid dynamically with help of dropdownlist in ASP.NET MVC 5 using entity framework

Question

0.00/5 (No votes)

See more:

I have one query table that holds three columns namely id, name, query. I want to bind id as a value name as a text in drop down and when I change the drop down list that query column is executed in web grid dynamically. I don't know how to do this.

Qry_ID	Qry_Name	Qry_Query
    ------------------------------------------------------------------------
1     customer    select cus_name, cus_street, cus_address, cus_place, cus_mobile from customer_master
2     supplier    select sup_code, sup_name from supplier_master

What I have tried:

i dont know how to do this. if any answer please reply me
Thank you

Posted 8-Aug-19 22:19pm

Member 13919255

Updated 28-Aug-19 2:43am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

dnxit · Answer 1 · 2019-08-28T02:43:00

C#

private DataTable DynamicTableResult(string tableType)
{
   // based on the table type parameter pass your query 
    var sql = "select sup_code, sup_name from supplier_master";
	var result = new DataTable();
	using (var context = new YourDbContext())
	{
		var cmd = context.Database.Connection.CreateCommand();
		cmd.CommandType = CommandType.Text;
		cmd.CommandText = sql;

		try
		{
			context.Database.Connection.Open();
			var reader = cmd.ExecuteReader();
			do
			{
				result.Load(reader);
			} while (!reader.IsClosed);
		}
		finally
		{
			context.Database.Connection.Close();
		}
	}

	return result;
}

Your Controller

C#

// tableType will hold Customer/Supplier
public ActionResult Index(string tableType)
{
     DataTable dt = DynamicTableResult(tableType);
     return View(dt);
}

Your View will be like

HTML

@using System.Data
@model DataTable

<table cellpadding="0" cellspacing="0">
    <tr>
        @foreach (DataColumn col in Model.Columns)
        {
            <th>@col.ColumnName</th>
        }

    </tr>
    @foreach (DataRow row in Model.Rows)
    {
        <tr>
            @foreach (DataColumn col in Model.Columns)
            {
                <td>@row[col.ColumnName]</td>
            } 
        </tr>
    }
</table>