Get Values From A Column And Put Them In Another Part Of Program?
Nov 15, 2009
I am working on a program where the user inputs values, then the program calculates those values and outputs the sum. When the user hits the button exit then those values entered by the user are saved. When the user starts the program again, the values are still there. I wrote the code and everything works fine. I am saving those values in notepad... and the program grabs the input in notepad and outputs those values to the program. But here comes the problem:
Lets say the user wants the information in a certain column to be added to another column somewhere in the program. Is that possible ? And if it is can it be done when I am saving those values in notepad ?
View 1 Replies
ADVERTISEMENT
Jun 3, 2011
am trying to calculate the values in rows in column 6 based on values of column 5. Bellow is the the code I am using I get a run time error about the string not formatted properly
[Code]...
View 1 Replies
Jun 22, 2010
I was wondering can you get a program made w/ vb to click on a certain part of the screen outside of the program? and also, can you copy information from outside the program in another window and store it in the program as a variable.
View 1 Replies
Jan 4, 2011
i have retrived this datatable from datasource and i want to add a more colum 'category'basedon the each value of each Role, like if role column has the value '90 daya client' then in the same row it should have a value 'DC' in the category column.n make a temporatry dt1 table but to add related values.
S.No First Name Last Name Role Date
1 Us er1Name User1Name 90 Day Client 11/01/2011
2 User1NameAtt1 User1NameAtt1 90 Day Client 11/01/2011
[code].....
View 1 Replies
May 28, 2010
I want to add all the values of a certain column. I already get the value of an exact cell value but when i add the loop code for it to continue,it doesn't performs well.
[code...]
I,m using vb6 po with datagrid component.
View 1 Replies
Feb 16, 2011
ok so i have done some searching and i can't seem to find any topics on this subject maybe im not searching for the right topic but here is my problem maybe someone could give me some advise: im writing a program that has a "main" .exe on any system. it will run and do what i am asking it to so far but my problem is i need it to generate a copy of only a portion of itself it has to generate a form and a login form to export in any specified location for transfer and travel and make it "run-able" without the main being present
[Code]...
View 1 Replies
Jun 10, 2011
Im trying to make a fast food program on which the user will input the amount that he has, then he will click on what he wants, by using check boxes. There are 7 different check boxes with 7 different amounts of money. I got an idea on what to do (they will check on what they want and the program will add up the total and there is only one of each item), but im confused on how to put the amount on where the check boxes (in the program area and not the text area) and add them together. After that all I need to do is add everything up, with sales tax, and tell the user if he has enough money or not. But what im confused on is how do I get the check boxes to a amount of money and add them up (all the ones hes checked) I just dont know how to code this part of the program, once I get one done all I have to do is the same for each one, and everything showed be easy after that. But how do I put an amount on a check box and add them all up?
View 5 Replies
Apr 5, 2009
Have a program that collects response data as part of a psychology experiment and i want the output text files to show up on the users desktop so that they can find them easily and e-mail them to me. I'm using Parallels on my Mac to run windows XP and found the files in a desktop folder but they were not on the desktop. Am I coding this right?
HTML
My.Computer.FileSystem.CreateDirectory("C:Desktop" & Participant)
FileOpen(2, "C:Desktop" & Participant & "IRAP output.txt", OpenMode.Append)
[code].....
View 7 Replies
Feb 22, 2011
im making an application in vb.net (duh!) anyway i have created and coded the whole project and it performs exactly as i want it to (i dont need code help). my problem lies with the fact that my project is 2-3 parts
1.a setup form that gathers inital data about the enviroment stores this data encrypted in a config file. after inital setup this form is not displayed again. but needs to be run on both computers
2. the second form is the real application form im in the process of turning this part in to a background service anyway this form is the one that establishes the connection between two nodes it works correctly
3. the config files
anyway here is my problem i want to make this application distributional with just one file the (.exe) and have this .exe make everything else happen. it runs the setup form and creates the first config file which it does then it needs to produce a copy of just the second form and the config file to transfer to workstation #2 that will run independtly without the whole application which i cant make happen then it needs to turn both workstations application on by only starting one on either computer and invoke the other computer to start its corrosponding app also no idea how to make this happen any ideas or suggestions as to where to look to try to find my answers.im thinking i might need to make two seperate applications (a setup app, and the running app) and include them both in a project and use the setup.exe to to package them together this is a little side project that im making for my self to use to make programming a little easier so i plan on giving it out to some fellow students to test and tell me what they think so im not really worried about ease of use or complicated procedures yet but if it turns out to work and actually be of use to anyone else i would be willing to rewrite it to distribute to the masses but for now i just want it to work for me.
View 4 Replies
Mar 13, 2010
I am using a Webbrowser in my program.
In the page source of a certain URL is the following: <input type="text" name="email" maxlength="50" value="email@email.com">
I'm trying to get the value part from the source and have it printed out to a TextBox on my program. I'm not sure how to do this but I tried. I made a new HtmlElement called email. Then I did email = WebBrowser1.Document.All.Item("email") However, when I try to add it to my textbox it doesn't work.
View 9 Replies
Dec 1, 2011
I have the following worksheet:
Quote:
SEP138 F-001-13, 8kV
SEP138 F-003-13, 8kV
SEP138 F-004-13, 8kV
[code]....
I wonder if anyone knows a macro developed in Visual Basic to separate the first part "F-001" to a different column
example:
Column A = F001
Column B = Sep138-13, 8kV
The spreadsheet is quite wide, going up to about F-220 I could only get to it:
StringElement Function (str As String, chr As String, ind As Integer)
As Variant Dim arr_str
arr_str = Split (str, chr)
StringElement arr_str = (ind - 1)
end Function
is very simple, just separates into single column and not the entire worksheet?
View 4 Replies
Nov 30, 2011
I have a datagridview, I am importing csv into it, I want to add a new column "Test Column" and populate that column with row numbers [code]...
View 3 Replies
Jun 10, 2011
I am able to connect to my MySql Database.How can I list all of the values from a column.I would like to list all of my "Username" column's value.[CODE]....
What is the sql query for it? So far I only know SELECT and INSERT. And then listing all of the values to the Items in my ComboBox.
View 1 Replies
Oct 5, 2011
I have a table called Table1 which already has a few other columns and 4 rows. I want to add three new columns to it. When the columns are added I want all the cells in the column to equal the variable I supply in the Add method. When I add the column named "BatchID" it works beautifully, but when I add "UserID" it gives an error "Cannot find column [iqz9]". Why? This is how Table1 should look like:
[code]...
View 1 Replies
Jun 2, 2011
i want to dynamically add the values in the column of a datagridview the row of which is also being created dynamically...
Form1.TextBox10.Text = total
con.Open()
cmd = New SqlClient.SqlCommand("select product,Quantity,MRP,Sale_Rate,Disc_Amt,Amt from sale_table ", con)
[Code].....
View 7 Replies
Mar 17, 2010
I have a database and a dataset as the image shows in the link, how would i add the values of the colums "amount1" and "amount2" for every row and entry as the user make entries to be automatically displayed in the "total" column. Meaning that every time values are entered in those amount columns, they will be added and the total displayed in the "Total" column.
[URL]
View 17 Replies
Aug 10, 2010
I have a GridView and by RowDataBound event I change the values of my last column. I want my last column to have as values the sum of each row.
Below is my code
If e.Row.RowType = DataControlRowType.DataRow Then
'total of row
Dim i As Integer
Dim total As Integer = 0
Dim dt As DataTable
[Code]....
View 4 Replies
Jul 30, 2009
I have a databound DataGridView and use a button to control updates.
The problem is that if a db Column does not allow a null value an error is thrown ("Column <ID> does not allow null values") and then the datagridview automatically removes the row. This error is raised as soon as the user leaves the cell and before the update command is issued.
View 3 Replies
Sep 9, 2009
tell me how I count the number of times a specifc value appears in a column within a DataGridView?
View 2 Replies
Aug 9, 2010
I am trying to get distinct values in column 2 of a DGV using the following LINQ query:
Dim AllocatedRoomTypes = From r In Me.AllocatedDGV.Columns.Cast(Of DataGridViewCell)() Select r.ColumnIndex = 2 Distinct
but I get the following error:
Unable to cast object of type 'System.Windows.Forms.DataGridViewTextBoxColumn' to type 'System.Windows.Forms.DataGridViewCell'
I understand that the problems lies with the Cast, but I do not know how to correct it.
What I am trying to acheive is this:
Value is Column 2 of DGV
Double
Double
Single
Twin
[Code]....
View 6 Replies
Jan 25, 2009
I have a db with Column name Break. I have attached to my datagrid view and all that works and shows up correctly. However Im needing to put this code in a timer to get all the times in the Break Column but I need to get it from each and every row. For example:
Break
6:00am
7:00am
6:30am
I need it to look through each row and get that value. Ive tried various things, but Im not on my normal computer so I cant post my code.
View 3 Replies
Aug 13, 2009
I have a a few checkboxes that I want to be checked based on a value of columns in a table.So I have a table that has a date column and I run a search based on a particular date. Then I want to be able to go through the rest of the columns based on the selected date. But I need to be able to check individual values. Not sure if this is making sense. It is for a checklist. I want to click on a date, and it will auto populate checkboxes based on what was pulled from the db.
View 9 Replies
Jan 16, 2010
I need to strip out part of a datafield namely Column name "City" the data provider adds an abbreviation to the end of the City name Example: Houston[HST] I need /want to strip out the [HST]been trying to modify my statement with no luckI am using Jet 4.o and database is a .txt or .csv file
OleDb.OleDbCommand("Select *, (([AddressDisplay])&',' &([City])&',' &([State])&',' &([ZipCode])) AS Address, IIf(IsNull([BathsQuarter]),0,[BathsQuarter]*.25)+ IIF(IsNull([Bathshalf]),0,[Bathshalf]*.5)+ IIf(IsNull([Bathsthreequarter]),0,[Bathsthreequarter]*.75)+ IIf(IsNull([BathsFull]),[BathsTotal],[BathsFull]) AS BATH From " & Me.OpenFileDialog1.SafeFileName & " Where ListStatus <> 'Closed Sale'", con)
View 13 Replies
Sep 8, 2010
I need to find rows in resultsets that have every column without null.these resultsets got variable number of columns.currently, the only way that I can think of is creating a view on each resultset and filter this way:
select field1, field2, field3, field4, ...
from "huge query"
where field1 is not null and
field2 is not null and
[code]....
and then in a storeproc/function or .net code(c# / vb.net) loop through all rows / columns and flag or remove every row that got any null?
View 3 Replies
Jan 20, 2012
I want to loop through a databale and change the values of a specific column in that datatable.eg: the database returns Request_ID, Desc, Date and Status_Ind. The Status_Ind column contains integer values. I dont want to show the integer values to the user. I want to convert that to a string value based on the integer values returned in that columns.
View 2 Replies
Oct 12, 2011
ei guys how to compute values in a datagrid column.. we have just tried some codes but it appers false anyway.. just need it badly.. i just have 30 min. :CCC
View 5 Replies
Mar 15, 2012
i have a datagridview on my form with customers info which is linked to my database. i want to execute a line of code based on the information in one of the columns in the datagridview??? for example i have a datetime column which stores dates(and maybe time) i want to use an if statement(or any code) to compare the date the customer entered. if its today then my code will execute!!
View 4 Replies
Nov 11, 2010
Dim cmd As New SqlCommand(SQLSTR, conn)
reader = cmd.ExecuteReader()
Dim myDataTable As New DataTable
[code]....
i hve the follwoing code by which i bind the data to the grid the grid has 4 columns PRODUCTNAME, QTY,RATE, AMOUNT the user shld be able to edit the data in the column qty for as many rows it has but i m not able to edit this column how do i edit the values in the cells of column(1) ie qty?
View 1 Replies
Jan 17, 2010
I have a datagridview with 2 columns.What i want is to enter numeric values into 2-nd column and to have the sum of this value in the last row (no matter how many values aka rows i will have). And also how can i have the last row fixed considering further actions.
View 10 Replies
Jul 9, 2009
I have a datagridview with 2 columns.What i want is to enter numeric values into 2-nd column and to have the sum of this value in the last row (no matter how many values aka rows i will have). And also how can i have the last row fixed considering further actions.
View 3 Replies