Link to home
Start Free TrialLog in
Avatar of jyotiraman
jyotiraman

asked on

checkbox list wth database

I have one table name having 2 fileds did(int) and dname(nvarchar(20)) and I want to use in CheckBoxList and I want to save it into another table as anyoen selected or not selected so how I will manage thses ids.
Avatar of Senthil B
Senthil B
Flag of India image

When you load the data into list box you have to load the ids into value property and the name should be visible. example for you.

<form action="">
<div>
<input type="radio" name="rs1" value="zero" checked>zero
<input type="radio" name="rs1" value="one">one
<input type="radio" name="rs1" value="two">two
<br>
<input type="checkbox" name="cb1" value="cb 1">cb 1
<input type="checkbox" name="cb2" value="cb 2">cb 2
<input type="checkbox" name="cb3" value="cb 3">cb 3
<br>
<input type="button" value="Show checked radio value" onclick="
alert(showRadioChecked(this.form.rs1));
"><br>
<input type="button" value="Show all checked values" onclick="
alert(showAllChecked(this.form));
"><br>
<input type="reset">
</div>
</form>

<script type="text/javascript">

function showRadioChecked(rSet)
{
var i = rSet.length;
while(i--){
if (rSet[i].checked) return rSet[i].value;
}
}

function showAllChecked(f)
{
var el, els = f.elements;
var x = '';
var i = els.length;
while(i--){
el = els[i];
if (el.checked){
x += '\n' + el.type + ': ' + el.value;
}
}
return x;
}
</script>
ASKER CERTIFIED SOLUTION
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
2. Retrieve all the values back

' Iterate through the Items collection of the CheckBoxList
         ' control and display the selected items.
         Dim i As Integer

         For i=0 To checkboxlist1.Items.Count - 1

            If checkboxlist1.Items(i).Selected Then

               Message.Text &= checkboxlist1.Items(i).Value & "<br />"

            End If

         Next

Open in new window

Avatar of jyotiraman
jyotiraman

ASKER

no it is not what exact I want I am using SQl server 2005 and ASP.Net(c#)
...... good .........
Did you get any progress with my comments ?
good
If it's good, why only a B-grade ?