Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

c# - Import DataSet into SQL Server 2008 Express -


i have large dataset containing 160.000 records. if loop trough dataset , import every record, can take 20 minutes before complete dataset imported sql server.

isn't there faster way importing dataset @ once in database?

the dataset created file process user provides, have 1 table called lets "importtable" containing 14 columns. columns correspond columns in dataset.

i use visual studio 2010 professional c#.

thanks in advance!

you should take close @ sqlbulkcopy class.

it's c# component (no external app), takes dataset or datatable input, , copies sql server in bulk fashion. should faster doing row-by-agonizing-row (rbar) insert operation...

better yet: don't need import entire data set memory - can define sqldatareader on base data, , pass sqlbulkcopy read sqldatareader , bulk insert sql server.


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -