ASP.NET

<br />
<br />
 Private Sub btnRetrive_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRetrive.Click<br />
        Dim sqlconn As New SqlConnection(ConfigurationSettings.AppSettings("BILL_CONSTR"))<br />
        Dim sqlcommand As New SqlCommand("select PersonImage from dbo.Person where PersonID=3", sqlconn)<br />
        Try<br />
            sqlconn.Open()<br />
            Dim SqlData As SqlDataReader<br />
            SqlData = sqlcommand.ExecuteReader(CommandBehavior.CloseConnection)<br />
            Do While (SqlData.Read())<br />
                Response.ContentType = "image/gif"<br />
                Response.BinaryWrite(SqlData.Item("PersonImage"))<br />
            Loop<br />
            sqlconn.Close()<br />
        Catch SQLex As SqlException<br />
            Response.Write("Insert Failed. Error Details are: " & SQLex.ToString())<br />
<br />
        End Try<br />
    End Sub<br />
<br />
<br />
<br />
<br />

Response.ClearHeaders()<br />
  Response.Cache.SetNoStore()<br />
  Response.ContentType = "image/gif"<br />
  Response.BinaryWrite(lImageDataset.Tables(0).Rows(0)(0))

<br />
'Using DB To Store Image IN Database<br />
 Private Sub btnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSave.Click<br />
<br />
        Dim oStrPostedFileName, oStrFileName<br />
        Dim oBinaryReader As BinaryReader<br />
        Dim fs As FileStream<br />
<br />
        intImageSize = fileUploadCTRL.PostedFile.ContentLength<br />
        strImagetype = fileUploadCTRL.PostedFile.ContentType<br />
        ImageStream = fileUploadCTRL.PostedFile.InputStream<br />
        oStrPostedFileName = System.IO.Path.GetFullPath(fileUploadCTRL.Value)<br />
<br />
        Dim ImageContent(intImageSize) As Byte<br />
        intsize = ImageStream.Read(ImageContent, 0, intsize)<br />
<br />
<br />
<br />
        fs = New FileStream(oStrPostedFileName, FileMode.Open, FileAccess.Read)<br />
        Dim MyData(fs.Length) As Byte<br />
<br />
        oBinaryReader = New BinaryReader(fs)<br />
        ImageContent = oBinaryReader.ReadBytes(CType(fs.Length, Integer))<br />
        oBinaryReader.Close()<br />
        fs.Close()<br />
<br />
        Dim sqlconn As New SqlConnection(ConfigurationSettings.AppSettings("BILL_CONSTR1"))<br />
        sqlconn.Open()<br />
<br />
        Dim sqlcommand As New SqlCommand("sp_Image", sqlconn)<br />
        sqlcommand.CommandType = CommandType.StoredProcedure<br />
        sqlcommand.Parameters.Add(New SqlParameter("@PersonImage", SqlDbType.Image))<br />
        sqlcommand.Parameters("@PersonImage").Value = ImageContent<br />
        sqlcommand.ExecuteNonQuery()<br />
        Response.Write("New Image Added Successfully")<br />
    End Sub<br />
<br />
'Reteriving From DB<br />
Private Sub btnRetrive_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRetrive.Click<br />
        Dim sqlconn As New SqlConnection(ConfigurationSettings.AppSettings("BILL_CONSTR1"))<br />
        Dim ds As New DataSet<br />
        Dim i As Integer<br />
        Dim da As New SqlDataAdapter("select PersonImage from Contacts.dbo.Person where pid in(1,2,3)", sqlconn)<br />
        Try<br />
            sqlconn.Open()<br />
            da.Fill(ds)<br />
            For i = 0 To ds.Tables(0).Rows.Count - 1<br />
<br />
                Response.ClearHeaders()<br />
                Response.Cache.SetNoStore()<br />
                Response.ContentType = "image/gif"<br />
                Response.BinaryWrite(ds.Tables(0).Rows(i).Item("PersonImage"))<br />
            Next<br />
<br />
        Catch ex As Exception<br />
            ex.Message.ToString()<br />
        Finally<br />
            sqlconn.Close()<br />
        End Try<br />
    End Sub<br />
<br />
End Class<br />

System.Web.Mail.MailMessage m = System.Web.Mail.MailMessage();
m.Attachments.Add();

VinothRao wrote:

protected string ConvertPercent(object number)
{
if (number == DBNull.Value)
return "-";
else
if (number == float.Negative)
return "0";
else
return "1";
};

if(number.ToString().Contains("-"))
return 0;
else
return 1;

Imran Khan Pathan wrote:

if(number.ToString().Contains("-"))return 0;elsereturn 1;

VinothRao wrote:

i want the "0" to be return incase NUMBER having negative (exp: -1.236)
i want the "1" to be return incase NUMBER having positive (exp: 1.236)

if (number < 0)
   return 0;
else
   return 1;

VinothRao wrote:

Operator '<' cannot be applied to operands of type 'object' and 'int'

protected string ConvertRM(object number)
{
   float FNumber = (float)number;
   if ( FNumber < 0 )
      return "0"; //It's a negative value
   else
      return "1"; //It's a positive value
}