i need the max ,min, avarage, for the 24 lines that lines counted from the line that contain the max date so i get the code for the max date for in the txt file this code used for both if txt file sorted by Ascending or by Descending
Imports System.Collections.Generic
Imports System.ComponentModel
Imports System.Data
Imports System.Drawing
[code]....
I have a Dataset with a Bunch of Columns used in a Report (DevExpress XtraReports) (DataSet being the DataSource). The Dataset has many columns, and i need to read a column (based on the row type), and decide which column value to read for the row, and apply formatting based on the row type.
[Code]...
Is there a suggested way to handle this in the Report or at DataSet Level (excepting the formatting part)?
i got two columns in mysql 2005 Grade and Remarks i need to do is.. when i input integers in grade column 1,1.25,1.50,1.75,2,2.25,2.50,2.75,3 then Remarks will show PASSED and when Grade is 4 up remarks will show FAILED(OPTIONAL)if Grade is null then Remarks will show UNKOWN this is my code but it doesnt works on sql computed column formula IIF(Grade >=4, 'Failed', IIF(Grade IN (1,1.25,1.50,1.75,2,2.25,2.50,2.75,3), 'PASSED','UNKNOWN'))
View 1 RepliesI'm have trouble summing a datagridview computed column. I can sum other columns in the DGV. Is it possible to sum a DGV computed column and have the result shown in a textbox elsewhere on the form? I have BindingSource with an End Date Column and a DaysLate computed by column. The calculation is in code and works fine. I now need a total days Late TextBox under the DGV days late column
View 2 RepliesI have two text files, the first text file has two columns separated by a space (" ") and the second text file only has one column.
The column 1 in text file 1 and text file 2 match albeit in different order, what I'm trying to achieve is for every field in column 1 text file 2 I want to search for column 1 in text file 1 and display the matching column 2 field in column 2 text file 2.
Dim*OpenTextFile*As*String*= IO.Path.Combine("C:Test1.txt")
Dim*OpenTextFile2*As*String*= IO.Path.Combine("C:Test2.txt")
Dim*SaveTextFile*As*String*= IO.Path.Combine("C:Test2.txt")
[code]....
I'm trying to add a computed column to a datatable that references another column in the datatable. Sometimes the computed column has a mathematical operation applied to it, but in this case I'm just referencing the original column. The code looks like the following:
ReportData.Columns.Add("1_1_US", _
GetType(Single), _
"1_1")
The code isn't actually hard coded as shown above - there are functions that return the values for the first and third parameters - but I checked those and they are returning the expected values and not generating any errors themselves.
The error is thrown when the .Add method is called, and the error states "Syntax error: Missing operand after '_1' operator." It seems to me that it doesn't like the column name, which I suppose I could change and just workaround it at the presentation level. Still, I'm curious. Is this a bug in the .net framework or something? It doesn't mind "1_1" as a column name in the datatable, so why is it having a problem with it in the expression statement?
I have 10 CheckBoxes which are created Dynamically at run time.Now i have to assign their Text is Column Values from DataBase.So, How can i get Column Values as a Text of CheckBoxes?Generally in VB we use Recordset ,by using Recordset we can put their Captions are like,, .Caption = rsDateDiff.Fields(0).Value & "-" & rsDateDiff.Fields(1).Value May i know in VB.NET??I am using Access DB.
View 8 Repliesam 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]...
I cannot update the column value on a *.csv file. Will someone help me out in this.My code snippet is as follows:
Dim str As String = ""
str = "update data.csv set code=code+'Test' where id='aafes'"
da1.UpdateCommand = Conn1.CreateCommand
da1.UpdateCommand.CommandText = str
[code]....
I want to replace the text in a string "Sin()" with the computed value for Math.Sin() where is...anything. My problem: The string can have more than one right parenthesis. Also, since it is performing mathematical operations, it would have to know how to do the innermost ones first.
[Code]...
reading a text file and then taking the values from the text file and inputting them in an Access database. I don't know how to do most of it, but I decided to start by reading the text file. However, whenever I click the button to read the file, I keep running into my catch error exception. Help!
Here is the Private Sub ImportButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ImportButton.Click
Dim CustomerStreamReader As StreamReader = New StreamReader(InputOpenFileDialog.FileName)
Dim vCustomerString As String
[Code]...
I have to save the text boxe values of a form to a text file almost like a data record. I will be saving an Employee First Name, Last Name, Dept Number, and Phone Number. This I know how to do using streamwriter.
next form which we have to use stream reader to load one record at a time. The form has a next button to load the next record. How do I seperate each record (I am sorry for calling it a record if this is inappropriate) when use streamreader and how do I load a record at a time.
I know how to open a file and use streamreader, I just don't know how to read one record at a time and move to the next one.
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].....
I have created a program that reads data from a text file. The file has four columns /fields separated by "," The first three columns are strings, the fouth column's value is an integer. I need to be able to sum the data that is in the fourth column. The file has 700 rows. I have tried using the split function to split the columns on each line. But am stuck as far as using array to compute the total of the fourth column.
View 3 RepliesI have a line of tetx. I must change the value of X an Y column according to the initial value which is input by user. I have a text box for user to enter row and column and also text box for the user to enter intial value of X and Y
It should work like that. If have 10 lines then user wil input row =2 and column=5. Row always will be 2. Initial value for X=100 Y=100
the first line should be 100 100 whic is initial value.
my output will be like this
X Y
100 100
102 100
104 100
[Code]....
I have a text box for user to enter row and column and also text box for the user to enter initial value of X and Y. It should work like that. If have 10 lines then user will input row =2 and column=5. Row always will be 2. Initial value for X=100 Y=100. The first line should be 100 100 which is initial value.
My output will be like this
X Y
100 100
102 100
104 100
106 100
108 100
100 102
102 100
104 100
106 100
108 100
The X value must plust with 2 until X=column meanwhile Y remain unchange . then at 6th column which is second row X=100 Y will be intial value of Y+2=102 the the same process will be repeat for second row.
This is my code so far
Dim lines1() As String = IO.File.ReadAllLines("C:\wirematchesout.txt")
Dim xValue As Decimal = Val(TextBox1.Text)
Dim yValue As Decimal = Val(TextBox2.Text)
Dim altValue As Decimal = 2
Dim lineTracker As Integer = 0
[Code] .....
Now I don't want to depend on the column value which is input by the user. I want to do automatically.Let say If my text file contain 131 lines. Since my row will be 2 which is fixed so it should take 66 lines as first row and 65 lines as second row and do the process that I explain above. If line is 132 then it will be 66 for first row and 66 for second row.
i have a text file which contains lines like this:
[1 07.15 44.4] 218611 54227 212454 38691
[1 07.43 45.8] 17111 51225 210454 36691
[1 07.58 45.8] 209611 1235 210454 35691
[1 07.50 46.4] 203611 51225 209454 36191
[1 07.51 59.1] 90111 238 190456 36138
The red colour column is X and green colour column is Y I wanted to replace Column X values with X1....Xn and Column Y values with Y1.
I have this code that searches for a set of numbers in my textfile. When it finds those numbers I want it to print what's on column 5 to 12 in the same line. Is this possible to do? I've been looking for an answer for ages now, and I can't seem to find anything.
View 4 RepliesI have lines like this
( Pin ) [ Probe ] Length = in.
| From | To | From | To
Length|Ga|Color |(b r c )|(b r c )| X Y | X Y
[code].....
how to sort .txt file by first column and the second column the first row is the header
<ticker>,<date>,<opening>,<high>,<low>,<close,<vol>
RIBL,20100329,30.1,30.3,30.1,30.2,205085
RIBL,20100330,30.3,30.5,30.3,30.5,405092
[code]....
Change value of column from text file line? I have lines like this[code]...
View 1 RepliesBackground: Users fill out a form that has 14 fields (radio buttons, checkboxes, textboxes, or listsboxes) in it. I have these fields populate into array list for each field. When the Write and Exit button are clicked the information in the arrary lists are combined and written to the text file that was appended when the form loaded.[code]...
View 7 RepliesI have a text file like this:
4.5 28 Red (T1 ) [1 12.86 53.8] 229111 -28275 198452 -1309 | 11.0 28 Red (2 13.10 04.0) [T1 ] 130611 2948 229111 28275
I want to chage the value in green colour and red colour column in each line. how can i point to that column?
I am new to the forum and would like some guidance on how I can achieve the following. I would like to read data from a text file after which I want to do a simple calculation that totals one of the columns.
I have already been able to read the text file into a text box but firstly I'm not quite sure if this method of using the text box is appropriate and secondly how do I sum a column of data?
how to read a text file that is column aligned. I understand how to read a delimited file (i.e.: comma, pipe, space, etc.) but the file I need to read is column aligned. [Code]
View 6 RepliesI have text file whic look like this[code]...
I want to swape the lines based on second and third column.. I must first swape based on second column in decending order wher the big number will come first. Like here the lines with number 30 will come first followed by 28 and so on. Then i must swape the colors. Like all the Black will come first follow by[code]...
I have lines like this
1.0 30 Blue (2 15.50 27.0) [2 15.48 24.1] 96111 19775 100493 19608
1.0 30 Blue (2 16.00 25.0) [2 15.26 23.7] 99111 23275 101123 18112
1.0 30 Blue (2 15.12 22.0) [2 14.97 17.9] 103611 17087 109706 16065
1.0 30 Blue (2 15.50 21.0) [2 15.15 21.4] 105111 19775 104509 17325
1.0 30 Blue (2 15.00 23.0) [2 15.23 17.9] 102111 16275 109706 17876
I want to sort the column that i higlighted in accending order.This is my code so far:
Dim FileContents() As String = IO.File.ReadAllLines(wirebot50)
For Y As Integer = 0 To FileContents.GetUpperBound(0)
If Not FileContents(Y).Trim = "" Then
[code]....
But this does not sorting anything. What is the wrong in the above code. And if i want to sort in decending order how to modify the code?
my text file will look like this
7.0 28 Black [2 11.94 37.7] (2 13.00 14.0) 115611 2275 79996 -5121
7.0 28 Black (2 13.00 50.0) (2 04.00 39.0) 78111 -60725 61611 2275
7.0 28 Black (2 11.00 18.0) (2 02.00 19.0) 108111 -74725 109611 -11725
[Code].....
my text file will look like this
7.0 28 Black [2 11.94 37.7] (2 13.00 14.0) 115611 2275 79996 -5121
7.0 28 Black (2 13.00 50.0) (2 04.00 39.0) 78111 -60725 61611 2275
7.0 28 Black (2 11.00 18.0) (2 02.00 19.0) 108111 -74725 109611 -11725
[code].....
I have two text files which contains are like this[code]..
When the original files find the same values in drill file than it must overwrite the original file the line from drill file. Let say original file contain T230 than it must serch for same value in drill file if it find than it must overwrite the original file line with drill file line. The content of drill file is not fix. It will allways be update according to need.
is that posible to connect two text file?