Insert multiple rows into SQL Server 2005 using a stored procedure

I am working on a ASP.NET MVC / C# application.

I have a list of objects lets say List<Student> students that were imported from a CSV.

I want to insert them into a SQL Server 2005 database using stored procedures and transactions. In case a row fails it should rollback.

Any suggestions?