Lokesh Chadha's Blog For Developers

HTML Markup Below is the HTML Markup of the page, where I have an ASP.Net control  FileUpload  to upload files, a  Button control to trigger file uploads and an ASP.Net GridView control to display the files from folder. < asp : FileUpload   ID ="FileUpload1"   runat ="server"   /> < asp : Button   ID ="btnUpload"   runat ="server"   Text ="Upload"   OnClick ="UploadFile"   /> < hr   /> < asp : GridView   ID ="GridView1"   runat ="server"   AutoGenerateColumns ="false"   EmptyDataText   =   "No files uploaded">      < Columns >          < asp : BoundField   DataField ="Text"   HeaderText ="File Name"   />          < asp : TemplateField >              < ItemTemplate >                  < asp : LinkButton   ID ="lnkDownload"   Text   =   "Download"   CommandArgument   =   ' &

website we should surf daily http://www.awwwards.com/ http://www.thefwa.com http://www.howdesign.com/design-creativity/top-10-sites-for-designers/ Creative websites http://benthebodyguard.com/ http://janploch.de/ http://fendilife.fendi.com/#/home unfold.no/ http://www.egopop.net/ http://vlog.it/ http://whyinteractive.com/showreel/ http://jessandruss.us/

CSV stands for Comma Separated Values, sometimes also called Comma Delimited Values. Create  TestTable USE  TestData GO CREATE TABLE  CSVTest ( ID  INT , FirstName   VARCHAR ( 40 ), LastName   VARCHAR ( 40 ), BirthDate  SMALLDATETIME ) GO Create CSV file in drive C: with name sweetest. text with the following content. The location of the file is C:\csvtest.txt 1 , James , Smith , 19750101 2 , Meggie , Smith , 19790122 3 , Robert , Smith , 20071101 4 , Alex , Smith , 20040202 Now run following script to load all the data from CSV to database table. If there is any error in any row it will be not inserted but other rows will be inserted. BULK INSERT  CSVTest FROM  'c:\csvtest.txt' WITH ( FIELDTERMINATOR  =  ',' , ROWTERMINATOR  =  '\n' ) GO --Check the content of the table. SELECT  * FROM  CSVTest GO --Drop the table to clean up  database . DROP TABLE  CSVTest GO Refrence from:  http://blog.sqlauthority.com/2008/02/06/sql-server-import-

I have so exciting news! Microsoft has released  SQL Server 2012  RTM (Code name  “Denali” ) on March 6 for manufacturing and download the evaluation edition from  http://www.microsoft.com/download/en/details.aspx?id=29066 As my laptop is 32-bit system, so I have downloaded the following files from the above link. Likewise, you can download the files for 64-bit system(x64) too. :) Finally, check your system requirements from the same link. ENU\x86\SQLFULL_x86_ENU_Core.box ENU\x86\SQLFULL_x86_ENU_Install.exe ENU\x86\SQLFULL_x86_ENU_Lang.box After downloading the above files, your system will look like below: Double click the  “SQLFULL_x86_ENU_Install.exe” , it will extract the required files for installation in the “SQLFULL_x86_ENU”  folder as shown below: Click the  “SQLFULL_x86_ENU”  folder and double click  “SETUP”  application. Checking your system requirements for installation. When you see  “SQL Server Installation Center”  screen, it means that your system configuration is perfe