how to assign select statement value to text box

[ramanan ram]

string sid;
if (Request.QueryString["empid"] != null)
{
    sid = Request.QueryString["empid"];
    OleDbConnection conn1 = new OleDbConnection(conn);
    String sql = string.Format("SELECT * FROM ADDRESS WHERE EMPID = {0}", sid);
    conn1.Open();
}

the above coding empid value getting from previous page .this field primary key in the table for example:the empid value is 4 assign to sid .based on using select statement to get the single row ,this stage address table have 4 fields each value want to show the textbox.
plz give the solution

[Frinavale]

Check out this article for a quick overview of how to use a DataReader to retrieve the data from your database and display it:

How To Use A Database In Your Program

-Frinny