How to make code for Girdview row shows on checkbox?

Question

Hai Friends,

i wanna create the application like contact details,
i have the concept when "ADMIN" logged in that entire contact list ll be show on gridview with checkbox 'enable','disable' button.
only admin can see the entire contact list if they modified list ll show on other users 'name','location','phone'.
for example:
=============
if admin logged means

checkbox name location    mobile    residence   status
tick    A     chennai 7894561230 22345610 enabled
tick    B     Banglore 1234567890   12345      enabled
not tick        c     Kolkatta   8745612309 887450    disabled

other login peopls:
==================

here only enable contact list ll be shown the Gridview only can view

Name location   Mobile       residence
A chennai   7894561230 22345610
B         Banglore 1234567890 12345

how to do that?

Iftikar Hussain · Answer

put the break point over the below line and check what value you are getting string usercode = grdvStore.Rows[i].Cells[1].Text; Regards, Iftikar

Rocky Rocky · Answer

hai, its not passinf the usercode, how to make update for that gridview.

Iftikar Hussain · Answer

are you getting correct usercode for this query string sq = "update telephone_user set status='Disable' where user_id='" + usercode + "'"; Regards, Iftikar

Rocky Rocky · Answer

Hai Iftikar, My apsx code: ============= my c# code: ========= protected void Button1_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["AccessString"].ConnectionString); string sq = "select User_id ,fname,lname ,Location,Phno ,residence,status from telephone_user "; SqlDataAdapter de = new SqlDataAdapter(sq, conn); DataTable dtStore = new DataTable(); de.Fill(dtStore); grdvStore.DataSource = dtStore.DefaultView; grdvStore.DataBind(); } protected void Save_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["AccessString"].ConnectionString); //StringBuilder strSql = new StringBuilder(string.Empty); //string status = "Disable"; for (int i = 0; i > grdvStore.Rows.Count; i++) // string user=grdvStore.Rows[i { CheckBox chkSelect = (CheckBox)grdvStore.Rows[i].Cells[0].FindControl("chkSelect"); if (chkSelect.Checked) { string usercode = grdvStore.Rows[i].Cells[1].Text; string status = grdvStore.Rows[i].Cells[7].Text; string sq = "update telephone_user set status='Disable' where user_id='" + usercode + "'"; //// update code not working SqlCommand cn = new SqlCommand(sq,conn); conn.Open(); cn.ExecuteNonQuery(); conn.Close(); } } how to do that?

Sanjeeb Lenka · Answer

Refer to this link it may help you http://www.aspsnippets.com/Articles/Select-and-delete-multiple-rows-in-ASP.Net-Gridview-control.aspx http://www.aspdotnet-suresh.com/2013/03/get-gridview-row-values-when-checkbox.html

Iftikar Hussain · Answer

Please refer link http://www.codeproject.com/Articles/11207/Selecting-multiple-checkboxes-inside-a-GridView-co Regards, Iftikar

Iftikar Hussain · Answer

can you share your aspx code? Regards, Iftikar

Rocky Rocky · Answer

Hai, how to pass the update command , in check box.....

Iftikar Hussain · Answer

You want link for checkbox in gridview? are you able to display all user in your grid? Regards, Iftikar

Rocky Rocky · Answer

Hai Iftikar, can you provide any link for my reference?

Iftikar Hussain · Answer

I believe you know how to populate data in gridview. You can have two page (one for admin and another for normal user). In admin page, you write select query from User table without any condition and bind it to gridview. In this page you can have save button to save all the checked or unchecked user info into database. You can write Update query for set status='Enabled' for selected checkbox. In the other page, you can write select query to pull only enabled user by putting the condition. Regards, Iftikar

Rocky Rocky · Answer

Hai Iftikar, I m looking for ASP.NET application, If admin login can click the check box That row ll be display for other login peoples.

Iftikar Hussain · Answer

Hi, Are you looking for in ASP.NET or Windows Application. Regards, Iftikar

How to make code for Girdview row shows on checkbox?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (13)