New winform app with Local Database.

[musiclover7]

Hi all, I am new to this forum, and pretty dang new to the world of coding as well. I have some scripting exp in html, bash, sql, and am working my way through a video tutorial of VB, but I am looking to start making some headway on a new project, hence posting here.. Vstudio2008 and access 2008 are the apps, though I am thinking of switching to a freel sql application, as my sql skills are pretty decent, just need to rap them into VB..

I am working on creating a winform application that will live on an employee's local laptop, that can be used for tracking troubleshooting incidents. The app will write data to local database first independent of internet connection, but can then upload changes to case data that have taken place since last sync, to the current web addressed server. Presently, we access case data through browser, but it is slow, and very tedious, and my idea is to create a stand alone app that can hopefully automate a lot of the tedious functions.. ie create cases from templates, etc..

So far, I created a layout that I thought would work well, by dragging and dropping from tool bar in Visual studio. I also created a database that can store data locally in access. Now, I am trying to figure out how to bind text boxes, month calendars, etc to the actual fields in the database.

I am here for general advice, but specifically, I have a tab with a month calendar tool, and a data-grid view beneath it. I want the user, to be able to select dates, or date spreads on the calendar and have cases relative to those dates, display in the datagridview below.

sort of like:

select caseid, customer_id, case_status from cases
where case_dttm in (XXXXXX);

and have the month calendar utility populate the case_dttm portion of the query..

Any and all help greatly appreciated!!

[Hack]

Moved From The CodeBank