.Net, ADO.NET, ASP.NET, C#, DB Connection Example, Example Connection, Excel, Excel 2003, Excel 2007, JavaScript, JQuery, Programming, Regular Expressions, Web Development

JQuery with ASP.NET: Save Copy / Paste Excel Data to a Database Table

Have you ever wanted to help your users move data from Excel to your Web application? In this article I will give an example in ASP.NET that takes copied Excel spreadsheet rows from the user’s clipboard and saves the information to a SQL Server database table.

Since ASP.NET runs at the server level, you will need to use JavaScript/JQuery to get the Excel information from the user’s clipboard. You will need to use a different command to get the information depending on the user’s browser. In this example, I code specifically for Internet Explorer, but this is just since I am giving an example. In a real-world application you would code for all of the major browsers. Continue reading “JQuery with ASP.NET: Save Copy / Paste Excel Data to a Database Table”

.Net, ADO.NET, ASP.NET, C#, DataSet, DataTable, Example Connection, GridView, Programming, Visual Studio 2010, Web Development, WebForms

C# Example of a GridView Tied to a SQLDataSource

GridView Example
GridView Example

So what’s the simplest way to build a Web-based interface for a basic database table? In this article I’ll provide a fully working example with a minimum of code.

This is a useful feature to be able to put together, especially when you are catering to power users who should be able to help maintain their own data without needing to call you each time. Continue reading “C# Example of a GridView Tied to a SQLDataSource”

.Net, ADO.NET, ASP.NET, C#, Database, DataSet, DB Connection Example, Example Connection, Programming, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 7, VB.NET

.NET – Write A File to Disk from your Database


In this example I will review and give examples in C# and VB.NET how to get and save a file stored in an Image datatype in a SQL Server table.

Here is a link to a list of other articles I have written about using .NET with SQL Server. Continue reading “.NET – Write A File to Disk from your Database”