Hello all , I am very new to visual studio and i am very interested in learning vb.net language even though i don't have much of programming experience.
I am creating a winform app for data entry connected to a access-db as source.
I have a data grid box in form2(name:reminder) which will pop up when clicked on a button in form1(name:MSdies).
In this form2 data-grid box i just want view the query results i have created as below SQL :
originally the table contains these detailsCode:SELECT ID, [Size in mg], [Die head number], [Inspection Date], [Next Calibration Date], [Die size in microns] FROM MSdies WHERE ([Next Calibration Date] < NOW())
Can anyone help me with this how can i achieve the same by step wise explanation.Code:SELECT ID, [Size in mg], [Die head number], [Inspection Date], [Next Calibration Date], [Die size in microns], [Condition of DIE-1], [Condition of DIE-2], [Condition of DIE-3], [Condition of DIE-4], [Condition of DIE-5], [Condition of DIE-6],[Condition of DIE-7], Observations, Inspector FROM MSdies
for database name & details
I have attached images too for your reference.Code:Private Sub Reminder_Load(sender As Object, e As EventArgs) Handles MyBase.Load Me.MSdiesTableAdapter.Fill(Me.TrialdatabaseDataSet.MSdies) End Sub![]()




Reply With Quote
