I am trying to retrieve a password from an SQLite database. The id of the row the password is in is 1. I want to assignt his password to a variable called actualpass.[code]
View 1 RepliesI have 10 checkboxes on my screen. I have a variable setup called "case" as a string. I want to know how I can say:
If checkbox1 is checked then case would be equal to "this".
If checkbox2 is checked then case would = "that"
Example of something I tried to cook up but didn't work because it tells me that I can't only use this in a "select case".
Dim Case as string
If checkbox1.checked = true
case = test1
end if
If checkbox2.checked = true
[Code] ......
I just started using VS2010. I am very familiar with Visual Basic 6 and was very comfortable with it.I was able to take a variable and assign a database field to iwithout using data binding. I can't seem to figure out how to do thatin VS2010 What I am trying to do is have the use enter a password to gain access to the program. The password is stored in a database so that the user/owner can change this password to suit their preference.
View 1 RepliesA stored procedure returns data about a user record including a nullable datetime column for their last login date. Which one is the better choice in dealing with the possibility for NULL values when trying to assign a .Net date variable?
Try
_LastLogin = CDate(DT.Rows(0)("LastLogin"))
Catch ex As InvalidCastException
[Code]....
Which is the preferred method of handling possible NULL values from the database? Is there a better way than the three listed?
Edit #2: I have noticed that the TryParse method does not play nice when trying to assign to a Nullable type.
I have this records in the table:
username, password, rights, allowance
admin, asdf, admin, 20
john, qwer, user, 10
peter, zxcv, user, 10
I want to select one record at a time
I used:
for i as integer = 1 to sqliteDataReader.FieldCount
dim ss as string = "select * from xtable where recno()=" & Ctr(i)
...
Next
But it doesn't get 1 record at a time.
I have a date/time variable stored in a column in an SQLite table. I need to select the string with the last 3 digits trimmed off. [code]
View 1 Replies'm trying to store a new value within a variable and then compare it to the previous value of that variable using the Math.Min method. I have created two seperate variable 1 for the previous and one for the new but I can't seem to store it
View 1 RepliesUsing VB.6, I am trying to assigning a value to a string variable but it causes an error. I am doing that in following way:
Dim a As Variant
a = "<div style="width: 400px;"><img title=""
Scenario: Writing a scanning program, thing is I can't have duplicate file names(which I generate). The img file paths r saved in a database.I'm trying to write a function that will return all the records I need using a SQL SELECT. To make this work I need to put all the retrieved records(just the one field from the database) into an array.My Problem: I have no idea how to put the retrieved SQL query into an array and then return it.
Private Function fileNameAcquisition(ByVal path As String, ByVal id As Integer) As String
Dim conn As New SqlConnection
Dim dr As SqlDataReader
[code].....
i'm working on a code that i want to start creating new classes with but i want to know if there's a more direct way to send the variables used in the form to a new class for storage.
for example i've got this on a form...
Dim ClassID As String
Dim ClassName As String
Dim Grade As String
[Code]....
you know? so what would be my most direct route to get this? how should i start?
Any way to assign a binary value to a vb variable? All of the obvious choices don't work. I've tried prefixing with &B, appending with b but nothing seems to work.For clarification, what I was looking for (which does not appear to be possible) was how to assign a literal binary number to a variable, in a similar manner in which you can assign a hex or octal number. I was just looking for a more visually engaging way to assign values to a flag enum.
Dim num as Integer = &H100ABC 'Hex'
Dim num2 as Integer = &O123765 'Octal'
Dim myFantasy as Integer = &B1000 'What I would like to be able to do'
Dim myReality as Integer = 2 ^ 3 'What I ended up doing'
This line of code references a checkbox in a Gridview, how can I assign the value of the check box 1 or -1, I think it is for checked or unchecked, to a variable so that I can run an if statement against it, and change it to True or False?
dt.Rows(row.DataItemIndex)("DisplayString") = (CType((row.Cells(3).Controls(0)), CheckBox)).Checked
How can I assign a variable which may contain a null value to a variable which is declared as Dim var1 as String and then use that variable to insert into access database table?
View 3 RepliesI would like a label to always show the current value of a boolean. This will change a lot of times and would like the label to ALWAYS reflect this.
Is there some kind of way to have the label set to the boolean byref (so its always the same). Currently I'm assigning the label.text = boolean onLoad, so if the boolean changes after that its not reflected.
I'm working on my final for VB.NET, and maybe it's just late...but here's how it goes. I need to make a variable named intMoney and it will be used to keep track of how much money you have and the value will be displayed in a label. Since this 'game' will have a lot of things going on, it needs to be available in a lot of places, not just one click event.
But I need to set intMoney to a starting value of 200 and then assign intMoney to a label called lblMoney. I can't assign intMoney to lblMoney in global. I get build errors. Where should I put the lblMoney.Text = intMoney?
I have the following function that checks if a date is on a holiday or weekend and returns the first non-holiday or weekend date.
vb.net
Private Function CheckDate(ByVal D As Date) As Date
TempDate = D
[code]....
The function does return a date. But when I try to assign it to variable, it assigns a time instead. Both tempdate and newdate are declared as date also.
vb.net
TempDate = CheckDate(NewDate).Date
I am trying to save a row to a variable so that I can remove it from the DataTable and then add it at a different index. thing is, the row that is added is empty of the information from the data row. I'm thinking the DataRow is not saving to the variable properly. Here's my
Dim row As DataRow = dtFolderList.Rows(MoveIndex)
I'm 99.99% positive I found out how to do this like last week or soemthing but can't for the life of me remember where I found it or how to do it.
Once I have filled a dataset is there a set of properties or in-line functions that will allow me to pull the data out of said dataset without having to populate a datagrid?
Code example:
Connection.Open()
accCommand.CommandText = "SELECT CustID FROM Rental WHERE DvdID = " & DvdID
accCommand.Connection = Connection
dvdDataAdapter.SelectCommand = accCommand
accCommand.ExecuteNonQuery()
dvdDataAdapter.Fill(dvdDataSet, "CustID")
Connection.Close()
I know the information returned from the query is a single value located at (0, 0) I just can't get to it so I can assign the value to the variable.
I have the following function
Public Function GetPositionBySchoolID(ByVal SchoolID As Integer) As CPAPositionsDataTable
Dim positions As New CPAPositionsDataTable
[Code]....
And I was wondering if there is any way to cut out assigning the LINQ result to tmp and just work with the result directly, i.e.
Public Function GetPositionBySchoolID(ByVal SchoolID As Integer) As CPAPositionsDataTable
Dim positions As New CPAPositionsDataTable
[Code].....
I want to assign a Value to a Variable of Decimal Type to do a calculation, but when I enter the decimal value (a 28 digits to the right of the decimal point - very long numbers) it gets altered. I give below what I was doing:
Dim MyNumber As Decimal = 0.7777777777777777777777777774
But as soon as I finish typing the number, it becomes 0.77777777777777779 and appears as,
Dim MyNumber As Decimal = 0.77777777777777779
And, when the cursor is kept over the altered number it shows as "Double, Represents a Double - precision floating-point number." How can I get the value I wanted to stay without getting changed? I was able to get this long Decimal value as the result of a calculation and get that appears in a text box in the same program. Is there anything I should change in the "Visual Studio 2008" to get this ?
What I want to do is either trivial, or likely impossible in the .NET framework.
I have a number of forms, with various pictureboxes, labels, etc. in each. Same names for the same items on each form. Only one form is visible at a time. What I need is some way to assign to a variable in the code which form is currently in use, such that I can reference the control on that form in a single statement.
That is, I have set up (already) references to the individual forms (call them frmForm1, frmForm2, etc.). So I can write to a textbox as:
frmForm1.textbox1.text="Hi there."
frmForm2.textbox1.text="Hello world."
What I need to be able to do is something like:
currentform = frmForm2
currentform.textbox1.text="Display on visible box"
Is such a thing even possible? Obviously, the way .Net normally wants to work is to verify everything at compile, and there is (of course) no way for it to know if whatever "currentform" points to even has a "textbox1" control.
save me a LOT of long-winded IF-THEN-ELSE to see which form is currently displayed for each and every time I want to display something. [FWIW, I *could* right everything out to every form, but I feel that would waste to much CPU time.]
I am writing an app that uses both an SQLite and MySql database. The reason for this before you ask is that it means I can store a local copy of the data onto my user' own machines when they are offline, and then update them to a central server when they are next online.
The problem I have is that when using datasets (on tables created in identical fashion) the itemarray of the mysql database has 9 extra totally blank fields...where as the SQLite itemarray has only the values for the items.
here is a snippet of the code:
CODE:
ultimately I am getting an index size mismatch error but with both tables having the same number of fields this is confusing.
i am deleting from an sqlite database using the ids of the records like this the dirID is an array of the IDs Dim i As Integer = 0
[Code]...
the problem is that it dosen't alwasy delete from the database, and its not throwing any errors. Could there be a better way of deleting
I'm a newbie in programming and visual basic 2008 language.I'm learning to use sqlite database in visual basic 2008, and I got the following tutorial code. The code is working correctly and my question is: what is the meaning of that ! mark in the code. Please point to me where to get more information as I wish to learn more about that. I have Windows Sdk v6.1 installed.
[Code]...
I would like to create a filepath and assign it to a string (so that it can have yet more added to it later on in my program) the code takes (well i want it to but it doesn't) the name of a drive selected previously and then adds this to a string to create a string variable that refers to a file. and then (as usual) i want to use thes files and display them in a combobox but i want to only select files that have a pre selected 2characters at the front. I have got this code so far:
' search for filer drive NETAPP-1
For i = 0 To frmDatabase.drvDB.Items.Count - 1
If InStr(frmDatabase.drvDB.SelectedText(), "\Netapp-1malika", CompareMethod.Text) Then
[code].....
I am using SQLite ADO.NET Provider.
I want to create a database with 2 tables via code in vb.net .
Please provide code for the same.
I am using VS 2010 Winforms, working under XP SP3 Pro
I'm writing a program that needs to parse data from a SQLite Database, I have the reference DLL but I do not know the proper syntax for the actual parsing of the file. The reference I have is located at [URL]..I don't really see any code that would need to be given seeing as the code for that class is currently something link:
Imports System.data.SQLite
public class SQLite
public sub Retrieve_Data
end sub
public sub Connect2SQLite
end sub
end class
I'm trying to read a BLOB from a SQLite Database.
View 3 RepliesI am using System.Data.SQLite with VB 2010 to bind to a SQLite database. Everything works just as it did in VB2005. I drug a table from the DataSources Window onto the form and automatically generated the binding navigator, table adapters, etc. I can preview data in the TableAdapter but when I run the app no data is read into the grid. The same thing happens with the details view. The BindingNavigator shows 0 of 0 records. There are 27 records visible when I preview the data. The code follows:
[Code]...
i'm just starting with sqlite, as apparently its quicker than access for a real time logger. i'm using this as a tutorial - i didn't install the runtime support with SQLite as it causes issues when using 2008 express.[URL]..
but it seems the data isn't being written to to the db. i can't tell exactly because i dont have a program to view the table contents, only to view the setup of the db.