string cn = System.Configuration.ConfigurationManager.ConnectionStrings["EilyaCString"].ConnectionString.ToString();
Int32 mx = 0;

protected void Page_Load(object sender, EventArgs e)
{

}

void UploadFiles()
{
    if (File1.PostedFile.FileName != "")
    {
        string StrFileType1 = File1.PostedFile.FileName.Substring(File1.PostedFile.FileName.ToString().Length - 4, 4);
        File1.PostedFile.SaveAs(Request.PhysicalApplicationPath + @"imagesthumbnailsPaint_" + mx.ToString() + StrFileType1);
        string StrFileType2 = File2.PostedFile.FileName.Substring(File2.PostedFile.FileName.ToString().Length - 4, 4);
        File2.PostedFile.SaveAs(Request.PhysicalApplicationPath + @"imagesfullsizePaint_" + mx.ToString() + StrFileType2);
    }
}

protected void btnInsertPaint_Click(object sender, EventArgs e)
{
    MakeEId();
    UploadFiles();
    string flpth1 = "images/thumbnails/Paint_" + mx.ToString() + File1.PostedFile.FileName.Substring(File1.PostedFile.FileName.ToString().Length - 4, 4);
    string flpth2 = "images/fullsize/Paint_" + mx.ToString() + File2.PostedFile.FileName.Substring(File2.PostedFile.FileName.ToString().Length - 4, 4);
    sdsInsertPaintings.InsertParameters[0].DefaultValue = flpth1;
    sdsInsertPaintings.InsertParameters[1].DefaultValue = flpth2;
    sdsInsertPaintings.InsertParameters[2].DefaultValue = paintTitle.Text.Trim();
    sdsInsertPaintings.Insert();
    lblMyAlert.Visible = true;
    paintTitle.Text = null;
    flpth1 = null;
    flpth2 = null;
}

private void MakeEId()
{
    try
    {
        SqlConnection con = new SqlConnection(cn);
        SqlCommand cmd = new SqlCommand();
        cmd = con.CreateCommand();
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "SpMakePaintID";
        con.Open();
        SqlDataReader dbDR = cmd.ExecuteReader();
        while (dbDR.Read())
        {
            mx = Convert.ToInt32(dbDR["ID"].ToString()) + 1;
        }
        con.Close();
    }
    catch { }
}