public int UpdateDataTable(string sql, System.Data.DataTable dt, System.Data.Odbc.OdbcDataAdapter sda)
{
int i = 0;
try
{
System.Data.Odbc.OdbcCommandBuilder builder = new System.Data.Odbc.OdbcCommandBuilder(sda);
sda.UpdateCommand = builder.GetUpdateCommand();
if (dt.GetChanges() != null)
{
i = sda.Update(dt);
dt = GetDataTable(sql);
}
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex.Message.ToString());
return(-1);
}
return(i);
}
private void button5_Click(object sender, EventArgs e)
{
try
{
dataSet11.Table.Rows.Clear();
dataSet11.Table.Columns.Clear();
odbcConnection1.ConnectionString = "Dsn=Excel Files;dbq=" + FexName + ";defaultdir=D:;driverid=1046;maxbuffersize=2048;pagetimeout=5";
odbcConnection1.Open();
odbcDataAdapter1 = new System.Data.Odbc.OdbcDataAdapter("SELECT* FROM" + " " + "[" + comboBox1.Text.ToString() + "$]", odbcConnection1.ConnectionString);
odbcDataAdapter1.Update(dataSet11.Table);
odbcDataAdapter1.Fill(dataSet11.Table);
dataGridView1.DataSource = dataSet11.Table;
odbcConnection1.Close();
}
catch (System.Data.Odbc.OdbcException)
{
MessageBox.Show("Выберите файл!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (System.InvalidOperationException)
{
MessageBox.Show("Выберите файл!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
