Hai Take Compare Validator and Change main Properties like this 1.Type=Currency 2.Operator= DataTypeCheck Thanks and Regards Siddu

Siddu Software Developer

Hai Take One CompareField Validator and go to propeties 1.Type= integer 2.Operator= DataTypeChecking. Happy Coding

Siddu Software Developer

I am Doing Datagrid Editing.While i am updating Data it is not showing any error but doesn't display Syntax Error Also .This is My Code i have placed Datagrid_UpdateCommand ---------------------- Dim conn As SqlConnection Dim MyCommand As SqlCommand Dim strConn As String = "Data source=B4-2F-128-HTB2\SQLSVR; user id=sa; password=; Database=New_Cart" Dim txtQty As TextBox = e.Item.Cells(3).Controls(0) Dim strUpdateStmt As String strUpdateStmt = " UPDATE ProductDetails SET Qty =@Qty " & _ " WHERE Pcode = @pcode" conn = New SqlConnection(strConn) MyCommand = New SqlCommand(strUpdateStmt, conn) MyCommand.Parameters.Add(New SqlParameter("@Qty", txtQty.Text)) MyCommand.Parameters.Add(New SqlParameter("@Pcode", e.Item.Cells(1).Text)) conn.Open() MyCommand.ExecuteNonQuery() MyDataGrid.EditItemIndex = -1 conn.Close() BindData()

Siddu Software Developer