C Sharp :: How To Select Specific Rows And Columns From A Text File
May 29, 2014
I want to select three columns from my text file i.e. Empl No, Start Date and Created Date. After selecting this, I want to insert the data into a database.
I have attached a copy of the text file.
I have the following code so far:
if (File.Exists(filename))
{
string[] lines = File.ReadAllLines(filename);
for (int y = 0; y < lines.Length; y++) {
Console.WriteLine(lines[y].ToString());
}
How do i select specific details for each employee
View 1 Replies
ADVERTISEMENT
Dec 21, 2014
How i draw such a thing in .TXT file using file handling. This output must be in columns and rows and in well arranged form.
No. Name Roll No. Physic Math Compuer Science Islamiyat Pak Studies Average Grade
1 Student Name 12345 50 60 70 76 90 81 A
2 Student Name 12345 55 52 50 80 58 55 C
3 Student Name 12345 85 66 90 88 77 75 B
4 Student Name 12345 40 70 91 45 56 85 A
5 Student Name 12345 30 80 80 55 93 45 D
View 3 Replies
View Related
Nov 8, 2014
I am working on a windows application that is for make a time schedule for all staff. i am using two gridview one for all staff names from employee table , and second is for time schedule, time schedule DGV is like 6to7 , 7 to8...12to1,... 5to6 columns . when user will select like 7to8 , 8to9,9to10, columns with holding ctrl key , thn i have to assign some work beteen these time for 3 hours. So i have to get multiple columns from Gridview.
View 1 Replies
View Related
Sep 2, 2014
So I made a text file which goes like this
word word word word
word word word word word word word
word word word word word
word word word word
(word is actually word I just didnt type them)
Now i figured out how to get the rows to work
#include <iostream>
#include <fstream>
#include <istream>
#include <stdio.h>
int main()
{
FILE* fp;
int countLines = 1;
int i;
[Code]...
I cant figure out column to work... Is it the same method cause im getting confused a lot!
View 12 Replies
View Related
Sep 12, 2014
I retrieve all the row values from database into text box.But I could not Update it.It shows error message is : The variable name '@value' has already been declared. Variable names must be unique within a query batch or stored procedure. Must declare the scalar variable "@keyValue".
my code is here:
public partial class ECB_ECBConfiguration : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
DataTable dt = ECBDal.GetECBConfiguration();
foreach(DataColumn col in dt.Columns)
[Code] ....
View 1 Replies
View Related
Feb 5, 2015
I don't understand when I'm only requesting a specific column on a unique row in MySQL that I'm being returned with data from all columns of that row.
My Select Statement - "select article from post where idpost=" + strIDpost + ";"
I should get:
|--- article -----|
"some article text"
Instead I get:
|-idpost-|-title-|---- article------|
1 title some article text
If I run the command directly to the database I get the results I'm looking for, but somehow while running the application, the program is managing to pull the entire row.
I'm using C# on a webform in Visual Studio '13. Here's my Code:
public static string GetConnectionString() {
string connStr = String.Format("server={0};user id={1}; password={2};" +
"database=dbname; pooling=false", "servername",
"dbUserID", "dbPassword");
[Code] .....
View 7 Replies
View Related
Mar 6, 2015
how to make the it all work later...but in the mean time how can i get this to display this? Note it has to be made using as a console program. The "Description" and "Cost/ib" collums will be referenced through use of a header file. all else is done by user input and calculations.
View 2 Replies
View Related
Feb 26, 2015
I'm having trouble trying to get my loop program to display multiples of 4 in rows and columns. My objective is to print multiples of 4 that are less than 100 in a 4 by 4 format.
So far when I write the code I get 4 8 12 16 20 .... 96 all on the same line.
This is what I expect the code to look like if done correctly.
4 8 12 16
20 24 28 32
36 40 44 48
52 56 60 64
68 72 76 80
84 88 92 96
This is code that I have so far.
#include <iostream>
using namespace std;
int main(){
[Code]....
View 4 Replies
View Related
Aug 2, 2014
Here's my code for adding the rows and columns. My problem is that my program displays an incorrect output.
main() {
int a[20][20],r,c,y,x,sum=0,rn,cn,cs=0,rs=0;
cout<<"Enter number of columns : ";
cin>>cn;
[Code] .....
This should be the output
Enter number of columns: 4
Enter number of rows: 3
Enter twelve numbers: 9 2 3 4 2 3 1 2 5 6 7 8
The numbers are:
9234
2312
5678
Sum of number 1 column is: 16
Sum of number 2 column is: 11
Sum of number 3 column is: 11
Sum of number 4 column is: 14
Sum of number 1 row is: 18
Sum of number 2 row is: 8
Sum of number 3 row is: 26
View 6 Replies
View Related
Apr 23, 2014
Im using apmatrix and im inputting values into a 4 by 4 matrix and im getting all these errors that have nothing to do with my cpp file so im guessing its apmatrixies fault. Also I put in the cpp and header file of both apmatrix and apvector into my project folder. Heres my code:
// Libraries
#include "apmatrix.h"
#include <iostream>
//cout, standard output
// <<, stream insertion operator
[code]....
My errors are:
error C1189: #error : The C++ Standard Library forbids macroizing keywords. Enable warning C4005 to find the forbidden macro.c:program filesmicrosoft visual studio 11.0vcincludexkeycheck.h2421TheMatrix
4IntelliSense: identifier "EMIT" is undefinedc:Program FilesMicrosoft Visual Studio 11.0VCincludeyvals.h4911TheMatrix
and a bunch are repeated
View 1 Replies
View Related
Oct 5, 2014
I am trying to sort a Report Table by which the user can enter any column or row number and output the results. And also sort by names as well. And from my code
#include "stdafx.h"
#include<iostream>
#include <string>
#include<iomanip>
using namespace std;
#include <stdlib.h> /* srand, rand */
#include <time.h> /* time */
[Code] .....
I know I need to start somewhere with a void function and put in a selection sort.
View 1 Replies
View Related
Feb 4, 2015
I have a N queens (actually 8 queens to be specific) program that accepts the numbers in order by row. I need to get it so it accepts the numbers in order by column. At first glance I thought it was just one space different, but it turned out not to be and how to get the one space difference in there. My current code (which I'm aware isn't doing the column accepting right) is:
Code:
#include <iostream>
using namespace std;
int main() {
int board[8];
cout << "Enter the columns containing queens, in order by column: ";
for(int i = 0; i < 8; ++i) {
cin >> board[i];
[Code]...
What the output should be:
Code:
Enter the rows containing queens, in order by column:
7
6
5
3
4
2
1
0
.......Q
......Q.
.....Q..
...Q....
....Q...
..Q.....
.Q......
Q.......
What it is:
Code:
Enter the columns containing queens, in order by column:
7
6
5
3
4
2
1
0
........Q
.......Q.
......Q..
....Q....
.....Q...
...Q.....
..Q......
.Q.......
View 5 Replies
View Related
Oct 1, 2013
I've a text file with 9 words and each word is written in a line. for exemple this is the list :
APPLE
ORANGE
MOON
CAR
CANDY
...
END
I'm gonna choose the fourth line and select the word that is in this line and work on. I tried lot of way but no result.
View 7 Replies
View Related
Mar 12, 2013
this is what i have so far
#include <iostream>
#include <cmath>
using namespace std;
int main () {
int v;
[Code] ....
im trying to get the program to print this as an example if the user enters 5 (the rounding of the decimal is optional).
1 1.41 1.73 2 2.24
1 1.41 1.73 2
1 1.41 1.73
1 1.41
1
why its not reading my for loop for rows its only doing columns ...
View 4 Replies
View Related
Aug 30, 2013
I have a huge text file in following format:
{Bunch of text
.
.
}
[Code].....
I want to extract Text1, Text2, Text3, Text4,..., Text600 in the output file. How can i achieve this?
/* BTW, I am not getting my homework done here. I am an ex-programmer, who has now moved to marketing for some time now, and today, I encountered this problem, which I believe can be solved easily through programming. */
View 3 Replies
View Related
Feb 7, 2015
I am writing a program that deals with 2d arrays. The program inputs the number of rows and columns and asks for the entries. When the program run and compiles it works perfectly until it outputs then it gives me a warning.
Here is my code:
#include <iostream>
#include <cstdlib>
using namespace std;
int main()
{
int row1=0,col1=0,i,j;
//int a[row1][col1];
int** a= new int*[row1];
[Code]...
I am learning how to do this before I can move on so it can read a text file of numbers.
Also I am having problems with ////delete [] a[];///// I took it out because it made my code compile and run but when I add it in, it gives me an error:
matrixtesting.cpp|56|error: expected primary-expression before ']' token|
I know this expression is suppose to deallocate the array.
View 7 Replies
View Related
Jan 19, 2014
I am trying to iterate a matrix in order to exchange rows and columns element by element. Although the function that exchanges the rows has come out well, i don't seem to figure out how to do the same on columns.The columns switch for a matrix like
1 2 3
1 2 3
1 2 3
if i try to switch column 3 and 2,is:
1 3 2
1 3 2
1 2 3
Here are both of the functions:
void interchange_rows(int *p,int n,int r1,int r2){
int temp;
for(int i=0;i<n;i++){
temp=*(p+r1*n+i);
*(p+r1*n+i)=*(p+r2*n+i);
*(p+r2*n+i)=temp;
[Code] ......
View 1 Replies
View Related
Aug 2, 2014
I have a text file called (Test.txt) with the following text:
This is line one
This is line two
This is line three
How do I go about writing a program that will print a line of text (e.g. "This in line two" on the console screen?
All I can seem to do is display the entire text file.
View 6 Replies
View Related
Oct 19, 2013
How can I read just the first column of this from a text file?
ORG 100
LOAD X
ADD Y
STORE Z
HALT
X, DEC 49
Y, DEC -80
Z, HEX 0000
I have
while (! sourceCode.eof() )
{
getline(sourceCode,symbolValue,'
');
sourceCode >> symbolValue >> codeWord >> value;
symbolTable << symbolValue << endl;
}
View 9 Replies
View Related
Oct 19, 2013
How can I read just the first column of this from a text file?
ORG 100
LOAD X
ADD Y
STORE Z
HALT
X, DEC 49
Y, DEC -80
Z, HEX 0000
I have
while (! sourceCode.eof() ) {
getline(sourceCode,symbolValue,'
');
sourceCode >> symbolValue >> codeWord >> value;
symbolTable << symbolValue << endl;
}
View 2 Replies
View Related
Feb 19, 2014
You will write a program that uses a multidimensional array having 3 rows and 8 columns and sorts each of the rows using both a bubble sort and a selection sort.
You must declare the array inside of main. You will have a for loop containing the calls to bubbleSort and selectionSort. You need to pass into function bubbleSort and selectionSort the following: 1) each column of the multidimensional array, 2) the size of the column, and 3) a particular row number of the multidimensional array to be used for printing out the "pass" shown on the following pages.
I keep getting an error that the identifier for bubbleSort and selectionSort is not found. (Error C3861)
Also, I feel like I'm missing something in int main() to get it to sort properly.
Code:
# include <iostream>
using namespace std;
int main() {
const int SIZE1 = 3;
const int SIZE2 = 8;
int arr [SIZE1][SIZE2] = { { 105, 102, 107, 103, 106, 100, 104, 101 },
[Code] ....
View 1 Replies
View Related
Apr 28, 2015
I need to show in a comboBox thats shows infor from Entity framework but i need to select a specific colum in the tables..
All in C# visual studio xaml form
So I created a var but i get and output: name of programe.NLHEntities
using (var context = new NLHEntities()) {
var blog = context.EtagesChambres
.Where(b => b.TypeChanbre == "Prive")
.FirstOrDefault();
textBox2Type.Text = Convert.ToString(blog);// i put a text box to see what the output would be..
}
View 14 Replies
View Related
Apr 19, 2015
So far I have managed to sort songs by their string length in main. The void function is there because i learned how to create it, but it's not being used because I dont know how to use it.
Expanding on main, how would I go about selecting a random song from the array?
#include <fstream>
#include <iomanip>
#include <iostream>
#include <string>
using namespace std;
struct Song {
string song;
[code]....
View 2 Replies
View Related
Feb 2, 2014
I'm having trouble opening a file from a specific location.
#include "maidcafe.h"
....
char directory[80] = {"C:UsersPublicDocumentsAnime NotesTransaction"};
char code[20];
printf("Enter file name");
gets(code);
strcat(directory,code);
system("start "" %s",directory);
i thought this would work, but it didn't xD. I got an error
View 3 Replies
View Related
Feb 6, 2014
Some codes to delete a text in a specific line in a text file.
Example:
This is line 1
This is line 2
this is line 3
Removing line 2,
This is line 1
This is line 3
//////////////////
View 2 Replies
View Related
Oct 15, 2013
I am trying to print a specific line from a textfile
e.g
I have a text file called info.txt and inside it contains the id,item name, price, quantity
Code:
1,shirt,100,10
2,pants,50,9
3,pen,20,8
I know how to find a specific word at the line in the file but how do I find and print out the specific line e.g(print out just the entire contents of line 2)?
Code:
string temDescription;
ofstream fout;
int curLine = 0;
[Code].....
View 1 Replies
View Related
