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);
}
protected void ExecuteSQL(string sSQL)
{
SqlCommand cmd = new SqlCommand(sSQL, conn);
try
{
conn.Close();
conn.Open();
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}