TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Manoj Bisht
NA
145
0
Store a DataTable from ASP.NET into Sql Server
Feb 22 2010 7:23 AM
Hello Friends,
I've a GridView in which i'm inserting lots of records it may be 100 or 500. And holding those values in a DataTable and there is a
Save
button after clicking on that button those records of DataTable being saved in Sql Server 2005. Currently i'm taking that DataTable values in a variable and serperating them with
Comma(,)
. And at sql side i'm serperating them with comma and saving the records in Table in Sql Server. And that's working fine. But is it any other way to save or send the whole datatable in a single turn not concating in a string variable and save them at sql server.
Reply
Answers (
3
)
search record with multiple fields and display in grid
Ajax Control Tool Kit(3.0)& asp.net(3.5) Problrm Getting Exception