Solved

checkbox list wth database

Posted on 2010-09-08
8
823 Views
Last Modified: 2013-12-17
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.
0
Comment
Question by:jyotiraman
  • 4
  • 3
8 Comments
 
LVL 4

Expert Comment

by:senthilkumarsb
Comment Utility
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>
0
 
LVL 53

Accepted Solution

by:
Dhaest earned 500 total points
Comment Utility
I'll do it in parts. (example in vb.net, data coming from access)

1. Fill the checkboxList with the id and dname
    'Use a string variable to hold the ConnectionString.

    Dim connectString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _

                                "Data Source=C:\File Databases\NWIND.MDB"



    'Create an OleDbConnection object,

    'and then pass in the ConnectionString to the constructor.

    Dim cn As OleDbConnection = New OleDbConnection(connectString)



    'Open the connection.

    cn.Open()



    'Use a variable to hold the SQL statement.

    Dim selectString As String = "SELECT ID, dname FROM YourTable"



    'Create an OleDbCommand object.

    'Notice that this line passes in the SQL statement and the OleDbConnection object.

    Dim cmd As OleDbCommand = New OleDbCommand(selectString, cn)



    'Send the CommandText to the connection, and then build an OleDbDataReader.

    'Note: The OleDbDataReader is forward-only.

    Dim reader As OleDbDataReader = cmd.ExecuteReader()



    While(reader.Read())

         CheckBoxList1.Items.Add(new ListItemreader("dname").ToString(), ListItemreader("ID").ToString())         

    End While



    'Close the reader and the related connection.

    reader.Close()

    cn.Close()

Open in new window

0
 
LVL 53

Expert Comment

by:Dhaest
Comment Utility
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

0
 

Author Comment

by:jyotiraman
Comment Utility
no it is not what exact I want I am using SQl server 2005 and ASP.Net(c#)
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:jyotiraman
Comment Utility
...... good .........
0
 
LVL 53

Expert Comment

by:Dhaest
Comment Utility
Did you get any progress with my comments ?
0
 

Author Closing Comment

by:jyotiraman
Comment Utility
good
0
 
LVL 53

Expert Comment

by:Dhaest
Comment Utility
If it's good, why only a B-grade ?
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now