C#

CREATE TABLE [dbo].[publication] (
    [id] INT IDENTITY(1,1) NOT NULL,
    [title] VARCHAR(50),
    [category] VARCHAR(50) NULL,
    [orig_file_name] VARCHAR(255) NULL,
    [publish_date] DATETIME NOT NULL DEFAULT(GETDATE()),
    [data] IMAGE NOT NULL,
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

public static int uploadPublication(string title, string originalFileName, DateTime publishDate, string category, System.IO.Stream publication)
{
    byte[] publicationData = new byte[publication.Length];
    publication.Read(publicationData, 0, Convert.ToInt32(publication.Length));
    SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ClubSiteDB"].ConnectionString);
    SqlCommand command = new SqlCommand("INSERT INTO publication (title, orig_file_name, publish_date, data, category) VALUES ( @title, @orig_file_name, @publish_date, @data, @category); select SCOPE_IDENTITY()", connection);
    SqlParameter param0 = new SqlParameter("@category", System.Data.SqlDbType.VarChar, 50);
    param0.Value = category;
    command.Parameters.Add(param0);
    SqlParameter param1 = new SqlParameter("@title", System.Data.SqlDbType.VarChar, 50);
    param1.Value = title;
    command.Parameters.Add(param1);
    SqlParameter param2 = new SqlParameter("@orig_file_name", System.Data.SqlDbType.VarChar, 255);
    param2.Value = originalFileName;
    command.Parameters.Add(param2);
    SqlParameter param3 = new SqlParameter("@publish_date", System.Data.SqlDbType.DateTime);
    param3.Value = publishDate;
    command.Parameters.Add(param3);
    SqlParameter param4 = new SqlParameter("@data", System.Data.SqlDbType.Image);
    param4.ParameterName = "data" ;
    param4.Value = publicationData;
    command.Parameters.Add(param4);
    connection.Open();
    object result = command.ExecuteScalar();
    connection.Close();
    if (result != null) 
    {
        return Convert.ToInt32(result);
    }
    else 
    {
        return 0;
    }
}

<br />
        private void button1_Click(object sender, EventArgs e)<br />
        {<br />
<br />
            this.BindingContext[this.empDataSet, "employees"].Position++;<br />
<br />
<br />
        }<br />

public static string NET_AuthenticatedMailSend(string mailFrom, string mailTo, string Subject, string MessageBody, string smtpHost, int smtpPort, string smtpNETAuthUser, string smtpNETAuthPassword)
            {
                //using System.Net.Mail;
                //using System.Net.Mime;
                //using System.Text.RegularExpressions;
                MailAddressCollection MailTO = mailTo;
                MailAddress MailFROM = Convert. mailFrom;
                System.Net.Mail.MailMessage email = new MailMessage();//(mailFrom, mailTo);
                email.From = MailFROM;
                email.CC = MailTO;
                email.Subject = "VERSION CONTROL (AUTORESPONDER): " + Subject;
                email.IsBodyHtml = true;
                email.Body = "VERSION CONTROL (AUTORESPONDER): \n\r" + MessageBody;
                System.Net.Mail.SmtpClient mailClient = new SmtpClient();
                System.Net.NetworkCredential basicAuthenticationInfo = new System.Net.NetworkCredential(smtpNETAuthUser, smtpNETAuthPassword);//("", "");
                mailClient.Host = smtpHost; // "exchange.liveoffice.com";
                mailClient.Port = smtpPort; // 25;
                mailClient.UseDefaultCredentials = false;
                mailClient.Credentials = basicAuthenticationInfo;

                try
                {
                    mailClient.Send(email);
                }

                catch (Exception ex)
                {
                    MessageBox.Show("Error Sending email: " + ex.ToString());
                    return ex.ToString();
                }

                return "1";

            }