Comments by acing wei (Top 110 by date)

sorry can i ask something ..
foreach (DataRow row in dt.Rows)
{
lstData.Add(new Tablelist() { FileName=csv, process = row["process"] + "", Event = row["Event"] + "", status = row["status"] + "" });

}
}
DataTable dtoutput = new DataTable();
var columnNames = lstData.Select(k => k.FileName).Distinct();
foreach (string columnName in columnNames)
dtoutput.Columns.Add(columnName, typeof(string));
DataRow newrowPassCount = dtoutput.NewRow();
foreach (string columnName in columnNames) {
int count = lstData.Where(k=> k.FileName == columnName).Count(k => k.status == "Pass");
newrowPassCount[columnName] = count;
}
dtoutput.Rows.Add(newrowPassCount);

this current code will give a new row with the newrowpasscount value inside.. in the second looping the new value will be overwrite that row... is there any idea i can create another row when looping second , third time ....keep creating row.. so far i did this
foreach (DataRow row in dtoutput.Rows)
{
dtoutput.Rows.Add(newrowPassCount);
}
but it doesnt work... can you guide me?

}

var columnNames = lstData.Select(k => k.FileName).Distinct();

foreach (string columnName in columnNames)

dtoutput.Columns.Add(columnName, typeof(string));

DataRow newrowPassCount = dtoutput.NewRow();
DataRow newrowReworkCount = dtoutput.NewRow();


int pprevcount = 0;
int rprevcount = 0;
foreach (string columnName in columnNames)
{

int pcount = lstData.Where(k => k.FileName == columnName).Count(k => k.status.Trim() == "PASS");
int rcount = lstData.Where(k => k.FileName == columnName).Count(k => k.status.Trim() == "REWORK");
newrowPassCount[columnName] = "Pass: " + (Convert.ToString(pcount - pprevcount));
newrowReworkCount[columnName] = "Rework: " + (Convert.ToString(rcount - rprevcount));
pprevcount = pcount;
rprevcount = rcount;

}



dtoutput.Rows.Add(newrowPassCount);
dtoutput.Rows.Add(newrowReworkCount);

column chart...I'm using csv with ,my code above
// Set chart data source
chart1.DataSource = dtoutput;

// Set series members names for the X and Y values
chart1.Series["Series 1"].XValueMember = "";
chart1.Series["Series 1"].YValueMembers = "";

// Data bind to the selected data source
chart1.DataBind();
I'm using something like this but can't work..

foreach (DataRow row in dt.Rows)
{
lstData.Add(new Tablelist() { FileName = csv.Replace(".csv", "").Replace(".CSV", ""), process = row["process"] + "", Event = row["Event"] + "", status = row["status"] + "" });

}
}



var columnNames = lstData.Select(k => k.FileName).Distinct();

foreach (string columnName in columnNames)

dtoutput.Columns.Add(columnName, typeof(string));
DataRow newrowPassCount = dtoutput.NewRow();

foreach (string columnName in columnNames)
{
int count = lstData.Where(k => k.FileName == columnName).Count(k => k.status == "PASS");
newrowPassCount[columnName] = "Pass: " + (Convert.ToString(count));
}


dtoutput.Rows.Add(newrowPassCount);

DataRow newrowReworkCount = dtoutput.NewRow();

foreach (string columnName in columnNames)
{

int count = lstData.Where(k => k.FileName == columnName).Count(k => k.status == "REWORK");
newrowReworkCount[columnName] = "Rework: " + (Convert.ToString(count));
}

dtoutput.Rows.Add(newrowReworkCount);

i got a lot of csv when reading first csv the pass & rework count is correct, the second , third and fourth csv the count value of pass and rework is wrong

mr karthik , why the value second time load different as first time when everytime i clicked...first count the value correct , second and third load the value will change..do i need to return something to the table..

foreach (string datestring in lstDateString)
{

string csv = datestring + ".csv";
con.ConnectionString = constr;

//create instance for command object
OleDbCommand cmd = new OleDbCommand();

cmd.Connection = con;
// set your file name in the below query

cmd.CommandText = "SELECT COUNT(Status) AS Total_Pass FROM " + csv +" WHERE Status='PASS' ";

//Open Oledb Connection to read CSV file
con.Open();

//Create one datatable to store data from CSV file
DataTable dt = new DataTable();

// Load Data into the datatable
dt.Load(cmd.ExecuteReader());

//Bind data in the Gridview
GridViewShow.DataSource = dt;
GridViewShow.DataBind();
con.Close();

}

i put my command in and it works perfectly..thank you so much ...but i got another question currently i count the pass and it only show me the 1030 result...how to actually show 4 tables of 0730,0830,0930 and 1030 pass result.