Posts

SignalR from scratch

http://www.c-sharpcorner.com/article/understanding-signalr-from-scratch/

How to export excel file with datatable

https://www.codeproject.com/Tips/344604/Export-to-EXCEL-from-Datatable-in-Csharp-Net http://www.neerajcodesolutions.com/2014/04/export-datatable-to-excel-in-aspnet-c.html

Most Important SQL Server Interview Questions and Answers

http://www.webcodeexpert.com/2017/05/most-important-sql-server-interview.html
How to replace <p> </p> in gridview rows in asp.net c# <asp:TemplateField HeaderText="Questions" SortExpression="TheQuestion"> <ItemTemplate> <asp:Label ID="lblQuestion" runat="server" Text='<%# Server.HtmlDecode(Eval("TheQuestion").ToString()) %>'></asp:Label> </ItemTemplate> <ItemStyle HorizontalAlign="Left" Width="100%" /> </asp:TemplateField>
Extract Only Numeric in C# string Retcode = Regex.Replace(Request.QueryString["code"].ToString(), "[^0-9]+", string.Empty);
Insert – save multiple checked checkbox values in SQL Server http://www.webtechminer.com/split-function-in-sql-server-to-break-comma-separated-string/
Gridview export to excel without having control like linkbutton, or anybutton(to hide columns) Frontend note: <%@ Page Title="" Language="C#" MasterPageFile="~/admin/admin.master" AutoEventWireup="true" CodeFile="CarMake.aspx.cs" Inherits="admin_CarMake" EnableEventValidation="false" %>     ----------------------------------------------------------------------------------------- Backend cs:- protected void btnExport_Click(object sender, EventArgs e) { ExporttoExcel(); } public override void VerifyRenderingInServerForm(Control control) { /* Verifies that the control is rendered */ } private void ExporttoExcel() { Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=ExistingCarData" + System.DateTime.Now.ToShortDateString() + ".xls"); Response.Charset = ""; Response.ContentType = "application/vnd.xls"; Str...