i am having trouble updating a datset because i get the follwing error
in the Data Adapter configuration Wizard:
Generated UPDATE statement. could not determine which columns uniquely
identify the rows for "Customers"
'Customers' is the only table from the database that im using for this
query, so it cant be anything to do with a problem of having multiple
tables. and the primary key is set. so i dont understand what the
problem is.
im using asp.net 2003, a microsoft access database, and an
OdbcDataAdapter .
can anyone help? 7 3732
It sounds like the primary key is NOT set, or has duplicate values
Jeff
"bazzer" <so*******@yaho o.com> wrote in message
news:11******** **************@ z34g2000cwc.goo glegroups.com.. . i am having trouble updating a datset because i get the follwing error in the Data Adapter configuration Wizard:
Generated UPDATE statement. could not determine which columns uniquely identify the rows for "Customers"
'Customers' is the only table from the database that im using for this query, so it cant be anything to do with a problem of having multiple tables. and the primary key is set. so i dont understand what the problem is.
im using asp.net 2003, a microsoft access database, and an OdbcDataAdapter .
can anyone help?
ive tried linking to a database with only one table, that has 2 fields,
'numbers', and 'names', set the primary key to numbers, and still it
wont work. ive even tried using windows forms and still i get the same
errors.
Did you check my suggestion?
"bazzer" <so*******@yaho o.com> wrote in message
news:11******** **************@ i40g2000cwc.goo glegroups.com.. . ive tried linking to a database with only one table, that has 2 fields, 'numbers', and 'names', set the primary key to numbers, and still it wont work. ive even tried using windows forms and still i get the same errors.
your suggestion? checking if the primary key is set, and checking for
duplicate values?
primary key is definetly set. and its set to Autonumber. By duplicate
values do you mean duplicate fields or primary keys. but as i said, ive
tried linking to a database with only one table, that has only 2
fields, 'numbers', and 'names', set the primary key to numbers, and
still it
wont work even with the most basic table. ive even tried using windows
forms and still i get the same errors. im about ready to give up really
cause no one seems to have a clue whats wrong. myself included. i can
only assume its something to do with the connection to the database
maybe. thanks for the help though. if u think of anything else let me
know.
Weird. Perhaps create a brand new database and try there? Perhaps it's
corrupted?
Jeff
"bazzer" <so*******@yaho o.com> wrote in message
news:11******** **************@ z34g2000cwc.goo glegroups.com.. . your suggestion? checking if the primary key is set, and checking for duplicate values?
primary key is definetly set. and its set to Autonumber. By duplicate values do you mean duplicate fields or primary keys. but as i said, ive tried linking to a database with only one table, that has only 2 fields, 'numbers', and 'names', set the primary key to numbers, and still it wont work even with the most basic table. ive even tried using windows forms and still i get the same errors. im about ready to give up really cause no one seems to have a clue whats wrong. myself included. i can only assume its something to do with the connection to the database maybe. thanks for the help though. if u think of anything else let me know.
tried that too a few times im afraid.
I did see this from a Google search
If I switch to OleDbConnection instead of OdbcConnection, everything's ok.
"Jeff Dillon" <je********@hot mail.com> wrote in message
news:OP******** ******@TK2MSFTN GP04.phx.gbl... Weird. Perhaps create a brand new database and try there? Perhaps it's corrupted?
Jeff
"bazzer" <so*******@yaho o.com> wrote in message news:11******** **************@ z34g2000cwc.goo glegroups.com.. . your suggestion? checking if the primary key is set, and checking for duplicate values?
primary key is definetly set. and its set to Autonumber. By duplicate values do you mean duplicate fields or primary keys. but as i said, ive tried linking to a database with only one table, that has only 2 fields, 'numbers', and 'names', set the primary key to numbers, and still it wont work even with the most basic table. ive even tried using windows forms and still i get the same errors. im about ready to give up really cause no one seems to have a clue whats wrong. myself included. i can only assume its something to do with the connection to the database maybe. thanks for the help though. if u think of anything else let me know.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: arvee |
last post by:
Hi - I'm updating an Oracle table with an empty string and getting the
error:
An unhandled exception of type 'System.Exception' occurred in
system.data.dll
Additional information: Parameter 'p1': No size set for variable length data
type: String.
The column is nullable and of type varchar2(50). I'm aware that I can store
DBNull.Value instead and Oracle won't complain, but, I was hoping to avoid
|
by: Nick Stansbury |
last post by:
Hi,
Sorry for the obscure title but I'm afraid I can't think of a better
way to describe what happened to one of my clerks last night. The guy was
working late, made a series of changes (accross a number of tables with a
dependant relationship structure - i.e. a customer linked to an order linked
to an invoice linked to a payments etc.) Now when he came back this morning
none of the work he did last night was still there. I'm by no means...
|
by: GSteven |
last post by:
(as formerly posted to microsoft.public.access.forms with no result)
I've created a continuous form which is based on a straightforward table
(ex - customers - 100 records). On the form there is a checkbox with a
control source named "MARK" (boolean) from customer table. I can check and
uncheck individual records fine. Then I created 2 command buttons named
"Select All" and "Deselect All". The Onclick property of these buttons runs
code...
|
by: web1110 |
last post by:
Hi y'all,
I was playing with the NorthWind database, displaying subtables in a
DataGrid. It worked fine for 3 levels, but when I added a fourth, I got the
following error:
These columns don't currently have unique values
The initialization code below generates the error on the last statement
(dataSet1.Relations.Add(clDataRelation34)). The odd thing is, if I CONTINUE
|
by: Robert Schuldenfrei |
last post by:
Dear NG,
I have done all I can do with Crystal Reports (CR) using the "pull" mode. I
now need to generate data in my application, load a DataSet with that data,
and "push" this on to a CR report. In the code listed below, you find a
demo DataSet, called MyDataSet, taken from the Bischof book. It runs from a
button created in Visual Studio (VS) in a project called Test3. So far it
works.
The next step is to create a .rpt file in...
| |
by: Hasan O. Zavalsiz |
last post by:
Hi , i am trying to figure out which approach is better to use .
let me explain the scenario.
i am using the "Nortwind" database . in this database i have "Customers "
table .The following is the two different ways to handle this table.
CASE 1 :
create a struct that encaplusates table "Customers" columns
public struct structCustomers
{
public string CustomerID;
|
by: HAN(removethis)twister |
last post by:
I've tried to create 11 textboxes as variables (not actually visible in
the program, not in Windows Form Designer) and have set DataBindings to
the text properties of the TextBoxes BUT according to tests I've run, it
says that the DataBindings exist, but the IsBinding is set to False, and
is ReadOnly (the bindings exist, they just aren't active AND I
can't/don't know how to make them active). Is there any way to allow
these 11 textboxes'...
|
by: saraDotNet |
last post by:
hi everybody ,
I'm a beginner student in vb.net,and I'm working on a very small project as a homework,and I've some questions which I ought to search for their solutions via any source .
My question, I need to make an (Update )button in most of my VB forms,which enable me to update any row elements in the datasource in Access through each form ,
for example:
I've a form about CustomersData as...
|
by: pbd22 |
last post by:
Hi.
How does one return a range of rows.
I know that "Top 5" will return rows 0 - 5
but, how do I get 6 - 10?
thanks
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |