Search results for query: *

I have developed a windows form application database using visual studio 2013 and SQL server 2016 enterprise edition, sitting in my desktop computer with Windows 10 operating system. I want to use my laptop to work in the database wherever I am, away from the desktop computer via the internet...

Thanks so much for such a great assistance. I believe am now close to the solution. I have modified the code as you advised. Yet still there is an error message. How do I initialize the connection property of the the scalar? I have attached the error message and the whole code for advise...

I decided to remove the scalar stuff I could succeed in the date filter but when I run the application still there come another error message that "The SelectCommand property has not been initialized before calling 'Fill' ". using System; using System.Collections.Generic; using...

Thanks. However, after setting the connection property there is another error requesting "Must declare the scalar variable "@fromDate". Please I will appreciate an example of declaring scalar variable @fromDate. Attached are my code page and the error message.

Please I have tried to create the projects newly and differently by using the attached code but it is still giving me an error message; this time differently. I still need a guideline to fix my error. Attached is the new code I am using and the error message also attached. private void...

Thanks to your usual assistance. I did it but still it is giving me an error message that "The SelectCommand property has not been initialized before calling "Fill" ". In fact am confused without knowing what to do. I wish to attach the parameters code for correction. private void...

I am working on a project where I want records filtered between two given dates in the datagridview display in the form textboxes accordingly. I have tried all I could but it is not working. I have also tried to place a label control as alternative to total up the filtered records on the...

I am working on a sales project and I finally want my btnStockLevel_Click (object sender, EventArgs e) { } to subtract the gross sales from the gross purchases, but I am totally stuck. I don't know the code to put in there in order to work satisfactorily. Please I will appreciate if someone...

Really I don't have any separate filter button, and I don't intend to have one. I rather intend to use the Keyup event for the filter textbox, to achieve my objective but the result is strange to me. When I became confused was when I put the cursor in a row then typed in the keyup textbox; and...

Hi Skydiver, "Are you are saying that only one time is return in all cases? Or is it returning only one item for some of the cases?" Only the first row is returned in all cases. Then again, let me say for example; Godis is Admin and on any other row. When I click on that row and filter all...

I am working on a database project using Microsoft Visual Studio 2013, and also Microsoft SQL Server 2014 respectively. I have about four tables in my project named UsersDataSet. I want to create filter controls for each form application using combo boxes and textboxes. I want to use the...

Yes! I agree with you jmcilhinney. I think I must pause and take the courses you have suggested to ground myself and then come to my project. Thanks for your advise.

Thanks for your tolerance and assistance. I believe the mistake would not occur again. However my problem is not addressed yet. Currently, when any user logs in with the correct password they are all directed to the Dashboard page where there are four role user command buttons (Admin...

Hi jmcilhinney and Sheepings, Thanks for your stern reprimands. I wished I did not commit the mistake again if I knew how to go about it. I tried several times but did not know how to locate the code tag and how to do it to expectation; seeing am very new on the forum. I wish somebody could...

Hi Forum Colleagues, Gratefully appreciate your prompt assistance when I post a question on the platform. On developing my payroll database, I have gotten to a stage of building users access control. I have successfully created the users login control, where when the user role logs in within...

Thanks jmcilhinney, I got it right when I went back to the SQL Management Studio and found that the Primary Key was not set. I set it, came back to the VS, deleted the DataSet and reconfigured it, rebuilt the application and now I can save updates. Thanks a lot to all contributors.

The following is the code of the project I am building. It would be observed in the code that I have two separate save button with different codes, but none of them could save updates. Am standing by for assistance:- using System; using System.Collections.Generic; using...

Thanks for correcting my mistakes. I will do the right thing hence.

I have the mind to develop a payroll database. After I have created the form in Microsoft Visual Studio 2015, I dragged both the nodes of DataGridView and Details front the DataSet window onto the Form. When I run the application I was able to save two entries I made into the database. But...