Questions on UI for ASP.NET AJAX Forum

5 answers

142 views

RadGrid1_ItemCommand Can't get cell value

I have this block of code which worked at the prior version (VS 2010, older RadGrid control). Now I upgraded to VS 2013 and use RadGrid control in version 2013.3.114.45, I can't figure out why I can't get the "ApplicationId" value from e.item.

Please see code below:
private void LoadData()
        {
            if (RadGrid1.Items.Count > 0) RadGrid1.DataSource = new Object[0];            //If Academic year is selected
            if (editAcademicYear.SelectedValue !="Select One")
            {
                var academicyear = (from ay in context.AcademicYears
                                    where ay.Name == editAcademicYear.SelectedValue
                                    select ay).First();
                yearID = academicyear.AcademicYearID;
            }   if (rbLName.Checked)
   {
    if (editSName.Text.Length > 0)
    {
     if (yearID > 0)
     {
      application = from s in context.Applications.Include("AcademicYear")
           where s.LastName.StartsWith(editSName.Text.Trim()) &&
           s.AcademicYear.AcademicYearID == yearID
           orderby s.LastName, s.FirstName
           select s;
     }
     else
     {
      application = from s in context.Applications
           where s.LastName.StartsWith(editSName.Text.Trim())
           orderby s.LastName, s.FirstName
           select s;
     }
     ShowApps(application, application.Count());   //Show data to RadGrid1 for selection.    }
    else
    {
     lblmissing.Visible = true;
     lblmissing.Text = "Please enter the last name.";
     return;
    }
   }
         }

//question: how can I get the value for dataItem below? What is wrong here?
protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
        {

            LoadData();
            //from debugging, I saw "application" value, but I did not see value
              from RadGrid1 or its "items".            try
            {
                if (e.Item.ItemIndex > -1)
                {
                    var dataItem = e.Item as GridDataItem;   //dataItem has no value here
                    string appid = dataItem["ApplicationId"].Text;    //therefore, appid has no value
                    Response.Redirect("DisplayApp.aspx?appid=" + appid);
                }
            }
            catch (Exception ex)
            {
                logger.ErrorException("Could not get appid from the grid row", ex);
                lblMessage.Visible = true;
                RadGrid1.Visible = false;
                lblMessage.Text = "<b>Error exists in the grid level. Please contact the Care Tech Support.</b>";
            }
    }

I have spent a few hours searching, the site is in production, but just can't get the "appid" of the selected row to display the detail page. Your quick response is much appreciated.

Thanks in advance!

Grid

answered on 05 May 2014

1 answer

68 views

Shaping PanelBar data with Underscore

Hi All:

I was working with underscore and figured out that I could reformat the data for the PanelBar control.
Here is my example code:

//

$(function () {

//

var meetingDataSource = new kendo.data.DataSource({

data: [

{ MeetingId: 65, Year: 2014, MeetingDate: '2014-05-14 18:00:00', Title: "30 tools for modern .net web development in 60 minutes" },

{ MeetingId: 64, Year: 2014, MeetingDate: '2014-04-09 18:00:00', Title: "azure websites deep dive" },

{ MeetingId: 63, Year: 2014, MeetingDate: '2014-03-12 18:00:00', Title: "cancelled" },

{ MeetingId: 62, Year: 2014, MeetingDate: '2014-02-12 18:00:00', Title: "getting to know windows azure mobile services" },

{ MeetingId: 60, Year: 2013, MeetingDate: '2013-12-11 18:00:00', Title: "custom graphics for your web application: the html5 canvas and kinetic.js" },

{ MeetingId: 59, Year: 2013, MeetingDate: '2013-11-13 18:00:00', Title: "four platforms. one codebase. xamarin." },

{ MeetingId: 58, Year: 2013, MeetingDate: '2013-10-09 18:00:00', Title: "it’s cheaper than therapy: building an “eliza” psychotherapist app in windows 8" },

{ MeetingId: 57, Year: 2013, MeetingDate: '2013-09-11 18:00:00', Title: "if typescript is the answer, what is the question?" }

]

});

//

meetingDataSource.fetch(function () {

//

var meetings = meetingDataSource.data();

//

var years = _.chain(meetings)

.pluck('Year')

.uniq()

.value();

//

var shapedData = _.reduce(years, function (memo, year) {

var exp = false;

if (memo.length == 0) exp = true;

//

var det = _.chain(meetings)

.filter(function (meeting) { return meeting.Year == year; })

.map(function (meeting) {

var m = meeting;

return { value: m.MeetingId, text: m.Title };

})

.value();

memo.push({ value: year, text: year, expanded: exp, items: det });

return memo;

}, []);

//

$("#inline-listview").kendoPanelBar({

dataSource: shapedData,

expandMode: "single"

}).data("kendoPanelBar");

});

//

});

I read the data with a dataSource fetch command. In the fetch function, I first extract the years for the level 0 of the panel-bar, then I use the years as input for the reduce function and reprocess the input data. The years are the level 0 and the level 1 is the reprocessed data.

Phil

PanelBar

answered on 04 May 2014

6 answers

88 views

Radgrid demo WebUserTemplate not inserting/updating

I have copied as it is this demo but I am unable to insert/update the records.

private static DataTable GetDataTable(string queryString)

{

String connString = ConfigurationManager.ConnectionStrings["NORTHWNDConnectionString"].ConnectionString;

SqlConnection mySqlConnection = new SqlConnection(connString);

SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();

mySqlDataAdapter.SelectCommand = new SqlCommand(queryString, mySqlConnection);

DataTable myDataTable = new DataTable();

mySqlConnection.Open();

try

{

mySqlDataAdapter.Fill(myDataTable);

}

finally

{

mySqlConnection.Close();

}

return myDataTable;

}

private DataTable Employees

{

get

{

object obj = this.Session["Employees"];

if ((!(obj == null)))

{

return ((DataTable)(obj));

}

DataTable myDataTable = new DataTable();

myDataTable = GetDataTable("SELECT * FROM Employees");

this.Session["Employees"] = myDataTable;

return myDataTable;

}

protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)

{

this.RadGrid1.DataSource = this.Employees;

this.Employees.PrimaryKey = new DataColumn[] { this.Employees.Columns["EmployeeID"] };

}

protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e)

