In this post we are going to create a connection with Microsoft SQL Server using .Net Framework and we would be using C# as our language. In order to perform SQL related tasks we need to use SqlClient under Data therefore we would add following line in the code window of each form where we will be performing SQL related tasks. using System.Data.SqlClient; Next we need to create a connection [...]
Free downloads for you
DB Invader : A Database Explorer A must to have tool for easy navigation between SQL Server database tables.
Design Pattern Concepts and Examples Easy to understand implementation, project solution for different design patterns.
Development Library Downloads
Your small contribution will help us code more free apps
As such there is nothing like renaming a file in C# but that functionality can certainly be achieved using Move function. Move : Basically move function accepts two arguments the file to be moved and new location where it needs to be moved along with the name of the file. Recently I was stucked in a task where I had to rename a list of approximately 2000 files in a [...]
I recently got stuck on a problem which required searching for a file recursively in a file and for each file found I had to perform operations on those file. File to be searched was alpha.text and it was to be searched in a folder whose complete address was stored in a variable dir which contained thousands of folder each containing many files and some folders as well and the [...]
How to retrieve file listing in .Net using C#? using System.IO; Use above namespace and follow one of the following commands suiting your need. String filename Directory.GetFiles(DirectoryLocation); Above statement returns all the files present in that directory. String dirname Directory.GetFiles(DirectoryLocation,SearchCriteria); Above statement returns all the files having above SearchCriteria in their name e.g. *.txt String dirname Directory.GetFiles(DirectoryLocation,SearchCriteria,SearchOption); Above statement returns all the files having above SearchCriteria and finds in the given [...]
What is JOIN in SQL? In a large application we have multiple tables in a database and they are interrelated with each other. When we are required to retrieve the data from those tables based on the relationship between them we use JOINs. So we can say Join is a method to retrieve rows from multiple tables satisfying some criteria (relationship). How many joins are there? There are basically two [...]
Class instances often encapsulate control over resources that are not managed by the runtime, such as window handles (HWND), database connections, and so on. Therefore, you should provide both an explicit and an implicit way to free those resources. Provide implicit control by implementing the protected Finalize Method on an object (destructor syntax in C# and the Managed Extensions for C++). The garbage collector calls this method at some point [...]
I just started preparing for my microsoft 70 480 scheduled next month. Today I read about jQuery Selectors. I also came to know that CSS selectors and jQuery selectors are more over same. I created a web page for the same. You can click on a selector and it will tell you what the selector does and give you a demo on screen. Simply click a button and look for [...]
Well the title may seem awkward. Why in the hell will I try Print Screen using C# when my keyboard has a key for that. But there may be many reason for the same. May be your Pr. Scr. key is not working because it is broken or it has been locked or your admin has blocked its usage. Well now we will be writing a code to achieve that [...]
Many a time we require to perform hash on data. The need can be because of reasons stated below but not limited to them only : We hash password and then save them in database so that it is not recoverable. We along with message provide a hash as well so that if the message is changed by someone the same can be traced. To create a digest we use [...]
Many a times an API call requires Byte array as argument when we have string to pass and it requires a conversion to be carried out. We can use static method GetBytes available in UTF8Encoding.UTF8 to get the array of bytes out of String we passed. Apart from UTF8Encoding you can also use UTF7Encoding and UTF32Encoding See following statements for an example : source.jsraw download1 2 3 UTF32Encoding.UTF32.GetBytes(inputString); UTF7Encoding.UTF7.GetBytes(inputString); UTF8Encoding.UTF8.GetBytes(inputString); Similarly we get byte array as [...]