Richard Alvarez
Last Activity: Feb 5 '12, 12:19 PM
Joined: Apr 14 '11
Location:
-
ListView Background Color
Anyone please help me this problem. I am creating a program that will view all the employee list in a listview control. Now every employee has the property of whether "active" or "inactive". What I want is to change the full row background color of "inactive" employee to red. I tried to do some forum suggestions but it didn't work. Somebody please help me. -
SaveSettings & GetSettings
hi to everyone, again i got this problem with vb6. I'm creating an attendance monitoring system with MySQL as its database. I use SaveSettings to save the server name, database name, username and password in the registy. Now this is my problem, how would i check if AppSettings(res ult of SaveSettings) are present in the registry or not. Thank you so much in advance. -
Thanks for the reply, really appreciate it but I've already got it running.. :D Thanks again.. -
Digital Persona FingerScan
Hello guys, I'm building an attendance monitoring application with DigitalPersona FingerScan and i can't make work to Store and retrieve FingerScan Template in MySQL database. I have a binary field where i put the template and i was able to save template in that field but unable to retrieve it. please help me with this. Thank you so much. -
this is the thing that really need. Thanks a lot with your help guys. :D thank you so much.Leave a comment:
-
yes of course that would be the one to use but we're already out of what the real problem is. How can I save and retrieve the image file within the ms access database?Leave a comment:
-
the user will browse for the image file that is to be inserted in the database.. how would i do that?Leave a comment:
-
Stretch image to fit pictureBox at runtime
Ever wonder how to imitate the Image control property stretch in vb6? This piece of code will do the trick...
...Code:Public Sub AutosizeImage(ByVal ImagePath As String, ByVal picBox As PictureBox, Optional ByVal pSizeMode As PictureBoxSizeMode = PictureBoxSizeMode.CenterImage) Try picBox.Image = Nothing picBox.SizeMode = pSizeMode If System.IO.File.Exists(ImagePath) Then -
by the way rsData in here is declared as ADODB.Recordset and DBConn is declared as ADODB.Connectio n 'active connection'Leave a comment:
-
about connecting to database; its clear enough with me. the problem is the process of saving and retrieving image files in an ole object.
also i want it to be in this king of format because uniformity in code is what i want to have in my works
...Code:If rsData.State = ConnectionState.Open Then rsData.Close() rsData.Open(String.Format("Select * from tblUsers where ID={0}", txtID.Text), DBConn, ADODB.CursorTypeEnum.adOpenKeyset,Leave a comment:
-
Picture User Control
Good day guys.. in the days i was busy creating this application that displays and saves an image file within the an access database. the field has an Ole Object property. is there a custom user control for this?
Its a WinForms DTR application. just want to have a quick/easy way of saving and retrieving image files in access database. i know that i have to work it out as a blob but the prob is that i don't know how to do it....Last edited by Frinavale; Oct 3 '11, 01:13 PM. -
Thank you so much, i really appreciate your help sir. I really do because this is the first time i learn about this bracket thing. Thank you again.Leave a comment:
-
I know that this is a dumb question but what is this "[]" for? (completely new to it :p)Leave a comment:
-
You mean something like this,Code:"Select * from " & [cboID.text], dbconn
Leave a comment:
-
DBConn is a public declared variable (Public DBConn as ADODB.Recordset )
I same thing that I first use to debug my code is to use a messagebox to dispplay the real value of the string. I even tried this
and got this output "Select * from TableName" with the quotes but...Code:Dim strSQL as string strSQL= Chr(34) & "Select * from " & cboID.text & Chr(34) msgbox(strSQL)
Leave a comment:
-
That was my mistake, the code that I posted was just a part of the private sub. Here's the whole code:...Code:Private Sub cboID_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboID.Click Try Dim rsData As New ADODB.Recordset Dim ListUsers As New ListViewItem If rsData.State = ConnectionState.Open Then rsData.Close() rsData.Open("SelectLeave a comment:
-
table names are created by the user at runtime.Code:Dim sql As String = "CREATE TABLE " & txtTabelName.text & " (StudentId INTEGER CONSTRAINT PkeyMyId PRIMARY KEY," + "Name CHAR(50), Address CHAR(255), Contact INTEGER)" cmd = New OdbcCommand(sql, conn) cmd.ExecuteNonQuery()Leave a comment:
-
yes i did and i did also try to assign a variable to hold the query string but still no luck.Leave a comment:
-
thank you so much for the quick reply sir, you've proven yourself a great help even on the first time that I ask question on this forum. cboID.text gives users the previledge to select what table he/she would use.Leave a comment:
-
"Syntax error in FROM clause"
good day guys, please help me with this code that i have. i'm having a "Syntax error in FROM clause" error. Here is my code, any help is much appreciated. Thank you in advance.
...Code:Dim strSQL As String = "Select * from " & Trim(cboID.Text) Dim rsData as ADODB.Recordset If rsData.State = ConnectionState.Open Then rsData.Close() rsData.Open(strSQL, DBConn, ADODB.CursorTypeEnum.adOpenKeyset,
No activity results to display
Leave a comment: