Setting Default

[jez123456]

Hi experts.

I have an ASP.Net page with a DropDownList called cboYear. This gets filled
with a c# method as follows.

private void FillYearList() {
SqlConnection cn = new SqlConnection() ;
cn = DatEngine.TimeO ffConn;
SqlCommand sc = new SqlCommand("SEL ECT intYear, Description FROM
dbo.vwYearSelec tor ",cn);
cn.Open();
SqlDataReader dr =sc.ExecuteRead er();

//Set the values to be used from the database for the combo
cboYear.DataSou rce = dr; //attach Datareader
cboYear.DataVal ueField = "intYear"; //specify column that contains the
value to use
cboYear.DataTex tField= "Descriptio n"; //specify column that contains the
value to see
cboYear.DataBin d();
cn.Close(); //Must close this!!!!
dr.Close();
}

The data in vwYearSelector is

intYear Description
2004 2004
2005 2005/2006
2006 2006/2007
2007 2007/2008
All this worked fine in 2004, however now in 2005, the cboYear still
initially shows the 2004. How can I set the cboYear to now display 2005/2006
when the page first loads. 2004 could then be selected if required later.

Thanks

[GazzoCS]

Hi jez,

Have you tried setting the SelectedIndex property of the DropDownList to 1
after you have done the databinding?

"jez123456" wrote:

Hi experts.

I have an ASP.Net page with a DropDownList called cboYear. This gets filled
with a c# method as follows.

private void FillYearList() {
SqlConnection cn = new SqlConnection() ;
cn = DatEngine.TimeO ffConn;
SqlCommand sc = new SqlCommand("SEL ECT intYear, Description FROM
dbo.vwYearSelec tor ",cn);
cn.Open();
SqlDataReader dr =sc.ExecuteRead er();

//Set the values to be used from the database for the combo
cboYear.DataSou rce = dr; //attach Datareader
cboYear.DataVal ueField = "intYear"; //specify column that contains the
value to use
cboYear.DataTex tField= "Descriptio n"; //specify column that contains the
value to see
cboYear.DataBin d();
cn.Close(); //Must close this!!!!
dr.Close();
}

The data in vwYearSelector is

intYear Description
2004 2004
2005 2005/2006
2006 2006/2007
2007 2007/2008
All this worked fine in 2004, however now in 2005, the cboYear still
initially shows the 2004. How can I set the cboYear to now display 2005/2006
when the page first loads. 2004 could then be selected if required later.

Thanks

[Shiva]

Hi,

After databinding, have this:
cboYear.Items.F indByValue(Date Time.Now.Year.T oString()).Sele cted = true;

This will select current year in the drop-down.

HTH.

"jez123456" <je*******@disc ussions.microso ft.com> wrote in message
news:79******** *************** ***********@mic rosoft.com...
Hi experts.

I have an ASP.Net page with a DropDownList called cboYear. This gets filled
with a c# method as follows.

private void FillYearList() {
SqlConnection cn = new SqlConnection() ;
cn = DatEngine.TimeO ffConn;
SqlCommand sc = new SqlCommand("SEL ECT intYear, Description FROM
dbo.vwYearSelec tor ",cn);
cn.Open();
SqlDataReader dr =sc.ExecuteRead er();

//Set the values to be used from the database for the combo
cboYear.DataSou rce = dr; //attach Datareader
cboYear.DataVal ueField = "intYear"; //specify column that contains the
value to use
cboYear.DataTex tField= "Descriptio n"; //specify column that contains the
value to see
cboYear.DataBin d();
cn.Close(); //Must close this!!!!
dr.Close();
}

The data in vwYearSelector is

intYear Description
2004 2004
2005 2005/2006
2006 2006/2007
2007 2007/2008
All this worked fine in 2004, however now in 2005, the cboYear still
initially shows the 2004. How can I set the cboYear to now display 2005/2006
when the page first loads. 2004 could then be selected if required later.

Thanks

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

IT worked by chance, as it was the first value in the list, use the
SelectedIndex property to select the correct one.

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"jez123456" <je*******@disc ussions.microso ft.com> wrote in message
news:79******** *************** ***********@mic rosoft.com...

Hi experts.

I have an ASP.Net page with a DropDownList called cboYear. This gets
filled
with a c# method as follows.

private void FillYearList() {
SqlConnection cn = new SqlConnection() ;
cn = DatEngine.TimeO ffConn;
SqlCommand sc = new SqlCommand("SEL ECT intYear, Description FROM
dbo.vwYearSelec tor ",cn);
cn.Open();
SqlDataReader dr =sc.ExecuteRead er();

//Set the values to be used from the database for the combo
cboYear.DataSou rce = dr; //attach Datareader
cboYear.DataVal ueField = "intYear"; //specify column that contains the
value to use
cboYear.DataTex tField= "Descriptio n"; //specify column that contains the
value to see
cboYear.DataBin d();
cn.Close(); //Must close this!!!!
dr.Close();
}

The data in vwYearSelector is

intYear Description
2004 2004
2005 2005/2006
2006 2006/2007
2007 2007/2008
All this worked fine in 2004, however now in 2005, the cboYear still
initially shows the 2004. How can I set the cboYear to now display
2005/2006
when the page first loads. 2004 could then be selected if required later.

Thanks