|
I have the codes
dim dataadapter as new oledb.oledbadapter("Select * from ITEM where dateAcquired between '9/20/2004' and '9/20/2007'
and it doesn't work.
What seems to be the problem?
gt
|
|
|
|
|
Impossible to say
1 - what does 'doesn't work' mean?
2 - what happens when you plug this code directly nto the DB
3 - what does the rest of your code look like ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Try the SQL statement in Query analyzer (SQL 2000) or Design a query and switch to SQL View in Access to see what are the results.
|
|
|
|
|
I tried it and it has an error which is criteria mismatch. What does it mean?
|
|
|
|
|
gt2 wrote: dim dataadapter as new oledb.oledbadapter("Select * from ITEM where dateAcquired between '9/20/2004' and '9/20/2007'
for date's you can use the convert statement (for sql server)
Select * from ITEM where dateAcquired between convert(datetime,'9/20/2004',102) and convert(datetime,9/20/2007,102)
or for access
select * from ITEM where dateacquired between #9/20/2004# and #9/20/2007#
hope it helps
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistaks.
|
|
|
|
|
convert(datetime,'9/20/2004',102)
What does 102 mean?
|
|
|
|
|
|
Using VB.net 2003
TXTBEGIN,TXTEND are indicate Datetimepicker
Dim DATEBEGIN, DATEEND As String
DATEBEGIN = TXTBEGIN.Value.Year & "-" & TXTBEGIN.Value.Month & "-" & TXTBEGIN.Value.Day
DATEEND = TXTEND.Value.Year & "-" & TXTEND.Value.Month & "-" & TXTEND.Value.Day
dim dataadapter as new oledb.oledbadapter("Select * from ITEM where dateAcquired between Between '" & DATEBEGIN & "' and '" & DATEEND & "'"
|
|
|
|
|
Not a good solution to begin with, and it won't work with an Access database.
|
|
|
|
|
if logged in successfully, i have the code me.close and form1.show.
The problem is the form will not show and it terminates the program.
if the code is me.hide and form1.show, form1 will show but when i close it the loginform will not.
What should be the code when closing the loginform?
gt
|
|
|
|
|
The most logical thing is for your main window to be your start window ( and for it to have a more logical name than form1 ). Then, it shows the login window, and if login fails, the app closes, otherwise the main window is shown when the login window closes.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
Do NOT use SMS speak in the forums. It makes your posts difficult to read. You've got a full 101+ key keyboard in front of you, use it.
|
|
|
|
|
how do i delete all the items from the listview?
gt
|
|
|
|
|
You remove the item from the items collection.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I tried using .remove() method. i also tried using .removeat() but it has an error.
|
|
|
|
|
How do i remove all the items form the listview?
gt
|
|
|
|
|
Collections usually have a Clear() method you can call.
|
|
|
|
|
i hv developed one small software using VB 6.0 as FrontEnd and MS-Access as BackEnd which stores customers records. the Key feature of software is dialing customer's mobile number or land line number and storing corresponding comments.When I dial number through code using(0,)eg ,9834567876 it shows invalid number and if i dial same number through phone dialer directly it shows valid number and i m able call to another person.I am using (0,) for EPBX purpose.Because when i directly dial widout sing(0,) I am able to speak with recipient party the problem is with EPBX only
code
|
|
|
|
|
It could be that your dial isn't pausing long enough after the 0 in the string, or there is an issue with interfacing your modem with the PBX system.
Your problem really has nothing to do with VB.NET itself.
|
|
|
|
|
hello all,
I have some work with me over the Vb Accelarator's Explorer bar.Well using the earlier written code the explorer bar is initialised once and could be used by changing its visible property. The explorer bar is made on a picture box. The problem is the new explorer bar strip which i have made on the existing one's is not visible when the property is set as true. Please help me out with this.
Thanx in advance
Neema 
|
|
|
|
|
You best source of information for using third party control would be whoever wrote the control. It's very unlikely that anyone who has used the control is going to see your post.
|
|
|
|
|
Well thanx for the suggestion but after fighting for the cause of my problem i got the solution.The explorer bar i was making need a fresh container and then it could be pasted to some other location.
|
|
|
|
|
hi all
i want to create one Language Creator in which i type in English word and i get Hindi word as output. Same created in REDIFF BOL V8.0 create HINDI words
some thing like TYPE ENGLISH GET HINDI[^]
can any budy plz help me
Thanks in advance
-- modified at 6:49 Thursday 27th September, 2007
The Stifler
--
Bugs can neither be created nor be removed from software by a developer. They can only be converted from one form to another. The total number of bugs in the software always remain constant.
|
|
|
|
|
Not sure what you're after here. You need a big old database of hindi words and english words they map too. A simple task, but a big one.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
