Skip to main content

Deleting Row option with deleting file from server and database through gridview

First use gridview :

 <asp:GridView ID="grdAcademicResourceFilesView" runat="server" AutoGenerateColumns="False"
                            CellPadding="4" DataKeyNames="ID" ForeColor="#333333" GridLines="None" OnRowDeleting="grdAcademicResourceFilesView_RowDeleting"
                            Width="100%">
                            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                            <Columns>
                                <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
                                <asp:BoundField DataField="Name" HeaderText="Category Name" SortExpression="Name" />
                                <asp:BoundField DataField="ProgramCode" HeaderText="Program Code" SortExpression="ProgramCode" />
                                <asp:BoundField DataField="Semester" DataFormatString="Semester {0}" HeaderText="Term Id"
                                    SortExpression="Semester" />
                                <asp:BoundField DataField="UploadedFileName" HeaderText="File Name" SortExpression="UploadedFileName" />
                                <asp:BoundField DataField="CreatedBy" HeaderText="Uploaded By" SortExpression="CreatedBy" />
                                <asp:BoundField DataField="CreatedDate" DataFormatString="{0:d}" HeaderText="Upload Date"
                                    SortExpression="CreatedDate" />
                                <asp:BoundField DataField="CourseCode" HeaderText="Course Code" SortExpression="CourseCode" />
                                <asp:BoundField DataField="Remarks" HeaderText="Remarks" SortExpression="Remarks" />
                                <asp:TemplateField ShowHeader="False">
                                    <ItemTemplate>
                                        <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Delete"
                                            OnClientClick="return confirm ('Are you sure to delete this record');" Text="Delete"></asp:LinkButton>
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>
                            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                            <EditRowStyle BackColor="#999999" />
                            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                        </asp:GridView>

Then add sqldata source to attach to it.
 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:LCODLConnectionString %>"
                            SelectCommand="LcOdlViewAcademicUploadedFiles" SelectCommandType="StoredProcedure"></asp:SqlDataSource>

Then create event of gridview ROW DELETING and paste following code in code behind model

  protected void grdAcademicResourceFilesView_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string rowID = Convert.ToString(grdAcademicResourceFilesView.DataKeys[e.RowIndex]["ID"]);
        string uploadedFileName = grdAcademicResourceFilesView.Rows[e.RowIndex].Cells[4].Text;
        if (!string.IsNullOrEmpty(uploadedFileName))
        {
            using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["LCODLConnectionString"].ConnectionString))
            {
                SqlTransaction tran = null;
                if (con.State == ConnectionState.Closed)
                {
                    con.Open();
                }
                tran = con.BeginTransaction();
                bool canDeleteFile = false;
                try
                {
                    SqlParameter[] param = new SqlParameter[2];
                    param[0] = new SqlParameter("@id", rowID);
                    param[1] = new SqlParameter("@canDelete", SqlDbType.Bit);
                    param[1].Direction = ParameterDirection.Output;
                    SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, "LcOdlDeleteUploadedAcademicFile", param);
                    canDeleteFile = Convert.ToBoolean(param[1].Value);
                    tran.Commit();
                }
                catch (SqlException ex)
                {
                    tran.Rollback();
                    ScriptManager.RegisterStartupScript(grdAcademicResourceFilesView, grdAcademicResourceFilesView.GetType(), "DeletingError", "alert('Some thing went wrong while deleting file. Please try again later');", true);
                    return;
                }
                finally
                {
                    con.Close();
                }
                //Now going To Deleet file from filesystem

                string Rootfolder = Server.MapPath("~/IpSyllabusSchemas");
                string FilePathWithName = string.Format("{0}\\{1}", Rootfolder, uploadedFileName);
                if (canDeleteFile)
                {
                    if (File.Exists(FilePathWithName))
                    {
                        try
                        {
                            File.Delete(FilePathWithName);
                        }
                        catch (Exception ex)
                        {
                            tran.Rollback();
                            ScriptManager.RegisterStartupScript(grdAcademicResourceFilesView, grdAcademicResourceFilesView.GetType(), "DeletingError", "alert('Some thing went wrong while deleting file. Please try again later');", true);
                            return;
                        }
                    }
                }

                grdAcademicResourceFilesView.DataSource = GetUploadedFiles();
                grdAcademicResourceFilesView.DataBind();
            }

        }
    }

Done :)

Comments

Post a Comment

Popular posts from this blog

Export Doc,Access,Image,CSV,Excel,Pdf,XML,HTML,Text,Print of Gridview in Asp.net

First import itextsharp.dll in the solution and use three namespces (basically for pdf) using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html.simpleparser;          Then Use the following code :- on each button  click  protected void Page_Load(object sender, EventArgs e)         {             if (!Page.IsPostBack)             {                 BindGridDetails(GridView1);             }         }                 protected DataTable BindGridDetails(GridView GridView1)         {             DataTable dt = new DataTable();             dt.Columns.Add("Student_ID", typeof(Int32));             dt.Columns.Add("Student_Name", typeof(string));             dt.Columns.Add("Education", typeof(string));             dt.Columns.Add("City", typeof(string));             DataRow dtrow = dt.NewRow();             dtrow["Student_ID"] = 1;             dtrow["Student_Name"] = "Musakkhir";   
1 comment
Read more

Ip Sec Internet Security Basic Structure

The IPsec suite is an  open standard . IPsec uses the following  protocols  to perform various functions: Authentication Headers (AH)  provide connectionless  integrity  and data origin  authentication  for IP  datagrams  and provides protection against  replay attacks . Encapsulating Security Payloads (ESP)  provide  confidentiality , data-origin  authentication , connectionless  integrity , an anti-replay service (a form of partial sequence integrity), and limited traffic-flow confidentiality. Security Associations (SA)  provide the bundle of algorithms and data that provide the parameters necessary to AH and/or ESP operations. The  Internet Security Association and Key Management Protocol  (ISAKMP) provides a framework for authentication and key exchange, with actual authenticated keying material provided either by manual configuration with pre-shared keys,  Internet Key Exchange  (IKE and IKEv2),  Kerberized Internet Negotiation of Keys  (KINK), or IPSECKEY  DNS records .
1 comment
Read more

Advent of code 2022 day 22 part 1

  function main(input, input1) {     let grid = input.split( '\n' );     grid.shift();     // only in big input     for ( let i = 0 ; i < 100 ; i++) {         grid[i] = '                                                  ' + grid[i];     }     //console.log(grid[100])     grid = grid.map(x => x.split( '' ))     // find first left top allowed     let temppos = - 1 ;     grid[ 0 ].forEach((element, i) => {         if (temppos == - 1 && element == '.' ) {             temppos = i;         }     });     let initpos = new pos(temppos, 0 )     // console.log(initpos)     // make grid equal shape     let maxlength = 0 ;     grid.forEach(el => {         if (el.length > maxlength) {             maxlength = el.length         }     })     console.log(maxlength)     grid.forEach(el => {         if (el.length < maxlength) {             let diff = maxlength - el.length;             while (diff > 0 ) {                 di
Post a Comment
Read more