Monday, July 21, 2008

dynamically adding TextBox

SqlConnection con = new SqlConnection("Data Source=(local);Database=Test;user id=sa;pwd=***");
con.Open();
SqlDataAdapter sq = new SqlDataAdapter("SELECT *From Employee", con);
DataSet ds = new DataSet();
sq.Fill(ds, "Employee");

foreach (DataRow dr in ds.Tables[0].Rows)
{
string test = "Murugesan";

TextBox txt = (TextBox)this.FindControl(test);

txt.Visible = true;

}


sq.Dispose();
con.Close();


}