c# - How to add data to Gridview using specific field name searching -

i have program in need display search result in gridview. here code. here @search1 1 of sql field name. sql field names bra1,bra2,bra3,bra4. if type code in text box eg "a103" search , dropdownlist have select branch bra1 search1, in gridview show values of code "a103" in bra1. here a103 example of item code , bra1 field name. give me solution this.for place "search1" can select field name value bra1,bra2 or bra3 , rsult shown in gridview.important: bra1 field name in sql or column name. here code:

 protected void button3_click(object sender, eventargs e)          {               string str = " select code,@search1 othstk code='a103';";         sqlcommand xp = new sqlcommand(str, con);          xp.parameters.add("@search1",sqldbtype.varchar).value=dropdownlist2.selectedvalue;               con.open();               sqldataadapter da = new sqldataadapter();           da.selectcommand = xp;      dataset ds = new dataset();      da.fill(ds,"branchcode");         gridview2.datasource = ds;      gridview2.databind();      con.close();  } 

hi vishnu,

your question not bit cleared understand question have 1 dropdown contain column name , 1 textbox in serach criteria.

you should directly concatenate dropdown value in str.

protected void button3_click(object sender, eventargs e)              {                   string str = " select code," + dropdownlist2.selectedvalu+ " othstk code='a103';";      sqlconnection con = new sqlconnection(your connection)         sqlcommand xp = new sqlcommand(str, con);               con.open();                   sqldataadapter da = new sqldataadapter();               da.selectcommand = xp;          dataset ds = new dataset();          da.fill(ds,"branchcode");             gridview2.datasource = ds;          gridview2.databind();          con.close();      }