How to insert a list of values into SQL Server 2008 from asp.net using C# -


i want store multiple rows @ once in sql server. have taken 1 list datatype storing multiple row content. want pass list directly sql server. don't want use loop insert value 1 one. how can pass whole list parameter stored procedure?

you can use comma-separated string, , parse on sql side. fastest solution, not have open connection wile doing loop on c# side.


Comments

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

asp.net mvc - breakpoint on javascript in CSHTML? -