SGksDQogDQpJJ20gc3RpbGwgaGF2aW5nIHByb2JsZW1zIGdldHRpbmcgbXkgbGlzdCBib3ggd2hp
Y2ggaXMgYm91bmQgdG8gYSBkYXRhIHNvdXJjZSB0byB3b3JrLiAgSSBhbSB0cnlpbmcgdG8gaW1w
bGVtZW50IGl0IGJ5IHVzaW5nIGFzcHggYW5kIGEgc2VwZXJhdGUgYyMgZmlsZS4gIFdoZW4gSSBh
ZGQgaXQgdG8gdGhlIEFzcHggcGFnZSBpdCB3b3JrcyBmaW5lLCBidXQgd2hlbiB0aGV5IGFyZSBk
aXZpZGVkIHVwIGl0IHJldHVybnMgYW4gZXJyb3IgdGhhdCBpdCBjYW4ndCBmaW5kIHRoZSBvbGIg
b2JqZWN0LiAgSSByZWFsbHkgZG9uJ3Qgd2FudCB0byBwdXQgdGhlIGNvZGUgb24gdGhlIGFzcHgg
cGFnZS4gDQogDQpUaGFua3MgZm9yIGFueSBoZWxwIGluIGFkdmFuY2UNClBhdHJpY2sNCihTZWUg
Y29kZSBiZWxvdykNCiANCioqKipDIw0KdXNpbmcgU3lzdGVtOw0KdXNpbmcgU3lzdGVtLldlYjsN
CnVzaW5nIFN5c3RlbS5XZWIuVUk7DQp1c2luZyBTeXN0ZW0uV2ViLlVJLldlYkNvbnRyb2xzOw0K
dXNpbmcgU3lzdGVtLkRhdGE7DQp1c2luZyBTeXN0ZW0uRGF0YS5PbGVEYjsNCnB1YmxpYyBjbGFz
cyBmcmVpZ2h0X2xhbmUgOiBQYWdlew0KIHByb3RlY3RlZCBEYXRhR3JpZCBteURhdGFHcmlkOw0K
IA0KIA0KIHByb3RlY3RlZCB2b2lkIFBhZ2VfTG9hZChPYmplY3Qgc2VuZGVyLCBFdmVudEFyZ3Mg
ZSkNCiB7DQogaWYgKCEgSXNQb3N0QmFjaykNCiAgew0KICBvcmlnaW5fRGF0YUJpbmQoKTsNCiAg
RGF0YUJpbmQoKTsNCiAgfQ0KIH0NCiBwcm90ZWN0ZWQgdm9pZCBvcmlnaW5fRGF0YUJpbmQoKQ0K
IHsNCiANCiBPbGVEYkNvbm5lY3Rpb24gT0Nvbm47DQogT2xlRGJDb21tYW5kIE9Db207DQogDQog
T0Nvbm4gPSBuZXcgT2xlRGJDb25uZWN0aW9uKCJQcm92aWRlcj1NaWNyb3NvZnQuSmV0Lk9MRURC
LjQuMDsgRGF0YSBTb3VyY2U9QzpcXERhdGFcXENvbnN1bHRpbmdcXFJheXRyYW5zXFxXZWJTaXRl
XFxEYXRhY29udGFpbmVyc1xcZGJjb250YWluZXJjb3J1cy5tZGI7Iik7DQogT0NvbSA9IG5ldyBP
bGVEYkNvbW1hbmQoIlNFTEVDVCBjaXR5IEZST00gb3JpZ2luX2NpdGllcyIsIE9Db25uKTsNCiAN
CiBPQ29ubi5PcGVuKCk7DQogb2xiLkRhdGFTb3VyY2UgPSBPQ29tLkV4ZWN1dGVSZWFkZXIoQ29t
bWFuZEJlaGF2aW9yLkNsb3NlQ29ubmVjdGlvbik7DQogb2xiLkRhdGFUZXh0RmllbGQgPSAiY2l0
eSI7DQogb2xiLkRhdGFCaW5kKCk7DQogDQogfQ0KIA0KIA0KIHByb3RlY3RlZCB2b2lkIEJpbmRE
YXRhKCkgDQogew0KICBPbGVEYkNvbm5lY3Rpb24gbXlDb25uZWN0aW9uOw0KICBPbGVEYkNvbW1h
bmQgbXlDb21tYW5kOw0KICBPbGVEYkRhdGFBZGFwdGVyIGxhbmVEQTsNCiAgT2xlRGJQYXJhbWV0
ZXIgbXlQYXJhbWV0ZXI7DQogIERhdGFTZXQgbGFuZURTOw0KICAgIA0KICBsYW5lREEgPSBuZXcg
T2xlRGJEYXRhQWRhcHRlcigpOw0KICBteUNvbm5lY3Rpb24gPSBuZXcgT2xlRGJDb25uZWN0aW9u
KCJQcm92aWRlcj1NaWNyb3NvZnQuSmV0Lk9MRURCLjQuMDsgRGF0YSBTb3VyY2U9QzpcXERhdGFc
XENvbnN1bHRpbmdcXFJheXRyYW5zXFxXZWJTaXRlXFxEYXRhY29udGFpbmVyc1xcZGJjb250YWlu
ZXJjb3J1cy5tZGI7Iik7DQogIG15Q29tbWFuZCA9IG5ldyBPbGVEYkNvbW1hbmQoInZfcmF0ZV9s
b29rdXAiLCBteUNvbm5lY3Rpb24pOw0KICBsYW5lREEuU2VsZWN0Q29tbWFuZCA9IG15Q29tbWFu
ZDsNCiAgbXlDb21tYW5kLkNvbW1hbmRUeXBlID0gQ29tbWFuZFR5cGUuU3RvcmVkUHJvY2VkdXJl
Ow0KICBteUNvbW1hbmQuUGFyYW1ldGVycy5BZGQoIkBDb3VudHJ5IiwgT2xlRGJUeXBlLlZhckNo
YXIsIDUwKS5WYWx1ZSA9ICJUdXNjYWxvb3NhIjsNCiAgbXlDb21tYW5kLlBhcmFtZXRlcnMuQWRk
KCJARGVzdGluYXRpb24iLCBPbGVEYlR5cGUuSW50ZWdlciwgOCkuVmFsdWUgPSAxMTQ3Ow0KICAN
CiAgICAgIA0KICANCiAgdHJ5DQogIHsNCiAgIG15Q29ubmVjdGlvbi5PcGVuKCk7DQogICBsYW5l
RFMgPSBuZXcgRGF0YVNldCgpOw0KICAgbGFuZURBLkZpbGwobGFuZURTLCAidl9yYXRlX2xvb2t1
cCIpOw0KICAgbXlEYXRhR3JpZC5EYXRhU291cmNlID0gbGFuZURTLlRhYmxlc1sidl9yYXRlX2xv
b2t1cCJdOw0KICAgbXlEYXRhR3JpZC5EYXRhQmluZCgpOw0KICB9DQogIGZpbmFsbHkNCiAgew0K
ICAgbXlDb25uZWN0aW9uLkNsb3NlKCk7DQogIH0NCiB9DQogDQogcHJvdGVjdGVkIHZvaWQgUGFn
ZUluZGV4Q2hhbmdlZF9PbkNsaWNrKE9iamVjdCBzZW5kZXIsIERhdGFHcmlkUGFnZUNoYW5nZWRF
dmVudEFyZ3MgZSkNCiAgDQogIHsNCiAgIG15RGF0YUdyaWQuQ3VycmVudFBhZ2VJbmRleCA9IGUu
TmV3UGFnZUluZGV4Ow0KICAgQmluZERhdGEoKTsNCiAgfQ0KfQ0KKioqKioqKipQYXJ0IG9mIEFT
UFggUGFnZSoqKioqKg0KIA0KPCVAIFBhZ2UgSW5oZXJpdHM9ImZyZWlnaHRfbGFuZSIgU3JjPSJj
cmd1aWRlLmNzIiAlPg0KJQ0KPGh0bWw+DQogPGhlYWQ+DQogIDx0aXRsZT5Db3J1cyBPbmxpbmUg
Um91dGluZyBHdWlkZTwvdGl0bGU+DQogICA8c3R5bGUgcmVsPSJyYXlzdHlsZSI+DQogICAgQSB7
dGV4dC1kZWNvcmF0aW9uOm5vbmU7Y29sb3I6YmxhY2t9DQogICAgQTpIb3ZlciB7Y29sb3I6bWFy
b29uO3RleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmV9DQogICAgQTpWaXNpdGVkIHtjb2xvcjpyZWR9
DQogICA8L3N0eWxlPg0KIDwvaGVhZD4NCjxib2R5Pg0KPGZvcm0gcnVuYXQ9InNlcnZlciIgbWV0
aG9kPSJwb3N0Ij4NCg0KIDxhc3A6TGlzdEJveA0KIHJ1bmF0PSJzZXJ2ZXIiDQogUm93cyA9ICIx
NSINCiBTZWxlY3Rpb25Nb2RlPSJTaW5nbGUiDQogaWQ9Im9sYiINCiAvPg0KIDxhc3A6RGF0YUdy
aWQNCiBydW5hdD0ic2VydmVyIg0KIGlkPSJteURhdGFHcmlkIg0KIEF1dG9HZW5lcmF0ZUNvbHVt
bnM9IkZhbHNlIg0KIEdyaWRsaW5lcz0iQm90aCINCiBIb3Jpem9udGFsQWxpZ249IkNlbnRlciIN
CiBXaWR0aD0iMTAwJSINCiBDZWxsUGFkZGluZz0iNCINCiBDZWxsU3BhY2luZz0iMCINCiBBbGxv
d1BhZ2luZz0iVHJ1ZSINCiBPblBhZ2VJbmRleENoYW5nZWQ9IlBhZ2VJbmRleENoYW5nZWRfT25D
bGljayINCiBQYWdlU2l6ZT0iMjAiDQogUGFnZXJTdHlsZS1Dc3NDbGFzcz0icGFnZUxpbmtzIg0K
IFBhZ2VyU3R5bGUtTW9kZT0iTmV4dFByZXYiDQogUGFnZXJTdHlsZS1OZXh0UGFnZVRleHQ9Ik5l
eHQiDQogUGFnZXJTdHlsZS1QcmV2UGFnZVRleHQ9IlByZXZpb3VzIg0KIFBhZ2VyU3R5bGUtSG9y
aXpvbnRhbEFsaWduPSJSaWdodCINCiBQYWdlclN0eWxlLVBvc2l0aW9uPSJUb3BBbmRCb3R0b20i
DQogPg0KIA0KIDxjb2x1bW5zPg0KIA0KIDxhc3A6Qm91bmRDb2x1bW4NCiBEYXRhRmllbGQ9Ik9y
aWdpbkNpdHkiDQogSGVhZGVyVGV4dD0iT3JpZ2luIg0KIEhlYWRlclN0eWxlLUJhY2tDb2xvcj0i
bWFyb29uIg0KIEhlYWRlclN0eWxlLUZvcmVDb2xvcj0iI0ZGRkZGRiINCiBIZWFkZXJTdHlsZS1G
b250LVNpemU9IjEwIg0KIEhlYWRlclN0eWxlLUZvbnQtQm9sZD0idHJ1ZSINCiBIZWFkZXJTdHls
ZS1Gb250LU5hbWU9IlZlcmRhbmEiDQogDQogSXRlbVN0eWxlLUJhY2tDb2xvcj0iI0ZGRkZGRiIN
CiBJdGVtU3R5bGUtRm9yZUNvbG9yPSIjMDAwMDAwIg0KIEl0ZW1TdHlsZS1Gb250LVNpemU9Ijgi
DQogSXRlbVN0eWxlLUZvbnQtQm9sZD0idHJ1ZSINCiBJdGVtU3R5bGUtRm9udC1OYW1lPSJWZXJk
YW5hIg0KIC8+DQogDQogDQo

