hello master .net why if I update fileupload1, then FileUplo

hothorasman panjaitan

11y1.3k.NET

pleas helpme

this my code

protected void Updatedata(object sender, GridViewUpdateEventArgs e)
{
FileUpload FileUpload1 = (FileUpload)GridView1.Rows[e.RowIndex].FindControl("FileUpload1");
        FileUpload FileUpload2 = (FileUpload)GridView1.Rows[e.RowIndex].FindControl("FileUpload2");

string id_peraturan = GridView1.DataKeys[e.RowIndex].Value.ToString();

string path1 = "Pembentukan/";
string path2 = "Pengelolaan/";

if (FileUpload1.HasFile)
        {
            path1 += FileUpload1.FileName;
            FileUpload1.SaveAs(MapPath(path1));
        }
if (FileUpload2.HasFile)
        {
            path2 += FileUpload2.FileName;
            FileUpload2.SaveAs(MapPath(path2));
        }

MySqlConnection con = new MySqlConnection(strConnString);

        MySqlCommand cmd = new MySqlCommand("UPDATE tbl_peraturan SET perda_pembentukan='" + path1 + "',perda_pengelolaan='"+ path2 +"' WHERE id_peraturan=" + id_peraturan + "", con);
con.Open();
        cmd.ExecuteNonQuery();
        con.Close()
GridView1.EditIndex = -1;
        tampilgird();
       Response.Redirect(Request.Url.AbsoluteUri);

}

4 Replies

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

hothorasman panjaitan11y ago

halo Mr.Francis

thnks to response.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"

            DataKeyNames="id_peraturan" onrowcancelingedit="batal" onrowdeleting="hapus"

            onrowupdating="update" onrowediting="edit">

    <Columns>



    <asp:BoundField DataField="propinsi_nama" HeaderText="Provinsi" ReadOnly="true" />

    <asp:BoundField DataField="kabupaten_nama" HeaderText="Kabupaten/Kota" ReadOnly="true" />

    <asp:BoundField DataField="sektor_nama" HeaderText="Bidang/Sektor" ReadOnly="true" />

<asp:TemplateField HeaderText="Perda Pembentukan">

<ItemTemplate>

    <asp:HyperLink ID="pembentukan" runat="server" Text='<%#Eval("perda_pembentukan") %>' NavigateUrl='<%#Eval("perda_pembentukan")%>' Target=_blank>asp:HyperLink>

ItemTemplate>

<EditItemTemplate>

    <asp:FileUpload ID="FileUpload1" runat="server" />

EditItemTemplate>

asp:TemplateField>

<asp:TemplateField HeaderText="Perda Pengelolaan">

<ItemTemplate>

    <asp:HyperLink ID="Pengelolaan" runat="server" Text='<%#Eval("perda_pengelolaan") %>' NavigateUrl='<%#Eval("perda_pengelolaan")%>' Target=_blank>asp:HyperLink>

ItemTemplate>

<EditItemTemplate>

    <asp:FileUpload ID="FileUpload2" runat="server" />

EditItemTemplate>

asp:TemplateField>



     <asp:CommandField ShowEditButton="true" HeaderText="Edit/Update" ButtonType="Button" />

    <asp:CommandField ShowDeleteButton="true" HeaderText="Hapus" ButtonType="Button" />

Columns>

asp:GridView>
Francis Susaimichael11y ago
This is because of "postback". Can you show the Markup of your page (.aspx)?
hothorasman panjaitan11y ago
if I update fileupload1 then fileupload2 be changed / deleted
keyur11y ago
Hello

Can you please provide more details ? What is not working ?