How could i Add row in server side coding

[Tamim]

Hi,
  I have using RadGrid. In default row set in 5. Assign the more than 5 rows how could i add row

This is my coding its working good but greater then 4 row empty row added previous row value clear.

using (var db = new DoskContractServicesDataContext(Globals.strCon))
            {
                var ClaimAssign = (from a in db.DSProjectMasters
                                   where !db.ProjectSubCons.Any(b => b.ProjectCode == a.ProjectCode && b.status != "DEL" && b.compcode == a.CompCode && b.Subconcode==Subcontractor.SelectedValue) && a.CompCode == compcode && a.FinalStatus == "Cls" && a.Status != "DEL"
                                   select new { a.ProjectCode, a.ProjectTitle,a.DtCommencement,a.DtCompletion,a.ContractAmount }).ToList();
                for (int i = 0; i <= RadGrid1.MasterTableView.Items.Count - 1; i++)
                {
                    Label SNO = (Label)RadGrid1.MasterTableView.Items[i].FindControl("Sno");
                    RadTextBox ProjectID = (RadTextBox)RadGrid1.MasterTableView.Items[i].FindControl("ProjectID");
                    RadTextBox ProjectTitle = (RadTextBox)RadGrid1.MasterTableView.Items[i].FindControl("ProjectTitle");
                    Label claimnostart = (Label)RadGrid1.MasterTableView.Items[i].FindControl("claimnostart");
                    RadDatePicker RadDatePicker1 = (RadDatePicker)RadGrid1.MasterTableView.Items[i].FindControl("Mainprojectcommencement");
                    RadDatePicker RadDatePicker2 = (RadDatePicker)RadGrid1.MasterTableView.Items[i].FindControl("MainprojectCompletion");
                    HiddenField MainContractAmount = (HiddenField)RadGrid1.MasterTableView.Items[i].FindControl("MainContractAmount");

                    if (ClaimAssign.Count() > i)
                    {
                        SNO.Text = Convert.ToString(i + 1);
                        ProjectID.Text = ClaimAssign[i].ProjectCode.ToString();
                        ProjectTitle.Text = ClaimAssign[i].ProjectTitle.ToString();
                        RadDatePicker1.SelectedDate = ClaimAssign[i].DtCommencement;
                        RadDatePicker2.SelectedDate = ClaimAssign[i].DtCompletion;
                        MainContractAmount.Value = ClaimAssign[i].ContractAmount.ToString();
                        claimnostart.Text = ClaimAssign[i].ProjectCode.ToString() + "/" + compcode + "/" + "PCL";
                        if (i >= 4)
                            addrow(i);
                    }
                }
            }

 private void addrow(int currow)
        {
            object[] emptyRow = new object[columcount];
            tabledata1 = null;
            DataTable dt = tabledata1;
            assigndt2(dt);
            dt.Rows.Add(emptyRow);
            RadGrid1.DataSource = dt;
            RadGrid1.DataBind();
        }

private void assigndt2(DataTable dt)
        {
            RadTextBox r1;
            RadNumericTextBox rn1;
            CheckBox c1;
            Label l1;
            HiddenField h1;
            RadDatePicker d1;

            for (int i = 0; i <= RadGrid1.Items.Count - 1; i++)
            {
                if (dt.Rows.Count - 1 < i)
                {
                    object[] emptyRow = new object[columcount];
                    dt.Rows.Add(emptyRow);
                }
                //c1 = (CheckBox)RadGrid1.Items[i].FindControl("active");
                //dt.Rows[i]["active"] = c1.Text;
                l1 = (Label)RadGrid1.Items[i].FindControl("Sno");
                dt.Rows[i]["Sno"] = l1.Text;
                r1 = (RadTextBox)RadGrid1.Items[i].FindControl("ProjectID");
                dt.Rows[i]["ProjectID"] = r1.Text;
                r1 = (RadTextBox)RadGrid1.Items[i].FindControl("ProjectTitle");
                dt.Rows[i]["ProjectTitle"] = r1.Text;
                r1 = (RadTextBox)RadGrid1.Items[i].FindControl("Subcontitle");
                dt.Rows[i]["Subcontitle"] = r1.Text;
                d1 = (RadDatePicker)RadGrid1.Items[i].FindControl("DateofCommencement");
                dt.Rows[i]["DateofCommencement"] = d1.SelectedDate;
                d1 = (RadDatePicker)RadGrid1.Items[i].FindControl("Mainprojectcommencement");
                dt.Rows[i]["Mainprojectcommencement"] = d1.SelectedDate;
                d1 = (RadDatePicker)RadGrid1.Items[i].FindControl("DateofCompletion");
                dt.Rows[i]["DateofCompletion"] = d1.SelectedDate;
                d1 = (RadDatePicker)RadGrid1.Items[i].FindControl("MainprojectCompletion");
                dt.Rows[i]["MainprojectCompletion"] = d1.SelectedDate;
                rn1 = (RadNumericTextBox)RadGrid1.Items[i].FindControl("ContractAmount");
                dt.Rows[i]["ContractAmount"] = rn1.Text;
                h1 = (HiddenField)RadGrid1.Items[i].FindControl("MainContractAmount");
                dt.Rows[i]["MainContractAmount"] = h1.Value;
                rn1 = (RadNumericTextBox)RadGrid1.Items[i].FindControl("LD");
                dt.Rows[i]["LD"] = rn1.Text;
                d1 = (RadDatePicker)RadGrid1.Items[i].FindControl("tentativedate");
                dt.Rows[i]["tentativedate"] = d1.SelectedDate;
                l1 = (Label)RadGrid1.Items[i].FindControl("claimnostart");
                dt.Rows[i]["claimnostart"] = l1.Text;
                rn1 = (RadNumericTextBox)RadGrid1.Items[i].FindControl("autoclaimno");
                dt.Rows[i]["autoclaimno"] = rn1.Text;
                rn1 = (RadNumericTextBox)RadGrid1.Items[i].FindControl("paymentcert");
                dt.Rows[i]["paymentcert"] = rn1.Text;
            }
        }


Thanks & Advance
Ansari.

[Eyup]

Hi Ansari,

Please note that using DataBind() is not recommended. Performing complex grid operations such as Inserting, Deleting, Updating, Hierarchy relations, grouping, Paging, Sorting, Filtering require accommodating appropriate database operations.  Therefore, we suggest you to avoid Simple Databinding and strongly recommend the use of more advanced databinding methods, which automatically handle the aforementioned functions:
Declarative DataSource
Advanced Data Binding

Hope this helps. Please give it a try and let me know about the result.

Regards,
Eyup
the Telerik team