Understanding BindingSource, DataSource, DataAdapter.

Hello.
I have two forms.
on each form I can delete/insert/update rows on a datatable.

The question :
==========
I want that :
at each new form - only the changes on the specific form take or not take 
affect.
(I want to commit or rollback the changes from the starting point of the 
form).
I can add/update/delete more then one single row.

==========================
I didn't see how bindingSource is acts as a "layer", because I need to 
delete by datarow object, and not via bindingSource object.
(dim dr as datarow
 ...
dr.delete() )

I am using :
BindingSource : for filtering and searching a specific row.
DataTable : adding rows, deleting rows, or update rows to a collection.
DataAdapter : one single adapter for the whole solution, used to put records 
on database, without any sql code behinds (using commandBuilder).

Thanks :) 

0
Mr
6/25/2010 10:19:46 AM
dotnet.languages.vb 830 articles. 0 followers. Follow

0 Replies
2161 Views

Similar Articles

[PageSpeed] 55

Reply:

Similar Artilces:

Help understanding DateAdd...
Thanks to all of you I was able to add the below expression to my query to give me the date of the Friday of the week represented by the value in my date field. However, I would like to understand what's happening as opposed to just pasting someone elses work. The value of [Date] = 6/26/2007 as Tuesday Result of Week Ending = 6/29/2007 a Friday Expression: Week Ending: DateAdd("w",6-Weekday([Date]),[Date]) I'm having a hard time understanding the concept of "w" = weekday and the function Weekday. I've been staring at this for so long, I may be ram...

need easy to understand instructions
I have 2002 office xp installed and would to configure my windows live account to OUTLOOK and/or OUTLOOK EXPRESS. Also whe I go to WORD, there's no "SEND TO" button for mr to click on...Thanks to anyone who can help.... Is your Outlook configured with all the info that was supplied by your ISP -- Peter Please Reply to Newsgroup for the benefit of others Requests for assistance by email can not and will not be acknowledged. "screwed up" <screwedup@discussions.microsoft.com> wrote in message news:05353803-C3DC-43F5-A2CB-B0AF5B0BD471@microsoft.com... >I ha...

How do I understand MashalAs
Hi! How should I understand this with MarshalAs in this example ? static extern void GetSystemTime([MarshalAs(UnmanagedType.LPStruct)]MySystemTime st); Is it correct to understand it in this way. When the managed code is excuted we have type MySystemTime but when the unmanaged type is called the type is changed to be LPStruct. //Tony Tony Johansson wrote: > Hi! > > How should I understand this with MarshalAs in this example ? > static extern void > GetSystemTime([MarshalAs(UnmanagedType.LPStruct)]MySystemTime st); > > Is it correct to unders...

hashCode understanding
Hi! Assume I have 2 instances of a class called Test see below which will work as key in a hashtable. The Name property of instance1 is set to 'Paul', and the Name property of instance2 is set to 'Piet'. Both instances will generate different hashcode, and they're also different according to the Equals method.So far so good. When looking up Piet I will get the value object whatever it can be. Now, suppose that I change the Name of instance2 to 'Paul', then, according to my Equals method, both instances should be equal, and according to the hashcode...

Help me understand mysterious Temp files.
Three of these appear every time I log on to Windows, in this folder: C:\Documents and Settings\Owner\Local Settings\Temp. I can always delete all but the three most recent. I see repeated references to Adobe Photoshop, which is not now nor has it ever been installed on my computer--though I do use the Adobe PDF Reader. I've heard lately of a strange new kind of "cookie," but can't remember what it's called. Could that be what these are? I'd like to know why they appear all the time, and have for several years. They don't do any apparent harm, but d...

simple question: to update the record in a table that is not the current datasource...
I suspect, I'm in the right church, but the wrong pew... I want to update a table, which is not the record source for the current form, when the value of a combobox [cboPresetOption] on the current form is changed. the table [tbeFixtureSchedulePrintOptions] which contains the fields to be updated has only (1) record I've got the code below written, but the record is not updatin; and I suspect I have a simple error, but am blind to it at this particular moment... thanks in advance, -mark --------------------------------------------- Private Sub cboPresetOption_Cha...

Understanding IPSec FrontEnd BackEnd with e2k3 or e2k
Who can help?? What is the problem when I try to connect e2k FE and BE with IPSec. Is IPSec not transparent for Application Layer ??? What was changed in e2k3 dq ...

Problem while mailmerging with an Excel datasource
This is a multi-part message in MIME format. ------=_NextPart_000_0012_01C4E1D2.928EF280 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi everybody, is there a known issue when trying to mailmerge in WORD with an Excel = datasource when the merged EXCEL columns contain formulas. Everything works fine, except that WORD doesn't respect the format = settings defined in Excel. For example, a value (63,24) in a column defined in EXCEL as NUMBER - = decimal places 2 shows up in the mailmerged WORD document as = 63,236249999999998 We wor...

