right syntax for storing a checkbox value 2

[dinster]

Hi all am currently saving data using an aspx webpage. I can store textbox values but having trouble getting the syntax right for a checkbox value....

could any1 have look at this code and see where am going wrong?

cmd.Parameters.Add(New OleDbParameter("@Location", txt_Location.text))
	cmd.Parameters.Add(New OleDbParameter("@Diagnosis", txt_Diagnosis.text))
	
[COLOR=#ff0000]
	If chk_sepsit.Checked Then
	cmd.Parameters.Add(New OleDbParameter("@SurvingSepsis", chk_sepsit.value = True))
	else
	cmd.Parameters.Add(New OleDbParameter("@SurvingSepsis", chk_sepsit.value = False))
	end if
[/color]

 

[ca8msm]

You don't have to check if it is checked or not, just assign the value based on it's Checked property e.g

cmd.Parameters.Add(New OleDbParameter("@SurvingSepsis", chk_sepsit.Checked))

-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[jbenson001]

Remove the "= TRUE" and the "= False "
and replace with chk_sepsit.checked

 

[dinster]

cheers guys...you made that look so simple! lol

 

[jbenson001]

glad to help .. you'll get the hang of .NET. Just keep plugging away..