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

}

FckEditor

--------------------------------------------------------
FCKEditor Sample

Alphabetic Paging Gridview

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

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ShowAllProjects();
}

}

public void ShowAllProjects()
{
DataTable dt = new DataTable();
dt = NSBuilder.DataAccess.GetDataSet("Usp_BindCategory_ForSortingTest").Tables[0];
if (dt.Rows.Count > 0)
{
gridAllProjects.Visible = true;
gridAllProjects.DataSource = dt;
gridAllProjects.DataBind();

}
else
{
gridAllProjects.Dispose();
gridAllProjects.Visible = false;

}
}


protected void gridAllProjects_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Pager)
{
TableCell tc = new TableCell();
TableCell tc1 = new TableCell();

tc.Text = "[Page:";
tc1.Text = "]";
Table tbl = new Table();
tbl = (Table)(e.Row.Cells[0].Controls[0]);
tbl.Rows[0].Cells.AddAt(gridAllProjects.PageIndex, tc);
tbl.Rows[0].Cells.AddAt(gridAllProjects.PageIndex + 2, tc1);
}
}

protected void gridAllProjects_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
TableCell cell = e.Row.Cells[0];

cell.ColumnSpan = 2;

for (int i = 65; i <= (65 + 25); i++)
{

LinkButton lb = new LinkButton();

lb.Text = Char.ConvertFromUtf32(i) + " ";

lb.CommandArgument = Char.ConvertFromUtf32(i);

lb.CommandName = "AlphaPaging";

cell.Controls.Add(lb);

lb.ToolTip = "Click to find the categories starting with :- " + lb.Text;
// lb.BackColor = System.Drawing.ColorTranslator.FromHtml("#6b8ade");
lb.CssClass = "simple";
// lb.Attributes.Add("onmouseover","style='backbol
// lb.Style.Add("background-color", "red");

if (! CheckCategoryExistsOrNot(lb.Text))
{
lb.Visible = false;
}

}
}
}

public bool CheckCategoryExistsOrNot(string s)
{
DataTable dt = new DataTable();
Hashtable ht = new Hashtable();
ht.Add("@C", s);

string result;
bool r;
result = Convert.ToString(NSBuilder.DataAccess.ExecuteNonQueryWithReturnParameter
("Usp_CheckCategorEXITSOrNOTForSortingTest",ht));

if (result == "1")
{
r = true;
}
else
{
r= false;
}
return r;

}


protected void gridAllProjects_RowCommand(object sender, GridViewCommandEventArgs e)
{
DataTable dt = new DataTable();
Hashtable ht = new Hashtable();
if (e.CommandName.Equals("AlphaPaging"))
{
ht.Add("@C", e.CommandArgument.ToString());
dt = NSBuilder.DataAccess.GetDataSet("Usp_BindCategory_ForSortingTest", ht).Tables[0];
gridAllProjects.DataSource = dt;
gridAllProjects.DataBind();
}


}


protected void gridAllProjects_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gridAllProjects.PageIndex = e.NewPageIndex;
ShowAllProjects();
}

}

---------------stored proc-----
alter PROCEDURE [dbo].[Usp_CheckCategorEXITSOrNOTForSortingTest]
(
@C Char(1) = null

) -- Usp_CheckCategorEXITSOrNOTForSortingTest 'A'
AS


BEGIN
DECLARE @VAR INT

IF EXISTS (SELECT CATEGORY FROM tbl_Category WHERE Category LIKE @C + '%')

SET @VAR = 1
ELSE
SET @VAR = -1

END
--PRINT @VAR
RETURN @VAR




------css class----

.simple
{
background-color:#bd0000;
color:#ffffff;
}
.simple:hover
{
background-color:#ffffff;
color:#bd0000;
}
--------------------

UsefulLinks

BLOGS

0. aspdotnet-suresh.blogspot.com
1. CsharpdotNetFreak
2. (Ramani sandeep)
3. SQL-Madhiwan
4..NetTips-Abhijeet Jana
5. www.abhisheksur.com
6. codesforprogrammers.blogspot.com
7. aspalliance
8. megasolutions.net
9. DotnetFreaks
10. AspnetTutorials
11. AspSnippets.com
12. T-SQL Format
13.CodeFormat for Blogs
14. EggHeadcafe FAQ
15.TechTasks Bloging

16. www.ezzylearning.com

Dropdownlist 2 Column display

Displaying two columns in dropdownlist----------------------------------

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
bindDropDown();
}

}

public void bindDropDown()
{


//string[,] arr_Place = {
// {"Delhi","India"},
// {"Newyork","America"},
// {"Taiwan","China"},
// {"Colombo","Srilanka"},
// {"Lahore","Pakistan"},

// };

DataSet dsdata = new DataSet();
dsdata = GetData();
int rowcount = Convert.ToInt32(dsdata.Tables[0].Rows.Count);
int colcount = 2;

string [,] arr_Place = new String[rowcount,colcount];

string a = String.Empty;
string b = String.Empty;

// FILL THE ARRAY WITH THE DATA
for (int i = 0; i < dsdata.Tables[0].Rows.Count; i++)
{
a = dsdata.Tables[0].Rows[i][0].ToString();
b = dsdata.Tables[0].Rows[i][1].ToString();

arr_Place[i, 0] = a;
arr_Place[i, 1] = b;

}



// NOW AFTER FILLING , BIND THE ARRARY WITH THE DROPDOWNLIST

string str = String.Empty;

for (int i = 0; i < arr_Place.GetLength(0); i++)
{

str = arr_Place[i, 0].ToString() + " ---> " + arr_Place[i, 1].ToString();

DropDownList1.Items.Add(str);
// DropDownList1.Items.Add(new ListItem(arr_Place[i, 0], arr_Place[i, 1]));
}

DropDownList1.Items.Insert(0, "--select one--");

}



public DataSet GetData()
{
// [Usp_checkCountyAvailable_Test]
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["cn"].ConnectionString.ToString();

SqlDataAdapter adp = new SqlDataAdapter("Usp_checkCountyAvailable_TEst", con);
adp.Fill(ds);
return ds;
}