Thank you so much. I will try this.

Hello, Below is my XML document. FP108MR 0 Z9999 I need to remove only node so that my xml document remains as below. FP108MR 0 Z9999 I used the following code to convert Dataset to a XMLdocument. Dim dtCounter As New DataSet("GetCountsResult") oDatabase.Connect() oDatabase.PopulateDataSet("Count", "Get_Current_Counter", True, dtCounter) Dim sw As New StringWriter dtCounter.WriteXml(sw, XmlWriteMode.IgnoreSchema) Dim xmldoc As New XmlDocument xmldoc.LoadXml(sw.ToString()) Please help me in getting this. Thanks.

Thanks Pete and Luc. I'm done with the changes as you suggested.

If dgEditor.Columns(e.ColumnIndex).Name = "Status" Then If dgEditor.Rows(e.RowIndex).Cells("Status").Value = "NEW" Then 'if already marked as new, leave it alone If IsDBNull(dgEditor.Rows(e.RowIndex).Cells("CommonLineName").Value) Then Else If dgEditor.Rows(e.RowIndex).Cells("CommonLineName").Value <> "" Then e.CellStyle.SelectionForeColor = Color.DarkGreen e.CellStyle.ForeColor = Color.DarkGreen e.CellStyle.BackColor = Color.Orange e.CellStyle.SelectionBackColor = Color.Orange End If End If Else If dgEditor.Rows(e.RowIndex).Cells("UsedFlag").Value = 1 Then dgEditor.Rows(e.RowIndex).Cells("Status").Value = "Used" e.CellStyle.BackColor = Color.LightGreen e.CellStyle.SelectionBackColor = Color.LightGreen e.CellStyle.SelectionForeColor = Color.Black Else If dgEditor.Rows(e.RowIndex).Cells("ExpiredFlag").Value = 1 Then If dgEditor.Rows(e.RowIndex).Cells("ApprovedFlag").Value = 1 Then dgEditor.Rows(e.RowIndex).Cells("Status").Value = "UnUsed" 'approved expired e.CellStyle.BackColor = Color.LightGray e.CellStyle.SelectionBackColor = Color.LightGray Else If dgEditor.Rows(e.RowIndex).Cells("RejectedFlag").Value = 1 Then dgEditor.Rows(e.RowIndex).Cells("Status").Value = "Expired" 'Rejected expired e.CellStyle.BackColor = Color.LightCoral e.CellStyle.SelectionBackColor = Color.LightCoral Else dgEditor.Rows(e.RowIndex).Cells("Status").Value = "Expired" 'pure expired - never approved and never rejected e.CellStyle.BackColor = Color.Gray e.CellStyle.SelectionBackColor = Color.Gray End If End If Else If dgEditor.Rows(e.RowIndex).Cells("RejectedFlag").Value = 1 Then

Please let me know if there are any steps to overcome it.? I will need to set the Color for "status" column.

Hello Pete, I tried to debug the code in the server after installing Visual studio. I'm getting the below error in Cell_formatting event in this line dgEditor.Rows(e.RowIndex).Cells("Status").Value = "Used" e.CellStyle.BackColor = Color.LightGreen e.CellStyle.SelectionBackColor = Color.LightGreen e.CellStyle.SelectionForeColor = Color.Black ERROR: An unhandled exception of type 'System.StackOverflowException' occurred in System.Windows.Forms.dll {Unable to evaluate expression.} I have made a check below, but it is partly working and not updating "Status" column and coloring, If e.Value Is Nothing Then Exit Sub End If Is there anyway i can mimic this issue? Please help. I can also paste my Cell_formating code if you want to look at it.

Could you please let me know the steps to do this?

Hello Pete, Pls find the details below. ColumnName DataType Length Nullable -------------------------------------------------------- ApprovedFlag int 4 no ApprovedDateTime datetime 8 yes ApprovedBy varchar 30 yes LastModifiedBy varchar 30 yes LastModifiedDateTime datetime 8 yes

DataGridView1.Item("ApprovedDateTime", e.RowIndex).Value = Now() DataGridView1.Item("ApprovedBy", e.RowIndex).Value = Username But the same code works fine for below columns DataGridView1.Rows(e.RowIndex).Cells("LastModifiedBy").Value = Username DataGridView1.Rows(e.RowIndex).Cells("LastModifiedDateTime").Value = Now() I tried to mimic the Null reference error, by replacing the first two lines with the below lines DataGridView1.Item("ApprovedDateTime", e.RowIndex).Value = now() DataGridView1.Item("ApprovedBy", e.RowIndex).Value = username even now also, i'm experiencing same issue and Application got crashed.

Yes Pete. Its a DateTime column.

Hello, I'm using a Datagridview in Windows application. Its working fine in my local machine, but when i tried to execute in my server( Winodws 2008 SP2), few columns not updating with the value using the below statement. DataGridView1.Rows(e.RowIndex).Cells("ApprovedBy").Value = "UserName" DataGridView1.Rows(e.RowIndex).Cells("ApprovedDateTime").Value = Now() Can anyone suggest a solution for this. Please!!. Thanks

Hi Dave,Paul and originSH, Thanks a lot for your comments. Let me explain my actual scenario, I have a C# Windows EXE which will call my Webserive hosted in another Webserver asynchronously. We have an UI interface which will call the above mentioned C# Windows EXE. when EXE gets abruptly aborted from UI Interface, my webservice still running in webserver machine. Any options or methods to stop my webservice when my EXE stops abruptly? Pls help me out. Thx Vidh

Hi all, I have a windows C# EXE. In most cases, it will be killed abruptly from TaskManager (its session will be killed). Is there any Event in C# to handle those abruptly closing of EXE? Need in urgent. Thanx in advance vidh

Hi Neo, Thx a lot for timely help .. It works fine... :) Vidhya

Hi Rahul.. I tried . Thx... But i need to write into Console window thru Win exe Code also Could u pls help Vidhya -- modified at 6:15 Thursday 8th March, 2007

Hi all, I have developed C#.net Windows Application and I've to open and write in Console window thru my Windows application. Pls help me to resolve this issue. Thx in Advance Vidhya