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();
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5