Tuesday, September 30, 2008

how to omit some files from form authentication

<location path="Default.aspx">
<system.web>
<authorization>
<allow users="*" />
</authorization>
</system.web>
</location>

If u want to omit more than one files from form authentication then put all the file within on
common folder and replace the <location path="Default.aspx">

<location path="public/">, here public is the name of the folder

<location path="public/">
<system.web>
<authorization>
<allow users="*" />
</authorization>
</system.web>
</location>

Friday, September 26, 2008

How To Replace Text With Image In Custom DataGrid Edit,Delete,Cancel



<asp:EditCommandColumn HeaderText="Edit" HeaderStyle-BackColor="#efeded"


CancelText="<img src='Images/icon_cancel.gif' alt='Cancel' style='border:0px' />"


EditText="<img src='Images/icon_edit.gif' style='border:0px' alt='Edit'/>"


UpdateText="<img src='Images/icon_save.gif' alt='Update' style='border:0px' />">


</asp:EditCommandColumn>


Friday, September 19, 2008

on datagrid edit how to focus on textbox


protected void dgAnnouncement_ItemCommand(object source, DataGridCommandEventArgs e)
{

switch(e.CommandName)
{
case "Edit":
dg.EditItemIndex = e.Item.ItemIndex;
.
.
fillurDataGrid
.
.
TextBox txtSub1 = (TextBox) dg.Items[e.Item.ItemIndex].Cells[0].FindControl("txtSubject");

// "Control differ according to the control you used within the DataGrid Column Here me used TextBox"

// "Cells[0] --> "Position Of The Column In The DataGrid"

// "FindControl("txtSubject") --> Control Id Which Within the Particular Cell

txtSub1.Focus();
}
}

Wednesday, September 17, 2008

What's the difference between TINYINT, SMALLINT, INT and BIGINT DataType In SQL SERVER

This datatype same is type but the differ from storage type,min and max values, the details as follows,

Data Type Min Value Max Value Storage Size
tinyint 0 255 1 byte
smallint -2^15 (-32,768) 2^15 - 1 (32,767) 2 bytes
int -2^31 (-2,147,483,648) 2^31 - 1 (2,147,483,647) 4 bytes
bigint -2^63 (-9,223,372,036,854,775,808) 2^63 - 1 (9,223,372,036,854,775,807) 8 bytes

Thursday, September 4, 2008

How To Get The Day Name From The Given Date Using C#

DateTime dt = DateTime.Parse("08/08/2001");

Response.Write(dt.DayOfWeek);