Exemplo n.º 1
0
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["PlantConnectionString"].ToString());

        con.Open();
        SqlCommand cmd = con.CreateCommand();

        cmd.CommandText = "insert into gallery (imagename,imageurl) values (@imagename,@imageurl)";

        cmd.Parameters.AddWithValue("imagename", TextBox1.Text);

        string imgurl = ImageUpload1.PostedFile.FileName.ToString();

        ImageUpload1.SaveAs(Server.MapPath("~/images/gallery/" + imgurl));


        string urlimage = "~/images/gallery/" + ImageUpload1.PostedFile.FileName.ToString();

        cmd.Parameters.AddWithValue("imageurl", urlimage);
        cmd.ExecuteNonQuery();
        cmd.Dispose();
        con.Close();
        lblmsg.Text   = "Success";
        TextBox1.Text = "";
    }
Exemplo n.º 2
0
        protected void SubmitButton1_Click(object sender, EventArgs e)
        {
            try
            {
                DateTime dob = DateTime.Parse(Request.Form[TextBox1.UniqueID]);
                byte[]   bytes;
                string   filename    = Path.GetFileName(ImageUpload1.PostedFile.FileName);
                string   contentType = ImageUpload1.PostedFile.ContentType;
                using (Stream fs = ImageUpload1.PostedFile.InputStream)
                {
                    using (BinaryReader br = new BinaryReader(fs))
                    {
                        bytes = br.ReadBytes((Int32)fs.Length);
                    }
                }
                Random random       = new Random();
                int    randomNumber = random.Next(0, 10000);
                string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
                ProfileImage.ImageUrl = "data:image/png;base64," + base64String;
                string connstr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
                dtb.Columns.Add("UserName", typeof(string));
                dtb.Columns.Add("EmailID", typeof(string));
                dtb.Columns.Add("PhoneNumber", typeof(string));
                dtb.Columns.Add("FBLink", typeof(string));

                //save Image to a folder
                if (ImageUpload1.FileName != string.Empty)//ImageUpload1.HasFile
                {
                    // Your code to save the file
                    ImageUpload1.SaveAs(Server.MapPath("~/Images/" + filename));
                }

                //Write code for DB connection and saving rows into a table in DB
                using (MySqlConnection con = new MySqlConnection(connstr))
                {
                    using (MySqlCommand cmd = new MySqlCommand("INSERT INTO sociallist.sociallisttable (Name,DateofBirth,EMailID,Phone,FaceBook,ProfilePicture)VALUES (@Name,@DateofBirth,@Email,@Phone,@URI,@ProfilePicture)"))
                    {
                        cmd.Parameters.AddWithValue("@Name", TxUserName.Text);
                        cmd.Parameters.AddWithValue("@DateofBirth", dob);
                        cmd.Parameters.AddWithValue("@Email", TxEmail.Text);
                        cmd.Parameters.AddWithValue("@Phone", TxPhone.Text);
                        cmd.Parameters.AddWithValue("@URI", TxFB.Text);
                        cmd.Parameters.AddWithValue("@ProfilePicture", bytes);
                        using (MySqlDataAdapter sda = new MySqlDataAdapter())
                        {
                            cmd.Connection    = con;
                            sda.SelectCommand = cmd;
                            con.Open();
                            cmd.ExecuteNonQuery();
                        }
                    }
                }

                dtb.Rows.Add(TxUserName.Text, TxEmail.Text, TxPhone.Text, TxFB.Text);
                GenerateTable(dtb);

                if (TxEmail.Text != string.Empty)
                {
                    if (TxFB.Text != string.Empty || TxUserName.Text != string.Empty || TxPhone.Text != string.Empty)
                    {
                        TxUserName.Focus();
                        TxPhone.Text = string.Empty;
                        TxFB.Text    = string.Empty;
                    }
                }
            }
            catch (Exception ex)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + ex.Message + "');", true);
            }
        }