Click here to Skip to main content
15,894,896 members
Home / Discussions / C#
   

C#

 
AnswerRe: Beginner C# homework project - stuck Pin
OriginalGriff26-Jan-10 8:20
mveOriginalGriff26-Jan-10 8:20 
GeneralRe: Beginner C# homework project - stuck Pin
tinnpot26-Jan-10 10:12
tinnpot26-Jan-10 10:12 
GeneralRe: Beginner C# homework project - stuck Pin
Ennis Ray Lynch, Jr.26-Jan-10 10:29
Ennis Ray Lynch, Jr.26-Jan-10 10:29 
GeneralRe: Beginner C# homework project - stuck Pin
Luc Pattyn26-Jan-10 13:51
sitebuilderLuc Pattyn26-Jan-10 13:51 
QuestionHow to display image in crystal report? Pin
mahdi136726-Jan-10 7:27
mahdi136726-Jan-10 7:27 
QuestionTroubles with a DPI Aware application Pin
Antonino Porcino26-Jan-10 6:50
Antonino Porcino26-Jan-10 6:50 
AnswerRe: Troubles with a DPI Aware application Pin
Ciumac Sergiu26-Jan-10 7:10
Ciumac Sergiu26-Jan-10 7:10 
QuestionBIZTALK questions: do not import duplicate data coming from csv file to sql server table Pin
challa_praveena26-Jan-10 6:46
challa_praveena26-Jan-10 6:46 
Hi all,

I am using biztalk 2009 and sql server 2008, vs2008.

any information is greatly appreciated - I am not able to find any tutorials or articles on how and where to start

I need help on figuring out how to do the following. I have csv file which I am able to map to sql server tables using updategrams and I am successful in importing the data to respective fields in multiple tables. (If the data in csv file is clean and straightforward then everything is smooth - but the system I am developing is a bit complex)

now I need to do validation on the data that is coming in

1) I need to retreive the csv file name into a attribute in flat file schema and retreive a part of the filename and parse it into the sql server table field.

2) I need to check if the data coming from csv file already exists (if yes then dont insert that Customer record and only update that customer's information)

3) validation for datatypes , length,spaces, -this all I cannot do in the map through functoids (In the map I can only check for schema mapping - if the schema matches or not -how can i do this)

4) where and how to do data validation in biztalk - so that correct data is imported to sql server (How to seperate schema validation from data validation in biztalk)

thanks
AnswerRe: BIZTALK questions: do not import duplicate data coming from csv file to sql server table Pin
PIEBALDconsult26-Jan-10 7:11
mvePIEBALDconsult26-Jan-10 7:11 
Questionsending output to a multiline text box. Pin
CodeRed300026-Jan-10 5:11
CodeRed300026-Jan-10 5:11 
AnswerRe: sending output to a multiline text box. Pin
Rob Philpott26-Jan-10 5:20
Rob Philpott26-Jan-10 5:20 
AnswerRe: sending output to a multiline text box. Pin
OriginalGriff26-Jan-10 5:26
mveOriginalGriff26-Jan-10 5:26 
AnswerRe: sending output to a multiline text box. Pin
Luc Pattyn26-Jan-10 6:15
sitebuilderLuc Pattyn26-Jan-10 6:15 
Questionvery fast image conversion from jpg to bmp in c# Pin
Mohammad Mahdipour26-Jan-10 3:32
Mohammad Mahdipour26-Jan-10 3:32 
AnswerRe: very fast image conversion from jpg to bmp in c# Pin
Natza Mitzi26-Jan-10 3:46
Natza Mitzi26-Jan-10 3:46 
GeneralRe: very fast image conversion from jpg to bmp in c# Pin
harold aptroot26-Jan-10 3:50
harold aptroot26-Jan-10 3:50 
GeneralRe: very fast image conversion from jpg to bmp in c# Pin
Natza Mitzi26-Jan-10 4:58
Natza Mitzi26-Jan-10 4:58 
GeneralRe: very fast image conversion from jpg to bmp in c# Pin
harold aptroot26-Jan-10 5:30
harold aptroot26-Jan-10 5:30 
GeneralRe: very fast image conversion from jpg to bmp in c# Pin
Natza Mitzi26-Jan-10 8:13
Natza Mitzi26-Jan-10 8:13 
GeneralRe: very fast image conversion from jpg to bmp in c# Pin
harold aptroot26-Jan-10 8:19
harold aptroot26-Jan-10 8:19 
AnswerRe: very fast image conversion from jpg to bmp in c# Pin
Luc Pattyn26-Jan-10 4:05
sitebuilderLuc Pattyn26-Jan-10 4:05 
GeneralRe: very fast image conversion from jpg to bmp in c# Pin
Mohammad Mahdipour26-Jan-10 18:31
Mohammad Mahdipour26-Jan-10 18:31 
GeneralRe: very fast image conversion from jpg to bmp in c# Pin
Luc Pattyn27-Jan-10 12:47
sitebuilderLuc Pattyn27-Jan-10 12:47 
AnswerRe: very fast image conversion from jpg to bmp in c# [modified] Pin
The Zetta26-Jan-10 6:07
The Zetta26-Jan-10 6:07 
GeneralRe: very fast image conversion from jpg to bmp in c# Pin
Ennis Ray Lynch, Jr.26-Jan-10 10:48
Ennis Ray Lynch, Jr.26-Jan-10 10:48 

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.