Search results for query: *

HI all.... sorry about the confusion caused. The one i wanted is datagridview sorry if it had mislead u guys....

Hi vis781, Thanks for the help. But the grid im using is datagridview which doesnt seem to have the HitTestInfo method.

Hi JohnH, Thanks for the help.Greatly appreciated.

Hi all, i have a qn to ask.. I have a monthcalendar in the form. Is there a way to display the date as dd/MM/yyyy? currently it is showing mm/dd/yyyy when i set showtoday as true... i tried using format(date,"dd/MM/yyyy) and displayed it in a msgbox. It works but how can i display the date in...

Hi all, I have a datagrid which retrieve data from 3 tables. Now, the problem is that on click on the datagridview, the details will be displayed into combo boxes. The combo box are populated with data from the database. So how can i display the details into the combo box and at the same...

Hi, nopt they are not primary keys... I have tried using DISTINCT but it seems like there are still rows that shld not be there... i did have a WHERE clause to filter thou.. Select * From table1 inner join table 2 on table1.id = table2.id inner join table3 on table2.id = table3.id Where...

Thank you.... I have solved the problem... and managed to retrieve for both yrs.. :)

Hi, i need to join 3 tables. After researching, i realised i shld use inner join to join all of them together. But after joining there are extra rows. This is my code... Select * From table1 inner join table 2 on table1.id = table2.id inner join table3 on table2.id = table3.id can anyone...

Hi all, I need help urgently.. I need a function that enable user to click on the cell of the datagrid and then there will be 3 combo boxes and a textbox that will display the details of the selected cell from the database. How can i know which cell is being click on so that i can retrieve the...

Hi, thanks for helping:) What i want is to retrieve all the records from year 2005 to 2006 so if year cannot equal to current year and previous year. How can i retrieve records from both year?? This is my coding: selectCmd = "SELECT * FROM [table1] INNER JOIN [table2] ON [table1].[Project No]...

Hi, need help urgently..:( mmm.. I m using sql server 2005 and visual studio 2005... i have 2 queries on visual basic codings and sql statement... 1) How can i retrieve previous year in sql statement to display in datagrid?? Select * From table1 Where Year = Now.Year And year = Now.Year -1...