ASP.NET

<pre>string URL = "http://myserver/ReportServer/Pages/ReportViewer.aspx?%2fbills%2fISU_PDF_GEN_APT&rs:Command=Render";
          string Command = "Render";
          string Format = "PDF";
          //We can get values of these parameters from Request object.
          string Contract_account_number = AccountNumber;
          URL = URL + "&rs:Command=" + Command + "&rs:Format=" + Format + "&Contract_Account_Number=" + Contract_account_number;
           System.Net.HttpWebRequest Req = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(URL);
          Req.Credentials = System.Net.CredentialCache.DefaultCredentials;
          Req.UseDefaultCredentials = true;
          Req.Method = "GET";
          System.Net.WebResponse objResponse = Req.GetResponse();
          System.IO.Stream stream = objResponse.GetResponseStream();
          var document = GenericMethods.StreamToByteArray(stream);
          Response.AddHeader("Content-type", "application/octet-stream");
          Response.AddHeader("Content-Disposition", "attachment; filename=" + AccountNumber + ".pdf");
          Response.BinaryWrite(document);
          Response.Flush();
          Response.End();</pre>

string lbText = ((LinkButton)grvSpeakers.HeaderRow.Cells[i].Controls[0]).Text;

protected void OnSorting(object sender, GridViewSortEventArgs e)
{
    string SortDir = string.Empty;
    DataTable dt = new DataTable();
    dt = ViewState["tables"] as DataTable;
    {
        if (SortDirection == SortDirection.Ascending)
        {
            SortDirection = SortDirection.Descending;
            SortDir = "Desc";
        }
        else
        {
            SortDirection = SortDirection.Ascending;
            SortDir = "Asc";
        }
        DataView sortedView = new DataView(dt);
        sortedView.Sort = string.Format("{0} {1}", e.SortExpression, SortDir);
        grvSpeakers.DataSource = sortedView;
        grvSpeakers.DataBind();
        for (int i = 0; i < grvSpeakers.Columns.Count; i++)
        {
            string lbText = ((LinkButton)grvSpeakers.HeaderRow.Cells[i].Controls[0]).Text;
            if (lbText == e.SortExpression)
            {
                TableCell tableCell = grvSpeakers.HeaderRow.Cells[i];
                System.Web.UI.WebControls.Image img = new System.Web.UI.WebControls.Image();
                img.ImageUrl = (SortDir == "Asc") ? "~/Images/down_arrow.png" : "~/Images/up_arrow.png";
                tableCell.Controls.Add(new LiteralControl(" "));
                tableCell.Controls.Add(img);
            }
        }
    }
}

SortExpression="SpeakerName"

fail: Microsoft.AspNetCore.SpaServices[0]
      <s> [webpack.Progress] 25% building 32/34 modules 2 active C:\Users\jkirk\source\repos\jkirkerx\jkirkerx\ClientApp\node_modules\babel-loader\lib\index.js??ref--7-0!C:\Users\jkirk\source\repos\jkirkerx\jkirkerx\ClientApp\node_modules\@angular-devkit\build-angular\node_modules\webpack\hot\log.js

