|
I wonder if anyone could help me on this problem I am having.
I have an Access 2003 database and using VB.Net 2003
I have a query in Access e.g. myQuery. In this query it has a date field. I want to pass 2 parameters to this field (myDate) e.g. between 01/01/1999 and 30/01/1999.
My query in VB.Net is
"EXECUTE myQuery #01/01/1999#, #30/01/1999#"
For some strange reason it is only picking up the 01/01/1999 value.
The question is,
How can I pass 2 parameters via VB.Net to a field in Access which uses the between date function in a field.
|
|
|
|
|
The standard way to do it is to use an OleDbCommand object, supplying it with the name of the stored procedure, and a couple of OleDbParameter objects.
Dim conn As New OleDbConnection("connection string")
Dim comm As New OleDbCommand("myQuery", conn)
' DateTime takes arguments in Year, Month, Day order.
comm.Parameters.Add("@p1", OleDbType.Date).Value = New DateTime(1999, 1, 1)
comm.Parameters.Add("@p2", OleDbType.Date).Value = New DateTime(1999, 1, 30)
Dim rdr As OleDbDataReader = comm.ExecuteReader()
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks for this information.
Tried it and it worked a treat.
|
|
|
|
|
hi
i want to know how notepad ms word and more similar editor applications opening a text file or wat ever it is in thier application by right click and open or right click and open with option
this i am asking because i want to make my application to open a text file on right click it
pls reply soon
with regards
Balagurunathan.B
|
|
|
|
|
you can use contextmenu in vb.net for right click option.
And add menu items for menu.
Add your code in the clickevents
Sathesh Pandian
|
|
|
|
|
i dont want that one
let us consider this scenario
if u have a c++ code
if u want to see that code u will right click on that and use open with ms word or notepad
like that i want to open
with regards
Balagurunathan.B
|
|
|
|
|
hi i want to make the users who installs the product created by me schould enter some license key provided to him. so wat i have to do.
i dont want user to get connectd into web
i dont have any idea to make users to enter the key given to him while installing
please give me a idea
we can use any cryptography algorithms to generate a key but how to embed it, so user will enter it while installation
if i am correct those things will be related with registry
i dont have any idea pls provide some help
with regards
Balagurunathan.B
with regards
Balagurunathan.B
|
|
|
|
|
You have two options:
1 - you can write a C++ dll which will allow you to require a password from the installer itself
2 - you can write some code inside your app that requires a key to be entered
In both instances, you have two choices:
1 - generate a key that is unique to the machine, which means they'd need to call you in order to finish the install
2 - just put a key in there that's the same for everyone
balakpn wrote: we can use any cryptography algorithms to generate a key but how to embed it, so user will enter it while installation
Obviously, you would 'embedd' it, by writing code that requires the key to be entered.
balakpn wrote: f i am correct those things will be related with registry
The registry is one obvious place to store that the key was already entered, so you don't ask for it again, yes.
One thing you need to know. If your app is VB.NET, a tech savvy user can decompile it, remove the licence code, and recompile. Easier still, they can read your code with a tool like Reflector, and just read how you generate your key, and thus discover it without having to know it in the first place.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )
|
|
|
|
|
hi i have two tables like want to display based on the date:
eg:
table1:
Id cardDate Intime1 Outtime1
1 12/22/2006 09:00 20:00
2 12/22/2007 09:00 20:00
3 12/22/2006 09:00 13:00
and table 2:
Id leaveDate Intime2 Outtime2
3 12/22/2006 13:00 20:00
4 12/22/2006 09:00 20:00
5 11/11/2006 09:00 20:00
If i select the date 12/22/2006" then it want to display like:
Id Carddate InTime1 Outtime1 Leavedate Intime2 Outtime2
1 12/22/2006 09:00 20:00 null null null
3 12/22/2006 09:00 13:00 12/22/2006 13:00 20:00
4 12/22/2006 09:00 20:00 null null null
I am week in sqlquery,plz hlp me...,
Magi
|
|
|
|
|
SELECT table1.id,cardDate,InTime1,Outtime1,Leavedate,Intime2,Outtime2 FROM table1 INNER JOIN table2 on table1.id=table2.id WHERE cardDate=#12/22/2006#
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
|
No,it willnot work,
Ur query will work,when that two tables have same id...,
If table1 have particular date on some other ids,
then those records willn't display...,
Similarly table2 also have paricular date some other ids those records will not display...,
ex:
table1:
Id cardDate Intime1 Outtime1
1 12/22/2006 09:00 20:00
2 12/22/2007 09:00 20:00
3 12/22/2006 09:00 13:00
7 12/22/2006 09:00 20:00
and table 2:
Id leaveDate Intime2 Outtime2
3 12/22/2006 13:00 20:00
4 12/22/2006 09:00 20:00
5 11/11/2006 09:00 20:00
8 12/22/2006 09:00 20:00
see ur query willn't show id=7 & 8,
and ur query will display table2 all records it willn't check the date condition
and it willn't show at one row when the date will be there in two tables
see my first ques i told output style also..........
Magi
|
|
|
|
|
after connecting vb6 with sql+, i can create normal data reports but how should i create dynamic data reports........
or
i use only one data environment and one form and one data report then how should i create such a report that the value entered in the text box of the form(for example a class in a school like 10th or 12th) then how should it be possible that i can create a report that whatever class is entered in the text box i get the fields of that class from the table of the students in the same data report........
deepak jain
|
|
|
|
|
Hi can you plz advice me how to filter file while upload image through webapplication for example when open dialogue box has open you want to show the file type with *.jpg and *.gif the file dialogue box should not show any other file type.
Magi
|
|
|
|
|
simply set your OpenFileDialog box property like.....
OpenFileDialog.Filter = "JPG Files(*.jpg)|*.jpg|GIF Files(*.gif)|*.gif"
thus Your OpenFileDialog box will not show any other file type.....
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
|
Hey one doubt..........,this command will be use in web application?
it will work in web application?
Magi
|
|
|
|
|
then you can use the Accept method of HTML FileField control for your work.....
MyFileField.Accept="jpeg,gif"
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
|
Hello,
[VS 2005]
Is there a way to manually order the columns in a DataGridView.
My grid is bound to the datasource at run-time. So I can't change the order in the designer.
Is there a method to do that in code?
Many thanks,
Steve
|
|
|
|
|
what do u mean by Ordering of column?? Construct your SQL Query as you like....
are you using SELECT * FROM TableName WHERE.....???
instead use....
SELECT Column1,Column2,...... FROM TableName WHERE ....."
Tirtha
"A man can ride on your back only when it is bent....."
|
|
|
|
|
I have a vb.net application that has a third party ActiveX/ocx control on the form .. The control can display data in a so called data-grid like format ... and one can add/remove/re-position/set width of the specific columns of data you want to display
Having set up the right columns I want ...
e.g | Column A | Column B | Column C | etc ... All works fine ..
If I then exit the application ... and re-run the application .. I have to again "set" all the columns as I want them on the control ...
Is there a way to "save" the column layout of the control?
I am not able to see any "methods" associated with the control to do this ...
Is there anything within the overall vb.net form to do this ..?
I hope I have explained myself clearly enough ...
Regards,
GaryAW
|
|
|
|
|
hi friends,
i want learn to make crystal report step by step...plz help
Imagine the I.T
|
|
|
|
|
|
i just complate my b.e i.t .
i want to do MCPD or MCSD
i want information abt MCPD or MCSD.
how can get material or book for exam?
Imagine the I.T
|
|
|
|
|
You have completed an IT qualification, but you don't know about google ? http://www.amazon.com[^] is the place for books.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 have my MCSD .net. It was hard, but if you study you can pass the tests.
MCSD .net is .net 1.1.
MCPD is .net 2.0. I am having more trouble with these tests. They seem harder then the MCSD ones.
Ben
|
|
|
|
|
hi..
thks 4 reply
.........
tell me abt books, & all related info....
Imagine the I.T
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
