I would like to export all data even image to excel from sql database to excel using asp.net.
<div class="container show-on-pc">
<asp:Button ID="btnExport" runat="server" Text="طباعة" CssClass="btn btn-primary export-button hide-on-mobile" OnClick="btnExport_Click" />
<br />
<asp:GridView ID="gvReports" runat="server" CssClass="rtl-gridview table table-striped table-bordered" AutoGenerateColumns="False" DataKeyNames="Id" OnRowDataBound="gvReports_RowDataBound" OnRowCreated="OnRowCreated" AllowPaging="True" PageSize="50" OnPageIndexChanging="gvReports_PageIndexChanging">
<PagerSettings Mode="Numeric" />
<PagerStyle CssClass="pagination-container" />
<Columns>
<asp:TemplateField>
<HeaderTemplate>
<asp:CheckBox ID="chkAll" runat="server" AutoPostBack="true" OnCheckedChanged="chkAll_CheckedChanged" Width="5px" />
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="م">
<HeaderStyle HorizontalAlign="Right" />
<ItemTemplate>
<asp:Label ID="lblRowNumber" runat="server" Text="<%# Container.DataItemIndex + 1 %>" ></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="الاسم">
<HeaderTemplate>
<asp:Label ID="lblHeaderName" runat="server" Text="الاسم"></asp:Label>
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="lblName" runat="server" Text='<%# Eval("Name") %>'></asp:Label>
<br />
<asp:Label ID="abcivil" runat="server" Text='<%# Eval("CivilId") %>'></asp:Label>
<br />
<asp:Label ID="mobiletxt" Text='<%# Eval("PhoneNumber") %>' runat="server" />
<br />
<asp:Button ID="Buttmob" runat="server" Text="WhatsApp" Font-Bold="True" BackColor="Lime" OnClientClick='<%# "openWhatsApp(\"" + Eval("PhoneNumber") + "\"); return false;" %>' Visible='<%# !string.IsNullOrEmpty(Eval("PhoneNumber").ToString()) %>' CssClass="btn btn-success" ForeColor="Black" Height="30px" Width="100px" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Right" VerticalAlign="Middle" />
</asp:TemplateField>
<asp:TemplateField HeaderText="تاريخ الطلب">
<ItemTemplate>
<%# GetFormattedDateTime(Eval("date")) %>
</ItemTemplate>
<ItemStyle HorizontalAlign="Right" VerticalAlign="Middle" />
</asp:TemplateField>
<asp:TemplateField HeaderText="الادارة">
<ItemTemplate>
<asp:Label ID="abstates" runat="server" Text='<%# Eval("States") %>'></asp:Label>
<br />
<asp:Label ID="abcites" runat="server" Text='<%# Eval("Cities") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Right" VerticalAlign="Middle" Width="200px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="التخصص">
<ItemTemplate>
<asp:Label ID="JobTitle" runat="server" Text='<%# Eval("JobTitle") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="200px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="الجامعة / الدولة">
<ItemTemplate>
<asp:Label ID="UniversityName" runat="server" Text='<%# Eval("UniversityName") %>'></asp:Label>
<br />
<asp:Label ID="CountryName" runat="server" Text='<%# Eval("CountryName") %>' ForeColor="Red"></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="200px" />
</asp:TemplateField>
<asp:TemplateField HeaderText="المرفقات">
<ItemTemplate>
<asp:LinkButton ID="lnkDownload1" runat="server" CommandArgument='<%# Eval("Id") %>' Text="المؤهل العلمي" OnClick="lnkDownload1_Click" CssClass="btn btn-primary"></asp:LinkButton>
<br />
<asp:LinkButton ID="lnkDownload2" runat="server" CommandArgument='<%# Eval("Id") %>' Text="معادلة المؤهل من التعليم العالي" OnClick="lnkDownload2_Click" CssClass="btn btn-secondary"></asp:LinkButton>
</ItemTemplate>
<ItemStyle HorizontalAlign="Right" VerticalAlign="Middle" />
</asp:TemplateField>
<asp:TemplateField HeaderText="الحالة">
<HeaderTemplate>
<asp:DropDownList ID="ddlStatusFilter" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlStatusFilter_SelectedIndexChanged">
<asp:ListItem Value="All">الكل</asp:ListItem>
<asp:ListItem Value="Approved">معتمد</asp:ListItem>
<asp:ListItem Value="Rejected">مرفوض</asp:ListItem>
</asp:DropDownList>
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="lblStatus" runat="server" Text='<%# TranslateStatus(Eval("Status").ToString()) %>' CssClass='<%# GetStatusCssClass(Eval("Status").ToString()) %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
</asp:TemplateField>
<asp:TemplateField HeaderText="تحديث الحالة">
<ItemTemplate>
<asp:DropDownList ID="ddlStatus" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlStatus_SelectedIndexChanged">
<asp:ListItem>تحديد الاعتماد</asp:ListItem>
<asp:ListItem Value="Pending">إسترجاع</asp:ListItem>
<asp:ListItem Value="Approved">معتمد</asp:ListItem>
<asp:ListItem Value="Rejected">مرفوض</asp:ListItem>
<asp:ListItem Value="Delete">حذف</asp:ListItem>
</asp:DropDownList>
<br />
<asp:Label ID="lblLastUpdatedBy" runat="server" Text='<%# " بواسطة: " + Eval("LastUpdatedBy").ToString() %>' CssClass="last-updated-by" Font-Size="Small" ForeColor="Red"></asp:Label>
<br />
<asp:Label ID="Label1" runat="server" Text='<%# Eval("LastUpdatedDate") != DBNull.Value ? "تاريخ: " + Convert.ToDateTime(Eval("LastUpdatedDate")).ToString("dd/MM/yyyy h:mm") : "تاريخ: N/A" %>' CssClass="last-updated-by" Font-Size="Small"></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Right" VerticalAlign="Middle" />
</asp:TemplateField>
</Columns>
<RowStyle Font-Bold="True" Font-Names="Arial" Font-Size="12pt" />
</asp:GridView>
</div>
<br />
<div class="mobile-view">
<!-- Repeater for Mobile -->
<asp:Repeater ID="rptMobileView" runat="server">
<ItemTemplate>
<div class="card rtl">
<h4>م: <%# Container.ItemIndex + 1 %></h4>
<p><strong>الاسم:</strong> <%# Eval("Name") %></p>
<p><strong>تاريخ الطلب:</strong> <%# Convert.ToDateTime(Eval("date")).ToString("dddd dd/MM/yyyy h:mm tt") %></p>
<p><strong>الملف / المدنى:</strong> <%# Eval("FileId") %>, <%# Eval("CivilId") %></p>
<p><strong>الادارة:</strong> <%# Eval("States") %>, <%# Eval("Cities") %></p>
<p><strong>نوع الطلب:</strong> <%# Eval("ordername") %></p>
<p><strong>الحالة:</strong> <span class='<%# GetStatusCssClass(Eval("Status").ToString()) %>'><%# TranslateStatus(Eval("Status").ToString()) %></span></p>
<p><strong>بواسطة:</strong> <%# Eval("LastUpdatedBy").ToString() %></p>
<p><strong>تاريخ:</strong> <%# Eval("LastUpdatedDate") != DBNull.Value ? Convert.ToDateTime(Eval("LastUpdatedDate")).ToString("dd/MM/yyyy h:mm") : "N/A" %></p>
<asp:DropDownList ID="ddlMobileStatus" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlMobileStatus_SelectedIndexChanged" Font-Bold="True" Font-Size="Larger">
<asp:ListItem>تحديد الاعتماد</asp:ListItem>
<asp:ListItem Value="Pending">أسترجاع</asp:ListItem>
<asp:ListItem Value="Approved">معتمد</asp:ListItem>
<asp:ListItem Value="Rejected">مرفوض</asp:ListItem>
<asp:ListItem Value="Delete">حذف</asp:ListItem>
</asp:DropDownList>
<asp:HiddenField ID="hfId" runat="server" Value='<%# Eval("Id") %>' />
<asp:LinkButton ID="lnkMobileDownload1" runat="server" CommandArgument='<%# Eval("Id") %>' Text="المؤهل العلمي" OnClick="lnkDownload1_Click" CssClass="btn btn-primary"></asp:LinkButton>
<asp:LinkButton ID="lnkMobileDownload2" runat="server" CommandArgument='<%# Eval("Id") %>' Text="معادلة المؤهل من التعليم العالي" OnClick="lnkDownload2_Click" CssClass="btn btn-secondary"></asp:LinkButton>
<asp:Button ID="btnWhatsApp" runat="server" Text="WhatsApp" OnClientClick='<%# "openWhatsApp(\"" + Eval("PhoneNumber") + "\"); return false;" %>' class="btn btn-success" />
</div>
</ItemTemplate>
</asp:Repeater>
</div>
</asp:Content>
My Connection
<connectionStrings>
<add name="cmConnectionString" connectionString="Data Source=kan01;Initial Catalog=cm;Persist Security Info=True;User ID=sa;Password=123" providerName="System.Data.SqlClient"/>
</connectionStrings>
database name " cm
table in sql : Confirmationmove
TABLE [dbo].[Confirmationmove](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](max) NULL,
[CivilId] [nvarchar](max) NULL,
[FileId] [nvarchar](max) NULL,
[Job] [nvarchar](max) NULL,
[States] [nvarchar](max) NULL,
[Cities] [nvarchar](max) NULL,
[Eldarajah] [nvarchar](max) NULL,
[FilePath] [varbinary](max) NULL,
[PhoneNumber] [nvarchar](max) NULL,
[Notes] [nvarchar](max) NULL,
[FileContent] [varbinary](max) NULL,
[FileName] [nvarchar](max) NULL,
[date] [datetime] NULL,
[ordername] [nvarchar](max) NULL,
[Status] [nvarchar](max) NULL,
[LastUpdatedBy] [nvarchar](max) NULL,
[LastUpdatedDate] [datetime] NULL,
[Nameop] [nvarchar](max) NULL,
[JobTitle] [nvarchar](max) NULL,
[UniversityName] [nvarchar](max) NULL,
[CountryName] [nvarchar](max) NULL,
[EquivalencyFileName] [nvarchar](max) NULL,
[EquivalencyFileContent] [varbinary](max) NULL,
CONSTRAINT [PK__Confirmationmove__Id] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO