Bulk Inser in Sql from CSV

/* CSV to SQL */
create table UserTable(
UserName varchar(50),
UserPassword varchar(50)
)


BULK
INSERT UserTable
FROM 'D:\Usertable.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
___________

[ Using Procedure ]
In Code behind
-------------

Dbconn.connection();

cmd = new SqlCommand("bulkinsert",Dbconn.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Path",SqlDbType.VarChar,50));
cmd.Parameters["@Path"].Value = FileUpload2.PostedFile.FileName;
cmd.ExecuteNonQuery();
----

Procedure
---------
CREATE Procedure [dbo].[bulkinsert]
@Path Varchar(50)
As
Declare @Str Varchar(2000)
Begin
Set @Str=''BULK INSERT waybill_register FROM ''
Set @Str=@Str+''''''''
Set @Str=@Str+@Path
Set @Str=@Str+''''''''
Set @Str=@Str+'' WITH (FIELDTERMINATOR = '''','''',ROWTERMINATOR = ''''\n'''')''
Exec(@Str)
End

Important Link

/* Free Text Box */

http://jhtmlarea.codeplex.com/

http://jhtmlarea.codeplex.com/releases/view/30759

_____________

/* Jquery Web control for asp.net */

http://dj.codeplex.com/

_____________
/* Jquery Chat */

http://aspnetjquerychat.codeplex.com/

__________

/* Jquery toolkit */

http://jquerytoolkit.codeplex.com/
_________________

/* Char using jquery */

http://www.codeproject.com/KB/webforms/ms-chart-with-jquery.aspx
__________

/* Jquery Image galery */

http://notesforgallery.codeplex.com/
_____________

/* Important DLL free Download */

http://dll.downloadatoz.com/

_______________

/* Telleric */

http://www.telerik.com/community/forums/aspnet/splitter/position-of-sliding-window-when-page-scrolls.aspx

___________

/* Image Slider */

http://mediaeventservices.com/blog/2007/11/15/ajax-image-gallery-powered-by-slideflow-like-cover-flow/

_________


/* Important Jquery */

http://docs.jquery.com/Tutorials:Live_Examples_of_jQuery

___________
/* Jquery for drag drop */

http://code.google.com/p/jsmarty/source/browse/trunk/samples/shared/scripts/jquery-ui-personalized-1.6rc2.js?r=444
_________

/* nicer swiping / ajax examples */

http://leodruker.theorydesign.ca/about/#2


http://visuallightbox.com/lightbox-mac-style-demo.html

http://nooshu.com/recreate-iphone-swipe-effect-using-jquery/
http://nooshu.com/explore/jquery-iphone-animation/
________