Loading
Topic
SQL Connection
7 posts about SQL Connection by 7 contributors.
Know SQL Connection? Share what you know with developers who are learning it.
+ Follow SQL ConnectionBe the first to follow this
- Articles
- 7
- Contributors
- 7
Articles about SQL Connection
- Article · SQL
Part IV - .NET 5+ SQL Connections: Why Encrypt=True Is Now the Default
Learn about the .NET 5+ default Encrypt=True setting for SQL connections and its impact on your applications. This article explains why Microsoft made this security enhancement, how to handle self-signed certificates in development, and best practices for production environments. Ensure secure data transfer and avoid connection errors by understanding and implementing the correct connection string configurations. Discover how to configure your connection strings for optimal security and compatibility.
- Article · Windows Forms
Real Time Use Of Context Menu Strip In Windows Form Application
Learn how to use ContextMenuStrip in a Windows Forms application to delete records from a DataGridView. This tutorial covers setting up a context menu, handling right-click events, and executing a delete operation with SQL.
- Article · ASP.NET
Export Data Table To Excel in ASP.Net MVC 4
This article demonstrates exporting a Data Table to Excel in ASP.NET MVC. It covers creating a new project, adding a ClosedXML reference, and setting up models and controllers. It details fetching data from SQL Server, using ClosedXML to generate Excel files, and handling file download in the MVC application.
- Article · SQL Server
Connection with SQL and queries.
Explore the essentials of connecting to SQL databases and executing efficient queries. Learn about various SQL commands, database management techniques, query optimization strategies, and best practices for data retrieval.
- Article · Web Development
Creating SQL Server Database Dynamically in .NET Using SQL DMO
It is a sample ASP.NET and Visual Studio 2005 application for creating a SQL Server database at runtime. I have used SQL-DMO dll. This article will show you how to create a database in SQL Server 2005 and 2000.
- Article · ADO.NET in VB.NET
Working with Data-bounds controls
Working with data-bound controls in VS.NET IDE is a fun. You just set couple of properties and you're all set to view, add, and update data using these data-bound controls. Some of these common controls are DataGrid, DataCombo, and ListBox.
- Article · ADO.NET
Storing Images into a Database
In order to provide your application with cool pictures you can employ two techniques (at least). One of them is that you can save the pictures in a folder and store the path to each one in a database or configuration file. The other one is to store the entire file into a database, along with its file name.
