Admin part in our website..

To Kirtan ..

hi...i tried tht way as u have suggested..

bt its working bt not fully..

in updateproducts.aspx i have

1 datalist control and 1 detailsview control....

DETEAILSVIEW & SQLDATASOURCE

 <%-- Sqldatasource for DetailsView --%> 
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [product] WHERE ([pcode] = @pcode)"
DeleteCommand="DELETE FROM [product] WHERE [pcode] = @pcode"
InsertCommand="Insert into [product] ([pcode],[pname], [purl], [price],[disc]) VALUES (@pcode, @pname, @purl, @price, @disc)"
UpdateCommand="UPDATE [product] SET [pname] = @pname, [disc] = @disc, [price] = @price, [purl] = @purl WHERE [pcode] = @pcode"
OnInserted="SqlDataSource2_Inserted" OnUpdated="SqlDataSource2_Updated" OnDeleted="SqlDataSource2_Deleted">
<DeleteParameters>
<asp:Parameter Name="pcode" Type="string" />
DeleteParameters>
<SelectParameters>
<asp:ControlParameter Name="pcode" Type="String" ControlID="DataList1" PropertyName="SelectedValue">asp:ControlParameter>
SelectParameters>
<UpdateParameters>
<asp:Parameter Name="pname" Type="string" />
<asp:Parameter Name="disc" Type="String" />
<asp:Parameter Name="price" Type="double" />
<asp:Parameter Name="purl" Type="string" />
<asp:Parameter Name="pcode" Type="string" />
UpdateParameters>
<InsertParameters>
<asp:Parameter Name="pcode" Type="string"/>
<asp:Parameter Name="pname" Type="string" />
<asp:Parameter Name="purl" Type="string" />
<asp:Parameter Name="price" Type="double" />
<asp:Parameter Name="disc" Type="string" />
InsertParameters>
asp:SqlDataSource>
 
<%-- Details file --%>
 
<%-- Details View Which will display selected product and also add new and edit existing--%> 
 
<asp:DetailsView ID="DetailsView1" BorderColor="white" datasourceid="SqlDataSource2" 
BorderWidth="1px" runat="server" Height="50px" Width="600px" autogeneraterows="False"
AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" 
AutoGenerateInsertButton="True" DataKeyNames="pcode"> 
<HeaderStyle ForeColor="White" /> 
<FooterTemplate>
<asp:ValidationSummary Font-Bold="true" ForeColor="white" id="ValidationSummary1" runat="server">asp:ValidationSummary> 
FooterTemplate>
<Fields> 
<asp:TemplateField SortExpression="pcode" HeaderText="Code">
<ItemTemplate>
<asp:Label runat="server" Text='<%# Bind("pcode") %>' id="Label1">asp:Label>
ItemTemplate>
<InsertItemTemplate>
<asp:TextBox runat="server" Text='<%# Bind("pcode") %>' id="pcod"/><br />
InsertItemTemplate>
<HeaderStyle Font-Bold="True" ForeColor="White" />
asp:TemplateField> 
<asp:BoundField DataField="pname" HeaderText="Product Name" SortExpression="pname" >
<HeaderStyle Font-Bold="True" ForeColor="White" />
<ItemStyle ForeColor="White" />
asp:BoundField>
<asp:BoundField DataField="price" HeaderText="Price" SortExpression="price" >
<HeaderStyle Font-Bold="True" ForeColor="White" />
<ItemStyle ForeColor="White" />
asp:BoundField>
<asp:TemplateField SortExpression="purl" HeaderText="PictureURL">
<EditItemTemplate>
<asp:TextBox runat="server" Text='<%# Bind("purl") %>' id="txtPictureURL"/>
<br />
 
<asp:FileUpload ID="FileUpload1" Runat="server" />
<asp:Button ID="btnUpload" Runat="server" Text="Upload Picture" OnClick="btnUpload_Click"
Width="127px" Height="21px" />
 
<asp:Label ID="Status" Runat="server">asp:Label>
 
EditItemTemplate>
<ItemTemplate> 
<asp:Label runat="server" Text='<%# Bind("purl") %>' id="lblurl">asp:Label>
ItemTemplate>
<InsertItemTemplate>
<asp:TextBox runat="server" Text='<%# Bind("purl") %>' id="txtPictureURL">
asp:TextBox><br />
 
<asp:FileUpload ID="FileUpload1" Runat="server" />
<asp:Button ID="btnUpload" Runat="server" Text="Upload Picture" OnClick="btnUpload_Click"
Width="127px" Height="21px" />
 
