Click here to Skip to main content
15,888,816 members
Home / Discussions / C#
   

C#

 
AnswerRe: Coding in C# Pin
Simon_Whale3-Nov-14 5:12
Simon_Whale3-Nov-14 5:12 
GeneralRe: Coding in C# Pin
Member 111998293-Nov-14 5:22
Member 111998293-Nov-14 5:22 
GeneralRe: Coding in C# Pin
V.5-Nov-14 3:14
professionalV.5-Nov-14 3:14 
QuestionI need helping to program project by c# Pin
Member 111993481-Nov-14 21:37
Member 111993481-Nov-14 21:37 
AnswerRe: I need helping to program project by c# Pin
Richard MacCutchan1-Nov-14 22:05
mveRichard MacCutchan1-Nov-14 22:05 
AnswerRe: I need helping to program project by c# Pin
OriginalGriff1-Nov-14 23:48
mveOriginalGriff1-Nov-14 23:48 
SuggestionRe: I need helping to program project by c# Pin
Kornfeld Eliyahu Peter2-Nov-14 0:42
professionalKornfeld Eliyahu Peter2-Nov-14 0:42 
GeneralC# Pin
mahen287@gmail.com1-Nov-14 7:38
professionalmahen287@gmail.com1-Nov-14 7:38 
DEAR ALL,I NEED URGENT HELP IN THIS I HAVE A TEXT FILE HAVING STRUCTURE

DOJ DATE OF JOINING IN THE FORM YYYYDDMM

EMPCODE,DOJ
0000001,20140211
0000002,20140211
0000003,00000000
0000004,20140211
0000004,20141511


I WANT READ THIS FILE AND CHECK FOR DATE ERRORS WHICH ARE ENTERED WRONGLY.JUST LIKE LAST LINE.BUT IN THIS THIRD LINE IS CORRECT.SO I WANT TO INCLUDE IT IN DATATABLE.SO HOW TO WRITE THE CODE IN ASP.NET.I AM COPIYING MY CODE WHICH I USED TO READ THIS FILE.BUT I AM NOT GETTING THIRD LINE CORRECTED.TELL ME HOW TO MENTION THE CONDITION IN CODE SO THAT I CAN GET THIRD LINE IN MY DATATABLE(HAVING DATE "00000000") AND GET ERROR FOR ONLY LAST LINE.I HAVE WRITTEN A CODE LIKE THIS



using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
//using System;
using System.Collections.Generic;
using System.Linq;
using Microsoft.VisualBasic.FileIO;

public partial class DateCheck : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string path = Server.MapPath("~/empdetails.txt");
FetchData(path);
}
catch
{
lblError.Text = "File Is Having Error,Date is wrong,Check The File and Upload It Again";
}
}


protected void FetchData(string filepath)
{
DataTable dt = CreateTable();
bool IsFirstRowHeader = true;
string[] columnf = new string[] { "" };
using (TextFieldParser parser = new TextFieldParser(filepath))
{
parser.TrimWhiteSpace = true;
parser.TextFieldType = FieldType.Delimited;
parser.SetDelimiters(";");
if (IsFirstRowHeader)
{
columnf = parser.ReadFields();
foreach (string sds in columnf)
{
if (sds.ToString() == "DOJ")
{
dt.Columns.Add(sds.Trim().ToLower());
}

else
{
dt.Columns.Add(sds.Trim().ToLower());
}
}
}
while (true)
{
if (IsFirstRowHeader == false)
{
string[] parts = parser.ReadFields();
if (parts == null)
{
break;
}
DataRow rowset = dt.NewRow();
for (int i = 0; i < parts.Length; i++)
{
if (i == 2)
{
string str = parts[i].ToString().Substring(4, 2);
string date = parts[i].ToString().Substring(6, 2) + "/" + parts[i].ToString().Substring(4, 2) + "/" + parts[i].ToString().Substring(0, 4);
DateTime dd = DateTime.Parse(date);
rowset[i] = dd.ToShortDateString();
}
else
rowset[i] = parts[i].ToString();

}
dt.Rows.Add(rowset);
}
IsFirstRowHeader = false;
}
}
GridView1.DataSource = dt;
GridView1.DataBind();
}

static IEnumerable<string> ReadAsLines(string filename)
{
using (var reader = new StreamReader(filename))
while (!reader.EndOfStream)
yield return reader.ReadLine();
}

private DataTable CreateTable()
{
try
{

DataTable table = new DataTable();
DataColumn column;

column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "EMPCODE";
table.Columns.Add(column);

column = new DataColumn();
column.DataType = Type.GetType("System.DateTime");
column.ColumnName = "DOJ";
table.Columns.Add(column);



return table;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
SuggestionRe: C# Pin
Kornfeld Eliyahu Peter1-Nov-14 8:18
professionalKornfeld Eliyahu Peter1-Nov-14 8:18 
GeneralRe: C# Pin
Kornfeld Eliyahu Peter1-Nov-14 8:19
professionalKornfeld Eliyahu Peter1-Nov-14 8:19 
GeneralRe: C# Pin
PIEBALDconsult1-Nov-14 8:31
mvePIEBALDconsult1-Nov-14 8:31 
GeneralRe: C# Pin
OriginalGriff1-Nov-14 23:50
mveOriginalGriff1-Nov-14 23:50 
QuestionSSIS package Pin
Sachin Malviya31-Oct-14 5:20
Sachin Malviya31-Oct-14 5:20 
AnswerRe: SSIS package Pin
PIEBALDconsult31-Oct-14 5:41
mvePIEBALDconsult31-Oct-14 5:41 
Generalquestion in c# Pin
Member 1119617431-Oct-14 5:19
Member 1119617431-Oct-14 5:19 
Questionxml parser & indexing Pin
shima54131-Oct-14 3:57
shima54131-Oct-14 3:57 
AnswerRe: xml parser & indexing Pin
Eddy Vluggen31-Oct-14 9:31
professionalEddy Vluggen31-Oct-14 9:31 
QuestionContinuous Integration: CruiseControl vs Jenkins vs ??? Pin
Frygreen31-Oct-14 0:59
Frygreen31-Oct-14 0:59 
AnswerRe: Continuous Integration: CruiseControl vs Jenkins vs ??? Pin
Pete O'Hanlon31-Oct-14 3:28
mvePete O'Hanlon31-Oct-14 3:28 
GeneralRe: Continuous Integration: CruiseControl vs Jenkins vs ??? Pin
Frygreen31-Oct-14 9:21
Frygreen31-Oct-14 9:21 
AnswerRe: Continuous Integration: CruiseControl vs Jenkins vs ??? Pin
Dominic Burford2-Nov-14 23:59
professionalDominic Burford2-Nov-14 23:59 
QuestionHow to use 2 Replace Function at same time in c# win. form Pin
agent_kruger31-Oct-14 0:59
professionalagent_kruger31-Oct-14 0:59 
AnswerRe: How to use 2 Replace Function at same time in c# win. form Pin
Richard MacCutchan31-Oct-14 1:08
mveRichard MacCutchan31-Oct-14 1:08 
GeneralMessage Closed Pin
31-Oct-14 1:10
professionalagent_kruger31-Oct-14 1:10 
GeneralRe: How to use 2 Replace Function at same time in c# win. form Pin
Richard MacCutchan31-Oct-14 1:13
mveRichard MacCutchan31-Oct-14 1:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.