how can i connect asp.net to mssql and show results in variables ?

how can i connect asp.net to mssql and show results in variables ?

 

Using Visual Studio - get your datasource setup, throw a datagrid in, and bind the datasource to the datagrid.

 

You can download Mysql connector from mysql site. Using this you can connect to MYSQL same as MSSQL.

 

i like to use the linq "datacontext"

[Table(Name = "MemberTable")]
public class MemberTable
{
}
var variable = new System.Data.Linq.DataContext(DBCONNECTION).GetTable<MemberTable>();