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. 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.
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
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
Roman,
Show me that code, so it is impossible to see something, sometimes it is
just a simple thing as a uppercase
Cor
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
And where is that code I showed you?
Cor
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
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....
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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
| |