What is proper way to send Conditional batch data to SQL server

See more:

C#

web

I have to send batch data to server by checking data so i wants to know
Which is proper way to send Conditional batch data in sql server
1. Comma separated values
2. UDT
3. One by one
Using 1 is i looks easy but is it professional
Using UDT I dont know much about it
Using one by one isnot secure as if any data fails then transaction how to achieve
So please tell me which is proper way ?