I need help understanding OutLook Express
I have been helping my family and a few friends with Outlook Express and so far I have been lucky. Question is usually "Where the heck is the (inbox, address book, stuff that I should be backing up, a Backup selection on the product toolbar)". I have been in the computer game for a lot of years, successfully transitioning from mainframes to minis to PC's - networked PC's, and I know the need to backup data. I am sure Microsoft would agree - but why do they make it so difficult find where the stuff to be backed up is located - or am I missing something obvious. Used ...

Trying to understand Preferred Names
I have a gazillion of transactions in the format of the following: HEB #428 10/17 #000784200 PU HEB #428 10/13 #000150600 PU HEB #428 10/08 #000723400 PU How do I make this read just HEB. I guess I'm not sure what I'm looking at when it shows me the Payee Name Variation and Payee, because every variation appears to be a payee. Do have have to rename every transaction every time I update my accounts? In microsoft.public.money, Mark Johnson wrote: >I have a gazillion of transactions in the format of the following: > >HEB #428 10/17 #000784200 PU >HEB #428 10/13 #0001506...

I don't understand the OnPaint method
Hi! I have some problems to fully understand the OnPaint that I override in my Form class. I do understand when I have an event handler for the Paint event. I mean when I override the OnPaint method this OnPaint is not an event handler I just override an existing method that exist in a more general class higher up and say now we use my implementation of OnPaint so windows will call my OnPaint instead of the other method OnPaint. I know that my OnPaint work as following when I have a windows with graphics on and hide it by using for example the notepad and then move the note...

Help me to understand formulae
Hi, Searching for the solver examples on the net I came across the example where I find a formulae that I don’t understand and I just wonder if any one could explain in very simple words the formulae is =B14*MAX (B10, 0) ^$H$4 where b14 =Unit Profit b10 =Units Produced $H$4= Diminishing Profit Factor (0.9) I can see that when I remove the Diminishing Profit Factor the result is much higher but I don’t understand why it has been included on the first place Thanks in advance Anna Hi anna: It is just a way to model reduced profit. For example, if H4 were set to .5 and B10 was 16, the...

Understanding PO and Taxes
It's been requested that we start entering taxes for every item on POs at the PO Entry level. We want it to report taxes on every item whether we are invoiced for them or not. I have three questions: 1. If we have setup for advanced tax - do we need to go into each item and change the item to taxable in order for it to print on the PO. The PO is showing the tax but when we print it, it is showing 0 percentage and the subtotal without the tax. 2. When I go into the Receivings screen and receive the item, the tax field is dimmed out. Why? 3. Can the tax amount be distributed ...

Understanding Mapi transport
I have to block some users to send external email; i have created a group (i.e. "smtp senders") enabled to send external email, adding it on smtp virtual server and allow to submit and relay. From Outlook Express client to relay is impossible (for users not included in "smtp senders"), the problem is that the outlook (mapi) users continue to relay external mail, why?! How is possible to block external MAPI relay !? i guess the best way is to block at SMTP connector which relays your mails outside of your organisation. well r u using Exchange 2000 or 2003?? for 2000 there...

Pivot Table
I have an excel pivot table using a query from an access database as the source. Worked great, including refreshing the data. Now I have a problem because I had to change the structure of the underlying database and didn't fix some of the querys yet. When I try to hange the query I'm getting the error message: "This query can not be edite". On OK I get the next message: "Too few parameters. Expected 1." I'm sure that's because of my changes in the database structure. But my problem is, that I don't know which query I used for the data. Is there anyway t...

Understanding the utilization of XML
Hi, Can some one provide me with a summary and a URL which will do the trick I.e. EXACTLY what is the utilization of XML and HOW does it help as compared to how (whatever it does) it was done before XML was here. Thanks--- XML is an open W3C standard than can be used to capture and contain data. The problem XML was designed to solve is that of data sharing. It seems that each one of the countless information systems in use today has a different mechanism for storing and transmitting data. Because all the mechanisms are different, a "customer record" (for example) from one s...

Having difficulty understanding SMALL function in formula
I have the following in a spreadsheet: A B C D E F G H row 1 1.1 1 76 71 #N/A 71 5 row 2 1.2 1 124 117 #N/A 117 7 row 3 1.3 1 156 159 159 159 3 row 4 2.1 2 12 5 #N/A 5 7 row 5 2.2 2 54 59 59 59 5 row 6 3.1 3 41 45 45 45 4 row 7 3.2 3 252 310 310 310 5 row 8 3.3 3 305 438 310 310 5 row 9 3.4 3 422 438 438 3 row 10 3.5 3 441 #N/A 438 3 row 11 4.1 4 33 35 35 35 2 row 12 4.2 4 107 111 111 111 4 row 13 4.3 4 180 175 #N/A 175 5 row 14 5.1 5 227 230 230 230 3 My array formula in column H is as follows: ={SMALL(($C$1:$C$14=C1)*ABS(G1-($D$1:$D$14)),COUNTA($C$1:$C$14)- COUNTIF($C$1:$C$14,C1)+1)} ...

