DropDown list in datagrid

See more:

VB

Oracle

hai..,

In datagrid i display in drop down list. that dropdownlist values from database using select query i bind that values as interger as well as that database column as integer.now i display 0th row i display '--SELECT--' how can i write code. i wrote code like this '

OracleDataAdapter1.SelectCommand = SelectCommand
            SelectCommand.Connection = Me.getOracleConnection
            SelectCommand.CommandText = "select shift_num from S_TR_SHIFT"
            OracleDataAdapter1.Fill(dsprocess1)
            dsprocess1.Tables(0).Rows.InsertAt(dsprocess1.Tables(0).NewRow, 0)
            dsprocess1.Tables(0).Rows(0).Item("SHIFT_NUM") = "--SELECT--"

'
display casting error pl give me a solution


Thanks & Regards.,
IdhayaRani.C