在asp.net的datalist控件中更新行？ [英] update row in datalist control of asp.net?

问题描述

亲爱的，

更新datalist控件中的行

这里点击更新命令按钮



那个行状态更新我想要



这里不能正常工作请回复我任何错误或者wxamples

  protected   void  FriendRequests_UpdateCommand（ object  source，DataListCommandEventArgs e）
 {
 SqlConnection con =  new  SqlConnection（ConfigurationManager.ConnectionStrings [  ConnectionString]。ConnectionString）; 
  int  id =（ int ）DataList1.DataKeys [（ INT ）e.Item.ItemIndex]; 
 SqlCommand cmd =  new  SqlCommand（ 更新Tablerow set Status = 1其中Status = 0且id = + id +   ，con）; 
 con.Open（）; 
  int  temp = cmd.ExecuteNonQuery（）; 
  if （temp ==  1 ）
 {
  //   lbldisplay.Text =已成功更新;  
} 
 con.Close（ ）; 
 LoadData（）; 
} 

解决方案

步骤：1首先创建标记Default.aspx

 <   asp：gridview     id   =  grvManageQuiz    runat   = 服务器    xmlns：asp   = ＃unknown >  
 <  列 >  
 
 <   asp：TemplateField         HeaderText   = 添加问题 >  
 <   ItemTemplate  > ;  
 <   asp：ImageButton           ID   =  imgbtndetails    runat   = 服务器    Im ageUrl   = 〜/ Images / data-add-icon.png          OnClick   =  imgbtn_Click          /  >  
 
 <   / ItemTemplate  >  
 <   / asp：TemplateField  >  
 <   / columns  >  
 <   / asp：gridview  < span class =code-keyword>>  
 

步骤：2 Default.CS

===========================

< pre lang =c＃> string ConnectionString = ConfigurationManager.ConnectionStrings [ quizConnectionString]的ConnectionString。
受保护 void Page_Load（ object sender，EventArgs e）
{
if （！IsPostBack）
{
loadresult（）;
}
}

public void loadresult（ ）
{
try
{
SqlConnection cn = new SqlConnection（ConnectionString）;
cn.Open（）;
SqlCommand cmd = new SqlCommand（ SP_Manage_Comprehensive_quiz ，cn）;
cmd.CommandType = CommandType.StoredProcedure;

grvManageQuiz.EmptyDataText = 找不到记录;
grvManageQuiz.DataSource = cmd.ExecuteReader（）;
grvManageQuiz.DataBind（）;

lbtotalRow.Visible = true ;
lbtotalRow.Text = 总计： + Convert.ToString（grvManageQuiz.Rows.Count ）+ 找到的记录 + < br />;
}
catch
{
}
}

protected void imgbtn_Click（ object sender，ImageClickEventArgs e）
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow =（GridViewRow）btndetails.NamingContainer;

string quiz_id = gvrow.Cells [ 3 ]。文字;
会话[ quiz_id] = quiz_id;

Response.Redirect（ 〜/ Admin / addquestion.aspx） ;
}

Dear All,
Update row in datalist control
here once click update command button

that row status update i want

here not working properly please reply me any mistake or wxamples

protected void FriendRequests_UpdateCommand(object source, DataListCommandEventArgs e)
    {                
 SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        int id = (int)DataList1.DataKeys[(int)e.Item.ItemIndex];
        SqlCommand cmd = new SqlCommand("Update Tablerow set Status=1 where Status=0 and id=" + id + "", con);
        con.Open();
        int temp = cmd.ExecuteNonQuery();
        if (temp == 1)
        {            
            //lbldisplay.Text = "Updated successfully";
        }
        con.Close();
        LoadData();
    }

解决方案

Step : 1 First Create Markup Default.aspx

<asp:gridview id="grvManageQuiz" runat="server" xmlns:asp="#unknown">
           <columns>

<asp:TemplateField   HeaderText="Add Question">
 <ItemTemplate>
    <asp:ImageButton    ID="imgbtndetails" runat="server" ImageUrl="~/Images/data-add-icon.png"    OnClick="imgbtn_Click"    />

     </ItemTemplate>
   </asp:TemplateField>
</columns>
       </asp:gridview>

Step:2 Default.CS
===========================

string ConnectionString = ConfigurationManager.ConnectionStrings["quizConnectionString"].ConnectionString;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            loadresult();
        }
    }

    public void loadresult()
    {
        try
        {
            SqlConnection cn = new SqlConnection(ConnectionString);
            cn.Open();
            SqlCommand cmd = new SqlCommand("SP_Manage_Comprehensive_quiz", cn);
            cmd.CommandType = CommandType.StoredProcedure; 

            grvManageQuiz.EmptyDataText = "No Records Found";
            grvManageQuiz.DataSource = cmd.ExecuteReader();
            grvManageQuiz.DataBind();

            lbtotalRow.Visible = true;
            lbtotalRow.Text = "Total : " + Convert.ToString(grvManageQuiz.Rows.Count) + " Records found" + "<br />"; 
        }
        catch
        {
        }
    }

    protected void imgbtn_Click(object sender, ImageClickEventArgs e) 
    {    
        ImageButton btndetails = sender as ImageButton;
        GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;

        string quiz_id = gvrow.Cells[3].Text;
        Session["quiz_id"] = quiz_id;

      Response.Redirect("~/Admin/addquestion.aspx");
    }

这篇关于在asp.net的datalist控件中更新行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！