{

GridEditableItem editedItem = e.Item as GridEditableItem;

UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);

//Prepare new row to add it in the DataSource

DataRow[] changedRows = this.Employees.Select("EmployeeID = " + editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["EmployeeID"]);

if (changedRows.Length != 1)

{

RadGrid1.Controls.Add(new LiteralControl("Unable to locate the Employee for updating."));

e.Canceled = true;

return;

}

//Update new values

Hashtable newValues = new Hashtable();

newValues["Country"] = (userControl.FindControl("TextBox7") as TextBox).Text;

newValues["City"] = (userControl.FindControl("TextBox8") as TextBox).Text;

newValues["Region"] = (userControl.FindControl("TextBox9") as TextBox).Text;

newValues["HomePhone"] = (userControl.FindControl("HomePhoneBox") as RadMaskedTextBox).Text;

newValues["BirthDate"] = (userControl.FindControl("BirthDatePicker") as RadDatePicker).SelectedDate.ToString();

newValues["TitleOfCourtesy"] = (userControl.FindControl("ddlTOC") as DropDownList).SelectedItem.Value;

newValues["Notes"] = (userControl.FindControl("TextBox1") as TextBox).Text;

newValues["Address"] = (userControl.FindControl("TextBox6") as TextBox).Text;

newValues["FirstName"] = (userControl.FindControl("TextBox2") as TextBox).Text;

newValues["LastName"] = (userControl.FindControl("TextBox3") as TextBox).Text;

newValues["HireDate"] = (userControl.FindControl("HireDatePicker") as RadDatePicker).SelectedDate.ToString();

newValues["Title"] = (userControl.FindControl("TextBox4") as TextBox).Text;

changedRows[0].BeginEdit();

try

{

foreach (DictionaryEntry entry in newValues)

{

changedRows[0][(string)entry.Key] = entry.Value;

}

changedRows[0].EndEdit();

this.Employees.AcceptChanges();

}

catch (Exception ex)

{

changedRows[0].CancelEdit();

Label lblError = new Label();

lblError.Text = "Unable to update Employees. Reason: " + ex.Message;

lblError.ForeColor = System.Drawing.Color.Red;

RadGrid1.Controls.Add(lblError);

e.Canceled = true;

}

protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e)

{

UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);

//Create new row in the DataSource

DataRow newRow = this.Employees.NewRow();

//Insert new values