Lowyat.NET: Latest topics by Shane711

Compare datagrid cell previous value with c#

Shane711 — Wed, 04 Aug 2010 09:02:24 +0800

Dear all, let me explain how my datagrid work. The datagrid have 10 columns and 21 rows. The datagrid value will be updated every 5 minutes. Actually what I want is to compare the value before 10minutes with the current value which show in the datagrid. The value that I would like to compare is "e.Item.Cells[6]" which name Final_qty. Because of the datagrid is updated every 5 minutes. It is difficult to me to store the value before 10 minutes. So I try the way to only compare the Final_Qty value 5 minutes before and current value. If the value that I compare is the equal. Then {e.Item.Cells[6].BackColor=Color.Blue;}. The problem is, what is the (if statement) should I write? I do not know how to write the comparison between previous value and current value. Please give me a hand if u know. Thanks.

\\This is the coding that insert into the datagrid.
private void dGridBind()
{
string lines= System.Configuration.ConfigurationSettings.AppSettings["Lines"];

if (lines!=null)
{
lines="top " +lines;
}
else
{
lines="top 100";
}

string strSQL="SELECT "+lines+ " * From PICS_R where 1=1";
strSQL+=" and Line_ID like 'V%'";
strSQL+="order by Date_Time desc, Line_ID";

SqlDataAdapter sqlAdpt=new SqlDataAdapter(strSQL,sqlConn);
DataSet ds=new DataSet();
sqlAdpt.Fill(ds);
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
}

\\Here is the way to compare
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
float qc1Target=
float.Parse(System.Configuration.ConfigurationSettings.AppSettings["QC1Target"]);
float qc2Target=
float.Parse(System.Configuration.ConfigurationSettings.AppSettings["QC2Target"]);

lblTarget.Text="QC1 Target: "+qc1Target.ToString("0.00%");
lblTarget.Text+=", QC2 Target: "+qc2Target.ToString("0.00%");

if (e.Item.ItemType==ListItemType.Item || e.Item.ItemType==ListItemType.AlternatingItem)
{
e.Item.Cells[1].Text=e.Item.Cells[1].Text.Substring(5,2)+e.Item.Cells[1].Text.Substring(8,2);
e.Item.Cells[2].Text=e.Item.Cells[2].Text.Substring(e.Item.Cells[2].Text.Length-4,4);

if (float.Parse(e.Item.Cells[4].Text)<qc1Target)
{
e.Item.Cells[4].ForeColor=Color.Red;
}

e.Item.Attributes.Add("onmouseover","javascript:this.style.cursor='hand';oldColor=this.style.backgroundColor;this.style.backgroundColor=newColor;");
e.Item.Attributes.Add("onmouseout","javascript:this.style.cursor='hand';this.style.backgroundColor=oldColor;");
}

O/D off flashes

Shane711 — Thu, 29 Oct 2009 09:58:48 +0800

Hi,every sifu here...
Can I knw what is O/D off?? It is flashes automatic while I am driving this morning...
I dono what is happening and what cause it flashes...
What should I do for now?? Izit got problem to my car??
could any sifu here can help me??
thx!!

Nissan sentra vs toyota vios

Shane711 — Fri, 25 Sep 2009 22:18:42 +0800

I am planning to get a second hand car currently...
I am interested in two car by now... One is toyota vios and another one is nissan sentra...
Many of my fren suggest me to own vios... But the sit behind the vios a bit small if compare to sentra...
I like sentra one style... Very cool if own it and drive it...
But jz scare nissan sentra a lot of problem after I buy second hand one...
And I heard than sentra 1.6 are quite high fuel... Anyone own nissan sentra can let me know bout this?? thx!!

The price between this two car are almost same...I have budget around 50K...
can own 2004/5 one Vios or Sentra... Jz wondering which I wan to buy...
Wil Nissan Sentra lot prob if second hand?? Wil Nissan Sentra high fuel???
Izit worth to buy Vios?? Low fuel if drive Vios??
Can anybody choose for me?? Or giv me the good point to choose better car... Thanks lot!!!

Seagate Crystal Report

Shane711 — Thu, 24 Sep 2009 17:12:17 +0800

Hi all,

I am facing some problem when I want to print out the photo through crystal report. When I click 'Print' button, this error message will appear - " Some links could not be updated because their sources are presently unavailable. " I have try reinstall my crsytal report and update d... But the problem occurs oso... When the error message appears, it just give me to either to choose 'OK' or 'Links'... But both of this button cant solve my problem too... The photo cant show out in the crystal report... Can anyone help me... urgent... thx a lot!!!

Second hand vios or jazz?

Shane711 — Fri, 18 Sep 2009 23:47:21 +0800

I wish to get a second hand car currently... Vios and Jazz is my lovely car...
But dono my budget is enuf to own either this two car or not lo...
My budget is bout 50K... hope to own above 04 one jazz...cos jazz is my 1st choice...
But dono worth or not lo... Scare regret choose honda n not toyota lo...
any opinion and comment?? thx!!

PC restart itself....(motherboard problem?)

Shane711 — Thu, 10 Sep 2009 10:40:04 +0800

Hi to all,

My pc dono why this few days sometime got display sometime dont have...
There have sound of beep beep beep beep...I think shld be 5 times... But the sound not too loud...
I dont think so is RAM problem sound... Cos RAM problem sound is more louder... Am I right??
Then I go plug in and out the HD and Graphic card... Sometime can work again... but sometime fail...
Then ytd It can go into the windows already... Always restart itself before WINDOW XP LOADING...

So I went to bought a new motherboard... At first, I plug into the built-in VGA Graphic card... the pc can work...
But after a moment it restart itself when login to window... Then I power on again...unfortunately I unable to open the pc d... All fun in CPU are work... But dont have display at all...
Can I know what is happening?? Possible is prosessor spoil?? Or graphic card?? Or else Network card?? Or Operating system problem?? Or my new motherboard got problem??
(I have graphic card and network card which are not built in one...)

Thank you all!!