473,769 Members | 2,444 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

asp.net datagrid - Multiple row update

Hi everybody,
I am an asp.net datagrid that have all the rows editable. An user can update
any column from datagrid. I'm trying to find a way to update only the rows
that were updated. How can I handle this? Is there any possibility to get
data row behind datagrid row?

Thank you in advance!

uiranejeb

Nov 18 '05 #1
7 3531
DataSet.GetChan ges()
http://msdn.microsoft.com/library/de...angestopic.asp

DataTable.GetCh anges()
http://msdn.microsoft.com/library/de...angestopic.asp

--
Regards,
HD
Once a Geek.... Always a Geek
"uiranejeb" <mi************ *@hotmail.comNO _SPAM> wrote in message
news:eo******** ******@TK2MSFTN GP12.phx.gbl...
Hi everybody,
I am an asp.net datagrid that have all the rows editable. An user can
update
any column from datagrid. I'm trying to find a way to update only the rows
that were updated. How can I handle this? Is there any possibility to get
data row behind datagrid row?

Thank you in advance!

uiranejeb

Nov 18 '05 #2
Hi HD,

Thany for replaying me. The question I ask for was how to get changes from
an asp.net datagrid? I need this changes for updating behind-data set.

I don't know exactly the correct behavior. If I modify data in datagrid,
then I must modify data in dataset? Is it true?
Thank you.
"Hermit Dave" <he************ @CAPS.AND.DOTS. hotmail.com> wrote in message
news:uA******** ******@TK2MSFTN GP09.phx.gbl...
DataSet.GetChan ges()
http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdata datasetclassget changestopic.as p
DataTable.GetCh anges()
http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdata datatableclassg etchangestopic. asp
--
Regards,
HD
Once a Geek.... Always a Geek
"uiranejeb" <mi************ *@hotmail.comNO _SPAM> wrote in message
news:eo******** ******@TK2MSFTN GP12.phx.gbl...
Hi everybody,
I am an asp.net datagrid that have all the rows editable. An user can
update
any column from datagrid. I'm trying to find a way to update only the rows that were updated. How can I handle this? Is there any possibility to get data row behind datagrid row?

Thank you in advance!

uiranejeb


Nov 18 '05 #3
not a big fan of access but this article will get you started... you have to
use a similar approach
http://msdn.microsoft.com/library/de...wtaccessdb.asp

similar article but a more generic one
http://msdn.microsoft.com/library/de...dWriteData.asp

hope this helps

--
Regards,
HD
Once a Geek.... Always a Geek
"uiranejeb" <mi************ *@hotmail.comNO _SPAM> wrote in message
news:ub******** ******@TK2MSFTN GP11.phx.gbl...
Hi HD,

Thany for replaying me. The question I ask for was how to get changes from
an asp.net datagrid? I need this changes for updating behind-data set.

I don't know exactly the correct behavior. If I modify data in datagrid,
then I must modify data in dataset? Is it true?
Thank you.
"Hermit Dave" <he************ @CAPS.AND.DOTS. hotmail.com> wrote in message
news:uA******** ******@TK2MSFTN GP09.phx.gbl...
DataSet.GetChan ges()

http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdata datasetclassget changestopic.as p

DataTable.GetCh anges()

http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdata datatableclassg etchangestopic. asp

--
Regards,
HD
Once a Geek.... Always a Geek
"uiranejeb" <mi************ *@hotmail.comNO _SPAM> wrote in message
news:eo******** ******@TK2MSFTN GP12.phx.gbl...
> Hi everybody,
>
>
> I am an asp.net datagrid that have all the rows editable. An user can
> update
> any column from datagrid. I'm trying to find a way to update only the rows > that were updated. How can I handle this? Is there any possibility to get > data row behind datagrid row?
>
>
>
> Thank you in advance!
>
> uiranejeb
>
>
>



Nov 18 '05 #4
Let me explain more detailed: I have an asp.net data grid that have all rows
editable. I edit some of the rows. Then I want to get a list of rows changed
and transfer them to dataset.

How can I do this? Thank you!
"Hermit Dave" <he************ @CAPS.AND.DOTS. hotmail.com> wrote in message
news:ur******** ******@TK2MSFTN GP10.phx.gbl...
not a big fan of access but this article will get you started... you have to use a similar approach
http://msdn.microsoft.com/library/de...us/dnadonet/ht
ml/adon_wtaccessdb .asp
similar article but a more generic one
http://msdn.microsoft.com/library/de...us/vbcon/html/
vbwlkWalkthroug hUsingDataGridW ebControlToRead WriteData.asp
hope this helps

