I have a data grid view which responds to a click event and the code works perfect
private void dgvContactpersonsearch_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
conn.ConnectionString = "Data Source=user-PC;Initial Catalog=MUCGPROJECT;User ID=sa;Password=mike";
conn.Open();
SqlCommand cmd =new SqlCommand();
string sqlQuery = dgvContactpersonsearch[0, e.RowIndex].Value.ToString();
sqlQuery = "select * from tblCollectorsregistration where collectorid like '" + this.dgvContactpersonsearch.Rows[e.RowIndex].Cells[0].Value + "' ";
cmd.Connection = conn;
cmd.CommandText = sqlQuery;
cmd.CommandType = System.Data.CommandType.Text;
SqlDataReader dr = null;
dr = cmd.ExecuteReader();
while (dr.Read())
{
txtCollectorid.Text = dr["collectorid"].ToString();
cboTitle.Text = dr["title"].ToString();
txtSurname.Text = dr["surname"].ToString();
txtMiddlename.Text = dr["middlename"].ToString();
txtFirstname.Text = dr["firstname"].ToString();
}
cmd.Dispose();
this.dgvContactpersonsearch.Visible = false;
}
I created a METHOD and copied this same code into it so that the method can be called anywhere in the project but i get the error “The name 'e' does not exist in the current context” please help me out
public void dgvCPclick()
{
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
conn.ConnectionString = "Data Source=user-PC;Initial Catalog=MUCGPROJECT;User ID=sa;Password=mike";
conn.Open();
SqlCommand cmd =new SqlCommand();
string sqlQuery = dgvContactpersonsearch[0, e.RowIndex].Value.ToString();
sqlQuery = "select * from tblCollectorsregistration where collectorid like '" + this.dgvContactpersonsearch.Rows[e.RowIndex].Cells[0].Value + "' ";
cmd.Connection = conn;
cmd.CommandText = sqlQuery;
cmd.CommandType = System.Data.CommandType.Text;
SqlDataReader dr = null;
dr = cmd.ExecuteReader();
while (dr.Read())
{
txtCollectorid.Text = dr["collectorid"].ToString();
cboTitle.Text = dr["title"].ToString();
txtSurname.Text = dr["surname"].ToString();
txtMiddlename.Text = dr["middlename"].ToString();
txtFirstname.Text = dr["firstname"].ToString();
}
cmd.Dispose();
this.dgvContactpersonsearch.Visible = false;
}