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...
Thank you cjard for your comment. My comment has a legacy database which is an Access DB on their server. This current project is a redesign of the existing Access front end. My hands are tied.
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...
The possible reason I have for using AddDays(0) was an attempt to get that Now() current search date to work. Now that I have found the problem - maybe you have a useful way of getting the current date instead of AddDays(0). This fragment which is actually DateTime searchDate =...
I switched the dates as soon as I read JohnH post so I was not arguing.
Problem resolved:
I found that the back end test file that was more current (had data after 4-13-23), was actually located in a sub folder with the same name as the back end test file which was actually being opened by the...
The then date and now date did not change that my "nowDate" is being ignored or substituted for 4/13/23 (and my system and backend is current to today. Is there anywhere else where that odd date could be getting taken from? For example might there be a copy of an old database back end file...
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)...
Thank you for the best practice information! I suppose that I have used the same dataset name for a few different forms does not mean that I have loaded into memory several copies of the same data, because when I close a form VS automatically clears that dataset from memory? Is it also the...
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...
The "loading" message that ReportViewer.Refresh shows just prior to the report data appearing. As far as the delay issue it remains, however one work around I see that I can make a user control with a text box on it with a text of "Report loading..." message. I place that user control on top...
I have an Application.UseWaitCursor = true first thing on the code btnGenerarteReport_Click, and UseWaitCursor = false at the end of the button code. However.... it looks to me like the delay is on the filling of the TableAdapter. I'm guessing the RefreshReport on the ReportViewer is where the...
I do not have specific code to show a "Loading" message. Perhaps that is part of the ReportViewer and generated code by VS designer. I just would like it to happen on click of btnGenerateReport immediately, and not after a delay.
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 am experimenting with a pie chart in the ReportViewer now. Is there a cache somewhere that holds changes? I have made some changes to the pie chart that are not being reflected on the ReportViewer. It's almost like my RDLC file is not being overwritten with new changes.
On hover of SampleCountReportViewer is -> '(field) Report Viewer FrmSampleCountReport.SampleCountReportViewer.' The interface does not flag this with a red underline in the code itself. It does upon running the code.
On hover of LocalReport is -> 'LocalReport ReportViewer.LocalReport { get...
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.