Gridview Checkbox Header




<asp:TemplateField>
<HeaderTemplate>
<asp:CheckBox ID="chkSelectAll" runat="server" AutoPostBack="true" OnCheckedChanged="chkSelectAll_CheckedChanged" />
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" AutoPostBack="true" OnCheckedChanged="chkSelect_CheckedChanged" />
</ItemTemplate>
</asp:TemplateField>
-------------------------------------------------
HEADER CHECKBOX EVENT
-------------------------------------------------
protected void chkSelectAll_CheckedChanged(object sender, EventArgs e)
{
CheckBox chkAll = (CheckBox)GridView1.HeaderRow.FindControl("chkSelectAll");
if (chkAll.Checked == true)
{
foreach (GridViewRow gvRow in GridView1.Rows)
{
CheckBox chkSel =
(CheckBox)gvRow.FindControl("chkSelect");
chkSel.Checked = true;
}
}
else
{
foreach (GridViewRow gvRow in GridView1.Rows)
{
CheckBox chkSel = (CheckBox)gvRow.FindControl("chkSelect");
chkSel.Checked = false;
}
}
}

-----------------------------------------------------------
ITEM CHECKBOX EVENT
------------------------------------------------------------
protected void chkSelect_CheckedChanged(object sender, EventArgs e)
{
int count = 0;
int totalChkBoxes = 0;
foreach (GridViewRow gvRow in GridView1.Rows)
{
totalChkBoxes += 1;
CheckBox chkSel = (CheckBox)gvRow.FindControl("chkSelect");

if (chkSel.Checked == true)
{
count += 1;
}
}

if (count == 0) // if no checkbox is selected then make header checkbox false.
{
CheckBox chkAll = (CheckBox)GridView1.HeaderRow.FindControl("chkSelectAll");
chkAll.Checked = false;
}

count = count + 1;
if (count == totalChkBoxes + 1)
{
CheckBox chkAll = (CheckBox)GridView1.HeaderRow.FindControl("chkSelectAll");
chkAll.Checked = true;
}

}
-------------------





Misc. Snippets

fdfadsf
test snippet

Only Numbers in Txtbox

 function isNumberKey(evt) {
            var charCode = (evt.which) ? evt.which : event.keyCode
            if (charCode > 31 && (charCode < 48 || charCode > 57))
                return false;
            return true;
        }
---------------------------
<asp:TextBox ID="txtph2" MaxLength="3"  
      onkeypress="return isNumberKey(event)"
      runat="server"></asp:TextBox>

Auto_TAB

............AutoTab.js------------------
------------------------------------------------------------
-- make this a separate .js file and add reference in head section of page.
------------------------------------------------------------
/* This script and many more are available free online at
The JavaScript Source!! http://javascript.internet.com
*/
var isNN = (navigator.appName.indexOf("Netscape") != -1);

function autoTab(input, len, e) {
    var keyCode = (isNN) ? e.which : e.keyCode;
    var filter = (isNN) ? [0, 8, 9] : [0, 8, 9, 16, 17, 18, 37, 38, 39, 40, 46];
    if (input.value.length >= len && !containsElement(filter, keyCode)) {
        input.value = input.value.slice(0, len);
        input.form[(getIndex(input) + 1) % input.form.length].focus();
    }

    function containsElement(arr, ele) {
        var found = false, index = 0;
        while (!found && index < arr.length)
            if (arr[index] == ele)
                found = true;
            else
                index++;
        return found;
    }

    function getIndex(input) {
        var index = -1, i = 0, found = false;
        while (i < input.form.length && index == -1)
            if (input.form[i] == input) index = i;
            else i++;
        return index;
    }
    return true;
}
----------------------------------------------------------------------
 <script type="text/javascript" src="JS/autoTab.js"></script>

     <asp:TextBox ID="txtph2" MaxLength="3"
         onKeyUp="return autoTab(this, 3, event);"   
         onkeypress="return isNumberKey(event)"
         runat="server"></asp:TextBox>

SQL Random List Of Records

-----------------------------------------------------------------
SQL RANDOM LIST OF PRODUCTS

Select Top 10 *
from
(
Select ProductID, ProductName, UnitPrice
from Products
--Where
-- ForumQuestion.QuestionTitle Like @SearchKeyword
) MyTable
ORDER BY NEWID()

Get_Random_Password

-----------------------------------------------------------

public static string GetRandomPassword(int length)
{
char[] chars = "$%#@!*abcdefghijklmnopqrstuvwxyz1234567890?;:ABCDEFGHIJKLMNOPQRSTUVWXYZ^&".ToCharArray();
string password = string.Empty;
Random random = new Random();

for (int i = 0; i < length; i++)
{
int x = random.Next(1,chars.Length);
//Don't Allow Repetation of Characters
if (!password.Contains(chars.GetValue(x).ToString()))
password += chars.GetValue(x);
else
i--;
}
return password;
}

Its a simple logic instead by generating a random number between 1 and Length of characters. It also checks that same character is not repeated in generated password and finally return the randomly generated password string of desired length.

Gridview_Tips_n_Tricks

------------------------------------------------------------
void GridView1_RowUpdated(Object sender, GridViewUpdatedEventArgs e)

