Search Engine in vb.Net

Question

ok.. take a look at this piece of code.. DataAdapter_RunNum2.SelectCommand.CommandText = _ SELECT [Main Table].Date  & _ [Main Table].Remarks  & _ [Project Table].Name  & _ [Project Table].Number  & _ [Document Table].Type  & _ [File Table].Type  & _ [User Table].Name  & _ FROM ((((([Main Table]  & _ INNER JOIN [Project Table]  & _ ON [Main Table].projectID = [Project Table].projectID)  & _ INNER JOIN [Document Table]  & _ ON [Main Table].documentID = [Document Table].documentID)  & _ INNER JOIN [File Table]  & _ ON [Main Table].fileID = [File Table].fileID)  & _ INNER JOIN [User Table]  & _ ON [Main Table].userID = [User Table].userID)  & _ INNER JOIN [Company Table]  & _ ON [Main Table].companyID = [Company Table].companyID)  & _ WHERE [Main Table].[Running Number] = 5  DataAdapter_RunNum2.SelectCommand.ExecuteNonQuery() DataAdapter_RunNum2.Fill(DataSet_RunNum2) i'm really confused.. * why is it i cannot change the number 5 to a ' & cboRunNum.Text & '?.. whereby the cboRunNum has a list of numbers that can be used.. * what does expr1 expr2.. refers to? * how do i make a search based on dates?.. as in between 20/07/2004 and 16/07/2004?.. what are the command codes like?.. can i put it as.. WHERE [Main Table].date >= ' & cboStart.Text & '  & _ AND [Main Table].date <= ' & cboStop.Text & '  & _ i tried it but it doesnt work.. anyone?.. help!..

Adam Erstelle · Answer

make sure you are using the following syntax to get the date from the datetimepicker. dtpStart.Value.ToShortDateString (not sure of the exact spelling of the function name) When you are debugging check what the command text for the SQL is and it should help point you in the direction of your problem.

sailor_cinbad · Answer

hi no im not using SQL. instead im using ms access. btw i still cant get the search by date to work. im using the 2 datetimepickers. one as dtpStart and another as dtpStop. But before i do the search a current date is inserted into the table (in the ms access database). and the format of the date is dd/mm/yyyy. but when i do a search using = it only does the search based on the dd. how about the mm and the yyyy? im really confused. help!

tyrone.smith · Answer

* why is it i cannot change the number 5 to a ' & cboRunNum.Text & '?.. whereby the cboRunNum has a list of numbers that can be used.. Try passing it as a parameter: Dim iCount as Integer . . WHERE [Main Table].[Running Number] = ' & iCount & ' * what does expr1 expr2.. refers to? I suspect you are using SQL Server for this. This is the default alias SQL assigns to a field selected if it is not asigned an alias. * how do i make a search based on dates?.. as in between 20/07/2004 and 16/07/2004?.. what are the command codes like?.. can i put it as.. WHERE [Main Table].date >= ' & cboStart.Text & '  & _ AND [Main Table].date <= ' & cboStop.Text & '  & _ dim Date1 as Date Date2 as Date dim SQL as String SQL = SELECT [field1] [StartDate] [EndDate]  & _ FROM [table]  & _ WHERE Startdate BETWEEN ' & Date1 & ' AND ' & Date2 & ' Something like that... Hope it helps. :)