private void dgvStaffsalarypayment_CellContentClick(object sender, DataGridViewCellEventArgs e) { SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); conn.ConnectionString = "Data Source=MICKY-PC;Initial Catalog=SMS;User ID=sa;Password=mike"; conn.Open(); SqlCommand cmd = new SqlCommand(); string sqlQuery = dgvStaffsalarypayment[0, e.RowIndex].Value.ToString(); sqlQuery = "select * from tblstaffsalarypaymentdetails where staffid like '" + this.cboStaffid5.Text + "%" + "'"; cmd.Connection = conn; cmd.CommandText = sqlQuery; cmd.CommandType = System.Data.CommandType.Text; SqlDataReader dr = null; dr = cmd.ExecuteReader(); while (dr.Read()) { cboStaffid5.Text = dr["staffid"].ToString(); dtpDateofpayment.Text = dr["dateofpayment"].ToString(); cboPurpose.Text = dr["purpose"].ToString(); cboYear.Text = dr["years"].ToString(); cboMonth.Text = dr["months"].ToString(); txtAmountpaid.Text = dr["amountpaid"].ToString(); txtRemarks.Text = dr["remarks"].ToString(); } cmd.Dispose(); }
select * from tblstaffsalarypaymentdetails where staffid like '" + this.cboStaffid5.Text + "%" + "' AND staffsalarytransid like '" + this.dgvStaffsalarypayment.Rows[e.RowIndex].Cells[0].Value + "%" + "'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)