.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
DataView
Messages   Related Types
This message was discovered on ASPFriends.com 'aspnges' list.


Laura San Roman
=A1Hola!

    Tengo un nuevo problema con la aplicaci=F3n que estoy desarrolando en
.Net, os lo comento a ver si alguien me puede ayudar.
Tengo un m=E9todo de una clase que me devuelve un dataview con los =
registros
de una tabla que corresponden a una sql, hasta aqui bien, mi problema =
es,
con lo que devuelve este m=E9todo necesito rellenar un DropDownList que
contenga lo devuelto por el dataview y adem=E1s a=F1adir yo una =
opci=F3n m=E1s (la
t=EDpica del option value=3D0) al principio del todo. =BFAlguien me =
puede dar una
idea de como hacerla?

Muchas gracias y un saludo.

******************
..........
<script language=3D"C#" runat=3D"server">
            private void Page_Load(Object Sender, EventArgs E){
                if (!IsPostBack) {
                =09
                    businessemployee emp =3D new
businessemployee();
                    ddlDeparment.DataSource =3D
emp.GetDepartments();
                    ddlDeparment.DataBind();
......
......

Department: 
<asp:DropDownList Runat=3D"server" AutoPostBack=3D"True" =
ID=3D"ddlDeparment"
OnSelectedIndexChanged=3D"ddlDeparment_SelectedIndexChanged"
DataValueField=3D"id_department"
DataTextField=3D"department_name"></asp:DropDownList>
******************

M=E9todo de la clase que lo carga:

    public DataView GetRoles(String IdDepartment)
        {
            SqlConnection Conection =3D new
SqlConnection(_ConnStr);
            String SQL =3D "Select * From tbRoles Where
id_department =3D " + IdDepartment + " Order By Role_name";
            SqlDataAdapter Command =3D new SqlDataAdapter(SQL
,Conection);
            DataSet Ds =3D new DataSet();
            Command.Fill(Ds, "tbRoles");
            return Ds.Tables["tbRoles"].DefaultView;
        }
Reply to this message...
 
    
Luis Ruiz
prueba con este codigo
DropDownList.Items.Insert(0, new ListItem(" Ninguno ",
"-1")) ;

Luis Ruiz

--- Laura San Roman <Click here to reveal e-mail address>
wrote:
[Original message clipped]

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
Reply to this message...
 
    
Victor Saldivia
Tienes que crear una funcion que devuelva un objeto datasource, yo lo =
he
hecho en codigo VB.NET y devuelvo un arraylist el cual es llenado por =
un
SQLDataReader, y en el objeto DropDownList agrego la propiedad =
Datasource
apuntando a esa funcion.
Esto tambien es valido si deseas colocar un DropDownList dentro de otro
Objeto Databinder (DataGrid, DataList, etc.)

-----Original Message-----
From: Laura San Roman [mailto:Click here to reveal e-mail address]=20
Sent: Martes, 28 de Agosto de 2001 07:30
To: aspnges
Subject: [aspnges] DataView

=A1Hola!

    Tengo un nuevo problema con la aplicaci=F3n que estoy desarrolando en
.Net, os lo comento a ver si alguien me puede ayudar. Tengo un =
m=E9todo de una
clase que me devuelve un dataview con los registros de una tabla que
corresponden a una sql, hasta aqui bien, mi problema es, con lo que =
devuelve
este m=E9todo necesito rellenar un DropDownList que contenga lo =
devuelto por
el dataview y adem=E1s a=F1adir yo una opci=F3n m=E1s (la t=EDpica del =
option value=3D0)
al principio del todo. =BFAlguien me puede dar una idea de como =
hacerla?

Muchas gracias y un saludo.

******************
..........
<script language=3D"C#" runat=3D"server">
            private void Page_Load(Object Sender, EventArgs E){
                if (!IsPostBack) {
                =09
                    businessemployee emp =3D new
businessemployee();
                    ddlDeparment.DataSource =3D
emp.GetDepartments();
                    ddlDeparment.DataBind();
......
......

Department: 
<asp:DropDownList Runat=3D"server" AutoPostBack=3D"True" =
ID=3D"ddlDeparment"
OnSelectedIndexChanged=3D"ddlDeparment_SelectedIndexChanged"
DataValueField=3D"id_department"
DataTextField=3D"department_name"></asp:DropDownList>
******************

M=E9todo de la clase que lo carga:

    public DataView GetRoles(String IdDepartment)
        {
            SqlConnection Conection =3D new
SqlConnection(_ConnStr);
            String SQL =3D "Select * From tbRoles Where
id_department =3D " + IdDepartment + " Order By Role_name";
            SqlDataAdapter Command =3D new SqlDataAdapter(SQL
,Conection);
            DataSet Ds =3D new DataSet();
            Command.Fill(Ds, "tbRoles");
            return Ds.Tables["tbRoles"].DefaultView;
        }

| [aspnges] member Click here to reveal e-mail address =3D YOUR ID=20
| http://www.asplists.com/asplists/aspnges.asp =3D JOIN/QUIT=20
| http://www.asplists.com/search =3D SEARCH Archives
Reply to this message...
 
    
Adrian Garcia
Esto no lo probe pero quizas ande:

....
ddlDeparment.DataSource = emp.GetDepartments();
ddlDeparment.DataBind();

ddlDeparment.Items.Add(new ListItem("","0")); // Agrego la opcion por
omision
ddlDeparment.SelectedIndex = ddlDeparment.Items.Count - 1; // la selecciono
....

Saludos

Adrian Garcia
Microsoft MVP [C#/ASP] - MCSD
NDSoft Filial Córdoba - Argentina
Click here to reveal e-mail address

----Original Message Follows----
From: Laura San Roman <Click here to reveal e-mail address>
Reply-To: "aspnges" <Click here to reveal e-mail address>
To: "aspnges" <Click here to reveal e-mail address>
Subject: [aspnges] DataView
Date: Tue, 28 Aug 2001 12:30:19 +0100

¡Hola!

    Tengo un nuevo problema con la aplicación que estoy desarrolando en
.Net, os lo comento a ver si alguien me puede ayudar.
Tengo un método de una clase que me devuelve un dataview con los registros
de una tabla que corresponden a una sql, hasta aqui bien, mi problema es,
con lo que devuelve este método necesito rellenar un DropDownList que
contenga lo devuelto por el dataview y además añadir yo una opción más (la
típica del option value=0) al principio del todo. ¿Alguien me puede dar una
idea de como hacerla?

Muchas gracias y un saludo.

******************
..........
<script language="C#" runat="server">
            private void Page_Load(Object Sender, EventArgs E){
                if (!IsPostBack) {

                    businessemployee emp = new
businessemployee();
                    ddlDeparment.DataSource =
emp.GetDepartments();
                    ddlDeparment.DataBind();
......
......

Department: 
<asp:DropDownList Runat="server" AutoPostBack="True" ID="ddlDeparment"
OnSelectedIndexChanged="ddlDeparment_SelectedIndexChanged"
DataValueField="id_department"
DataTextField="department_name"></asp:DropDownList>
******************

Método de la clase que lo carga:

    public DataView GetRoles(String IdDepartment)
        {
            SqlConnection Conection = new
SqlConnection(_ConnStr);
            String SQL = "Select * From tbRoles Where
id_department = " + IdDepartment + " Order By Role_name";
            SqlDataAdapter Command = new SqlDataAdapter(SQL
,Conection);
            DataSet Ds = new DataSet();
            Command.Fill(Ds, "tbRoles");
            return Ds.Tables["tbRoles"].DefaultView;
        }

| [aspnges] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspnges.asp = JOIN/QUIT
| http://www.asplists.com/search = SEARCH Archives

_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp
Reply to this message...
 
    
Adrian Garcia
El codigo de Luis es mucho mas elegante y mejor del que mande yo!.

Saludos

Adrian Garcia
Microsoft MVP [C#/ASP] - MCSD
NDSoft Filial Córdoba - Argentina
Click here to reveal e-mail address

----Original Message Follows----
From: Luis Ruiz <Click here to reveal e-mail address>
Reply-To: "aspnges" <Click here to reveal e-mail address>
To: "aspnges" <Click here to reveal e-mail address>
Subject: [aspnges] Re: DataView
Date: Tue, 28 Aug 2001 06:40:18 -0700 (PDT)

prueba con este codigo
DropDownList.Items.Insert(0, new ListItem(" Ninguno ",
"-1")) ;

Luis Ruiz

--- Laura San Roman <Click here to reveal e-mail address>
wrote:
[Original message clipped]

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

| [aspnges] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspnges.asp = JOIN/QUIT
| http://www.asplists.com/search = SEARCH Archives

_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp
Reply to this message...
 
    
Laura San Roman
Justo lo que necesitaba.
Muchas gracias a Todos

-----Original Message-----
From: Adrian Garcia [mailto:Click here to reveal e-mail address]
Sent: martes, 28 de agosto de 2001 16:10
To: aspnges
Subject: [aspnges] Re: DataView

Esto no lo probe pero quizas ande:

....
ddlDeparment.DataSource =3D emp.GetDepartments();
ddlDeparment.DataBind();

ddlDeparment.Items.Add(new ListItem("","0")); // Agrego la opcion por=20
omision
ddlDeparment.SelectedIndex =3D ddlDeparment.Items.Count - 1; // la =
selecciono
....

Saludos

Adrian Garcia
Microsoft MVP [C#/ASP] - MCSD
NDSoft Filial C=F3rdoba - Argentina
Click here to reveal e-mail address

----Original Message Follows----
From: Laura San Roman <Click here to reveal e-mail address>
Reply-To: "aspnges" <Click here to reveal e-mail address>
To: "aspnges" <Click here to reveal e-mail address>
Subject: [aspnges] DataView
Date: Tue, 28 Aug 2001 12:30:19 +0100

=A1Hola!

    Tengo un nuevo problema con la aplicaci=F3n que estoy desarrolando en
.Net, os lo comento a ver si alguien me puede ayudar.
Tengo un m=E9todo de una clase que me devuelve un dataview con los =
registros
de una tabla que corresponden a una sql, hasta aqui bien, mi problema =
es,
con lo que devuelve este m=E9todo necesito rellenar un DropDownList que
contenga lo devuelto por el dataview y adem=E1s a=F1adir yo una =
opci=F3n m=E1s (la
t=EDpica del option value=3D0) al principio del todo. =BFAlguien me =
puede dar una
idea de como hacerla?

Muchas gracias y un saludo.

******************
..........
<script language=3D"C#" runat=3D"server">
            private void Page_Load(Object Sender, EventArgs E){
                if (!IsPostBack) {

                    businessemployee emp =3D new
businessemployee();
                    ddlDeparment.DataSource =3D
emp.GetDepartments();
                    ddlDeparment.DataBind();
......
......

Department: 
<asp:DropDownList Runat=3D"server" AutoPostBack=3D"True" =
ID=3D"ddlDeparment"
OnSelectedIndexChanged=3D"ddlDeparment_SelectedIndexChanged"
DataValueField=3D"id_department"
DataTextField=3D"department_name"></asp:DropDownList>
******************

M=E9todo de la clase que lo carga:

    public DataView GetRoles(String IdDepartment)
        {
            SqlConnection Conection =3D new
SqlConnection(_ConnStr);
            String SQL =3D "Select * From tbRoles Where
id_department =3D " + IdDepartment + " Order By Role_name";
            SqlDataAdapter Command =3D new SqlDataAdapter(SQL
,Conection);
            DataSet Ds =3D new DataSet();
            Command.Fill(Ds, "tbRoles");
            return Ds.Tables["tbRoles"].DefaultView;
        }

| [aspnges] member Click here to reveal e-mail address =3D YOUR ID
| http://www.asplists.com/asplists/aspnges.asp =3D JOIN/QUIT
| http://www.asplists.com/search =3D SEARCH Archives

_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp

| [aspnges] member Click here to reveal e-mail address =3D YOUR ID
| http://www.asplists.com/asplists/aspnges.asp =3D JOIN/QUIT
| http://www.asplists.com/search =3D SEARCH Archives
Reply to this message...
 
    
Laura San Roman
=BFExiste alguna manera de a=F1adir dicho elemento al principio de la =
lista?
s=F3lo consigo a=F1adirlo al final y me descuadra toda la l=F3gica.

Gracias

-----Original Message-----
From: Adrian Garcia [mailto:Click here to reveal e-mail address]
Sent: martes, 28 de agosto de 2001 16:10
To: aspnges
Subject: [aspnges] Re: DataView

Esto no lo probe pero quizas ande:

....
ddlDeparment.DataSource =3D emp.GetDepartments();
ddlDeparment.DataBind();

ddlDeparment.Items.Add(new ListItem("","0")); // Agrego la opcion por=20
omision
ddlDeparment.SelectedIndex =3D ddlDeparment.Items.Count - 1; // la =
selecciono
....

Saludos

Adrian Garcia
Microsoft MVP [C#/ASP] - MCSD
NDSoft Filial C=F3rdoba - Argentina
Click here to reveal e-mail address

----Original Message Follows----
From: Laura San Roman <Click here to reveal e-mail address>
Reply-To: "aspnges" <Click here to reveal e-mail address>
To: "aspnges" <Click here to reveal e-mail address>
Subject: [aspnges] DataView
Date: Tue, 28 Aug 2001 12:30:19 +0100

=A1Hola!

    Tengo un nuevo problema con la aplicaci=F3n que estoy desarrolando en
.Net, os lo comento a ver si alguien me puede ayudar.
Tengo un m=E9todo de una clase que me devuelve un dataview con los =
registros
de una tabla que corresponden a una sql, hasta aqui bien, mi problema =
es,
con lo que devuelve este m=E9todo necesito rellenar un DropDownList que
contenga lo devuelto por el dataview y adem=E1s a=F1adir yo una =
opci=F3n m=E1s (la
t=EDpica del option value=3D0) al principio del todo. =BFAlguien me =
puede dar una
idea de como hacerla?

Muchas gracias y un saludo.

******************
..........
<script language=3D"C#" runat=3D"server">
            private void Page_Load(Object Sender, EventArgs E){
                if (!IsPostBack) {

                    businessemployee emp =3D new
businessemployee();
                    ddlDeparment.DataSource =3D
emp.GetDepartments();
                    ddlDeparment.DataBind();
......
......

Department: 
<asp:DropDownList Runat=3D"server" AutoPostBack=3D"True" =
ID=3D"ddlDeparment"
OnSelectedIndexChanged=3D"ddlDeparment_SelectedIndexChanged"
DataValueField=3D"id_department"
DataTextField=3D"department_name"></asp:DropDownList>
******************

M=E9todo de la clase que lo carga:

    public DataView GetRoles(String IdDepartment)
        {
            SqlConnection Conection =3D new
SqlConnection(_ConnStr);
            String SQL =3D "Select * From tbRoles Where
id_department =3D " + IdDepartment + " Order By Role_name";
            SqlDataAdapter Command =3D new SqlDataAdapter(SQL
,Conection);
            DataSet Ds =3D new DataSet();
            Command.Fill(Ds, "tbRoles");
            return Ds.Tables["tbRoles"].DefaultView;
        }

| [aspnges] member Click here to reveal e-mail address =3D YOUR ID
| http://www.asplists.com/asplists/aspnges.asp =3D JOIN/QUIT
| http://www.asplists.com/search =3D SEARCH Archives

_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp

| [aspnges] member Click here to reveal e-mail address =3D YOUR ID
| http://www.asplists.com/asplists/aspnges.asp =3D JOIN/QUIT
| http://www.asplists.com/search =3D SEARCH Archives
Reply to this message...
 
    
Adrian Garcia
Laura, la solucion estaba en un correo de un participante de la lista (no
recuerdo quien) que propuso una solucion mucho mas simple que la que yo te
di y que, ademas, resuelve el problema que planteas.

Proba con:

....
ddlDeparment.DataSource = emp.GetDepartments();
ddlDeparment.DataBind();

ddlDeparment.Items.Insert(0, new ListItem("","0")); // Agrego la opcion por
omision
ddlDeparment.SelectedIndex = 0; // la selecciono. Quizas esto no sea
necesario
....

Saludos

Adrian Garcia
Microsoft MVP [C#/ASP] - MCSD
NDSoft Filial Córdoba - Argentina
Click here to reveal e-mail address

----Original Message Follows----
From: Laura San Roman <Click here to reveal e-mail address>
Reply-To: "aspnges" <Click here to reveal e-mail address>
To: "aspnges" <Click here to reveal e-mail address>
Subject: [aspnges] Re: DataView
Date: Thu, 30 Aug 2001 12:25:12 +0100

¿Existe alguna manera de añadir dicho elemento al principio de la lista?
sólo consigo añadirlo al final y me descuadra toda la lógica.

Gracias

-----Original Message-----
From: Adrian Garcia [mailto:Click here to reveal e-mail address]
Sent: martes, 28 de agosto de 2001 16:10
To: aspnges
Subject: [aspnges] Re: DataView

Esto no lo probe pero quizas ande:

....
ddlDeparment.DataSource = emp.GetDepartments();
ddlDeparment.DataBind();

ddlDeparment.Items.Add(new ListItem("","0")); // Agrego la opcion por
omision
ddlDeparment.SelectedIndex = ddlDeparment.Items.Count - 1; // la selecciono
....

Saludos

Adrian Garcia
Microsoft MVP [C#/ASP] - MCSD
NDSoft Filial Córdoba - Argentina
Click here to reveal e-mail address

----Original Message Follows----
From: Laura San Roman <Click here to reveal e-mail address>
Reply-To: "aspnges" <Click here to reveal e-mail address>
To: "aspnges" <Click here to reveal e-mail address>
Subject: [aspnges] DataView
Date: Tue, 28 Aug 2001 12:30:19 +0100

¡Hola!

    Tengo un nuevo problema con la aplicación que estoy desarrolando en
.Net, os lo comento a ver si alguien me puede ayudar.
Tengo un método de una clase que me devuelve un dataview con los registros
de una tabla que corresponden a una sql, hasta aqui bien, mi problema es,
con lo que devuelve este método necesito rellenar un DropDownList que
contenga lo devuelto por el dataview y además añadir yo una opción más (la
típica del option value=0) al principio del todo. ¿Alguien me puede dar una
idea de como hacerla?

Muchas gracias y un saludo.

******************
..........
<script language="C#" runat="server">
            private void Page_Load(Object Sender, EventArgs E){
                if (!IsPostBack) {

                    businessemployee emp = new
businessemployee();
                    ddlDeparment.DataSource =
emp.GetDepartments();
                    ddlDeparment.DataBind();
......
......

Department: 
<asp:DropDownList Runat="server" AutoPostBack="True" ID="ddlDeparment"
OnSelectedIndexChanged="ddlDeparment_SelectedIndexChanged"
DataValueField="id_department"
DataTextField="department_name"></asp:DropDownList>
******************

Método de la clase que lo carga:

    public DataView GetRoles(String IdDepartment)
        {
            SqlConnection Conection = new
SqlConnection(_ConnStr);
            String SQL = "Select * From tbRoles Where
id_department = " + IdDepartment + " Order By Role_name";
            SqlDataAdapter Command = new SqlDataAdapter(SQL
,Conection);
            DataSet Ds = new DataSet();
            Command.Fill(Ds, "tbRoles");
            return Ds.Tables["tbRoles"].DefaultView;
        }

| [aspnges] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspnges.asp = JOIN/QUIT
| http://www.asplists.com/search = SEARCH Archives

_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp

| [aspnges] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspnges.asp = JOIN/QUIT
| http://www.asplists.com/search = SEARCH Archives

| [aspnges] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspnges.asp = JOIN/QUIT
| http://www.asplists.com/search = SEARCH Archives

_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp
Reply to this message...
 
    
Laura San Roman
Muchas gracias por vuestra ayuda.

-----Original Message-----
From: Adrian Garcia [mailto:Click here to reveal e-mail address]
Sent: jueves, 30 de agosto de 2001 15:04
To: aspnges
Subject: [aspnges] Re: DataView

Laura, la solucion estaba en un correo de un participante de la lista =
(no=20
recuerdo quien) que propuso una solucion mucho mas simple que la que yo =
te=20
di y que, ademas, resuelve el problema que planteas.

Proba con:

....
ddlDeparment.DataSource =3D emp.GetDepartments();
ddlDeparment.DataBind();

ddlDeparment.Items.Insert(0, new ListItem("","0")); // Agrego la opcion =
por=20
omision
ddlDeparment.SelectedIndex =3D 0; // la selecciono. Quizas esto no sea=20
necesario
....

Saludos

Adrian Garcia
Microsoft MVP [C#/ASP] - MCSD
NDSoft Filial C=F3rdoba - Argentina
Click here to reveal e-mail address

----Original Message Follows----
From: Laura San Roman <Click here to reveal e-mail address>
Reply-To: "aspnges" <Click here to reveal e-mail address>
To: "aspnges" <Click here to reveal e-mail address>
Subject: [aspnges] Re: DataView
Date: Thu, 30 Aug 2001 12:25:12 +0100

=BFExiste alguna manera de a=F1adir dicho elemento al principio de la =
lista?
s=F3lo consigo a=F1adirlo al final y me descuadra toda la l=F3gica.

Gracias

-----Original Message-----
From: Adrian Garcia [mailto:Click here to reveal e-mail address]
Sent: martes, 28 de agosto de 2001 16:10
To: aspnges
Subject: [aspnges] Re: DataView

Esto no lo probe pero quizas ande:

....
ddlDeparment.DataSource =3D emp.GetDepartments();
ddlDeparment.DataBind();

ddlDeparment.Items.Add(new ListItem("","0")); // Agrego la opcion por
omision
ddlDeparment.SelectedIndex =3D ddlDeparment.Items.Count - 1; // la =
selecciono
....

Saludos

Adrian Garcia
Microsoft MVP [C#/ASP] - MCSD
NDSoft Filial C=F3rdoba - Argentina
Click here to reveal e-mail address

----Original Message Follows----
From: Laura San Roman <Click here to reveal e-mail address>
Reply-To: "aspnges" <Click here to reveal e-mail address>
To: "aspnges" <Click here to reveal e-mail address>
Subject: [aspnges] DataView
Date: Tue, 28 Aug 2001 12:30:19 +0100

=A1Hola!

    Tengo un nuevo problema con la aplicaci=F3n que estoy desarrolando en
.Net, os lo comento a ver si alguien me puede ayudar.
Tengo un m=E9todo de una clase que me devuelve un dataview con los =
registros
de una tabla que corresponden a una sql, hasta aqui bien, mi problema =
es,
con lo que devuelve este m=E9todo necesito rellenar un DropDownList que
contenga lo devuelto por el dataview y adem=E1s a=F1adir yo una =
opci=F3n m=E1s (la
t=EDpica del option value=3D0) al principio del todo. =BFAlguien me =
puede dar una
idea de como hacerla?

Muchas gracias y un saludo.

******************
..........
<script language=3D"C#" runat=3D"server">
            private void Page_Load(Object Sender, EventArgs E){
                if (!IsPostBack) {

                    businessemployee emp =3D new
businessemployee();
                    ddlDeparment.DataSource =3D
emp.GetDepartments();
                    ddlDeparment.DataBind();
......
......

Department: 
<asp:DropDownList Runat=3D"server" AutoPostBack=3D"True" =
ID=3D"ddlDeparment"
OnSelectedIndexChanged=3D"ddlDeparment_SelectedIndexChanged"
DataValueField=3D"id_department"
DataTextField=3D"department_name"></asp:DropDownList>
******************

M=E9todo de la clase que lo carga:

    public DataView GetRoles(String IdDepartment)
        {
            SqlConnection Conection =3D new
SqlConnection(_ConnStr);
            String SQL =3D "Select * From tbRoles Where
id_department =3D " + IdDepartment + " Order By Role_name";
            SqlDataAdapter Command =3D new SqlDataAdapter(SQL
,Conection);
            DataSet Ds =3D new DataSet();
            Command.Fill(Ds, "tbRoles");
            return Ds.Tables["tbRoles"].DefaultView;
        }

| [aspnges] member Click here to reveal e-mail address =3D YOUR ID
| http://www.asplists.com/asplists/aspnges.asp =3D JOIN/QUIT
| http://www.asplists.com/search =3D SEARCH Archives

_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp

| [aspnges] member Click here to reveal e-mail address =3D YOUR ID
| http://www.asplists.com/asplists/aspnges.asp =3D JOIN/QUIT
| http://www.asplists.com/search =3D SEARCH Archives

| [aspnges] member Click here to reveal e-mail address =3D YOUR ID
| http://www.asplists.com/asplists/aspnges.asp =3D JOIN/QUIT
| http://www.asplists.com/search =3D SEARCH Archives

_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp

| [aspnges] member Click here to reveal e-mail address =3D YOUR ID
| http://www.asplists.com/asplists/aspnges.asp =3D JOIN/QUIT
| http://www.asplists.com/search =3D SEARCH Archives
Reply to this message...
 
    
Bicuna Xabier
LAURA, CREO QUE LO QUE BUSCAS ES LO SIGUIENTE,=20

y es lo escribio Luis Ruiz <Click here to reveal e-mail address>

DropDownList.Items.Insert(0, new ListItem(" Ninguno ",
"-1")) ;

[Original message clipped]
Reply to this message...
 
 
System.Data.DataSet
System.Data.DataView
System.Data.SqlClient.SqlConnection
System.Data.SqlClient.SqlDataAdapter
System.EventArgs
System.Web.UI.WebControls.DataGrid
System.Web.UI.WebControls.DataList
System.Web.UI.WebControls.DropDownList
System.Web.UI.WebControls.ListItem
System.Windows.Forms.DataGrid




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification