Not only 100 records it may be more than 100.
yes, am using asp.net gridview.
in that i have to show top 10 customers and 11 record should be sum of balance records i ll put it as other customers

ya am sure ... asnd i solved it .. its because of IIS config.. no got a new problem.. am getting correct output in IE but in crome reports are not viewing properly.cant view the print button and showing buy single column one by one..

Try this

first check the text box is null or empty
then Ist box is not null execute update query for 1 field

ex: update tblename set fname=val

then check 2nd box its not null execute

update tblename set Lname=val

if its null do not execute the query put in else part that's it

ya i used that too while pass the value i added comma's but when it goes to the parameter its as-usual same problem it cannot take any records

my following code to add comma's

string testcode = Request.QueryString["code"].ToString();

            string[] arrcode = testcode.Split(',');



            StringBuilder buildValue = new StringBuilder();

            if (arrcode.Length == 1)
            {
                buildValue.Append(arrcode[0]);

            }
            if (arrcode.Length == 2)
            {
                buildValue.Append(arrcode[0]);

                buildValue.Append("','");

                buildValue.Append(arrcode[1]);

                //obtainedValue = arrcode[0] + "','" + arrcode[1];
            }
            if (arrcode.Length > 2)
            {

                buildValue.Append(arrcode[0]);
                buildValue.Append("'");

                for (int i = 1; i < arrcode.Length - 1; i++)

                    buildValue.Append(",'" + arrcode[i] + "'");

                buildValue.Append(",'");
                buildValue.Append(arrcode[1]);

            }

that code value is come from when i check check box, i have many check box that value is code value

button click--

con.Open();
        HiddenField2.Value = string.Empty;
        TextBox1.Text = "";
        using (cmd = new SqlCommand("select Code ,Desc  from MaterialType where CDM_Active=" + 1 + "order by CDM_MaterialType_Desc", con))
        {

            dr = cmd.ExecuteReader();
            int i = 0;
            while (dr.Read())
            {
                if (((CheckBox)this.FindControl(dr["Code"].ToString())).Checked)
                {

                    if (TextBox1.Text.Length > 0)
                    {
                        //TextBox1.Text = string.Empty;
                        TextBox1.Text += "," + dr["Desc"].ToString();
                        HiddenField2.Value += "," + dr["Code"].ToString();

                    }
                    else
                    {
                        TextBox1.Text = dr["Desc"].ToString();
                        HiddenField2.Value = dr["Code"].ToString();
                    }
                }

            }
        }
        con.Close();

am passing this hidden value in querystring then i aplly to parameter

 cmd.Parameters.AddWithValue("@Materialcode", Request.QueryString["code"].ToString());