Using listview datakeyname for listbox parameter

jrobbins

I have managed to put a listbox in my listview and have gotten the box to appear but it is empty. I want to click on the Edit link and based on the datakeyname value pass the parameter to the objectdatasource to fill the listbox. I'm trying to use IEnumerable and am not getting it. Can someone help with an understandable example. Or another way to do it.

I'm at a loss to what I am to return (see ??? ) and it doesn't like my (SqlInt32 PersonnelNumber) telling me it can't convert to "SqlInt32? (in my EmployeeObject)" -

Expand|Select|Wrap|Line Numbers

 
public IEnumerable<AuthorizationObjectClass> GetEmployeeNoAuthorizations(SqlInt32 PersonnelNumber)

        {

            DataSet ds;

            AuthorizationObjectClass auth = new AuthorizationObjectClass();

            try

            {

                //EmployeeObjectClass Emp = new EmployeeObjectClass();

                Emp.PersonnelNumber = PersonnelNumber;

                ds = data.GetNotSelectedAuthorizations(Emp);

                if (ds.Tables.Count > 0)

                {

                    auth.AuthorizationID = Convert.ToInt32(ds.Tables[0].Rows[0]["AuthorizationID"]);

                    auth.AuthorizationDefinition = Convert.ToString(ds.Tables[0].Rows[0]["AuthorizationDescription"]);

                }

            }

            catch (Exception e)

            {

                Console.WriteLine("{0} Exception caught.", e);

            }

            return  ???? ;

        }

tlhintoq

and it doesn't like my (SqlInt32 PersonnelNumber) telling me it can't convert to "SqlInt32? (in my EmployeeObject)"

I'm guessing the SqlInt32 is a single item from within the Employee object..

If your return type is the SqlInt32, don't try to return the entire employee object: return just the ID number .... return myEmployeeObject.PersonnelNumber;

If you want to return the entire EmployeeObject, then change your return type from a SqlInt32 to an EmployeeObject type.... return myEmployeeObject;

jrobbins

Can someone please tell me how to get a listbox to populate inside a listview when the Edit button is clicked based on either a hidden field or the datakeynames

jrobbins

[quote]I was able to retrieve my id field; but when I try to bind results to listbox (NOAUTH), my listbox is showing as null and won't allow the binding. Any ideas?

QUOTE]

Expand|Select|Wrap|Line Numbers

   protected void lvSearchResults_ItemEditing(Object sender, ListViewEditEventArgs e)

    {
 
        string id = lvSearchResults.DataKeys[e.NewEditIndex].Value.ToString();
 
        ListViewItem item = lvSearchResults.Items[e.NewEditIndex];

       CoreDataManager lbNoAuth = new CoreDataManager();
 
        DataTable dt = lbNoAuth.GetNotSelectedAuthorizations(id);
 
        ListBox NoAuth = (ListBox)item.FindControl("lbNoAuthorizations");
 
        if (dt.Rows.Count > 0)

        {
 
            NoAuth.DataSource = dt;

            NoAuth.DataTextField = dt.Columns[1].ColumnName;

            NoAuth.DataValueField = dt.Columns[0].ColumnName;

tlhintoq

I don't do a lot of this stuff, but...

Expand|Select|Wrap|Line Numbers

ListBox NoAuth = (ListBox)item.FindControl("lbNoAuthorizations");

If the result of your FindControl is null (no matching controls found) then NoAuth would be null.

jrobbins

I finally figured this after lots of searching. I have a listbox inside my listview. I grab the datakey on the OnItemEditing event in the listview and then pass the objectdatasource the datakey as the default parameter.

Expand|Select|Wrap|Line Numbers

 protected void lvSearchResults_OnItemEditing(object sender, ListViewEditEventArgs e)

    {

            ListViewItem currentItem = lvSearchResults.Items[e.NewEditIndex];
 
            string id = lvSearchResults.DataKeys[e.NewEditIndex].Value.ToString();

            Response.Write("datakey:  " + id);

            odsNotSelectedAuthorizations.SelectParameters["PersonnelNumber"].DefaultValue = id;

            odsSelectedAuthorizations.SelectParameters["PersonnelNumber"].DefaultValue = id;

    }

Using listview datakeyname for listbox parameter

Post your reply

Similar topics