I have a students table, a courses table and a student/courses table to show the students enrolled in a course. The table is in SQL Server 2008 and the front end in C# and Asp.net.
In the student/courses table I would like to be able to have a dropdown menu that will allow me to select the student ID stored on the database and then populate the student's name, last name and middle initial in a textbox or label.
How can I possibly do this? Any examples? Thank you for your help!
You can use either ADO.net, if not familiar then
on page load event
SqlCommand cmd = new SqlCommand();
cmd.Connection= new Class1().getconnection();
cmd.CommandText = "SELECT * FROM Profile";
cmd.Connection.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DropDownList1.Items.Add(dr["YahooId"].ToString());
}
in "cmd.CommandText" instead of "Profile" use your table name, and under "while(dr.read()) use your column name instead of "YahooId"
