Get value from field

Tue, 28 Jun 2011 11:42:04 -0700

Hi i need to get the value of a field:

How could i get the value of the field request (the field type is boolean

Thank's in advance

Here is the code:

string sql = "SELECT request FROM Table1 where id = 10";
        string connectionString = WebConfigurationManager.ConnectionStrings["Connect
ionString"].ConnectionString;
        SqlConnection con = new SqlConnection(connectionString);
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        con.Open();
        cmd.CommandText = sql;
        SqlDataReader dr;
        dr = cmd.ExecuteReader();

Thank's in advance

Re: Get value from field

Wed, 29 Jun 2011 00:29:29 -0700

Hi,

I believe you can do something like below. The syntax might not be correct but you will get an idea.

while (reader.Read())
{
if(reader.GetValue(0) != DBNull.Value)
{
bool result = reader.GetValue(0)
}

}

Hope this helps
<a href="http://www.serverintellect.com">ASP.NET Hosting</a>

'Get value from field' Thread RSS Feed

Get value from field

Re: Get value from field