|
The same InsertCommand will be call as many times as records were added.
That's the beauty of it, you can insert a few records, delete others and make a couple of changes on others, then set the three commands (InsertCommand, DeleteCommand, UpdateCommand) and let the DataAdapter do all the updates to the Database.
Andres Manggini.
Buenos Aires - Argentina.
|
|
|
|
|
hmmm,I got it.But there is another question for me here:
Each time I make a change to dataset,I have to update DataAdapter,so for large database I don't think its good.
Or I can update DataAdapter after all changes.What is a solution for that too?
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
The idea is you make all the changes needed on the DataSet, once you're done and want to commit these changes to the database you call Update on the DataAdapter, and the changes will be reflected on the Database.
There is no need (of course this is depending on your design) to save the dataset after each change, it works sort of a batch process.
Hope that clarify a bit. If you have doubts just ask again 
Andres Manggini.
Buenos Aires - Argentina.
|
|
|
|
|
One more thing..
If you're dealing with large DataSet's, there is this method: GetChanges.
Doc:
Gets a copy of the DataSet containing all changes made to it since it was
last loaded
It can be very useful in distributed scenarios.
Andres Manggini.
Buenos Aires - Argentina.
|
|
|
|
|
Thanks Andres,Now I have to write some codes to understand all this things
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
I hate feeling like a newbie again.
I know I can just type the line...
protected override void OnPaint( PaintEventArgs e )
{
...
base.OnPaint( e );
}
but is there a way to get a list of override-ables and have the code generated for you? Something like ClassWizard in MFC?
Thanks!!
|
|
|
|
|
psdavis wrote:
I hate feeling like a newbie again.
Me too 
psdavis wrote:
but is there a way to get a list of override-ables
I believe that you can get that in the VB type properties box in the bottom right.
Christian
The tragedy of cyberspace - that so much can travel so far, and yet mean so little.
"I'm thinking of getting married for companionship and so I have someone to cook and clean." - Martin Marvinski, 6/3/2002
|
|
|
|
|
HAHAHAH! Of course.. Duh!!
|
|
|
|
|
Christian Graus wrote:
I believe that you can get that in the VB type properties box in the bottom right.
 Is this in design view? or code view?
And its curious you should say "VB type" box. In VB.NET, the overridable methods are obtained from the two drop-downs at the top of the code window. (unless of course, you mean in design view, in which case i'll shut up now)
I think i'll shut up anyway
--
David Wengier
Sonork ID: 100.14177 - Ch00k
|
|
|
|
|
Christian Graus wrote:
I believe that you can get that in the VB type properties box in the bottom right.
Thats not something only in VB type,its in another type too,
At least,I know it exist in VC++ and VC# type too,Is there ant other type too?;) (Of cource in VC++ type,its in bottom left)
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
In .NET yes. I'm saying the .NET IDE looks like VB6.
Christian
The tragedy of cyberspace - that so much can travel so far, and yet mean so little.
"I'm thinking of getting married for companionship and so I have someone to cook and clean." - Martin Marvinski, 6/3/2002
|
|
|
|
|
I have a Dataset,I want to get a spesific recordset form it.
Like recordset from table1,Column3,Row2
Thanks
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
Hey,I found it
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
i want to build a search engine but i can't know from where i should start.
ayman
|
|
|
|
|
Yeah, that's what the world needs.
Start by writing code that will trawl and index websites. Lots of them. The build a database, and create a front end so people can search it.
Christian
The tragedy of cyberspace - that so much can travel so far, and yet mean so little.
"I'm thinking of getting married for companionship and so I have someone to cook and clean." - Martin Marvinski, 6/3/2002
|
|
|
|
|
Hi,
I am just moving over to .Net and C# after using VB for many years, and I am trying to convert one of my old VB Com+ projects to a C# WebService.
However I have hit a problem, in the VB project I use IPWorks WebForm object to build a form to post to a Gateway service. I am tring to do the same in the new project but I would like to do it without having to buy the .Net version of IPWorks.
Dose anyone know if there is anything in the .Net framework that would alow you to do what the IPWorks webform control dose?
Thanks for any help.
Matthew.
|
|
|
|
|
Are you looking for something to make use of GET/POST functions in HTML?
If thats the case look at the System.Net.HttpWebRequest class, I think it will do what you are looking for
James
Sonork ID: 100.11138 - Hasaki
"Smile your little smile, take some tea with me awhile.
And every day we'll turn another page.
Behind our glass we'll sit and look at our ever-open book,
One brown mouse sitting in a cage."
"One Brown Mouse" from Heavy Horses, Jethro Tull 1978
|
|
|
|
|
This contains several bug fixes for problems in 1.2
It also contains some improved functionality for MenuControl and PopupMenu controls.
If you want that IDE look and feel then download the free source from ...
www.dotnetmagic.com
Phil Wright
phil.wright@dotnetmagic.com
|
|
|
|
|
If you would like an add on this page I'm sure Chris would love to get your money. Othervise, keep your add's out of the forums. 
- Anders
Money talks, but all mine ever says is "Goodbye!"
|
|
|
|
|
According to the web page:
"Developed in C# for use with the .NET environment. The download consists of a Visual Studio .NET project that includes all the source code for the library and samples plus tutorials to help get you started.
There is no licence or royalty fee to be paid at any time. You may include the source into your own projects which may then be used for personal or commercial use. The only restriction is the code cannot be resold as is, nor modified and sold as a user interface library for C#."
So IMHO it is most welcome,
Regards,
R.
|
|
|
|
|
IMO he should write an article and post it here if he wants us to see it.
But I got from the original that it was probably free, the original poster can be forgiven for the fact that so many paying products advertise on these forums.
Christian
The tragedy of cyberspace - that so much can travel so far, and yet mean so little.
"I'm thinking of getting married for companionship and so I have someone to cook and clean." - Martin Marvinski, 6/3/2002
|
|
|
|
|
Please, continue posting your ads... They at least usefull...
|
|
|
|
|
I want to create a file with others file data in like
FileName : C:\test.dat
FileNames:
- C:\ttt.dat + ttt.dat data
- C:\tt.dat + tt.dat data
...... etc
For the writing to the file i'm ok but my problem is when I want to open the C:\test.dat to read the data in and after I want to read each path stored in this file and read the data reliated to this path to recreate the file at the same place with the same data . Anybody know how make this
I used :
ArrayList (Path and File Data)
BinaryFormatter (Serialize all the data (C:\test.dat))
StreamReader ( to read the data of each files I added to C:\test.dat)
StreamWriter (to recreate each file with the reliated data)
my error is under the StreamWriter.
I used 2 foreach statement, one to read/rewrite the path and the other to read/rewrite the data.
like this
foreach(......)
{
.......
Create the StreamWriter with the reliated File Path
foreach(.....)
{
Write the data to the reliated file
.....
}
}
Thanks a lot in advance 
Jonathan Pouliot
|
|
|
|
|
I have a datagrid and I bind it to a datasource,It show the records ok,but after I insert a record to database I don't know how to update the datagrid to show the new record.
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
How are you inserting this new record ?.
Andres Manggini.
Buenos Aires - Argentina.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
