I have a small database from which I need to select specific data for my Windows Form Textbox.I have a table in a database with a few columns: "ID,Date,Val1,Vla2,Val3,OK" (int, date, int, int, int, bool). There are several rows, but only one of the rows has the boolean value as 1 (or 'True').I would like to select all of the information from that row and write it to different TextBoxes.[code]
View 13 RepliesI am new to VB.net
I have a simple form with two textboxes, I want Textbox1 to write to a file named C:VALUE1.txt and
Textbox2 to write its value to a file named C:VALUE2.txt
Any text that is already in the text file MUST be over written.
Is it Possible for me to read text from textbox control and write it to .txt file at specific location.
for an instance.... say below with quote is my Text in .txt file:
"THE QUICK BROWN FOX JUMP OVER THE LAZY DOG"
and with programming code I want to change some text in the same sentance become....(see below)
"THE QUICK GREY FOX JUMP OVER THE LAZY CAT"
so you can see the word BROWN change to GREY and word DOG change to CAT
if i have 4 lines in a text box and i only want to add new text to line 3, how can i do so..i would like it to delete previous text and/or overwrite it.
View 2 RepliesIs there a way to write a program to go to a specific website, enter some things injto textboxes, and then click a button? I want to use this to log into some of my accounts for other sites once a month, Instead of entering the username and password manually.
View 2 RepliesIm just trying to figure out how to write an LDAP query to list all of the PCs in a specific OU.
View 3 RepliesIs there a way to write text between html tags?like <textarea>TEXT HERE
View 7 RepliesI'm amazed at this situation. In QBasic, you could just easily GET and PUT whatever you wanted at the exact position in the file that you wanted. Now in Visual Basic 2008 I'm just completely stumped.
I can't use FilePut or FilePutObject because of a twisted issue. It adds a couple of bytes to describe the length of the data being written: what's the point of BINARY read/write if it won't allow you to write EXACTLY what you want and nothing less or more? There's a way to turn off this issue, and that's by setting the parameter StringisFixedLength to TRUE, but that's where the twisted part comes in. You can't do that. As far as I can tell you have to redefine the function using SUB, for example:
[Code]...
My.Computer.FileSystem.WriteAllBytes. To my amazed surprise, this function doesn't even bother to include the possibility that I might want to put the data in a specific position within the file! I can't believe this. You can either specify to APPEND at the end or not, in the latter case apparently resulting in a write to the beginning of the file. No option at all to specify where in the file you want to put the data. I can't believe this.
How do you write to a SPECIFIC position in a binary file in VB 2008, and do it without the program deciding to add a few "informative" bytes to your data before it's written (totally undermining the whole point of binary files)?
I am using impersonate user to copy files form one location to other.
Only impersonate user will have write permission on the destination folder.
But i want to check before if that user has write permission before i copy file.
Currently i could able to get it using try catch exception, for that i need to perform the copy file process
I have two part in text file. Let say Part 1 and part 2. I want to write part2 in different file and part 1 in different file.
View 5 RepliesI am using impersonate user to copy files form one location to other.Only impersonate user will have write permission on the destination folder.But i want to check before if that user has write permission before i copy file.Currently i could able to get it using try catch exception, for that i need to perform the copy file process.
View 7 RepliesHow I can do this? generate Textbox and button, If I write 5 in textbox? 5 Labeles will apear
View 3 RepliesI am writing a program where I would like the user to be able to save the contents from multiple textBox into a file and the retrieve the contents late.
View 5 RepliesI'm using a pattern of buttons verticle, & horizonal, to produce a 2 dimensional matrix (6 deep, 25 wide .) The sequence is repeating, but offset from horizonal line to line. the values are 1 thru 12. there are corresponding files in the "My.resources." file carrying names related to the buttons. If the "my. Resources" filename is say.., "1,3,4,6,8,9,11,12 " & the buttons pushed have produduced the string "1","4","6" then the prestated file carries all these values, and therefore should be selected. All integers of the textbox list must be present in a "my.resources" file to show the file. There will be multiple files in the resource file that will fit. (My ultimate intention is to show all files that fit, somehow. I'll have to, eventually. I'm still writing this, and changing it constantly. )the question is, "How do I get the computer to link the textbox integers to the resources files? Textbox = "1", "4", "6" to My.Resources.1,3,4,6,8,9,11,12
View 1 RepliesIn VB.NET, let's assume I have the following Structure:
Public Structure Product
Public ItemNo As Int32
Public Description As String[code].....
How would I define a LINQ Query to Sum all of the Product.Cost values in the List? In other words, what would be the LINQ Query in VB.NET to return the value 120.90, which reflects the sum of all three Product Cost values in a single LINQ Query?
I am having a string in CSV format.http:[code].....I can add new values to it by some mechanism. Everything will be same except the new values will have numeric part = 0. Take example I have this exsiting CSV string
1 , abc.txt , 2 , def.doc , 3 , flyaway.txt
Now by some mechanism i added two more files Superman.txt and Spiderman.txt to the existing string. Now it became
1 , abc.txt , 2 , def.doc , 3 , flyaway.txt, 0, Superman.txt, 0 , Spiderman.txt
What i am doing here is that this csv string is paased into SP where its splitted and inserted to db. So for inserting I have to take the files with numeric part 0 only rest will be omiited .Which will be further then converted into CSV string.Array will look like this
str[0]="1"
str[1]="abc.txt"
str[2]="2"[code].....
So at last i want to say my input will be
1 , abc.txt , 2 , def.doc , 3 , flyaway.txt, 0, Superman.txt, 0 , Spiderman.txt
Desired Output:
0, Superman.txt, 0 , Spiderman.txt
I have a program which grabs the source code of a webpage and puts it into a string. I would now like to search the string for two values.
"video_id": "value 1 here"
"t": "value 2 here"
The problem, is that I don't know the position of the values, and I the values change depending on each webpage. All I know, is the text before the value, e.g. "video_id" and "t:"
Here is my code:
Dim videoid As String = TextBox1.Text.Trim
Dim wc As New System.Net.WebClient()
Dim result As String = wc.DownloadString(videoid)
I wish to display values of 2 decimal places whenever this field (datatype = smallmoney) is being read & displayed via a SQL select statement. Is there a simpler way out besides the following example? Im using VS 2008,
CONVERT(varchar, CONVERT(smallmoney, ABS(reading_i - reading_f)), 2 )
I have a datatable contain fId field. I want to update all values for this field to "1" without using loop. [Code]
View 1 RepliesI have a datagridview in my project that is loaded with data from a SQL table when the form loads. One of the columns contains names of users in the database. I'm wondering what is the best way to the number of times a name appears in the column. For example, the user name "Rob Smith" might be listed 12 times in the column,I'd like to pass that number to a textbox.
View 3 RepliesI am making a game and decided to add a high score section. I currently have this code setup to insert and read from the database, I set the insert code to a bottom just for testing purposes.[code]There are three columns in the database rank, score and name. I set the rank to auto number so the database would assign the player rank automatically, how would I go about inserting the score into the relevant place inside the database and moving the other scores to their new relevant places?
View 1 Repliesi have a problem regarding datagrid.remove and textbox. This is a Function to Add and Subtract Values on a specific Column. If I cellclick on the main datagrid on a specfic row which has record where the record goes to the other datagrid with no record yet to be filled with record, the textbox will count/ add all the values from the UNITS COLUMN and in an instance on one row removed in the other datagrid, the total value of units in the textbox does not subtract or less. here's the code.
Public Function total_units_remove() As Double
Dim totalunits As Double = 0
Dim i As Integer = 0
[Code].....
I want to look up a value in column B and if the value of the cell in column b matches my searched value i want to look up a value in another column. If both values match the values i am searching for, i want to exit the while loop.
If there is no row that contains both my values in the range of cells, that contain any value in column b i want to exit my while loop.I am literally crying, because i just can't get this done.As you can see i am trying to do this via a for each loop.
there are so many things that didn't work so far...the rows 3 to 6 are filled, but rows 7 to 10 are empty. row 11 is filled.the counter returns the value for counter, that shows, that only not empty cells or rows were counted. I just don't get it. A already wrote, that if the cell.value is nothing, counter shoul be incremented, but this didn't seem to work.I also tried the findmethod in vba, but couldn't get it to work.
my code:
Code:
Sub GetSumme()
'====================================================================================================
' Dieses Sub summiert die zu kaufenden und verkaufenden Mengen. Wichtig f�r den korrekten Start
' im aktuellen K�stchen ist der Wert, der in "bearbeitet" steht. Das ist ein fortlaufender Wert, der
[code]....
I have a datalist in vb web form.How can i get the value in a specific rows and cells of a datalist?I could do it for detailsview but how to do it for datalist?Below is my code for detailsview: Dim selectedCommentAns As String = DetailsView.Rows(0).Cells(1).Text.I tried the same way for datalist but it dont have rows and cells to be selected.[code]
View 3 RepliesI'm trying to build an application wich shows some info about a specific user. The info is stored in an Excell sheet.
What I want to do is this: I'll have the user fill a field with in example the logon name. Now I want the application to search the Excell sheet for that record and list the info into seperate fields on my form.
I have column in database
[Code]...
I want when any user search For: Delhi to Manali on between 17-Dec-2010 to 19-Dec-2010 then the price would be automatically changes to $900 in gridview else the default price wold be displayed in fare is $600 if he search for DelHi to Manali after 19-Dec-2010.
This is kind of a brain twister. First, what it involves. I'm writing an application that is working with values sent to and received from an 8 bit micro-controller. There are 8 bits of specified values. Here they are. bit1 = 1, bit2 = 2, bit3 = 4, bit4 = 8, bit5 = 16, bit6 = 32, bit7 = 64 and bit8 = 128.I made a routine that uses 8 checkboxes to add the values for sending them to the micro-controller. That wasn't too hard. In my appp there are 8 checkboxes. Each checkbox assigns one of the specific bit values to a variable (or subtracts it when unchecked). The total of the variable is then displayed in a textbox and ready to send.Now the hard part that ed to take any number between 0 and 255 apart in values that will be a combination of the numbers (1,2,4,8,16,32,64,128) above and show each checkbox which is assigned those numbers to be checked.
View 6 RepliesHow to reconfigure code to output specific values rather than collection
View 2 RepliesHow can I iterate through a listview that has checkedboxes and get the value of the first column? The listview has 3 columns, "ID" "Survey" "County". I want to get the value of the "ID" column for the items that are checked. I've been using the following code, but can't figure out how to proceed. am I on the right track?
[Code]...
I currently this code on my app that works great to loop through a page and grab the label of an input value of a form and then print the value to a rich text box.I am now trying to revamp the code to give me the ID the value if the label contains a specific name.For instance if the label before the input field contains the word Username then I want the application to output the ID of the input field rather than just everything that has a label.
Here is my current code:
Dim web As HtmlAgilityPack.HtmlWeb = New HtmlWeb()
Dim doc As HtmlAgilityPack.HtmlDocument = web.Load("http://shaggybevo.com/board/register.php")
Dim nodes As HtmlNodeCollection
[code]....