I have problem in sql query [Resolved]

SELECT Isnull(SUM(F_VAT),0) AS Amunt FROM MyTbl WHERE (CONTRACT ='hpky000292') AND (DUEDATE >= GETDATE())"

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Hi,


Can you explain a bit more about the requirement?
It will be good if you can share me the script ,sample data and a sample of your desired result

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Im Executing this query using Sqldatareader. after I get this value as a variable.In that some time Read a null value and getting error,
I want to handle this null value.

Rathnayake

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Hi Please try this

using (SqlConnection connection = new SqlConnection(strConn))
{
connection.Open();
using (SqlCommand command = new SqlCommand("your query", connection))
{
//
// Invoke ExecuteReader method.
//
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{

if(!reader.IsDBNull(1))
Title = reader.GetString(1); //1 is the index of column

}

}
}

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Its work Great San.Pblr.Gct. thanks lot.

Rathnayake

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator