static void Main(string[] args)
{
// Создание Таблицы DataTable с именем "Cars"
DataTable tablCars = new DataTable("Cars");
// Создание столбцов
DataColumn carsId = new DataColumn("Id", typeof(int));
DataColumn carsName = new DataColumn("Name", typeof(string));
DataColumn carsCountry = new DataColumn("Country", typeof(string));
DataColumn carsPrice = new DataColumn("Price", typeof(double));
tablCars.Columns.AddRange(new DataColumn[] { carsId, carsName, carsCountry, carsPrice });
// Создание строки с данными
DataRow newRow1 = tablCars.NewRow();
newRow1["Name"] = "BMW"; newRow1["Country"] = "Germany";
newRow1["Price"] = "50000";
tablCars.Rows.Add(newRow1);
DataRow newRow2 = tablCars.NewRow();
newRow2["Name"] = "Audi"; newRow2["Country"] = "Germany";
newRow2["Price"] = "37500";
tablCars.Rows.Add(newRow2);
// Сохранить ТАБЛИЦЫ tablCars в виде XML
tablCars.WriteXml("Cars.xml");
tablCars.WriteXmlSchema("CarsSchema.xsd");
// Создание Таблицы DataTable с именем "Drivers"
DataTable tablDrivers = new DataTable("Drivers");
// Создание столбцов
DataColumn drId = new DataColumn("Id", typeof(int));
DataColumn drName = new DataColumn("Name", typeof(string));
DataColumn drAge = new DataColumn("Age", typeof(string));
tablDrivers.Columns.AddRange(new DataColumn[] { drId, drName, drAge });
// Создание строки с данными
DataRow newRow3 = tablDrivers.NewRow();
newRow3["Name"] = "Ivan"; newRow3["Age"] = "33";
tablDrivers.Rows.Add(newRow3);
DataSet dataSet = new DataSet("AutoPark");
dataSet.Tables.AddRange(new DataTable[] { tablCars, tablDrivers});
// Сохранить DATASET в виде XML
dataSet.WriteXmlSchema("AutoParkSchema.xsd");
dataSet.WriteXml("AutoPark.xml");
// Очистить DataSet.
dataSet.Clear();
Console.WriteLine("XML успешно сформированы!");
Console.ReadKey();
}
protected void btnSaveChanges_Click(object sender, EventArgs e)
{
using (System.Data.DataTable xmlData = Lib.Blok.GetXmlData())
{
foreach (GridViewRow item in dataGrid1.Rows)
{
switch (((CheckBox)item.Cells[0].FindControl("chkSelected")).Checked)
{
case true:
xmlData.DefaultView.RowFilter = "";
xmlData.DefaultView.RowFilter = "ID=" + BAYMYO.UI.Converts.NullToInt32(dataGrid1.DataKeys[item.RowIndex]["ID"]);
xmlData.DefaultView[0]["Sira"] = BAYMYO.UI.Converts.NullToInt16(((DropDownList)item.FindControl("ddlSira")).SelectedValue);
xmlData.DefaultView[0]["Yer"] = ((DropDownList)item.FindControl("ddlYer")).SelectedValue;
xmlData.DefaultView[0]["Dil"] = ((DropDownList)item.FindControl("ddlDil")).SelectedValue;
xmlData.DefaultView[0]["TumDil"] = ((CheckBox)item.FindControl("chkTumDil")).Checked;
xmlData.DefaultView[0]["TumSayfa"] = ((CheckBox)item.FindControl("chkTumSayfa")).Checked;
xmlData.DefaultView[0]["Aktif"] = ((CheckBox)item.FindControl("chkAktif")).Checked;
break;
}
}
xmlData.AcceptChanges();
xmlData.WriteXml(Server.MapPath(Lib.Blok.XmlPath));
infoLiteral.Text = "Tablo üzerindeki değişiklikler başarılı bir şekilde kaydedildi!";
}
}
protected string GetDataTableXml(DataTable dt)
{
dt.TableName = "must have name for xml...";
var writer = new StringWriter();
dt.WriteXml(writer);
return writer.ToString();
}
///// <summary>
///// 序列化物件
///// </summary>
///// <typeparam name="T"></typeparam>
///// <param name="value"></param>
///// <returns></returns>
//public string ObjectToString<T>(T value)
//{
// XmlSerializer ser = new XmlSerializer(value.GetType());
// MemoryStream stream = new MemoryStream();
// ser.Serialize(stream, value);
// stream.Position = 0;
// StreamReader reader = new StreamReader(stream);
// string result = reader.ReadToEnd();
// stream.Dispose();
// reader.Dispose();
// return result;
//}
public string ToDataTableXmlString(IEnumerable value)
{
var type = value.GetType().GetGenericArguments()[0];
DataTable dataTable = new DataTable(type.Name);
PropertyInfo[] Props = type.GetProperties(BindingFlags.Public | BindingFlags.Instance);
foreach (PropertyInfo prop in Props)
{
dataTable.Columns.Add(prop.Name);
}
foreach (object item in value)
{
var values = new object[Props.Length];
for (int i = 0; i < Props.Length; i++)
{
values[i] = Props[i].GetValue(item, null);
}
dataTable.Rows.Add(values);
}
using (var memoryStream = new MemoryStream())
{
dataTable.WriteXml(memoryStream);
memoryStream.Position = 0;
using (var reader = new StreamReader(memoryStream))
{
return reader.ReadToEnd();
}
}
}
static void Main(string[] args)
{
Console.WriteLine("program start!!");
// ClinetsInfoParser.Parse();
var tbl=new DataTable();
tbl.TableName = "custom";
tbl.Columns.Add("Name");
tbl.Columns.Add("Producer");
tbl.Columns.Add("Trash");
tbl.Columns.Add("Expires");
tbl.Columns.Add("Quantity");
tbl.Columns.Add("Trash2");
tbl.Columns.Add("Division");
for (int i = 0; i < 15; i++)
tbl.Rows.Add("Name" + i.ToString(), "Producer" + i.ToString(), i.ToString(), DateTime.Now.ToShortDateString(),
i.ToString(),i.ToString(), "Division" + i.ToString());
var stream=new MemoryStream();
tbl.WriteXml(stream,XmlWriteMode.WriteSchema);
var data= Packer.Pack(stream);
var result = new ConcurrentBag<byte[]>();
result.Add(data);
result.ToQueryResult();
Console.ReadKey();
}
private static string ConvertAltmanDataTableToXml(DataTable dt)
{
MemoryStream stream = null;
XmlTextWriter writer = null;
try
{
stream = new MemoryStream();
writer = new XmlTextWriter(stream, Encoding.Default);
writer.Formatting = Formatting.Indented;
dt.WriteXml(writer);
var count = (int)stream.Length;
var arr = new byte[count];
stream.Seek(0, SeekOrigin.Begin);
stream.Read(arr, 0, count);
return new UTF8Encoding().GetString(arr);
}
catch
{
return String.Empty;
}
finally
{
if (writer != null)
writer.Close();
}
}
/// <summary>
/// Function to export all the Account data to the XML File
/// </summary>
private static void exportAccountData()
{
DataTable AccountDB = new DataTable();
AccountDB.TableName = "Account Database";
AccountDB.Columns.Add("AccountID");
AccountDB.Columns.Add("Balance");
AccountDB.Columns.Add("Type");
AccountDB.Columns.Add("ClientID");
AccountDB.Columns.Add("Interest");
AccountDB.Columns.Add("Limit");
foreach (KeyValuePair<string, Account> entry in Program.AccountData)
{
DataRow row = AccountDB.NewRow();
row["AccountID"] = entry.Value.ACCOUNTID;
row["Balance"] = entry.Value.BALANCE;
row["Type"] = entry.Value.ACCOUNTTYPE;
row["ClientID"] = entry.Value.CLIENTID;
if (entry.Value.ACCOUNTTYPE=="Interest")
{
AccountInterest temp1 = (AccountInterest)entry.Value;
row["Interest"] = temp1.INTEREST;
row["Limit"] = null;
}
else
{
AccountNoInterest temp2 = (AccountNoInterest)entry.Value;
row["Limit"] = temp2.LIMIT;
row["Interest"] = null;
}
AccountDB.Rows.Add(row);
}
AccountDB.WriteXml("myAccount.xml");
}
private void AddTemplateToXML(string nm)
{
string path = System.IO.Path.GetDirectoryName(System.Windows.Forms.Application.ExecutablePath) + @"\templates.xml";
DataTable dt = new DataTable("TemplateTable");
dt.Columns.Add("TemplateName");
DataRow dr;
if (lstTemplate.Items.Count > 0)
{
try
{
for (int b = 0; b < lstTemplate.Items.Count; b++)
{
dr = dt.NewRow();
dr[0] = lstTemplate.Items[b].ToString();
dt.Rows.Add(dr);
}
if (File.Exists(path))
File.Delete(path);
dt.WriteXml(path);
MessageBox.Show("Template successfully inserted.", "CSR Assistant");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "CSR Assistant");
}
}
}
XmlDocument ConvertToXml(object source)
{
XmlDocument xml = new XmlDocument();
System.Data.DataTable dt = source as System.Data.DataTable;
if (dt != null)
{
using (System.IO.MemoryStream ms = new System.IO.MemoryStream())
{
dt.WriteXml(ms);
ms.Flush();
ms.Seek(0, System.IO.SeekOrigin.Begin);
xml.Load(ms);
}
}
else
{
XmlSerializer serializer = new XmlSerializer(source.GetType());
using (StringWriter sw = new StringWriter())
{
serializer.Serialize(sw, source);
sw.Flush();
string o = sw.ToString();
xml.LoadXml(o);
}
}
return(xml);
}
internal static string GetDeliveries()
{
sql = "SELECT " +
"deliveries.id AS delivery_id, purchases.id AS purchase_id, purchases.po_number, deliveries.delivery_date, supplier_id, name AS supplier_name, " +
"lookup_status.description AS status, lookup_status2.description AS completion_status " +
"FROM deliveries " +
"JOIN purchases ON purchases.id = deliveries.purchase_id " +
"JOIN suppliers ON suppliers.id = supplier_id " +
"JOIN lookup_status ON lookup_status.id = deliveries.status " +
"JOIN lookup_status AS lookup_status2 ON lookup_status2.id = deliveries.completion_status " +
"WHERE lookup_status2.description != 'Complete' ";
dt = new DataTable();
dt = Database.Query(sql);
if (dt != null)
{
if (dt.Rows[0].ItemArray[0].ToString() == "-1")
{
result = dt.Rows[0].ItemArray[1].ToString();
}
else
{
StringWriter sw = new StringWriter();
dt.WriteXml(sw);
result = sw.ToString();
}
}
else
{
result = Functions.FormatReturn(0, "No items found");
}
return result;
}
private static void SaveResultsToXml(
string fileName,
DataTable results
)
{
results.WriteXml(fileName);
}
public void ToXmlVfp(string path)
{
DataTable dt = new DataTable();
dt.TableName = "Tabla1";
DataColumn campo1 = new DataColumn();
campo1.DataType = typeof(string);
campo1.MaxLength = 20;
campo1.ColumnName = "Cae";
DataColumn campo2 = new DataColumn();
campo2.DataType = typeof(string);
campo2.MaxLength = 500;
campo2.ColumnName = "Problema";
dt.Columns.Add(campo1);
dt.Columns.Add(campo2);
foreach (string mensaje in this.Problema)
{
DataRow registro1 = dt.NewRow();
registro1[0] = this.Cae;
registro1[1] = mensaje;
dt.Rows.Add(registro1);
}
dt.WriteXml(path);
}
public string ConvertBetweenDataTableToXML(DataTable dtNeedCoveret)
{
System.IO.TextWriter tw = new System.IO.StringWriter();
//if TableName is empty, WriteXml() will throw Exception.
dtNeedCoveret.TableName = dtNeedCoveret.TableName.Length == 0 ? "Table" : dtNeedCoveret.TableName;
dtNeedCoveret.WriteXml(tw);
dtNeedCoveret.WriteXmlSchema(tw);
return tw.ToString();
}
public static void CreateBackUp(DataTable dt)
{
try
{
//dt.AcceptChanges();
dt.WriteXml(BackUpFileName);
}
catch(Exception)
{}
}
/*
Example Use
string[] fieldNames = {
"Id",
"Name",
"Age"
};
CsvToXmlConvert("c:\\temp\\example.txt", "TempTable", ";", "c:\\temp\\example.xml", fieldNames);*/
/// <summary>
/// </summary>
/// <param name="inputFile"></param>
/// <param name="dataName"></param>
/// <param name="separator"></param>
/// <param name="outputFile"></param>
/// <param name="fieldnames"></param>
public static void CsvToXmlConvert(
string inputFile,
string dataName,
char separator,
string outputFile,
string[] fieldnames = null)
{
var dt = new DataTable(dataName);
bool firstRow = true;
using (var sr = new StreamReader(inputFile))
{
while (!(sr.EndOfStream))
{
string readLine = sr.ReadLine();
if (readLine == null)
{
continue;
}
string[] fields = readLine.Split(separator);
IEnumerable<string> e = from s in fields
select s;
int c = e.Count();
if (firstRow)
{
for (int ii = 0;
ii <= c - 1;
ii++)
{
string fName = "";
if ((fieldnames == null))
{
fName = "Field" + ii.ToString("000");
}
else
{
fName = fieldnames[ii];
}
dt.Columns.Add(fName);
}
firstRow = false;
}
foreach (string field in fields)
{
dt.Rows.Add(field);
}
}
dt.WriteXml(outputFile);
dt.Dispose();
}
}
public string Write(TableName tname, DataTable dt)
{
string file = getDataFileName(tname);
using (var writer = NewStreamWriter(file))
{
dt.TableName = tname.Name;
dt.DataSet.DataSetName = tname.DatabaseName.Name;
dt.WriteXml(writer, XmlWriteMode.WriteSchema);
}
return file;
}
public static void CreateCorrespondingXmlWhenNotExist()
{
if (!File.Exists(xmlPath))
{
var dtTableName = new DataTable();
dtTableName.Columns.Add("OriName");
dtTableName.Columns.Add("PascalName");
dtTableName.TableName = "dt";
dtTableName.Rows.Add(new[] { "1", "1" });
dtTableName.WriteXml(xmlPath);
}
}
public response GetSpecificStory(int ID)
{
var dataTable = new System.Data.DataTable();
dataTable = new System.Data.DataTable {
TableName = "Stories"
};
string connString = URLInfo.GetDataBaseConnectionString();
System.IO.StringWriter writer = new System.IO.StringWriter();
string returnString = "";
response response = new response();
response.result = 0;
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(connString))
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("GetSpecificStory", con))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", System.Data.SqlDbType.NVarChar).Value = ID;
con.Open();
var dataReader = cmd.ExecuteReader();
dataTable.Load(dataReader);
dataTable.WriteXml(writer, System.Data.XmlWriteMode.WriteSchema, false);
returnString = writer.ToString();
int numberOfRecords = dataTable.Rows.Count;
response.result = numberOfRecords;
SpecificStoryList list = new SpecificStoryList();
foreach (System.Data.DataRow row in dataTable.Rows)
{
specificStory myprod = new specificStory();
myprod.ID = row["ID"].ToString();
myprod.JakataID = row["JakataID"].ToString();
myprod.AnimalType = row["AnimalType"].ToString();
myprod.Comments = row["Comments"].ToString();
myprod.MoralType = row["MoralType"].ToString();
myprod.Stories = row["Stories"].ToString();
myprod.StoryCategorytName = row["StoryCategorytName"].ToString();
myprod.Title = row["Title"].ToString();
list.specificStory.Add(myprod);
}
response.AddSpecificStoryList(list);
response.log.Add(numberOfRecords + " Records found");
}
}
return(response);
}
/// <summary>
/// 将DataTable转化为XML输出
/// </summary>
/// <param name="dataTable">DataTable</param>
/// <param name="fileName">文件名称</param>
public void DataTableToXML(DataTable dataTable, string fileName)
{
//指定程序安装目录
string filePath = AppDomain.CurrentDomain.SetupInformation.ApplicationBase + fileName;
using (FileStream fs = new FileStream(filePath, FileMode.OpenOrCreate, FileAccess.Write))
{
using (XmlWriter xmlWriter = XmlWriter.Create(fs))
{
dataTable.WriteXml(xmlWriter, XmlWriteMode.IgnoreSchema);
}
}
Process.Start(filePath);
}
/// <summary>
/// 将数据从DataTable类型转化为XElement类型数据
/// </summary>
/// <param name="xmlDS">数据源</param>
/// <param name="tableName">DataTable中的表名</param>
/// <returns></returns>
public static XElement ConvertDataTableToXML(DataTable xmlDS, string tableName)
{
//定义转化需要的变量
StringWriter sw = new StringWriter();
//设置获取数据的表名
xmlDS.TableName = tableName;
//写当前数据
xmlDS.WriteXml(sw, System.Data.XmlWriteMode.IgnoreSchema, true);
//将数据转化为字符串
string contents = sw.ToString();
//返回
return XElement.Parse(contents);
}
/// <summary>
/// DataTable 내용을 Xml Text로 변경한다.
/// </summary>
/// <param name="table">Instance of DataTable</param>
/// <param name="writeMode">Xml Text 생성 모드</param>
/// <returns>생성된 Xml 문자열</returns>
public static string ToXmlText(DataTable table, XmlWriteMode writeMode = XmlWriteMode.WriteSchema) {
table.ShouldNotBeNull("table");
if(IsDebugEnabled)
log.Debug("Convert DataTable to Xml Text. table=[{0}], writeMode=[{1}]", table.TableName, writeMode);
var sb = new StringBuilder();
using(var writer = new StringWriter(sb))
table.WriteXml(writer, writeMode);
return sb.ToString();
}
private void button2_Click(object sender, EventArgs e)
{
string d_OldPath = "";
d_OldPath = Application.StartupPath;
SaveFileDialog d_Dialog = new SaveFileDialog();
d_Dialog.Title = "导出数据";
d_Dialog.Filter = "Excel 文件(*.xls)|*.xls|XML 文件(*.xml)|*.xml|TXT文件(*.txt)|*.txt|HTML 文件(*.html)|*.html|MHT 文件(*.mht)|*.mht|PDF 文件(*.pdf)|*.pdf|RFT 文件(*.rtf)|*.rtf";
//'d_Dialog.Filter = "Excel 文件(*.xls)|*.xls|XML 文件(*.xml)|*.xml|TXT文件(*.txt)|*.txt"
string d_PathName = "";
try
{
if (d_Dialog.ShowDialog() == DialogResult.OK)
{
d_PathName = d_Dialog.FileName;
if (d_PathName.Substring(d_PathName.Length - 3) == "xls")
{ //'把数据导到Excel中
gridView1.ExportToExcelOld(d_PathName);
}
else if (d_PathName.Substring(d_PathName.Length - 3) == "xml")
{ //'把数据导到xml中
DataTable d_table = new DataTable();
d_table = (DataTable)this.gridControl1.DataSource;
//'把FlexGrid里的内容写到DataSet里
d_table.WriteXml(d_PathName);
}
else if (d_PathName.Substring(d_PathName.Length - 3) == "txt")
{ //'把数据导到txt中
gridView1.ExportToText(d_PathName);
}
else if (d_PathName.Substring(d_PathName.Length - 3) == "tml")
{ //'把数据导到HTML中
gridView1.ExportToHtml(d_PathName);
}
else if (d_PathName.Substring(d_PathName.Length - 3) == "mht")
{ //'把数据导到mht中
gridView1.ExportToMht(d_PathName);
}
else if (d_PathName.Substring(d_PathName.Length - 3) == "pdf")
{ //'把数据导到PDF中
gridView1.ExportToPdf(d_PathName);
}
else if (d_PathName.Substring(d_PathName.Length - 3) == "rtf")
{ //'把数据导到PDF中
gridView1.ExportToRtf(d_PathName);
}
}
}
catch { }
}
public void Output(TableInfo table, DataTable data)
{
var outputFilename = string.Format("{0}.xml", table.OutputTableName);
_logger.Info("Writing data to {0}...", outputFilename);
using (var writer = new StringWriter())
{
data.WriteXml(writer, XmlWriteMode.IgnoreSchema, false);
File.WriteAllText(outputFilename, writer.ToString());
}
_logger.Info("Finished writing data to {0}.", outputFilename);
}
public response GetJakataMaster()
{
var dataTable = new System.Data.DataTable();
dataTable = new System.Data.DataTable {
TableName = "JakataMaster"
};
//var conString1 = ConfigurationManager.ConnectionStrings["LocalEvolution"];
//string connString = conString1.ConnectionString;
string connString = URLInfo.GetDataBaseConnectionString();
System.IO.StringWriter writer = new System.IO.StringWriter();
string returnString = "";
response response = new response();
response.result = 0;
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(connString))
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("GetJakataMaster", con))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
var dataReader = cmd.ExecuteReader();
dataTable.Load(dataReader);
dataTable.WriteXml(writer, System.Data.XmlWriteMode.WriteSchema, false);
returnString = writer.ToString();
int numberOfRecords = dataTable.Rows.Count;
response.result = numberOfRecords;
JakataMasterList list = new JakataMasterList();
foreach (System.Data.DataRow row in dataTable.Rows)
{
jakataMaster myprod = new jakataMaster();
myprod.ID = row["ID"].ToString();
myprod.Title = row["Title"].ToString();
list.jakataMasterLists.Add(myprod);
}
response.AddJakataMasterList(list);
response.log.Add(numberOfRecords + " Records found");
}
}
return(response);
}
public static string ConvertDataTableToXML(DataTable sourceTable)
{
string xmlString = "";
using (System.IO.MemoryStream ms = new System.IO.MemoryStream())
{
sourceTable.WriteXml(ms);
System.Xml.XmlTextWriter x = new System.Xml.XmlTextWriter(ms, new System.Text.UTF8Encoding(false));
x.Formatting = System.Xml.Formatting.Indented;
//using (x)
//{
xmlString = System.Text.Encoding.UTF8.GetString(ms.GetBuffer(), 0, (int)ms.Length);
//}
}
return xmlString;
}
public int Execute()
{
using (var conn = this.GetConnection())
{
conn.Open();
DataTable dt = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(this.Command, conn);
adapter.SelectCommand.CommandType = this.CommandType;
adapter.Fill(dt);
dt.TableName = "tmp";
dt.WriteXml(this.SaveTo);
dt.WriteXmlSchema(this.SaveTo + ".schema");
}
return 0;
}
private void btGrabar_Click(object sender, EventArgs e)
{
oTabla.Rows.Add();
oTabla.Rows[oTabla.Rows.Count - 1]["nombre"] = txtNombre.Text;
oTabla.Rows[oTabla.Rows.Count - 1]["edad"] = txtEdad.Text;
oTabla.Rows[oTabla.Rows.Count - 1]["domicilio"] = txtDomicilio.Text;
//oTabla.Rows.Add();
//oTabla.Rows[1][0] = txtNombre.Text;
//oTabla.Rows[1][1] = txtEdad.Text;
//oTabla.Rows[1][2] = txtDomicilio.Text;
oTabla.WriteXml(@"clientes.xml");
}
private void btSaveXML_Click(object sender, EventArgs e)
{
saveFileDialog1.InitialDirectory = "C:";
saveFileDialog1.Title = "Save as .XML File";
saveFileDialog1.FileName = "";
saveFileDialog1.Filter = "XML file(*.xml)|*.xml";
saveFileDialog1.RestoreDirectory = true;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
DataTable dt = new DataTable();
dt.TableName = "THONG_TIN_KHACH";
for (int i = 0; i < dataGridViewSML.Columns.Count; i++)
{
if (dataGridViewSML.Columns[i].Visible) // Add's only Visible columns (if you need it)
{
string headerText = dataGridViewSML.Columns[i].HeaderText;
headerText = Regex.Replace(headerText, "[-/, ]", "_");
DataColumn column = new DataColumn(headerText);
dt.Columns.Add(column);
}
}
object[] cellvalue = new object[dataGridViewSML.Columns.Count];
foreach (DataGridViewRow DataGVRow in dataGridViewSML.Rows)
{
DataRow dataRow = dt.NewRow();
for (int i = 0; i < DataGVRow.Cells.Count; i++)
{
cellvalue[i] = DataGVRow.Cells[i].Value;
}
dt.Rows.Add(cellvalue);
}
DataSet ds = new DataSet();
ds.DataSetName = "KHAI_BAO_TAM_TRU";
ds.Tables.Add(dt);
MessageBox.Show("Sucsecfull!");
var writer = XmlWriter.Create(saveFileDialog1.FileName, new XmlWriterSettings {
Encoding = Encoding.UTF8, Indent = true
});
dt.WriteXml(writer);
writer.Close();
}
}
public response GetYouTube(int JakataID)
{
var dataTable = new System.Data.DataTable();
dataTable = new System.Data.DataTable {
TableName = "YouTube"
};
string connString = URLInfo.GetDataBaseConnectionString();
System.IO.StringWriter writer = new System.IO.StringWriter();
string returnString = "";
response response = new response();
response.result = 0;
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(connString))
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("GetYouTube", con))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@JakataID", System.Data.SqlDbType.NVarChar).Value = JakataID;
con.Open();
var dataReader = cmd.ExecuteReader();
dataTable.Load(dataReader);
dataTable.WriteXml(writer, System.Data.XmlWriteMode.WriteSchema, false);
returnString = writer.ToString();
int numberOfRecords = dataTable.Rows.Count;
response.result = numberOfRecords;
YouTubeList list = new YouTubeList();
foreach (System.Data.DataRow row in dataTable.Rows)
{
youTube myprod = new youTube();
myprod.ID = row["ID"].ToString();
myprod.JakataID = row["JakataID"].ToString();
myprod.URL = row["URL"].ToString();
list.youTubeLists.Add(myprod);
}
response.AddYouTubeList(list);
response.log.Add(numberOfRecords + " Records found");
}
}
return(response);
}
public string gameLogFromsID(string sID)
{
SqlCommand cmd = new SqlCommand("SELECT * FROM w00_GameLog..tGameLog WHERE tGameLog.nCharNo = (SELECT nCharNo FROM w00_Character..tCharacter WHERE sID = @sID) OR tGameLog.nTargetCharNo = (SELECT nCharNo FROM w00_Character..tCharacter WHERE sID = @sID) ORDER BY dDate;", conn);
cmd.Parameters.AddWithValue("@sID", sID);
DataTable bufferDT = new DataTable();
SqlDataAdapter SQLDTA = new SqlDataAdapter();
conn.Open();
bufferDT.TableName = "GameLog";
SQLDTA.SelectCommand = cmd;
SQLDTA.Fill(bufferDT);
conn.Close();
StringWriter sw = new StringWriter();
bufferDT.WriteXml(sw);
sw.Close();
return sw.ToString();
}
private void createXml()
{
DataTable dt = new DataTable("empTable");
dt.Columns.Add("EmpNo",Type.GetType("System.Int32"));
dt.Columns.Add("EmpName", Type.GetType("System.String"));
dt.Columns.Add("Salary", Type.GetType("System.Int32"));
DataRow r = dt.NewRow();
r[0] = 1;
r[1] = "Rama";
r[2] = 1000;
dt.Rows.Add(r);
string str = Server.MapPath("emp.xml");
dt.WriteXml(str);
}
public static string FormatReturn(int _flag, string _result)
{
string result;
using (DataTable dt = new DataTable("table"))
{
dt.Columns.Add("flag");
dt.Columns.Add("result");
dt.Rows.Add(_flag, _result);
StringWriter sw = new StringWriter();
dt.WriteXml(sw);
result = sw.ToString();
sw.Dispose();
}
return result;
}
protected void btnExportToXML_Click(object sender, EventArgs e)
{
FillGrid();
try
{
DataTable dtXML = new DataTable();
dtXML = dvTeachers.ToTable("Teachers");
dtXML.WriteXml(@"C:\Users\Core i3\Desktop\Teachers.xml");
lblMsg.Text = "Export to XML OK!!!";
}
catch(Exception ex)
{
lblMsg.Text = "Error to Export to XML: " + ex.Message.ToString();
}
}
public response GetStorySource()
{
var dataTable = new System.Data.DataTable();
dataTable = new System.Data.DataTable {
TableName = "StorySource"
};
string connString = URLInfo.GetDataBaseConnectionString();
System.IO.StringWriter writer = new System.IO.StringWriter();
string returnString = "";
response response = new response();
response.result = 0;
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(connString))
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("GetStorySource", con))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
var dataReader = cmd.ExecuteReader();
dataTable.Load(dataReader);
dataTable.WriteXml(writer, System.Data.XmlWriteMode.WriteSchema, false);
returnString = writer.ToString();
int numberOfRecords = dataTable.Rows.Count;
response.result = numberOfRecords;
StorySourceList list = new StorySourceList();
foreach (System.Data.DataRow row in dataTable.Rows)
{
storySource myprod = new storySource();
myprod.ID = row["ID"].ToString();
myprod.StorySource = row["StorySource"].ToString();
list.storySourceLists.Add(myprod);
}
response.AddStorySourceList(list);
response.log.Add(numberOfRecords + " Records found");
}
}
return(response);
}
private static string TarnsformInternal(DataTable dt, Encoding encoding, XslCompiledTransform transform)
{
Encoding e = encoding ?? Encoding.Default;
XmlDocument doc = new XmlDocument();
using (StringWriter sw = new StringWriter())
{
XmlWriterSettings set = new XmlWriterSettings();
set.Encoding = e;
using (XmlWriter xw = XmlWriter.Create(sw, set))
{
dt.WriteXml(xw, false);
doc.LoadXml(sw.ToString());
}
}
return TransformInternal(doc, transform);
}
private void CreateXml()
{
try
{
using (System.Data.DataTable dt = new System.Data.DataTable("Manset"))
{
using (BAYMYO.UI.Web.CustomSqlQuery query = new BAYMYO.UI.Web.CustomSqlQuery(dt, "Manset", "KayitTarihi DESC", "Aktif=1"))
{
query.Top = 9;
query.Execute();
dt.WriteXml(Server.MapPath(Settings.XmlPath + "manset.xml"), System.Data.XmlWriteMode.WriteSchema);
}
}
}
catch (Exception)
{
}
}
//функция записи таблицы в XML формат
public void SaveDataTableInXML(DataTable TableForSave)
{
//читаем имя таблицы
string Name = TableForSave.TableName;
//если имя таблицы не пустое то сохраняем данные
if (Name != "")
{
//добавляем к имени расширение xml
Name += ".xml";
//создаем специальную переменную для преобразования данных из таблицы в XML формат
StringWriter writerXML = new StringWriter();
//получаем данные о таблице и преобразуем их в XML формат
TableForSave.WriteXml(writerXML, XmlWriteMode.WriteSchema, true);
//Сохраняем преобразованные в XML данные в файл
File.WriteAllText(Name, writerXML.ToString());
}
}
public static void saveDataTable(DataTable data, string filePath)
{
// Create the FileStream to write with.
System.IO.FileStream myFileStream = new System.IO.FileStream
(filePath, System.IO.FileMode.Create);
// Create an XmlTextWriter with the fileStream.
System.Xml.XmlTextWriter myXmlWriter =
new System.Xml.XmlTextWriter(myFileStream, System.Text.Encoding.Unicode);
// Write to the file with the WriteXml method.
try
{
data.WriteXml(myXmlWriter);
}
finally
{
myXmlWriter.Close();
}
}
/// <summary>
/// Gets the XML document.
/// </summary>
/// <param name="table">The table.</param>
/// <returns></returns>
public static IXPathNavigable GetXmlDocument(DataTable table)
{
XmlDocument doc = new XmlDocument();
using (MemoryStream ms = new MemoryStream())
{
table.WriteXml(ms, XmlWriteMode.IgnoreSchema);
ms.Position = 0;
XmlReaderSettings settings = new XmlReaderSettings();
settings.IgnoreComments = true;
settings.IgnoreProcessingInstructions = true;
settings.IgnoreWhitespace = true;
XmlReader reader = XmlReader.Create(ms, settings);
doc.Load(reader);
}
return doc;
}
//public response GetSpecificStory(Story myStoryies)
public String GetSpecificStory(Story myStoryies)
{
var dataTable = new System.Data.DataTable();
dataTable = new System.Data.DataTable {
TableName = "Stories"
};
string connString = URLInfo.GetDataBaseConnectionString();
System.IO.StringWriter writer = new System.IO.StringWriter();
string returnString = "";
response response = new response();
response.result = 0;
string resultstring = "";
SpecificStoryList list = new SpecificStoryList();
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(connString))
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("GetSearchStory", con))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
//cmd.Add("@JakataID", myStory.JakataID);
//cmd.Add("@StoryCategorytName", 1);
//cmd.Add("@Title", myStory.Title);
//cmd.Add("@AnimalType", myStory.AnimalType);
if (myStoryies.Title > 0)
{
cmd.Parameters.Add("@Title", System.Data.SqlDbType.NVarChar).Value = myStoryies.Title;
}
if (myStoryies.JakataID > 0)
{
cmd.Parameters.Add("@JakataID", System.Data.SqlDbType.Int).Value = myStoryies.JakataID;
}
if (myStoryies.AnimalType != "0")
{
cmd.Parameters.Add("@AnimalType", System.Data.SqlDbType.NVarChar).Value = myStoryies.AnimalType;
}
if (myStoryies.MoralType > 0)
{
cmd.Parameters.Add("@MoralType", System.Data.SqlDbType.Int).Value = myStoryies.MoralType;
}
if (myStoryies.Comments != "0")
{
cmd.Parameters.Add("@Comments", System.Data.SqlDbType.NVarChar).Value = myStoryies.Comments;
}
if (myStoryies.Stories != "0")
{
cmd.Parameters.Add("@Stories", System.Data.SqlDbType.NVarChar).Value = myStoryies.Stories;
}
con.Open();
var dataReader = cmd.ExecuteReader();
dataTable.Load(dataReader);
dataTable.WriteXml(writer, System.Data.XmlWriteMode.WriteSchema, false);
returnString = writer.ToString();
//return returnString;
int numberOfRecords = dataTable.Rows.Count;
response.result = numberOfRecords;
//SpecificStoryList list = new SpecificStoryList();
foreach (System.Data.DataRow row in dataTable.Rows)
{
//specificStory myprod = new specificStory();
resultstring = resultstring + row["ID"].ToString() + "|";
//list.specificStory.Add(myprod);
}
//response.AddSpecificStoryList(list);
//response.log.Add(numberOfRecords + " Records found");
}
}
//return list;
return(resultstring);
//return response;
}
/// <summary>
/// конструктор класса
/// </summary>
/// <param name="start_day">дата первого дня учебной недели</param>
public Data(DateTime start_day, List <int> empty_rows, List <string> grups, int fakultet)
{
rows = 42;
cols = grups.Count;
//задать соотвествие "дата-номер строки"
DateTime curdate = start_day;
for (int i = 0; i < empty_rows.Count; i++)
{
for (int j = empty_rows[i] + 1; j < empty_rows[i] + 7; j++)
{
date_row.Add(j, curdate);
}
curdate = curdate.AddDays(1);
}
//задать соотвествие "группа-столбец"
int kkk = 1;
for (int j = 0; j < grups.Count; j++)
{
grupa_column.Add(kkk, grups[j]);
column_grupa.Add(grups[j], kkk);
kkk += 2;
}
//задать соотвествие "пара-номер_строки"
for (int i = 0; i < empty_rows.Count; i++)
{
int para_count = 1;
for (int j = empty_rows[i] + 1; j < empty_rows[i] + 7; j++)
{
para_row.Add(j, para_count);
para_count++;
}
}
//создать фильтр для данной недели
int ds = start_day.Day,
ms = start_day.Month,
ys = start_day.Year;
int de = start_day.AddDays(6).Day,
me = start_day.AddDays(6).Month,
ye = start_day.AddDays(6).Year;
string res = "";
res = string.Format(" and (y>={0} and y<={1}) ", ys, ye);
if (ms == 12 && me == 1)
{
res = res + " and (m=1 or m=12) ";
}
else
{
res = res + string.Format(" and (m>={0} and m<={1})", ms, me);
}
if (de < ds)
{
res = res + string.Format(" and ((d>={0} and d<=31 and m={2}) or (d>=1 and d<={1} and m={3})) "
, ds, de, ms, me);
}
else
{
res = res + string.Format(" and (d>={0} and d<={1}) ", ds, de);
}
query = string.Format("select " +
" gn=grupa.name, gi=grupa.id, " +
" prepn = prepod.fam + ' ' + left(prepod.im,1) + '.' + left(prepod.ot,1) + '.'," +
" predmn = predmet.name_krat, " +
" audn = kabinet.nomer, " +
" rasp.y, rasp.d, rasp.m, rasp.predmet_id, rasp.grupa_id, rasp.prepod_id, rasp.fakultet_id, " +
" rasp.kurs_id, rasp.nom_zan, rasp.vid_zan_id, " +
" rasp.kabinet_id, rasp.semestr_id, rasp.potok_id, " +
" rasp.subgr_nomer, chas = rasp.kol_chas, " +
" rasp.id, krat_name, predmet.delenie, tema, vid_del=vid_zan.delenie, vidname = vid_zan.name, prim = isnull(prim_text,'') " +
" , prfullname = predmet.name " +
" from rasp " +
" join grupa on grupa.id=rasp.grupa_id " +
" join prepod on prepod.id=rasp.prepod_id " +
" join predmet on predmet.id=rasp.predmet_id " +
" join kabinet on kabinet.id=rasp.kabinet_id " +
" join vid_zan on vid_zan.id=rasp.vid_zan_id " +
" where rasp.fakultet_id={0} and grupa.show_in_grid=1 ", fakultet)
+ res +
" order by y, m, d, nom_zan, grupa.outorder";
//получить данные раписания на указанную неделю
SqlDataAdapter da = new SqlDataAdapter(query, main.global_connection);
BD = new DataTable("rasp");
da.Fill(BD);
//создать временную папку для размещения файлов данных
path = Environment.GetEnvironmentVariable("TMP", EnvironmentVariableTarget.User) +
"\\Facultet";
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
else
{
foreach (string f in Directory.GetFiles(path))
{
try
{
File.Delete(f);
}
catch (Exception exx)
{
//
}
}
}
if (BD.Rows.Count > 0)
{
BD.WriteXml(path + "\\0.xml");
}
// ----------------------- сздать структуру данных для хранения информации в программе
data =
new Dictionary <DateTime, Dictionary <string, Dictionary <int, Cell> > > ( );
//data[DateTime.Now]["П21"][6].egz[0] = true;
//цикл по дням недели
int paranumber = 0;
for (DateTime i = start_day; i <= start_day.AddDays(6); i = i.AddDays(1))
{
Dictionary <string, Dictionary <int, Cell> > gruppa_cell =
new Dictionary <string, Dictionary <int, Cell> > ( );
for (int j = 0; j < grups.Count; j++) //цикл по группам
{
string grname = grups[j];
Dictionary <int, Cell> para_gruppa = new Dictionary <int, Cell> ( );
for (paranumber = 1; paranumber <= 6; paranumber++) //цикл по парам
{
Cell tmpcell = new Cell( );
para_gruppa.Add(paranumber, tmpcell);
}
gruppa_cell.Add(grname, para_gruppa);
}
data.Add(i, gruppa_cell);
}
// ---------------------------------- заполнить структуру data данными из базы
foreach (DataRow row in BD.Rows)
{
Cell c = new Cell( );
DateTime currdate = new DateTime((int)row["y"], (int)row["m"], (int)row["d"]);
if (this[currdate, row["gn"].ToString( ), (int)row["nom_zan"]].id[0] > 0 ||
this[currdate, row["gn"].ToString( ), (int)row["nom_zan"]].id[1] > 0)
{
c = this[currdate, row["gn"].ToString( ), (int)row["nom_zan"]];
}
int sub = (int)row["subgr_nomer"];
c.col[0] = column_grupa[row["gn"].ToString( )];
c.col[1] = c.col[0] + 1;
c.row = 0;
foreach (int drow in date_row.Keys)
{
if (date_row[drow] == currdate)
{
c.row = drow + (int)row["nom_zan"] - 6;
}
}
if (sub == 0)
{
sub = 0;
}
else
{
sub--;
}
c.subgr_nomer[sub] = (int)row["subgr_nomer"];
c.id[sub] = (int)row["id"]; //задать id зантяия
c.y[sub] = (int)row["y"];
c.m[sub] = (int)row["m"];
c.d[sub] = (int)row["d"];
c.y[sub] = (int)row["y"];
c.predmet_id[sub] = (int)row["predmet_id"];
c.predmet_name[sub] = row["predmn"].ToString();
c.predmet_fullname[sub] = row["prfullname"].ToString();
c.prepod_id[sub] = (int)row["prepod_id"];
c.prepod_name[sub] = row["prepn"].ToString();
c.grupa_id[sub] = (int)row["grupa_id"];
c.fakultet_id[sub] = (int)row["fakultet_id"];
c.kurs_id[sub] = (int)row["kurs_id"];
c.nom_zan[sub] = (int)row["nom_zan"];
c.vid_zan_id[sub] = (int)row["vid_zan_id"];
c.vid_zan_name[sub] = row["krat_name"].ToString();
c.vid_full_name[sub] = row["vidname"].ToString();
c.vid_delenie[sub] = (bool)row["vid_del"];
c.kabinet_id[sub] = (int)row["kabinet_id"];
c.aud_name[sub] = row["audn"].ToString();
c.semestr_id[sub] = (int)row["semestr_id"];
c.potok_id[sub] = (int)row["potok_id"];
c.delenie[sub] = (bool)row["delenie"];
c.tema[sub] = row["tema"].ToString();
c.str_prim[sub] = row["prim"].ToString();
if (!row.IsNull("chas"))
{
c.col_chas[sub] = (double)row["chas"];
}
else
{
c.col_chas[sub] = 0.0;
}
if ((int)row["subgr_nomer"] == 0)
{
c.copy_subgroups(sub, 1 - sub);
}
this[currdate, row["gn"].ToString( ), (int)row["nom_zan"]] = c;
}
}
public response GetSpecificStoryDropdownStatus(int ID)
{
var dataTable = new System.Data.DataTable();
dataTable = new System.Data.DataTable {
TableName = "JakataMaster"
};
string connString = URLInfo.GetDataBaseConnectionString();
System.IO.StringWriter writer = new System.IO.StringWriter();
string returnString = "";
response response = new response();
response.result = 0;
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(connString))
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("GetSpecificStoryDropdownStatus", con))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@StoryImported", System.Data.SqlDbType.NVarChar).Value = ID;
con.Open();
var dataReader = cmd.ExecuteReader();
dataTable.Load(dataReader);
dataTable.WriteXml(writer, System.Data.XmlWriteMode.WriteSchema, false);
returnString = writer.ToString();
int numberOfRecords = dataTable.Rows.Count;
response.result = numberOfRecords;
//JakataMasterList list = new JakataMasterList();
//foreach (DataRow row in dataTable.Rows)
//{
// jakataMaster myprod = new jakataMaster();
// myprod.ID = row["JakataID"].ToString();
// myprod.Title = row["Title"].ToString();
// list.jakataMasterLists.Add(myprod);
//}
ToDoList list = new ToDoList();
foreach (System.Data.DataRow row in dataTable.Rows)
{
toDo myprod = new toDo();
myprod.ID = row["JakataID"].ToString();
myprod.Title = row["Title"].ToString();
list.toDoLists.Add(myprod);
}
//response.AddJakataMasterList(list);
response.AddToDoList(list);
//response.AddToDoList(list);
response.log.Add(numberOfRecords + " Records found");
}
}
return(response);
}
private void ExportResults()
{
//SS:01/03/2018:2018-R1:ABSEXCH-19796: When Running the ExchDVT.exe, SQL Admin Passwords are visible in dump file.
ADODB.Connection conn = new ADODB.Connection();
ADODB.Command cmd = new ADODB.Command();
if (CompanyCode == null)
{
cmd.CommandText = "SELECT [IntegrityErrorNo]" +
", [IntegrityErrorCode]" +
", [Severity]" +
", [IntegrityErrorMessage]" +
", [IntegritySummaryDescription]" +
", [SchemaName]" +
", [TableName]" +
", [PositionId]" +
"FROM [common].[SQLDataValidation] ";
}
else
{
cmd.CommandText = "SELECT [IntegrityErrorNo]" +
", [IntegrityErrorCode]" +
", [Severity]" +
", [IntegrityErrorMessage]" +
", [IntegritySummaryDescription]" +
", [SchemaName]" +
", [TableName]" +
", [PositionId] " +
"FROM [common].[SQLDataValidation] " +
"WHERE SchemaName = '" + CompanyCode + "'";
}
cmd.CommandTimeout = 10000;
if (conn.State == 0)
{
if (ConnPassword.Trim() == "")
{
conn.Open();
}
else
{
conn.Open(ExchequerCommonSQLConnection, "", ConnPassword.Trim(),
(int)ADODB.ConnectModeEnum.adModeUnknown);
}
}
conn.CursorLocation = ADODB.CursorLocationEnum.adUseClient;
System.Data.DataTable dataTable = new System.Data.DataTable {
TableName = "resultSet"
};
try
{
cmd.CommandType = ADODB.CommandTypeEnum.adCmdText;
cmd.ActiveConnection = conn;
ADODB.Recordset recordSet = null;
object objRecAff;
recordSet = (ADODB.Recordset)cmd.Execute(out objRecAff, Type.Missing, (int)ADODB.CommandTypeEnum.adCmdText);
System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter();
adapter.Fill(dataTable, recordSet);
if (conn.State == 1)
{
conn.Close();
}
}
catch
{
throw;
}
Type officeType = Type.GetTypeFromProgID("Excel.Application");
if (officeType == null)
{
//no Excel installed
SaveFileDialog.Filter = "XML File | *.xml";
SaveFileDialog.InitialDirectory = ExchequerPath + "\\Logs";
SaveFileDialog.DefaultExt = "XML";
SaveFileDialog.OverwritePrompt = true;
SaveFileDialog.FileName = "ExchSQLDataValidationResults";
if (CompanyCode != null)
{
SaveFileDialog.FileName = SaveFileDialog.FileName + "-" + CompanyCode;
}
SaveFileDialog.ShowDialog();
this.UseWaitCursor = true;
txtCompanyName.Enabled = false;
txtContactName.Enabled = false;
txtEmailAddress.Enabled = false;
btnSaveResults.Enabled = false;
System.Windows.Forms.Application.DoEvents();
XmlTextWriter writer = new XmlTextWriter(@SaveFileDialog.FileName, null);
writer.WriteStartDocument(true);
writer.Formatting = Formatting.Indented;
writer.WriteStartElement("SQLDataValidationResults");
writer.WriteStartElement("CompanyName");
writer.WriteString(txtCompanyName.Text);
writer.WriteEndElement();
writer.WriteStartElement("ContactName");
writer.WriteString(txtContactName.Text);
writer.WriteEndElement();
writer.WriteStartElement("EmailAddress");
writer.WriteString(txtEmailAddress.Text);
writer.WriteEndElement();
writer.WriteStartElement("VersionInfo");
writer.WriteString(VersionInfo);
writer.WriteEndElement();
dataTable.WriteXml(writer);
writer.WriteEndDocument();
writer.Close();
}
else
{
//Excel installed
SaveFileDialog.Filter = "Excel File | *.xlsx";
SaveFileDialog.InitialDirectory = ExchequerPath + "\\Logs";
SaveFileDialog.DefaultExt = "XLSX";
SaveFileDialog.OverwritePrompt = true;
SaveFileDialog.FileName = "ExchSQLDataValidationResults";
if (CompanyCode != null)
{
SaveFileDialog.FileName = SaveFileDialog.FileName + "-" + CompanyCode;
}
SaveFileDialog.ShowDialog();
this.UseWaitCursor = true;
txtCompanyName.Enabled = false;
txtContactName.Enabled = false;
txtEmailAddress.Enabled = false;
btnSaveResults.Enabled = false;
System.Windows.Forms.Application.DoEvents();
clsExcelUtlity obj = new Data_Integrity_Checker.clsExcelUtlity();
obj.WriteDataTableToExcel(dataTable, "ExchSQL Data Validation Results", SaveFileDialog.FileName, txtCompanyName.Text, txtContactName.Text, txtEmailAddress.Text, VersionInfo);
}
this.UseWaitCursor = false;
dataTable = null;
Close();
}