473,323 Members | 1,551 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

DropDownList with Dataset from OleDBConnection NOT display records

I've created an OleDBConnection with a corresponding dataAdapter and a
dataSet. In development I am able to retrieve records and display them fine.
Once compiled no records are returning. I'm loading the recordset in
Page_Load event:

DatSet.Clear()
dataAdapter.Fill(DataSet)

Microsft recommended using DataBind( ) but everytime I call theat function I
get a compile error. This is an ASP .NET web form. Help please, I'm getting
nowhere and Microsoft's "support" is USELESS.
Nov 21 '05 #1
9 2236
Roman,

With your code you show that you fill a dataset to from a database.

However you tell you load a recordset to a page. ???????????? I do not
understand that.

What you can do as one as the possibilities is set the dataset as a
datasource for a datagrid something as

Datagrid1.datasource = Dataset
Datagrid1.databind

I hope this helps?

Cor

"rr****@800mcmahan.com" <rr****@800mcmahan.com@discussions.microsoft.com > .
I've created an OleDBConnection with a corresponding dataAdapter and a
dataSet. In development I am able to retrieve records and display them
fine.
Once compiled no records are returning. I'm loading the recordset in
Page_Load event:

DatSet.Clear()
dataAdapter.Fill(DataSet)

Microsft recommended using DataBind( ) but everytime I call theat function
I
get a compile error. This is an ASP .NET web form. Help please, I'm
getting
nowhere and Microsoft's "support" is USELESS.

Nov 21 '05 #2
Roman,

I see now in the subject that it is about a dropdownlist than it can be (I
would not use the name dataset)

\\\
DropDownList1.DataSource = ds.Tables(0)
DropDownList1.DataTextField = "mycolumn1"
DropDownList1.DataMember = "mycolumn2"
DropDownList1.DataBind()
///

I hope this helps?

Cor
Nov 21 '05 #3
I've tried both of these methods and when I comile I receive "Specified
argument was out of the range of valid values. Parameter name: value". On
another note, I'm not using the actual name dataSet, it's just there as an
example.

"Cor Ligthert" wrote:
Roman,

I see now in the subject that it is about a dropdownlist than it can be (I
would not use the name dataset)

\\\
DropDownList1.DataSource = ds.Tables(0)
DropDownList1.DataTextField = "mycolumn1"
DropDownList1.DataMember = "mycolumn2"
DropDownList1.DataBind()
///

I hope this helps?

Cor

Nov 21 '05 #4
Roman,

Show me that code, so it is impossible to see something, sometimes it is
just a simple thing as a uppercase

Cor
Nov 21 '05 #5
If I try to use DataBind( ) I get a compile error. I use this and I get no
records returned.

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
DsUsers1.Clear()
dataAdapterUsers.Fill(DsUsers1)
DsSystems1.Clear()
dataAdapterSystems.Fill(DsSystems1)

dateBox.Text = Date.Today

End Sub

"Cor Ligthert" wrote:
Roman,

Show me that code, so it is impossible to see something, sometimes it is
just a simple thing as a uppercase

Cor

Nov 21 '05 #6
And where is that code I showed you?

Cor
Nov 21 '05 #7
I had to remove it. It appears that I'm OK when I have only one dataAdapter
with one dataSet. When I add another dataAdapter with another dataSet is
when I'm encountering the problem. In other words, this works:

DsUsers1.Clear()
SqlDataAdapter1.Fill(DsUsers1)

DataBind()

But this does not:

DsUsers1.Clear()
SqlDataAdapter1.Fill(DsUsers1)

DsSytems1.Clear()
SqlDataAdapter2.Fill(DsSytems1)

DataBind()

"Cor Ligthert" wrote:
And where is that code I showed you?

Cor

Nov 21 '05 #8
Roman,

It seems to me that you have set everyting in the designer, that I cannot
see, check that again, and use than as well instead of databind only.

the control (your dropdonw). databind

Cor

"rr****@800mcmahan.com"
..
I had to remove it. It appears that I'm OK when I have only one
dataAdapter
with one dataSet. When I add another dataAdapter with another dataSet is
when I'm encountering the problem. In other words, this works:

DsUsers1.Clear()
SqlDataAdapter1.Fill(DsUsers1)

DataBind()

But this does not:

DsUsers1.Clear()
SqlDataAdapter1.Fill(DsUsers1)

DsSytems1.Clear()
SqlDataAdapter2.Fill(DsSytems1)

DataBind()

"Cor Ligthert" wrote:
And where is that code I showed you?

Cor

Nov 21 '05 #9
I apologize for wasting your time. I resolved this problem. Apparently
soemthing was corrupt in the project itself. I started from scratch and am
now running fine. On to a new problem. Thanks for the assist.
"Cor Ligthert" wrote:
Roman,

It seems to me that you have set everyting in the designer, that I cannot
see, check that again, and use than as well instead of databind only.

the control (your dropdonw). databind

Cor

"rr****@800mcmahan.com"
..
I had to remove it. It appears that I'm OK when I have only one
dataAdapter
with one dataSet. When I add another dataAdapter with another dataSet is
when I'm encountering the problem. In other words, this works:

DsUsers1.Clear()
SqlDataAdapter1.Fill(DsUsers1)

DataBind()

But this does not:

DsUsers1.Clear()
SqlDataAdapter1.Fill(DsUsers1)

DsSytems1.Clear()
SqlDataAdapter2.Fill(DsSytems1)

DataBind()

"Cor Ligthert" wrote:
And where is that code I showed you?

Cor


Nov 21 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Antonio D'Ottavio | last post by:
Good morning, I've a problem with a dropdownlist located inside any row of a datalist, I fill both datalist and dropdownlist at runtime, the problem is with the dropdownlist infact using the event...
3
by: Bill | last post by:
I have a seating chart web form that has over 50 entry field controls (tables/booths) where I use a DropDownList box to select a single company name from a single large list of organizations (200...
2
by: xzzy | last post by:
Problem: the following creates an empty dropdownlist it needs to populate the dropdownlist with a list of printers global.aspx.cs++++++++++++++++++++++++++ string l_SQL = "SELECT modRowID,...
4
by: DotNetJunky | last post by:
I have built a control that runs an on-line help system. Depending on the category you selected via dropdownlist, it goes out and gets the child subcategories, and if there are any, adds a new...
2
by: jason | last post by:
Pardon my ignorance on this. The below code works, except, when I edit a record and update the two drop downs take the first entry in the dropdownlist if not selected. I'd also like the dropdown to...
3
by: troy.forster | last post by:
I am sure this must be about the simplest thing to do. I can whip something off in 10 different languages and environments with no problem. But VisualStudio 2003 and ASP.NET is sooooo...
2
by: Nosaj | last post by:
Houston, we've got a problem... In a ascx file, I bind a datasource with a dropdownlist. The following code runs perfectly in a aspx file but not in a ascx file. And I just can't understand it....
4
by: glenn | last post by:
Hi folks, I am getting an error "Object reference not set to an instance of an object". It seems I have everything in place but something is obviously in err. If you could take a quick peak...
0
by: ana_gil | last post by:
hello i have a problem with a dropdown list i am populating from an Access table. I´ve seen this problem in other discussions but i can´t seem to find the solution. please help. my .aspx has...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.