Delete Confirmation Box

<asp:LinkButton ID="lnkDelete" runat="server" 
CommandName="Delete" Text="Delete"
OnClientClick = "return confirm('Are you sure?')" />

Hide HyperLink if Database cell is NULL

Visible ='<%# Eval("a") == System.DbNull.Value ? False : True %>'

Upload File in VB

VB

Dim spath As String = Server.MapPath("~/foldername/")
Dim sfile As String = FileUpload1.FileName
Dim sfullpath As String = spath & "\" & sfile
Try
  FileUpload1.SaveAs(sfullpath)


Catch ex As Exception
  Label1.Text = "Failed. " & ex.Message
End Try

errors : The name ... does not exist in the current

Make sure inherits and class same name

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="office.aspx.cs" Inherits="TEST_office" %>

public partial class TEST_office : System.Web.UI.Page
{
    
}

SQL : Get Date Only

SQL

DATEADD(dd,0, DATEDIFF(dd, 0, GETDATE()))

SQL 2008

CAST(GETDATE() AS DATE)

IIS 7 Blank Image Problem

Fisrttime when using IIS 7 in Windows 2008 Server i got problem. I can not display all image. After googling I get the solution. The problem is static content not checked yet.

Get GridViewRow from Autopostback control event

Sometime we have checkbox control or other control inside gridview.
We need to do when checkbox clicked then some action affected to that row, for example getting datakey, rowindex or getting cell value.

ASPX

<asp:TemplateField>
    <ItemTemplate>
      <asp:CheckBox ID="CheckBox1" runat="server" AutoPostBack="True" 
        oncheckedchanged="CheckBox1_CheckedChanged" />
    </ItemTemplate>
</asp:TemplateField>

This sample code is getting gridviewrow from checkbox checked changed event then displaying value from another cell to a label.

C#

protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
{
  GridViewRow gvrow = ((Control)sender).Parent.Parent as GridViewRow;
  Label1.Text = gvrow.Cells[2].Text;
}

Using Naming Container

protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
  {
        GridViewRow row=(GridViewRow)(((CheckBox)sender).NamingContainer);

  }

Export Datatable

C#

public static void ExportToSpreadsheet(DataTable table, string name)
{
   HttpContext context = HttpContext.Current;
   context.Response.Clear();
   foreach (DataColumn column in table.Columns)
   {
    context.Response.Write(column.ColumnName + ";");
   }
   context.Response.Write(Environment.NewLine);
   foreach (DataRow row in table.Rows)
   {
    for (int i = 0; i < table.Columns.Count; i++)
    {
     context.Response.Write(row[i].ToString().Replace(";", string.Empty) + ";");
    }
    context.Response.Write(Environment.NewLine);
   }
   context.Response.ContentType = "text/csv";
   context.Response.AppendHeader("Content-Disposition", "attachment; filename=" + name + ".csv");
   context.Response.End();
}

JavaScript : Auto Maximize Window Script

JAVASCRIPT

<script language="JavaScript1.2">
<!--

/***********************************************
* Auto Maximize Window Script- © Dynamic Drive (www.dynamicdrive.com)
* This notice must stay intact for use
* Visit http://www.dynamicdrive.com/ for this script and 100's more.
***********************************************/

top.window.moveTo(0,0);
if (document.all) {
top.window.resizeTo(screen.availWidth,screen.availHeight);
}
else if (document.layers||document.getElementById) {
if (top.window.outerHeight<screen.availHeight||top.window.outerWidth<screen.availWidth){
top.window.outerHeight = screen.availHeight;
top.window.outerWidth = screen.availWidth;
}
}
//-->
</script>

Source : http://www.dynamicdrive.com/

Show Error Detail for 500 internal server error

Web.Config

<customErrors mode="off"/>

<system.webServer>      
        <httpErrors errorMode="Detailed" /> 
        <asp scriptErrorSentToBrowser="true"/>    
    <defaultDocument> 
      <files> 
        <remove value="default.aspx" /> 
        <add value="default.aspx" /> 
      </files> 
    </defaultDocument> 
</system.webServer>

CSS:Remove asp:Hyperlink blue border

When using asp Hyperlink with ImageUrl value. Usualy the image has blue border in browser. You can remove the blue border by CSS code below

ASPX

<head runat="server">

    <style type="text/css">

     a img { border:none; }

    </style>

</head>

Microsoft SQL Version

Microsoft SQL Server Version list :

version	Sql
515	Sql7
539	Sql2000
611	Sql2005sp1
612	Sql2005sp2
655	Sql2008sp1(dev10sp1)
	sql2008sp2
	Sql2008sp3
661	Sql2008r2
705	Sql2012(RC0)
706	Sql2012(RC1/RTM)

Refresh page periodicaly

If you want to refresh a page periodicaly use META tag like below

ASPX/HTML

<meta http-equiv="Refresh" content="300" />

Display Long Date Formatted Regarding LocalCulture

ASPX

using System.Globalization;
using System.Threading;

private void Page_Load(object sender, System.EventArgs e)
{
    Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture(Request.UserLanguages[0].ToString());
    Thread.CurrentThread.CurrentUICulture = new CultureInfo(Request.UserLanguages[0].ToString());

    lblToday.Text = Today;

    lblMessage.Text = "Culture Info Display Name " + Thread.CurrentThread.CurrentCulture.DisplayName;
}

Adding Double Quote to a string using c#

This sample is how to add "sample" (double quote is included) to a string

C#

string mystring = @""sample""

DataKey get a gridview

Question :

Using VS2010, C #, AspNet4

I principal.aspx page, contains a GridView1 with fields Id and Name, Id is the DataKey.
Select any line on the grid and open a new page called editar.aspx.

How using a button, I get the Id of the selected row to edit the page editar.aspx

Answer :
You can use hyperlinkfield to open editor.aspx

ASPX

<hyperlinkfield Text="Edit Data" DataNavigateUrlFields="ID"
DataNavigateUrlFormatString="editar.aspx?id={0} />

in editar.aspx use querystring("id") to filter the data.
It's not using selected row and datakeyname. Hyperlink only

source : http://forums.asp.net/t/1820678.aspx/1?DataKey+get+a+gridview

Redirect to UnAuthorized Page

Modify your global.asax like below :

VB

 Public Sub Application_AuthorizeRequest(ByVal sender As Object, ByVal e As EventArgs)  
 If (sender.Request.Path.ToUpper().EndsWith("LOGIN.ASPX") And sender.Request.IsAuthenticated) Then  
   sender.Response.Redirect("~/users/Unauthorized.aspx")  
 End If  
 End Sub 

When you already loged-in and want to access unauthorized page, usualy the page redirect to login.aspx again without any message that you rectricted.