checkbox list should not display error if any checkbox is seletected inbetween and if last one is not selected.

Question

0.00/5 (No votes)

See more:

Hi ,

I am using a list of checkbox and i am having a text box to assign scores to only those lines whoses corresponding checkbox is selected.. i have got a loop and i am checking each row if checkbox is checked and if checked then only assign score else i am displaying error as please select checkbox!! this works correctly but if inbetween say 1st row and 5th row checkbox is checked of the 7 checkboxes... then still it shows error please select checkbox... how can i overcome this issue... coding is as follows:

string maxcount = (hdgrdcount.Value);
int grdmaxcnt = Convert.ToInt32(maxcount);
con.Open();
if (txtassignscr.Text == "" || txtassignscr.Text == null)
{
    lblerrassign.Text = "Enter a score!";
}
else
{
    for (int i = 0; i < grdmaxcnt; i++)
    {
        TextBox gettxtscore = (TextBox)grdscore.Rows[i].FindControl("txtSetScore");
        bool isChecked = ((CheckBox)grdscore.Rows[i].FindControl("chkSelect")).Checked;
        Label refer = ((Label)grdscore.Rows[i].FindControl("refURL"));
        string refurl = refer.Text;
        if (isChecked)
        {
            gettxtscore.Text = txtassignscr.Text;
            string checkquery = "select score from tbl_Score where DataSourceId='" + ddldatasource.SelectedItem.Value + "' and ImportFileId='" + ddltablename.SelectedItem.Value + "' and ColumnName='" + ddlcolumnname.SelectedValue + "' and ColumnValue='" + refurl + "' and MMUserId='" + Session["AdminId"] + "'";
            DataSet dscorexists = Main.BindGridSearch(checkquery);
            if (dscorexists.Tables[0].Rows.Count != 0 && dscorexists.Tables[0].Rows.Count != null)
            {
                string querynew = "update tbl_Score SET  Score='" + gettxtscore.Text + "' where DataSourceId='" + ddldatasource.SelectedItem.Value + "' and ImportFileId='" + ddltablename.SelectedItem.Value + "' and ColumnName='" + ddlcolumnname.SelectedValue + "' and ColumnValue='" + refurl + "' and MMUserId='" + Session["AdminId"] + "'";
                if (Main.CommanDB(querynew) == 0)
                {
                    lblerrassign.Text = "Assigned values successfully!";
                }
            }
            else
            {
                string query = "INSERT INTO tbl_Score(DataSourceId,ImportFileId,ColumnName,ColumnValue,TrafficType,Score,MMUserId)VALUES ('" + ddldatasource.SelectedItem.Value + "','" + ddltablename.SelectedItem.Value + "','" + ddlcolumnname.SelectedValue + "', '" + refurl + "','', '" + gettxtscore.Text + "','" + Session["AdminId"] + "' )";
                SqlCommand cmd1 = new SqlCommand(query, con);
                cmd1.ExecuteNonQuery();
                lblerrassign.Text = "Assigned values successfully!";
            }
        }
        else
        {
            lblerrassign.Text = "Please select any checkbox!";
        }
    }
}

please help!!

thanking u in advance!!

Posted 21-Mar-13 3:26am

Shruthi.BT

Add a Solution

2 solutions

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)

InjectionWatcher · Answer 1 · 2013-03-21T04:15:00

The error is probably in this line:

bool isChecked = ((CheckBox)grdscore.Rows[i].FindControl("chkSelect")).Checked;

Have you checked to see if it is actually finding the checkbox?

Are you using Web Forms? Master pages?

Also, please don't concatenate strings to send to a database:

"select score from tbl_Score where DataSourceId='" + ddldatasource.SelectedItem.Value

Use parameterized queries. They aren't much more difficult and will save you from SQL Injection attacks.

Shruthi.BT · Answer 2 · 2013-05-06T00:10:00

Solution 2

I solved the issue by using flag like this:

If any checkbox checked flag == 1

then while displaying error message will check if flag== 1 if yes then no error message else
i am displaying error message.

Posted 6-May-13 0:10am