Sirdots
asked on
Creating a flat file from a datatable using c#
I am working on creating a flat file from a datatable. I have not been able to get this to work. Attached is my specification and dotnet code. Also could you take a look at my sql and see what am doing wrong. The text file is generated but the columns are not in the right position.
Here is the sql
select
substring(Year, 1,4) as "AWARD-YEAR",
substring(Social_Security_ Number,1,9 )as SSNO ,
substring("Alternate ID",1, 10)as "id-alt",
substring(Last_Name_Applic ant,1,16)a s "NAME-L",
substring(First_Name_Appli cant,1,11) as "NAME-F",
substring(Middle_Initial_A pplicant,1 , 1)as "NAME-M",
substring("Fund External Name", 1,35)as "fund_external_name",
substring("Award Amount",1,5)as AWARDAMT
from studentinfo
code.txt
Specification.JPG
Here is the sql
select
substring(Year, 1,4) as "AWARD-YEAR",
substring(Social_Security_
substring("Alternate ID",1, 10)as "id-alt",
substring(Last_Name_Applic
substring(First_Name_Appli
substring(Middle_Initial_A
substring("Fund External Name", 1,35)as "fund_external_name",
substring("Award Amount",1,5)as AWARDAMT
from studentinfo
code.txt
Specification.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It looks like all the columns are character data so it should return the right value. As to the column headers, I don't do C#, but I suspect this is your culprit:
for (i = 0; i < dt.Columns.Count - 1; i++)
{ sw.Write(dt.Columns[i].ColumnName + " \t ");
}
sw.Write(dt.Columns[i].ColumnName);
sw.WriteLine();
ASKER
I think I got it to work now. I will test now.
ASKER
I will close this now. Thanks.
ASKER
I also dont want the field names to show if the flat file is generated. The field names appear on the first line.
tablestructure.JPG