Select different Text of Dropdown if all items value is same

Hi midhun, i have 4 tables i need to insert excel sheets in that i have 3 tables of all columns are same and 1 table of columns different then how can i take data table can you please tell me i take data table like this:

DataTable dtColumns = new DataTable();
dtColumns.Columns.Add("ColumnNames", typeof(string));
dtColumns.Columns.Add("ID", typeof(int));

dtColumns.Rows.Add("ID", 1);
dtColumns.Rows.Add("Description", 1);
dtColumns.Rows.Add("Credits", 1);
dtColumns.Rows.Add("QTY%", 1);
dtColumns.Rows.Add("Amount", 1);
dtColumns.Rows.Add("Amount %", 1);

dtColumns.Rows.Add("ID", 2);
dtColumns.Rows.Add("Description", 2);
dtColumns.Rows.Add("ChargeCount", 2);
dtColumns.Rows.Add("ChargeCount %", 2);
dtColumns.Rows.Add("Charges", 2);
dtColumns.Rows.Add("Total Charges %", 2);

dtColumns.Rows.Add("ID", 3);
dtColumns.Rows.Add("Description", 3);
dtColumns.Rows.Add("Credits", 3);
dtColumns.Rows.Add("QTY%", 3);
dtColumns.Rows.Add("Amount", 3);
dtColumns.Rows.Add("Amount %", 3);

dtColumns.Rows.Add("ID", 4);
dtColumns.Rows.Add("Description", 4);
dtColumns.Rows.Add("Credits", 4);
dtColumns.Rows.Add("QTY%", 4);
dtColumns.Rows.Add("Amount", 4);
dtColumns.Rows.Add("Amount %", 4);

DataRow[] dr = dtColumns.Select(" ID='" + ddlTypes.Selected.Value + "'");

Thank you

Hi,

If you need selected text of dropdown, you can try with jquery.

var text=$("#ddlTypes :selected").text();


This will give you the selected text. You can save it to a hidden field and check the value in back end.

Hi,

As per my knowledge, you cannot achieve what you need. You shouldn't be giving same value for your dropdown items. They should be unique.