Hi everyone,
I tried for myself code. But I have a problem. When I checkbox check event. Copy to another gridview. But I dont get data in gridview.
I tried for myself code. But I have a problem. When I checkbox check event. Copy to another gridview. But I dont get data in gridview.
Now the problem is not the data in the td column in gridview. The second problem is that once I checkbox check GridView is deleted.
$('[id*=txtkategori]').keyup(function () {
var obj = {};
obj.value = $(this).val();
$.ajax({
url: "DepoSiparisEkle.aspx/BindProductTable",
data: JSON.stringify(obj),
dataType: "json",
type: "POST",
contentType: "application/json; charset=utf-8",
success: function (data) {
if (data.d != "Please Enter Valid Category" && data.d != "No Data Found!!") {
var xmlDoc = $.parseXML(data.d);
var xml = $(xmlDoc);
var Urun = xml.find("Urunler");
var row = $("[id*=example] tr:last-child").clone(true);
$("[id*=example] tr").not($("[id*=example] tr:first-child")).remove();
$.each(Urun, function () {
var product = $(this);
//$("td", row).eq(1).html("<input type='checkbox' id='chcsec'/>");
$("td", row).eq(1).html($(this).find("UrunAd").text());
$("td", row).eq(2).html($(this).find("Stok").text());
$("td", row).eq(3).html($(this).find("SeriNo").text());
$("td", row).eq(4).html($(this).find("TedarikciID").text());
//$("td", row).eq(5).html("<input type='text' id='txtAdet'/>");
//$("td", row).eq(6).html("<select name='select' id='drpEleman'></select>");
$("[id*=example]").append(row);
row = $("[id*=example] tr:last-child").clone(true);
});
$("[id*=example]").attr('style', 'display:block');
}
else {
$("[id*=example]").attr('style', 'display:none');
alert(data.d);
}
},
error: function (data) { alert(data.d); }
});
});
});
Checkbox
protected void chcsec_CheckedChanged(object sender, EventArgs e)
{
if ((sender as CheckBox).Checked)
{
if (ViewState["CheckedRow"] == null)
{
DataTable dt = CheckedData();
ViewState["CheckedRow"] = dt;
}
else
{
DataTable previousCheckedRows = ViewState["CheckedRow"] as DataTable;
DataTable dtCurrentCheckedRows = CheckedData();
dtCurrentCheckedRows.Merge(previousCheckedRows);
ViewState["CheckedRow"] = dtCurrentCheckedRows;
}
}
else
{
GridViewRow row = ((sender as CheckBox).NamingContainer as GridViewRow);
Label lblUrun = (row.FindControl("lblUrun") as Label);
Label lblStok = (row.FindControl("lblStok") as Label);
DataTable deleteRow = (ViewState["CheckedRow"] as DataTable).DefaultView.ToTable(true);
DataRow[] dr = deleteRow.Select("UrunAd = '" + lblUrun.Text + "' AND Stok = '" + lblStok.Text + "'");
foreach (DataRow d in dr)
{
deleteRow.Rows.Remove(d);
}
ViewState["CheckedRow"] = deleteRow;
}
gvSiparis.DataSource = (ViewState["CheckedRow"] as DataTable).DefaultView.ToTable(true);
gvSiparis.DataBind();
}
private DataTable CheckedData()
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[] { new DataColumn("UrunAd"), new DataColumn("Stok", typeof(int)), new DataColumn("Adet", typeof(int)), new DataColumn("Pozisyon"), new DataColumn("ElemanAdet", typeof(int)), new DataColumn("TedarikUcreti") });
//dt.Columns.AddRange(new DataColumn[] { new DataColumn("UrunAd"), new DataColumn("Stok", typeof(int))});
foreach (GridViewRow rw in example.Rows)
{
CheckBox chk = (CheckBox)rw.Cells[0].FindControl("chcsec");
if (chk.Checked)
{
//HiddenField hdID = (HiddenField)rw.Cells[0].FindControl("hdID");
string lb = rw.Cells[1].Text;
Response.Write(rw.Cells[1].Text);
Response.Write(rw.Cells[2].Text);
//Label lb1 = (Label)rw.Cells[2].FindControl("lblStok");
//TextBox fiyat = (TextBox)rw.Cells[3].FindControl("txtAdet");
TextBox adet = (TextBox)rw.Cells[3].FindControl("lblAdet");
DropDownList drp = (DropDownList)rw.Cells[4].FindControl("drpEleman");
TextBox elemanadet = (TextBox)rw.Cells[5].FindControl("lblElemanAdet");
TextBox tedarikfiyat = (TextBox)rw.Cells[6].FindControl("lblTedarikciFiyat");
int stok = Convert.ToInt32(lb);
int adets = Convert.ToInt32(adet.Text);
if (stok < adets)
{
chk.Checked = false;
//Response.Write("<script LANGUAGE='JavaScript' >alert('Stok Yok...')</script>");
ScriptManager.RegisterStartupScript(this, GetType(), "alert", "<script>alert('Stok Yok ..!!');</script>", false);
break;
}
dt.Rows.Add(lb, adets, drp.SelectedItem.Text, elemanadet.Text, tedarikfiyat.Text);
//dt.Rows.Add(lb.Text, lb1.Text);
chk.Checked = false;
adet.Text = "";
elemanadet.Text = "";
tedarikfiyat.Text = "";
}
}
return dt;
}
Gridview
<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<asp:GridView ID="example" CssClass="table table-striped table-bordered table-hover"
Style="display: none" AutoGenerateColumns="false" runat="server" ClientIDMode="Static"
OnRowDataBound="example_RowDataBound">
<Columns>
<asp:TemplateField HeaderText="Ürün Seç" ItemStyle-Width="5%">
<ItemTemplate>
<asp:CheckBox ID="chcsec" CssClass="form-control" runat="server" AutoPostBack="true"
OnCheckedChanged="chcsec_CheckedChanged" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Ürün Ad" ItemStyle-Width="22%">
<ItemTemplate>
<asp:Label ID="lblUrun" runat="server" Text='<%# Eval("UrunAd") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Stok" ItemStyle-Width="5%">
<ItemTemplate>
<asp:Label ID="lblStok" Style="padding: 3px 5px;" runat="server" Text='<%# Eval("Stok") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Seri No" ItemStyle-Width="15%">
<ItemTemplate>
<asp:Label ID="lblSeriNo" Style="padding: 3px 5px;" runat="server" Text='<%# Eval("SeriNo") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Tedarikçi" ItemStyle-Width="15%">
<ItemTemplate>
<asp:Label ID="lblTedarik" Style="padding: 3px 5px;" runat="server" Text='<%# Eval("TedarikciID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Adet" ItemStyle-Width="50">
<ItemTemplate>
<asp:TextBox ID="lblAdet" Style="padding: 3px 5px; width: 100%" CssClass="form-control"
runat="server"></asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtAdet" runat="server" Style="padding: 3px 5px; width: 100%" CssClass="form-control"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Eleman Seç" ItemStyle-Width="100">
<ItemTemplate>
<asp:DropDownList ID="drpEleman" CssClass="form-control" runat="server">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Eleman Adet" ItemStyle-Width="50">
<ItemTemplate>
<asp:TextBox ID="lblElemanAdet" Style="padding: 3px 5px; width: 100%" CssClass="form-control"
runat="server"></asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtElemanAdet" runat="server" Style="padding: 3px 5px; width: 100%"
CssClass="form-control"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Tedarikçi Fiyat" ItemStyle-Width="50">
<ItemTemplate>
<asp:TextBox ID="lblTedarikciFiyat" Style="padding: 3px 5px; width: 100%" CssClass="form-control"
runat="server"></asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtTedarikciFiyat" runat="server" Style="padding: 3px 5px; width: 100%"
CssClass="form-control"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<div class="col-lg-12" style="margin-top: 30px;">
<div class="panel panel-danger">
<div class="panel-heading">
Sipariş Tablosu
</div>
<asp:GridView ID="gvSiparis" runat="server" CssClass="table table-striped table-bordered table-hover"
AutoGenerateColumns="false" OnRowDataBound="gvSiparis_RowDataBound" OnRowDeleting="gvSiparis_RowDeleting">
<Columns>
<asp:TemplateField HeaderText="Ürün Ad" ItemStyle-Width="22%">
<ItemTemplate>
<asp:Label ID="lblUrun" runat="server" Text='<%# Eval("UrunAd") %>'></asp:Label>
</ItemTemplate>
<%-- <EditItemTemplate>
<asp:TextBox ID="txturunad" runat="server" Text='<%# Eval("UrunAd") %>'></asp:TextBox>
</EditItemTemplate>--%>
</asp:TemplateField>
<asp:TemplateField HeaderText="Stok" ItemStyle-Width="5%">
<ItemTemplate>
<asp:Label ID="lblStok" Style="padding: 3px 5px;" runat="server" Text='<%# Eval("Stok") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtstok" Style="padding: 3px 5px;" runat="server" Text='<%# Eval("Stok") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Adet" ItemStyle-Width="50">
<ItemTemplate>
<asp:Label ID="lblAdet" Style="padding: 3px 5px;" runat="server" Text='<%# Eval("Adet") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtAdet" runat="server" Style="padding: 3px 5px; width: 100%" CssClass="form-control"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Eleman Seç" ItemStyle-Width="100">
<ItemTemplate>
<%-- <asp:DropDownList ID="drpEleman" CssClass="form-control" runat="server"></asp:DropDownList>--%>
<asp:Label ID="lblElemans" Style="padding: 3px 5px;" runat="server" Text='<%# Eval("Pozisyon") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Eleman Adet" ItemStyle-Width="50">
<ItemTemplate>
<asp:Label ID="lblElemanAdet" Style="padding: 3px 5px;" runat="server" Text='<%# Eval("ElemanAdet") %>'></asp:Label>
</ItemTemplate>
<%-- <EditItemTemplate>
<asp:TextBox ID="txtElemanAdet" runat="server" Style="padding: 3px 5px; width: 100%" CssClass="form-control"></asp:TextBox>
</EditItemTemplate>--%>
</asp:TemplateField>
<asp:TemplateField HeaderText="Tedarikçi Fiyat" ItemStyle-Width="50">
<ItemTemplate>
<asp:Label ID="lblTedarikci" Style="padding: 3px 5px;" runat="server" Text='<%# Eval("TedarikUcreti") %>'></asp:Label>
</ItemTemplate>
<%-- <EditItemTemplate>
<asp:TextBox ID="txtElemanAdet" runat="server" Style="padding: 3px 5px; width: 100%" CssClass="form-control"></asp:TextBox>
</EditItemTemplate>--%>
</asp:TemplateField>
<asp:CommandField ButtonType="Link" ShowEditButton="false" ShowDeleteButton="true"
ItemStyle-Width="20%" />
</Columns>
</asp:GridView>
</div>
</div>
</ContentTemplate>
</asp:UpdatePanel>