I got a textbox with lets say 3 rows of text
1.Hello
2.My name is
3.Simon
And i got a listview that is on detailed...When i press a button: for each row listview item add.So the listview items will be 3 items, 1 item per row in the textbox thats on multiline.
i have a textbox and i want to find all of the words begin with the letter in textbox(for example a)
i know i should use "select * from tbl_search where Name like a% "
but it doesnt work for values in textbox.for example i wrote like this:
cmd = New SqlCommand("select * from tbl_search where Name like @value%") 'it gives the runtime error :"Incorrect syntax near '%'."
cmd.Parameters.AddWithValue("@value", TextBox1.Text)
Is it possible to declare a variable using the text of, lets say a string, as the name?If u dont get it im looking for something like;Dim Var + string1 As PictureBox..In the code "Var" is the start of the name and "string1" is the end of it so if string1 was "Hello", the picturebox would have been named VarHello.
View 2 RepliesHow can I count how many rows are returned by a dataset and then show the total number of rows as extbox.text and read-only so that the user can only see them but not change them?
so far I have this but it dosent return a number and says it cant find table 0:tbRecordsFound.Text = ds.Tables(0).Rows.Count
Ok i need to create a program that lets the user open a text document and lets him do the following. This is with Visual Basics 2008.
Count Characters
Count Lines
Count Words
Count All
I don't know how to get my program to count just individual words and i have no idea how to get it to do all 3.
[Code]...
I have a Data Table Column with multiple Rows of data. I need to search all lines of TextBox1.Text for any data that is identical to any row in the specified data column ("MCaddRG"). Also any identical findings need to be made into a new text file or a new form with a text box.[code]...
*Also if it is possible I would really like to have a check box list that contains the data from the "Device" columns so I could check the "Device" and then it search the TextBox.Text for the checked "Device's" "MCaddRG"
How to place text in textbox from multiple selected rows in datagridview with loop
View 4 RepliesI'm trying to make a program that lets you type "A" in a text box then it plays an audio file.
My code is: If MaskedTextBox1.Text = ("A") Then
LblPPG.Text = Val(TextBoxPP.Text) / (TextBoxQTY.Text)
This is the only way I know how to obtain the info I need for this equation but if generated again with no input from the textboxes I get an error. Is there anyway to bypass this if its generated a second time with no inputs?
I want to get the total of ROWS IN A TEXTBOX I MEAN LIKE THIS
quantity price subtotal
10 * 10 100
15 * 1 15
8 * 10 80
this is a exam.
so the total OF ( 100+ 15+ 80 = 195) To be shown
in the texTbox named" TOTAL " and so .with the other rows till unlimited if is possible
[code]....
I am trying to add the sum of a datagrid column to a textbox. There was a similir question in this forum but it doesnt add the sum of all the rows of that column to my textbox.
Me.SubtotalTextBox.Text = ABTDBDataSet.Products.Compute("sum(UnitPrice)", String.Empty) What else do I need to add to get the whole rows sum of one column and show up in the textbox.
Basically I need to make a program that lets a user browse and choose a folder, then I need a box that the user can then select the files to work with, then with the selected files I need to put them into a zip file. I'm trying to use a list view box but having all kinds of problems using the data in it.
View 2 RepliesI have just a few questions about the listview control,how do messegebox sub items lets say row2 col 2 and why cant (at run time) I select items in col 2 but only col 1.
View 2 RepliesI am currently converting a 90s VB6 application to VB.NET. While testing I came across something curious.A Modal form by definition will prevent users accessing any other form in the application.This I discovered is not always true as I have a Modal form displayed which allowed me to access its owner form's Menu.Searching MSDN I could find no mention of this feature. So I thought I would share it:Click Button 1 on Form2 and Form1 comes back to life!
View 12 RepliesI'm using VS 2010 and .net 4. I'm trying to figure out how to make a textbox be multiline and set the rows in codebehind.I'm trying to figure it out for a user control that i'm working on. So in the properties passed through the to user control it will set the textbox to be a multiline or not.
View 1 RepliesI have dgv with 3 columns id , name . email
so how to copy dgv rows to textbox each row in a new line?
I am facing a rather odd problem right now. If you fellow this : Best place to put key or password used for encryption? i was looking at a way to encrypt data. Using RSA seemed to be a good choice. However we have a problem since my requirements are thoses fellowing...Client must have a file encrypted in order to determine if the software is activated.
That actually mean that the client must read the encrypted file.. but the problem is that we actually need the private key to be there which isnt a good idea since some poeple could start making their license file using that key. The activation server encrypt the data file which are sent back to the client and then the client save that file.
Client must have a file encrypted in order to determine if the software is activated.Client sent user data to the activation server in unencrypted/encrypted form. That doesnt matter. Sure it would be better encrypted at this point.The activation server check that data and then determine if the client can be activated.If the client can be activated then the server send the encrypted form of the license file.. but the problem appear now.. there is no way to deencrypt the file on the client if the private key isnt on the client which would be pretty insecure!
I'm trying to make a hash calculator (For testing now)
I know that MD5 is a 1 way(Meaning that there is no decryption for it, yet)
now I was wondering if SHA-1 is a two way. Also, is there any other hashing method that are 2way?
reason is that I want to convert a long string (Lets say 550 chars) into something lower (From 550chars to something lower then 550chars)
I can use a Key, but every possibility will give me bigger length then the actual string.
Is there any way to create a web browser that hides your IP address and pretty much lets you surf the internet anonymously?
View 2 RepliesSo basically i need to make a loop that only lets the user click it ten times then gives the answer to them.i was gonna use a DO loop that looks like this so far.
Dim counter as integer
counter = 0
Do until counter = 10
loop
and after that i'm kinda lost on what to do, i know that its needs to be if you click btnenter 10 times give the right answer and then your done.
Using VB.Net,In my application, am using datagridview, when i clicking the particular row, that rows value should be appear in the textbox.So the code should be come under the DataGrid3_CellMouseDoubleClick Event.How to dispaly a rows value in the textbox.For Example
3 rows means - 3 rows values should display in 3 textbox.
vb6 code
Private Sub datagrid1_DblClick()
textbox1 = datagrid1.SelectedItem.SubItems(1)[code]....
How to write a code in vb.net by getting datagrid row values.
I'm trying to loop through all rows, and see if any match what is in the textbox. Would this work?
Code:
Dim dr As Data.DataRow
For Each dr In myQuery.GetMembers()
If UsernameTextBox.Text = dr.Item("mail") Then
[code]....
I have sqldatareader that picks up x number of rows, I would like all of them to appear in one textbox. Is that possible and how can I accomplish this?[code]
View 11 RepliesI put a form to Person Search.
Search for a name is entered into the TextBox,The results are displayed within the Data Grid
All information, data grid is 100 records
Now I want to go up and down keys to move between records
While my focus is Text Box
I have to create an application that lets a user enter as much grades he wants. The grades are between 0 and 100 and they can't be negative. Whenever the user type -1, the application is done and it shows the average of the grades, the lowest and the highest grades.I absolutly have no idea where to start but i must be using loop/do/while.
View 4 RepliesI have a little situation and i am not sure of the best way to do it.
- My program lets the user select a folder
- From that folder i need to select all .png files
- One by one i need to load them into a picture box, await a button press and then go to the next image.
The above that i have typed in red is where im not sure what to do. The other steps i can do.
is it possible in design mode to set the textbox text property to the text property of a textbox in a different form in vb.net?
View 1 RepliesI've made a small game that lets the user move a picturebox around with arrowkeys. The monster picturebox is moved towards the player and keeps growing while you are "alive". If it touches you, you lose.
How to improve my code. Im the worst ever at OOP programming. The main reason is i dont understand how i can pass variables between subs/functions e.t.c. I've read up on overloading operators but i dont feel that i can grasp it. If someone has any comments or any simple examples on improving my ability i wouldnt mind hearing them ^^
This is what i have now. Attached project (with "graphics") without .exe files and all code is also below. Also an image of what it looks like below.
CODE:
I'm trying to export a listbox (lets call it Listbox1) to excel 2007 and I'm having some trouble with it. Listbox1 contains just one column of items but the list itself is able to contain more 30 items.I have this script and it does something but, the most important thing doesn't show up: The list as in listbox1...
'Dim oExcel As Object
'Dim oBook As Object
'Dim oSheet As Object
[code]....
I'm working on a project. Part of the project needs me to capture data, for example, email address, from certain rows/columns of a datagridview and displays them in a textbox on another windows form(form1.vb) with a click of a button(Add Contact button). I am familiar with doing these in web form but windows form are different and i am not familiar with it.
View 11 Replies