public void LlenarCMBUsuarios()
{
/*SqlConnection cnn = new SqlConnection(ConfigurationManager.AppSettings.Get("strConnection"));*/
string conexion = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
SqlConnection cnn;
cnn = new SqlConnection(conexion);
cnn.Open();
SqlCommand objsqlcommand = new SqlCommand("SP_Catalogo_Usuario", cnn);
objsqlcommand.CommandType = CommandType.StoredProcedure;
objsqlcommand.Parameters.AddWithValue("@Opcion", "COMBO");
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(objsqlcommand);
DataTable dt = new DataTable();
sqlDataAdapter.Fill(dt);
Id_Usuario.DataTextField = "NombreCompleto";
Id_Usuario.DataValueField = "Id_Usuario";
Id_Usuario.DataSource = dt;
Id_Usuario.DataBind();
Id_Usuario.Items.Insert(0, new ListItem("[Seleccionar]", "0"));
Id_Usuario.SelectedIndex = 0;
objsqlcommand.ExecuteNonQuery();
}
