Editing the file

Hello one an all,
I am having a requirement regarding my work i am doing. The requirement goes as follows. I am having my data saved in the SQL table as follows.

Id Name filename
----------------------
1 ABC abc.doc
------------------------
2 XYZ xyz.pdf
-------------------------
Like this some other file formats...

What i am doing is i am going to display all these in a grid view as follows.

Id Name Filename
--------------------------------
1 ABC abc.doc Edit
---------------------------------
2 XYZ xyz.pdf Edit
---------------------------------

What i need is when i click on edit i would like to get a file upload control there i will select a new file like some pqr.txt and i would like to replace the old file. For example if i click Edit in the first column then a file upload should appear and there what ever file i uploaded should be saved in place of abc.doc after clciking update and also if i would like to edit the name also i shoul. So can any one give me the code for my requirement...

Thanks In Advance,
M.DOrababu

I think you can add FileUpload control in the Edit template of the gridview and it can be used to save the uploading file.The following is sample code for your reference.Wish this help you.

HTML Code in .ASPX file:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
DataSourceID="AccessDataSource1" Width="148px" OnRowCommand="GridView1_RowCommand">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" />
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="lblFileUpLoad" runat="server"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:FileUpload ID="FileUpload1" runat="server" />
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowEditButton="true" ShowDeleteButton="true" />
</Columns>
</asp:GridView>

<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/AccessDb.mdb"
SelectCommand="SELECT [ID], [Name] FROM [task]" DeleteCommand="DELETE FROM [task] WHERE [ID] = ?" InsertCommand="INSERT INTO [task] ([ID], [Name]) VALUES (?, ?)" UpdateCommand="UPDATE [task] SET [Name] = ? WHERE [ID] = ?">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="Name" Type="String" />
</InsertParameters>
</asp:AccessDataSource>

Code Behind File:

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if(GridView1.EditIndex == -1) return;
FileUpload fileUpLoad = GridView1.Rows[GridView1.EditIndex].FindControl("FileUpload1") as FileUpload;
string fileName = fileUpLoad.FileName;
string fullPath = Path.GetFullPath(fileName);
fileUpLoad.SaveAs(fullPath);
}