C#

...(SqlConnection, SqlCommand stuff up here)...
MailMessage mm = new MailMessage(...);
SqlDataReader myReader = null;

conn.Open

myReader = cmd.ExecuteReader();
while (myReader.Read())
{
object buffer = myReader["Saved_File"];
mm.Attachments.Add(new Attachment(new MemoryStream((byte[])buffer), myReader["Filename"].ToString()));
}

conn.Close();

try
{
    byte[] buffer = null; <----- declare it here as null and of type byte[]
    while(myReader.Read())
    {
        buffer = myReader["Saved_File"] as byte[]; <----- safely convert the return value here
        if(buffer == null) <----- conversion failed, skip this item
            continue;
        mm.Attachments.Add(new Attachment(new MemoryStream(buffer), myReader["Filename"].ToString()));
    }
}
catch
{
     // <handle exception="" here="">
}
finally <----- close out database resources here
{
    if(myReader != null)
        myReader.Close();
    if(conn != null)
        conn.Close();
}</handle>

mobius111001 wrote:

.dll project

mobius111001 wrote:

add new features to the DLL

mobius111001 wrote:

If you can't just link in a DLLs source tree

mobius111001 wrote:

I step into a function debugging

mobius111001 wrote:

proper way to add a project to a solution

mobius111001 wrote:

is there a better solution?

ping_jacob wrote:

change mouse cursor outside form