insert s TXT file u tabelu
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
 |  |
 |
