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
Arvind Chourasiya
NA
933
134.3k
How to insert multiple records at once in SQLite
Jul 21 2016 2:26 AM
Hii
i want to insert multiple record in my SQLite table at a time. See this line of code
var items = await MgoApi.Get("Assignment/GetAssigstudents", param);
in this line i'm getting multiple record in items from API, now how can i insert items all record in local database table.
i'm using xamarin android, SQLite database with SQLiteAsyncConnection in VS2013
how i have tried see
foreach(var _items in items)
{
obj.Amount = _items.Amount;
obj.Purpose_Of_Spending = _items.Purpose_Of_Spending;
obj.Type = _items.Type;
obj.Subject=_items.Subject;
obj.Rank=_items.Rank
var RowAffted= Repository_obj.Insert(obj);
}
is this way is correct or not, if you people have more efficient way can suggest me. Thank You
Reply
Answers (
2
)
How to auto increment integer + variable in c#
add one more row on windows form when click on add button c#