Lokesh Chadha's Blog For Developers

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

If you’ve set a gridviews AllowPaging attribute to “true”, you’ll notice the following error; The GridView fired event PageIndexChanging which wasn’t handled To setup paging with Gridviews, you also need to set the page index property to the new page that you wish to view. This is extremely easy to do. See below for a code example written for aspx page and Code behind page. At aspx page <asp:GridView ID="GridView1" runat="server" Width="800px" AllowPaging="True" PageSize="100" OnPageIndexChanging="gvList_PageIndexChanging"> At Code behind page protected void gvList_PageIndexChanging(object sender, GridViewPageEventArgs e)     {                          bindGrid(); // your code to bind the grid view eg sql connection                  GridView1   .PageIndex = e.NewPageIndex;                  GridView1.DataBind();    }