edit link column added every time edit link is clicked

hadoop hadoop

C# Winform Desktop Application

I've a grid view where I've added a Edit link column from code behind. The edit link works fine when the data is loaded for the first time. But when I do search on the same grid view, the edit link is added every time I press the Edit link.

I know the cause of the problem, please see the comment in the code . But I do not know where should I keep my edit function so that it appears in my grid view correctly. Please see my code and suggest.

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using Dashboard.AppCode;

using Dashboard.DAL;

using System.Text.RegularExpressions;

namespace Dashboard.UI

{

public partial class ReceiptReport : Form

{

private bool isSearchMode = false;

public ReceiptReport()

{

InitializeComponent();

isSearchMode = false;

GetReceipt(isSearchMode);

edit();

}

private void ReceiptReport_Load(object sender, EventArgs e)

{

dtpFrom.Value = DateTime.Today.AddDays(-1);

FillPaymentMode();

this.WindowState = FormWindowState.Maximized;

}

private void edit()

{

DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();

Editlink.UseColumnTextForLinkValue = true;

Editlink.HeaderText = "Edit";

Editlink.DataPropertyName = "lnkColumn";

Editlink.LinkBehavior = LinkBehavior.SystemDefault;

Editlink.Text = "Edit";

receiptGrid.Columns.Add(Editlink);

}

private void receiptGrid_CellContentClick(object sender, DataGridViewCellEventArgs e)

{

int paymentTxnId_ = 0;

try

{

if (e.RowIndex >= 0 && receiptGrid.Columns[e.ColumnIndex].Index == 0)

{

DataRowView drv = receiptGrid.Rows[e.RowIndex].DataBoundItem as DataRowView;

paymentTxnId_ = Convert.ToInt32(drv.Row["paymentTxnId"]);

Receipt receiptFrm = new Receipt(paymentTxnId_);

receiptFrm.StartPosition = FormStartPosition.CenterParent;

receiptFrm.Show();

}

catch (Exception ex)

{

string title = "Error";

MessageBox.Show(ex.Message.ToString(), title);

}

private void GetReceipt(bool mode)

{

int dummyId = 0;

int getPaymentMode = 0;

string fromDate = string.Empty;

string toDate = string.Empty;

string payPartyName = string.Empty;

string recNum = string.Empty;

DataTable dt = new DataTable();

ReceiptDal objDal = new ReceiptDal();

try

{

if (mode == false)

{

dt = objDal.GetReceipt(dummyId);

receiptGrid.DataSource = dt;

receiptGrid.Columns[0].Visible = false;

}

else

{

getPaymentMode = (int)cmbPaymentMode.SelectedValue;

fromDate = dtpFrom.Value.ToShortDateString();

toDate = dtpTo.Value.ToShortDateString();

dt = objDal.SearchReceipt(getPaymentMode, fromDate, toDate);

receiptGrid.DataSource = dt;

receiptGrid.Columns[0].Visible = false;

edit(); // every time it is called when the search button is pressed so added in grid view every time

}

catch (Exception ex)

{

MessageBox.Show(ex.Message.ToString(), "Error");

}

#region search

private void btnSearch_Click(object sender, EventArgs e)

{

try

{

isSearchMode = true;

GetReceipt(isSearchMode);

}

catch (Exception ex)

{

MessageBox.Show(ex.Message.ToString(), "Error");

}

#endregion

private void FillPaymentMode()

{

DataTable dt = new DataTable();

ReceiptDal objDal = new ReceiptDal();

dt = objDal.GetPaymentMode();

cmbPaymentMode.DataSource = dt;

cmbPaymentMode.DisplayMember = "paymentmodename";

cmbPaymentMode.ValueMember = "paymentmodeid";

}

7 Replies

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

hadoop hadoop11y ago
Guys please help with this.
Thanks!!!
0
hadoop hadoop11y ago
Thanks for your response. I did as you suggest me.
But now another problem. When the data loads the EDIT link column is at the end of the data grid, but after pressing the SEARCH the edit link column appears at the first column. Why is it so?

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Dashboard.AppCode;
using Dashboard.DAL;
using System.Text.RegularExpressions;
namespace Dashboard.UI
{
public partial class ReceiptReport : Form
{
private bool isSearchMode = false;
private bool isEditMode = false;
public ReceiptReport()
{
InitializeComponent();
isSearchMode = false;
GetReceipt(isSearchMode);
edit();

}
private void ReceiptReport_Load(object sender, EventArgs e)
{
dtpFrom.Value = DateTime.Today.AddDays(-1);
isEditMode = false;
FillPaymentMode();
this.WindowState = FormWindowState.Maximized;
}
private void edit()
{
DataGridViewLinkColumn Editlink = new DataGridViewLinkColumn();
Editlink.UseColumnTextForLinkValue = true;
Editlink.HeaderText = "Edit";
Editlink.DataPropertyName = "lnkColumn";
Editlink.LinkBehavior = LinkBehavior.SystemDefault;
Editlink.Text = "Edit";
receiptGrid.Columns.Add(Editlink);
}
private void receiptGrid_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int paymentTxnId_ = 0;
try
{
if (e.RowIndex >= 0 && receiptGrid.Columns[e.ColumnIndex].Index == 0)
{
DataRowView drv = receiptGrid.Rows[e.RowIndex].DataBoundItem as DataRowView;
paymentTxnId_ = Convert.ToInt32(drv.Row["paymentTxnId"]);
Receipt receiptFrm = new Receipt(paymentTxnId_);
receiptFrm.StartPosition = FormStartPosition.CenterParent;
receiptFrm.Show();
}
}
catch (Exception ex)
{
string title = "Error";
MessageBox.Show(ex.Message.ToString(), title);
}
}
private void GetReceipt(bool mode)
{
int dummyId = 0;
int getPaymentMode = 0;
string fromDate = string.Empty;
string toDate = string.Empty;
string payPartyName = string.Empty;
string recNum = string.Empty;
DataTable dt = new DataTable();
ReceiptDal objDal = new ReceiptDal();
try
{
if (mode == false)
{
dt = objDal.GetReceipt(dummyId);
receiptGrid.DataSource = dt;
receiptGrid.Columns[0].Visible = false;
}
else
{
receiptGrid.DataSource = null;
getPaymentMode = (int)cmbPaymentMode.SelectedValue;
fromDate = dtpFrom.Value.ToShortDateString();
toDate = dtpTo.Value.ToShortDateString();
payPartyName = txtPaymentPartyName.Text.Trim();
recNum = txtReceiptNum.Text.Trim();
dt = objDal.SearchReceipt(getPaymentMode, recNum, payPartyName, fromDate, toDate);
receiptGrid.DataSource = dt;
receiptGrid.Columns[0].Visible = false;
if (isEditMode == false)
{
edit();
isEditMode = true;
}

}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Error");
}
}
#region search
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
isSearchMode = true;
GetReceipt(isSearchMode);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Error");
}
}
#endregion
}
}
0
Syed Shanu11y ago
comment the Edit link from the Search method of else part.Other wise make a boolean variable and set it as false initially in form load. When search click check the boolean variable is false.If its false then call the Edit funciton and then make the boolean variable as true.By this next time when you click on search button it will not call the edit function.

Note : You should call the edit method only one time.In you search method iam not sure what you are doing in else part .In the else part it calls the Edit method everytime.as i told you make some boolean variable check and call the Edit fucntion.

0
hadoop hadoop11y ago
sorry it did not solve my problem. Edit link is added each time I click the SEARCH button.
0
Syed Shanu11y ago
Oops sorry for that i ddint check that its as Winform. but the answer is same. as in your button click everytime you are binding the data with out clearing it .Make the Datagridview.datasource=Null; bfore binding the source. Hope that will fix your issue.
0
hadoop hadoop11y ago
Will "page.Ispostback" work for Win form applications?
0
Syed Shanu11y ago
Hi,
You need to check for the page.isPostback .
When you click on a button or any event is triggered for every time the page load event and Page Init event will be triggerd so your data is refershing and adding again and again to avoid this in page load you can check for not page is postback then bind data items.i have changed your code like below.

public ReceiptReport()
{
InitializeComponent();

}
private void ReceiptReport_Load(object sender, EventArgs e)
{
dtpFrom.Value = DateTime.Today.AddDays(-1);

this.WindowState = FormWindowState.Maximized;

if(!page.Ispostback)
{
isSearchMode = false;
GetReceipt(isSearchMode);
edit();
FillPaymentMode();
}
}
0