How to fill student name in StudentList Dropdown List from two tables, Student and UserInfo tables.Both tables have this field.

Hi Stephine,

This is a sample, change it accordingly.

ASPX Code

<asp:DropDownList ID="DropDownList1" runat="server">
asp:DropDownList>

Code Behind

DataTable dataTable = new DataTable();
dataTable = FillDataTable(); //Method to get records from database.
DropDownList1.DataSource = dataTable;
DropDownList1.DataTextField = "StudentName";
DropDownList1.DataValueField = "StudentId";
DropDownList1.DataBind();

--------------------------------------------------

DataTable FillDataTable()
{
//Code to retrieve records from database.
}