how to find the row position/index in a data table, using a value from another table. For example, I use the row position from Linkingtable1 to get my value for CustomerID, but i want to use the CustomerID to search the CustomerTable for its row position, in order to show the Customers Name in a text box, As currently when loading the textbox shows the customerID. I understand the code to get the names from the rows in the datatable, its just finding the row position of the customerID.
I am trying to find the position in a string of a perticular letter of the alphabet (Q), I have found a method to determine if the letter exsists in the string, but not it's position.
What would be the simplest way to find the n-th position of delimiter in a string.For example, say, I have a string variable called FullFilePath that contains the path of a file, like, C:SourceFiles<mthyr><subject><filename>.txt From this, I would like to extract out mthyr, subject, and filename, using the delimiter, "".
I was hoping string.IndexOf would let me find the n-th position of the delimiter "", in which case I can use the result to do a string.Substring. But it looks like IndexOf only finds the first occurence of a certain string, which means I would have to interate this somehow to look for the n-th occurence.
Or is there another method that will help me do this more efficiently.
I have a binary image (Black/White) that showing several white spots (3 to 4 spots). Is there any method to identify the position (coordinate) for every white spot.
Entered an 5 elements of an array so is has 4 index? I need to find the lowest and highest element of an array and their index position Example: I enter 1 2 3 4 5 The output should be like this The lowest is 1 and position of index is 0 The highest is 5 and position of index = 4
I have 1 access database with 3 tables How do I make the combobox get data from one table and input it to another table?ex.I have a table with all my Carriers and another table with jobs that are assigned to Carriers?
I've tried to use the DMAX Function in my VB windows application to find the highest value in a column in one of my tables, however it doesn't seem to work. After doing some research, I think that the function is only relevant to VBA, although I could be wrong.
'show me the maximum HCCID - DMAX 'Dim HCCNUM As Int32 'HCCNUM = DMAX("[HCCID]", "tblHCC")
How to find the maximum value in a column in one of the tables in my database?
I would like to be able to run a query that could tell me where a given table/query is used within all of my queries. I would like to do this with SQL but VBA is also fine.
How to find row position after table sort? Datagrid is binded to ds1.sometable. I have DataRow object or DataRowView from cm.Current and position before sort (cm.position or dg.CurrentRowIndex) but how to find where is its position to navigate DataGrid to select row after I re-sort datagrid?
I've looked throu all of the SendMessage(messages) but there does not seem to be anything like WM_GetPos.Now I can accomplish through AHK with ControlGetPos, but for the life of me I can not figure out what Win API function they are calling to accomplish this.We have an order entry system we use, that I am trying to automate the printing of our reports (we have 4 per order form) to save time
I am interested in the pros and cons of data tables and arrays in VB 2010. I programmed decades ago in FORTRAN and used arrays extensively.However, I frequently see data tables in code snippets and don't know when they should be used in lieu of an array.
I found a sample of how to display data from a table in to a datagrid using VB.
con.Open() Dim reader As SqlDataReader = _ cmd.ExecuteReader() DataGrid1.DataSource = (reader.GetSchemaTable()) reader.Close()
But this just displays the details of the table columns. For example row 1 has details about usrID, row 2 usrTel ect rather than the actual data of the table.
I Have a c++ program that is already completed but has no ineterface. So What I am trying to do is translate the c++ code over to Visual Basic, which is trickier than I thought. I need to browse for a text file, cross reference that with a csv file which will match IDs and replace in the text file, outputting to a textbox to save
i having a syntax error when im inserting data to two table.i check all the spelling and also i put [] in my reserved word.. by the way here's the code..[code]
Im trying to fumble my way through selecting data from a mysql table and populating it to a combo box. I feel Im almost there, could someone look over my code and see whats going wrong?
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged Dim con As New MySqlConnection
I've worked out how to display charts in VB 2010 Express, but now I'm needing the user to input data into a spreadsheet/table that will be used within the program. I know that table is no longer available and neither is the OWC11 set. Is my remaining option then to use DataGridView? I know it is SQL based and I don't have much experience there yet, but I didn't want to commit to it if there is another method that would work just as well. The values that are put in by the user does not need to be preserved.
I am using Datagridview to show some table data from database. It is working but its appearance is not what i am looking for.Is there a way to edit columns and rows manually ?This is a list of what i want to do :
1. First of all i want to change column captions. because they are like "Fld_name" etc.
2. There is a column that shows date. I want to write a code for it ( convert date type )
3. I want to add a button at the end of each row and write a code for it ( show detail about that record )
I need to get a list of distinct names inside the data table and the sum of values for each one. I know some basic stuff about linq, but i don't know how to put the distinct and the sums together.
I'm using the following code to import data from a text file into an existing Access table:
[Code]...
The first time i ran the code, it caused no error but no records where loaded into the table. The second time it causes the OleDbException "Table 'TEMP' already exists."explain me wath am i doing wrong? The text file is comma delimited and it has exactly the same number of columns of the TEMP table.
I created a winform that display an item master in a DataGridView, bound with a DataView. Let's just say it has columns/fieldsitem_id item_name item_description I wanted to make a single text box that will be searched in all fields. So if any field in a row contains searched item, it will be displayed. My current idea is to create a DataView with RowFilter contains all rows such
I defined a database using SQL Server 2008 R2 Express, and connected to it using Visual Basic 2010 Express. For some reason though, when I use the database in the program, it wants to start off using a negative primary key.Is there any way to make the primary key only a positive number?
The above line prints the data contents of the ROData array in position three. I would like to be able to assign a specific position accross the line to have the printer print the data at without left padding the array data.
I am trying to learn how I can enter data into a Microsoft Visual Basic 2010 TextBox on a form and when I Tab to the next TextBox, the data from the first TextBox is automatically appended to a Microsoft Access 2007 table. For this question, no other controls or objects are necessary.
I am having a little trouble with the folowing code. I made it so that it searches column "U" in the excel spreadsheet and for bcode that is input into a text box. The code runs perfectly the first time it runs but if i try to search a second time it gives me this error " Exception from HRESULT: 0x800A01A8"
Here is the
Dim Shape As String Dim bcode2 As String Dim Size As String
