Questions on UI for ASP.NET AJAX Forum

3 answers

153 views

Hi,

I was trying to RadListBox LoadOnDemand feature. I was creating the RadListBox and setting EnableLoadOnDemand property dynamically/programatically. I gave it a DataSource and called DataBind on it. But, It loads all the data in it instead of doing the LoadOnDemand. Am i missing something?

Thanks in advance!!!

ListBox

answered on 25 Mar 2011

1 answer

91 views

Custom EditForm Not Updating

I have a series of stored procedures created to handle the Select, Insert, Update and Delete needs of the system. Many of the columns are dynamically driven. The delete functionality works perfectly but Update is throwing me some odd issues and I'm not certain where I've made my mistakes. Any direction would be helpful.

The Problem:
When you click Edit the form comes up correctly (See awardgrid-edit.jpg) with even the ItemID on the top indicating I have the appropriate record correlating to the database ID. However when you click the Update button the AJAX does a post back and the Edit field is empty and the button for the [Update] now has no text (See awardgrid-afterupdate.jpg).

The ASPX Page Snippet

<telerik:radscriptmanager ID="RadScriptManager1" Runat="server">

</telerik:radscriptmanager>

<uc1:Awards ID="Awards1" runat="server" />

Awards User Control Snippet (ASCX)

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="rgProfileItem">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="rgProfileItem" LoadingPanelID="RadAjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Skin="Windows7" EnableSkinTransparency="true" runat="server" />

<telerik:RadGrid ID="rgProfileItem" runat="server"

AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True"

GridLines="None" Skin="Windows7"

OnItemDataBound="rgProfileItem_ItemDataBound" OnInsertCommand="rgProfileItem_InsertCommand"

OnDeleteCommand="rgProfileItem_DeleteCommand" OnUpdateCommand="rgProfileItem_UpdateCommand"

onneeddatasource="rgProfileItem_NeedDataSource" AllowAutomaticUpdates="false" AllowAutomaticInserts="false">

<MasterTableView AutoGenerateColumns="False" AllowAutomaticInserts="false" AllowAutomaticUpdates="false"

DataKeyNames="ItemID" EditMode="EditForms">

<Columns>

<telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="Edit">

<HeaderStyle Width="20px" />

</telerik:GridEditCommandColumn>

<telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete"

ImageUrl="~/images/delete-16x16.png" Text="Delete" UniqueName="Delete">

<HeaderStyle Width="20px" />

</telerik:GridButtonColumn>

<telerik:GridBoundColumn DataField="Title"

FilterControlAltText="Filter Title column" HeaderText="Title"

SortExpression="Title" UniqueName="Title">

<HeaderStyle Width="30%" />

</telerik:GridBoundColumn>

<telerik:GridDateTimeColumn DataField="DateReceived"

FilterControlAltText="Filter DateReceived column" HeaderText="Date Received"

SortExpression="DateReceived" UniqueName="DateReceived"

DataType="System.DateTime">

<HeaderStyle Width="150px" />

</telerik:GridDateTimeColumn>

<telerik:GridTemplateColumn DataField="Notes"

FilterControlAltText="Filter Notes column" Groupable="False" HeaderText="Notes"

UniqueName="Notes">

<ItemTemplate>

<asp:Label ID="shortNote" runat="server" Text='<%# Eval("Notes") %>' />

<asp:Label ID="longNote" runat="server" Visible="false" Text='<%# Eval("Notes") %>' />

<telerik:RadToolTip ID="RadToolTip1" runat="server"

Skin="Windows7" RelativeTo="Element" Width="400px" CssClass="infotooltip" Position="TopCenter" TargetControlID="shortNote">

<%# Eval("Notes") %>

</telerik:RadToolTip>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

<EditFormSettings InsertCaption="Add new item" CaptionFormatString="Edit Item: {0}"

CaptionDataField="ItemID" EditFormType="Template" PopUpSettings-Modal="true" PopUpSettings-Width="600px">

<EditColumn UniqueName="EditCommandColumn1" FilterControlAltText="Filter EditCommandColumn1 column"></EditColumn>

<FormTemplate>

<asp:Table ID="pubForm" CssClass="pubForm" CellSpacing="0" CellPadding="2" runat="server">

<asp:TableFooterRow>

<asp:TableCell ColumnSpan="2">

<asp:Button ID="Button1" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'

runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'>

</asp:Button>

<asp:Button ID="Button2" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel">

</asp:Button>

</asp:TableCell>

</asp:TableFooterRow>

</asp:Table>

</FormTemplate>

</EditFormSettings>

</MasterTableView>

<FilterMenu EnableImageSprites="False"></FilterMenu>

<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>

</telerik:RadGrid>

Awards User Control Code Behind (ASCX.CS)

int maxFieldLength = 100;

 int itemTypeID = 2; //ID item for Awards/Honors

 SqlConnection cn = new SqlConnection(CONNSTRINGINFO);

 protected void Page_Load(object sender, EventArgs e)

 {

 }



 protected void rgProfileItem_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)

 {

 SqlDataAdapter adapter = new SqlDataAdapter();

 adapter.SelectCommand = new SqlCommand("sp_getProfileItem", cn);

 adapter.SelectCommand.CommandType = CommandType.StoredProcedure;

 adapter.SelectCommand.Parameters.AddWithValue("@ProfileItemTypeId", itemTypeID);

 if (!string.IsNullOrEmpty(Request.QueryString["uid"]))

 {

 adapter.SelectCommand.Parameters.AddWithValue("@PersonID", Request.QueryString["uid"]);

 }

 DataTable myDataTable = new DataTable();

 cn.Open();

 try

 {

 adapter.Fill(myDataTable);

 }

 finally

 {

 cn.Close();

 }

 rgProfileItem.DataSource = myDataTable;

 }

 protected void rgProfileItem_ItemDataBound(object sender, GridItemEventArgs e)

 {

 if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem)

 {

 Label target = (Label)e.Item.FindControl("shortNote");

 if (!Object.Equals(target, null))

 {

 if (target.Text.Length > maxFieldLength)

 {

 target.Text = target.Text.Substring(0, maxFieldLength) + " ...";

 }

 }

 }

 if (e.Item is GridEditFormItem && (e.Item as GridEditableItem).IsInEditMode)

 {

 GridEditableItem editedItem = (GridEditableItem)e.Item;

 string ItemID = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["ItemID"].ToString();

 Table editFormTable = (Table)editedItem.FindControl("pubForm");

 LoadProfileFields(int.Parse(ItemID), editFormTable);

 }



 }



 protected void rgProfileItem_DeleteCommand(object sender, GridCommandEventArgs e)

 {

 //Delete Function

 cn.Open();

 GridDataItem item = (GridDataItem)e.Item;

 try

 {

 SqlCommand comm = new SqlCommand("sp_deleteProfileItem", cn);

 comm.CommandType = CommandType.StoredProcedure;

 comm.Parameters.AddWithValue("@ItemID", item.GetDataKeyValue("ItemID"));

 comm.ExecuteNonQuery();

 comm.Dispose();

 }

 catch (Exception ex)

 {

 lblErrMsg.Text = "<br />" + ex.Message;

 }

 finally

 {

 //lblErrMsg.Text = "Deleted " + item.GetDataKeyValue("ItemID");;

 cn.Close();

 }

 }



 protected void rgProfileItem_UpdateCommand(object sender, GridCommandEventArgs e)

 {



 DataTable dtProfileInfo = new DataTable();

 //Get the GridEditableItem of the RadGrid

 GridEditableItem editedItem = e.Item as GridEditableItem;

 string ItemID = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["ItemID"].ToString();



 cn.Open();

 try

 {

 string profInfo = ""; //A placeholder for the dynamic fields Profile Information uses

 string strProcName = "sp_updateProfileItem";



 //Get the DataTable of all Publication Fields

 dtProfileInfo = getProfileInfoFields();

 foreach (DataRow dr in dtProfileInfo.Rows)

 {

 //It is important to note that the stored procedure is expecting all rows to be seperated by a | and fields seperated by a =.

 //These symbols were used because they are not 'common place' and should not throw erroneous data.

 profInfo += dr["FieldID"] + "=" + getDynamicField(stripText(dr["FieldName"].ToString())) + "|";

 }

 if (profInfo.Length > 0)

 {

 profInfo = profInfo.Substring(0, profInfo.Length - 1); //Remove the last | symbol

 }



 SqlCommand comm = new SqlCommand(strProcName, cn);

 comm.CommandType = CommandType.StoredProcedure;

 comm.Parameters.AddWithValue("@ItemType", itemTypeID); //Item Type ID

 comm.Parameters.AddWithValue("@ItemInfo", profInfo); //String of dynamic field values

 comm.Parameters.AddWithValue("@ProfileItem", ItemID); //ItemID

 comm.ExecuteNonQuery();

 rgProfileItem.Rebind();

 editedItem.Edit = false;

 }

 catch (Exception ex)

 {

 rgProfileItem.Controls.Add(new LiteralControl("Unable to update Item. Reason: " + ex.Message));

 e.Canceled = true;

 }

 finally

 {

 cn.Close();

 }



 }



 protected void rgProfileItem_InsertCommand(object source, GridCommandEventArgs e)

 {

 }



 private void LoadProfileFields(int ItemID,Table formTable)

 {

 //Based on the Profile Item Type, determine and add what fields are neccessary.

 SqlCommand comm = new SqlCommand("sp_getProfileItemFieldsByType", cn);

 comm.CommandType = CommandType.StoredProcedure;

 comm.Parameters.AddWithValue("@ItemTypeID", itemTypeID);

 string tmpFieldValue = "";

 int rowInsertAt = formTable.Rows.Count - 1;



 if (ItemID != null && ItemID > 0)

 {

 comm.Parameters.Add("@ItemID", ItemID);

 }

 SqlDataAdapter fieldTypeAdapter = new SqlDataAdapter(comm);



 DataTable fieldTypeDataTable = new DataTable();

 fieldTypeAdapter.Fill(fieldTypeDataTable);



 foreach (DataRow fieldTypeDataRow in fieldTypeDataTable.Rows)

 {

 tmpFieldValue = "";

 try

 {

 bool isRequired = false;

 if (fieldTypeDataRow["Required"].ToString().Trim().ToLower() == "true")

 {

 isRequired = true;

 }

 tmpFieldValue = fieldTypeDataRow["FieldValue"].ToString();

 rowInsertAt = formTable.Rows.Count - 1;



 switch (fieldTypeDataRow["FieldType"].ToString())

 {

 case "Date":

 formTable.Rows.AddAt(rowInsertAt,AddRow_Datebox(fieldTypeDataRow["FieldName"].ToString(), tmpFieldValue, isRequired));

 break;

 case "Textarea":

 formTable.Rows.AddAt(rowInsertAt, AddRow_Textarea(fieldTypeDataRow["FieldName"].ToString(), tmpFieldValue, isRequired));

 break;

 default:

 //By Default everything is a single-line text box.

 formTable.Rows.AddAt(rowInsertAt,AddRow_Textbox(fieldTypeDataRow["FieldName"].ToString(), tmpFieldValue, isRequired));

 break;

 }

 }

 catch

 {

 lblErrMsg.Text += "Field Broke!! ";

 }

 }



 }



 private DataTable getProfileInfoFields()

 {

 SqlCommand comm = new SqlCommand("sp_getProfileItemFieldsByType", cn);

 comm.CommandType = CommandType.StoredProcedure;



 if (itemTypeID > 0)

 {

 comm.Parameters.Add("@ItemTypeID", itemTypeID);

 }

 else

 {

 return null;

 }

 SqlDataAdapter adapter = new SqlDataAdapter(comm);



 DataTable dataTable = new DataTable();

 adapter.Fill(dataTable);

 return dataTable;

 }



 private TableRow AddRow_Textbox(string rowField, string defaultValue, bool isRequired)

 {

 TableRow tr = new TableRow();

 TableCell tcLabel = new TableCell();

 TableCell tcField = new TableCell();



 tcLabel.CssClass = "label";

 tcLabel.Text = rowField;



 RadTextBox rtb = new RadTextBox();

 rtb.Skin = "Windows7";

 rtb.Width = 230;

 rtb.ID = stripText(rowField);

 rtb.Text = defaultValue.Trim();

 tcField.Controls.Add(rtb);

 if (isRequired)

 {

 RequiredFieldValidator rfv = new RequiredFieldValidator();

 rfv.ControlToValidate = rtb.ID;

 rfv.ErrorMessage = "You must fill out this field";

 rfv.CssClass = "validator";

 rfv.ValidationGroup = "PublicationFields";

 tcField.Controls.Add(rfv);

 tcLabel.Text += "<span class=\"required-field\">*";

 }



 tr.Cells.Add(tcLabel);

 tr.Cells.Add(tcField);



 //int rowInsertAt = pubForm.Rows.Count - 1;

 //pubForm.Rows.AddAt(rowInsertAt, tr);

 return tr;

 }



 private TableRow AddRow_Datebox(string rowField, string defaultValue, bool isRequired)

 {

 TableRow tr = new TableRow();

 TableCell tcLabel = new TableCell();

 TableCell tcField = new TableCell();

 DateTime dr;



 tcLabel.CssClass = "label";

 tcLabel.Text = rowField;



 RadDateInput rdi = new RadDateInput();

 rdi.DateFormat = "d";

 rdi.Skin = "Windows7";

 rdi.Width = 230;

 rdi.ID = stripText(rowField);

 if (DateTime.TryParse(defaultValue, out dr))

 {

 rdi.SelectedDate = dr;

 }

 tcField.Controls.Add(rdi);

 if (isRequired)

 {

 RequiredFieldValidator rfv = new RequiredFieldValidator();

 rfv.ControlToValidate = rdi.ID;

 rfv.ErrorMessage = "You must fill out this field";

 rfv.Display = ValidatorDisplay.Dynamic;

 rfv.CssClass = "validator";

 rfv.ValidationGroup = "PublicationFields";

 tcField.Controls.Add(rfv);

 tcLabel.Text += "<span class=\"required-field\">*";

 }



 tr.Cells.Add(tcLabel);

 tr.Cells.Add(tcField);



 //int rowInsertAt = pubForm.Rows.Count - 1;

 //pubForm.Rows.AddAt(rowInsertAt, tr);

 return tr;

 }



 private TableRow AddRow_Textarea(string rowField, string defaultValue, bool isRequired)

 {

 TableRow tr = new TableRow();

 TableCell tcLabel = new TableCell();

 TableCell tcField = new TableCell();



 tcLabel.CssClass = "label";

 tcLabel.Text = rowField;



 RadEditor rtb = new RadEditor();



 rtb.Skin = "Windows7";

 rtb.ToolbarMode = EditorToolbarMode.ShowOnFocus;

 rtb.SkinID = "DefaultSetOfTools";

 rtb.ToolsFile = "~/App_Data/ToolsFile.xml";

 rtb.Width = 500;

 rtb.Height = 200;



 string[] imagePath = {"~/Editor/Img/UserDir/Marketing,~/Editor/Img/UserDir/PublicRelations"};

 rtb.ImageManager.ViewPaths = imagePath;

 rtb.ImageManager.UploadPaths = imagePath;

 rtb.ID = stripText(rowField);

 rtb.Content = defaultValue;

 tcField.CssClass = "field_onTop";

 tcField.Controls.Add(rtb);

 if (isRequired)

 {

 RequiredFieldValidator rfv = new RequiredFieldValidator();

 rfv.ControlToValidate = rtb.ID;

 rfv.ErrorMessage = "You must fill out this field";

 rfv.CssClass = "validator";

 rfv.ValidationGroup = "ProfileFields";

 tcField.Controls.Add(rfv);

 tcLabel.Text += "<span class=\"required-field\">*";

 }



 tr.Cells.Add(tcLabel);

 tr.Cells.Add(tcField);



 //int rowInsertAt = pubForm.Rows.Count - 1;

 //pubForm.Rows.AddAt(rowInsertAt, tr);

 return tr;

 }



 private string stripText(string toStrip)

 {

 string pattern = "[^\\w\\.@-]";

 Regex rgx = new Regex(pattern);

 return rgx.Replace(toStrip, "");

 }



 private Control FindControlRecursive(Control root, string id)

 {

 if (root.ID == id)

 {

 return root;

 }



 foreach (Control c in root.Controls)

 {

 Control t = FindControlRecursive(c, id);

 if (t != null)

 {

 return t;

 }

 }



 return null;

 }

 private string getDynamicField(string controlID)

 {

 string fieldValue = "";

 Control fieldControl = FindControlRecursive(Page, controlID);

 if (fieldControl != null)

 {

 string tmpTypeBox = fieldControl.GetType().Name;

 switch (tmpTypeBox)

 {

 case "RadTextBox":

 RadTextBox tmpTextControl = (RadTextBox)fieldControl;

 fieldValue = tmpTextControl.Text;

 break;

 case "RadDateInput":

 RadDateInput tmpDateControl = (RadDateInput)fieldControl;

 if (tmpDateControl.SelectedDate.HasValue)

 {

 fieldValue = tmpDateControl.DbSelectedDate.ToString().Split(' ')[0];

 }

 else

 {

 fieldValue = "";

 }

 break;

 }

 }

 else

 {

 lblErrMsg.Text = "Could not find the control ID for " + controlID;

 }



 return fieldValue;

 }

