Sql query

Dim constring As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\appln\appln\Acc.accdb"
        Dim insertcmd As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand
        Dim con As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection
        con.ConnectionString = constring
        insertcmd.CommandType = CommandType.Text
        insertcmd.CommandText = String.Format("select sum(total) from account where ID between {0} and {1}", TextBox1.Text, TextBox2.Text)
        insertcmd.Connection = con
        con.Open()
        Try
            Dim data As Object
            data = insertcmd.ExecuteScalar()
            If data Is Not NULL Then

                Dim result As Int32
                result = Convert.ToInt32(data)

        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try

        con.Close()

can you share the code?

Regards,
Iftikar

Try like this

 Dim constring As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\appln\appln\Acc.accdb"
        Dim insertcmd As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand
        Dim con As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection
        con.ConnectionString = constring
        insertcmd.CommandType = CommandType.Text
        insertcmd.CommandText = String.Format("select sum(total) from account where ID between {0} and {1}", TextBox1.Text, TextBox2.Text)
        insertcmd.Connection = con
        con.Open()
        Try
            Dim data as Object
            data=insertcmd.ExecuteScalar()
            If data IS NOT NULL

                  Dim result AS Int32
                  result=Convert.ToInt32(data)
 
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try

        con.Close()

Regards,
Iftikar

that means for that range you don't have value in your sql database. Can you run the below query in sql and check the result?

select total from account where ID between {0} and {1}", TextBox1.Text, TextBox2.Text


Regards,
Iftikar

can you check what value you are getting for the below sql in sql directly by passing the textbox value

"select sum(total) from account where ID between {0} and {1}", TextBox1.Text, TextBox2.Text

Regards,
Iftikar

Hi Nandini,

use ExecuteScalar() to get the value as object, unbox it to int/decimal type variable and check it.

do it like this:
-----------------------------------
cmd.CommandText=sql;
object retVal =  cmd.ExecuteScalar();
int sum = (int)retVal;
if(sum<0)
{
        //sum is negative
}
else
{
        //sum is positive
}
-----------------------------------------

Hope it helps.
Cheers!

Hi,
        You can just check the value weather it is less than 0 or not. If it is less than 0 then it is negative.

Regards,
Iftikar