Sub DropDown()
Dim de As New SqlConnection(ConfigurationManager.ConnectionStrings("ITRequest").ConnectionString)
de.Open()
Dim Cmd As New SqlCommand("Select * From User_MG", de)
Dim dt As New DataTable
dt.Load(Cmd.ExecuteReader)
drop.DataSource = dt
drop.DataTextField = "Manager_name"
drop.DataValueField = "MG_id"
drop.DataBind()
drop.SelectedIndex = drop.Items.IndexOf(drop.Items.FindByText(" "))
de.Close()
End Sub