Search results for query: *

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, 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, 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...