Click here to Skip to main content
15,920,438 members
Home / Discussions / C#
   

C#

 
GeneralRe: Float Data Type Pin
Dan Neely8-Oct-07 4:53
Dan Neely8-Oct-07 4:53 
GeneralRe: Float Data Type Pin
Imran Adam8-Oct-07 4:57
Imran Adam8-Oct-07 4:57 
GeneralRe: Float Data Type Pin
Andrei Ungureanu8-Oct-07 4:58
Andrei Ungureanu8-Oct-07 4:58 
AnswerRe: Float Data Type Pin
Dan Neely8-Oct-07 4:52
Dan Neely8-Oct-07 4:52 
GeneralRe: Float Data Type Pin
Imran Adam8-Oct-07 4:58
Imran Adam8-Oct-07 4:58 
GeneralRe: Float Data Type Pin
Anthony Mushrow8-Oct-07 5:06
professionalAnthony Mushrow8-Oct-07 5:06 
AnswerRe: Float Data Type Pin
Pete O'Hanlon8-Oct-07 5:10
mvePete O'Hanlon8-Oct-07 5:10 
Questioncheck if record exist in a database C# sql 2005 Pin
Gazide8-Oct-07 4:02
Gazide8-Oct-07 4:02 
Hello

I am kind of new to C#(2.0) and MS SQL 2005, I am battling to write code (windows app C#), that can check Sql table to see if a record already exist. I have a table in sql called [Resources] with a PK called(Personnelno), i am trying to write a stored proc that can check if a [personnelno] exist in the table. if it exist it shouldn't save the record, else save it.

The application is three tiered [DAL, Business object and Presentation], can anyone please show me how do i call this stored proc through this layers until to the presentation layer. i'm trying to show messagebox to let user know that the record already exist, so he or she can change it.
Thanks.

N. Gazide
AnswerRe: check if record exist in a database C# sql 2005 Pin
Andrei Ungureanu8-Oct-07 4:18
Andrei Ungureanu8-Oct-07 4:18 
GeneralRe: check if record exist in a database C# sql 2005 Pin
ffowler8-Oct-07 5:49
ffowler8-Oct-07 5:49 
QuestionOnline Verification Pin
Nokoff8-Oct-07 4:00
Nokoff8-Oct-07 4:00 
AnswerRe: Online Verification Pin
il_masacratore8-Oct-07 4:16
il_masacratore8-Oct-07 4:16 
GeneralRe: Online Verification Pin
Nokoff8-Oct-07 4:34
Nokoff8-Oct-07 4:34 
GeneralRe: Online Verification Pin
Andrei Ungureanu8-Oct-07 4:42
Andrei Ungureanu8-Oct-07 4:42 
GeneralRe: Online Verification Pin
Nokoff8-Oct-07 4:54
Nokoff8-Oct-07 4:54 
GeneralRe: Online Verification Pin
Andrei Ungureanu8-Oct-07 5:02
Andrei Ungureanu8-Oct-07 5:02 
QuestionDataGridView Selections Pin
ffowler8-Oct-07 3:59
ffowler8-Oct-07 3:59 
AnswerRe: DataGridView Selections Pin
Anthony Mushrow8-Oct-07 4:05
professionalAnthony Mushrow8-Oct-07 4:05 
AnswerRe: DataGridView Selections Pin
Andrei Ungureanu8-Oct-07 4:07
Andrei Ungureanu8-Oct-07 4:07 
GeneralRe: DataGridView Selections Pin
ffowler8-Oct-07 4:15
ffowler8-Oct-07 4:15 
GeneralRe: DataGridView Selections Pin
Andrei Ungureanu8-Oct-07 4:22
Andrei Ungureanu8-Oct-07 4:22 
GeneralRe: DataGridView Selections Pin
ffowler8-Oct-07 5:39
ffowler8-Oct-07 5:39 
QuestionReflection Pin
karoitay8-Oct-07 3:49
karoitay8-Oct-07 3:49 
AnswerRe: Reflection Pin
Judah Gabriel Himango8-Oct-07 4:31
sponsorJudah Gabriel Himango8-Oct-07 4:31 
GeneralThanks Pin
karoitay8-Oct-07 5:29
karoitay8-Oct-07 5:29 

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.