Exploreasp

Ajax CalendarExtender displaying at wrong position in Chrome

2014-08-25T15:09:00.000+05:30

function onCalendarShown(sender, args) {

// Get Image that was clicked to open calendar

var calendarImage = $get('<%=txtDate.ClientID %>');

// Set new calendar position

sender._popupDiv.parentElement.style.top = calendarImage.offsetTop + calendarImage.height + 'px';

sender._popupDiv.parentElement.style.left = calendarImage.offsetLeft + 'px';

}

</script>

...............................................................................

<asp:TextBox ID="txtDate CssClass="textboxstyledatetime" runat="server"></asp:TextBox>

<ajaxToolkit:CalendarExtender ID="CalendarExtender1" Format="dd/MM/yyyy" runat="server"

PopupButtonID="ibtnCalendar" TargetControlID="txtDate" OnClientShown="onCalendarShown"> </ajaxToolkit:CalendarExtender>

string was not recognized as a valid datetime in Asp.Net

2012-11-01T18:39:00.000+05:30

DateTime.ParseExact which parses a date that exactly matches a format you supply.

string date1 = "12/29/2011";

DateTime date2 = DateTime.ParseExact(date1, "MM/dd/yyyy", null);

null means the current culture.

using System.Globalization;

date2 = DateTime.ParseExact(date1, "MM/dd/yyyy HH:mm:ss", CultureInfo.InvariantCulture);

Email Binding in Asp.Net GridView

2012-10-20T15:25:00.000+05:30

<asp:TemplateField HeaderText="Email">

<asp:HyperLink runat="server" ID="HyperLink1" NavigateUrl='<%# string.Format("mailto:{0}", Eval("Email")) %>'

Text='<%# Eval("Email") %>' />

</ItemTemplate>

</asp:TemplateField>

Maxlength of Multilne Textbox in ASP.Net

2012-10-02T16:09:00.000+05:30

function textboxMultilineMaxNumber(txt, maxLen)

