string connectString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=D:/_Web3rev/App_Data/CentralDB.mdb"; OleDbConnection cn = new OleDbConnection(connectString); cn.Open(); string selectString = "SELECT studid FROM Students WHERE studid='" + lblStudid.Text+ "'"; OleDbCommand cmd = new OleDbCommand(selectString, cn); OleDbDataReader reader = cmd.ExecuteReader();
string selectString = "SELECT FullName FROM Import WHERE IDNumber=@IDNumber";
while
if
if(reader.Read()) lblstudid.text = reader.GetString(reader.GetOrdinal("studid")); and get rid of the while {}
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)