protected void AjaxFileUpload1_UploadComplete(object sender, AjaxControlToolkit.AjaxFileUploadEventArgs e)
{
byte[] image = e.GetContents();
MembershipUser currentUser = Membership.GetUser();
if (currentUser != null)
{
currentUserId = (Guid)currentUser.ProviderUserKey;
string connectionString =
ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString;
string updateSql = "UPDATE UserProfiles SET BackgroundPicture = @BackgroundPicture WHERE UserId = @UserId";
try
{
using (SqlConnection myConnection = new SqlConnection(connectionString))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(updateSql, myConnection);
myCommand.Parameters.AddWithValue("@UserId", currentUserId);
myCommand.Parameters.AddWithValue("@BackgroundPicture", image);
myCommand.ExecuteNonQuery();
myConnection.Close();
}
}
catch { }
}
this.DataBind();
e.DeleteTemporaryData();
}