Click here to Skip to main content
15,909,445 members

Comments by Member 14081438 (Top 3 by date)

Member 14081438 10-Dec-18 10:52am View    
connection.Open();
string selectString = "SELECT FullName FROM Import WHERE IDNumber='" + textBox1.Text + "'";
OleDbCommand cmd = new OleDbCommand(selectString, connection);
OleDbDataReader reader = cmd.ExecuteReader();

reader = cmd.ExecuteReader();
while (reader.Read())
{
cmd.Parameters.AddWithValue("@IDNumber", textBox1.Text);
if (reader.Read())
label1.Text = reader.GetString(reader.GetOrdinal("FullName"));
}

connection.Close();
it wont work to my system :(. plse help me sir
Member 14081438 10-Dec-18 10:51am View    
connection.Open();
string selectString = "SELECT FullName FROM Import WHERE IDNumber='" + textBox1.Text + "'";
OleDbCommand cmd = new OleDbCommand(selectString, connection);
OleDbDataReader reader = cmd.ExecuteReader();

reader = cmd.ExecuteReader();
while (reader.Read())
{
cmd.Parameters.AddWithValue("@IDNumber", textBox1.Text);
if (reader.Read())
label1.Text = reader.GetString(reader.GetOrdinal("FullName"));
}

connection.Close();
it wont work :( plse help me sir
Member 14081438 10-Dec-18 10:49am View    
why it wont work to my system it always says that there is no value given by one or more paramiter?