<asp:Label ID="Status" Runat="server">asp:Label>
InsertItemTemplate>
asp:TemplateField>
<asp:TemplateField SortExpression="disc" HeaderText="Description">
<EditItemTemplate>
<asp:TextBox runat="server" Text='<%# Bind("disc") %>' id="TextBox2" Columns="50" TextMode="MultiLine" Rows="3">asp:TextBox>
<asp:requiredfieldvalidator id="RequiredFieldValidator1" runat="server"
errormessage="You must enter a description" controltovalidate="TextBox2">*asp:requiredfieldvalidator>
EditItemTemplate>
<ItemTemplate>
<asp:Label runat="server" Text='<%# Bind("disc") %>' id="Label2">asp:Label>
ItemTemplate>
<InsertItemTemplate>
<asp:TextBox runat="server" Text='<%# Bind("disc") %>' id="TextBox2" Columns="50" TextMode="MultiLine" Rows="3">asp:TextBox>
<asp:requiredfieldvalidator id="RequiredFieldValidator1" runat="server"
errormessage="You must enter a description" controltovalidate="TextBox2">*asp:requiredfieldvalidator>
InsertItemTemplate>
<HeaderStyle Font-Bold="True" ForeColor="White" />
asp:TemplateField>
Fields>
asp:DetailsView>

DATA LIST SQLDATA SOURCE:

 <%-- Sqldatasource for datalist--%> 
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [product]" 
DeleteCommand="DELETE FROM [product] WHERE [pcode] = @pcode"
InsertCommand="Insert into [product] ([pcode], [pname], [purl], [price],[disc]) VALUES (@pcode, @pname, @purl, @price, @disc)"
UpdateCommand="UPDATE [products] SET [pname] = @pname, [disc] = @disc, [price] = @price, [purl] = @purl WHERE [pcode] = @pcode">
<DeleteParameters>
<asp:Parameter Name="pcode" Type="string" />
DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="pname" Type="string" />
<asp:Parameter Name="disc" Type="String" />
<asp:Parameter Name="price" Type="double" />
<asp:Parameter Name="purl" Type="string" />
<asp:Parameter Name="pcode" Type="string" />
UpdateParameters>
<InsertParameters>
<asp:Parameter Name="pcode" Type="string"/>
<asp:Parameter Name="pname" Type="string" />
<asp:Parameter Name="purl" Type="string" />
<asp:Parameter Name="price" Type="double" />
<asp:Parameter Name="disc" Type="string" />
InsertParameters>
asp:SqlDataSource>
 
<%-- datalist--%> 
<asp:DataList ID="DataList1"
runat="server" DataSourceID="SqlDataSource1" RepeatColumns="4" 
RepeatDirection="Horizontal" BackColor="Transparent" BorderColor="White" 
BorderStyle="None" BorderWidth="2px" CellPadding="0" 
GridLines="Both" ShowFooter="False" ShowHeader="False" 
Width="80%" Height="400" CellSpacing="0" ForeColor="Black" DataKeyField="pcode">
<ItemTemplate>
<asp:Image ImageUrl='<%# Eval("purl","~/Products/items/{0}") %>' runat="server" id="PictureURLImage" Height="80" Width="80" BorderWidth="2px" /><br /><br />
<asp:Label Text='<%# Eval("pname") %>' runat="server" id="NameLabel" style="font-weight:bold"/><br />
<asp:Label Text='<%# Eval("price") %>' runat="server" id="PriceLabel"/> Rs.<br />
<asp:LinkButton id="LinkButton1" runat="server" CommandName="Select">Selectasp:LinkButton>
ItemTemplate>
<SelectedItemStyle BorderColor="#ff9900" BorderStyle="dashed" BorderWidth="1px" />
<ItemStyle VerticalAlign="top" HorizontalAlign="left" />
asp:DataList>

and at the top:

 
 
<asp:linkbutton id="btnNewItem" runat="server" commandname="New" OnClick="btnNewItem_Click">Add New Itemasp:linkbutton>
<br /><br />
 
.cs
 
protected void btnNewItem_Click(object sender, EventArgs e)
{
DetailsView1.ChangeMode(DetailsViewMode.Insert);
}

