Below are some code snippets / resources for T-SQL that I have personally benefited from. If you do not find one that you are looking for or want more, just
drop me a request or comment below, I’d try to address the request.
Example
Description
Download
Global Variables in C#
Different scenarios as your requirement and need
zip
Text to SQL Server
Read a text file and insert all records in SQL Server.
zip
Update combobox items according to selection of column-name in other combobox
zip
MySQL(SQL Server) To MsAccess
Copy table of Ms-Access from the data of the MySQL
zip
(Basic) Reading Ms-Excel spreadsheets
Reading data from Excel sheets using C#
zip
Updating Ms-Excel spreadsheets
Updating data of Excel sheets using C#
zip
Accessing .config file
The app.config can be used to access some setings (like conn string) anywhere in the project
zip
MySQL (SQL Server) database to CSV
Convert record set from MySQL query to csv file
zip
String Delimiter
Various illustrations in a single project, demonstrating ways to use the String.Split() function
zip
Date – Times
Gets the beginning and ending dates of
This Week
Last Week
This Month
Last Month
Last 6 Months
This Year
Last 3 Years
zip
Update/Delete CSV
Here is the work around for Updating / Deleting records from CSV, which usually is just a file IO operation otherwise
zip
json
json in C# using JSON .NET & LINQ
zip
json serialization
serialization/de-serialization of json
zip
Stateful iterations
By using yield keyword, difference b/w IEnumerable and IEnumerator
zip
Take Our Poll
Like this: Like Loading...