Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: C# SQL
i have a form which has both textboxes and a gridview. when a staffid is selected from the combo box, the gridview displays all the transactional records about the staff. each staff have got more than one transaction. i want the girdview to display the records in a particular row into their respective textboxes when that row is double - clicked.
i tired this but one particular record keeps on displaying in the text boxes even
if a different row is selected. how do i modify my sql statement to select based on the staffid in the combo box and the tansactionid in the gridview?
pls help me out

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";
            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();
Posted 13-Oct-12 8:47am
Edited 13-Oct-12 8:48am
Wes Aday94.3K
Wes Aday at 13-Oct-12 13:51pm
"and the tansactionid in the gridview"... well you would get the transactionid from the gridview and add that to your query.
mikeoabban at 14-Oct-12 12:16pm
yes, but how do i get it from the griddview. thats the problem
Wes Aday at 14-Oct-12 12:30pm
How is that a problem? dgvStaffsalarypayment.Rows[e.RowIndex].Cells[whatever-the-column-number-of-your-transactionid-is].Value

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

this is the solution. thanks to Wes Aday
select * from tblstaffsalarypaymentdetails where staffid like '" + this.cboStaffid5.Text + "%" + "' AND staffsalarytransid like '" + this.dgvStaffsalarypayment.Rows[e.RowIndex].Cells[0].Value + "%" + "'

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

  Print Answers RSS
0 OriginalGriff 277
1 Maciej Los 210
2 BillWoodruff 205
3 Jochen Arndt 180
4 Sergey Alexandrovich Kryukov 165
0 OriginalGriff 5,130
1 DamithSL 4,157
2 Maciej Los 3,650
3 Kornfeld Eliyahu Peter 3,460
4 Sergey Alexandrovich Kryukov 2,811

Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 21 Oct 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100