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();
}
