Click here to Skip to main content
15,887,214 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
This is my screen:
http://i.stack.imgur.com/LsPbX.png

I type in textbox, then I check checkbox.
Next I click button cbXacNhan to insert data into database but typed data don't update. Data update into database is old values.
I want insert typed data into data table.
I need to help.

This is my code:

C#
protected int[] SelectedRowsIndex()
        {
            int[] indexes = new int[gridThuTien.Selection.Count];
            int k = 0;
            for (int i = 0; i < gridThuTien.VisibleRowCount; i++)
            {
                if (gridThuTien.Selection.IsRowSelected(i))
                {
                    indexes[k] = i;
                    k++;
                }
            }
            return indexes;
        }
    protected void cbXacNhan_Callback(object source, DevExpress.Web.ASPxCallback.CallbackEventArgs e)
    {
        int TienHDKHId;
        ASPxTextBox txtSoTien;
        ASPxTextBox txtHDKHId;
        int[] indexes = SelectedRowsIndex();
        foreach (int i in indexes)
        {
            txtSoTien = gridThuTien.FindRowCellTemplateControl(i, gridThuTien.Columns["TienTT"] as GridViewDataColumn, "ASPxTextBox1") as ASPxTextBox;
            txtHDKHId = gridThuTien.FindRowCellTemplateControl(i, gridThuTien.Columns["TienHDKHId"] as GridViewDataColumn, "ASPxTextBox2") as ASPxTextBox;
            decimal sotien = Convert.ToDecimal(txtSoTien.Text);
            int hdid = Convert.ToInt32(txtHDKHId.Text);
    		int loaitien = Convert.ToInt32(cbxLoaiTien.Value);
    		int nhanvienid = Convert.ToInt32(Session["NhanVienId"]);
    		clst.T_INSERT_PHIEUXACNHAN(hdid, loaitien, sotien, nhanvienid);
        }
    }

My ASPX code:

ASP.NET
<dx:GridViewDataTextColumn Caption="Loại tiền" FieldName="TienTT" Name="LOAITIEN" Width="100px">
        <DataItemTemplate>
    		<dx:ASPxTextBox ID="ASPxTextBox1"  runat="server" Width="100%" Text='<%#Eval("TienTT")%>'>
    		</dx:ASPxTextBox>
        </DataItemTemplate>
    </dx:GridViewDataTextColumn>
    <dx:GridViewCommandColumn ShowSelectCheckbox="true" Width="50px" >
        <HeaderTemplate>
            <input type="checkbox" name="cbxSelect"  runat="server" enableviewstate="true" id="checkAll" title="Chọn/ Bỏ chọn tất cả" 
                />
        </HeaderTemplate>
        <HeaderStyle HorizontalAlign="Center" />
    </dx:GridViewCommandColumn>
Posted

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900