C#

Blikkies wrote:

You can use ADO.net or data set to get you data from DB.

Greg Chelstowski wrote:

What the hell does that bring to anything?

SqlConnection conn = new SqlConnection(@"user id=sa; Password=pass; initial catalog=databaseName; Data source=localhost");
			conn.Open();
			SqlCommand cmd = conn.CreateCommand();
			cmd.CommandText = "SELECT * FROM Tabel WHERE tels_no = '"+textbox1.Text.Replace("'","")+"'";
			SqlDataReader reader = cmd.ExecuteReader();
			while(reader.Read())
			{
				TextBox2.Text = reader["tels_name"].ToString();
			}

private void MethodName(object sender, EventArgs e)
{

}

this.controlName.KeyDown += new System.Windows.Forms.KeyEventHandler(this.MethodName);

Application = null;