Hi,
I need to display calculation values on the datagrid but the problem is how do I control the datagrid if data in S1 field is =0
If its 0 this msg will come out :->divide by zero error encountered
 Sub BindGrid()
        BindDataSet()
        DataGrid1.Visible = True

        DataGrid1.DataSource = dv
        With DataGrid1
            Try
                DataGrid1.DataBind()
            Catch
                .CurrentPageIndex = 0
                DataGrid1.DataBind()
            End Try
        End With
    End Sub

Sub BindDataSet()
        Dim Area_sf, PSF, L_Area, Price As Double
        objConn = New SqlConnection(ConfigurationSettings.AppSettings("c onnVIOS"))
        strSql = "SELECT *, L_AREA / 0.0929AS Area_sf ,PRICE/(L_AREA / 0.0929) * S2/S1 AS PSF FROM VSALES2"

        sda = New SqlDataAdapter(strSql, objConn)
        ds = New DataSet
        sda.Fill(ds, "Sales")
        dt = ds.Tables("Sales")
        dv = New DataView(dt)
        lblAyat.Text = "Record Found - " & dv.Count
        objConn.Close()

    End Sub


Please help and thanks in advance.

replace the line
strSql = "SELECT *, L_AREA / 0.0929AS Area_sf ,PRICE/(L_AREA / 0.0929) * S2/S1 AS PSF FROM VSALES2"

by line using case

strSql = "SELECT *
,L_AREA / 0.0929AS Area_sf
,case S1 when 0 then [Any Max Value] else PRICE/(L_AREA / 0.0929) * S2/S1 end AS PSF
FROM VSALES2"




Ahmed Ali
Software Developer

Still not working ahmed any other suggestion?

Try putting a (If/else) check in place of the strsql= line to make sure s1 isn't 0.. Make a SQLDataReader to check what S1 is, and if it's 0, I'm not sure what that sql line is computing but factor that in however it should be and set it to strsql (need to know what S1 is, and why it would be 0 if it's the denominator), else, put what you have now in strsql.

Btw when you did Ahmed's suggestion, did you write a number in place of [Any Max Value]?