how to make a relation between TextBox and CheckBoxList

Question

0.00/5 (No votes)

See more:

i Have a textbox and CheckBoxList

If i enter orderid in TextBox(order id is the column name in my database) ,that time want to show the status of order id in CheckBox List

In the CheckBoxList i have four items

Renovated,completed,validated,cancelled

how to show clicked ,for example the orderid renovated or completed,validated,cancelled

Please give me a solution

Posted 27-May-12 4:53am

mansoorttg

Add a Solution

Comments

Shahin Khorshidnia 27-May-12 12:59pm

It depends on your application base (Win/ASP.Net/WPF ?) and your databse design. Are the type of the items (copleted, validated, cancelled) are Bit? If yes, then you can Select them after TextChanged as a Collection (List) and rebind them to CheckBoxList. Firstly, plase reTag your question and specify WinForm or ASP.NET or .... .

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

taha bahraminezhad Jooneghani · Answer 1 · 2012-05-27T12:46:00

if you have 2table , first for orders and second for status, and each order have a status_id, this is the solution:

this should be your markup:

XML

<asp:TextBox ID="TextBox1" runat="server" ontextchanged="TextChanged"></asp:TextBox>
    <asp:Repeater ID="rptstatus" runat="server" DataSourceID="SqlDataSource1">
        <ItemTemplate>
            <asp:CheckBox ID="CheckBox1" 
            Checked='<%#(int)Eval("status_id")==(int)Session["id"] %>' 
            Text='<%#Eval("status") %>' runat="server" Enabled="False" />
        </ItemTemplate>
    </asp:Repeater>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:testConnectionString %>"
            SelectCommand="SELECT * FROM [status]"></asp:SqlDataSource>

and this is for code behind:

C#

protected void Page_Load(object sender, EventArgs e)
{
    //set session to 0 for first page load and empty text box
    if (!Page.IsPostBack)
    {
        Session["id"] = 0;
    }
}

protected void TextChanged(object sender, EventArgs e)
{
    int id = Convert.ToInt32(TextBox1.Text);
    using (var context = new testEntities())
    {
        var status_id = (from a in context.orders where a.order_id == id select a).FirstOrDefault();
        Session["id"] = status_id.status_id;
//here you get the status id and set it to session
    }

}

comment if you have a question!