ASP.NET Gridview textbox binding to a variable at runtime

Question

I am a novice with ASP.NET, and I am wondering if the following is possible. I have an application that is bound to a data source (MS Access) using OldDbDataAadpter, and works ok However, I want to be able to display ONE of an number of table fields based on user input (from a drop down list). The idea is that user selects one of (a possible 10) languages at runtime, and have the Gridview display only that field.
If you can ignore the structure of the database for the moment (it is a legacy issue), the table has a number of fields (Index, Name, etc..) and then a field for one of 10 languages (such as en-us, de, es, fr, ect..).
The following section works fine (the variable "lang" is filled from the dropdown list at runtime)

       string qryStr = "select PIndex, TName, Component, " + lang  " from MyTbles";


        GlobalClass.adap = new OleDbDataAdapter(qryStr, con);

        OleDbCommandBuilder bui = new OleDbCommandBuilder(GlobalClass.adap);

        GlobalClass.dt = new DataTable();

        GlobalClass.adap.Fill(GlobalClass.dt);

        GridView1.DataSource = GlobalClass.dt;

        GridView1.DataBind();

GlobalClass.cs is as follows: public class GlobalClass {

    public static OleDbDataAdapter adap;

    public static DataTable dt;

    // Stored image path before updating the record

}

The problem is the ASP code appears to require the EXACT fieldname when it is bound. This is a section of the ASP file :

 Text='<%#Bind("Component") %>'

This shows how the "Component" field is bound to the Gridview textbox. My question is: Is it possible to use a variable name in the "Bind" sections above? I want this ASP code to be able to find and resolve a variable from the .CS code behind section.
I am not expecting anyone to show me how, but I would like to know if this is possible (and the relevant classes I should be looking at..) Many thanks..

Paul Abbott · Accepted Answer · 2014-11-05 21:24:36Z

1

Why not just do

string qryStr = "select PIndex, TName, Component, " + lang " as SelectedLang from MyTbles";

then

Text='<%#Bind("SelectedLang") %>'

answered Nov 5, 2014 at 21:24

Paul Abbott

7,2213 gold badges30 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ASP.NET Gridview textbox binding to a variable at runtime

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related