|
aa2002uk wrote: i do need this quite urgently
No can do.
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
|
What is it about point number 10 in this[^] post that you don't understand.?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
Description -
QuizMaster is a software developed for testing one’s knowledge through computer based quizzes and analysis of the results. It is very dynamic and interactive in nature. The user can create different quizzes and add as many number of questions as he/she wants. The question can be later edited/deleted too if required. One can also add comments to the quiz banks created. This will help quiz maker add tips for the quiz takers. All questions are objective type. Scoring pattern can also be altered to allow negative markings.
As such QuizMaster comes out as an essential tool for CAL(Computer Aided Learning).
snaps
http://img167.imagevenue.com/img.php?image=65568_scap_122_493lo.jpg
Based on -
VB6, Oracle 8i or above
adodc , msflexgrid
App Type - Database Implementation
* source code included
download link
http://www.sendspace.com/file/kzfsuj
stuff2d.blogspot.com - the books site
|
|
|
|
|
What is it about point number 10 in this[^] post that you don't understand.?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
Hi,
I have a small MS Access database that keeps a log. When I write the current date and time to the table it only shows the date in the table. I checked the table with zoom and it's just the date that's in. The time seems to be gone?
My code is something like this
OleDbCommand.Parameters("LogDate").Value = System.DateTime.Now
In my app it shows like it should, but not in the database.
Any suggestions on how to get the time in MS Access?
|
|
|
|
|
SilentBob101 wrote: In my app it shows like it should, but not in the database.
Sounds like it works. Have you tried expanding the field in the database when viewing it?
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
use format command format(logdate,"dd/MM/yyyy MM:HH")
|
|
|
|
|
Been there, done that
Here's what I did.
Making sure the LogDate field in the database is text
<br />
OleDbCommand.Parameters("LogDate").Value = System.DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss")
LogDate looks like 2006-12-27
-----------------------------------------------------------------
Making sure the LogDate field in the database is Date/time with standard date time notation
<br />
OleDbCommand.Parameters("LogDate").Value = System.DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss")
LogDate looks like 27/12/2006
-----------------------------------------------------------------
Making sure the LogDate field in the database is Date/time with the following notation dd/mm/yyyy hh:nn:ss
<br />
OleDbCommand.Parameters("LogDate").Value = System.DateTime.Now
LogDate looks like this 27/12/2006 00:00:00
-----------------------------------------------------------------
The last one gets me confused. Where did the time go?
|
|
|
|
|
Oeaah, stop the press, I got it
OleDbType of the Parameter must be 'DBTimeStamp' and System.DateTime.Now must be set to a string variable. The field format of the database can stay standard date-notation.
ex.
strTimestamp = System.DateTime.Now
OleDbCommand.Parameters.Add("Time", OleDbType.DBTimeStamp)
OleDbCommand.Parameters("LogDate").Value = strTimestamp
Succes at last.
A hand of applause for me.
Thank you, you're to kind.
|
|
|
|
|
Hi.
I have to create parser(s) that will be able to parse xls, csv and txt files. All the files to parse are data from customers which has to be parsed, massaged and inserted into the database. The problem is that each customer presents its own format so I guess I have to build different parsers for each customer.
Did anyone have any experience with this? What would be the best approach? What should I use (beside VB.NET)? Any examples will be appreciated as well.
Thank you,
Alex.
|
|
|
|
|
alexfromto wrote: The problem is that each customer presents its own format so I guess I have to build different parsers for each customer.
Did anyone have any experience with this?
Yes, and it is usually a total nightmare...
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
Any help with where and how I should start?
I guess I have to parse each incoming file. What would be the best approach to use?
Thank you,
Alex.
|
|
|
|
|
alexfromto wrote: Any help with where and how I should start?
You could try to have the documents in a standard format if at all possible...
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
Thanks for your response, Dave Kreskowiak, although it looks like someone has erased it on the board.
What your note says makes sense but how do I get a copy of the global variables into the Child form if I don't get this from the global variables themselves?
Interestingly, the TitleBar gets the correct info each time using
Me.Text = MAIN.wsName
which refers to the Public variable held in the top of the MAIN Form.
Can you guide me further, please?
|
|
|
|
|
NigeLost wrote: although it looks like someone has erased it on the board
It didn't get erased. You're seeing the effects of a childish egomaniac who has nothing better to than to screw with websites and insult people.
NigeLost wrote: What your note says makes sense but how do I get a copy of the global variables into the Child form if I don't get this from the global variables themselves?
Interestingly, the TitleBar gets the correct info each time using
Me.Text = MAIN.wsName
which refers to the Public variable held in the top of the MAIN Form.
You're using global variables when you shouldn't be. The title bar sticks because each child form is using it's own copy of the text. You're not associating the Me.Text to the variable MAIN.wsName . It's getting a copy of the contents of that variable every time that code is run.
The solution is simple. In each of your child forms, expose properties that you can set so each child maintains it's own copy of the data it needs to redraw itself.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hello Dave,
Thanks for the prompt response.
You say:
The solution is simple. In each of your child forms, expose properties that you can set so each child maintains it's own copy of the data it needs to redraw itself.
But you are talking to a beginner and I cannot understand what you mean!
I tried copying the MAIN.wsScore etc (global) variables into "locally DIMmed" vars, no go. Instead, I tried converting them to "Me.Text" strings & then converting those to the "locally DIMmed variables. Still no luck.
Would you be kind enough to elaborate so a person who is only two months old can follow? Sorry to be difficult, but it will be appreciated.
Thanks
|
|
|
|
|
OK. This is real basic Class stuff. I suggest picking up a beginners book on VB.NET before you tackle another project like this. But, the easiest way to expose a field is to declare it Public. But, mind you, this isn't the best way to do this:
Public Class MyForm2
Public HeaderText As String
Public Data() As Integer
.
. Your remaining form code...
.
End Class
Now, you just have to set the values from your main form:
Dim newChildForm As New MyForm2
newChildForm.HeaderText = "Some text..."
newChildForm.Data = SomeArray()
.
. Finish creating your child form as normal...
.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks, Dave.
I do have books, but find it difficult to get my head around the heaps of jargon and find them dry & tough going. As a result, I find it easier to operate on the basis of learning what I need to know for what I am doing - that makes me study & delve like mad!
I have used the "Build A Program Now!" - excellent for straightening me out on databases and have VB for Dummies (describes me perfectly!) and Murach. Both have been helpful.
Again, thanks for the pointer. Your patience is greatly appreciated.
|
|
|
|
|
I want to create a Banking Management System, and i have created all the forms in vb.net 2003. The database is created using Microsoft Access 2003. I have stored the username and password of the customers in the table named customer details. This means that each time a user wants to login to this system, they have to enter their username and password and click the login button. Whatever they've entered will be checked with the database. If the information they have entered is correct, then they will be able to login. Else they would not be able to do so, and an error message will pop up.
I want to know how should the code be written to be able to do as what i have explained above.
|
|
|
|
|
hope this little code will help you. here i am assuming that in 'customerdetails' table there are fields called 'uname' and 'pwd'. you call this function from you code and check for its return value, if it's true then the login is valid, or otherwise its invalid.
for the ConStr property contain connectionstring that will be used to connect to the database, you can use something like this : 'provider=microsoft.jet.oledb.4.0;data source=d:\database\BankingMS.mdb' where you can replace 'd:\database\BankingMS.mdb' with you actual database location.
'before placing this code, make sure you have imported system.data.oledb
public function IsLoginValid(byval ConStr as string, byval UName as string, byval Password as string) as boolean
dim c as new oledbconnection(ConStr)
dim cmd as oledbcommand=c.createcommand
dim da as new oledbdataadapter(cmd)
dim dr as oledbdatareader
with cmd
.commandtext="select pwd from customerdetails where uname='" & _
uname.trim & "'"
try
dr=.executereader
catch x as exception
messagebox.show("Cant connect to database.")
finally
c.close
end try
end with
if dr.hasrows then
dr.read
if cstr(dr("pwd")).trim=password.trim then
return true
else
return false
end if
else
return false
end if
end function
|
|
|
|
|
I used dataset and sqldataAdapter to retreive data from the sql database ,
I want to make few column of the database which are shown in the datagrid to be read only .
how can i do this ?
And which event should i use in order to validate the datagrid's entered data for each cell, and how it can be done?
Rajwant Mishra
|
|
|
|
|
I want to make few column of the database which are shown in the datagrid to be read only .
how can i do this ?
--->Use this : grid.Columns(2).ReadOnly = True
--->U want to specify the column number here.
And which event should i use in order to validate the datagrid's entered data for each cell, and how it can be done?
--->Use CellValidating event in the datagrid property.
Janani
|
|
|
|