|
use dataset to insert and after that update table through dataset
|
|
|
|
|
use dataset to insert and after that update table through dataset
monu_khan
|
|
|
|
|
One post is enough.
Regards,
Satips.
|
|
|
|
|
can we insert to datagrid without dataset? i mean insert manually
example:
in vb 6 if we use flexgrid we just write grid.textmatrix(row, col) = value
value is anything that w want to insert to the grid
can datagrid get value from that kind of code??
|
|
|
|
|
Sir/Madam,
Can I programically ascertain , the number of users who has accounts on my operation system
I can find out the user who is currently logged in .
By the following code.
System.Environment.Username
But I want to know the no of users who has account on the operation system.
Please help.
Thanks and Regards
Pankaj
|
|
|
|
|
Can you write some code to have it go through the "document and settings" directory on the system and count the number of profile directories. Just remember to subtract at least 3 for Administrator, Default User, and All Users.
David
|
|
|
|
|
|
What is Help.ChangeMMDDYY
What u importing to get the function ChangeMMDDYY
|
|
|
|
|
hi, sir
Help is businesslogic in my project ie
used to convert datetime format in MONTH/DAY/YEAR
monu_khan
|
|
|
|
|
ok thanks i thought it is any predefined function
|
|
|
|
|
I believe your problem is that you are trying to compare two string dates as if they were date values, which of course you cannot do successfully. The only way you can successfully compare 'dates' as strings would be to arrange the dates in yyyymmdd format so that they have a 'numerical' value to which you can apply an operator.
I would suggest that the dates be stored in the database as either proper dates, or as the string representation of the date in yyyymmdd format. EIther of these would make it much easier to handle date comparisons.
If changing the database structure to a date is not possible at this stage you may have a problem unless you can change the string storage to a more usable format.
David Loring
!! Keep Music Live !!
|
|
|
|
|
I'll weigh in on this, I have had several projects where the client data was stored as a string. They always want to query by a from -> to date on these fields. Your best bet is to backup the data then change the field in the database to a date field then make sure the change took. Now you can change your code so that the search won't need to be converted to do what you want.
Just my 2 cents...
|
|
|
|
|
hi,
how can i query duplicate records
from a ms access table.
ram
|
|
|
|
|
How are you going to enter duplicate records
Develop2Program & Program2Develop
|
|
|
|
|
for example
tblA
col1 col2
101 AAA
102 BBB
101 AAA
103 CCC
103 CCC
select col1, col2 from tblA gorup by col1, col2 having count(*) > 1
returns all rows which are repeated
Regards
KP
|
|
|
|
|
I have two froms, one form has button called "Close",
when I clicks the "Close" button then two forms are closed.
I wants to close that "Close" button from not all the forms.how can I handle this????????
Thiwa
|
|
|
|
|
Maybe posting your code will help.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
try me.close in the close button code
|
|
|
|
|
me.close not worked.It cloased all the forms I open.
I want to close only one form.
THiwa
|
|
|
|
|
if u povide me the code u coded .
|
|
|
|
|
frmLoging.Close()<br />
MDIMain.Show()
when Im using this not showing the MDIMain form.
All the forms are closed.
Thiwa
|
|
|
|
|
problem is when u closing the fmlogging form .it destroys the object of all others.
so it will be fine if u hust hide the frmlogging
frmlogging.hide.
|
|
|
|
|
|
I guess you are closing MDI Form and all other forms seems to be its Child Form . Do take a look at it
Develop2Program & Program2Develop
|
|
|
|
|
NO.frmLogin form is not a MDI child.
Thiwa
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