You have to declare your olb variable in your codebehind.  It looks like
you're using VS.NET -- the easy way to get your controls declared in the
codebehind is just to double click on the aspx page in design view.  If you
do this just on the design surface, you'll get taken to the Page_Load event,
and all of the controls on your page will be declared.

You can do it yourself by adding:
protected System.Web.UI.WebControls.ListBox olb;

right after this line:
  protected DataGrid myDataGrid;

Steve


Steven Smith, MCSE+Internet, Microsoft MVP: ASP.NET
ssmith@a...
President, ASPAlliance.com
http://aspalliance.com    The #1 ASP.NET Community
http://aspsmith.com        ASP.NET Training for ASP Developers

Learning ASP.NET?  Get My Book: ASP.NET By Example
http://www.amazon.com/exec/obidos/ASIN/0789725622/stevenatorasp/

----- Original Message -----
From: "Kelly, Patrick" <Patrick.Kelly@H...>
To: "aspx_beginners" <aspx_beginners@p...>
Sent: Thursday, April 11, 2002 12:01 AM
Subject: [aspx_beginners] Help!! - More Listbox Problems


> Hi,
>
> I'm still having problems getting my list box which is bound to a data
source to work.  I am trying to implement it by using aspx and a seperate c#
file.  When I add it to the Aspx page it works fine, but when they are
divided up it returns an error that it can't find the olb object.  I really
don't want to put the code on the aspx page.
>
> Thanks for any help in advance
> Patrick
> (See code below)
>
> ****C#
> using System;
> using System.Web;
> using System.Web.UI;
> using System.Web.UI.WebControls;
> using System.Data;
> using System.Data.OleDb;
> public class freight_lane : Page{
>  protected DataGrid myDataGrid;
>
>
>  protected void Page_Load(Object sender, EventArgs e)
>  {
>  if (! IsPostBack)
>   {
>   origin_DataBind();
>   DataBind();
>   }
>  }
>  protected void origin_DataBind()
>  {
>
>  OleDbConnection OConn;
>  OleDbCommand OCom;
>
>  OConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=C:\\Data\\Consulting\\Raytrans\\WebSite\\Datacontainers\\dbcontainerc
orus.mdb;");
>  OCom = new OleDbCommand("SELECT city FROM origin_cities", OConn);
>
>  OConn.Open();
>  olb.DataSource = OCom.ExecuteReader(CommandBehavior.CloseConnection);
>  olb.DataTextField = "city";
>  olb.DataBind();
>
>  }
>
>
>  protected void BindData()
>  {
>   OleDbConnection myConnection;
>   OleDbCommand myCommand;
>   OleDbDataAdapter laneDA;
>   OleDbParameter myParameter;
>   DataSet laneDS;
>
>   laneDA = new OleDbDataAdapter();
>   myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
Data
Source=C:\\Data\\Consulting\\Raytrans\\WebSite\\Datacontainers\\dbcontainerc
orus.mdb;");
>   myCommand = new OleDbCommand("v_rate_lookup", myConnection);
>   laneDA.SelectCommand = myCommand;
>   myCommand.CommandType = CommandType.StoredProcedure;
>   myCommand.Parameters.Add("@Country", OleDbType.VarChar, 50).Value 
"Tuscaloosa";
>   myCommand.Parameters.Add("@Destination", OleDbType.Integer, 8).Value 
1147;
>
>
>
>   try
>   {
>    myConnection.Open();
>    laneDS = new DataSet();
>    laneDA.Fill(laneDS, "v_rate_lookup");
>    myDataGrid.DataSource = laneDS.Tables["v_rate_lookup"];
>    myDataGrid.DataBind();
>   }
>   finally
>   {
>    myConnection.Close();
>   }
>  }
>
>  protected void PageIndexChanged_OnClick(Object sender,
DataGridPageChangedEventArgs e)
>
>   {
>    myDataGrid.CurrentPageIndex = e.NewPageIndex;
>    BindData();
>   }
> }
> ********Part of ASPX Page******
>
> <%@ Page Inherits="freight_lane" Src="crguide.cs" %>
> %
> <html>
>  <head>
>   <title>Corus Online Routing Guide</title>
>    <style rel="raystyle">
>     A {text-decoration:none;color:black}
>     A:Hover {color:maroon;text-decoration:underline}
>     A:Visited {color:red}
>    </style>
>  </head>
> <body>
> <form runat="server" method="post">
>
>  <asp:ListBox
>  runat="server"
>  Rows = "15"
>  SelectionMode="Single"
>  id="olb"
>  />
>  <asp:DataGrid
>  runat="server"
>  id="myDataGrid"
>  AutoGenerateColumns="False"
>  Gridlines="Both"
>  HorizontalAlign="Center"
>  Width="100%"
>  CellPadding="4"
>  CellSpacing="0"
>  AllowPaging="True"
>  OnPageIndexChanged="PageIndexChanged_OnClick"
>  PageSize="20"
>  PagerStyle-CssClass="pageLinks"
>  PagerStyle-Mode="NextPrev"
>  PagerStyle-NextPageText="Next"
>  PagerStyle-PrevPageText="Previous"
>  PagerStyle-HorizontalAlign="Right"
>  PagerStyle-Position="TopAndBottom"
>  >
>
>  <columns>
>
>  <asp:BoundColumn
>  DataField="OriginCity"
>  HeaderText="Origin"
>  HeaderStyle-BackColor="maroon"
>  HeaderStyle-ForeColor="#FFFFFF"
>  HeaderStyle-Font-Size="10"
>  HeaderStyle-Font-Bold="true"
>  HeaderStyle-Font-Name="Verdana"
>
>  ItemStyle-BackColor="#FFFFFF"
>  ItemStyle-ForeColor="#000000"
>  ItemStyle-Font-Size="8"
>  ItemStyle-Font-Bold="true"
>  ItemStyle-Font-Name="Verdana"
>  />
>
>
>
> 캹Z* ºrê²?rz ujyjzí¾?í¼? ]ß?Ú?