P
Pierre
Hi,
I get a Dataset from a web service. I'de like to empty a table in my
local SQL Server and insert my Dataset (from the web service) into
this, now empty, table.
Something like (but working):
private void insertData(string type){
connectionString=ConfigurationSettings.AppSettings["DBConnectionString"];
SqlConnection _sqlcon = new SqlConnection(connectionString);
DataSet ds=new DataSet();
ds=this._webServ.GetPlayersCosts(type);
SqlDataAdapter da = new SqlDataAdapter(sql,this._sqlcon);
da.Fill(ds);
da.Update();
_sqlcon.Close();
}
Thank you for your answers, advices.
I get a Dataset from a web service. I'de like to empty a table in my
local SQL Server and insert my Dataset (from the web service) into
this, now empty, table.
Something like (but working):
private void insertData(string type){
connectionString=ConfigurationSettings.AppSettings["DBConnectionString"];
SqlConnection _sqlcon = new SqlConnection(connectionString);
DataSet ds=new DataSet();
ds=this._webServ.GetPlayersCosts(type);
SqlDataAdapter da = new SqlDataAdapter(sql,this._sqlcon);
da.Fill(ds);
da.Update();
_sqlcon.Close();
}
Thank you for your answers, advices.