protected void Button1_Click(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); try { con.Open(); } catch (Exception) { throw; } string str = TextBox1.Text.ToString(); OleDbCommand cmd = new OleDbCommand("SELECT Profession FROM name WHERE Name="+str, con); OleDbDataReader rdr = cmd.ExecuteReader(); if (rdr.Read()) { // string str = rdr.GetValue(1).ToString(); TextBox3.Text = rdr["Profession"].ToString(); // TextBox3.Text = rdr.GetValue(2).ToString(); } con.Close(); }
OleDbCommand cmd = new OleDbCommand("SELECT Profession FROM name WHERE Name='"+str +"'", con);
"SELECT Profession FROM name WHERE Name='"+str+ "'"
OleDbCommand cmd = new OleDbCommand("SELECT Profession FROM name WHERE Name='"+str+"'", con);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)