I am trying to write the value of 3 variables (Username, Email, Password) to an SQLite Database. I can write text to the database but not a variable. How would I do this?
My Code:
SQCommand.CommandText = "INSERT INTO login_data (username, password, email) VALUES (Username, Password, Email)"
I have a question about storing formulas on a database and bringing them back in as a string. I want to have the user enter in a width and that number will be passed to intWidth. Lets say a user enters 8 into txtWidth, strRange will = "Less Than 10" and in the database I will have a Width_Range column with "Less Than 10" and a corresponding Equation column to go with it. If I have a formula such as (1800 * 1.8) saved in that database column, the code I have works and does the calculation.
[Code]...
Dim
sqlquary2 = "GET Status from Members
WHERE Username='" & UsernameTextBox.Text &
"';"
[Code]....
This is probably so simple however my brain has decided it wants a night off. I am trying to write a program that uses SQL queries for various tasks but I need it to allow the user to be able to use which ever name they want for the database name. therefore I need to be able to reference the database as a string variable. For Eg:
[Code]...
I'm looking for a way to search a string variable for two words and copy the text in between them into another variable. This needs to be done as many times as the match occurs.
View 3 RepliesSay I have something like this
Dim Level1 as Integer = 83
Dim Goal as String
Goal = InputBox(" What level is your goal?")
[code].....
I am trying to insert a string variable inside of two strings, and make a combined string. Public Sub Page_Load() Dim Id As String Id = Trim (Request.QueryString("Id")) End Sub Dim mp3text as string url... & Id & ".mp3" My goal is to make the mp3text variable have a string that is: url...(If Id is 7) It is for some reason not connecting up correctly. I checked what string it is outputting and this is what it is giving: url...It is missing the Id content.
View 12 RepliesThe code below works for the class that I hard coded "XCCustomers" in my RetrieveIDandName method where I use CType. However, I would like to be able to pass in various classes and property names to get the integer and string LIST returned. For example, in my code below, I would like to also pass in "XCEmployees" to my RetrieveIDandName method. I feel so close... I was hoping someone knew how to use CType where I can pass in the class name as a string variable.
Note, all the other examples I have seen and tried fail because we are using Option Strict On which disallows late binding. That is why I need to use CType.I also studied the "Activator.CreateInstance" code examples to try to get the class reference instance by string name but I was unable to get CType to work with that.When I use obj.GetType.Name or obj.GetType.FullName in place of the "XCCustomers" in CType(obj, XCCustomers)(i)I get the error "Type 'obj.GetType.Name' is not defined" or "Type 'obj.GetType.FullName' is not defined"
'+++++++++++++++++++++++++++++++
Imports DataLaasXC.Business
Imports DataLaasXC.Utilities
[code]....
I am trying the following code using vb.net and have managed to capture the running application values via portmon... look likes below and connects with success:
QUESTION: What is the HyperTerminal Equivalent string value for this Keystroke Sequence: Ctrl-A Shift-V Ctrl-B 02 1234512345 Ctrl-C Ctrl-M The above works great using a windows HyperTerminal window and writes data to the device.
[Code]...
These is the content of my txt file which is saved in D drive in my pc abc,1,2,3..I tried the flowing but it didn't work:[code]I am getting error on this line.. data = line.Split(","c)...it says this line isn't in use anymore or something and that I rather use LineInput but thats asks for filenumber and i don't know what that is. I am sorry but I am a complete beginner. what else can I try? [code]ok that error is gone now but now if I want to add these values to a list box..how can i do that?
View 1 RepliesI have a List(of String()). I have written a custom comparer (implements IComparer(of string)) to do an alphanumeric sort.Is there a way to sort the List using a given index to determine which position in the String() to sort by? In other words one time I might sort by Index = 0 and another time by Index = 3. The length of all String() in the list is the same.For reference this question is similar to Sort List<String[]> except I am using VB.net and that question is hardwired to Index=0.
EDIT from OP's comments:I started simple with the non custom comparer but I am getting an error: expression does not produce a value. Not sure what I am doing wrong.Here is the code:
Public Shared Function SortListOfStringArray(ByVal ListOfStringArray As List(Of String()), ByVal SortByIndex As Integer) As List(Of String())
Return ListOfStringArray.Sort(Function(x, y) x(SortByIndex).CompareTo(y(SortByIndex)))
End Function
I have a long UTF8 encoded text string. The actual values stored in the string are hexadecimal. I want to convert the encoding and save to a binary file.
Is there a simple encoding.convert or other method to do this with?
Basically the output is twice as large as it needs to be right now. The long way of doing it would be a routine to go through the string two characters at a time and convert to byte array and then .writeallbytes I guess. It seems there must be a simpler way of converting this?
I've set the colour of a label using the ColorDialog and I want to read the chosen colour value into a string, using the following
ColorDialog1.ShowDialog()
label1.ForeColor = ColorDialog1.Color
For example, I have chosen, say, blue as the colour.. How would I read this value into a string, or the hex code for this colour?
Basically I want to write to a database, lets say called testdatabase, and I want to write to a table called dbo.Test_table, under three different colums named one two three. How do I go about this? I created a data set connection to the database but it sits on the right hand side with the other forms and I dont know how to use it or write to those colums in the tables.
View 3 RepliesI have written a program which reads the text from the text file cleans it for some specific letters or phrases and then saves it in another text file. I am having a problem in rewriting the processed or cleaned data (after it has removed some phrases and characters)onto writing the file.
I have successfully written the text on the file except one problem. In each loop when each string is cleaned and is written on the text file, it overwrites the previous string. What I want is that it should write in the next line or in the same line.
My code is given below:
Private Sub btnopen_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnopen.Click
FileOpen.Title = "Please select the file"
[Code]...
how can I write the text in the new line and avoid overwriting of text in my text file.
I have a fairly old radio receiver. (Icom R70) A friend and I have built an interface to control it from my computer. The interface is parallel. For me the interface is a black box. (My friend is the electronics specialist) In the description (25 years or more old) the statement to set a frequency and receive mode (like Am, FM etc) on the receiver is:print ".0:087330"
Today I am working in VB.Net and on Windows7 pro. I have already spent several days figuring out how to do this, but can't get it to work.I have found inpout.dll, but that does only allows me to write one byte at the time, and if I break up the above string and send nine individual characters, it does not work.
I'm makin an application which will calculate the amount of carpet needed to floor a room, i would like to add in an order management bit too the application so that the user can add, delete and amend pending jobs. I'm a bit of a beginner so i don't know which way is really best to go, should i use file writing on database? I will be takin values from variables and textbox's if thats of any importance.
View 13 RepliesI have a table in a database with 3 columns: OfferName, ExperienceAward, and GoldAward
I populate a combobox with the various offer names with the code below:
Dim con As OleDbConnection = New OleDbConnection( _
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UsersDouglasDocumentsVisual Studio 2008ProjectsGameBoxRPGGameBoxRPGContacts.accdb;Persist Security Info=False")
Dim cmd As OleDbCommand = New _
[Code]....
I'm currently under way with a computing project for 6th form and I have encountered a problem when working with a local database.
To give an overview:
-My program is intending to take in data on lorries, drivers and other sections of the haulage industry through multiple forms and afterwards be returned in a suitable manner.
-I have no trouble in reading data from my database that I have set up. However I am unable to write back to the database.
-I can add the relevant new data to either the specific table(Driver_Table in this case) of the Database1DataSet.xsd or to a table set up in this manner.
-My problem is with the Driver_TableTableAdapter.update method.
-When I call this it returns a value of 1 (for one row added) but does not write this to the database.
In specifics the particular section (created to test this section of code) is:
'Dim tbl As New Database1DataSet.Driver_TableDataTable
Driver_TableTableAdapter1.Fill(Database1DataSet1.Driver_Table)
' Driver_TableTableAdapter1.Fill(tbl)
[code].....
Im trying to get my program to fill out textboxes with information it reads from a database, and then save the changes to the database. Does anybody know any good tutorials of this which i could look into?
View 6 RepliesI've two Strings which I'm loading from a SQL Server 2008 database (nvarchar-field)After loading them from the database Visual Studio 2010 displays them as follows in the watch window:
str1 = "Test"
str2 = "Test"
But the comparison with str1 = str2 returns False If I write those strings to a file with UTF8 Encoding the result is as expected:
Test
Test
If I write those strings to a file with ANSI (Default) Encoding the result is NOT as expected:
?Test
Test
Converting the strings to bytes:
System.Text.Encoding.Default.GetBytes(str1) 'Returns ByteArray {63, 84, 101, 115, 116}
System.Text.Encoding.Default.GetBytes(str2) 'Returns ByteArray {84, 101, 115, 116}
System.Text.Encoding.UTF8.GetBytes(str1) 'Returns ByteArray {239, 187, 191, 84, 101, 115, 116}
System.Text.Encoding.UTF8.GetBytes(str2) 'Returns ByteArray {84, 101, 115, 116}
Where is the Byte 63 in case of ANSI Encoding OR Bytes 239, 187, 191 in case of UTF8 Encoding for str1 coming from?Well, Bytes 239, 187, 191 are the BOM for UTF8. The question here would more likely be: Why do I get the BOM for str1 but not for str2?(Well, the values are values passed to a webservice which inserts them into the database, the initial values are passed to this webservice by a client I've no control over)
Well I basically know how to read a text file, replace text then write to one. how to append text after a specified string (ie, insert text at a specified line, removing the text after a string in a line and changing it without altering other lines, etc). Can someone please tell me how I would go about adding a string after a certain string in a text file? For example:
I Have:
test
example
hello
[Code]....
I'm outputting a number of variables to a text file and each field needs to be in a specific place.For example:I have a string that is varying in length, but will never be more than 5 characters. The string has to end on the 8th character of the line. Is there a way to write the string to ensure that the string ends at a specific place on the line, regardless of the length?
View 4 RepliesI can write a 1-d string array to file with:
Dim test() As String = {1, 2, 3, 4, 5}
File.WriteAllLines("C:MyFile.txt", test)
but can't see how to write a 2-d array to file.
I've tried this:
Dim test(,) As String = {{1, 2, 3, 4, 5}, {34, 22, 12, 33, 55}}
Dim myfile = File.CreateText("C:MyFile.txt")
Dim row, col As Integer
[Code].....
I've made a function to convert a number and fraction string eg. "22 7/8" to decimal. I've no problem pulling the data from the current row cell to pass through the function. Checked it via a temp textbox i put on the form. What i actuall want to do is pass it back to another cell on the current row. Tried a few things but having no luck. Here's the code of what works. The name of the cell i'm trying to pass the result back to is called "BaseDec".
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim fact As String
[Code].....
I am writing the code as on if statement that if the html class has strings called "<a id=""rowTitle1""(.*?)</a>" then do something. In what property that come after pattern that I could check the string whether if it valid or not??
View 13 RepliesI want to be able to click on the save icon and have the data on the form save to the original database. Right now I seem to have a disconnected dataset I have tried to change everything from read only to a false statement but it just will not work. It saves to the form fine just not the orignial data base.
View 3 RepliesI have written a program that has a form called AddMembers. it is supposed to get users input from textboxes and write them to an access database. but I am getting an error message Argument not specified for parameter. Also my results are not sent to the database. I have attached both the zip program and also the database.
View 9 RepliesI'm currently doing a project, I have 5 text boxes, and the information I put inside them get's added to a record in my database..In this record, an auto-number is allocated, and I need to display what the auto-number allocated is..
View 7 RepliesI am trying to write data back to my database in my project, but it keeps disappering when I make any changes to code. I can build the project, add data, close the project and build it again and the data is still there. But as soon as I make any changes to anything, on the next build, all of the data is gone.
The table will not be bound to any controls in the final project, but for testing purposes I have a datagrid control that it is bound to. My code started as follows:
[Code]...