boundfield add make double it self by the table selected

Question

0.00/5 (No votes)

See more:

hi guys, i have a gridview, that using boundfield inject from asp.net, also hardcode from C# IDE, first problem is everytime i load data into gridview in page load event, the field column always adding twice from it's original, example i select field a,b,c,d but bwcause of the postback the field shown in gridview is become a,b,c,b,c,d and this problem fixed when i put the eventhandler name into if(!ispostback){}, but this problem come again when i execute searching data from table. i has try to find the solution but still no luck, please everybody helm me..

this is some code from me :

C#

SqlConnection tarikdatakondisi1 = new SqlConnection(StartKoneksiDatatable());

                    // buka koneksi kedalam datatable
                    tarikdatakondisi1.Open();

                    SqlDataAdapter sda1 = new SqlDataAdapter("select BillingNo, deskripsi, customername, remarks from mastertablebilling where tablestatusId = 1 and billingstatusId = 1", tarikdatakondisi1);
                    DataTable dt1 = new DataTable();
                    sda1.Fill(dt1);

                    // masuk ke kondisi dimana datatable adakah atau tidak
                    if (dt1 != null)
                    {
                        if (dt1.Rows.Count > 0)
                        {
                            // melakukan perhitungan jumlah row kolom untuk dijadikan materi dan diinsert berapa banyak row kolom yang dibutuhkan dengan looping tiap field yang di select
                            for (int i = 0; i < dt1.Columns.Count; i++)
                            {
                                // assign boundfield sebagai array variable kolom space(ruang)
                                BoundField boundField = new BoundField();

                                // kondisi sebaliknya jika ternyata ada field tersebut, maka tetapkan langsung headertextnya
                                boundField.DataField = dt1.Columns[i].ColumnName.ToString();

                                // buat kondisi jika ternyata ada field yang bernama tersebut, maka prosedural penetapan secara otomatis dilewatkan, karena sudah ada dari hardcode
                                if (dt1.Columns[i].ColumnName.ToString() != "BillingNo")
                                {
                                    if (dt1.Columns[i].ColumnName.ToString() == "deskripsi")
                                    {
                                        boundField.HeaderText = "Deskripsi";
                                    }
                                    if (dt1.Columns[i].ColumnName.ToString() == "customername")
                                    {
                                        boundField.HeaderText = "Customer";
                                    }
                                    if (dt1.Columns[i].ColumnName.ToString() == "remarks")
                                    {
                                        boundField.HeaderText = "Remarks";
                                    }
                                    // asignment field yang sudah didapat hasil tangkapan ke boundfield untuk dijadikan row kolom sesuai dengan headertext yang sudah dibuat
                                    gridviewformindexteknis.Columns.Add(boundField);
                                }
                            }
                        }
                    }
                    // lempar data tarikan ke row grid
                    gridviewformindexteknis.DataSource = dt1;
                    gridviewformindexteknis.DataBind();
                    tarikdatakondisi1.Close();
}

this is from my gridview ASP.Net code :

C#

<td><asp:Panel ID="panelgdformindeteknis" runat="server" style="overflow:auto" Width="100%">
                <asp:GridView ID="gridviewformindexteknis" runat="server" 
                    AutoGenerateColumns="false" BackColor="White"
                BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" 
                    AllowPaging="false" OnPageIndexChanging="PageIndexChanging" 
                    style="overflow:auto" Width="100%">
                <footerstyle backcolor="#B5C7DE" forecolor="#4A3C8C" />
                <rowstyle backcolor="#E7E7FF" forecolor="#4A3C8C" />
                <pagerstyle backcolor="#E7E7FF" forecolor="#4A3C8C" horizontalalign="Right" />
                <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
                <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
                <alternatingrowstyle backcolor="#F7F7F7" />
                <columns>
                <asp:HyperLinkField HeaderText="Nomer Billing" Target="_blank" DataNavigateUrlFields="BillingNo" DataTextField="BillingNo" DataNavigateUrlFormatString="~/detailBillingTek.aspx?BillingNo={0}" />
                </columns>

please anyone any can help me?

Posted 27-Oct-13 20:40pm

haritz.aryandra

Updated 27-Oct-13 20:53pm

Thanks7872

v3

Add a Solution

Comments

CodeBlack 28-Oct-13 2:46am

can you update your question with code ?

haritz.aryandra 28-Oct-13 3:54am

i has give the code, do you know what wrong with the code?

CodeBlack 28-Oct-13 4:04am

why do you use for loop instead of directly assigning datasource and adding bound field in grid itself ?

haritz.aryandra 28-Oct-13 4:11am

because i has condition from searching the data, it use radiobutton as the filter also the combo and textbox used for input criteria from the combo, do you get what i mean?

