ASP.NET Codes

Thursday, 7 February 2013

SQL : Get Date Only

SQL

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

SQL 2008

CAST(GETDATE() AS DATE)

Friday, 1 February 2013

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.

Thursday, 31 January 2013

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);

  }

Wednesday, 30 January 2013

Export Datatable

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/

Monday, 28 January 2013

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>

Sunday, 27 January 2013

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>