{

// Retrieve the row being edited.

int index = GridView1.EditIndex;

GridViewRow row = GridView1.Rows[index];


// Retrieve the value of the first cell

lblMsg.Text = "Updated record " + row.Cells[1].Text;

}

Row_Deleting Event

-------------------------------------------------

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

int ID = (int)GridView1.DataKeys[e.RowIndex].Value;

// Query the database and get the values based on the ID

}

LinkButtons

--------------------------------------------------------
<ItemTemplate>
<asp:LinkButton ID="lnkbtnIsactive" runat="server"
OnClick="change_status"
CommandArgument='<%#Eval("ID")+","+Eval("ProjectID") %>'
ToolTip='<%#Eval("UserName")%>'
Text='<%#get(Convert.ToBoolean((Eval("IsActive"))))%>'
></asp:LinkButton>
</ItemTemplate>
//(can also use <img src> in linkbutton)

lnk = ((LinkButton)(sender));
string[] array = lnk.CommandArgument.ToString().Split(',');
prjID = Convert.ToInt32(array[1].ToString());
Int32 bid = Convert.ToInt32(array[0].ToString());

---------------------------------------------------------

Row_Updated Event

void GridView1_RowUpdated(Object sender, GridViewUpdatedEventArgs e)
{

// Retrieve the row being edited.

int index = GridView1.EditIndex;

GridViewRow row = GridView1.Rows[index];


// Retrieve the value of the first cell

lblMsg.Text = "Updated record " + row.Cells[1].Text;

}

gridview_rowEditing

-------------------------------------------------------------
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
BindGrid();

GridViewRow grow = (GridViewRow)GridView1.Rows[e.NewEditIndex];
DropDownList ddlR = new DropDownList();
ddlR = (DropDownList)grow.FindControl("ddlrole");

DropDownList ddlC = (DropDownList)grow.FindControl("ddlcnt");

if (ddlR != null)
{
ddlR.DataSource = GetRoles();
ddlR.DataTextField = "role";
ddlR.DataValueField = "ID";
ddlR.DataBind();

}
string r = ViewState["role"].ToString();
ddlR.Items.FindByText(r).Selected = true;


if (ddlC != null)
{
ddlC.DataSource = GetCountry();
ddlC.DataTextField = "countryname";
ddlC.DataValueField = "countryid";
ddlC.DataBind();

}
string c = ViewState["cnt"].ToString();
ddlC.Items.FindByText(c).Selected = true;
}

URL Functions

---------------------------------------------------------

public string getImageUrl(bool act)
{
string imageurl = "";
string path = "~/images/";
if (act == true)
{
imageurl = path + "available.png";
return imageurl;
}
else
{
imageurl = path + "notav.png";
return imageurl;
}
}
------------------------------------------------------
<ItemTemplate>
<asp:ImageButton ID="imgBtnStatus" CommandName="changestatus"
CommandArgument='<%#Eval("userid")%>'
ToolTip="Click to change status. !!!"
ImageUrl='<%#getImageUrl(Convert.ToBoolean((Eval("IsActive"))))%>'
runat="server" />
<asp:HiddenField ID="HiddenField1" Value='<%#Eval("IsActive")%>'
runat="server" />
</ItemTemplate>
---------------------------------------------------------------------------------------------------------------

change status images 2

-------------------------------------------------------------------
----------------------------------
alter proc usp_Change_Status
(
@userid int,
@status varchar(50)
)
as
update tbl_user set IsActive=@status where userid=@userid

-----------------------------------------------------
public string getImageUrl(bool act)
{
string imageurl = "";
string path = "~/images/";
if (act == true)
{
imageurl = path + "available.png";
return imageurl;
}
else
{
imageurl = path + "notav.png";
return imageurl;
}
}



-------------------------------------------------------------------------------------------
<asp:TemplateField>
<ItemTemplate>
<asp:ImageButton ID="imgBtnStatus" CommandName="changestatus"
CommandArgument='<%#Eval("userid")%>'
ToolTip="Click to change status. !!!"

ImageUrl='<%#getImageUrl(Convert.ToBoolean((Eval("IsActive"))))%>'
runat="server" />

<asp:HiddenField ID="HiddenField1" Value='<%#Eval("IsActive")%>'
runat="server" />
/ItemTemplate>
</asp:TemplateField>

------------------------------------------------------------------------------------------------
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{

if (e.CommandName.ToString() == "changestatus")
{
GridViewRow grow = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer;
ImageButton img = e.CommandSource as ImageButton;
GridViewRow gvRow = img.Parent.Parent as GridViewRow;

int id = int.Parse(e.CommandArgument.ToString());

HiddenField hdnField = (HiddenField)GridView1.Rows[gvRow.RowIndex].FindControl("HiddenField1");

string status = "";
if (hdnField.Value == "True")
{
status = "False";
}
else if (hdnField.Value == "False")
{
status = "True";
}

Hashtable ht = new Hashtable();
ht.Add("@userid", id);
ht.Add("@status", status);

NSBuilder.DataAccess.ExecuteNonQuery("usp_Change_Status", ht);
BindGrid();
}

}