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 .

Hi All,

  I have two Rad listboxes on my web page. I can move the items from one list box. when I transfer the items from lefts side listbox to right side one, the value from left listbox are gone to the right listbox so everthing is working as I want it to be. when I save the listbox with the selected value and display the listbox again after running the web site again, the values that I selected are shown on the right side, but the same values are also shown on the left side. Is their any way I can exclude the values that are on the right side of the listbox not to be displayed on the left side of the listbox.

I'm using this control in a webpart and I can upload a file with no problem but if I try to delete or create a new folder the events do not fire.

I've already configured the control as shown in this blog post and I can not make this work.

Can anyone please help me with this issue?

Best Regards,

Hi

I am attaching a image. I want to do similarly using Radchart control. Is it possible to do?

Regards
Arima

Hi,

I'm having a problem with RadCharts. When I try to display a chart with around 50 rows of data, the loading image stays in the middle of the chart even if the chart is already completed loading as shown in the attached image.

Anyone? thanks.

Hi All,

I am using rad grid with filtering (AllowFilteringByColumn="true").
I have "GridDateTimeColumn" with header filter.
What I want to do is to highlight the current date in calendar of grid filter date picker.
How can I do this?
I have used following to access the date picker, But it did not work.

Please give me a solution.

Thanks & Regards,
Madu

Hi,

I have a chart that can have small values, say 1 or 2, but it can go up to the hundreds as well. This is dynamic total data and there is no defined upper limit to this, but they are all integer. I've noticed that for these small values, the RadChart seems to insert some intermediate values into the series even if there are no such values in the DataTable datasource. Is there a way to prevent RadChart from doing this?

Attached is a sample screenshot of the intermediate values inserted. Only the value 2 is set in the datasource, we can live with the value "1" but none of those having decimal places. Any assistance on this would be greatly appreciated. Thanks!

Hi 
i have a problem with this code in a master page.  
<link href="<%=ResolveUrl("~/App_Themes/SkinSistema.css")%>" rel="stylesheet" type="text/css" />

before telerik, this work perfectly, but i have incorporate telerik RadScriptManager and then does not work.
this is my error:
"La colección de controles no puede modificarse porque el control contiene bloques de código (por ej. <% ... %>)."

i need help.
thk

Hi there, im trying the telerik controls, and i wanted to know if is possible to trigger an alert after uploading a file in edititem template.


this is my code-behind




And this is my javascript which is quite simple.

Im using radajaxmanager to ajaxified radgrid.


any help would be appreciated.


regards

HI

Is it possible to create a news paper style in the editor without using tables and have the entire text equaly divided over the columns? In css3 this should be possible by multi-column us but not many browsers support this yet I think. Hope anybody can help me with this.