public static int[] ImportMembers(string table, string filePath) { int[] successFail = new int[2]; //Read form file try { // Open the text file using a stream reader. using (StreamReader sr = new StreamReader(filePath, Encoding.UTF8)) { // Read the stream to a string, and write the string to the console. String line = sr.ReadLine(); string[] columns = line.Split('\t'); int columnCount = columns.Length; string[] rows; while ((line = sr.ReadToEnd()) != null) { rows = line.Split('\t'); try { SQLInsertCommandModel insert = new SQLInsertCommandModel() { Table = table, Columns = columns, Data = rows }; SQLCommandController.InsertInto(insert); successFail[0]++; } catch (Exception) { successFail[1]++; } } } } catch (Exception e) { MessageBox.Show(e.Message); } return(successFail); }
private void applyButton_Click(object sender, EventArgs e) { dataSet.Tables.Clear(); SQLSelectCommandModel command = new SQLSelectCommandModel(); command.Columns = "*"; command.Table = "Member"; setFilterDataCommnadText(ref command); setSortDataCommandText(ref command); dataSet.Tables.Add(SQLCommandController.SelectFrom(command, "Member")); dataSet.Tables.Add(SuretyController.GetSureties()); report.SetDataSource(dataSet); crystalReportViewer.ReportSource = report; filterSortSlidePanel.IsOpen = false; }
public BookReportViewerForm() { InitializeComponent(); filterSortSlidePanel.IsOpen = false; SQLSelectCommandModel command = new SQLSelectCommandModel(); command.Table = "Book"; command.Columns = "*"; DataSet dataSet = new DataSet(); DataTable table = SQLCommandController.SelectFrom(command, "Book"); dataSet.Tables.Add(table); BookReport report = new BookReport(); report.SetDataSource(dataSet); crystalReportViewer.ReportSource = report; }