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