i have a string (the letters will never be in the same order):
TFTADFDAAFDADADDAFFDTFFTDFTFTDTTAFDAFADTAAATFDTADAFFTFTDDFDAFFTAT
1) i know it is always going to 65 characters (no numbers)
2) it will only have the letters ADFT
i want to loop through each row of data and check if the data contains this.
System.Text.RegularExpressions.Regex.IsMatch()
CODE:
That code works to read the entry data and to recognise the correct data, and the incorrect. However, even if entry is correct, the error msgbox will appear (x times of how many records there are in file), despite being navigated to the menu. Anyway that the Else isn't triggered when data is correct. Also for it to appear just one instead of (x times of how many records there are in file.)
I have a program for school project that has input fields for Name, Address, City, State and Zip. I need to error check so that the fields are not empty.I have used If statements that check to see if the fields are empty and shows a message box if they are but if I leave the whole form empty and click the button that activates it, all the if statements go- one by one instead of pausing for the user to input the required data.How do I check for data and make the program stay there until the data is input? I have tried TRY/CATCH but it won't catch this type of error.
this is the
'This program computes customer's bills at the pizza shop for all combinations of
'crusts, toppings, sizes and discounts
Option Strict On
Public Class PizzaForm
[code].....
I tried this code to check if the data in textbox1 not equal to any data in column name, so insert the data that in the textboxes to the table1. Esle.. do another thing. But it didn't success with me.
Code:
Dim conn As New OleDbConnection()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source =" & Application.StartupPath & "DataBaseName.mdb "
[Code].....
an application i developed using vb 2008 express, to fill a web form with data from an access database, one after another when a button is clicked hasn't given me what i expected. the loop was suposed to stop after filling web form with the first data on clicking a button and continue to fill the webform with the next(2nd) data from the database on clicking the button again. Below is the code i wrote
Private
Sub STARTButton_Click(ByVal
sender As System.Object,
ByVal e
[Code]....
i have publish data on data grid(in vb express 2010) and want to check for the data in each an every row. there are few columns and i want to check the string "OK" under "Status" column. if there is any "Not ok" found then need to prompt a message describing the details of whole row under.
View 4 RepliesMy application is like this : i have to search my data from database with some check box and text box when user select check box specific function go on and then when user enters some range of value in textbox then the result will shown in data grid view after that i can print it by selecting data
my vb.net code is as follow:
Imports System.Data
Imports System.Data.SqlClient
Public Class XtraForm1
[CODE]............
I m also pasting the demo picture.
I am trying to populate a dataset with data from a dynamic SQL dataset created by a code generator (PDSA). If I want the first row of data, or I use a specific "Where" clause to retrieve 1 row, I have no problem. But, when I loop through the dataset that has four entries, instead of getting the four entries, I get the first row 4 times.
Code Example:
Dim DS_C as New DS
Dim dr_A As DS_C.Tbl_ARow
Me.DS_C.Tbl_A.Clear()
[Code].....
I get:
System.InvalidCastException = {"Unable to cast object of type 'System.Data.DataRow' to type 'TblXLMajorPerilsRow'."}
I stucked by the xml problem, I want to read out the data and use the data to insert to database.
[Code]...
I use VB.NET 2010. So, I have to create a file, which has to follow a very old standard. I use a For Each / Next loop to get all my data. During this loop, I have to check the next entry before it is called. and if the next entry has some condition, it is not allowed to be called again....
Code Example:
For Each myData in Data
Dim nxt = Data.FindIndex(myData)
If Data(nxt+1).Depends = True Then
Data.RemoveAt(nxt+1)
End If
Next
I am trying to loop through the rows of my gridview and retrieve the data key value of each row and then execute some code to run sql queries. How can I get the data key value of each row in variable? right now I am receiving an error message saying:
value of type system.web.ui.webcontrols.datakey cannot be converted to integer.
Here is my code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
For Each row As GridViewRow In GridView1.Rows
Dim therowindex As Integer = row.RowIndex
[code]....
I'm stuck in converting the rate in the datalist. My page contain one dropdownlist(currency converter), one datalist - inside contain the price of bags in labels. Now I uses the dropdownlist.selectedIndexchange
Protected Sub ddl_rate_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddl_rate.SelectedIndexChanged
Dim lbl_rate As Label = roomList.Items.Item(0).FindControl("lbl_rate")
[Code]....
Currently, I am looking for a solution to makes my data loop at the code behind? It is actually an announcement list that query from database which contains the title and contents.
cmdDa = New SqlDataAdapter("SELECT * FROM announcement ORDER BY announcement_PostDT DESC", conn)
ds = New DataSet()
cmdDa.Fill(ds, "announcement")[code]....
Should I put it into a panel, list view or anything and loop it?
I'm switching over from PHP to vb.net. And some of the concepts are a bit different. Mainly I struggle with concepts and keywords, so it hard to look stuff up. Currently I'm creating a dashboard and needs to run a lot of different sql queries. But I see where I should be able to minimize my code. But things that I have tired don't work. Example below of two chunks of code that I should be able to put in some type of loop and increment a value for my sqlstring and textbox output.
[Code]...
I'm trying to just iterate through this xml and grab all of its data and add it to my collection(_personOC). Right now it's not working. How can I do this without having to specify the id? All I did was make a dataset with a person table and saved it as a xml.
Public Property personOC As ObservableCollection(Of Person)
Get
Return _personOC
[Code]....
How do I use for loop in vb.net something like
dim start as integer
Dim customers as New List(Of Customers)
Customers=dataAcess.GetCustomers()[code].....
I want to process some data for each 500 customers..
I found this snippet which loops the the old and new values, but I need to figure out the Parameter names that the values are associated with.
Sub DisplayValues(ByVal newValues As OrderedDictionary, ByVal oldValues As OrderedDictionary)
test.Text &= "<br/></br>"
' Iterate through the new and old values. Display the
[Code].....
I'm trying to add all of the totals within a list box, which would then be displayed in a label.[code]
View 3 RepliesI'm using Visual Studio 2008 and am creating a Visual Basic application. This is connnected to a SQL server database - standard settings.
I have created a nested loop and want to write the value of a variable into a record in the database table. Typically I have seen that textboxes, etc are connected to the database. How do I update the details for one record as part of the VB function?
Details are (excuse the pseudocode):
For loop (y axis)
For loop (x axis)
Within these storing values x,y,R,G,B,Y,U,V,mask as integer
[Code].....
I am writing code that pulls data from database tables and writes them to an XML file (to be picked up by another process). There are bout 60,000 records, and each record can have multiple entites, i.e. a member can have several contacts, each contact can have several phone numbers, etc. The entire process takes several hours, and I've narrowed down the slowness to the actual pull of the data (not writing the XML, or any data processing after it's pulled, etc.). I've tried the code two different ways, with similar results. First I leveraged LINQ queries and created all the elements in one statement:[code]That produced almost no change in amount of time the process took. I then tried stripping out all the elements and reduced the code down to just the database pulls, and it was similarly slow.Is there a faster/better way to pull all this normalized data from the database so I can get it to the XML file as quickly as possible?
View 3 RepliesI am making a webrequest to a web page, and need to collect some data which is arranged like:
<tr bgcolor="#ffffff" class="text" height=10>
<td>Name1</td>
<td>Age1</td>
[Code]...
I've been trying to get this method to run parallel so it can take full advantage of all processors, and it seems like the data is running over itself. I didn't originally write it, so I'm having a hard time figuring out where it's running over itself when it runs parallel. It gets good data when it runs in a regular For loop.
Parallel.For(1, endm, Sub(m)
'Debug.Print("Top of loop: " & Now)
For p = 1 To rowend
[code]....
which is better for retrieving data?a loop or an array,
View 2 Replieswhy I cannot populate the data grid with the results of my loop>
Public Class FormInput
'The disabled close button declarations;written by Achmad Zeanuri
Private Const MF_BYPOSITION = &H400
[Code].....
i want to delete existing data in datagridview using loop . i write code below:[code]but problem is that when data found and deleted row then orginal data index mismatch. and get error. how do make loop in up to down and delete row if match
View 4 RepliesI have a procedure that loops through the directories and subdirectories on a file server and sets the permissions. Procedure is called on a button click on a form.
I need to display on the form which directory is being processed. Similar to if we use the Debug.writeline which writes to the output in Visual Studio. I tried using a ListBox but it only displays the last one and only displays the last one once processing is done. I want to be able to display each directory name as it is being processed.[code]...
I have an Access database that has thousands of records. The fields in the database are EMPID, FIRST, LAST, JOBTYPE and PAGES. I would like to know how to loop through the database and for each individual EMPID to calculate the sum of the PAGES foreach JOBTYPE. There are four JOBTYPE's: "E", "K", "O" and "R".
Her is some code:
Dim
WebAllEmployeeQuery As
[code].....
Can I know which is better when retrieving data?
View 3 RepliesI cut my programming teeth on QBASIC so apologise if I'm a bit behind the times. I wrote a program in QB and I'm trying to convert it to VB.NET. One stumbling block I've hit is the DATA & READ facility, there does'nt appear to be an equivilant in VB. I want to read a list of data into an array using a FOR NEXT loop.
View 13 RepliesIn my winform application, I have 2 datatables, both contains 37000 rows. Table 1 has 171 columns and Table 2 has 4 columns. A While loop runs to update values in Table 1 from Table 2 for 4 columns. A For loop runs inside While twice to update values. It takes more than 5 min to do so. which i think should be a task of 5 seconds.
Columns being updated are:
Int64 - 1 Columns
String - 1 Columns
[Code]....