Hi all,
I have a datagrid which i am using for updating the data to the database. It
works fine for single row data however when i have multiple rows(records)
associated with the same criteria(billno ) it updates both the rows with the
values for the row i updated.
I thought of reading both the rows into a dataset and update that to the
database table but am not able to do so.
Any help will be appreciated.
Thanks,
Abby
4  1271 
Abby,
How do you populate that datagrid, your question seems a little bit strange
to me.
Cor
"Abby" <Ab**@discussio ns.microsoft.co mschreef in bericht
news:AE******** *************** ***********@mic rosoft.com...
Hi all,
I have a datagrid which i am using for updating the data to the database.
It
works fine for single row data however when i have multiple rows(records)
associated with the same criteria(billno ) it updates both the rows with
the
values for the row i updated.
I thought of reading both the rows into a dataset and update that to the
database table but am not able to do so.
Any help will be appreciated.
Thanks,
Abby
Hi Cor,
I use a dataset. I populate it and then bind it to the datagrid.
Let me explain the process again. Considering the dataset has 2 records in
it which are associated to the same billno say record 1 and record2. I need
to update the record 2 in the dataset.
But when i click on the update link after editing the data it updates both
the records with the same information.
so i was trying to catch the record that needs to be updated through a
dataset which i can create from the databind befor the update method is
executed.
Waiting for ur reply.
Thanks,
Abby
"Cor Ligthert [MVP]" wrote:
Abby,
How do you populate that datagrid, your question seems a little bit strange
to me.
Cor
"Abby" <Ab**@discussio ns.microsoft.co mschreef in bericht
news:AE******** *************** ***********@mic rosoft.com...
Hi all,
I have a datagrid which i am using for updating the data to the database.
It
works fine for single row data however when i have multiple rows(records)
associated with the same criteria(billno ) it updates both the rows with
the
values for the row i updated.
I thought of reading both the rows into a dataset and update that to the
database table but am not able to do so.
Any help will be appreciated.
Thanks,
Abby
Abby,
Is this a web datagrid or a windowforms datagrid, I assume web, but I am
still not sure,
Cor
"Abby" <Ab**@discussio ns.microsoft.co mschreef in bericht
news:DB******** *************** ***********@mic rosoft.com...
Hi Cor,
I use a dataset. I populate it and then bind it to the datagrid.
Let me explain the process again. Considering the dataset has 2 records in
it which are associated to the same billno say record 1 and record2. I
need
to update the record 2 in the dataset.
But when i click on the update link after editing the data it updates both
the records with the same information.
so i was trying to catch the record that needs to be updated through a
dataset which i can create from the databind befor the update method is
executed.
Waiting for ur reply.
Thanks,
Abby
"Cor Ligthert [MVP]" wrote:
>Abby,
How do you populate that datagrid, your question seems a little bit
strange
to me.
Cor
"Abby" <Ab**@discussio ns.microsoft.co mschreef in bericht
news:AE******* *************** ************@mi crosoft.com...
Hi all,
I have a datagrid which i am using for updating the data to the
database.
It
works fine for single row data however when i have multiple
rows(records)
associated with the same criteria(billno ) it updates both the rows with
the
values for the row i updated.
I thought of reading both the rows into a dataset and update that to
the
database table but am not able to do so.
Any help will be appreciated.
Thanks,
Abby
Cor,
its a web datagrid .
Abby
"Cor Ligthert [MVP]" wrote:
Abby,
Is this a web datagrid or a windowforms datagrid, I assume web, but I am
still not sure,
Cor
"Abby" <Ab**@discussio ns.microsoft.co mschreef in bericht
news:DB******** *************** ***********@mic rosoft.com...
Hi Cor,
I use a dataset. I populate it and then bind it to the datagrid.
Let me explain the process again. Considering the dataset has 2 records in
it which are associated to the same billno say record 1 and record2. I
need
to update the record 2 in the dataset.
But when i click on the update link after editing the data it updates both
the records with the same information.
so i was trying to catch the record that needs to be updated through a
dataset which i can create from the databind befor the update method is
executed.
Waiting for ur reply.
Thanks,
Abby
"Cor Ligthert [MVP]" wrote:
Abby,
How do you populate that datagrid, your question seems a little bit
strange
to me.
Cor
"Abby" <Ab**@discussio ns.microsoft.co mschreef in bericht
news:AE******** *************** ***********@mic rosoft.com...
Hi all,
I have a datagrid which i am using for updating the data to the
database.
It
works fine for single row data however when i have multiple
rows(records)
associated with the same criteria(billno ) it updates both the rows with
the
values for the row i updated.
I thought of reading both the rows into a dataset and update that to
the
database table but am not able to do so.
Any help will be appreciated.
Thanks,
Abby
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Steve Donnor |
last post by:
Here's my question..
I have a Dataset which has populated a datagrid with information from an AS400
That SQL looks like this
"Select MASYS, MAFLD, MADATA, MAEQV from QS36F.MAPDATA WHERE MASYS = ? AND MAFLD = ?
It populates a data adapter in which at that point I open a new dataset and I have the parameters and such setup including the proper...
|
by: Bil Muh |
last post by:
Esteemede Developers,
I would like to Thank All of You in advance for your sincere guidances.
I am developing a software using Visual C++ .NET Standard Edition with
Windows Form (.NET) template.
Briefly
--------------------------------------------------------------------------------------------
I need to create dynamically some...
|
by: AW |
last post by:
I am creating my columns automatically at run time, but I also want to align
the text columns to the left and the number columns to the right. Is there
anyway to do this?? I can't see how to specify this. Thanks.
|
by: Diego TERCERO |
last post by:
Hi...
I'm working on a tool for editing text resources for a family of software
product my company produces.
These text resources are found in a SQL Server database, in a table called
"Resource" with the following structure :
Resource{,en,fr,es}
Yes.. these are the only languages supported actually.
A couple of rows in that table would...
|
by: Patrick |
last post by:
I'm working on a contact management application, and need a hand with one
aspect...
Here's what I want to create:
------------------------------------
A form split into two parts. There is a datagrid on the left side that lists
names and perhaps a couple of other key fields. The user can click on a
record in the datagrid, which should...
| | |
by: ASP Yaboh |
last post by:
I have an ArrayList of data gathered from a database. I want to create a web
page from this data by creating a <table>, each cell in each row displays the
appropriate data. One of those cells in each row needs a <textarea> control.
The background supporting classes are completed, the only task left now is
to create the web page. I am at a...
|
by: Roger |
last post by:
I am using visual studio 2003. I user the server explorer and drag a table
onto a webform.
The program creates a "Connection" and an SQLDataAdapter Generates the
"Select, Insert, Delete" statments.
I right click on the SQLDataAdapter and chose Generate Dataset.
I drag a datagrid on to the form. Chose the SQLDataAdapter and dataset in...
|
by: A_PK |
last post by:
I have problem databinding the DataGrid with DataView/DataSet after the
filter...
I create the following proceudre in order for user to filter as many as they
want, but the following code is only allow user to filter the first time,
when they tried the second time, the speficied cast error message will
prompt one....
I create a mydataset1...
|
by: max |
last post by:
Hello,
I am a newbye, and I'm trying to write a simple application.
I have five tables with three columns; all tables are identical; I need to
change some data in the first table and let VB updates the same data in all
other four tables in the right places.
I know it would be possible by using the ForeignKeyConstraint object. I have
created...
|
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...
|
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...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
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...
|
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...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
