getting datakey value at listview itemcommand

Question

0.00/5 (No votes)

See more:

i have populated listview from database.i am trying to get the datakey value of listbox bt i am getting null value:the code is:

protected void Maillist_ItemCommand(object sender, ListViewCommandEventArgs e)
   {
       if (e.CommandName == "Delete")
       {
           populatelistview();
           Label lblid=(Label)e.Item.FindControl("lblid");
           string id = Maillist.SelectedValue.ToString();
           SqlConnection conn = new SqlConnection();
           conn.ConnectionString = strconn;
           string str = "delete from Companymails_Master where Mailid='" + Maillist.DataKeys.ToString() + "'";
           SqlCommand cmd = new SqlCommand(str,conn);
           conn.Open();
           cmd.ExecuteNonQuery();
           conn.Close();

           populatelistview();
       }
   }

plz guide...where m i wrong.i simply want to delete the row on clicking the
delete button.

Posted 2-May-11 1:47am

mylogics

Add a Solution

4 solutions

Solution 1

try this

 protected void EmployeesListView_OnItemCommand(object sender, ListViewCommandEventArgs e)
  {
    if (String.Equals(e.CommandName, "AddToList"))
    {
      // Verify that the employee ID is not already in the list. If not, add the
      // employee to the list.
      ListViewDataItem dataItem = (ListViewDataItem)e.Item;
      string employeeID = 
        EmployeesListView.DataKeys[dataItem.DisplayIndex].Value.ToString();

      if (SelectedEmployeesListBox.Items.FindByValue(employeeID) == null)
      {
        ListItem item = new ListItem(e.CommandArgument.ToString(), employeeID);
        SelectedEmployeesListBox.Items.Add(item);
      }
    }
  }


//Other way is 

<asp:LinkButton ID="LinkButton1" CommandName="Insert" CommandArgument='<%#Eval("CatId")%>'
                 runat="server">Edit</asp:LinkButton>

//in the item command Event 

   if (e.CommandName == Edit)
       {

 int CatId = int.Parse(e.CommandArgument.ToString());
}

Posted 2-May-11 1:53am

Mahendra.p25

Updated 2-May-11 2:22am

v2

Solution 2

Have you mention DataKey attribute in the aspx ListBox Control or DataKey must be same as that of table field in the database.

Thanks & Regards,
Balwant

Posted 2-May-11 2:07am

Balwant.mnd

Comments

mylogics 2-May-11 8:12am

yes i have defined datakey in listview.i also have a label name lblid which contains the primaryvalue .bt i am not able to get the value.it gives null.

Solution 3

Try this for your query

string str = "delete from Companymails_Master where Mailid='" + Maillist.DataKeys[e.ItemIndex].ToString() + "'";

Hope this helps .......

Posted 2-May-11 2:23am

Ra-one

Updated 2-May-11 22:41pm

v2

Comments

mylogics 2-May-11 8:29am

e.Item.ItemIndex there is no such property

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

mylogics · Accepted Answer · 2011-05-02T02:36:00

finally got the solution here:

protected void Maillist_ItemDeleting(object sender, ListViewDeleteEventArgs e)
  {
      string id = Maillist.DataKeys[e.ItemIndex].Value.ToString();
      SqlConnection conn = new SqlConnection();
      conn.ConnectionString = strconn;
      string str = "delete from Companymails_Master where Mailid='" + id + "'";
      SqlCommand cmd = new SqlCommand(str, conn);
      conn.Open();
      cmd.ExecuteNonQuery();
      conn.Close();

      populatelistview();
  }

getting datakey value at listview itemcommand

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

getting datakey value at listview itemcommand

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us