listbox show System.Data.DataRowView

Question

    String start_cd;
    String end_cd;
    opencon();

    SqlCommand res = new SqlCommand("SELECT ID,'" + start_cd + "','" + end_cd + "' FROM Train_route_up WHERE " + start_cd + "!=0 or " + end_cd + "!=0", con);
    SqlDataAdapter sda_res = new SqlDataAdapter(res);
    DataTable dt_res = new DataTable();
    sda_res.Fill(dt_res);

    listBox1.DataSource=dt_res;
    listBox1.DisplayMember=" +start_cd+ ";
    //Train_route_up=  SQL table name
    //FOT=start_cd value(nvarchar)

listbox show System.Data.DataRowView (my sql table column name=FOT Data type=int)

Side note: the way you are constructing your SQL statement should be revised. See SQL INJECTION : ref: http://stackoverflow.com/questions/306668/are-parameters-really-enough-to-prevent-sql-injections — Hardrada, Feb 17 '14 at 00:14

Damith · Answer 1 · 2014-02-16T06:02:25.377

1

try with

listBox1.DisplayMember= start_cd.Trim();

edited Feb 16 '14 at 06:02

answered Feb 16 '14 at 05:48

Damith

62,401
13
102
153

score 0 · Accepted Answer · answered Feb 16 '14 at 05:49

0

If the start_cd variable contains the name of the column that you want displayed then you assign the start_cd variable to the DisplayMember property, i.e.

listBox1.DisplayMember = start_cd;

answered Feb 16 '14 at 05:49

jmcilhinney

50,448
5
26
46

listbox show System.Data.DataRowView

2 Answers2