Torna al Thread
SqlConnection cn = new SqlConnection("Data Source=address,port;Network Library=DBMSSOCN;Initial Catalog=TUODB;User ID=TuoUsername;Password=TuaPassword;");
cn.Open();
string query = "SELECT * FROM TABELLA WHERE ID = ....";
SqlCommand cmd = new SqlCommand(query,cn);
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
DataTable myData = new DataTable();
da.SelectCommand = cmd;
da.Fill(ds);
Dictionary<string, string> dic = new Dictionary<string, string>();
for (int i = 0; i <= ds.Tables[0].Columns.Count - 1; i++)
{
dic.Add(ds.Tables[0].Columns[i].ColumnName, ds.Tables[0].Rows[0][i].ToString());
}
cn.Close();