Get checked valu from database and set in checkbox in .netC#

Question

I am trying to get all the value from database and set that valu in checkbox when user click on edit button.

Amit Mohanty · Answer

You can use like this. string weekDays = "Monday,Tuesday,Wednesday" ; string [] days = weekDays.Split( ',' ); foreach ( string day in days) { if (day == "Monday" ) mon.Checked = true ; if (day == "Tuesday" ) tues.Checked = true ; if (day == "Wednesday" ) wed.Checked = true ; if (day == "Thrusday" ) thrus.Checked = true ; if (day == "Friday" ) fri.Checked = true ; if (day == "Saturday" ) sat.Checked = true ; if (day == "Sunday" ) sun.Checked = true ; }

Itsme · Answer

Thanks a lot It is working great.

Amit Mohanty · Answer

.aspx "C#" AutoEventWireup= "true" CodeBehind= "WebForm4.aspx.cs" Inherits= "WebApp1.WebForm4" %> "http://www.w3.org/1999/xhtml" > "server" > "form1" runat= "server" > class = "checkbox checkbox-primary" > "mon" Text= "Monday" runat= "server" CssClass= "styled" /> "tues" Text= "Tuesday" runat= "server" CssClass= "styled" /> "wed" Text= "Wednesday" runat= "server" CssClass= "styled" /> "thrus" Text= "Thrusday" runat= "server" CssClass= "styled" /> "fri" Text= "Friday" runat= "server" CssClass= "styled" /> "sat" Text= "Saturday" runat= "server" CssClass= "styled" /> "sun" Text= "Sunday" runat= "server" CssClass= "styled" /> "GridView1" runat= "server" AutoGenerateColumns= "false" > "Weeks Opens" > "lblweeks" runat= "server" Text= ' ' > "Select" > "lnkView" runat= "server" CommandArgument= ' ' OnClick= "ViewDetails" >Select .cs protected void Page_Load( object sender, EventArgs e) { this .BindGrid(); } private void BindGrid() { DataTable dt = new DataTable(); dt.Columns.AddRange( new DataColumn[2] { new DataColumn( "Id" , typeof ( string )), new DataColumn( "Name" , typeof ( string )) }); dt.Rows.Add( "mon" , "Monday" ); dt.Rows.Add( "tues" , "Tuesday" ); dt.Rows.Add( "wed" , "Wednesday" ); dt.Rows.Add( "thrus" , "Thrusday" ); dt.Rows.Add( "fri" , "Friday" ); dt.Rows.Add( "sat" , "Saturday" ); dt.Rows.Add( "sun" , "Sunday" ); GridView1.DataSource = dt; GridView1.DataBind(); } protected void ViewDetails( object sender, EventArgs e) { LinkButton lnkView = (sender as LinkButton); string id = lnkView.CommandArgument; switch (id) { case "mon" : mon.Checked = Check(mon); break ; case "tues" : tues.Checked = Check(tues); break ; case "wed" : wed.Checked = Check(wed); break ; case "thrus" : thrus.Checked = Check(thrus); break ; case "fri" : fri.Checked = Check(fri); break ; case "sat" : sat.Checked = Check(sat); break ; case "sun" : sun.Checked = Check(sun); break ; } } protected bool Check(CheckBox chk) { if (chk.Checked == true ) return false ; else return true ; }

Itsme · Answer

string weeks = (grow.FindControl("lblweeks") as Label).Text; In this string my all checked value is stored seperated by comma "," and in database all the checked value is stored in a single column for eg:: Monday,Tuesday,Wednesday...etc so How to implement I am little bit confused. because when user click on edit button then all the checked value should be fetched from database and value checked in checkbox.

Get checked valu from database and set in checkbox in .netC#

Answers (4)