SqlConnection conNorthwind; SqlCommand cmdSelect; SqlDataReader dtrCategories;
conNorthwind = new SqlConnection(@"Server=localhost;Integrated Security=SSPI; Database=Northwind"); cmdSelect = new SqlCommand("Select CategoryName From Categories", conNorthwind); conNorthwind.Open(); dtrCategories = cmdSelect.ExecuteReader();
RadioButtonList1.DataSource = dtrCategories; RadioButtonList1.DataTextField = "CategoryName"; RadioButtonList1.DataBind();
dtrCategories.Close(); conNorthwind.Close();
|