Problem with databinding a webform/textboxes

**MdWebtress** · 10-21-2004 02:22 PM

I have 2 textboxes on my webform (ASP.NET) that are bound to a database. The only line in my load sub (after the page.ispostback line) is:

page.databind()

This is the error I get:

Code:

Index 0 is not non-negative and below total rows count. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.IndexOutOfRangeException: Index 0 is not non-negative and below total rows count.

How do I fix this? I'm using an SQLDataAdapter and connection.

**PeOfEo** · 10-21-2004 02:31 PM

could you attach all of the code?

**MdWebtress** · 10-21-2004 02:39 PM

Code:

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
        If Not Page.IsPostBack Then
            'Panel1.DataBind()
            Page.DataBind()
        End If
    End Sub

Code:

<%@ Page Language="vb" AutoEventWireup="false" Codebehind="WebForm1.aspx.vb" Inherits="Testing.WebForm1"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
	<HEAD>
		<title>WebForm1</title>
		<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
		<meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1">
		<meta name="vs_defaultClientScript" content="JavaScript">
		<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
	</HEAD>
	<body MS_POSITIONING="GridLayout">
		<form id="Form1" method="post" runat="server">
			&nbsp;
			<asp:TextBox id=TextBox1 style="Z-INDEX: 101; LEFT: 248px; POSITION: absolute; TOP: 224px" runat="server" Text='<%# DataBinder.Eval(DataSet11, "Tables[equipment].DefaultView.[0].BAR-CODE") %>'>
			</asp:TextBox>
		</form>
	</body>
</HTML>

**MdWebtress** · 10-22-2004 07:49 AM

Ok, I found out I needed this line: SqlDataAdapter1.Fill(dataset11)

Now, my next question. How do I navigate through this? (i.e., previous, next, first, last, etc.).

**PeOfEo** · 10-22-2004 10:01 PM

its a lot like an array. You use the rows.

dataset.Tables("table").Rows(0).Item("field")
that will return the first record
dataset.Tables("table").Rows.Count()
will return the total number of rows.
But it is in essence a big array created by your data.

Thread: Problem with databinding a webform/textboxes

Thread Tools

Display

Problem with databinding a webform/textboxes

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions