How to Export the Girdview without Paging in asp.net

       

Protected Void ExportData()
{
       Response.Clear();
        Response.Buffer = true;
        Response.ClearContent();
        Response.ClearHeaders();
        Response.Charset = "";
        string FileName = "Grid" + DateTime.Now + ".xls";
        StringWriter strwritter = new StringWriter();
        HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
        Response.Cache.SetCacheability(HttpCacheability.NoCache);
        Response.ContentType = "application/vnd.ms-excel";
        Response.AddHeader("Content-Disposition", "attachment;filename="+FileName +"");
        grdRetailData.GridLines = GridLines.Both;
        grdRetailData.Columns[1].Visible = false;
        grdRetailData.HeaderStyle.Font.Bold = true;
        grdRetailData.RenderControl(htmltextwrtter);
        grdRetailData.AllowPaging = false;
       BindData();
        Response.Write(strwritter.ToString());
        Response.End();
}

Session State 2.0 Problem connecting to SQL Server

Web config changes.
    <sessionState mode="SQLServer" allowCustomSqlDatabase="true" cookieless="false" timeout="60"
      sqlConnectionString="Data Source=PANKAJ-PC;Initial Catalog=Test;User ID=sa;Password=123654;" >
    </sessionState>

and Add State Server.:

How to Close Fancybox and Redirect to another page in asp.net and C#.

Just need to use the code.

 ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "add", "window.top.location.href ='" +RedirectUrl+ "'; parent.jQuery.fancybox.close();", true);

how to trim text box value in javascript in .Net

    // implementing a trim function for strings in javascript
            <script language="JavaScript" type="text/javascript">
            <!--
            String.prototype.trim = function () {
            return this.replace(/^\s*/, "").replace(/\s*$/, "");
           }
           </script>

  <asp:TextBox runat="server" ID="abdc" onkeyup ="OnChange(this)" onblur="ShowAvailability()" onchange="this.value=this.value.trim()"></asp:TextBox>

Date and Time formats in asp.net using C#,VB.Net | Convert date time formats

Introduction: In this article i am going to explain with example list of different date and time formats/types available in asp.net using both C# and VB.Net language.

Description: In previous related articles i explained How to Get age in years,months,days,hours and seconds from DOB in asp.net C#,Vb.Net and Formatting Date in GridView and Get current date in dd/mm/yyyy format and Date format in sql server and  How to Convert Rupees,Currency or Numbers to Words.
It is very common in asp.net application or any other application to show date and time in various formats as per application requirement. There are so many different datetime formats/type available that can be used as per application requirement.Some of them are custom date and time formats. So this example will be helpful for those who are searching for datetime formatting and converting date and time format to one format to another e.g. dd/MM/yyyy to MM/dd/yyyy and in any other.

Implementation: Let's see the different formats with example.I have listed many date time formats that will be useful for developers.

C#.Net Code to show/display list of different Date and Time formats

protected void btnDateTime_Click(object sender, EventArgs e)

    {

        Response.Write("<BR>" + DateTime.Today.ToString("dd-MM-yyyy"));  // Output : 14-08-2013

        Response.Write("<BR>" + DateTime.Today.ToString("dd/MM/yyyy"));  // Output : 14/08/2013

        Response.Write("<BR>" + DateTime.Today.ToString("dd MM yyyy"));  // Output : 14 08 2013

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR>" + DateTime.Today.ToString("dd-MM-yy"));  // Output : 14-08-13

        Response.Write("<BR>" + DateTime.Today.ToString("dd/MM/yy"));  // Output : 14/08/13

        Response.Write("<BR>" + DateTime.Today.ToString("dd MM yy"));  // Output : 14 08 13

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR>" + DateTime.Today.ToString("ddd-dd-MM-yy"));  // Output : Wed-14-08-13

        Response.Write("<BR>" + DateTime.Today.ToString("ddd/dd/MM/yy"));  // Output : Wed/14/08/13

        Response.Write("<BR>" + DateTime.Today.ToString("ddd dd MM yy"));  // Output : Wed 14 08 13

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR>" + DateTime.Today.ToString("dddd-dd-MM-yy"));  // Output : Wednesday-14-08-13

        Response.Write("<BR>" + DateTime.Today.ToString("dddd/dd/MM/yy"));  // Output : Wednesday/14/08/13

        Response.Write("<BR>" + DateTime.Today.ToString("dddd dd MM yy"));  // Output : Wednesday 14 08 13

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR>" + DateTime.Today.ToString("dd-MMM-yyyy"));  // Output : 14-Aug-2013

        Response.Write("<BR>" + DateTime.Today.ToString("dd/MMM/yyyy"));  // Output : 14/Aug/2013

        Response.Write("<BR>" + DateTime.Today.ToString("dd MMM yyyy"));  // Output : 14 Aug 2013

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR>" + DateTime.Today.ToString("dd-MMMM-yyyy"));  // Output : 14-August-2013

        Response.Write("<BR>" + DateTime.Today.ToString("dd/MMMM/yyyy"));  // Output : 14/August/2013

        Response.Write("<BR>" + DateTime.Today.ToString("dd MMMM yyyy"));  // Output : 14 August 2013

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR>" + DateTime.Today.ToString("MM-dd-yyyy"));  // Output : 08-14-2013

        Response.Write("<BR>" + DateTime.Today.ToString("MM/dd/yyyy"));  // Output : 08/14/2013

        Response.Write("<BR>" + DateTime.Today.ToString("MM dd yyyy"));  // Output : 08 14 2013

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR>" + DateTime.Today.ToString("MMM-dd-yyyy"));  // Output : Aug-14-2013

        Response.Write("<BR>" + DateTime.Today.ToString("MMM/dd/yyyy"));  // Output : Aug/14/2013

        Response.Write("<BR>" + DateTime.Today.ToString("MMM dd yyyy"));  // Output : Aug 14 2013

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR>" + DateTime.Today.ToString("yyyy-MM-dd"));  // Output : 2013-08-14

        Response.Write("<BR>" + DateTime.Today.ToString("yyyy/MM/dd"));  // Output : 2013/08/14

        Response.Write("<BR>" + DateTime.Today.ToString("yyyy MM dd"));  // Output : 2013 08 14

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy-MM-dd h:m:s"));  // Output : 2013-08-14 5:12:30

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy/MM/dd h:m:s"));  // Output : 2013/08/14 5:12:30

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy MM dd h:m:s"));  // Output : 2013 08 14 5:12:30

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));  // Output : 2013-08-14 05:12:30

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss"));  // Output : 2013/08/14 05:12:30

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy MM dd hh:mm:ss"));  // Output : 2013 08 14 05:12:30

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy-MM-dd H:m:s"));  // Output : 2013-08-14 17:12:30

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy/MM/dd H:m:s"));  // Output : 2013/08/14 17:12:30

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy MM dd H:m:s"));  // Output : 2013 08 14 17:12:30

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));  // Output : 2013-08-14 17:12:30

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));  // Output : 2013/08/14 17:12:30

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy MM dd HH:mm:ss"));  // Output : 2013 08 14 17:12:30

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss tt"));  // Output : 2013-08-14 17:12:30 PM

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss tt"));  // Output : 2013/08/14 17:12:30 PM

        Response.Write("<BR>" + DateTime.Now.ToString("yyyy MM dd HH:mm:ss tt"));  // Output : 2013 08 14 17:12:30 PM

        Response.Write("<BR/>" + "------------------------");

        DateTime now = DateTime.Now;

        Response.Write("<BR/>" + now.ToString("d"));  // Output : 14-Aug-13

        Response.Write("<BR/>" + now.ToString("D"));  // Output : Wednesday, August 14, 2013

        Response.Write("<BR/>" + now.ToString("f"));  // Output : Wednesday, August 14, 2013 5:12 PM

        Response.Write("<BR/>" + now.ToString("F"));  // Output : Wednesday, August 14, 2013 5:12:30 PM

        Response.Write("<BR/>" + now.ToString("g"));  // Output : 14-Aug-13 5:12 PM

        Response.Write("<BR/>" + now.ToString("G"));  // Output : 14-Aug-13 5:12:30 PM

        Response.Write("<BR/>" + now.ToString("m"));  // Output : August 14

        Response.Write("<BR/>" + now.ToString("M"));  // Output : August 14

        Response.Write("<BR/>" + now.ToString("o"));  // Output : 2013-08-14T17:12:30.1324811+05:30

        Response.Write("<BR/>" + now.ToString("O"));  // Output : 2013-08-14T17:12:30.1324811+05:30

        Response.Write("<BR/>" + now.ToString("s"));  // Output : 2013-08-14T17:12:30

        Response.Write("<BR/>" + now.ToString("t"));  // Output : 5:12 PM

        Response.Write("<BR/>" + now.ToString("T"));  // Output : 5:12:30 PM

        Response.Write("<BR/>" + now.ToString("u"));  // Output : 2013-08-14 17:12:30Z

        Response.Write("<BR/>" + now.ToString("U"));  // Output : Wednesday, August 14, 2013 11:42:30 AM

        Response.Write("<BR/>" + now.ToString("y"));  // Output : August, 2013

        Response.Write("<BR/>" + now.ToString("Y"));  // Output : August, 2013

        Response.Write("<BR/>" + "------------------------");

        Response.Write("<BR/>" + now.ToLongDateString());  // Output : Wednesday, August 14, 2013

        Response.Write("<BR/>" + now.ToLongTimeString());  // Output : 5:12:30 PM

        Response.Write("<BR/>" + now.ToShortDateString());  // Output : 14-Aug-13

        Response.Write("<BR/>" + now.ToShortTimeString());  // Output : 5:12 PM

        Response.Write("<BR/>" + now.ToString());  // Output : 14-Aug-13 5:12:30 PM

    }

VB.Net Code to show/display list of different Date and Time formats

Protected Sub btnDateTime_Click(sender As Object, e As System.EventArgs) HandlesbtnDateTime.Click

        Response.Write("<BR>" & DateTime.Today.ToString("dd-MM-yyyy")) ' Output : 14-08-2013

        Response.Write("<BR>" & DateTime.Today.ToString("dd/MM/yyyy")) ' Output : 14/08/2013

        Response.Write("<BR>" & DateTime.Today.ToString("dd MM yyyy")) ' Output : 14 08 2013

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR>" & DateTime.Today.ToString("dd-MM-yy")) ' Output : 14-08-13

        Response.Write("<BR>" & DateTime.Today.ToString("dd/MM/yy")) ' Output : 14/08/13

        Response.Write("<BR>" & DateTime.Today.ToString("dd MM yy")) ' Output : 14 08 13

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR>" & DateTime.Today.ToString("ddd-dd-MM-yy")) ' Output : Wed-14-08-13

        Response.Write("<BR>" & DateTime.Today.ToString("ddd/dd/MM/yy")) ' Output : Wed/14/08/13

        Response.Write("<BR>" & DateTime.Today.ToString("ddd dd MM yy")) ' Output : Wed 14 08 13

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR>" & DateTime.Today.ToString("dddd-dd-MM-yy")) ' Output : Wednesday-14-08-13

        Response.Write("<BR>" & DateTime.Today.ToString("dddd/dd/MM/yy")) ' Output : Wednesday/14/08/13

        Response.Write("<BR>" & DateTime.Today.ToString("dddd dd MM yy")) ' Output : Wednesday 14 08 13

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR>" & DateTime.Today.ToString("dd-MMM-yyyy")) ' Output : 14-Aug-2013

        Response.Write("<BR>" & DateTime.Today.ToString("dd/MMM/yyyy")) ' Output : 14/Aug/2013

        Response.Write("<BR>" & DateTime.Today.ToString("dd MMM yyyy")) ' Output : 14 Aug 2013

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR>" & DateTime.Today.ToString("dd-MMMM-yyyy")) ' Output : 14-August-2013

        Response.Write("<BR>" & DateTime.Today.ToString("dd/MMMM/yyyy")) ' Output : 14/August/2013

        Response.Write("<BR>" & DateTime.Today.ToString("dd MMMM yyyy")) ' Output : 14 August 2013

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR>" & DateTime.Today.ToString("MM-dd-yyyy")) ' Output : 08-14-2013

        Response.Write("<BR>" & DateTime.Today.ToString("MM/dd/yyyy")) ' Output : 08/14/2013

        Response.Write("<BR>" & DateTime.Today.ToString("MM dd yyyy")) ' Output : 08 14 2013

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR>" & DateTime.Today.ToString("MMM-dd-yyyy")) ' Output : Aug-14-2013

        Response.Write("<BR>" & DateTime.Today.ToString("MMM/dd/yyyy")) ' Output : Aug/14/2013

        Response.Write("<BR>" & DateTime.Today.ToString("MMM dd yyyy")) ' Output : Aug 14 2013

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR>" & DateTime.Today.ToString("yyyy-MM-dd")) ' Output : 2013-08-14

        Response.Write("<BR>" & DateTime.Today.ToString("yyyy/MM/dd")) ' Output : 2013/08/14

        Response.Write("<BR>" & DateTime.Today.ToString("yyyy MM dd")) ' Output : 2013 08 14

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy-MM-dd h:m:s")) ' Output : 2013-08-14 5:12:30

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy/MM/dd h:m:s")) ' Output : 2013/08/14 5:12:30

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy MM dd h:m:s")) ' Output : 2013 08 14 5:12:30

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")) ' Output : 2013-08-14 05:12:30

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss")) ' Output : 2013/08/14 05:12:30

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy MM dd hh:mm:ss")) ' Output : 2013 08 14 05:12:30

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy-MM-dd H:m:s")) ' Output : 2013-08-14 17:12:30

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy/MM/dd H:m:s")) ' Output : 2013/08/14 17:12:30

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy MM dd H:m:s")) ' Output : 2013 08 14 17:12:30

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")) ' Output : 2013-08-14 17:12:30

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")) ' Output : 2013/08/14 17:12:30

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy MM dd HH:mm:ss")) ' Output : 2013 08 14 17:12:30

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss tt")) ' Output : 2013-08-14 17:12:30 PM

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss tt")) ' Output : 2013/08/14 17:12:30 PM

        Response.Write("<BR>" & DateTime.Now.ToString("yyyy MM dd HH:mm:ss tt")) ' Output : 2013 08 14 17:12:30 PM

        Response.Write("<BR/>" & "------------------------")

        Dim now As DateTime = DateTime.Now

        Response.Write("<BR/>" & now.ToString("d")) ' Output : 14-Aug-13

        Response.Write("<BR/>" & now.ToString("D")) ' Output : Wednesday, August 14, 2013

        Response.Write("<BR/>" & now.ToString("f")) ' Output : Wednesday, August 14, 2013 5:12 PM

        Response.Write("<BR/>" & now.ToString("F")) ' Output : Wednesday, August 14, 2013 5:12:30 PM

        Response.Write("<BR/>" & now.ToString("g")) ' Output : 14-Aug-13 5:12 PM

        Response.Write("<BR/>" & now.ToString("G")) ' Output : 14-Aug-13 5:12:30 PM

        Response.Write("<BR/>" & now.ToString("m")) ' Output : August 14

        Response.Write("<BR/>" & now.ToString("M")) ' Output : August 14

        Response.Write("<BR/>" & now.ToString("o")) ' Output : 2013-08-14T17:12:30.1324811+05:30

        Response.Write("<BR/>" & now.ToString("O")) ' Output : 2013-08-14T17:12:30.1324811+05:30

        Response.Write("<BR/>" & now.ToString("s")) ' Output : 2013-08-14T17:12:30

        Response.Write("<BR/>" & now.ToString("t")) ' Output : 5:12 PM

        Response.Write("<BR/>" & now.ToString("T")) ' Output : 5:12:30 PM

        Response.Write("<BR/>" & now.ToString("u")) ' Output : 2013-08-14 17:12:30Z

        Response.Write("<BR/>" & now.ToString("U")) ' Output : Wednesday, August 14, 2013 11:42:30 AM

        Response.Write("<BR/>" & now.ToString("y")) ' Output : August, 2013

        Response.Write("<BR/>" & now.ToString("Y")) ' Output : August, 2013

        Response.Write("<BR/>" & "------------------------")

        Response.Write("<BR/>" & now.ToLongDateString()) ' Output : Wednesday, August 14, 2013

        Response.Write("<BR/>" & now.ToLongTimeString()) ' Output : 5:12:30 PM

        Response.Write("<BR/>" & now.ToShortDateString()) ' Output : 14-Aug-13

        Response.Write("<BR/>" & now.ToShortTimeString()) ' Output : 5:12 PM

        Response.Write("<BR/>" & now.ToString()) ' Output : 14-Aug-13 5:12:30 PM

    End Sub

Reference site: http://www.webcodeexpert.com/2013/08/date-and-time-formats-in-aspnet-using.html#.Uk6o99KBnCY

How to get IP address in Sql server.

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') [Machine Name]
   ,SERVERPROPERTY('InstanceName') AS [Instance Name]
   ,LOCAL_NET_ADDRESS AS [IP Address Of SQL Server]
   ,CLIENT_NET_ADDRESS AS [IP Address Of Client]
 FROM SYS.DM_EXEC_CONNECTIONS
 WHERE SESSION_ID = @@SPID

How to add the Progress bar when u are Uplading a Video in asp.net

Hey all,
Follow given link..
http://www.c-sharpcorner.com/uploadfile/rahul4_saxena/uploading-file-with-progress-bar/