Click here to Skip to main content
15,891,513 members
Home / Discussions / C#
   

C#

 
GeneralRe: What's the difference between Binary and Text file? Pin
Heath Stewart20-Jan-06 15:18
protectorHeath Stewart20-Jan-06 15:18 
GeneralRe: What's the difference between Binary and Text file? Pin
pmasknguyen21-Jan-06 6:29
pmasknguyen21-Jan-06 6:29 
GeneralRe: What's the difference between Binary and Text file? Pin
Dave Kreskowiak21-Jan-06 8:46
mveDave Kreskowiak21-Jan-06 8:46 
Questiondisplay a file to the browser using stream Pin
CodyGen20-Jan-06 11:27
CodyGen20-Jan-06 11:27 
AnswerRe: display a file to the browser using stream Pin
Heath Stewart20-Jan-06 12:12
protectorHeath Stewart20-Jan-06 12:12 
GeneralRe: display a file to the browser using stream Pin
CodyGen20-Jan-06 12:49
CodyGen20-Jan-06 12:49 
GeneralRe: display a file to the browser using stream Pin
Heath Stewart20-Jan-06 15:12
protectorHeath Stewart20-Jan-06 15:12 
QuestionBindingNavigator's AddNew vs. AutoIncrement DB fields Pin
mrlucmorin20-Jan-06 9:18
mrlucmorin20-Jan-06 9:18 
Hi,

First, I apologize if this is not the proper forum to ask my question.

I have a .NET 2.0 Windows Form App which uses BindingNavigator, BindingSource and DataSet.

The user can use the AddNew and Delete buttons of the BindingNavigator to Add/Delete records to the underlying typed DataSet.

In my particular case, I'm showing a Work Order record whose PK is also the table's IDENTITY field (MS SQL 2005).

My DataSet is setup with negative increment for this PK in order to avoid clashes.

So, when the user clicks the AddNew button, he sees a negative Work Order number showing up until the Update method is called on the TableAdapter. This could be a source of confusion in some users, so I'd like to proceed differently.

Should I handle this field manually, getting from the DB the highest Work Order number right when the record is created in the DataSet ? If so, how do I take care of concurrency in the case another user also creates a new Work Order before first user actualy commits his new record ?

Or should I simply call Update right away when the record is created ?

I assume this is a very common issue in DB programming.

Thank for any tips.


Luc Morin
AnswerRe: BindingNavigator's AddNew vs. AutoIncrement DB fields Pin
Guffa20-Jan-06 9:57
Guffa20-Jan-06 9:57 
GeneralRe: BindingNavigator's AddNew vs. AutoIncrement DB fields Pin
mrlucmorin20-Jan-06 10:45
mrlucmorin20-Jan-06 10:45 
GeneralRe: BindingNavigator's AddNew vs. AutoIncrement DB fields Pin
Dave Kreskowiak20-Jan-06 11:28
mveDave Kreskowiak20-Jan-06 11:28 
QuestionHow do I create dynamic content (has to be easy!) Pin
Roger Jane20-Jan-06 8:33
Roger Jane20-Jan-06 8:33 
AnswerRe: How do I create dynamic content (has to be easy!) Pin
Guffa20-Jan-06 9:07
Guffa20-Jan-06 9:07 
GeneralRe: How do I create dynamic content (has to be easy!) Pin
Roger Jane20-Jan-06 22:39
Roger Jane20-Jan-06 22:39 
QuestionHow to copy a picture??? Pin
CrazyDragon638420-Jan-06 8:26
CrazyDragon638420-Jan-06 8:26 
AnswerRe: How to copy a picture??? Pin
Wjousts20-Jan-06 9:26
Wjousts20-Jan-06 9:26 
AnswerRe: How to copy a picture??? Pin
CodyGen20-Jan-06 9:44
CodyGen20-Jan-06 9:44 
AnswerRe: How to copy a picture??? Pin
CrazyDragon638420-Jan-06 23:23
CrazyDragon638420-Jan-06 23:23 
GeneralRe: How to copy a picture??? Pin
CodyGen21-Jan-06 3:45
CodyGen21-Jan-06 3:45 
QuestionDataGridViewColumn DefaultCellStyle help Pin
Kasdoffe20-Jan-06 7:59
Kasdoffe20-Jan-06 7:59 
QuestionCalling Visual Basic .net class object in C# Pin
idreesbadshah20-Jan-06 7:33
idreesbadshah20-Jan-06 7:33 
AnswerRe: Calling Visual Basic .net class object in C# Pin
Dave Kreskowiak20-Jan-06 7:39
mveDave Kreskowiak20-Jan-06 7:39 
Questionwhy can't i start/stop separate threads inside of same block? Pin
WetRivrRat20-Jan-06 5:47
WetRivrRat20-Jan-06 5:47 
AnswerRe: why can't i start/stop separate threads inside of same block? Pin
Le centriste20-Jan-06 6:03
Le centriste20-Jan-06 6:03 
AnswerRe: why can't i start/stop separate threads inside of same block? Pin
Dave Kreskowiak20-Jan-06 6:25
mveDave Kreskowiak20-Jan-06 6:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.