public DeletePlaylist(Form1 form, DataSet1 dataset, AxWindowsMediaPlayer mp) { InitializeComponent(); this.otherForm = form; this.dataset = dataset; manager = new PlayListManager(dataset); this.mp = mp; }
private void Frm_ThongKe_Load(object sender, EventArgs e) { //1 reset report this.rpv_BaoCao.Reset(); //2 format report rpv_BaoCao.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.Normal); rpv_BaoCao.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; rpv_BaoCao.ZoomPercent = 100; //config DataSet1 dataset = new DataSet1(); dataset.BeginInit(); this.rpv_BaoCao.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", dataset.Tables["DtHoaDon"])); this.rpv_BaoCao.LocalReport.ReportPath = "../../rptReportHoaDon.rdlc"; this.rpv_BaoCao.Location = new System.Drawing.Point(0, 0); dataset.EndInit(); DataSet1TableAdapters.DtHoaDonTableAdapter DTHoaDon = new DataSet1TableAdapters.DtHoaDonTableAdapter(); DTHoaDon.Connection.ConnectionString = HDon_PTA.sChuoiKetNoi(); DTHoaDon.ClearBeforeFill = true; if (sDk != "") DTHoaDon.FillBy(dataset.DtHoaDon, sDk); else DTHoaDon.Fill(dataset.DtHoaDon); this.rpv_BaoCao.RefreshReport(); }
public static DataSet1 LoadData(DataSet1 dataSet1) { if (dataSet1.Tables.Contains("MainProjects") && dataSet1.Tables.Contains("PartProjects")) { DataTable dtMain; DataTable dtPart; dtMain = dataSet1.Tables["MainProjects"]; dtPart = dataSet1.Tables["PartProjects"]; dtMain.Rows.Add(1, "TestProject"); var startDate = new DateTime(2016, 01, 18); var nextDate1 = NextAvailDate(startDate, 6, true); var endDate1 = EndDate(nextDate1, true); var nextDate2 = EndDate(endDate1.AddDays(1), false); var endDate2 = NextAvailDate(nextDate2.AddDays(-1), 5, false); var nextDate3 = EndDate(endDate2.AddDays(1), true); var endDate3 = NextAvailDate(nextDate3.AddDays(-1),1, true); dtPart.Rows.Add(1, 1, "Delmål1", startDate, 6, true, endDate1); dtPart.Rows.Add(2, 1, "Delmål2", nextDate2, 5, false, endDate2); dtPart.Rows.Add(3, 1, "Delmål3", nextDate3, 1, true, endDate3); } return dataSet1; }
//-------------------------------------------- private DataTable getData() { IDictionary<string, List<string>> LoadedImgFiles = (IDictionary<string, List<string>>)Session["LoadedIamges"]; DataSet1 ds = new DataSet1(); DataTable dt = ds.Tables[0]; for (int i = 0; i < LoadedImgFiles.Count; i ++) { DataRow dr = dt.NewRow(); var pair = LoadedImgFiles.ElementAt(i); //tr.Cells.Add(AddImage(pair.Key.ToString(), pair.Value.ToString())); //if (i < LoadedImgFiles.Count - 1) //{ // pair = LoadedImgFiles.ElementAt(i + 1); // tr.Cells.Add(AddImage(pair.Key.ToString(), pair.Value.ToString())); //} dr["FilePath"] = "http://" + System.Web.HttpContext.Current.Request.Url.Authority + "/uploads/" + pair.Key.ToString(); dr["Description"] = dr["FilePath"]; dt.Rows.Add(dr); } return dt; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack && !GridWeb1.IsPostBack) { // Create dataset object this.dataSet11 = new DataSet1(); // Create web worksheet object WebWorksheet sheet = GridWeb1.WebWorksheets[0]; // Specifies the datasource for the sheet. sheet.DataSource = dataSet11; sheet.DataMember = "Products"; // Creates in-sheet column headers. sheet.EnableCreateBindColumnHeader = true; // Data cells begin at row 1; sheet.BindStartRow = 1; // Creates the data field column automatically. sheet.CreateAutoGenratedColumns(); // Modifies a column's number type. sheet.BindColumns["UnitPrice"].NumberType = NumberType.Currency3; // The "product name" field is required. Aspose.Cells.GridWeb.Validation v = new Aspose.Cells.GridWeb.Validation(); v.IsRequired = true; sheet.BindColumns["ProductName"].Validation = v; // Modifies column headers' background color. for (int i = 0; i < sheet.BindColumns.Count; i++) { sheet.BindColumns[i].ColumnHeaderStyle.BackColor = Color.SkyBlue; } // Create demo database object ExampleDatabase db = new ExampleDatabase(); // Create path to database file string path = (this.Master as Site).GetDataDir(); // Create connection string db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Miscellaneous\\Database\\demos.mdb"; try { // Loads data from database. db.oleDbDataAdapter1.Fill(dataSet11); } finally { // Close connection db.oleDbConnection1.Close(); } // Binding. sheet.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { DataSet1 dsOrder = new DataSet1(); DataTable dtOrder = dsOrder.Tables[0]; dtOrder.Rows.Add("lideng", "125", "M", "1"); dtOrder.Rows.Add("lideng1", "13", "M", "1"); dtOrder.Rows.Add("lideng2", "14", "M", "2"); dtOrder.Rows.Add("lideng3", "15", "M", "2"); DataSetLine dsOrderLine = new DataSetLine(); DataTable dtOrderLine = dsOrderLine.Tables[0]; dtOrderLine.Rows.Add("11", "Desc", "33", "GST1", "1"); dtOrderLine.Rows.Add("11", "Desc", "33", "GST1", "1"); dtOrderLine.Rows.Add("22", "Desc", "44", "GST2", "2"); dtOrderLine.Rows.Add("22", "Desc", "44", "GST2", "2"); ReportDataSource rds = new ReportDataSource("DataSet1", dtOrder); ReportDataSource reportDataSource = new ReportDataSource("DataSet2", dtOrderLine); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(rds); ReportViewer1.LocalReport.DataSources.Add(reportDataSource); ReportViewer1.LocalReport.Refresh(); }
public ListViewItem ToItem(DataSet1.PlaylistRow row) { ListViewGroup in_group = null; string group_name = (row.artist ?? "") + " - " + (row.album ?? ""); foreach (ListViewGroup group in listViewTracks.Groups) { if (group.Name == group_name) { in_group = group; break; } } if (in_group == null) { in_group = new ListViewGroup(group_name, group_name); listViewTracks.Groups.Add(in_group); } int iconIndex = _icon_mgr.GetIconIndex(new FileInfo(row.path), true); ListViewItem item = new ListViewItem(row.title, iconIndex); TimeSpan Length = TimeSpan.FromSeconds(row.length); string lenStr = string.Format("{0:d}.{1:d2}:{2:d2}:{3:d2}", Length.Days, Length.Hours, Length.Minutes, Length.Seconds).TrimStart('0', ':', '.'); item.SubItems.Add(new ListViewItem.ListViewSubItem(item, lenStr)); item.Group = in_group; item.Tag = row; return item; }
/// <summary> /// 增加 /// </summary> public void add() { System.Text.StringBuilder list = new System.Text.StringBuilder(); DataSet ds = new DataSet1(); ds.ReadXml(Server.MapPath("work.xml")); DataRow row = ds.Tables[0].NewRow(); row["cname"] = Request.QueryString["cname"]; row["cmoney"] = Request.QueryString["cmoney"]; row["mark"] = Request.QueryString["mark"]; ds.Tables[0].Rows.Add(row); ds.WriteXml(Server.MapPath("work.xml")); DataSet dss = new DataSet1(); dss.ReadXml(Server.MapPath("work.xml")); int ircount = dss.Tables[0].Rows.Count; int maxid = 0; for (int i = 0; i < ircount; i++) { if (Convert.ToInt32(dss.Tables[0].Rows[i][0]) > maxid) { maxid = Convert.ToInt32(dss.Tables[0].Rows[i][0]); } } list.Append("<tr id='d" + maxid + "'>"); list.Append("<td><a href='javascript:del(" + maxid.ToString() + ")'>删除</a></td>"); list.Append("<td>"+Request.QueryString["cname"]+"</td>"); list.Append("<td>" + Request.QueryString["cmoney"] + "</td>"); list.Append("<td>" + Request.QueryString["mark"] + "</td></tr>"); Response.Write(list.ToString()); Response.End(); }
public Edit(DataSet1.recordDataRow row) { InitializeComponent(); idLoaded = row.id; RecordRow = dataSet1.recordData.NewrecordDataRow(); this.relationBox.Text=row.relation; this.titleText.Text=row.title; this.fnameText.Text=row.first_name; this.midnameText.Text=row.mid_name; this.lnameText.Text=row.last_name; this.nickText.Text=row.nickname; if(row.sex == "Male"){male.Checked=true;} else { female.Checked = true; }; if (row.birthdate != null) { this.dateTimePicker1.Checked = true; this.dateTimePicker1.Value = System.DateTime.Parse(row.birthdate); } this.noteText.Text=row.note; this.pictureBox1.ImageLocation=row.photo; this.pictureBox1.Image= new Bitmap(row.photo); this.pictureBox1.SizeMode=PictureBoxSizeMode.StretchImage; this.pcityText.Text=row.pcity; this.paddressText.Text=row.paddress; this.pzipText.Text=row.pzip; if (((row.scity.Length>0) || (row.sddress.Length>0)) || ((row.szip.Length > 0) || (row.sstate.Length > 0))) { this.checkGroupBox2.Checked = true; this.groupBox2.Enabled = true; this.pstateText.Text = row.pstate; this.scityText.Text = row.scity; this.saddText.Text = row.sddress; this.szipText.Text = row.szip; this.sstateText.Text = row.sstate; } this.num1.Text=row.num1; this.num2.Text=row.num2; this.num3.Text=row.num3; this.num4.Text=row.num4; this.num5.Text=row.num5; this.num6.Text=row.num6; this.num1Text.Text=row.nnum1; this.num2Text.Text=row.nnum2; this.num3Text.Text=row.nnum3; this.num4Text.Text=row.nnum4; this.num5Text.Text=row.nnum5; this.num6Text.Text=row.nnum6; this.emailText.Text=row.email; this.webText.Text=row.web; this.wpositionText.Text=row.wposition; this.wcopmanyText.Text=row.wcompany; this.waddressText.Text=row.waddress; this.wcityText.Text=row.wcity; this.wzipText.Text=row.wzip; this.wtelText.Text=row.wtelephone; this.wemailText.Text=row.wemail; this.wwebText.Text = row.wweb; }
private bool IsWinnerExpected(int winnerId, DataSet1.playerRow playerA, DataSet1.playerRow playerB) { if (playerA.currentPoints >= playerB.currentPoints && winnerId == playerA.Id || playerB.currentPoints >= playerA.currentPoints && winnerId == playerB.Id) return true; else return false; }
// Konstruktor public TZBForm() { InitializeComponent(); ds = new DataSet1(); dataGridView1.DataSource = ds.Tables["DataTable1"]; num = ComboBox1.SelectedIndex; }
public void showValues() { DataSet1 set = new DataSet1(); adapter.Fill(set.DataTable2); DataRow [] arrRow = set.DataTable2.Select("fname = 'arif'"); DataRow row = arrRow[0]; Console.WriteLine(row[1]); }
private void LoadDataSource() { //SortBy is required. if (string.IsNullOrEmpty(dgv1.SortBy)) dgv1.SortBy = DEFAULT_SORT; DataSet1 ds = new DataSet1(); var dt = Class1.GetData(TABLE_NAME, dgv1.PageSize, dgv1.PageNumber, SEARCH_FIELD, dgv1.SearchEntry, dgv1.SortBy); dgv1.DataSource = dt; }
protected void Button1_Click(object sender, EventArgs e) { SqlDataAdapter da = new SqlDataAdapter("insert into feedback (us,feedback)values(@user,@feedback)", cn); da.SelectCommand.Parameters.AddWithValue("@user", Session["email_id"].ToString()); da.SelectCommand.Parameters.AddWithValue("@feedback", TextBox1.Text); DataSet1 ds = new DataSet1(); da.Fill(ds); // cn.Close(); }
public frmMain() { InitializeComponent(); a1 = new ArrayList(); a2 = new ArrayList(); a3 = new ArrayList(); d = new ArrayList(); config = new ArrayList(); ds = new DataSet1(); browserListe = new ArrayList(); bs = new BindingSource(); datasetVersion = "1.0.0"; }
private void XtraReport1_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { DataSet1TableAdapters.CategoriesTableAdapter da = new DataSet1TableAdapters.CategoriesTableAdapter(); DataSet1 ds = new DataSet1(); da.Fill(ds.Categories); DataSource = ds.Categories; xrLabel2.Text = "[CategoryName]"; xrLabel3.Text = "[Description]"; xrPictureBox1.DataBindings.Add("Image", null, "Picture"); }
protected void Page_Load(object sender, EventArgs e) { SqlConnection con =new SqlConnection(); con.ConnectionString = "Data Source=LALITHA-PC;Initial Catalog=LSR;Integrated Security=True"; con.Open(); SqlDataAdapter da = new SqlDataAdapter("select customerID,salutation,fname,lname,state_address,email from Customer",con); DataSet1 dt = new DataSet1(); da.Fill(dt, "Customer"); CrystalReportSource1.ReportDocument.SetDataSource(dt.Tables[0]); }
public void GetAll() { DataSet1 dataSet = BL.getPositions(); List <DataRow> list = dataSet.position_in_mat_delivery_note.Select().OfType <DataRow>().ToList(); list.Sort((x, y) => ((int)x["id_"]).CompareTo((int)y["id_"])); //сортируем по ид Assert.That(1, Is.EqualTo(1)); Assert.That(list.Count, Is.EqualTo(5)); Assert.That((int)(list[0]["id_"]), Is.EqualTo(1)); Assert.That((double)(list[0]["amount"]), Is.EqualTo(10)); Assert.That((int)(list[0]["invoice_id"]), Is.EqualTo(1)); }
private void botoneraImpCancel1_Click_IMP(object sender, EventArgs e) { try { //*********************IMAGEN PROGRESS BAR********************** picProgresBar.Visible = true; botoneraImpCancel1.Visible = false; //******************************************************* if (dgvGrilla.DataSource != null) { VISTA.DataSet1 dsDatos = new DataSet1(); //CREO EL DATATABLE EN MEMORIA DataTable tabla = new DataTable(); //FILTRO LOS QUE ESTAN TILDADOS PARA IMPRIMIR var colIMPRIMIR = (from entity in ListProductoImprimir where entity.IMPRIMIR == true select entity).ToList(); foreach (var producto in colIMPRIMIR) { DataRow NuevaFila = dsDatos.Tables["ProductosFaltantes"].NewRow(); NuevaFila["Descipcion"] = producto.PRO_DESCRIPCION; NuevaFila["CodBarra"] = producto.PRO_BARRAS; NuevaFila["Categoria"] = producto.CATEGORIA_PRODUCTO.CAT_DESCRIPCION; NuevaFila["Costo"] = "$ " + producto.PRO_COSTO; NuevaFila["CantidadEnStock"] = producto.PRO_STOCKACTUAL; NuevaFila["CantidadMinima"] = producto.PRO_STOCKMINIMO; dsDatos.Tables["ProductosFaltantes"].Rows.Add(NuevaFila); } string TipoInfo = "PRODUCTOSFALTANTES"; frmINFORMES form = new frmINFORMES(dsDatos.Tables["ProductosFaltantes"], TipoInfo); form.Show(); } //*********************IMAGEN PROGRESS BAR********************** picProgresBar.Visible = false; botoneraImpCancel1.Visible = true; //******************************************************* } catch (Exception ex) { ProcesarExcepcion(ex); } }
private void BindWithInSheetHeaders() { // Create dataset object this.dataSet11 = new DataSet1(); // Create database object ExampleDatabase db = new ExampleDatabase(); // Create path to database file string path = (this.Master as Site).GetDataDir(); // Create connection string db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Miscellaneous\\Database\\demos.mdb"; try { // Connects to database and fetches data. db.oleDbDataAdapter1.Fill(dataSet11); // Create webworksheet object WebWorksheet sheet = GridWeb1.WebWorksheets[0]; // Clears the sheet. sheet.Cells.Clear(); // Enables creating in-sheet headers. sheet.EnableCreateBindColumnHeader = true; // Data cells begin from row 2. sheet.BindStartRow = 2; // Creates some title cells. sheet.Cells["A1"].PutValue("The Product Table"); sheet.Cells["A1"].GetStyle().Font.Size = new FontUnit("20pt"); sheet.Cells["A1"].GetStyle().HorizontalAlign = HorizontalAlign.Center; sheet.Cells["A1"].GetStyle().VerticalAlign = VerticalAlign.Middle; sheet.Cells["A1"].GetStyle().BackColor = Color.SkyBlue; sheet.Cells["A1"].GetStyle().ForeColor = Color.Blue; sheet.Cells.Merge(0, 0, 2, 11); // Freezes the header rows. sheet.FreezePanes(3, 0, 3, 0); // Bind the sheet to the dataset. sheet.DataBind(); } finally { //Close connection db.oleDbConnection1.Close(); } }
private void IPDPatientTreatmentSheet_Load(object sender, EventArgs e) { if (IPDPatientTreatmentSheetGuid != Guid.Empty) { DataSet1 ds = new DataSet1(); Hospital.Reports.IPDPatientTreatmentSheetDetails objIPDPatientTreatmentSheetDetailsRpt = new Reports.IPDPatientTreatmentSheetDetails(); TextObject txtPatientName = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtPatientName"] as TextObject; TextObject txtIPDNo = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtIPDNo"] as TextObject; TextObject txtInchargeDoctor = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtInchargeDoctor"] as TextObject; TextObject txtDiagnosis = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtDiagnosis"] as TextObject; // TextObject txtTreatmentDate = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtTreatmentDate"] as TextObject; TextObject txtDietAdvice = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtDietAdvice"] as TextObject; TextObject txtSOSDrug = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtSOSDrug"] as TextObject; TextObject txtSpecialAdvice = objIPDPatientTreatmentSheetDetailsRpt.ReportDefinition.ReportObjects["txtSpecialAdvice"] as TextObject; // if (PatientGuid != Guid.Empty) { objPatient = new Patient(PatientGuid); if (objPatient != null) { txtIPDNo.Text = objPatient.PatientIndoorNo.ToString(); txtPatientName.Text = objPatient.DisplayName; txtInchargeDoctor.Text = objPatient.PatientDoctorIncharge; txtDiagnosis.Text = objPatient.PatientFinalDiagnosis; } } objTreatmentSheet = new IPDPatientTreatmentSheet(IPDPatientTreatmentSheetGuid); if (objTreatmentSheet != null) { txtDietAdvice.Text = objTreatmentSheet.DiatAdvice; txtSOSDrug.Text = objTreatmentSheet.SOSDrug; txtSpecialAdvice.Text = objTreatmentSheet.SpecialAdvice; txtTreatmentDate.Text = Common.DateToString(objTreatmentSheet.SheetDate); } var obj = Report.GetIPDPatientTreatmentSheetDetailsReport(IPDPatientTreatmentSheetGuid); ds.Tables["IPDPatientTreatmentSheetDetails"].Merge(obj); var objVital = Report.GetIPDPatientVitalsByDate(PatientGuid, objTreatmentSheet.SheetDate); ds.Tables["PatientVitalDetails"].Merge(objVital); ReportDocument reportdocument = new ReportDocument(); objIPDPatientTreatmentSheetDetailsRpt.SetDataSource(ds); IPDPatientTreatmentSheet.ReportSource = objIPDPatientTreatmentSheetDetailsRpt; } }
public static DataSet1 get_repot(string no_invoice) { DataSet1 ds = new DataSet1(); try { using (var db = new Models.jotunContext()) { db.Database.Connection.Open(); using (var cmd = db.Database.Connection.CreateCommand()) { cmd.CommandText = string.Format("select * from invoice where no_invoice = '{0}'", no_invoice); cmd.CommandType = System.Data.CommandType.Text; using (var reader = cmd.ExecuteReader()) { var dt = new System.Data.DataTable(); dt.Load(reader); ds.Tables["invoice"].Merge(dt); } cmd.CommandText = string.Format("select * from detail_invoice where no_invoice = '{0}'", no_invoice); cmd.CommandType = System.Data.CommandType.Text; using (var reader = cmd.ExecuteReader()) { var dt = new System.Data.DataTable(); dt.Load(reader); ds.Tables["detail_invoice"].Merge(dt); } string[] tables = new string[] { "barang", "customer", "surat_jalan", "po" }; foreach (var table in tables) { cmd.CommandText = string.Format("select * from {0}", table); cmd.CommandType = System.Data.CommandType.Text; using (var reader = cmd.ExecuteReader()) { var dt = new System.Data.DataTable(); dt.Load(reader); ds.Tables[table].Merge(dt); } } } } } catch (Exception ex) { Helpers.Generic.MsgError(ex.Message); } return(ds); }
public static DataSet1 get_report(string kolom, string param) { DataSet1 result = new DataSet1(); kolom = kolom.ToLower(); string sql = "select * from karyawan where "; if (kolom.Contains("kode")) { sql += string.Format("kd_karyawan like '%{0}%'", param); } else if (kolom.Contains("nama")) { sql += string.Format("nama like '%{0}%'", param); } else if (kolom.Contains("alamat")) { sql += string.Format("alamat like '%{0}%'", param); } else if (kolom.Contains("email")) { sql += string.Format("email like '%{0}%'", param); } else if (kolom.Contains("akses")) { sql += string.Format("hak_akses like '%{0}%'", param); } try { using (var db = new Models.sim_penjualanContext()) { db.Database.Connection.Open(); using (var cmd = db.Database.Connection.CreateCommand()) { cmd.CommandText = sql; cmd.CommandType = System.Data.CommandType.Text; using (var reader = cmd.ExecuteReader()) { var dt = new System.Data.DataTable(); dt.Load(reader); result.Tables["karyawan"].Merge(dt); } } } } catch (Exception ex) { Helpers.Generic.MsgError(ex.Message); } return(result); }
public void RelatorioAcompanhamento() { DRFormAguarde.ExecuteFormWait("Gerando Relatório", "Acompanhamento "); using (DataSet1 ds = ServerDR.GetAcompanhamentoPeriodo(DRProjetoContext.DRProjeto.CodProjeto, dtini, dtfim, checkBox1.Checked)) { if (ds.DRACOMPANHAMENTO.Rows.Count == 0) { DRFormAguarde.FormAguarde.FinalizaAguarde(); MessageBox.Show("Não foi encontrado nenhuma informação!"); return; } DataRow rowEmp = ServerDR.GetInfoEmpresa(); string caminho; DRRelatorisClass.LoadLogoRel(rowEmp, out caminho); string titulo = GetTitulo(); decimal totPrevisto; decimal totDespesaAnterior; decimal totDespesaAtual; ServerDR.GetTotalizadores(DRProjetoContext.DRProjeto.CodProjeto, dtini, dtfim, out totPrevisto, out totDespesaAnterior, out totDespesaAtual); decimal totDespesa = totDespesaAnterior + totDespesaAtual; DRFormAguarde.FormAguarde.FinalizaAguarde(); using (DRViewRel rel = new DRViewRel()) { Microsoft.Reporting.WinForms.ReportParameter[] parametros = { new Microsoft.Reporting.WinForms.ReportParameter("P_OBRA", "Obra: " + DRProjetoContext.DRProjeto.NomeProjeto), new Microsoft.Reporting.WinForms.ReportParameter("ImageLogo", caminho), new Microsoft.Reporting.WinForms.ReportParameter("Endereco", DRRelatorisClass.GetEndereco(rowEmp)), new Microsoft.Reporting.WinForms.ReportParameter("NomeEmpresa", rowEmp["NOME"].ToString()), new Microsoft.Reporting.WinForms.ReportParameter("TITULO", titulo), new Microsoft.Reporting.WinForms.ReportParameter("TotalDespesa", totDespesa.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("TotalPrevisto", totPrevisto.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("TotDespesaAtual", totDespesaAtual.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("TotDespesaAnterior", totDespesaAnterior.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("Observacao", txtObs.Text) }; rel.ExecuteRel(ds.DRACOMPANHAMENTO, "DataSet1_DRACOMPANHAMENTO", "DRRelAcompanhamento.rdlc", parametros); } DRRelatorisClass.DeleteImageLogo(); } }
private void DischargeSummeryReportForm_Load(object sender, EventArgs e) { DataSet1 ds = new DataSet1(); var obj = Report.GetDischargeSummeryReport(PatientGuid); var objtre = Report.GetDischargeTreatmentRpt(PatientGuid); ds.Tables["DischargeSummery"].Merge(obj); ds.Tables["DischargeTreatment"].Merge(objtre); objrpt = new Reports.DischargeSummeryReport(); ReportDocument reportdocument = new ReportDocument(); objrpt.SetDataSource(ds); DischargeSummeryReportForm.ReportSource = objrpt; }
public void GetAll() { DataSet1 dataSet = BL.getUnits(); List <DataRow> list = dataSet.unit_of_measurement.Select().OfType <DataRow>().ToList(); list.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"])); //сортируем по ид Assert.That(list.Count, Is.EqualTo(15)); Assert.That((int)(list[0]["id"]), Is.EqualTo(4)); Assert.That((string)(list[0]["unit_name"]), Is.EqualTo("Миллиметр")); Assert.That((string)(list[0]["code"]), Is.EqualTo("003")); Assert.That((string)(list[0]["national_symbol"]), Is.EqualTo("мм")); }
private void button2_Click(object sender, EventArgs e) { string cell = dataGridView1.CurrentRow.Cells[5].Value.ToString(); DialogResult result = MessageBox.Show("Вы действительно хотите удалить эту запись?", "Вопрос", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { DataSet1 newDataSet1 = new DataSet1(); DataSet1TableAdapters.workerTableAdapter workerTA = new DataSet1TableAdapters.workerTableAdapter(); workerTA.DeleteQuery(Convert.ToInt32(cell)); WorkerViewForm_Activated(sender, e); } }
private void View_Load(object sender, EventArgs e) { con.ConnectionString = @"Data Source=DESKTOP-U9D8BHS\YASIR;Initial Catalog=INFOEMP;Integrated Security=True "; string sql = "SELECT Table_1.Employee_ID, Table_1.Full_Name, Table_1.Job, Table_1.Job_Degree, Table_1.First_job_Date, Table_1.Department, Table_2.Birth_Date, Table_2.Birth_Place, Table_1.Working_Years, Table_1.Place_Of_working, Table_2.Card_Number, Table_2.Gavernatore, Table_2.Relajon, Table_2.Street FROM Table_1 INNER JOIN Table_2 ON Table_1.Employee_ID = Table_2.Information_ID"; DataSet1 ds = new DataSet1(); SqlDataAdapter dad = new SqlDataAdapter(sql, con); dad.Fill(ds.Tables["OrderTable"]); CryOrder ord = new CryOrder(); ord.SetDataSource(ds.Tables["OrderTable"]); crystalReportViewer1.ReportSource = ord; crystalReportViewer1.Refresh(); }
public void GetAll() { DataSet1 dataSet = BL.getInvoices(); List <DataRow> list = dataSet.invoice.Select().OfType <DataRow>().ToList(); list.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"])); //сортируем по ид Assert.That(1, Is.EqualTo(1)); Assert.That(list.Count, Is.EqualTo(2)); Assert.That((int)(list[0]["id"]), Is.EqualTo(1)); Assert.That((string)(list[0]["invoice_number"]), Is.EqualTo("000001")); Assert.That((int)(list[0]["organization_id"]), Is.EqualTo(2)); }
private void View_Load(object sender, EventArgs e) { con.ConnectionString = @"Data Source=DESKTOP-U9D8BHS\YASIR;Initial Catalog=INFOEMP;Integrated Security=True "; string sql = "SELECT Table_1.Employee_ID,Table_1.Full_Name,Table_1.Job,Table_1.Job_Degree,Table_1.Sex,Table_1.First_job_Date, Table_1.Department, Table_1.Working_Years, Table_1.Place_Of_working, Table_2.Birth_Date, Table_2.Birth_Place, Table_2.Name_of_presonal_card_Office, Table_2.Number_Of_File_Card,Table_2.Number_Of_Page_Card,Table_2.Card_Number,Table_2.Sertificate_Number,Table_2.Sertificate_Issuse_Date,Table_2.Marride_State,Table_2.Total_Children,Table_2.Food_Card_Number,Table_2.Gavernatore,Table_2.Relajon,Table_2.Street,Table_2.House,Table_2.Mobile_Number FROM Table_1 INNER JOIN Table_2 ON Table_1.Employee_ID = Table_2.Information_ID WHERE Table_1.Employee_ID = " + x; DataSet1 ds = new DataSet1(); SqlDataAdapter dad = new SqlDataAdapter(sql, con); dad.Fill(ds.Tables["OrdarTable"]); Order ord = new Order(); ord.SetDataSource(ds.Tables["OrdarTable"]); crystalReportViewer1.ReportSource = ord; crystalReportViewer1.Refresh(); }
protected void fillexamtypes() { strsql = "select strexamtype from tblexamschedule where intschool=" + Session["SchoolID"] + " group by strexamtype"; DataAccess da = new DataAccess(); DataSet ds = new DataSet(); ds = da.ExceuteSql(strsql); ddlexamtype.DataSource = ds; ddlexamtype.DataTextField = "strexamtype"; ddlexamtype.DataValueField = "strexamtype"; ddlexamtype.DataBind(); ddlexamtype.Items.Insert(0, "-Select-"); ddlexamtype.Items.Insert(1, "All"); }
//string CCon = ConfigurationManager.AppSettings["ConnectionString"].ToString(); protected void Page_Load(object sender, EventArgs e) { CrystalReportViewer1.DisplayGroupTree = false; RD = new ReportDocument(); ReportID = Request.QueryString["ReportID"]; if (ReportID == "PartItemLedger") { string StrToDateFrom = "", StrDateTo = ""; RD = new ReportDocument(); dsrpt = new DataSet1(); // PartItemLedger.sp_ItemStockLedger_select.Load(ds.CreateDataReader()); DataSet ds = new DataSet(); //DataSet ds1 = new DataSet(); StrToDateFrom = Request.QueryString["FromDate"]; StrDateTo = Request.QueryString["ToDate"]; SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@FromPartCode", SqlDbType.VarChar, 50), //0 new SqlParameter("@ToPartCode", SqlDbType.VarChar, 50), //0 new SqlParameter("@OpeningDate", SqlDbType.VarChar, 10), //0 new SqlParameter("@ToDate", SqlDbType.VarChar, 10), //0 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = Request.QueryString["FromCode"].ToString(); param[2].Value = Request.QueryString["ToCode"].ToString(); param[3].Value = Convert.ToDateTime(StrToDateFrom).ToString("yyyy-MM-dd"); param[4].Value = Convert.ToDateTime(StrDateTo).ToString("yyyy-MM-dd"); ObjSysFunc.ExecuteSP_NonQuery("sp_PartItemLedger", param); ds = SqlHelper.ExecuteDataset(CConnection.GetConnectionString(), CommandType.Text, "sp_tempItemStockLedger_Select '" + Session["DealerCode"].ToString() + "'"); //dsrpt.sp_tempItemStockLedger_Select.Load(ds.CreateDataReader()); RD.Load(base.Server.MapPath("rptItemStockLedger.rpt")); //RD.Load(base.Server.MapPath("rptLedger.rpt")); RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserName"].ToString() + "'"; RD.DataDefinition.FormulaFields["FromCode"].Text = "\"" + Convert.ToDateTime(Request.QueryString["FromDate"].ToString()).ToString("dd/MM/yyyy") + "\""; RD.DataDefinition.FormulaFields["ToCode"].Text = "\"" + Convert.ToDateTime(Request.QueryString["ToDate"].ToString()).ToString("dd/MM/yyyy") + "\""; RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'"; RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "ITEM STOCK LEDGER REPORT" + "\""; RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; // RD.SetDataSource(dsrpt.sp_tempItemStockLedger_Select.DataSet); } CrystalReportViewer1.ReportSource = RD; }
public PassportMKD() { InitializeComponent(); ds = new DataSet1(); elHouseAdapter = new ElHouseTableAdapter(); elHouseParamAdapter = new ElHouseParamsTableAdapter(); // elHouseFlatsAdapter = new ElHouseFlatsTableAdapter(); // elHouseNoflatsAdapter = new ElHouseNoflatsTableAdapter(); porchAdapter = new PorchTableAdapter(); pomeschAdapter = new PomeschenieTableAdapter(); }
protected void btnLogin_Click(object sender, EventArgs e) { string email = tbemail.Text; string pwd = tbpwd.Text; DataSet1 ds = new DataSet1(); DataSet1TableAdapters.UsersTableTableAdapter taUser = new DataSet1TableAdapters.UsersTableTableAdapter(); taUser.Fill(ds.UsersTable); DataRow[] dr = ds.UsersTable.Select("Email='" + email + "'"); Users user = new Users(); if (dr.Count() == 0) { Label1.Visible = true; Label1.Text = "User Doesnt exists!! Sign Up first"; } else if ((string)(dr[0]["Password"]) != pwd) { Label1.Visible = true; Label1.Text = "Invalid Password !!!!"; } else if ((string)(dr[0]["UserType"]) == "Employer") { user.FirstName = (string)dr[0]["FirstName"]; user.LastName = (string)dr[0]["LastName"]; user.Password = (string)dr[0]["Password"]; user.userid = (int)dr[0]["userid"]; user.UserType = (string)dr[0]["UserType"]; // if ((string)dr[0]["Skillset"] != null) //{ // user.SkillSet = (string)dr[0]["Skillset"]; // } Session["user"] = user; Session["userid"] = user.userid; Response.Redirect("~/OrganizationSide/OrgShowAllProj.aspx"); } else if ((string)(dr[0]["UserType"]) == "Student") { user.FirstName = (string)dr[0]["FirstName"]; user.LastName = (string)dr[0]["LastName"]; user.Password = (string)dr[0]["Password"]; user.userid = (int)dr[0]["userid"]; user.UserType = (string)dr[0]["UserType"]; Session["student"] = user; Session["message"] = null; Response.Redirect("~/Index.aspx"); } }
private void dailyAttendanceReportToolStripMenuItem_Click(object sender, EventArgs e) { RayedoxVariables.currentReport = "Absentee Monthly Report"; // Absentee Monthly Report frmReportOrderBy frm = new frmReportOrderBy("D"); frm.ShowDialog(); if (frm.orderby != "") { SqlConnection conn = new SqlConnection(RayedoxVariables.connectionstring); SqlCommand cmd; SqlDataAdapter da; DataSet1 ds = new DataSet1(); string stingadd1 = "select * from view_attendance where 1=1" + frm.orderby; conn.Open(); cmd = new SqlCommand(stingadd1, conn); da = new SqlDataAdapter(cmd); da.Fill(ds.tblAttendance); cmd.Dispose(); da.Dispose(); rptDailyAttendance rpt = new rptDailyAttendance(); rpt.SetDataSource(ds); crystalReportViewer1.ReportSource = rpt; crystalReportViewer1.RefreshReport(); cmd.Dispose(); da.Dispose(); conn.Close(); try { try { rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Text, "D:\\Rayedoxreport.txt" + ".txt"); } catch { rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Text, "E:\\Rayedoxreport.txt" + ".txt"); } } catch { rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.Text, "F:\\Rayedoxreport.txt" + ".txt"); } } }
public void printPreview() { string doaFrom, doaTo; // Init selected dates from calendar DateTime?selectedDateFrom = usc_stockout.sortDOAfrom.SelectedDate; DateTime?selectedDateTo = usc_stockout.sortDOAto.SelectedDate; try { if (selectedDateFrom.HasValue || selectedDateTo.HasValue) { // Making a format and getting the value of datepicker to string doaFrom = selectedDateFrom.Value.ToString("yyyy/MM/dd", System.Globalization.CultureInfo.InvariantCulture); doaTo = selectedDateTo.Value.ToString("yyyy/MM/dd", System.Globalization.CultureInfo.InvariantCulture); ReportDataSource rptDataSource; this.ReportViewerStockInHistory.LocalReport.DataSources.Clear(); ReportViewerStockInHistory.LocalReport.ReportEmbeddedResource = "NavigationDrawerPopUpMenu2.Reportstockinhistory.rdlc"; DataSet1 ds = new DataSet1(); conn.Open(); // Open Connection if (reportToPrint == "Select") { query = "SELECT * FROM stock_in WHERE stockinStatus = 'Stock In' ORDER BY stockinItem ASC"; } else if (reportToPrint == "Sort") { query = "SELECT * FROM stock_in WHERE stockinDate BETWEEN '" + doaFrom + "' AND '" + doaTo + "' ORDER BY stockinItem ASC "; // Sort base on the query } MySqlDataAdapter da = conn.DataAdapter(query); da.Fill(ds.Tables["dtStockin"]); conn.Close(); // Close Conn rptDataSource = new ReportDataSource("DataSet1", ds.Tables["dtStockin"]); this.ReportViewerStockInHistory.LocalReport.DataSources.Add(rptDataSource); ReportViewerStockInHistory.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); ReportViewerStockInHistory.ZoomMode = ZoomMode.Percent; ReportViewerStockInHistory.ZoomPercent = 100; } } catch (Exception x) { conn.Close(); MessageBox.Show(x.Message + ", Try again later", "Stock In Report Failed", MessageBoxButton.OK, MessageBoxImage.Warning); } }
private void btnPrint_Click(object sender, EventArgs e) { ObjectId id = ObjectId.Parse(dvBill.SelectedRows[0].Cells[2].Value.ToString()); FilterDefinition <BsonDocument> filter = Builders <BsonDocument> .Filter.Eq("bills._id", id); BsonDocument r = collection.Find(filter).First(); int selectedIndex = dvBill.SelectedRows[0].Index; DataSet1 ds = new DataSet1(); DataRow row; var items = r["bills"][selectedIndex]["items"].AsBsonArray; row = ds.dtReceipt.NewRow(); row["patient_name"] = string.Format("{0} {1} {2}", r["firstname"].ToString(), r["middlename"].ToString(), r["lastname"].ToString()); try { row["address"] = r["address"]; }catch (System.Collections.Generic.KeyNotFoundException ex) { Console.WriteLine(ex.ToString()); } ds.dtReceipt.Rows.Add(row); foreach (var item in items) { row = ds.dtReceipt.NewRow(); row["item"] = item["name"]; row["amount"] = item["amount"]; ds.dtReceipt.Rows.Add(row); } row = ds.dtReceipt.NewRow(); row["total"] = r["bills"][selectedIndex]["total"]; try { row["amount_paid"] = r["bills"][selectedIndex]["paid"]; row["change"] = r["bills"][selectedIndex]["change"]; }catch (System.Collections.Generic.KeyNotFoundException ex) { Console.WriteLine(ex.ToString()); MessageBox.Show("Unpaid"); return; } ds.dtReceipt.Rows.Add(row); new Print.FrmPrintForm(ds, new Print.PrintReceipt()).ShowDialog(); }
public void LoadReport(string pcash, string pchange) { ReportDataSource rptDataSource; try { this.reportViewer1.LocalReport.ReportPath = Application.StartupPath + @"\Reports\Report1.rdlc"; this.reportViewer1.LocalReport.DataSources.Clear(); DataSet1 ds = new DataSet1(); MySqlDataAdapter da = new MySqlDataAdapter(); con.Open(); da.SelectCommand = new MySqlCommand("SELECT c.id, c.transno,c.pcode,c.price,c.qty,c.disc, c.total,c.sdate,c.status, p.pdesc FROM `tblcart` as c INNER JOIN tblproduct as p ON p.pcode = c.pcode where transno like '" + f.lbltransno.Text + "'", con); da.Fill(ds.Tables["dtSold"]); con.Close(); ReportParameter pVatable = new ReportParameter("pVatable", f.lblVatable.Text); ReportParameter pVat = new ReportParameter("pVat", f.lblVat.Text); ReportParameter pDiscount = new ReportParameter("pDiscount", f.lblDiscount.Text); ReportParameter pTotal = new ReportParameter("pTotal", f.lblTotal.Text); ReportParameter pCash = new ReportParameter("pCash", pcash); ReportParameter pChange = new ReportParameter("pChange", pchange); ReportParameter pStore = new ReportParameter("pStore", store); ReportParameter pAddress = new ReportParameter("pAddress", address); ReportParameter pTransaction = new ReportParameter("pTransaction", "Invoice #: " + f.lbltransno.Text); ReportParameter pCashier = new ReportParameter("pCashier", f.lblUsername.Text); reportViewer1.LocalReport.SetParameters(pVatable); reportViewer1.LocalReport.SetParameters(pVat); reportViewer1.LocalReport.SetParameters(pDiscount); reportViewer1.LocalReport.SetParameters(pTotal); reportViewer1.LocalReport.SetParameters(pChange); reportViewer1.LocalReport.SetParameters(pCash); reportViewer1.LocalReport.SetParameters(pStore); reportViewer1.LocalReport.SetParameters(pAddress); reportViewer1.LocalReport.SetParameters(pTransaction); reportViewer1.LocalReport.SetParameters(pCashier); rptDataSource = new ReportDataSource("DataSet1", ds.Tables["dtSold"]); reportViewer1.LocalReport.DataSources.Add(rptDataSource); reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); reportViewer1.ZoomMode = ZoomMode.Percent; reportViewer1.ZoomPercent = 100; } catch (Exception ex) { con.Close(); MessageBox.Show(ex.Message); } }
public XtraReport CreateDataGroupingReport() { // Create a report, and bind it to a data source. XtraReport report = new XtraReport(); DataSet1 ds = new DataSet1(); new DataSet1TableAdapters.OrdersTableAdapter().Fill(ds.Orders); report.DataSource = ds; report.DataMember = "Orders"; // Create a detail band and add it to the report. DetailBand detailBand = new DetailBand(); detailBand.Height = 20; report.Bands.Add(detailBand); // Create a group header band and add it to the report. GroupHeaderBand ghBand = new GroupHeaderBand(); ghBand.Height = 20; report.Bands.Add(ghBand); // Create a calculated field, and add it to the report's collection CalculatedField calcField = new CalculatedField(report.DataSource, report.DataMember); report.CalculatedFields.Add(calcField); // Define its name, field type and expression. // Note that numerous built-in date-time functions are supported. calcField.Name = "dayOfWeek"; calcField.FieldType = FieldType.None; calcField.Expression = "GetDayOfWeek([OrderDate])"; // Define the calculated field as // a grouping criteria for the group header band. GroupField groupField = new GroupField(); groupField.FieldName = "dayOfWeek"; ghBand.GroupFields.Add(groupField); // Create two data-bound labels, and add them to // the corresponding bands. XRLabel ghLabel = new XRLabel(); ghLabel.DataBindings.Add("Text", report.DataSource, "OrderDate", "{0:dddd}"); ghLabel.BackColor = Color.Red; ghBand.Controls.Add(ghLabel); XRLabel detailLabel = new XRLabel(); detailLabel.DataBindings.Add("Text", report.DataSource, "OrderDate", "{0:MM/dd/yyyy}"); detailLabel.ProcessDuplicates = ValueSuppressType.Suppress; detailBand.Controls.Add(detailLabel); return report; }
private void button4_Click(object sender, EventArgs e) { // 環境設定年月の確認 string msg = "処理対象年月は " + global.cnfYear.ToString() + "年 " + global.cnfMonth.ToString() + "月です。よろしいですか?"; if (MessageBox.Show(msg, "勤怠データ作成", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.No) { return; } bool hol = true; Hide(); if (getHoldData() > 0) { // 保留データ選択 OCR.frmFaxSelect frmH = new OCR.frmFaxSelect(); frmH.ShowDialog(); hol = frmH.myBool; // 中止のとき:false frmH.Dispose(); } if (hol) { /* 出勤簿フォームを開く前に処理可能な出勤簿データがあるか確認してなければ終了する * // 2017/10/24 * // CSVファイル数をカウント */ int n = System.IO.Directory.GetFiles(Properties.Settings.Default.dataPath, "*.csv").Count(); DataSet1 dts = new DataSet1(); DataSet1TableAdapters.勤務票ヘッダTableAdapter hAdp = new DataSet1TableAdapters.勤務票ヘッダTableAdapter(); hAdp.Fill(dts.勤務票ヘッダ); // 勤務票件数カウント if (n == 0 && dts.勤務票ヘッダ.Count == 0) { MessageBox.Show("出勤簿がありません", "出勤簿登録", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); Show(); // メニュー画面再表示 return; // 戻る } // 勤怠データ作成 OCR.frmCorrect frm = new OCR.frmCorrect(string.Empty); frm.ShowDialog(); } Show(); }
/// <summary> /// Create experiment based on Dataset /// </summary> /// <param name="dataset"></param> public Experiment(DataSet1 dataset) { //copy data m_strData = new string[dataset.Data.Length][]; for (int i = 0; i < dataset.Data.Length; i++) { m_strData[i] = new string[dataset.Data[i].Length]; for (int j = 0; j < dataset.Data[i].Length; j++) { m_strData[i][j] = dataset.Data[i][j]; } } // Init(dataset.MetaData.ToList(), dataset.TestRows, dataset.IsPrecentige); }
private void LoadData(FlexCelReport fr) { DataSet1 Data = new DataSet1(); DataSet1TableAdapters.ProductTableAdapter ProductAdapter = new DataSet1TableAdapters.ProductTableAdapter(); ProductAdapter.Fill(Data.Product); DataSet1TableAdapters.ProductPhotoTableAdapter ProductPhotoAdapter = new DataSet1TableAdapters.ProductPhotoTableAdapter(); ProductPhotoAdapter.Fill(Data.ProductPhoto); DataSet1TableAdapters.ProductProductPhotoTableAdapter ProductProductPhotoAdapter = new DataSet1TableAdapters.ProductProductPhotoTableAdapter(); ProductProductPhotoAdapter.Fill(Data.ProductProductPhoto); fr.AddTable(Data); }
public string[] c41 = new string[50]; // c41[0]:20時以降の勤務時間、c41[1]:土日祝の勤務時間 ///-------------------------------------------------------------------------- /// <summary> /// 給与計算用計算用受入データ作成クラスコンストラクタ</summary> /// <param name="preFrm"> /// 親フォーム</param> /// <param name="dts"> /// DataSet1</param> /// <param name="hTbl"> /// 勤務票ヘッダDataTable</param> /// <param name="mTbl"> /// 勤務票明細DataTable</param> ///-------------------------------------------------------------------------- public OCROutput(Form preFrm, DataSet1 dts) { _preForm = preFrm; _dts = dts; _hTbl = dts.勤務票ヘッダ; _mTbl = dts.勤務票明細; for (int i = 0; i < c41.Length; i++) { if (i != c41.Length - 1) { c41[i] = ","; } } }
public MainWindow() { InitializeComponent(); //http://www.codeproject.com/KB/WPF/WPFDataGridExamples.aspx // construct the dataset DataSet1 dataset = new DataSet1(); // use a table adapter to populate the Customers table Feuil1_TableAdapter adapter = new Feuil1_TableAdapter(); adapter.Fill(dataset._Feuil1_); // use the Customer table as the DataContext for this Window this.DataContext = dataset._Feuil1_.DefaultView; }
protected void Page_Load(object sender, EventArgs e) { // Required code this.ReportViewer1.LocalReport.ExecuteReportInCurrentAppDomain(System.Reflection.Assembly.GetExecutingAssembly().Evidence); this.ReportViewer1.LocalReport.AddTrustedCodeModuleInCurrentAppDomain("Barcode, Version=1.0.5.40001, Culture=neutral, PublicKeyToken=6dc438ab78a525b3"); this.ReportViewer1.LocalReport.AddTrustedCodeModuleInCurrentAppDomain("System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"); // Data load DataSet1 dataSet = new DataSet1(); dataSet.ReadXml(Server.MapPath("~/App_Data/Products.xml")); ReportDataSource dataSource = new ReportDataSource("DataSet1_Products", dataSet.Products); this.ReportViewer1.LocalReport.DataSources.Add(dataSource); this.ReportViewer1.LocalReport.Refresh(); }
private void Form1_Load(object sender, EventArgs e) { con.ConnectionString = " server=THENME-PC;integrated security=true;dataBase=store_system"; string sql = "SELECT Storeinvoice.Storeinvoice_no as PurchaseId, Storeinvoice.Storeinvoice_date as PurchaseDate,customercompany.cocuname as CompanyName,employee.empname as EmployeeName, item.item_name as ProductName,invoice_details.invoice_detailsExpirydate as ExpiryDate, invoice_details.invoice_detailsCost UnitCost, invoice_details.invoice_detailsqty Quantity, invoice_details.invoice_detailsqty * CONVERT(int, invoice_details.invoice_detailsCost) AS Total FROM item INNER JOIN invoice_details ON item.item_no = invoice_details.item_no INNER JOIN customercompany ON item.cucono = customercompany.cocuno INNER JOIN Storeinvoice ON invoice_details.Storeinvoice_no = Storeinvoice.Storeinvoice_no AND customercompany.cocuno = Storeinvoice.cocuno INNER JOIN employee ON Storeinvoice.empno = employee.empno where Storeinvoice.Storeinvoice_no= " + x; DataSet1 ds = new DataSet1(); SqlDataAdapter dad = new SqlDataAdapter(sql, con); dad.Fill(ds.Tables["DataTable1"]); CrystalReport1 cr = new CrystalReport1(); cr.SetDataSource(ds.Tables["DataTable1"]); crystalReportViewer1.ReportSource = cr; crystalReportViewer1.Refresh(); }
public ProductPartsForm(DataSet1 data, DataRowView productRowView) { var productRow = (DataSet1.ProductRow)productRowView.Row; _productID = productRow.ID; _data = data; InitializeComponent(); productBindingSource.DataSource = productRowView; assignedPartBindingSource.DataSource = _data; assignedPartBindingSource.DataMember = "Part"; assignedPartsListBox.DisplayMember = "Name"; unassignedPartBindingSource.DataSource = _data; unassignedPartBindingSource.DataMember = "Part"; unassignedPartsListBox.DisplayMember = "Name"; }
protected void fillReports() { DataSet1 ds = new DataSet1(); ds = csfee.fncGetStudentDailyAllFeeCollectioReport(Int32.Parse(ddlyear.SelectedValue), ddlAdmission.SelectedValue, ddlclass.SelectedValue); reportfilepath = Server.MapPath("CR_StudentWiseAllFeecollectionReport.rpt"); CrystalReportViewer1.EnableDatabaseLogonPrompt = false; ReportDocument FeeDetails = new ReportDocument(); FeeDetails.Load(reportfilepath); FeeDetails.SetDataSource(ds.Tables["StudentWiseAllFeeCollection"]); CrystalReportViewer1.ReportSource = FeeDetails; CrystalReportViewer1.DataBind(); CrystalReportViewer1.RefreshReport(); }
public Form_add_user() { form_opreator = new Form_operator(); user = new DataSet1TableAdapters.UserQuerry1TableAdapter(); dataNew = new DataSet1(); InitializeComponent(); Opacity = 0; Timer timer = new Timer(); timer.Tick += new EventHandler((sender, e) => { if ((Opacity += 0.08d) == 1) timer.Stop(); }); timer.Interval = 5; timer.Start(); }
public MainWindow() { InitializeComponent(); a = new DataSet1(); a.DT_Num_Series.Rows.Clear(); dtSeries.ItemsSource = a.DT_Num_Series.AsDataView(); //_erpBS = new ErpBS(); //_erpBS.AbreEmpresaTrabalho(EnumTipoPlataforma.tpEmpresarial ,"CLONETVSD", "gmahota", "Accsys2011!"); //_documentoCompra = _erpBS.Comercial.Compras.Edita("000", "VGR", "2015", 1); //linhaActual = 2; }
public Info(DataSet1.recordDataRow row) { InitializeComponent(); this.Text = row.title + ' ' + row.first_name + ' ' + row.mid_name + ' ' + row.last_name; this.relationText.Text = row.relation; this.nameText.Text = this.Text; this.nickText.Text = row.nickname; this.sexText.Text = row.sex; this.birthdateText.Text = row.birthdate; this.noteText.Text = row.note; this.photoPictureBox.Image = new Bitmap(row.photo); this.photoPictureBox.ImageLocation = row.photo; this.photoPictureBox.SizeMode=PictureBoxSizeMode.StretchImage; this.pcityText.Text = row.pcity; this.paddressText.Text = row.paddress; this.pzipText.Text = row.pzip; this.pstateText.Text = row.pstate; this.scityText.Text = row.scity; this.saddText.Text = row.sddress; this.szipText.Text = row.szip; this.sstateText.Text = row.sstate; this.num1.Text = row.num1; this.num2.Text = row.num2; this.num3.Text = row.num3; this.num4.Text = row.num4; this.num5.Text = row.num5; this.num6.Text = row.num6; this.nnum1.Text = row.nnum1; this.nnum2.Text = row.nnum2; this.nnum3.Text = row.nnum3; this.nnum4.Text = row.nnum4; this.nnum5.Text = row.nnum5; this.nnum6.Text = row.nnum6; this.emailText.Text = row.email; this.webText.Text = row.web; this.wpositionText.Text = row.wposition; this.companyText.Text = row.wcompany; this.waddressText.Text = row.waddress; this.wcityText.Text = row.wcity; this.wzipText.Text = row.wzip; this.wtelText.Text = row.wtelephone; this.wemailText.Text = row.wemail; this.wwebText.Text = row.wweb; loadedRow = row; }
private Tuple<int, int> AwardPoints(int winnerId, DataSet1.playerRow playerA, DataSet1.playerRow playerB) { List<Tuple<int, int>> pointsExpected = new List<Tuple<int, int>>(); List<Tuple<int, int>> pointsUnexpected = new List<Tuple<int, int>>(); pointsExpected.Add(new Tuple<int, int>(-1, 8)); pointsExpected.Add(new Tuple<int, int>(13, 7)); pointsExpected.Add(new Tuple<int, int>(38, 6)); pointsExpected.Add(new Tuple<int, int>(63, 5)); pointsExpected.Add(new Tuple<int, int>(88, 4)); pointsExpected.Add(new Tuple<int, int>(113, 3)); pointsExpected.Add(new Tuple<int, int>(138, 2)); pointsExpected.Add(new Tuple<int, int>(163, 2)); pointsExpected.Add(new Tuple<int, int>(188, 1)); pointsExpected.Add(new Tuple<int, int>(213, 1)); pointsExpected.Add(new Tuple<int, int>(238, 0)); pointsUnexpected.Add(new Tuple<int, int>(-1, 8)); pointsUnexpected.Add(new Tuple<int, int>(13, 10)); pointsUnexpected.Add(new Tuple<int, int>(38, 13)); pointsUnexpected.Add(new Tuple<int, int>(63, 16)); pointsUnexpected.Add(new Tuple<int, int>(88, 20)); pointsUnexpected.Add(new Tuple<int, int>(113, 25)); pointsUnexpected.Add(new Tuple<int, int>(138, 30)); pointsUnexpected.Add(new Tuple<int, int>(163, 35)); pointsUnexpected.Add(new Tuple<int, int>(188, 40)); pointsUnexpected.Add(new Tuple<int, int>(213, 45)); pointsUnexpected.Add(new Tuple<int, int>(238, 50)); int dif = Math.Abs(playerA.currentPoints - playerB.currentPoints); for (int i = pointsExpected.Count-1; i > -1; i--) { if (dif > pointsExpected[i].Item1) { if (IsWinnerExpected(winnerId, playerA, playerB)) { return pointsExpected[i]; } else return pointsUnexpected[i]; } } return new Tuple<int, int>(0, 0); }
private void BindWithoutInSheetHeaders() { // Create dataset object this.dataSet11 = new DataSet1(); // Create database object ExampleDatabase db = new ExampleDatabase(); // Create path to database file string path = (this.Master as Site).GetDataDir(); // Create connection string db.oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "\\Miscellaneous\\Database\\demos.mdb"; try { // Connects to database and fetches data. db.oleDbDataAdapter1.Fill(dataSet11); // Create web worksheet object WebWorksheet sheet = GridWeb1.WebWorksheets[0]; // Clears the sheet. sheet.Cells.Clear(); sheet.Cells.UnMerge(0, 0, 2, 11); // Disables creating in-sheet headers. sheet.EnableCreateBindColumnHeader = false; // Data cells begin from row 0. sheet.BindStartRow = 0; // Unfreezes the header rows. sheet.UnfreezePanes(); // Bind the sheet to the dataset. sheet.DataBind(); } finally { // Close database connection db.oleDbConnection1.Close(); } }
public void Init(frmCUEPlayer parent) { _config = parent.Config; dataSet = parent.DataSet; MdiParent = parent; Show(); _icon_mgr = parent.IconMgr; listViewTracks.SmallImageList = _icon_mgr.ImageList; foreach (DataSet1.PlaylistRow row in dataSet.Playlist) { try { listViewTracks.Items.Add(ToItem(row)); } catch (Exception ex) { Trace.WriteLine(ex.Message); } } }
public object GetDataSource(NameValueCollection args, bool designTime) { if (designTime) { return new DataSet1(); } else { var ds = new DataSet1(); var row0 = ds.DataTable1.NewDataTable1Row(); row0.DataColumn1 = "TEST 0"; ds.DataTable1.AddDataTable1Row(row0); var row1 = ds.DataTable1.NewDataTable1Row(); row1.DataColumn1 = "TEST 1"; ds.DataTable1.AddDataTable1Row(row1); return ds; } }
private void btnReport_Click(object sender, EventArgs e) { Int32 selectedRowCount = dgv1.Rows.GetRowCount(DataGridViewElementStates.Selected); if (selectedRowCount<=0) { MessageBox.Show("Please select record first."); return; } string StrCmd = ""; string EMPID = dgv1.Rows[dgv1.CurrentCell.RowIndex].Cells["dgv1EMPID"].Value.ToString(); if (rdo1.Checked == true) { StrCmd = "select EMPID,NAME,DATETIMEIN,DATETIMEOUT from InOutTimeTable where DateDiff('d',DATETIMEIN,'" + dtp1.Value + "')=0 and EMPID=" + EMPID; } else if (rdo2.Checked == true) { StrCmd = "select EMPID,NAME,DATETIMEIN,DATETIMEOUT from InOutTimeTable where DateDiff('m',DATETIMEIN,'" + dtp1.Value + "')=0 and EMPID=" + EMPID; } OleDbDataAdapter da = new OleDbDataAdapter(StrCmd, MyConn); DataSet ds = new DataSet(); da.Fill(ds, "ReportTable"); DataTable dt = new DataTable(); dt = ds.Tables["ReportTable"]; DataRow dr; dsx = new DataSet1(); foreach(DataRow _item in dt.Rows) { dr = dsx.ReportTable.NewRow(); dr["EMPID"] = _item[0]; dr["NAME"] = _item[1]; dr["DATETIMEIN"] = _item[2]; dr["DATETIMEOUT"] = _item[3]; TimeSpan span = (DateTime.Parse(_item[3].ToString()).Subtract(DateTime.Parse(_item[2].ToString()))); dr["HOUR"] = span.Hours.ToString() + ":" + span.Minutes.ToString(); dsx.ReportTable.Rows.Add(dr); } frmReportViewer ReportViewerForm = new frmReportViewer(); ReportViewerForm.Show(); }
public void CreafReportes(string nombreReporte, String sCadena, String sTitulo,DataTable dtabla) { string titulo = sTitulo; string cadena = sCadena; // Crea el documento del Reporte CrystalDecisions.CrystalReports.Engine.ReportDocument reporte = creaReporte(nombreReporte); DataSet1 dtSet = new DataSet1(); dtSet.Tables.Add(dtabla); reporte.SetDataSource(dtSet.Tables[1]); //===== Crea formulario cFReporte System.Windows.Forms.Form cFReporte = new System.Windows.Forms.Form(); cFReporte.BackColor = Color.LightSteelBlue; cFReporte.WindowState = FormWindowState.Maximized; cFReporte.MaximizeBox = false; cFReporte.MinimizeBox = false; // Crea el Report Viewer CrystalDecisions.Windows.Forms.CrystalReportViewer CRVrpt = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); CRVrpt.Size = new System.Drawing.Size(830, 501); CRVrpt.Location = new System.Drawing.Point(0, 0); CRVrpt.Dock = System.Windows.Forms.DockStyle.Fill; CRVrpt.ShowCloseButton = true; CRVrpt.ShowExportButton = true; CRVrpt.ShowGotoPageButton = true; CRVrpt.ShowPageNavigateButtons = true; CRVrpt.ShowPrintButton = true; CRVrpt.ShowRefreshButton = true; CRVrpt.ShowZoomButton = true; CRVrpt.ShowGroupTreeButton = true; CRVrpt.DisplayGroupTree = true; CRVrpt.DisplayStatusBar = true; CRVrpt.DisplayToolbar = true; CRVrpt.ReportSource = reporte; cFReporte.Controls.Add(CRVrpt); cFReporte.Show(); }
protected void Page_Load(object sender, EventArgs e) { DataSet1.CategoryDataTable Category = new DataSet1.CategoryDataTable(); CategoryTableAdapter catAdap = new CategoryTableAdapter(); DataSet1.ProductsDataTable Products = new DataSet1.ProductsDataTable(); ProductsTableAdapter prodAdap = new ProductsTableAdapter(); catAdap.Fill(Category); prodAdap.Fill(Products); var result = from item in Products select item; DataTable queriedProducts = result.CopyToDataTable<DataSet1.ProductsRow>(); queriedProducts.TableName = "queriedProducts"; DataSet1 ds = new DataSet1(); ds.Tables.Add(queriedProducts); //DataView view = result.AsDataView<DataSet1.ProductsRow>(); //view.RowFilter = "CategoryID = 65985"; GridView1.DataSource = ds.Tables["queriedProducts"]; GridView1.DataBind(); }