haritz.aryandra 28-Oct-13 4:13am

i have 3 radio button (a,b,c) each radiobutton shown trigger more field than others, exp. : rbo a only shown 4 field, rbo b shown 5, etc..

CodeBlack 28-Oct-13 4:13am

I don't see any code for searching data. The code which you have provided only gets data using sql query and binds those data to the grid view.

haritz.aryandra 28-Oct-13 4:20am

protected void btnCari_Click(object sender, EventArgs e)
{
try
{
// kondisi radio button yang dipilih == dimana file billing status adalah rejected
if (rboOutstanding.Checked == true)
{
if ((drpdpilihfungsi.SelectedValue == "") || (drpdpilihfungsi.SelectedValue == "Pilih") & (txtdeskripsi.Text == ""))
{

haritz.aryandra 28-Oct-13 4:22am

what are this script mean to you? in this type, i don;t use spesific filter, because just using one radio button, but on the next logic, i used something like :
select BillingNo, deskripsi, customername, remarks from mastertablebilling where billingstatusId = 1 and tablestatusId = 1 and BillingNo like '%" + txtdeskripsi.Text + "%'

2 solutions

Solution 1

As your binding code only retrieves data from database and bind it to grid view, I suggest to bind it as mentioned below :

Design Page:

XML

<asp:GridView ID="gridviewformindexteknis" runat="server"
        AutoGenerateColumns="false" BackColor="White"
        BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3"
        AllowPaging="false" OnPageIndexChanging="PageIndexChanging"
        Style="overflow: auto" Width="100%">
        <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
        <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
        <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
        <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
        <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
        <AlternatingRowStyle BackColor="#F7F7F7" />
        <Columns>
            <asp:BoundField DataField="deskripsi" HeaderText="Deskripsi" />
            <asp:BoundField DataField="deskripsi" HeaderText="Deskripsi" />
            <asp:BoundField DataField="customername" HeaderText="Customer" />
            <asp:BoundField DataField="remarks" HeaderText="Remarks" />
            <asp:HyperLinkField HeaderText="Nomer Billing" Target="_blank" DataNavigateUrlFields="BillingNo" DataTextField="BillingNo" DataNavigateUrlFormatString="~/detailBillingTek.aspx?BillingNo={0}" />
        </Columns>
    </asp:GridView>

Code Behind :

C#

SqlConnection tarikdatakondisi1 = new SqlConnection(StartKoneksiDatatable());

            // buka koneksi kedalam datatable
            tarikdatakondisi1.Open();

            SqlDataAdapter sda1 = new SqlDataAdapter("select BillingNo, deskripsi, customername, remarks from mastertablebilling where tablestatusId = 1 and billingstatusId = 1", tarikdatakondisi1);
            DataTable dt1 = new DataTable();
            sda1.Fill(dt1);
            
            // lempar data tarikan ke row grid
            gridviewformindexteknis.DataSource = dt1;
            gridviewformindexteknis.DataBind();
            tarikdatakondisi1.Close();

Posted 27-Oct-13 22:34pm

CodeBlack

Comments

haritz.aryandra 28-Oct-13 4:40am

if that use, are the boundfield can show, because i used one hyperlink in gridview as the primary row column?

CodeBlack 28-Oct-13 4:51am

hyperlink will remain as it is. what I have done is instead of code behind, I have bound all the columns in design page.

haritz.aryandra 28-Oct-13 5:12am

oke, but how is in another condition, i want to add more bound to the grid, exp in radiobutton b condition, etc, do i must use condition in the asp.net? can i?

CodeBlack 28-Oct-13 5:16am

yes you can.

haritz.aryandra 28-Oct-13 5:18am

how? give me the code if the condition is, there is 3 radio button, 1 combobox and 1 text criteria. for exp, the previous is for radiobutton one checked, how about in radiobutton two checked etc??

CodeBlack 28-Oct-13 5:31am

no one will write a code for you. try it your self and if you face any problem then post it in code project. you will get an solution for this.

haritz.aryandra 30-Oct-13 15:00pm

how if i want to add another condition for get data, exmp. condition nomer 2 after this is i want to add more column beside in the hardcode??

haritz.aryandra 6-Nov-13 4:15am

here is the condition =
1. radiobutton1 u load 3 field : 1 hyperlink, and 2 usual field,
2. radiobutton2 u load 4 field : 1 hyperlink, and 3 usual field,
3. radiobutton3 u load 5 field : 1 hyperlink, and 4 usual field,

please help how i can do this with boundfield?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

haritz.aryandra · Accepted Answer · 2013-10-27T22:35:00

i has solved the problem by my self, look's like the fault is because i assign the

Quote:
gridviewformindexteknis.Columns.Add(boundField);
gridviewformindexteknis.DataSource = null;

inside the looping condition, so maybe the system counting as the field is double value, because for the i++

i has updated the code behind also the asp.net :

this is the asp.net gridview of mine :

Quote:

<asp:Panel ID="panelgdformindeteknis" runat="server" style="overflow:auto" Width="100%">
<asp:GridView ID="gridviewformindexteknis" runat="server" BackColor="White"
BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3"
AllowPaging="false" OnPageIndexChanging="PageIndexChanging" style="overflow:auto" Width="100%" AutoGenerateColumns="False">
<footerstyle backcolor="#B5C7DE" forecolor="#4A3C8C">
<rowstyle backcolor="#E7E7FF" forecolor="#4A3C8C">
<pagerstyle backcolor="#E7E7FF" forecolor="#4A3C8C" horizontalalign="Right">
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<alternatingrowstyle backcolor="#F7F7F7">
<columns> <asp:HyperLinkField HeaderText="Nomer Billing" Target="_blank" DataNavigateUrlFields="BillingNo" DataTextField="BillingNo" DataNavigateUrlFormatString="~/detailBillingTek.aspx?BillingNo={0}" />
<asp:BoundField DataField="deskripsi" HeaderText="Deskripsi" />
<asp:BoundField DataField="customername" HeaderText="Customer" />

and this is the code behind :

Quote:
// kondisi radio button yang dipilih == dimana file billing status adalah new atau new updated(ini adalah status new yang pernah direject dan telah diupdated)
if (rboacceptedbilling.Checked == true)
{
if ((drpdpilihfungsi.SelectedValue == "Pilih") || (drpdpilihfungsi.SelectedValue == "") & (txtdeskripsi.Text == ""))
{
// assign boundfield sebagai array variable kolom space(ruang)
BoundField boundField5 = new BoundField();

SqlConnection koneksitarikdatadualaccepnofilt = new SqlConnection(StartKoneksiDatatable());

// buka koneksi kedalam datatable
koneksitarikdatadualaccepnofilt.Open();

SqlDataAdapter sda5 = new SqlDataAdapter("select BillingNo, deskripsi, customername, customerjabatan, remarks from mastertablebilling where tablestatusId = 1 and billingstatusId = 1 or billingstatusId = 3 or billingstatusId = 4", koneksitarikdatadualaccepnofilt);
DataTable dt5 = new DataTable();
sda5.Fill(dt5);

// masuk ke kondisi dimana datatable adakah atau tidak
if (dt5 != null)
{
if (dt5.Rows.Count > 0)
{
// melakukan perhitungan jumlah row kolom untuk dijadikan materi dan diinsert berapa banyak row kolom yang dibutuhkan dengan looping tiap field yang di select
for (int i = 0; i < dt5.Columns.Count; i++)
{
// buat kondisi jika ternyata ada field yang bernama tersebut, maka prosedural penetapan secara otomatis dilewatkan, karena sudah ada dari hardcode
if (dt5.Columns[i].ColumnName.ToString() != "BillingNo")
{
// kondisi sebaliknya jika ternyata ada field tersebut, maka tetapkan langsung headertextnya
boundField5.DataField = dt5.Columns[i].ColumnName.ToString();

if (dt5.Columns[i].ColumnName.ToString() == "deskripsi")
{
boundField5.HeaderText = "Deskripsi";
}
if (dt5.Columns[i].ColumnName.ToString() == "customername")
{
boundField5.HeaderText = "Customer";
}
if (dt5.Columns[i].ColumnName.ToString() == "customerjabatan")
{
boundField5.HeaderText = "Posisi";
}
if (dt5.Columns[i].ColumnName.ToString() == "remarks")
{
boundField5.HeaderText = "Remarks";
}
// asignment field yang sudah didapat hasil tangkapan ke boundfield untuk dijadikan row kolom sesuai dengan headertext yang sudah dibuat
//gridviewformindexteknis.Columns.Add(boundField5);
}
}
}
}
// asignment field yang sudah didapat hasil tangkapan ke boundfield untuk dijadikan row kolom sesuai dengan headertext yang sudah dibuat
gridviewformindexteknis.Columns.Add(boundField5);
gridviewformindexteknis.DataSource = null;// clear the grid

// lempar data array kedalam row gridview
gridviewformindexteknis.DataSource = dt5;
gridviewformindexteknis.DataBind();
koneksitarikdatadualaccepnofilt.Close();
}

the stack is shown, when i want to add more column as the filter nomer 2 searching(get data method), please anybody can give me the dynamic more code and script if there any of mistaken maybe by me