datagridview control

Question

hi to all how to add delete and update the datagridview control in windows application. don't use textbox and label. datagridview control in changed in edit delete and add the database fields.

Praveen N · Answer

Reference:- http://www.mindstick.com/Articles/9422cfc8-c2ed-4ec1-9fab-589eb850a863/?Insert%20Delete%20Update%20in%20Da Thanks & Regards Praveen N

Praveen N · Answer

public partial class DataTrialForm : Form { private String connectionString = null ; private SqlConnection sqlConnection = null ; private SqlDataAdapter sqlDataAdapter = null ; private SqlCommandBuilder sqlCommandBuilder = null ; private DataTable dataTable = null ; private BindingSource bindingSource = null ; private String selectQueryString = null ; public DataTrialForm () { InitializeComponent (); } private void DataTraiForm_Load ( object sender  EventArgs e ) { sqlConnection = new SqlConnection ( data source=SEZ-WS-137\SQLEXPRESS2008;initial catalog=AttendanceData;user id=sa;password=pass ); selectQueryString = select top 20 * from Attendance order by punchtime asc ; sqlConnection . Open (); sqlDataAdapter = new SqlDataAdapter ( selectQueryString  sqlConnection ); sqlCommandBuilder = new SqlCommandBuilder ( sqlDataAdapter ); dataTable = new DataTable (); sqlDataAdapter . Fill ( dataTable ); bindingSource = new BindingSource (); bindingSource . DataSource = dataTable ; dataGridViewTrial . DataSource = bindingSource ; // to hide Identity column dataGridViewTrial . Columns [ 0 ]. Visible = false ; } private void addUpadateButton_Click ( object sender  EventArgs e ) { try { sqlDataAdapter . Update ( dataTable ); } catch ( Exception exceptionObj ) { MessageBox . Show ( exceptionObj . Message . ToString ()); } } private void deleteButton_Click ( object sender  EventArgs e ) { try { dataGridViewTrial . Rows . RemoveAt ( dataGridViewTrial . CurrentRow . Index ); sqlDataAdapter . Update ( dataTable ); } catch ( Exception exceptionObj ) { MessageBox . Show ( exceptionObj . Message . ToString ()); } } } Thanks & Regards Praveen Nelge