by Evgelen
22. March 2010 06:18
In order to create SQL Database Schema for Microsoft membership provider you need to Open Visual Studio Command Prompt and type aspnet_regsql command (as you can see below)

by Evgelen
21. January 2010 20:22
- Click "Start" and "Run" or Windows Key + R
- Type cmd
- Then Go to the root folder of C:\ drive
- Type osql -L
- The system return the names of all instances installed on your server

by Evgelen
12. December 2009 21:55
SELECT * FROM TableName WHERE len(ColumnName) > 100
by Evgelen
4. December 2009 20:03
ASP.NET C# Bind DropDownList Control from SQL Datasource
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
private void Page_Load(object sender, EventArgs e)
{
DropDownListBind();
}
public void DropDownListBind()
{
var conn = new SqlConnection
{
ConnectionString =
ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()
};
var cmd = new SqlCommand("SELECT * FROM TableName", conn);
cmd.Connection.Open();
var dropDownListsValues = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DropDownListControl.DataSource = dropDownListsValues;
DropDownListControl.DataValueField = "ControlId";
DropDownListControl.DataTextField = "ControlData";
DropDownListControl.DataBind();
cmd.Connection.Close();
cmd.Connection.Dispose();
}
private void Page_Load(object sender, EventArgs e)
{
DropDownListBind();
}
public void DropDownListBind()
{
var connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
using (var conn = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("SELECT * FROM TableName", conn);
cmd.Connection.Open();
var dropDownListsValues = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DropDownListControl.DataSource = dropDownListsValues;
DropDownListControl.DataValueField = "ControlId";
DropDownListControl.DataTextField = "ControlData";
DropDownListControl.DataBind();
}
}
by Evgelen
13. November 2009 22:40
sp_attach_db @dbName = 'DataBase',
@filename1 = 'C:\folder\Database.mdf',
@filename2 ='C:\folder\Database_log.ldf'