Grazie
Ho fatto così:
ho importato: System.Data.OleDb; e System.Data, ma mi da questi errorini che non comprendo:codice:string tableName = "stat"; string ordine = "nome"; string str_conn = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]; OleDbConnection cnn = new OleDbConnection(str_conn) ; OleDbCommand cmd = new OleDbCommand ("SELECT * FROM " + tableName + " ORDER BY " + ordine + " ASC", cnn); cnn.Open(); OleDbDataReader dr=command.ExecuteReader(); string dati=string.Empty; while (dr.Next()) { dati=string.Format("{0}{1} - {2} ",dati, dr["nome"].ToString(),dr["data"].ToString()); } cnn.Close();
c:\inetpub\wwwroot\ppp\admin\dati.aspx.cs(69): The type or namespace name 'command' could not be found (are you missing a using directive or an assembly reference?)
(lo segnala la riga dopo la cnn.open)
c:\inetpub\wwwroot\ppp\admin\dati.aspx.cs(72): 'System.Data.OleDb.OleDbDataReader' does not contain a definition for 'Next'
(lo segnala su dr.next)


Rispondi quotando