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
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
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.
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)
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:
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.
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.
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
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:
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
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.
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:
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. */
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.
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
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 },
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.. }
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;
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;