objConn.Open();
string sqlStmt = "SELECT personID,firstname + ' ' + lastname as fullname FROM mailAdr";
objCmd = new OleDbCommand(sqlStmt, objConn);
objRdr = objCmd.ExecuteReader();
ddlReciever.DataSource = objRdr;
ddlReciever.DataValueField = "personID";
ddlReciever.DataTextField = "fullname";
ddlReciever.DataBind();
objRdr.Close();
objConn.Close();
Frågan#1
Flera cellers värden in i DataText i en dropDownMeny
objConn.Open();
string sqlStmt = "SELECT * FROM mailAdr";
objCmd = new OleDbCommand(sqlStmt, objConn);
objRdr = objCmd.ExecuteReader();
ddlReciever.DataSource = objRdr;
ddlReciever.DataValueField = "personID";
ddlReciever.DataTextField = "firstname";
ddlReciever.DataBind();
objRdr.Close();
objConn.Close();
fast ddlRevciever.DataTextField = "firstname" + " " + "lastname"; vill jag, där firstname och lastname är kolumner i en databas.