private void открытьToolStripMenuItem_Click(object sender, EventArgs e) { if (openFileDialog1.ShowDialog() == DialogResult.OK) { if (DataSet1.Tables[0].Rows.Count > 0) { DataSet1.Clear(); } DataSet1.ReadXml(openFileDialog1.FileName); } }
/// <summary> /// Загрузить из файла /// </summary> /// <param name="fileName">Имя файла, из которого загружаем</param> private void OpenProject(string fileName) { try { fData.Clear(); // Грузим в DataSet fData.ReadXml(fileName); } catch (Exception ex) { MessageBox.Show("Ошибка в формате загружаемого файла.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void UpdateDataGrid() { OracleConnection connection = DBUtils.GetDBConnection(); connection.Open(); OracleCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM " + selectedState; cmd.ExecuteNonQuery(); OracleDataAdapter oda = new OracleDataAdapter(cmd); dataGridView1.DataSource = null; ds.Clear(); dataGridView1.Update(); dataGridView1.Refresh(); oda.Fill(ds, selectedState); dataGridView1.DataSource = ds.Tables[selectedState].DefaultView; }
protected void Page_Load(object sender, EventArgs e) { MyConn = new SqlConnection(strProvider); ds = new DataSet1(); ds.Clear(); ReportDoc = new ReportDocument(); MyConn.Open(); string strSql = "select * from View_3"; SqlDataAdapter daView_1 = new SqlDataAdapter(strSql, MyConn); //将适配器里面的信息填充到对应的Dataset里面的Table daView_1.Fill(ds, "View_3"); ReportDoc.Load(Server.MapPath("..\\StoreMen\\CrystalReport_Store_1.rpt")); ReportDoc.SetDatabaseLogon("sa", "lycms", @"192.168.0.236\\sqlExpress", "LYCMS"); ReportDoc.SetDataSource(ds.Tables["View_3"]); MyConn.Close(); CrystalReportViewer1.ReportSource = ReportDoc; CrystalReportViewer1.DataBind(); }
private void newConfig() { if (MessageBox.Show("Du hast nicht die aktuelle \"config.xml\"\r\n\r\nSoll eine neue angelegt werden? \r\n(die alte Datei wird gelöscht)", "Achtung", MessageBoxButtons.YesNo, MessageBoxIcon.Error) == System.Windows.Forms.DialogResult.No) { return; } ds.Clear(); System.IO.File.Delete("./config.xml"); DataSet1.DataTable1Row row; row = ds.DataTable1.NewDataTable1Row(); ds.DataTable1.AddDataTable1Row(row); DataSet1.DataTable2Row rowVersion; rowVersion = ds.DataTable2.NewDataTable2Row(); rowVersion.version = datasetVersion; ds.DataTable2.AddDataTable2Row(rowVersion); ds.WriteXml("./config.xml"); }
public ActionResult MndonReport() { DataSet1 ds = new DataSet1(); ds.Clear(); ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "SalOrderRpt.rpt")); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", "قائمة المندوبين.pdf")); } catch { throw; } }
//загрузка private void open(object sender, RoutedEventArgs e) { set.Clear(); list.Items.Clear(); loading = true; OpenFileDialog f = new OpenFileDialog { Filter = "xml|*.xml", AddExtension = true, DefaultExt = "xml" }; try { if (MessageBox.Show("Открытие новой базы данных приведет к закрытию всех окон кроме главного\nПродолжить?", "Открытие файла", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No) { loading = false; return; } f.ShowDialog(); Stream xml = File.OpenRead(f.FileName); set.ReadXml(xml); xml.Close(); foreach (Window w in OwnedWindows) { w.Close(); } } catch (Exception E) { MessageBox.Show(E.Message); } loading = false; W.refresh(); }
public virtual int Fill(DataSet1.DataDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
void Clear() { Console.WriteLine(new string('_', 20)); db.Clear(); }