How to load/migrate data from .CSV file to mySQL table?

---

• How to load/migrate data from .CSV file to mySQL table?
• How to add background music in HTML
• How to write a stored procedure in sql server
• Restriction and Partition Operators in Linq.
• Check all functionality using Javascript in Gridview
• Employee System Application using ASP.net MVC
• Clustered and Non clustered index in sql server 2008
• Web application security for ASP .NET

How to load/migrate data from .CSV file to mySQL table? Posted: 20 Aug 2012 02:51 AM PDT Data migration means migrating data from one place to another place. Generally, mySQL queries are used to retrive ,add , update , delete data. We have used mySQL query for migration purpose. I hope this will be useful to all.

How to add background music in HTML Posted: 20 Aug 2012 03:10 AM PDT In this article, I will explain how to add background music in HTML File with the help of embed tag and repeatation of music at the background. It is used to play the music automatically by setting autostart attribute to true of embed tag. Play button is hidden using hidden attribute to hide the control so that the music control can be hidden from the user. It enables to repeat the music by setting the loop value to true.

How to write a stored procedure in sql server Posted: 03 Sep 2012 12:12 AM PDT A Stored procedure is nothing but a group of sql statement that performs a specific task under single Execution plan. If you want to do a same task again and again than we can create a Stored procedure.Once we create a procedure then we can reuse the code by Execute Statement.

Restriction and Partition Operators in Linq. Posted: 03 Sep 2012 05:10 AM PDT Language-Integrated Query (LINQ) are a set of features introduced in Visual Studio 2008 that extends powerful query capabilities to the language syntax of C# which have many operators. We will look through the restriction and Partition operators of LINQ.

Check all functionality using Javascript in Gridview Posted: 03 Sep 2012 06:05 AM PDT This is a small article that helps you to implement popular functionality of check all, it helps you to put checkbox in gridview view header and on click of that checkbox all check boxes will checked at once

Employee System Application using ASP.net MVC Posted: 04 Sep 2012 12:23 PM PDT Employee System is basic application build from the ASP.net MVC. It's a starting point to know what you can build from ASP.net MVC with cleaner code.I am using the Static List data for the simplicity and to know how to use LINQ in different Scenario.

Clustered and Non clustered index in sql server 2008 Posted: 05 Sep 2012 01:35 AM PDT Index is a database object used to minimize the number of data comparisons. Index can be created on one or more columns in a table. There are two types of indexes in sql server. They are clustered and Nonclustered Index. Clustered index is an index that stores the actual data but Non Clustered index is a pointer to the data.

Web application security for ASP .NET Posted: 05 Sep 2012 07:48 AM PDT Web applications should be very secured. In this article we shall discuss about the security options available in ASP .NET. Security of a web application maintained using Authentication and Authorization function. Authorization checks for the user credentials like user name and passwords and the later one decides whether grant or deny access to specified resources for authenticated users.

You are subscribed to email updates from .NET Articles, Tutorials and Resources To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610