Loading
Listview Updating and Deleting events not working  
  •                     class="questionview" runat="server">  
  •                         class="qaimg">"16" src="e.png" />  
  •                         "viewlbl" CssClass="qaviewlbl" Text='<%#Eval("questionView")%>' runat="server" />  
  •                       
  •                       
  •                     class="questionanswer" runat="server">  
  •                         class="qaimg">"16" src="p.png" />  
  •                         "answerlbl" CssClass="qaviewlbl" Text='<%#Eval("questionAnswer")%>' runat="server" />  
  •                       
  •                     class="questiondate" runat="server">  
  •                         class="calendar">class="fa fa-calendar-o">  
  •                         "questiondate" CssClass="questiondatelbl" Text='<%#Bind("questionDate", "{0:dd-M-yyyy}")%>' runat="server" />  
  •                       
  •                  
  •   
  •                       
  •               
  •       
    1. MySqlConnection cn = new MySqlConnection("Server=; Database=; Uid=; Password=;");  
    2.         MySqlCommand cmd = new MySqlCommand();  
    3.         MySqlDataReader dr;  
    4.   
    5.         private void question()  
    6.         {  
    7.               
    8.   
    9.             cmd = new MySqlCommand("Select * from question order by ID desc", cn);  
    10.   
    11.             cn.Open();  
    12.   
    13.             dr = cmd.ExecuteReader();  
    14.             questionlist.DataSource = dr;  
    15.             questionlist.DataBind();  
    16.   
    17.             cn.Close();  
    18.              
    19.         }  
    20.         protected void Page_Load(object sender, EventArgs e)  
    21.         {  
    22.             question();  
    23.              
    24.               
    25.         }  
    26.   
    27.         protected void questionlist_ItemUpdating(object sender, ListViewUpdateEventArgs e)  
    28.         {  
    29.             bool z;  
    30.             Label questionID = (questionlist.Items[e.ItemIndex].FindControl("questionID")) as Label;  
    31.             Label questionPlus = (questionlist.Items[e.ItemIndex].FindControl("exactlynum")) as Label;  
    32.             Button exactly2 = (questionlist.Items[e.ItemIndex].FindControl("exactly2")) as Button;  
    33.             //ImageButton exactly = (questionlist.Items[e.ItemIndex].FindControl("exactly")) as ImageButton;  
    34.   
    35.             cmd = new MySqlCommand("Select * FROM questionLike WHERE questionID=@qID AND userID=@uID", cn);  
    36.             cmd.Parameters.AddWithValue("@qID", questionID.Text);  
    37.             cmd.Parameters.AddWithValue("@uID", Session["userID"]);  
    38.             cn.Open();  
    39.             dr = cmd.ExecuteReader();  
    40.             if (dr.Read())  
    41.             {  
    42.                 z = true;  
    43.             }  
    44.             else  
    45.             {  
    46.                 z = false;  
    47.             }  
    48.             cn.Close();  
    49.   
    50.             if (z == false && Session["userID"] != null)  
    51.             {  
    52.                 if (exactly2.CommandName == "Update")  
    53.                 {  
    54.                     string cmds = string.Format("Insert into questionLike(questionID, userID) values(@qID, @uID)");  
    55.                     cmd = new MySqlCommand(cmds, cn);  
    56.                     cmd.Parameters.AddWithValue("@qID", questionID.Text);  
    57.                     cmd.Parameters.AddWithValue("@uID", Session["userID"]);  
    58.                     cn.Open();  
    59.                     cmd.ExecuteNonQuery();  
    60.                     exactly2.Text = "Vazgeç";  
    61.                     exactly2.CommandName = "Delete";  
    62.                     cn.Close();  
    63.                 }  
    64.             }  
    65.             int uQPLus = -1;  
    66.             cmd = new MySqlCommand("select count(userID) from questionLike where questionID=@qID", cn);  
    67.             cmd.Parameters.AddWithValue("@qID", questionID.Text);  
    68.             cn.Open();  
    69.             uQPLus = Convert.ToInt32(cmd.ExecuteScalar());  
    70.             questionPlus.Text = uQPLus.ToString();  
    71.             cn.Close();  
    72.   
    73.         
    74.         }  
    75.   
    76.         protected void questionlist_ItemDeleting(object sender, ListViewDeleteEventArgs e)  
    77.         {  
    78.               
    79.             Label questionID = (questionlist.Items[e.ItemIndex].FindControl("questionID")) as Label;  
    80.             Label questionPlus = (questionlist.Items[e.ItemIndex].FindControl("exactlynum")) as Label;  
    81.             Button exactly2 = (questionlist.Items[e.ItemIndex].FindControl("exactly2")) as Button;  
    82.             //ImageButton exactly = (questionlist.Items[e.ItemIndex].FindControl("exactly")) as ImageButton;  
    83.   
    84.             if (exactly2.CommandName == "Delete")  
    85.             {  
    86.                 cmd = new MySqlCommand("DELETE FROM questionLike WHERE userID=@uID AND questionID=@qID", cn);  
    87.                 cmd.Parameters.AddWithValue("@uID", Session["userID"]);  
    88.                 cmd.Parameters.AddWithValue("@qID", questionID.Text);  
    89.                 cn.Open();  
    90.                 cmd.ExecuteNonQuery();  
    91.                 exactly2.Text = "Begen";  
    92.                 exactly2.CommandName = "Update";  
    93.                 cn.Close();  
    94.             }  
    95.             int uQPLus = -1;  
    96.             cmd = new MySqlCommand("select count(userID) from questionLike where questionID=@qID", cn);  
    97.             cmd.Parameters.AddWithValue("@qID", questionID.Text);  
    98.             cn.Open();  
    99.             uQPLus = Convert.ToInt32(cmd.ExecuteScalar());  
    100.             questionPlus.Text = uQPLus.ToString();  
    101.             cn.Close();  
    102.   
    103.         }  
    104.   
    105.         protected void questionlist_ItemDataBound(object sender, ListViewItemEventArgs e)  
    106.         {  
    107.             Label questionID = (Label)e.Item.FindControl("questionID");  
    108.             Label questionPlus = (Label)e.Item.FindControl("exactlynum");  
    109.             Button exactly2 = (Button)e.Item.FindControl("exactly2");  
    110.           
    111.              
    112.             //ImageButton exactly = (ImageButton)e.Item.FindControl("exactly");  
    113.   
    114.             MySqlConnection cn2 = new MySqlConnection("Server=; Database=; Uid=; Password=;");  
    115.             MySqlCommand cmd2 = new MySqlCommand();  
    116.             MySqlDataReader dr2;  
    117.   
    118.   
    119.             int uQPLus = -1;  
    120.             cmd2 = new MySqlCommand("select count(userID) from questionLike where questionID=@qID", cn2);  
    121.             cmd2.Parameters.AddWithValue("@qID", questionID.Text);  
    122.             cn2.Open();  
    123.             uQPLus = Convert.ToInt32(cmd2.ExecuteScalar());  
    124.             questionPlus.Text = uQPLus.ToString();  
    125.             cn2.Close();  
    126.   
    127.             cmd2 = new MySqlCommand("Select * from questionLike where questionID=@qID and userID=@uID", cn2);  
    128.             cmd2.Parameters.AddWithValue("@uID", Session["userID"]);  
    129.             cmd2.Parameters.AddWithValue("@qID", questionID.Text);  
    130.             cn2.Open();  
    131.             dr2 = cmd2.ExecuteReader();  
    132.   
    133.             if (dr2.Read())  
    134.             {  
    135.                 exactly2.Text = "Vazgeç";  
    136.                 exactly2.CommandName = "Delete";  
    137.   
    138.   
    139.             }  
    140.             else  
    141.             {  
    142.                 exactly2.Text = "Begen";  
    143.                 exactly2.CommandName = "Update";  
    144.   
    145.             }  
    146.   
    147.             cn2.Close();  
    148.   
    149.         
    150.   
    151.         }  
    These codes do not work on the page that I am currently viewing when running on another page. When I want to detect an error with a breakpoint, I can not get any feedback because the button is not fired.

    5 Replies

    Know the answer? Post it — somebody with the same question will find it here.