How to get value for checkbox from database in asp.net c# ??

Accepted answer

Hi krutika,

You can get the value of checkbox as boolean as 1 or 0 from database and then show the value in the c# for checkbox .When true then checked else unchecked .

You can follow below link also :

https://stackoverflow.com/questions/30483099/how-to-get-checkbox-value-from-database-in-c-sharp-asp-net

Hope its heps to you.Please accept the ans if its help you.

Thanks

+3

tom okila7y ago

You can also retrive the value from database as an integer, that is if you stored it as either 1-true; 0:false like:

int test = Convert.ToInt32(ds.Tables[0].Rows[0]["NAME"].ToString());

test variable stores the value retrived from database

Then use if condition to check against the checkbox as below:

check_Test.Checked = (test== 1) ? true : false;

0

Bhairab Dutt8y ago

Brilliant..

Thanks for accept the answer.

0

Krutika Karekar8y ago

Thanks sir....bt i already got the solution....i used trim() function...

0