[ bigguy @ 20.06.2009. 15:30 ] @
Kako da prevazidjem ovu gresku "Invalid attempt to call Read when reader is closed.", koja mi se pojavljuje kada se SqlDataReader dr ucitava u while petlji? Code: public void fillTable(SqlDataReader dr, string tabela, string kolona) { while (dr.Read()) { int a = dr.FieldCount; for (int i = 0; i < a; i++) { Dodavanje(tabela, kolona, dr.GetString(i)); } } conn.Close(); } public void Dodavanje(string table, string kolona, string promenjiva) { string sSQL = "INSERT INTO " + table + " (" + kolona + ") VALUES ('" + promenjiva + "')"; ExecuteSQL(sSQL); } Code: protected void ExecuteSQL(string sSQL) { SqlCommand cmd = new SqlCommand(sSQL, conn); try { conn.Close(); conn.Open(); cmd.ExecuteNonQuery(); } finally { conn.Close(); } } |