How to select random row from a data table
1: Select a random row with Microsoft SQL Server: ...
()
How to Create a Custom Membership Provider from Microsoft
Here is a video tutorial from Microsoft about "How Do I: Create a Custome Membership Provider" , but you need to install SilverLight witch is also downloaded from Microsoft. SilverLight is a ...
()
How to get CSV file using SQL Server management studio
I had a task to output or generate CSV file using SQL Sever management Studio. ...
()
The text data type cannot be selected as DISTINCT because it is not comparable
When I tried to select a table which includes a text type field using distinct. I got these error: ...
()
How to Convert Generic List To DataTable using C#
I have a task to need to get a DataTable, however, all existing objects are List, I need convert some of those lists to DataTables. Before I wrote my own code to do it. I searched internet and got 2 p ...
()
How to copy a table in SQL Server correctly ?
There is chance that we might need to make a copy of table in SQL Server. Most of time, maybe we can use the following script: ...
()
Sql Server Must declare the scalar variable
When one of asp.net project was in develop stage, we always got the exception 'Must declare the scalar variable "@variableName" ' ...
()
Reset Identity column in SQL Server
For identity column in SQL Server, we have a command to easy to control it! ...
()
ASP.NET Could not find a part of path
We have a asp.net 2.0 / 3.5 project, it worked on our development site, but when we put it to product site, all functions about file read such as used Server.MapPath() method could not work and got th ...
()
Optimizing C#
I got part of content from vcskicks.com ...
()