{

try {

if ((txt.value.length) > (maxLen-1 ))

return false;

}

catch (e)

{

}

</script>

<asp:TextBox ID="TextBox1" runat="server" Width="200px" TextMode="MultiLine" Height="100px" onkeypress="return textboxMultilineMaxNumber(this,5)"></asp:TextBox>

Disable Cut, Copy & Paste in ASP.Net textbox

2012-10-02T15:50:00.002+05:30

<asp:TextBox ID="TextBox1" runat="server" oncopy="return false" onpaste="return false"

oncut="return false"></asp:TextBox>

Generate random file names in Asp.net

2012-03-19T17:45:00.002+05:30

//Random FileName with Random Extension

string fileName = System.IO.Path.GetRandomFileName();

//Random FileName without Random Extension

string fileNameWithoutExtension = System.IO.Path.GetFileNameWithoutExtension(System.IO.Path.GetRandomFileName());

Browser Detection in ASP.NET

2012-01-05T14:48:00.002+05:30

System.Web.HttpBrowserCapabilities browser = Request.Browser;

string name = browser.Browser;

float version = (float)(browser.MajorVersion + browser.MinorVersion);

if ((name == "IE" && version == 6))

{

}

Accordian headers all collapsed initially on page load

2011-12-10T19:44:00.001+05:30

Accordion1.SelectedIndex = -1;

Accordion1.RequireOpenedPane = false;

Expand All / Collapse All panes in Ajax Accordion Extender

2011-12-10T19:40:00.001+05:30

There is no direct way to Expand/Collapse all panes in Accordion Extender. Using following java script, Accordion can be Expand/Collapse all panes in one click.

function pageLoad()

{

collapseAll();

}

function collapseAll()

{

var behavior = $get("<%=UserAccordion.ClientID%>").AccordionBehavior;

for (var i = 0; i < behavior._panes.length; i++) {

behavior.get_Pane(i).content.style.display = 'none';

behavior.get_Pane(i).content.height = 0;

behavior.get_Pane(i).content.style.height = '0px';

}

behavior.set_SelectedIndex(-1);

}

function expandall()

{

var behavior = $get("<%=UserAccordion.ClientID%>").AccordionBehavior;

for (var i = 0; i < behavior._panes.length; i++) {

behavior.get_Pane(i).content.style.display = 'block';

behavior.get_Pane(i).content.height = behavior.get_Pane(i).content.scrollHeight;

behavior.get_Pane(i).content.style.height = behavior.get_Pane(i).content.scrollHeight + 'px';

}

</script>

Mathematical Functions in C#

2011-10-18T13:03:00.001+05:30

Popular mathematical functions are summarized in the following table. Note that certain functions do not require the Math. prefix.

Function Use
Math.Abs() Returns the absolute value.

Math.Abs(-10) returns 10.

Math.Ceiling() Returns an integer that is greater than or equal to a number.

Math.Ceiling(5.333) returns 6.

Fix() Returns the integer portion of a number.

Fix(5.3333) returns 5.

Math.Floor() Returns an integer that is less than or equal to a number.

Fix(5.3333) returns 5.

Int() Returns the integer portion of a number.

Int(5.3333) returns 5.

Math.Max() Returns the larger of two numbers.

Math.Max(5,7) returns 7.

Math.Min() Returns the smaller of two numbers.

Math.Min(5,7) returns 5.

Math.Pow() Returns a number raised to a power.

Math.Pow(12,2) returns 144.

Rnd() Returns a random number between 0 and 1. Used in conjunction with Randomizestatement to initialize the random number generator.

Math.Round() Rounds a number to a specified number of decimal places. Rounds up on .5.

Math.Round(1.1234567,5) returns 1.12346.

Math.Sign() Returns the sign of a number. Returns -1 if negative and 1 if positive.

Math.Sign(-5) returns -1.

Math.Sqrt() Returns the square root of a positive number.

Math.Sqrt(144) returns 12.

How to Convert DataReader to DataTable

2011-10-09T17:14:00.001+05:30

string connString = ConfigurationManager.ConnectionStrings["NorthwindConn"].ConnectionString;

SqlConnection conn = new SqlConnection(connString);

string query = "SELECT * FROM Customers";

SqlCommand cmd = new SqlCommand(query, conn);

conn.Open();

SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

DataTable dt = new DataTable();

dt.Load(dr);

conn.Close();

how to query sql server database size

2011-10-05T20:43:00.000+05:30

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.SqlClient;

using System.Data;

namespace ConsoleApplication2

{

class Program

{

static void Main(string[] args)

{

string strCount;

SqlConnection Conn = new SqlConnection

("Data Source=W3INTECH-PC\\sqlexpress;Initial Catalog=aliintDatb;Integrated Security=True;");

SqlCommand testCMD = new SqlCommand

("sp_spaceused", Conn);

testCMD.CommandType = CommandType.StoredProcedure;

Conn.Open();

SqlDataReader reader = testCMD.ExecuteReader();

if (reader.HasRows)

{

while (reader.Read())

{

Console.WriteLine("Name: " + reader["database_name"]);

Console.WriteLine("Size: " + reader["database_size"]);

}

Console.ReadLine();

}

Convert HTML Table to DataSet in Asp.Net

2011-10-04T20:33:00.001+05:30

private DataSet ConvertHTMLTablesToDataSet(string HTML)

{

// Declarations

DataSet ds = new DataSet();

DataTable dt = null;

DataRow dr = null;

DataColumn dc = null;

string TableExpression = "<table[^>]*>(.*?)</table>";

string HeaderExpression = "<th[^>]*>(.*?)</th>";

string RowExpression = "<tr[^>]*>(.*?)</tr>";

string ColumnExpression = "<td[^>]*>(.*?)</td>";

bool HeadersExist = false;

int iCurrentColumn = 0;

int iCurrentRow = 0;

// Get a match for all the tables in the HTML

MatchCollection Tables = Regex.Matches(HTML, TableExpression, RegexOptions.Multiline | RegexOptions.Singleline | RegexOptions.IgnoreCase);

// Loop through each table element

foreach (Match Table in Tables)

{

// Reset the current row counter and the header flag

iCurrentRow = 0;

HeadersExist = false;

// Add a new table to the DataSet

dt = new DataTable();

//Create the relevant amount of columns for this table (use the headers if they exist, otherwise use default names)

if (Table.Value.Contains("<th"))

{

// Set the HeadersExist flag

HeadersExist = true;

// Get a match for all the rows in the table

MatchCollection Headers = Regex.Matches(Table.Value, HeaderExpression, RegexOptions.Multiline | RegexOptions.Singleline | RegexOptions.IgnoreCase);

// Loop through each header element

foreach (Match Header in Headers)

{

dt.Columns.Add(Header.Groups[1].ToString());

}

else

{

for (int iColumns = 1; iColumns <= Regex.Matches(Regex.Matches(Regex.Matches(Table.Value, TableExpression, RegexOptions.Multiline | RegexOptions.Singleline | RegexOptions.IgnoreCase)[0].ToString(), RowExpression, RegexOptions.Multiline | RegexOptions.Singleline | RegexOptions.IgnoreCase)[0].ToString(), ColumnExpression, RegexOptions.Multiline | RegexOptions.Singleline | RegexOptions.IgnoreCase).Count; iColumns++)

{

dt.Columns.Add("Column " + iColumns);

}

//Get a match for all the rows in the table

MatchCollection Rows = Regex.Matches(Table.Value, RowExpression, RegexOptions.Multiline | RegexOptions.Singleline | RegexOptions.IgnoreCase);

// Loop through each row element

foreach (Match Row in Rows)

{

// Only loop through the row if it isn't a header row

if (!(iCurrentRow == 0 && HeadersExist))

{

// Create a new row and reset the current column counter

dr = dt.NewRow();

iCurrentColumn = 0;

// Get a match for all the columns in the row

MatchCollection Columns = Regex.Matches(Row.Value, ColumnExpression, RegexOptions.Multiline | RegexOptions.Singleline | RegexOptions.IgnoreCase);

// Loop through each column element

foreach (Match Column in Columns)

{

// Add the value to the DataRow

dr[iCurrentColumn] = Column.Groups[1].ToString();

// Increase the current column

iCurrentColumn++;

}

// Add the DataRow to the DataTable

dt.Rows.Add(dr);

}

// Increase the current row counter

iCurrentRow++;

}

// Add the DataTable to the DataSet

ds.Tables.Add(dt);

}

return ds;

}

Remove html tags from string in Asp.net

2011-07-23T19:28:00.004+05:30

public static string StripHtml(string html, bool allowHarmlessTags)

{

if (html == null || html == string.Empty)

return string.Empty;

if (allowHarmlessTags)

{

return System.Text.RegularExpressions.Regex.Replace(html, "", string.Empty);

}

return System.Text.RegularExpressions.Regex.Replace(html, "<[^>]*>", string.Empty);

}

Email Validation in ASP.net

2011-07-19T18:37:00.001+05:30

protected bool EvaluateIsValid()

{

string val = txtEmail.Text;

string pattern = @"^[a-z][a-z|0-9|]*([_][a-z|0-9]+)*([.][a-z|0-9]+([_][a-z|0-9]+)*)?@[a-z][a-z|0-9|]*\.([a-z][a-z|0-9]*(\.[a-z][a-z|0-9]*)?)$";

Match match = Regex.Match(val.Trim(), pattern, RegexOptions.IgnoreCase);

if (match.Success)

return true;

else

return false;

}

Disable copy paste in asp.net textbox

2011-07-14T15:10:00.000+05:30

<asp:TextBox ID="TextBox1" runat="server"

oncopy="return false"

onpaste="return false"

oncut="return false">

</asp:TextBox>

Disable Right Click -Asp.Net

2011-07-14T14:29:00.000+05:30

// on right click appear this message

var DisplayMsg="Right Click Disabled";

//return message

function clickBYIE()

{

if(document.all)

{

alert(DisplayMsg);

return false;

}

//return message

function clickBYNS(e)

{

if (document.layers||(document.getElementById&&!document.all))

{

if (e.which==2||e.which==3)

{

alert(DisplayMsg);

return false;

}

//set the function as per browser

if (document.layers)

{

document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickBYNS;

}

else

{

document.onmouseup=clickBYNS;document.oncontextmenu=clickBYIE;

}

//disabled the right click on the browser

document.oncontextmenu=new Function("return false")

</script>

Set Default Button in ASP.NET

2011-07-02T16:53:00.000+05:30

<asp:TextBox ID="Textbox1" runat="server" />

<asp:TextBox ID="Textbox2" runat="server" />

<asp:Button ID="Button1" runat="server" Text="Submit" />

<asp:Button ID="Button2" runat="server" Text="Cancel" />

</form>

Embed youtube video without youtube link

2011-06-23T02:34:00.000+05:30

How to check the value in querystring is number or not in Asp.Net

2011-06-19T19:33:00.000+05:30

if (!String.IsNullOrEmpty(Request.QueryString["Id"]))

{

string Id = Request.QueryString["Id"].ToString();

if (Id != "")

{

int numeber = 0;

if (int.TryParse(Id, out number))

{

//code

}

else

{

Server.Transfer("Error.aspx");

}

else

{

Server.Transfer("Error.aspx");

}

ASP.NET GridView And Conditional Images

2011-06-01T20:03:00.000+05:30

Depending upon a value in the data source, we can conditionally display images in GridView columns. For example, the following TemplateField declaration conditionally displays approved.gif or unapproved.gif based on IsApproved flag in the DataSet that the GridView is bound to:

<asp:TemplateField HeaderText="Approval Status">

<asp:Image ID="ApprovalImage" runat="server" ImageUrl='<%# "~/Images/" + (((bool)Eval("IsApproved") == false) ? "Unapproved.gif" : "Approved.gif") %>' />

</ItemTemplate>

</asp:TemplateField>

Convert String into Pascal Case in C#

2011-05-01T18:33:00.000+05:30

private string ConvertToPascal(string strFileName)

{

if (strFileName == null) throw new ArgumentNullException("strException", "Null is not a valid string!");

if (strFileName.Length == 0) return strFileName;

string[] strWords = strFileName.Split(' ');

for (int i = 0; i < strWords.Length; i++)

{

if (strWords[i].Length > 0)

{

string strWord = strWords[i];

char strFirstLetter = char.ToUpper(strWord[0]);

strWords[i] = strFirstLetter + strWord.Substring(1);

}

return string.Join(" ", strWords);

}

Validator controls taking up space in Asp.Net

2011-04-26T16:30:00.000+05:30

If you are using the built-in ASP.net Validation Controls such as the RequiredFieldValidator or the RegularExpressionValidator to validate user input, as you should be, you may have notices that in your UI even though they are not active (hidden) they are still taking up space in your layout and may be throwing things off.
It turns out that the Validation Controls in ASP.net have an attribute you can add to their markup called ‘Display’. By default if you do not add and set this attribute in your control’s markup it will default to ‘Static’. There are 2 other options available to you ‘None’ and ‘Dynamic’. It is due to the ‘Static’ option that you are seeing it take up space even when it is not active.
To fix the problem set the ‘Display’ attribute in the control’s markup to the ‘Dynamic’ value and poof, the space is no longer taken up when inactive and is dynamically added when active.
Here is what each option actually does to the Validator’s HTML markup when set.

Static (Default): Causes the required space for the error message to be taken up in the UI’s HTML no matter if it is inactive or active.

<span style="color: Red; visibility: hidden;">Invalid</span>

Dynamic: Causing the element to not display at all, but when activated the space needed to display the error is reclaimed and UI elements are shifted to make room.

<span style="color: Red; display: none;">Invalid</span>

None: Causing the element to not display at all even when activated, the error message still displays in a Validation Summary if provided but nothing will appear in the UI where the Validator was originally positioned.

Maintaining the Scroll Position after post back in ASP.NET

2011-04-24T15:32:00.000+05:30

Some of us may come across this situation, ie maintaining the scroll position after the page is post back. This is very useful when we have a gridview or data repeater or some thing like that, which shows a large amount of data and a button controls is place below page, so that user has to scroll a bit to reach there. After clicking on the button, the page is posted back, but the page is scrolled to top.
If you want to maintain the scroll position, add this attribute on the @page directive

<%@ Page Language="C#" MaintainScrollPositionOnPostback="true"

ERROR: A potentially dangerous Request.Form value was detected from the client in ASP.NET

2011-04-24T15:05:00.000+05:30

This occurs when we try to post html code. The server will validate the postdata, if it find that its an HTML code, error something similar to this is shown. This actually helps to prevent running malicious script. If you really want to post the html content add this to the page directive validateRequest=”false”.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Login" ValidateRequest="false" %>

You can also do this from the web.config like this