<asp:GridView ID="grdbiddingreport" ShowHeader="true" runat="server" Width="100%" ShowHeaderWhenEmpty="true" class="table table-condensed no-more-tables"
                                                   AutoGenerateColumns="false" EmptyDataText="No Data Available..." AllowSorting="true" OnSorting="grdbiddingreport_Sorting" OnRowCreated="grdbiddingreport_RowCreated" AllowPaging="true" AllowCustomPaging="true" OnPageIndexChanging="grddcustomer_PageIndexChanging">
                                                   <PagerSettings Mode="NumericFirstLast" FirstPageText="First" LastPageText="Last" NextPageText="Next" PreviousPageText="Previous" />
                                                   <PagerStyle HorizontalAlign="Right" CssClass="pagin" />
                                                   <Columns>
                                                       <asp:TemplateField HeaderStyle-Width="9%" HeaderText="Bidding ID" HeaderStyle-CssClass="gridcolor" HeaderStyle-ForeColor="White" SortExpression="BiddingNo">
                                                           <ItemTemplate>
                                                               <asp:Label ID="lblBiddingid" runat="server" Text='<%# Eval("BiddingID")%>' Visible="false"></asp:Label>
                                                               <asp:Label ID="lblBiddingno" runat="server" Text='<%# Eval("BiddingNo")%>'></asp:Label>
                                                           </ItemTemplate>

                                                       </asp:TemplateField>

                                                       <asp:TemplateField HeaderText="Customer Name" HeaderStyle-Width="12%" HeaderStyle-CssClass="gridcolor" HeaderStyle-ForeColor="White" SortExpression="CUstomerName">
                                                           <ItemTemplate>
                                                               <asp:Label ID="lblcustomername" runat="server" Text='<%# Eval("CUstomerName")%>'></asp:Label>
                                                           </ItemTemplate>

                                                       </asp:TemplateField>

                                                       <asp:TemplateField HeaderStyle-Width="8%" HeaderText="Date" HeaderStyle-CssClass="gridcolor" HeaderStyle-ForeColor="White" SortExpression="BidDate">
                                                           <ItemTemplate>
                                                               <asp:Label ID="lbldate" runat="server" Text='<%# Eval("BidDate","{0:MM/dd/yyyy}")%>'></asp:Label>
                                                           </ItemTemplate>

                                                       </asp:TemplateField>


                                                       <asp:TemplateField HeaderStyle-Width="10%" HeaderText="Total Cost" HeaderStyle-CssClass="gridcolor" HeaderStyle-ForeColor="White" SortExpression="BidPriceAmount">
                                                           <ItemTemplate>
                                                               <asp:Label ID="lbltotalcost" runat="server" Text='<%# Eval("BidPriceAmount","{0:N2}")%>'></asp:Label>
                                                           </ItemTemplate>

                                                       </asp:TemplateField>
                                                       <asp:TemplateField HeaderText="Created By" HeaderStyle-Width="12%" HeaderStyle-CssClass="gridcolor" HeaderStyle-ForeColor="White" SortExpression="Createdby">
                                                           <ItemTemplate>
                                                               <asp:Label ID="lblcreatedby" runat="server"
                                                                   Text='<%# Eval("Createdby")%>'></asp:Label>
                                                           </ItemTemplate>
                                                       </asp:TemplateField>
                                                       <asp:TemplateField HeaderStyle-Width="20%" HeaderStyle-CssClass="gridcolor">
                                                           <ItemTemplate>
                                                               <asp:Button ID="BtnProposal" runat="server" Font-Size="Smaller" ToolTip="Get Proposal" OnClick="BtnProposal_Click" Text="Get Proposal" CssClass="btn" target="_blank" />
                                                               <asp:Button ID="Btncontract" runat="server" Font-Size="Smaller" ToolTip="Contract" OnClick="Btncontract_Click" Text="Contract" CssClass="btn" target="_blank" />
                                                               <asp:Button ID="Btnspecs" runat="server" Font-Size="Smaller" ToolTip="Specs" OnClick="Btnspecs_Click" Text="Specs" CssClass="btn" target="_blank" />
                                                           </ItemTemplate>
                                                       </asp:TemplateField>
                                                       <%--<asp:TemplateField HeaderStyle-Width="10%" HeaderStyle-CssClass="gridcolor">
                                                           <ItemTemplate>
                                                               <asp:LinkButton ID="LinkButton1" OnClick="LinkButton1_Click" runat="server"><span style="font-size:15px;font-weight:bold">FINANCIAL SUMMARY</span></asp:LinkButton>
                                                           </ItemTemplate>
                                                       </asp:TemplateField>--%>
                                                       <asp:TemplateField HeaderStyle-Width="10%" HeaderText="Action" HeaderStyle-CssClass="gridcolor">
                                                           <ItemTemplate>
                                                               <%--<asp:ImageButton ID="btnview" runat="server" ToolTip="View" ImageUrl="~/images/view.jpg" Width="20px" Height="20px" />  --%>
                                                                       <asp:ImageButton ID="btnedit" runat="server" ToolTip="Edit" ImageUrl="~/images/Edit.png" Width="20px" Height="20px" />  
                                                                       <asp:ImageButton ID="btndelete" runat="server" CommandArgument='<%# Eval("BiddingID")%>' ToolTip="Delete" OnClientClick="return confirm('Do you want to delete?')" ImageUrl="~/images/delete.png" Width="20px" Height="20px" />
                                                           </ItemTemplate>
                                                       </asp:TemplateField>
                                                   </Columns>
                                               </asp:GridView>

Quote:

First for companies like Facebook, YouTube, Instagram and
other companies' database processing to report SQL Server
The communication line is given to our web server
User information is available on this server by
user information to access database data or fetch user-related files.
We get to the point where the user posts the files every day
we store On the database of a computer in the internal network
that has a hard drive with a raid strip.
There is a Windows service on this computer whose job is to
distribute the database table data on computers within the network
up to 100 computers for storage and the computer ip stores the
storage in the table of a computer that is to be extracted.
To identify a suitable computer for distributing the file on it,
it looks at the active IP table and, for example,
if there are 10 active computers,
stores it on one of the ten to be taken And returns the IP
to store the record with the ID on the database of that particular computer.
Now you can use the server link to report or obtain files

The id of the file is stored on a table with ip of computer that stored on back to the server and store
on the on table that inner join with table of users

Now, when the user logs in, his data will be accessible.
Having the IP address of the link server and the ID of
the file storage location, the report can be get with dynamic queries
Microsoft sql server and the speed of getting files depends
on how many of network computers

Windows service must clear the data from its table after saving the data on
the SQL Server database to always serve the file senders with