--
Regards,
HD
Once a Geek.... Always a Geek
"uiranejeb" <mi************ *@hotmail.comNO _SPAM> wrote in message
news:ub******** ******@TK2MSFTN GP11.phx.gbl...
Hi HD,

Thany for replaying me. The question I ask for was how to get changes from an asp.net datagrid? I need this changes for updating behind-data set.

I don't know exactly the correct behavior. If I modify data in datagrid,
then I must modify data in dataset? Is it true?
Thank you.
"Hermit Dave" <he************ @CAPS.AND.DOTS. hotmail.com> wrote in message news:uA******** ******@TK2MSFTN GP09.phx.gbl...
DataSet.GetChan ges()

http://msdn.microsoft.com/library/de...us/cpref/html/ frlrfsystemdata datasetclassget changestopic.as p

DataTable.GetCh anges()

http://msdn.microsoft.com/library/de...us/cpref/html/ frlrfsystemdata datatableclassg etchangestopic. asp

--
Regards,
HD
Once a Geek.... Always a Geek
"uiranejeb" <mi************ *@hotmail.comNO _SPAM> wrote in message
news:eo******** ******@TK2MSFTN GP12.phx.gbl...
> Hi everybody,
>
>
> I am an asp.net datagrid that have all the rows editable. An user can
> update
> any column from datagrid. I'm trying to find a way to update only the

rows
> that were updated. How can I handle this? Is there any possibility to

get
> data row behind datagrid row?
>
>
>
> Thank you in advance!
>
> uiranejeb
>
>
>



Nov 18 '05 #5
I just found a sample.
http://www.dotnetjohn.com/runtime/MultiLineEdit.aspx

Thank you anyway.
"uiranejeb" <mi************ *@hotmail.comNO _SPAM> wrote in message
news:eo******** ******@TK2MSFTN GP12.phx.gbl...
Hi everybody,
I am an asp.net datagrid that have all the rows editable. An user can update any column from datagrid. I'm trying to find a way to update only the rows
that were updated. How can I handle this? Is there any possibility to get
data row behind datagrid row?

Thank you in advance!

uiranejeb

Nov 18 '05 #6
I actually havent tried inplace editing. (i prefer a seperate page for
add/edit)
The articles which i asked you to look at show you how to get started with
inplace editing of one row at a time.
unfortunately you will have to hunt on msdn or google.

here's one such article i could find...
http://www.dotnetjohn.com/articles/articleid83.aspx

good luck..

--
Regards,
HD
Once a Geek.... Always a Geek
"uiranejeb" <mi************ *@hotmail.comNO _SPAM> wrote in message
news:OE******** ******@TK2MSFTN GP10.phx.gbl...
Let me explain more detailed: I have an asp.net data grid that have all
rows
editable. I edit some of the rows. Then I want to get a list of rows
changed
and transfer them to dataset.

How can I do this? Thank you!
"Hermit Dave" <he************ @CAPS.AND.DOTS. hotmail.com> wrote in message
news:ur******** ******@TK2MSFTN GP10.phx.gbl...
not a big fan of access but this article will get you started... you have

to
use a similar approach

http://msdn.microsoft.com/library/de...us/dnadonet/ht
ml/adon_wtaccessdb .asp

similar article but a more generic one

http://msdn.microsoft.com/library/de...us/vbcon/html/
vbwlkWalkthroug hUsingDataGridW ebControlToRead WriteData.asp

hope this helps

--
Regards,
HD
Once a Geek.... Always a Geek
"uiranejeb" <mi************ *@hotmail.comNO _SPAM> wrote in message
news:ub******** ******@TK2MSFTN GP11.phx.gbl...
> Hi HD,
>
> Thany for replaying me. The question I ask for was how to get changes from > an asp.net datagrid? I need this changes for updating behind-data set.
>
> I don't know exactly the correct behavior. If I modify data in
> datagrid,
> then I must modify data in dataset? Is it true?
> Thank you.
>
>
> "Hermit Dave" <he************ @CAPS.AND.DOTS. hotmail.com> wrote in message > news:uA******** ******@TK2MSFTN GP09.phx.gbl...
>> DataSet.GetChan ges()
>>
> http://msdn.microsoft.com/library/de...us/cpref/html/ > frlrfsystemdata datasetclassget changestopic.as p
>>
>> DataTable.GetCh anges()
>>
> http://msdn.microsoft.com/library/de...us/cpref/html/ > frlrfsystemdata datatableclassg etchangestopic. asp
>>
>> --
>> Regards,
>> HD
>> Once a Geek.... Always a Geek
>> "uiranejeb" <mi************ *@hotmail.comNO _SPAM> wrote in message
>> news:eo******** ******@TK2MSFTN GP12.phx.gbl...
>> > Hi everybody,
>> >
>> >
>> > I am an asp.net datagrid that have all the rows editable. An user
>> > can
>> > update
>> > any column from datagrid. I'm trying to find a way to update only
>> > the
> rows
>> > that were updated. How can I handle this? Is there any possibility
>> > to
> get
>> > data row behind datagrid row?
>> >
>> >
>> >
>> > Thank you in advance!
>> >
>> > uiranejeb
>> >
>> >
>> >
>>
>>
>
>



Nov 18 '05 #7
just replied to you message with probably a link on the same site..

--
Regards,
HD
Once a Geek.... Always a Geek
"uiranejeb" <mi************ *@hotmail.comNO _SPAM> wrote in message
news:ea******** ******@TK2MSFTN GP09.phx.gbl...
I just found a sample.
http://www.dotnetjohn.com/runtime/MultiLineEdit.aspx

Thank you anyway.
"uiranejeb" <mi************ *@hotmail.comNO _SPAM> wrote in message
news:eo******** ******@TK2MSFTN GP12.phx.gbl...
Hi everybody,
I am an asp.net datagrid that have all the rows editable. An user can

update
any column from datagrid. I'm trying to find a way to update only the
rows
that were updated. How can I handle this? Is there any possibility to get
data row behind datagrid row?

Thank you in advance!

uiranejeb


Nov 18 '05 #8

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

Similar topics

1
1299
by: Bill Reynolds | last post by:
I'm trying to add functionality to a VB 6 application allowing customer service to add a customer number to a new customer. Customers are added to the database by sales personnel, and a prospective customer may have multiple rows due to projected orders for multiple products. Customer numbers are assigned when a new customer makes their first order. I'm using a DataGrid connected to an ADO Data Control. The data control is connected...
2
9926
by: Chris Plowman | last post by:
Hi all, I was wondering if anyone can help me with a really annoying problem I have been having. I made a derived datagrid class that will select the row when a user clicks anywhere on a cell (multi-select without modifier keys). I got that working fine, but I also wanted to keep rows selected after a sort, which I do by storing the row's id in an arraylist. The idea was to do the sort and then go back and re-select the rows with that...
1
18250
by: Brian | last post by:
I have a dataset containing 2 tables. I need to fill a datagrid using data from both of these. If I could create a SQL Statement to fill the datagrid, it would look like this: SELECT fields.fieldname, fieldvalues.value FROM fields, fieldvalues I am having trouble finding documentation explaining how to populate
12
2880
by: James Norton-Jones | last post by:
Hi, Am I trying to hold the data of a DataGrid in a label so that when the form is reposted the DataGrid can be repopulated. The problem I am having is that I don't understand how to get the text into a stream in order to be able to use DataSetOutcomes1.ReadXML(MyStream). Thanks in advance, James
1
3296
by: Andrew | last post by:
Hey all, I am very new to ASP.Net (and .Net in general), but that isn't stopping the boss from wanting to begin new projects in it. This latest project has me kinda stumped and after a couple days of struggling, I figure asking you all (the experts) will keep me from going down some dark and dangerous road. The project I have is a fairly simple one, in theory anyway. The gist is to create a page where the user enters an IDNumber,...
1
1971
by: Wolffang | last post by:
From: "Wolffang" <javid@techlite.co.uk> Subject: How to do a multiple select and update in a datagrid Date: 23 October 2004 21:28 Using Visual studio.net VB I have a datagrid that brings records from a stored procedure. Be selecting multiple datarows using a checkbox. All i want to do is update a field called 'Active' datatype bit from 0 to 1
0
1639
by: cwbp17 | last post by:
I'm having trouble updating individual datagrid cells. Have two tables car_master (columns include Car_ID, YEAR,VEHICLE) and car_detail (columns include Car_ID,PRICE,MILEAGE,and BODY);both tables have a FK relationship on CAR_ID so the oracledataadapter1 select statement(CommandText) is: select car_master.car_id, car_master.year,car_master.vehicle,car_detail.car_id AS EXPR1,
6
4679
by: shil | last post by:
Hi, I am writing a windows app in .net 2003. I have a datagrid which gets data from a storedprocedure. My question is how can I update the data in the datagrid? I want to call another storedprocedure to update the data in the datagrid. Thanks in advance.
4
1277
by: Abby | last post by:
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.
0
9579
marktang
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...
0
10035
jinu1996
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...
1
9984
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 most users, this new feature is actually very convenient. If you want to control the update process,...
0
9851
tracyyun
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...
0
8863
agi2029
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5293
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...
0
5441
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3949
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
2
3556
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.