dropdown list second value not save in sql but images save successfullyplease guide ltajaxToolkitScriptManager ID34toolkit134 runat34server34gtltajaxToolkitScriptManagergt ltaspDropDownList ID34dalbum34 runat34server34 gtltaspDropDownListgt ltajaxAjaxFileUpload ID34AjaxFileUpload134 runat34server34 AllowedFileTypes34jpgjpegpnggifbmpdocdocx34 OnUploadComplete34AjaxFileUpload1UploadComple

You need to add the DropDownList Selected Index change event If that event set the Selected value SessionHTMLltaspToolkitScriptManager ID34ToolkitScriptManager34 runat34server34gtltaspToolkitScriptManagergtltdiv align34center34gtltaspDropDownList ID34ddlFileType34 runat34server34 OnSelectedIndexChanged34FileTypeOnSelectedIndexChanged34 AutoPostBack34true34gtltaspDropDownListgtltaspAjaxFileUpload ID34AjaxFileUpload134 runat34server34 AllowedFileTypes34jpgjpegpnggif34 MaximumNumberOfFiles34334 OnUploadComplete34FileUpload34 Width34500px34 gtNamespacesusing AjaxControlToolkitusing SystemIOusing SystemDataSqlClientusing SystemDatausing SystemConfigurationCprotected void PageLoadobject sender EventArgs e if thisIsPostBack PopulateDropDownList protected void FileTypeOnSelectedIndexChangedobject sender EventAr

AJAX Multiple File Uploader : Save Files to database in ASP.Net

pathanyu...

SOLVED CLOSED ACTIVE ANSWERED
User: pathanyunu
Posted: on Feb 25, 2015 02:41 AM
Forum: ASP.Net AJAX
Answer: 1
Views: 3482

dropdown list second value not save in sql but images save successfully.

please guide..

 <ajax:ToolkitScriptManager ID="toolkit1" runat="server"></ajax:ToolkitScriptManager>
          <asp:DropDownList ID="dalbum" runat="server" ></asp:DropDownList>
            <ajax:AjaxFileUpload ID="AjaxFileUpload1" runat="server" AllowedFileTypes="jpg,jpeg,png,gif,bmp,doc,docx" OnUploadComplete="AjaxFileUpload1_UploadComplete1"/>

using System;
using System.Collections.Generic;

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.IO;

public partial class Default2 : System.Web.UI.Page
{
    SqlCommand cmd;
    SqlConnection con;
    SqlDataAdapter adp;
    DataSet ds;

   
     protected void Page_Load(object sender, EventArgs e)
    {
        con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconn1"].ConnectionString);
        if (!IsPostBack)
        {
           
          
           
            balbum();
      

        }
    }

     protected void balbum()
     {
         //conenction path for database
         // SqlConnection con = new SqlConnection(strConnection);
         con.Open();
         SqlCommand cmd = new SqlCommand("SELECT  * FROM Album", con);
         SqlDataAdapter da = new SqlDataAdapter(cmd);
         DataSet ds = new DataSet();
         da.Fill(ds);
         con.Close();
         dalbum.DataSource = ds;
         dalbum.DataTextField = "AlbumName";
         dalbum.DataValueField = "AlbumID";
         dalbum.Items.Clear();
         dalbum.DataBind();
         // dc.Items.Insert(0, new ListItem("--Select City--", "0"));
         //dcity.Items.Insert(0, new ListItem("Select", "0"));

         //for (int i = 0; i < dcity.Items.Count; i++)
         //{
         //    string[] sub = dcity.Items[i].ToString().Split(',');
         //    for (int J = 0; J < sub.Length; J++)
         //    {

         //        dcity.Items.Add(sub[J].ToString());
         //    }


         //}




     }
protected void AjaxFileUpload1_UploadComplete1(object sender, AjaxControlToolkit.AjaxFileUploadEventArgs e)
     {
         string filename = e.FileName;
       //  string name = dalbum.SelectedValue;
         AjaxFileUpload1.SaveAs(Server.MapPath("album/") + filename);

         // Storing the relative path to store into images
         string Imagepath = "album/" + filename;
         //string filepath = (Server.MapPath("~/my/") + Guid.NewGuid() + System.IO.Path.GetFileName(e.FileName));
         //AjaxFileUpload1.SaveAs(filepath);
         //string fl = filepath.Substring(filepath.LastIndexOf("\\"));
         //string[] split = fl.Split('\\');
         //string newpath = split[1];
         //string imagepath = "~/my/" + newpath;
         string Insert = "Insert into Photalbum (Photo,AlbumID) values(@Photo,@AlbumID)";
         SqlCommand cmd = new SqlCommand(Insert, con);
         cmd.Parameters.AddWithValue("@Photo", Imagepath);
         cmd.Parameters.AddWithValue("@AlbumID", dalbum.SelectedValue);
        
         con.Open();
         cmd.ExecuteNonQuery();
         con.Close();
         cmd.Dispose();

 }
}

