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 fnamelname LocationPhno residencestatus 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(sqconn); 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