How To Clear the rad grid

[mohamed]

how to clear the radgrid .after bind the record

SqlConn = ObjDBHelp.GetOpenConnection();

            DataTable dt1 = new DataTable();
            DataTable dt2 = new DataTable();
            SqlDataAdapter sqladp = new SqlDataAdapter();

            try
            {
                if (showinactive == "0")
                {
                    string selectQuery = "SELECT AssetName, SerialNumber, Asset_UserID,Asset_Inactive FROM [Assets] where Asset_Inactive>0 order by AssetName asc";
                    sqladp.SelectCommand = new SqlCommand(selectQuery, SqlConn);
                    sqladp.Fill(dt1);
                    int i = dt1.Rows.Count;
                    dt1 = null;

                    if (i > 0)
                    {
                        selectQuery = "SELECT a.AssetID,a.AssetName,a.SerialNumber,a.Asset_UserID,b.ppl_Name,a.Asset_Inactive FROM [Assets] a , People b " +
                                      "where a.Asset_UserID=b.PeopleID  order by AssetName asc";
                        sqladp.SelectCommand = new SqlCommand(selectQuery, SqlConn);
                        sqladp.Fill(dt2);
                        GridColumn chkbox = RadGrid1.MasterTableView.GetColumnSafe("Asset_Inactive");
                        chkbox.Visible = true;
                    }
                    else
                    {
                        selectQuery = "SELECT a.AssetID,a.AssetName,a.SerialNumber,a.Asset_UserID,b.ppl_Name,a.Asset_Inactive FROM [Assets] a , People b " +
                                      "where a.Asset_UserID=b.PeopleID  order by AssetName asc";
                        sqladp.SelectCommand = new SqlCommand(selectQuery, SqlConn);
                        sqladp.Fill(dt2);
                        RadGrid1.DataSource = dt2;
                        RadGrid1.DataBind();
                        GridColumn chkbox = RadGrid1.MasterTableView.GetColumnSafe("Asset_Inactive");
                        chkbox.Visible = false;
                    }
                }
                else
                {
                    string selectQuery = "SELECT AssetName, SerialNumber, Asset_UserID,Asset_Inactive FROM [Assets] where Asset_Inactive>0 order by AssetName asc";
                    sqladp.SelectCommand = new SqlCommand(selectQuery, SqlConn);
                    sqladp.Fill(dt1);
                    int i = dt1.Rows.Count;
                    dt1 = null;

                    if (i > 0)
                    {
                        selectQuery = "select  a.AssetID,a.AssetName,a.SerialNumber,a.Asset_UserID,b.ppl_Name,a.Asset_Inactive FROM [Assets] a , People b  " +
                                            "where a.Asset_UserID=b.PeopleID and a.Asset_Inactive=1 order by AssetName asc";
                        sqladp.SelectCommand = new SqlCommand(selectQuery, SqlConn);
                        sqladp.Fill(dt2);
                        showinactive = "0";
                    }
                }
                RadGrid1.DataSource = dt2;
                Session["AssetList"] = dt2;
            }
            finally
            {
                ObjDBHelp.CloseConnection(SqlConn);
                dt2 = null;
            }

Thanks,
Mohamed .

[Princy]

Hello Mohamed,

The following forum thread discusses the same scenario. Check the thread for more details.
Clearing Grid ItemsCollection.

Thanks,
Princy.

[mohamed]

thanks for ur reply.

where i call this
every where i call this value error come .
RadGrid1.DataSource = New String() {}

Thanks,
Mohamed.

[Princy]

Hello Mohamed,

Sorry, the code in the thread was VB version. Try the following code.

C#:

this.RadGrid1.DataSource = new string[0];

Thanks,
Princy.

[mohamed]

Thanks for ur reply princy,

nothing change .

i called this on needdata source

else
                {                    
                    this.RadGrid1.DataSource = new string[0];                    
                    string selectQuery = "SELECT AssetName, SerialNumber, Asset_UserID,Asset_Inactive FROM [Assets] where Asset_Inactive>0 order by AssetName asc";
                    sqladp.SelectCommand = new SqlCommand(selectQuery, SqlConn);
                    sqladp.Fill(dt1);
                    int i = dt1.Rows.Count;
                    dt1 = null;


                    if (i > 0)
                    {
                        selectQuery = "select  a.AssetID,a.AssetName,a.SerialNumber,a.Asset_UserID,b.ppl_Name,a.Asset_Inactive FROM [Assets] a , People b  " +
                                            "where a.Asset_UserID=b.PeopleID and a.Asset_Inactive=1 order by AssetName asc";
                        sqladp.SelectCommand = new SqlCommand(selectQuery, SqlConn);
                        sqladp.Fill(dt2);
                        showinactive = "0";
                    }
                }
                RadGrid1.DataSource = dt2;
                Session["AssetList"] = dt2;

Thanks,
Mohamed.