PhotAlbum

PhotoID	int	Unchecked
Photo	nvarchar(MAX)	Checked
PhotoName	nvarchar(MAX)	Checked
AlbumID	int	Checked
detail	nvarchar(MAX)	Checked
		Unchecked

Album

AlbumID	int	Unchecked
AlbumName	nvarchar(MAX)	Checked
DefaultPhotID	int	Checked
details	nvarchar(MAX)	Checked
thumb	nvarchar(MAX)	Checked
		Unchecked

Download FREE API for Word, Excel and PDF in ASP.Net

Azim

0 8

Reply
ANSWER
User: Azim
Replied: on Feb 25, 2015 05:11 AM
Report

You need to add the DropDownList Selected Index change event. If that event set the Selected value Session.

HTML

<asp:ToolkitScriptManager ID="ToolkitScriptManager" runat="server">
</asp:ToolkitScriptManager>
<div align="center">
<asp:DropDownList ID="ddlFileType" runat="server" OnSelectedIndexChanged="FileType_OnSelectedIndexChanged"
    AutoPostBack="true">
</asp:DropDownList>
<asp:AjaxFileUpload ID="AjaxFileUpload1" runat="server" AllowedFileTypes="jpg,jpeg,png,gif"
    MaximumNumberOfFiles="3" OnUploadComplete="File_Upload" Width="500px" />

Namespaces

using AjaxControlToolkit;
using System.IO;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        PopulateDropDownList();
    }    
}

protected void FileType_OnSelectedIndexChanged(object sender, EventArgs e)
{
    Session["SelectedValue"] = this.ddlFileType.SelectedItem.Value;
}

private void PopulateDropDownList()
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection cn = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT * FROM FileType", cn))
        {
            using (SqlDataAdapter da = new SqlDataAdapter(cmd))
            {

                DataSet ds = new DataSet();
                da.Fill(ds);
                this.ddlFileType.DataTextField = "Type";
                this.ddlFileType.DataValueField = "Id";
                this.ddlFileType.DataSource = ds;
                this.ddlFileType.DataBind();
            }
        }
    }
}

protected void File_Upload(object sender, AjaxFileUploadEventArgs e)
{
    string filename = Path.GetFileName(e.FileName);
    string strDestPath = Server.MapPath("~/Documents/");
    string strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(strConnString))
    {
        string strQuery = "INSERT INTO FilesUploaded (FileType, FileName, FilePath) VALUES(@FileType,@FileName, @FilePath)";
        using (SqlCommand cmd = new SqlCommand(strQuery))
        {
            cmd.Parameters.AddWithValue("@FileType", Convert.ToInt32(Session["SelectedValue"]));
            cmd.Parameters.AddWithValue("@FileName", filename);
            cmd.Parameters.AddWithValue("@FilePath", "Documents/" + filename);
            cmd.CommandType = CommandType.Text;
            cmd.Connection = con;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }

    //Save file to project
    AjaxFileUpload1.SaveAs(@strDestPath + filename);
}

SQL

CREATE TABLE [dbo].[FileType](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Type] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

INSERT INTO [dbo].[FileType]
           ([Type])
     VALUES
           ('Flower')
GO

INSERT INTO [dbo].[FileType]
           ([Type])
     VALUES
           ('Animal')
GO

INSERT INTO [dbo].[FileType]
           ([Type])
     VALUES
           ('Scenery')
GO


CREATE TABLE [dbo].[FilesUploaded](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[FileType] [varchar](50) NULL,
	[FileName] [varchar](100) NULL,
	[FilePath] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Screenshot

FileType is DropDownList value.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

AJAX Multiple File Uploader : Save Files to database in ASP.Net

Company

Explore

Follow us

Contact Us