I also want how combobox show student ID and Name together i have 2 fields in DataBase table."StudentId" and "Name".Plz Help me.
CODE
Query="select StudentID, Name From StudentRecord"
com = new sqlcommand
com.commandText = Query
da= new sqldataadapter
dt = new DataTable
da.selectcommand = com
da.fill(dt)
cmb1.DataSource = dt
cmb1.ValueMember = dt.columns("Name").ToString
cmb1.DisplayMembers = dt.columns("StudentID").ToString
30 Jun, 2008 - 09:56 PM
| 
