private void btn_KSSS_load_Click(object sender, EventArgs e) { if (listBox_KSSS.Text != "") { string Warning = ""; int rows; if (int.TryParse(tb_KSSS_lastRow.Text, out rows) && (Convert.ToInt32(tb_KSSS_lastRow.Text) - Convert.ToInt32(tb_KSSS_firstRow.Text)) >= 0) { //начать загрузку if (tb_KSSS_firstRow.Text == "") tb_KSSS_firstRow.Text = "1"; _range = "A" + (Convert.ToInt32(tb_KSSS_firstRow.Text) - 1).ToString() + ":D" + tb_KSSS_lastRow.Text; OdbcConnection cn = new OdbcConnection(); cn.ConnectionString = string.Format(@"Driver={{Microsoft Excel Driver (*.xls)}};DBQ={0};ReadOnly=0;", lbl_KSSS_dateload.Text); string strCom = "select * from [" + _sheet + "$" + _range + "]"; cn.Open(); OdbcCommand comm_mon = new OdbcCommand(strCom, cn); OdbcDataAdapter da = new OdbcDataAdapter(); da.SelectCommand = comm_mon; System.Data.DataTable dt = new System.Data.DataTable(); da.Fill(dt); DataSaver ds = new DataSaver(login_, password_); Warning = ds.SaveKSSStable(dt, Convert.ToInt32(tb_KSSS_firstRow.Text)); if (Warning != "") MessageBox.Show(Warning); } else { MessageBox.Show("Укажите корректное количество строк!"); } } KSSStoContragentFill(); }