Re: CheckBox value inserted into MS SQL data table

Thank-you Jeevanathamand and Jignesh,

 

Both your replys are extremely helpful.

 

Thank-you both for your assistance, it is greatly appreciated!

 

Regrds,

Kyle

Thank you for your code. As jignesh suggested, you can try moving the values into parameters instead of inline text would solve this issue. 

 

Also, since you are new to programming, I advise you to not to have presentation and  database logic. Look into how to use entity framework for database operations using repository pattern. 

 

https://www.c-sharpcorner.com/article/asp-net-mvc-crud-operation-using-entityframework/ 

Please find this article.

 

If you are storing int values then just remove single quates while passing values 

only for string values quotes required, int, bool and double not required 

 

if still not working please use below link,

 

https://www.c-sharpcorner.com/blogs/insert-checkbox-values-into-database1 

Hi Jeevanatham,

 

My code as requested;

 

 SqlConnection con = new SqlConnection(@"Data Source=KYLELT\SQLEXPRESS;Initial Catalog=EmploymentEquity;Integrated Security=True");

        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void BtnEmployerDetailsUpdate_Click(object sender, EventArgs e)
        {
            //Code to update CompanyDetails table
            con.Open();
            SqlCommand cmd = con.CreateCommand();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "insert into CompanyDetails values('"+TxBoxTradeName.Text+ "','"+TxBoxDTIname.Text+ "','"+CheckBox1.Text+ "','"+CheckBox2.Text+ "','"+CheckBox3.Text+ "','"+TxBoxEEnumber.Text+ "')";
            cmd.ExecuteNonQuery();
            con.Close();
        }

 

Thank-you for your response, it is appreciated!

 

Regards,

Kyle

Hi,

 

Please find below link,

 

https://forums.asp.net/t/1859270.aspx?Check+the+Checkbox+in+gridview+based+on+db+value

 

https://www.aspsnippets.com/Articles/Set-Check-Uncheck-CheckBox-in-GridView-based-on-DataTable-value-in-ASPNet.aspx