private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) //Insert button inside datagridview { if (e.ColumnIndex == 3) { var senderGrid = (DataGridView)sender; if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0) { //TODO - Button Clicked - Execute Code Here //string x = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString(); conn = new SqlConnection(connec.GetServer()); conn.Open(); cmd = new SqlCommand("Insert into tblSubj (Subject, TimeIN, TimeOUT,GradeLevel) Values('" + dataGridView1.Rows[e.RowIndex].Cells[0].Value + "','" + dataGridView1.Rows[e.RowIndex].Cells[1].Value + "','" + dataGridView1.Rows[e.RowIndex].Cells[2].Value + "','"+getinfo.rowid+"')", conn); m_dr = cmd.ExecuteReader(); m_dr.Close(); conn.Close(); MessageBox.Show("Results Saved!"); } } else if (e.ColumnIndex == 4) { var senderGrid = (DataGridView)sender; if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0) { //TODO - Button Clicked - Execute Code Here //string x = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString(); conn = new SqlConnection(connec.GetServer()); conn.Open(); cmd = new SqlCommand("update tblSubj set Subject='" + dataGridView1.Rows[e.RowIndex].Cells[0].Value + "' ,TimeIN='" +dataGridView1.Rows[e.RowIndex].Cells[1].Value + "' ,TimeOUT='"+ dataGridView1.Rows[e.RowIndex].Cells[2].Value + "' Where GradeLevel='" + getinfo.rowid + "'", conn); m_dr = cmd.ExecuteReader(); conn = new SqlConnection(connec.GetServer()); conn.Open(); SqlCommand cmd1 = new SqlCommand("update tblTime set Temp='" + "Taken" + "' Where GradeLevel='" + getinfo.rowid + "' And TimeIN = '" + dataGridView1.Rows[e.RowIndex].Cells[1].Value + "' And TimeOUT = '" + dataGridView1.Rows[e.RowIndex].Cells[2].Value + "'", conn); SqlDataReader m_dr1 = cmd1.ExecuteReader(); conn.Close(); MessageBox.Show("Updated"); } }}
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)