I started a database app using a LeftPanelMainMenu for buttons with which to load each form which does its own particular functions . The forms as they open are displayed inside (or on top of) MainContentPanel. It looked fine and worked each form opening and closing after its work was done and...
I have FrmTempRequired and on its Load open a connection to my Access backend using OleDbConnection. The dataAdapter fills the dataGridView1 with the dataSet ds. So far so good. The form opens and the datagridview displays several records. I can edit a value in one of those records and move...
Accessing an ACCESS database back end.
DateTime searchDate = DateTime.Now.AddDays(0);
DateTime searchDate2 = DateTime.Now.AddDays(-170);
Using OleDbCommand cmd;
cmd = new OleDbCommand("SELECT * FROM tbl_Sample_Login_table WHERE LoginDate BETWEEN @nowDate AND @thenDate)...
What is the best or proper way to design a database app where I am using a FrmMain with a left side panel with a number of menu buttons. My question is basically when opening FrmMain should I be querying my Access back end database file to get everything into memory that the menu buttons could...
Using VS2022. My form has a tab control where each tab is a different type of instrument. There are individual tables in the back end for each respective type of instrument. I have not been able to find information of how to handle the datasets which each tab will need to be bound to. No...
My report generation takes a beginning date and ending date parameter in the form header. The narrow date range reports are pretty quick so after the btnGenerateReport in my form header gets triggered its no problem. I see now that wide date ranges are causing a problem with delay. The...
I have a form with a ReportViewer control on it. When the form opens the ReportViewer loads and I see the NumberOfProducts from an expression in the RDLC file. In the expression in the RDLC file II use a text box with this expression: "=CountDistinct(Fields!ProductName.Value)" to get the...
Where do I need to go to resolve this please? I have already tried editing the rdlc file to no avail. Don't know what I did to get to this point either. My form is for a report to query my ACCESS DB back end. I can preview data, but when I load my report form this 'data source instance'...
I'm doing my first database application using C# with VS2019. It is dead in the water due to problems with getting reports to work. On a form where I want a report to appear in the Toolbox and General subgroup there are are no report items listed. I right click and select 'Choose Toolbox...
My code below gathers the total number of samples from tbl_Sample_Login_table between a set of dates. That's nice for a total of all samles - however what I need to do is group by ProductName - capture that product name - and get the total count of that product... continuing on for all...
I have looked all over the internet and found examples with iText and Java, but I am not using Java (and don't speak it). Is there a clear site with sample code snippets to position elements? What I need to do is have a logo at the top in the header section of a PDF, underneath that a line of...
This is pushing me too close to the edge ":-( On FrmCreatePDF is a Btn_GeneratePDF. The code snippet below slightly modified from CodeGuru throws a "NULL REFERENCE Object reference not set to an instance of an object". The error is thrown on "document.Add(header);". So 'document' is a new...
On FrmMain I have a panel LeftPanelMainMenu and a set of buttons to launch various forms. Buttons are for example BtnSampleLogin, BtnRecentSamples ... etc. I have set one BackgroundImage for not used and another lighter one for MouseHover and MouseLeave. The lighter background image is also...
This must be a common occurrence. I have a datagridview on a tabcontrol. A datagridview is on each tab. All but one of the bindingNavigators are bound/connected/linked with the datagridview on which they appear. Somehow one is broken and does not manipulate the datagridview that is appears...
The background is this... I have a tab control on a form which has multiple tabs. In order to get the appropriate category of Method_Titles on each tab, I have had to programmatically set up the data binding etc.. as the data comes from an Access backend. For each tab there is a SELECT...
I have this plan of having a tab control with 7 tabs. Each tab is basically doing a filter or separate query to get only a subset of data from the multi-table relational database. One tab I want all methods. One tab I want only the QC category methods. One tab I want only RandD methods...
I have a login form that runs first. Upon successful login I want to close this form and open Frm_Main. As a beginner in C# I'm having a problem with OOP and simply closing a form without closing the entire app. I'm working in Visual Studio 2017.
To be more specific, I have Program.cs that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.