Comments by Ravi Vayyala (Top 1 by date)

After selecting the data from excel through OleDbDataReader and while reading the data from it the plain cell data is accessible but there is a dropdown in that excel that drop down selected value can't be accessed.
some code is pasted below in that some are dropdown list columns in excel
that dtExcelSheetNames[0] in select query is sheetname of the excel

excelConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fine + "; Jet OLEDB:Engine Type=5;Extended Properties=\"Excel 8.0;IMEX=1;HDR=Yes;ImportMixedTypes=Text;\"";
OleDbConnection objconn = new OleDbConnection(excelConnection);

qry = "Select [Type],[Bank],[Party Type],[Party ID],[Purpose],[Instrument Type],[Instrument No],[Instrument Date],[Instrument Bank],[Instrument Branch],[Instrument Amount],[Remarks] from [" + dtExcelSheetNames[0] + "]";
OleDbCommand cmd = new OleDbCommand(qry, objconn);

OleDbDataReader dReader;
dReader = cmd.ExecuteReader();


while (dReader.Read())
{
//string rid = GetRegid(dReader["UserName"].ToString().Trim());
SqlCommand cmd1 = new SqlCommand("sp_uploadPaymnet", sqlcon);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add("@FileName", SqlDbType.NVarChar).Value = Name + Extension;
cmd1.Parameters.Add("@TransType", SqlDbType.NVarChar).Value = dReader["Type"].ToString();
cmd1.Parameters.Add("@Bank", SqlDbType.NVarChar).Value = dReader["Bank"].ToString();
cmd1.ExecuteNonQuery();
}