String was not recognized as a valid Boolean.

Question

how to solve this problem String was not recognized as a valid Boolean.

Zakir Ahamed · Answer

https://msdn.microsoft.com/en-us/library/86hw82a3(v=vs.110).aspx It should be " true " or " false ". Else this line will throw error.

Midhun Tp · Answer

Hi, In your Convert.ToBoolean() function the value should be "true" or "false" for it to work. In your below code - Convert.ToBoolean(userRight["wbCanView"].ToString()); Check what is the value you getting for userRight["wbCanView"].ToString() It should be " true " or " false ". Else this line will throw error. Like wise check at other 2 places also. If you are getting "1" or "0", you should convert it to "true" or "false" accordingly.

Syeada Sanjida Jahan · Answer

Dear zakir ahamed below this code please see and solve this problem.. protected void tvMenu_HtmlRowPrepared(object sender, TreeListHtmlRowEventArgs e) { DataTable dtUserRight = new DataTable(); string strConnectionString = ConfigurationManager.ConnectionStrings["EchoITEMS"].ConnectionString; SqlConnection Conn = new SqlConnection(strConnectionString); Conn.Open(); SqlCommand cmd = new SqlCommand("GET_USER_RIGHTS_MENU_SP", Conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@USER_ID", SqlDbType.BigInt).Value = Convert.ToInt32(ddlUser.SelectedItem.Value.ToString()); ; cmd.CommandTimeout = 50; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dtUserRight); Conn.Close(); if (dtUserRight.Rows.Count > 0) { var _userRightList = from DataRow myRow in dtUserRight.Rows select myRow; foreach (DataRow userRight in _userRightList) { if (Convert.ToInt32(e.NodeKey) == Convert.ToInt32(userRight["wbMenuId"].ToString())) { tvMenu.FindNodeByKeyValue(e.NodeKey).Selected = true; (tvMenu.FindDataCellTemplateControl(e.NodeKey, tvMenu.Columns["wbCanView"] as TreeListDataColumn, "chkView") as CheckBox).Checked = Convert.ToBoolean(userRight["wbCanView"].ToString()); (tvMenu.FindDataCellTemplateControl(e.NodeKey, tvMenu.Columns["wbCanEdit"] as TreeListDataColumn, "chkEdit") as CheckBox).Checked = Convert.ToBoolean(userRight["wbCanEdit"].ToString()); (tvMenu.FindDataCellTemplateControl(e.NodeKey, tvMenu.Columns["wbCanDelete"] as TreeListDataColumn, "chkDelete") as CheckBox).Checked = Convert.ToBoolean(userRight["wbCanDelete"].ToString()); } } } } protected void btnAssaign_Click(object sender, EventArgs e) { if (ddlUser.SelectedIndex > -1) { int _userID = Convert.ToInt32(ddlUser.SelectedItem.Value.ToString()); string _userName = ddlUser.SelectedItem.Text.Trim(); lblMessage.Text = ""; try { foreach (TreeListNode node in tvMenu.GetAllNodes()) { CheckBox chkView = tvMenu.FindDataCellTemplateControl(node.Key.ToString(), tvMenu.Columns["wbCanView"] as TreeListDataColumn, "chkView") as CheckBox; CheckBox chkEdit = tvMenu.FindDataCellTemplateControl(node.Key.ToString(), tvMenu.Columns["wbCanEdit"] as TreeListDataColumn, "chkEdit") as CheckBox; CheckBox chkDelete = tvMenu.FindDataCellTemplateControl(node.Key.ToString(), tvMenu.Columns["wbCanDelete"] as TreeListDataColumn, "chkDelete") as CheckBox; String ConnString = ConfigurationManager.ConnectionStrings["EchoITEMS"].ConnectionString; SqlConnection con = new SqlConnection(ConnString); SqlCommand cmd = new SqlCommand("USER_RIGHTS_INSERT_UPDATE_SP", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@USER_ID", SqlDbType.BigInt).Value = _userID; cmd.Parameters.Add("@MENU_ID", SqlDbType.BigInt).Value = Convert.ToInt32(node.Key); cmd.Parameters.Add("@CAN_EDIT", SqlDbType.Bit).Value = chkEdit.Checked; cmd.Parameters.Add("@CAN_DELETE", SqlDbType.Bit).Value = chkDelete.Checked; cmd.Parameters.Add("@CAN_VIEW", SqlDbType.Bit).Value = chkView.Checked; if (String.IsNullOrEmpty(node.ParentNode.Key)) { cmd.Parameters.Add("@PARENT_ID", SqlDbType.BigInt).Value = Convert.ToInt32(node.Key); } else { cmd.Parameters.Add("@PARENT_ID", SqlDbType.BigInt).Value = Convert.ToInt32(node.ParentNode.Key); } try { con.Open(); cmd.ExecuteNonQuery(); lblMessage.Text = String.Format("Menu Permission has Inserted successfully to Assign User : {0}", _userName); } catch (Exception ex) { } } } catch (Exception ex) { lblMessage.Text = String.Format("Menu Permission hasn't Complete..RollBack!! of User : {0} ", _userName); } } }

Zakir Ahamed · Answer

hi just send me the code then only i know how to solve it

String was not recognized as a valid Boolean.

String was not recognized as a valid Boolean.

Answers (4)