private void read(string filename)
{
DataSet dstracking = new DataSet("collistatus");
dstracking.ReadXml(filename);
}

DataTable importTable = new DataTable();
importTable.ReadXmlSchema(Path.Combine(filepath, "ImportTable.xsd"));

importTable.ReadXml(Path.Combine(filepath, "ImportTable.xml"));

public void do_job()
{
try
{
string path = "\\\\standbyserver/importPARTNER9113/";
DirectoryInfo di = new DirectoryInfo(path);
FileInfo[] rgFiles = di.GetFiles("*.xml";);
foreach (FileInfo fi in rgFiles)
{
read(fi.FullName.ToString());
//File.Delete(fi.FullName.ToString());
}
}
catch (Exception errormessage)
{
MessageBox.Show(errormessage.Message.ToString());
}
}

private void read(string filename)
{
DataSet ds = new DataSet();
ds.ReadXml(filename);

for(int i = 0; i≤ds.Tables["collistatus"].Rows.Count-1; i++)
{
string[] help = new string[8];
ds.Tables["collistatus"].Rows[i].ItemArray.CopyTo(help, 0);[/i]

ms.cm.CommandText = @"insert into ws_temp_tracking
(coll_nr,stat_date,stat_time,stat_code,stat_text,ex_orderid)
values (@collnr,@statdate,@stattime,@statcode,@stattext,@exorderid);";
ms.cm.Parameters.Clear();
ms.cm.Parameters.AddWithValue("collnr", help[0]);
ms.cm.Parameters.AddWithValue("statdate", help[1]);
ms.cm.Parameters.AddWithValue("stattime", help[2]);
ms.cm.Parameters.AddWithValue("statcode", help[3]);
ms.cm.Parameters.AddWithValue("stattext", help[4]);
ms.cm.Parameters.AddWithValue("exorderid", help[5]);
ms.open();
try
{
ms.cm.ExecuteNonQuery();
}
finally
{
ms.close();
}
}