so by ur code i wrote:

 protected void btnUpload_Click(object sender, System.EventArgs e)
{
 
FileUpload fp = (FileUpload)DetailsView1.FindControl("FileUpload1");
 
if (fp.HasFile == true)
{
 
string FileName = fp.FileName;
//Get Actual Path of Images Folder on Server 
string FolderPathToSave = Server.MapPath("~/Products/items");
 
//Save Image in Images Folder
fp.SaveAs(FolderPathToSave + @"\" + FileName);
string PathToStoreInDatabase = @"~/Products/items" + FileName;
 
}

it stores image in the folder, bt not the imageurl in the database...!

where is the problem?

thanx!

Hi Diya

Here is your Solution

take one FileUpload Control and One Button Control and Code Like Below

 protected void btnUpload_Click(object sender, EventArgs e)
    {
        if (FileUpload1.HasFile == true)
        {
            //Get Just FileName not Full path of File
            string FileName = FileUpload1.FileName;
            
           //Get Actual Path of Images Folder  on Server 
            string FolderPathToSave = Server.MapPath("images");

            //Save Image in Images Folder
            FileUpload1.SaveAs(FolderPathToSave+@"\"+FileName);
 
            string PathToStoreInDatabase = @"~\images\" + FileName;
 
 // Insert PathToStoreDatabase in Database to Retrive Image Path Again When you need From Database 
            //Like If you want to Show Uploaded Image in Picture Control Then Code below 
 
            Image1.ImageUrl = PathToStoreInDatabase;
        }
    }

you can also Check Weather File is Only jpg /gif / png before saving it to images folder just mess with code you will get it :)

All the Best :)

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dipa Ahuja17y ago

hello from somewhere i found that fileupload doesnt work wth updatepanale bt by using following code it works

 
<div>

<table cellpadding="4" cellspacing="4" width="90%" align="center">
<tr>
<cc1:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:Label ID="Label1" runat="server" Text="Select A File To Upload:" ForeColor="Black">asp:Label>
     
<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:Button ID="ButtonUpload" runat="server" Height="25px" OnClick="ButtonUpload_Click" Text="Upload"
Width="128px" />
<br />
<asp:Label ID="Label2" runat="server">asp:Label>
<br />
ContentTemplate>
<Triggers>
<cc1:PostBackTrigger ControlID="ButtonUpload" />
Triggers>
cc1:UpdatePanel>
tr>
table>
div>

here file upload button is simple bt in my code it is inside the details view...!

so in the code how to write the controlId Property of detailsView 's btnUpload :

<Triggers> <cc1:PostBackTrigger ControlID="ButtonUpload" /> Triggers>

Dipa Ahuja17y ago
To Kirtan
hi would u plz see y the fileupload not working when i use ajax updatepanel...

http://www.mediafire.com/file/tlzn5jzgmjw/admin.rar
0
Dipa Ahuja17y ago
hi... its done..

i 4got to write this:

TextBox boundControl = (TextBox)DetailsView1.FindControl("txtPictureURL");
boundControl.Text = fp.FileName;

bt 1 problem when i take Ajax's updatepanel.. in my updateproduct.aspx, its not uploading the image.. y its happening so?
0
Dipa Ahuja17y ago
updateproduct.aspx is in the folder from root "admin"

and those images i want to store is from root : "products/items"
0

Dipa Ahuja17y ago
To Kirtan ..

hi...i tried tht way as u have suggested..

bt its working bt not fully..

in updateproducts.aspx i have

1 datalist control and 1 detailsview control....

DETEAILSVIEW & SQLDATASOURCE

<%-- Sqldatasource for DetailsView --%>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [product] WHERE ([pcode] = @pcode)"
DeleteCommand="DELETE FROM [product] WHERE [pcode] = @pcode"
InsertCommand="Insert into [product] ([pcode],[pname], [purl], [price],[disc]) VALUES (@pcode, @pname, @purl, @price, @disc)"
UpdateCommand="UPDATE [product] SET [pname] = @pname, [disc] = @disc, [price] = @price, [purl] = @purl WHERE [pcode] = @pcode"
OnInserted="SqlDataSource2_Inserted" OnUpdated="SqlDataSource2_Updated" OnDeleted="SqlDataSource2_Deleted">
<DeleteParameters>
<asp:Parameter Name="pcode" Type="string" />
DeleteParameters>
<SelectParameters>
<asp:ControlParameter Name="pcode" Type="String" ControlID="DataList1" PropertyName="SelectedValue">asp:ControlParameter>
SelectParameters>
<UpdateParameters>
<asp:Parameter Name="pname" Type="string" />
<asp:Parameter Name="disc" Type="String" />
<asp:Parameter Name="price" Type="double" />
<asp:Parameter Name="purl" Type="string" />
<asp:Parameter Name="pcode" Type="string" />
UpdateParameters>
<InsertParameters>
<asp:Parameter Name="pcode" Type="string"/>
<asp:Parameter Name="pname" Type="string" />
<asp:Parameter Name="purl" Type="string" />
<asp:Parameter Name="price" Type="double" />
<asp:Parameter Name="disc" Type="string" />
InsertParameters>
asp:SqlDataSource>

<%-- Details file --%>

<%-- Details View Which will display selected product and also add new and edit existing--%>

<asp:DetailsView ID="DetailsView1" BorderColor="white" datasourceid="SqlDataSource2"
BorderWidth="1px" runat="server" Height="50px" Width="600px" autogeneraterows="False"
AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
AutoGenerateInsertButton="True" DataKeyNames="pcode">
<HeaderStyle ForeColor="White" />
<FooterTemplate>
<asp:ValidationSummary Font-Bold="true" ForeColor="white" id="ValidationSummary1" runat="server">asp:ValidationSummary>
FooterTemplate>
<Fields>
<asp:TemplateField SortExpression="pcode" HeaderText="Code">
<ItemTemplate>
<asp:Label runat="server" Text='<%# Bind("pcode") %>' id="Label1">asp:Label>
ItemTemplate>
<InsertItemTemplate>
<asp:TextBox runat="server" Text='<%# Bind("pcode") %>' id="pcod"/> 
InsertItemTemplate>
<HeaderStyle Font-Bold="True" ForeColor="White" />
asp:TemplateField>
<asp:BoundField DataField="pname" HeaderText="Product Name" SortExpression="pname" >
<HeaderStyle Font-Bold="True" ForeColor="White" />
<ItemStyle ForeColor="White" />
asp:BoundField>
<asp:BoundField DataField="price" HeaderText="Price" SortExpression="price" >
<HeaderStyle Font-Bold="True" ForeColor="White" />
<ItemStyle ForeColor="White" />
asp:BoundField>
<asp:TemplateField SortExpression="purl" HeaderText="PictureURL">
<EditItemTemplate>
<asp:TextBox runat="server" Text='<%# Bind("purl") %>' id="txtPictureURL"/>
 

<asp:FileUpload ID="FileUpload1" Runat="server" />
<asp:Button ID="btnUpload" Runat="server" Text="Upload Picture" OnClick="btnUpload_Click"
Width="127px" Height="21px" />

<asp:Label ID="Status" Runat="server">asp:Label>

EditItemTemplate>
<ItemTemplate>
<asp:Label runat="server" Text='<%# Bind("purl") %>' id="lblurl">asp:Label>
ItemTemplate>
<InsertItemTemplate>
<asp:TextBox runat="server" Text='<%# Bind("purl") %>' id="txtPictureURL">
asp:TextBox> 

<asp:FileUpload ID="FileUpload1" Runat="server" />
<asp:Button ID="btnUpload" Runat="server" Text="Upload Picture" OnClick="btnUpload_Click"
Width="127px" Height="21px" />

<asp:Label ID="Status" Runat="server">asp:Label>
InsertItemTemplate>
asp:TemplateField>
<asp:TemplateField SortExpression="disc" HeaderText="Description">
<EditItemTemplate>
<asp:TextBox runat="server" Text='<%# Bind("disc") %>' id="TextBox2" Columns="50" TextMode="MultiLine" Rows="3">asp:TextBox>
<asp:requiredfieldvalidator id="RequiredFieldValidator1" runat="server"
errormessage="You must enter a description" controltovalidate="TextBox2">*asp:requiredfieldvalidator>
EditItemTemplate>
<ItemTemplate>
<asp:Label runat="server" Text='<%# Bind("disc") %>' id="Label2">asp:Label>
ItemTemplate>
<InsertItemTemplate>
<asp:TextBox runat="server" Text='<%# Bind("disc") %>' id="TextBox2" Columns="50" TextMode="MultiLine" Rows="3">asp:TextBox>
<asp:requiredfieldvalidator id="RequiredFieldValidator1" runat="server"
errormessage="You must enter a description" controltovalidate="TextBox2">*asp:requiredfieldvalidator>
InsertItemTemplate>
<HeaderStyle Font-Bold="True" ForeColor="White" />
asp:TemplateField>
Fields>
asp:DetailsView>

DATA LIST SQLDATA SOURCE:

<%-- Sqldatasource for datalist--%>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [product]"
DeleteCommand="DELETE FROM [product] WHERE [pcode] = @pcode"
InsertCommand="Insert into [product] ([pcode], [pname], [purl], [price],[disc]) VALUES (@pcode, @pname, @purl, @price, @disc)"
UpdateCommand="UPDATE [products] SET [pname] = @pname, [disc] = @disc, [price] = @price, [purl] = @purl WHERE [pcode] = @pcode">
<DeleteParameters>
<asp:Parameter Name="pcode" Type="string" />
DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="pname" Type="string" />
<asp:Parameter Name="disc" Type="String" />
<asp:Parameter Name="price" Type="double" />
<asp:Parameter Name="purl" Type="string" />
<asp:Parameter Name="pcode" Type="string" />
UpdateParameters>
<InsertParameters>
<asp:Parameter Name="pcode" Type="string"/>
<asp:Parameter Name="pname" Type="string" />
<asp:Parameter Name="purl" Type="string" />
<asp:Parameter Name="price" Type="double" />
<asp:Parameter Name="disc" Type="string" />
InsertParameters>
asp:SqlDataSource>

<%-- datalist--%>
<asp:DataList ID="DataList1"
runat="server" DataSourceID="SqlDataSource1" RepeatColumns="4"
RepeatDirection="Horizontal" BackColor="Transparent" BorderColor="White"
BorderStyle="None" BorderWidth="2px" CellPadding="0"
GridLines="Both" ShowFooter="False" ShowHeader="False"
Width="80%" Height="400" CellSpacing="0" ForeColor="Black" DataKeyField="pcode">
<ItemTemplate>
<asp:Image ImageUrl='<%# Eval("purl","~/Products/items/{0}") %>' runat="server" id="PictureURLImage" Height="80" Width="80" BorderWidth="2px" /> 
<asp:Label Text='<%# Eval("pname") %>' runat="server" id="NameLabel" style="font-weight:bold"/> 
<asp:Label Text='<%# Eval("price") %>' runat="server" id="PriceLabel"/> Rs. 
<asp:LinkButton id="LinkButton1" runat="server" CommandName="Select">Selectasp:LinkButton>
ItemTemplate>
<SelectedItemStyle BorderColor="#ff9900" BorderStyle="dashed" BorderWidth="1px" />
<ItemStyle VerticalAlign="top" HorizontalAlign="left" />
asp:DataList>

and at the top:

<asp:linkbutton id="btnNewItem" runat="server" commandname="New" OnClick="btnNewItem_Click">Add New Itemasp:linkbutton>
 

.cs

protected void btnNewItem_Click(object sender, EventArgs e)
{
DetailsView1.ChangeMode(DetailsViewMode.Insert);
}

so by ur code i wrote:

protected void btnUpload_Click(object sender, System.EventArgs e)
{

FileUpload fp = (FileUpload)DetailsView1.FindControl("FileUpload1");

if (fp.HasFile == true)
{

string FileName = fp.FileName;
//Get Actual Path of Images Folder on Server
string FolderPathToSave = Server.MapPath("~/Products/items");

//Save Image in Images Folder
fp.SaveAs(FolderPathToSave + @"\" + FileName);
string PathToStoreInDatabase = @"~/Products/items" + FileName;

}

it stores image in the folder, bt not the imageurl in the database...!

where is the problem?

thanx!
0

Mahesh Chand17y ago
You must have read/write permissions on the Web folder where you will upload your images, otherwise file upload process will not work.
0
Kirtan Patel17y ago
Hi Diya

Here is your Solution

take one FileUpload Control and One Button Control and Code Like Below

protected void btnUpload_Click(object sender, EventArgs e)

    {

        if (FileUpload1.HasFile == true)

        {

            //Get Just FileName not Full path of File
            string FileName = FileUpload1.FileName;


           //Get Actual Path of Images Folder on Server
            string FolderPathToSave = Server.MapPath("images");

            //Save Image in Images Folder

            FileUpload1.SaveAs(FolderPathToSave+@"\"+FileName);

            string PathToStoreInDatabase = @"~\images\" + FileName;

// Insert PathToStoreDatabase in Database to Retrive Image Path Again When you need From Database

            //Like If you want to Show Uploaded Image in Picture Control Then Code below

            Image1.ImageUrl = PathToStoreInDatabase;

        }

    }

you can also Check Weather File is Only jpg /gif / png before saving it to images folder just mess with code you will get it :)

All the Best :)
0