private void menuItemExportToDB_Click(object sender, EventArgs e)
{
IList <LogRecord> list = dataGridView1.DataSource as IList <LogRecord>;
if (list == null || list.Count == 0)
{
return;
}
//DataTable dt = new DataTable("IISLogData");
//dt.Columns.Add("LogTime", typeof(string));
//dt.Columns.Add("Method", typeof(string));
//dt.Columns.Add("ClientIP", typeof(string));
//dt.Columns.Add("ClientIPLocation", typeof(string));
//dt.Columns.Add("Status", typeof(string));
//dt.Columns.Add("SubStatus", typeof(string));
//dt.Columns.Add("Win32Status", typeof(string));
//dt.Columns.Add("ReceiveBytes", typeof(string));
//dt.Columns.Add("SendBytes", typeof(string));
//dt.Columns.Add("UriStem", typeof(string));
//dt.Columns.Add("Referer", typeof(string));
//dt.Columns.Add("UriStemAlias", typeof(string));
//dt.Columns.Add("RefererAlias", typeof(string));
//dt.Columns.Add("UserAgentAlias", typeof(string));
//dt.Columns.Add("UserAgent", typeof(string));
//foreach (LogRecord lr in list)
//{
// DataRow row = dt.NewRow();
// row["LogTime"] = lr.LogTime.ToString();
// row["Method"] = lr.Method;
// row["ClientIP"] = lr.ClientIP;
// row["ClientIPLocation"] = lr.ClientIPLocation;
// row["Status"] = lr.Status;
// row["SubStatus"] = lr.SubStatus;
// row["Win32Status"] = lr.Win32Status;
// row["ReceiveBytes"] = lr.ReceiveBytes;
// row["SendBytes"] = lr.SendBytes;
// row["UriStem"] = lr.UriStem;
// row["Referer"] = lr.Referer;
// row["UriStemAlias"] = lr.UriStemAlias;
// row["RefererAlias"] = lr.RefererAlias;
// row["UserAgentAlias"] = lr.UserAgentAlias;
// row["UserAgent"] = lr.UserAgent;
// dt.Rows.Add(row);
//}
//IISLogExportToDB exporter = new IISLogExportToDB(dt);
IISLogExportToDB exporter = new IISLogExportToDB(list);
exporter.ShowDialog();
}
private void menuItemExportToDB_Click(object sender, EventArgs e)
{
IList<LogRecord> list = dataGridView1.DataSource as IList<LogRecord>;
if (list == null || list.Count == 0) return;
//DataTable dt = new DataTable("IISLogData");
//dt.Columns.Add("LogTime", typeof(string));
//dt.Columns.Add("Method", typeof(string));
//dt.Columns.Add("ClientIP", typeof(string));
//dt.Columns.Add("ClientIPLocation", typeof(string));
//dt.Columns.Add("Status", typeof(string));
//dt.Columns.Add("SubStatus", typeof(string));
//dt.Columns.Add("Win32Status", typeof(string));
//dt.Columns.Add("ReceiveBytes", typeof(string));
//dt.Columns.Add("SendBytes", typeof(string));
//dt.Columns.Add("UriStem", typeof(string));
//dt.Columns.Add("Referer", typeof(string));
//dt.Columns.Add("UriStemAlias", typeof(string));
//dt.Columns.Add("RefererAlias", typeof(string));
//dt.Columns.Add("UserAgentAlias", typeof(string));
//dt.Columns.Add("UserAgent", typeof(string));
//foreach (LogRecord lr in list)
//{
// DataRow row = dt.NewRow();
// row["LogTime"] = lr.LogTime.ToString();
// row["Method"] = lr.Method;
// row["ClientIP"] = lr.ClientIP;
// row["ClientIPLocation"] = lr.ClientIPLocation;
// row["Status"] = lr.Status;
// row["SubStatus"] = lr.SubStatus;
// row["Win32Status"] = lr.Win32Status;
// row["ReceiveBytes"] = lr.ReceiveBytes;
// row["SendBytes"] = lr.SendBytes;
// row["UriStem"] = lr.UriStem;
// row["Referer"] = lr.Referer;
// row["UriStemAlias"] = lr.UriStemAlias;
// row["RefererAlias"] = lr.RefererAlias;
// row["UserAgentAlias"] = lr.UserAgentAlias;
// row["UserAgent"] = lr.UserAgent;
// dt.Rows.Add(row);
//}
//IISLogExportToDB exporter = new IISLogExportToDB(dt);
IISLogExportToDB exporter = new IISLogExportToDB(list);
exporter.ShowDialog();
}
