Example Connection – Page 2

.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

2013-10-302013-11-22 Justin Cooney

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

2013-09-272013-11-22 Justin Cooney

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” →