Grid

answered on 25 Mar 2011

3 answers

151 views

Combo Custom Attribute

Hi All

I am currently using the method below to poulate a combobox on the page load event:

Dim dataAdapter as new SetTableAdapter.someidentityTableAdapter

Dim adapterTable as DataTable

adapterTable = dataAdapter.getData()

Radcombo1.DataValueField = "Value1"

Radcombo1.DataTextField = "Value2"

Radcombo1.DataSource = adapterTable

Radcombo1.DataBind()

I would like to add a custom attribute to this combo box,
I am able to achive this in a load on demand senario but not the senario above!
Would someone be kind enough to point me in the right direction on how to achive this please?

Also when using custom attributes in this way is it still only possible to get the attributes value client side?

Many Thanks

Regards

Darren

ComboBox

answered on 25 Mar 2011

1 answer

81 views

Error Installing Q1 2011

Hi,

Previously, I've Q3 2010 installed on my machine. Everything worked well.
Now I am about to install Q1 2011 but failed with the following error message:

There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor.

I am attaching 2 files:
- error screen shot
- log file screen shot

Here's my environment:
- Windows 7 x64
- VS 2010 with .NET 4

Please advise.

Installer and VS Extensions

answered on 25 Mar 2011

1 answer

149 views

Possible To Avoid Internal Caching (force async postback)?

