How can I create an application with many forms?

Question

Hey,

I have just started to learn C# and I think it's not so hard if u switch from any other programming language.
But I don't understand how I can create a normal application with many forms.
For example u have some menu items like: customers, products, orders, ...
and a main form with the menu on it.
So is it possible to create one main form and include the content from the pages inside a panel?
Or do I have to create multiple forms and by click on a menu item I have to show the the window e.g. customer and hide the main form?
But then I have to create the menu on each form so that the layout looks like the layout on the main form.
I hope somebody understand what I mean and can help me.
Thanks

Answer 1

your issue here is that you are comparing dates valus exactly with the designated columns and I am assuming that your table date column is of datetime type. This means you need to discard time part from both your target column and your from and to dates i.e.

 

 

select * from tablename where DATEADD(dd,0,DATEDIFF(dd,0,date )) between DATEADD(dd,0,DATEDIFF(dd,0,'01-12-2016')) AND DATEADD(dd,0,DATEDIFF(dd,0,'01-02-2017'))

Answer 2

Hi Vinay,

 Please find the below link.

https://www.codeproject.com/tips/355235/how-to-search-between-two-dates-and-get-all-record 

Answer 3

@Vinay

 

It has always been observed for many times that the problem is occuring with only the date formats

 

Always use the universal format 'yyyy-MM-dd' format instead using 'MM-dd-yyyy'. You can change its format whichever suits the clients.

 

try searching like this

 select * from tablename where date between '2016-12-01' and '2017-02-01'

 

Answer 4

Hi , 

 

I can not  understand you question clearly ! Do you mean that?

 

Answer 5

HI Vinay,

 

Try your code first in your DB, if it is working fine , check whether the DB and system format both are same or not.

 

try this URL, It may help you

 

http://stackoverflow.com/questions/14353434/selecting-data-between-2-dates 

 

http://stackoverflow.com/questions/16447877/c-sharp-between-two-dates-search

 

http://stackoverflow.com/questions/35272405/how-to-search-between-two-dates-in-c-sharp-with-ms-access

 

http://www.c-sharpcorner.com/forums/search-between-two-dates