[ ZOSTROG @ 10.05.2006. 12:19 ] @
| pozdrav svima !! i molio bih za pomoc na ekranu sam upisivao i ime txt fila i ime TABELE i sa metodom split delio txt i upisivao insert.. deo koda koji je bitan za ovo je int brojac = 0; System.Text.StringBuilder values1 = new System.Text.StringBuilder(); System.Text.StringBuilder headers = new System.Text.StringBuilder(); FileInfo f = new FileInfo(fileName); using (StreamReader sr = f.OpenText() ) { string line; while ( ( line = sr.ReadLine() ) != null ) { string[] values = line.Split('#'); foreach(string s in values) { system.Text.StringBuilder sb1 = new System.Text.StringBuilder(); sb1.Append(s); opisTab opTab = new opisTab(); opTab = (opisTab)opisTab1[brojac]; if (brojac == 0) { headers.Append("("); values1.Append("("); } headers.Append(opTab.colName.ToString() + ","); bool numericCheck = IsNumeric(s); if (numericCheck==true) { values1.Append(sb1.ToString() + ","); } else { values1.Append("'" + sb1.ToString() + "'" + ","); } brojac++; } headers.Remove(headers.Length - 1, 1); values1.Remove(values1.Length - 1, 1); values1.Append(")"); headers.Append(")"); dml = new System.Text.StringBuilder("INSERT INTO " + tableName + headers + " VALUES " + values1); string proba3 = dml.ToString(); oleDbCommand1 = new OleDbCommand(dml.ToString()); oleDbConnection1.Open(); oleDbCommand1.ExecuteNonQuery(); oleDbConnection1.Close(); i puca mi na oleDbCommand1.ExecuteNonQuery(); da LI MOZE NEKO DA MI POMOGNE |