XML datasource
SSBoYXZlIGEgVlMgMjAwNSBiZXRhLg0KSG93IEkgY2FuIGNyZWF0ZSBhIFhNTCBkYXRhc291cmNl IGluIGRlc3Vnbi10aW1lPw0KDQotLSANClN0YW5pc2xhdyBUcmlzdGFuDQpJUCBQcm90ZWN0aW9u DQpLeWl2LCBVa3JhaW5lDQpFLW1haWw6IGFkbWluQHplc3RhZC5jb20NCldFQjogd3d3Lnplc3Rh ZC5jb20= VGhhbmtzLCBzb2x1dGlvbiBmb3VuZDogQWRkLT5OZXcgSXRlbS0+RGF0YXNldA0KDQotLSANClN0 YW5pc2xhdyBUcmlzdGFuDQpJUCBQcm90ZWN0aW9uDQpLeWl2LCBVa3JhaW5lDQpFLW1haWw6IGFk bWluQHplc3RhZC5jb20NCldFQjogd3d3Lnplc3RhZC5jb20NCiJTdGFuaXNsYXcgVHJpc3RhbiIg PHN0YXM3NzVAaS5jb20udWE+INPPz8Ldycwv08/Pwt3JzMEg1yDOz9fP09TRyCDTzMXE1cDdxcU6 IG5ld3M6ZXNTVkxsS2ZGSEEuMjQyNEBUSzJNU0ZUTkdQMDkucG...

understanding "TRANSFERS" in the monthly Income Statment
Ok... I need help in understanding the TRANSFERS in the Monthly income and Spending STATMENTS.... Why are they a neg? My basic understanding is that INCOME 1000 EXPENSES 1000 INCOME - EXPESNE = 0 That is what the report is trying to show...like a mini PL for yourself I am assuming .... However... if in the above example I have 400 in transfers... what would my INCOME - EXPENSE = ? Thank you ... maybe I am dense... In microsoft.public.money, T Grier wrote: > > >I need help in understanding the TRANSFERS in the >Monthly income and Spending STATMENTS.... > >Why are they ...

Can't understand the error message
When I open this form I get a "Data type mismatch in creteria expression" and when I click on the button on the form I get "The expression you enetered refers to an object that is closed or doesn't exist" error in the code. When I click on Debug, it takes me to this line of code: Me.OutofScope_Table_subform.Form.RecordSource = "SELECT * fROM [OutofScope Table] WHERE [Project Number] ='" & _ Me.cmbProjectNumber & "'" & " AND [Task Number] ='" & Me.cmbTaskNumber & "'" & "...

Attachements
We have Exchange 2003 latest SP. We receive many attachments that get as large as 50MB. Sometimes an email with this attachment is sent to 3 people and then those 3 people forward it to 5 other people in the company, and then all of them may save it to various locations for their use. When they save it to their network drives we obviously have a lot of storage starting to be used up with duplicate data. 1) One of my questions is how does Exchange deal with attachments and if multiple people receive the same file? 2) Is there just one copy that Exchange references or are there x co...

Having problems understanding sub-form selections and uses of comb
Access '02: Hi all, I guess i'm having fundelmental problems getting my sub-forms and combo boxs to work for what i'm trying to attempt. I've posted my first problem with use of 'drop down combo box" and getting it to show me the text in the destination field already. I've made progress with that. Now i can't get a grip on the use of sub-forms and combo boxes for my next part. So i don't burden you to much can anyone recommend any useful visual demos or examples for these. The online help is of no use to me for my needs, and i can't...

power options properties help me understand
I have recently re done my laptop, running windows xp, sp3, I am unsure what to set in the power options properties. My laptop is always plugged into power sourse, so I do not keep battery in all the time. I was told to , by dell, to shut down over night when not using it. Ok, but in the daytime if I am away where do I leave it in- do I log off, go to standby or hibernate?I do not see a sleep button on my keyboard- very confusing- at the moment this is what I have done-turn off moniter-never-plugged in-turn off hard disks-never- system standby-never- system hibernates-never-unde...

datasources
I was wondering if it is possible to join 2 different datasources in Reporting Services. No. You have to do this somewhere else. If you are doing master-detail then use subreports to do this. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "Ben Watts" <benryanwatts@live.com> wrote in message news:#Hs0VHYsKHA.6004@TK2MSFTNGP04.phx.gbl... > I was wondering if it is possible to join 2 different datasources in > Reporting Services. > ...

understanding of a formula
Placing a + infront of a sum means what?- eg:=+SUM(C6+C8+C10) It usually means that the author of the formula started with Lotus 123. In lotus, you could start a formula with + +a1+b1 Excel starts with an equal sign: =a1+b1 But some people have muscle memory and can't stop typing that + even though they don't need it. sabi wrote: > > Placing a + infront of a sum means what?- eg:=+SUM(C6+C8+C10) -- Dave Peterson "sabi" <sabi@discussions.microsoft.com> wrote: > Placing a + infront of a sum means what? > eg:=+SUM(C6+C8+C10) Nothing special. It is a...