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

C++ ::  Columns And Rows In Text File

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

C Sharp :: How To Select Multiple Columns In A Grid View

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

C++ ::  how To Count Rows And Columns From File

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

C Sharp :: How To Update All Rows Using Text Box

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

C# :: Grabbing All Rows From MySQL Select Statement

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

C :: Creating Rows And Columns

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

C/C++ :: Columns And Rows For Loops?

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

C++ :: How To Get Sum Of Rows And Columns In 2 Dimensional Array

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

C/C++ :: Program To Sum Rows And Columns Of A Matrix?

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

C/C++ :: How To Sort A Table By Rows / Columns

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

C++ :: How To Modify A Program So That It Accepts Columns Instead Of Rows

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

C :: How To Select Words From A Text File

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

C++ :: Print Square Roots Of Numbers With Rows And Columns

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

C++ :: Filter Text Enclosed In Specific Tags From Text File?

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

C++ :: Program Inputs The Number Of Rows And Columns And Asks For The Entries

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

C/C++ :: Iterate 2D Matrix In Order To Exchange Columns And Rows Using Pointers

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

C++ :: Extracting Specific Lines Of Text From A Text File

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

C++ :: Reading Columns From A Text File?

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

C++ :: Reading Columns From Text File

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

Visual C++ :: Multidimensional Array Having 3 Rows And 8 Columns - Bubble And Selection Sort

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

C# :: Entity Framework - Select Specific Column In Tables

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

C/C++ :: Read All Song Titles From A Text File - Randomly Select And Output?

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

C/C++ :: How To Open Text File From A Specific Location

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

C/C++ :: Delete Specific Line In Text File Using Program?

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

Visual C++ :: Find Specific String Of Lines In A Text File

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







Copyrights 2005-15 www.BigResource.com, All rights reserved