I have a FileExplorer on a page with a very short logout period.

The problem is, when people are logged out, they are still able to click around the FileExplorers folders so long as they have visited the folders recently (the internal caching of the FileExplorer doesn't make another trip to the server).

Is it possible to have the FileExplorer not cache it's lists of flies, and ask the server when a folder is selected for the current list of files in that folder?

FileExplorer

answered on 25 Mar 2011

2 answers

84 views

Change header text property into hierarchical datagrid

Hello,

I've try to change the HeaderText property into hierarchical datagrid (DetailTable) but I can't change it.

This is my code:

   protected void RG1_DetailTableDataBind(object source, GridDetailTableDataBindEventArgs e)
   {
   switch (e.DetailTableView.Name)
   {
   case "DeviceID":

   break;

   default:
   break;
   }
   }

Do you have others solutions?

Grid

answered on 25 Mar 2011

1 answer

178 views

Telerik Skinning Problem

Hello,
i am using "RadControls_for_ASP.NET_AJAX_2008_2_826_dev". Suddenly few days before i faced a problem with the telerik skin. Skin doesn't show in run time and also functionality doesn't work in run time. i uninstalled it and again installed it but the problem is still there. When i browse the ASP.net page in Visual Studio 2008 by internal browser then a error message prompt (attached file - ajax_error.jpg).i attach another image for radcalender with the skin problem.. any body help me please

SkinManager

answered on 25 Mar 2011

1 answer

75 views

RadButton and Blackberry browser

Hi there,

It looks like the standard RadButton is not clickable on blackberry browser. Are you guys going supporting blackberry browser at all and if not, do you know a work around?

Thanks.

Button

answered on 25 Mar 2011

1 answer

66 views

Information about error message received when trying to edit records in pop up edit forms

A property named 'TextBox2' was not found on the entity during an insert, update, or delete operation. Check to ensure that properties specified as binding expressions are available to the data source.

I have a pop-up edit form that I use to edit data. I am able to pull up the form and after I make changes to a text box item in the form, this is message I receive when I click the forms update button.

It seems that I must expose these textboxes to the Data Source that I created, but I am not sure how to do it, or even if this is the action that the data sources is asking me to do.

Any ideas, or information would be very helpful. Been reading the forums and viewing demos, but did not find a post or demo that explained how to do this.

Thanks!

Grid

answered on 25 Mar 2011

3 answers

304 views

RadGrid Edit Form Not Closing

I am trying to close the edit form of this RadGrid:

<telerik:RadGrid ID="rgAccountRangeSet" runat="server"

AutoGenerateColumns="False" GridLines="None" AllowAutomaticDeletes="True"

AllowAutomaticInserts="True" AllowAutomaticUpdates="True"

PageSize="25" AllowPaging="True" AllowSorting="True" >

<PagerStyle Mode="NumericPages" />

<MasterTableView AutoGenerateColumns="False" CommandItemDisplay="Top" CommandItemSettings-ShowRefreshButton="False"

HorizontalAlign="NotSet" DataKeyNames="Id">

<CommandItemSettings AddNewRecordText="Add New Account Range" AddNewRecordImageUrl="~/images/Keymaster/add.gif"/>

<NoRecordsTemplate>

<center>No records available</center>

</NoRecordsTemplate>

<Columns>

</Columns>

<EditFormSettings>

<EditColumn ButtonType="PushButton" />

</EditFormSettings>

</MasterTableView>

</telerik:RadGrid>

With the following code:

Private Sub rgAccountRangeSet_InsertCommand(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles rgAccountRangeSet.InsertCommand

'code to handle insert items has been removed

rgAccountRangeSet.Rebind()

rgAccountRangeSet.MasterTableView.IsItemInserted = False

End Sub

However, I am getting an exception. When I remove "IsItemInserted = False" assignment, the exception goes away. I also want to mention that I am opening the page in certain scenarios with "IsItemInserted = True" with no problem. The grid opens fine and displays the edit form. Any ideas?

Thanks in advance!!

Grid

answered on 25 Mar 2011