|
I have many examples of how to bind a dropdownlist but NONE match the code that is generated in VS .NET. Since I am new to .NET and web programming I am having difficulty following the gerneated code. I am convinced my problem is in the way I am binding the data. The eror I get is
"Index 0 is not non-negative and below total rows count."
and it ocurs in the following line
DropDownList1.DataBind();
Here is some of the code. If you are intereseted in helping me I can post all of it.
private void Page_Load(object sender, System.EventArgs e)<br />
{<br />
if (!Page.IsPostBack) <br />
{<br />
BindListToDropDown();<br />
}<br />
}<br />
<br />
#region Web Form Designer generated code<br />
override protected void OnInit(EventArgs e)<br />
{<br />
InitializeComponent();<br />
base.OnInit(e);<br />
}<br />
<br />
private void InitializeComponent()<br />
{ <br />
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();<br />
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();<br />
this.dbListOfAirports1 = new dbListOfAirports();<br />
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();<br />
((System.ComponentModel.ISupportInitialize)(this.dbListOfAirports1)).BeginInit();<br />
this.DropDownList1.DataBinding += new System.EventHandler(this.Page_Load);<br />
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;<br />
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {<br />
new System.Data.Common.DataTableMapping("Table", "tblAirport", new System.Data.Common.DataColumnMapping[] {<br />
new System.Data.Common.DataColumnMapping("AirportCode", "AirportCode"),<br />
new System.Data.Common.DataColumnMapping("AirportID", "AirportID"),<br />
new System.Data.Common.DataColumnMapping("AirportName", "AirportName"),<br />
new System.Data.Common.DataColumnMapping("City", "City"),<br />
new System.Data.Common.DataColumnMapping("Latitude", "Latitude"),<br />
new System.Data.Common.DataColumnMapping("Longitude", "Longitude"),<br />
new System.Data.Common.DataColumnMapping("State", "State")})});<br />
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=0;Data Source=""D:\MGDevelopment\SIMDAC Viewer\DB\simdac_be.mdb"";Jet OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";<br />
this.dbListOfAirports1.DataSetName = "dbListOfAirports"; <br />
this.dbListOfAirports1.Locale = new System.Globalization.CultureInfo("en-US");<br />
this.oleDbSelectCommand1.CommandText = "SELECT AirportCode, AirportID, AirportName, City, Latitude, Longitude, State FROM" +<br />
" tblAirport";<br />
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;<br />
((System.ComponentModel.ISupportInitialize)(this.dbListOfAirports1)).EndInit();<br />
<br />
}<br />
#endregion<br />
<br />
private void BindListToDropDown()<br />
{<br />
try <br />
{<br />
oleDbConnection1.Open();<br />
OleDbDataReader OleDbReader = this.oleDbSelectCommand1.ExecuteReader();<br />
DropDownList1.SelectedIndex=0;<br />
DropDownList1.DataSource=OleDbReader;<br />
DropDownList1.DataBind();<br />
<br />
}<br />
catch(OleDbException ex) <br />
{
Thanks in advance
Brian
|
|
|
|
|
Your code is all fine except that you can't set the SelectedIndex to 0. As far as I know that doesn't work. Comment out that line and I bet it will work. Your initial value then will be the first row in your table. Here is an example from some code that I had wrote a while back. Note this is NOT using Visual Studio to assist me:
public void buildlocation()
{
string ConnectionString = "yourconnection";
//Command String
string location_cmd = "yoursqlcommand";
SqlDataAdapter dataAdapter = new SqlDataAdapter(location_cmd, ConnectionString);
DataSet ds = new DataSet();
//Fill the datatable object
dataAdapter.Fill(ds,"yourtable");
location.DataSource = ds.Tables[0];
location.DataTextField = "location";
location.DataValueField = "location";
location.DataBind();
}
If you want to initialize a value other than a row in your table do this:
location.SelectedItem.Text = "Please Select a Location";
location.SelectedItem.Value = "select";
Hope that helps.
Scott Stocker
|
|
|
|
|
Thanks for the response. I took out the line in question. Still no binding. I added code to make sure that the datareader was in fact reading data. It was. I still get the following error
Index 0 is not non-negative and below total rows count.
Any more suggestions would be helpful.
|
|
|
|
|
In an aspx page I have inserted a menu header as user control, a datagrid with a select row column and two hidden text boxes to contain two fields of the table being accessed.
When the user selects a row in the datagrid the code behind stores two columns of the selected row in session variables ie row index and name. I then set the value of two textboxes within the form the second of which is set to autopostback.
On autopostback I want the session variables to populate two labels within the menu header control. However, these values both remain blank until I next select another row in the datagrid and the user control values are populated with the previous session variables.
It appears obvious that the postback is performed before the session variables are stored and therefore not being displayed in the user control form labels.
Is this the case and if so can I force the session variables to be saved first before the postback is performed.
Thanks
Sue
|
|
|
|
|
Does anyone here know about scrapper? How to use this guy in HTML coding coz I need to parse HTML content and extract data from it..?any help will be much appreciated!TQ!
mijan
|
|
|
|
|
I'm not quite sure but does anyone knows the term use to call this thing, it sounds like HTML 'scrap' or 'scrab' but i dono which one is correct. This thing will help identified any damages in our page. The code should resdies in HTML part.
mijan
|
|
|
|
|
I've been having a look at this example of doing http requests from the client side in IE / Firefox :
webpasties.com/xmlHttpRequest/ and it looks awesome.
However, I can't find any realworld examples of what you can do with the resultant xml.
Does anyone have examples of looping through an relatively simple XML file?
Cheers,
Simon
sig ::
"Don't try to be like Jackie. There is only one Jackie.... Study computers instead.", Jackie Chan on career choices.
article :: animation mechanics in SVG blog:: brokenkeyboards
"Most of us are programmers, but a few use VB", Christian Graus
|
|
|
|
|
I develop a page that get html content from an URL. For ex, from Yahoo search engine, I want to get the search result by request to the URL:
http://search.yahoo.com/search?p=codeproject&sm=Yahoo%21+Search&fr=FP-tab-web-t&toggle=1
But using frame is not allow here. 
Before, I build an ASP page that using ASPTear.dll to get the html content then response.write to the client browser. And my server is overloaded 
Now, I want the client browser request to that url and get the html content, not myserver. That's mean, the request come from client browser (by client-side scripting).
Help me please.
Thanks all of you.
|
|
|
|
|
Hi everyone,
Does anyone know of any good articles about the best arcitecture to set up a simple 3-tier (UI, Biz, Data Access) for an asp.net web application. And most importantly - the communication between the tiers.
I've been talking to myself for a few days now, and I still can't decide the best approach.
For example - what if something goes wrong when trying to retreive data from a DB, I don't want to rely on exceptions as it slows down execution. In the past I've created a class that holds the information from the query to the DB, which has an error object, which will tell you if the operation was succesfull.
However, it wasn't a very 'clean' approach.
Anyone got any 'clean arcitecture' articles??!
Cheers
Dan F.
|
|
|
|
|
In general the communication can be summarised as follows. The upper teir (UI on top, then Business, then Data on the bottom) can call into the teir below. If the lower teir below needs to communicate upwards then use events so that the coupling between layers is reduced. i.e. the lower teir exposes a number of events which it fires and the upper teir subscribes to those events. For a good example look at the way events are used in the UI layer so that Microsoft don't need to know anything about your code in order for their UI code to invoke your methods.
Daniel Fowler wrote:
I don't want to rely on exceptions as it slows down execution
What is an exception for? It is for when something exceptional happens. If you expect that the database isn't going to be there then you should test for that in advance. If a missing database is really a very rare and totally exceptional thing to happen then you should use exceptions. Don't use the tired argument that exceptions are slow to avoid them. Yes, exceptions are slow - but then the circumstances in which they are thrown are exceptional and should not happen often. If your code is throwning many exceptions a second then I would say that your code is wrong. If it throws an exception only occasionally then it sounds as if it is going great (assuming that you are catching and handling the exception).
Daniel Fowler wrote:
In the past I've created a class that holds the information from the query to the DB, which has an error object, which will tell you if the operation was succesfull.
And how did the database communicate a failure? Most likely it threw an exception. In which case just let up bubble up to where it can be handled most efficiently.
My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
Hi Colin
Thanks for the input, much appreaciated.
Dan F
|
|
|
|
|
I have a problem with sizing tables on a web page. I need to make the table height = 100% so that the bottom row always appears on the bottom edge of the page. However, if I use the attribute is ignored.
If I use it renders correctly both in IE and firefox. But according to the w3.org validator this is not valid HTML (there is no attribute "HEIGHT").
|
|
|
|
|
|
Ah, finally figured it out. The problem in with standards complient mode the page doesn't fill 100% of the window, so you need to do this in the style sheet:
body {
height:100%;
}
html{
height:100%;
}
|
|
|
|
|
hai
I draw the curve and line using vml & javascript and implemented in IE 6.0.
In my program I have a textbox and command button.suppose I want to draw a curve,write "curve" in textbox and javascript draws a curve using vmltags.
first I gave the input in textbox "curve",the figure appeared.then second I gave "line",but in this time,the line appeared with the curve.I need
line only.problem is refreshing...I don't know how to refresh?
help me
|
|
|
|
|
Ganesh:
I would have to see your code to figure out how to do what you want, but it doesn't sound like a huge problem. You can post the code here (in this thread) or email to me if you like.
--Retired Alchemist
|
|
|
|
|
Hello,
Can anyone give me some ideas on doing a web service project. It is for my degree and l have no idea of what to do. If anyone can give me some interesting ideas on what type of web service to build l will be very grateful.
Thanks in advance,
Steve
|
|
|
|
|
I have been asked to make a webpage (that is running fine on IE and Mozilla) to run on Safari. Is it a problem with the code? what should I change or add on my code to make the webpage run on any browser?
the page runs fine on various browsers such as IE or Mozilla but not on Safari. What is the problem and how can I solve it?
Please any help would be appreciated.
Thanks
McBel
|
|
|
|
|
The problem is that Safari is crapola. The issue will be with it treating specific HTML tags differently. Do a google for what tags are treated differently by Safari, then find where you use them, and either change to something else, or detect Safari and have a seperate Safari rendering layer.
Yuck, yuck, yuck.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
HI, is anyone get a class to handle a encoded URL . When I get a encoded URL I don't know how to decode it , and if that URL is a local full part , I need to get the some info.
I 'm so lazzzzzy to write a class . If some one already got it , please send it to me. lnmtuan@yahoo.com.
|
|
|
|
|
|
 I 'm so lazzzzzy to write a class ?????
|
|
|
|
|
Active Server Pages error 'ASP 0223'
TypeLib Not Found
METADATA tag contains a Type Library specification that does not match any Registry entry
amalan simon
|
|
|
|
|
|
 Thanx alot and its really helps alot...
amalan simon
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
