Insert, Update and Delete Records in a C# DataGridView

Sign in to leave a comment.

• UA

  Udochukwu John Anyanwu1y agoPosted Oct 9, 2024, 11:39 AM

  Please can you reach you via email..
• J

  Jimansh3y agoPosted May 14, 2023, 11:05 AM

  Thanks alot
  • 

    Anoop Kumar Sharma3y agoPosted May 14, 2023, 4:53 PM

    Thanks Jimansh for the comment
• MA

  Mark Neil Abian4y agoPosted Feb 2, 2022, 2:48 AM

  What about if there is a date time in my database and I want to update the data, but when I try to select that data to update, I get this error "String was not recognized as a valid date time"?
• HH

  Hitori Hitori5y agoPosted May 12, 2021, 1:41 PM

  Hi, could you lead me to fix database engine services that failed for SQL 2019,please ? :(((
• TS

  terter Santos5y agoPosted May 3, 2021, 6:19 AM

  Hi my code are showing message successfully updated but in datagridview and database are the same, nothing has changed. Thanks
• WE

  Wilfred Eghenedji5y agoPosted Feb 23, 2021, 12:33 PM

  Am working with Access as Database in C# (Visual Studio 15). I want to save form entries (add record) into the Access Database and would want the corresponding ID of the record to show upon successful saving.
• DD

  Danson Danson6y agoPosted Apr 30, 2020, 1:59 PM

  Hi. My records are showing update successful but when I check the database, nothing is updated, what could be the reason?
  • 

    Anoop Kumar Sharma6y agoPosted May 1, 2020, 1:45 AM

    Danson Danson, Make sure the ID parameter has non-zero value then the data in the database will be updated. Add a breakpoint in btn_Update_Click event and check the query as well as field value to find out the issue.
  • 

    Rohan Rao6y agoPosted May 1, 2020, 4:32 AM

    Danson Danson That might not be updating your data. If you refresh the page your changes would go away. That means your ID is not properly seeded in your update query. As Anoop Kumar Sharma said it has to be non-zero value.
• AS

  akhil sai6y agoPosted Oct 29, 2019, 2:48 AM

  Hi. I am able to add records to the table but when I select the record in the datagridview to update the columns then it is showing "Please select to update". same problem with delete. Kindly give me a solution and problem?
  • 

    Rohan Rao6y agoPosted Oct 31, 2019, 10:53 PM

    Check if you have properly generated the "RowHeaderMouseClick" event. Sometimes, it gets generated but doesn't work. In this case, remove this event and regenerate it and write the code again and then check.
• RR

  Rosemary Roopnarine6y agoPosted Oct 27, 2019, 10:09 PM

  Hi, I am able to add records to the table but when I select the record in the datagridview to update the columns are empty. Not sure what I am missing, if you can assist it would be appreciated.
• CG

  Chikits Garots7y agoPosted Oct 6, 2019, 1:28 PM

  Hello, I've used Auto specification in ID, somehow the rowheader which i clicked from the datagridview isn't inserting in text boxes. Thanks for the help
  • CG

    Chikits Garots7y agoPosted Oct 7, 2019, 12:44 PM

    I hope I get some response thank you so much.
• MS

  Marcus Sticher7y agoPosted Jun 7, 2019, 3:22 AM

  Good afternoon Anoop, my problem still the same: no automatic insertion of Id Number, error message same I listed. There is no identity added on that column. "Cannot insert the value NULL into column 'Id'(....).tbl_Record'; column does not allow nulls. INSERT fails.
  • 

    Rohan Rao7y agoPosted Jul 25, 2019, 12:53 PM

    This is because you have auto-incremented the ID value, but still you are providing a value to ID which is not required. Or other way round, you might have defined ID in database (not auto-incremented this time), but you are not supplying values to ID. Check both the scenario I told just now. I am sure you will find it.
  • 

    Rohan Rao6y agoPosted Feb 13, 2020, 4:23 AM

    This is because the ID that you have created is auto-generated. By using the above code you are inserting ID again on the existing ID in database. This is not possible. Better solution should be to remove the Auto-increment for ID from Database.
• UĐ

  Uy Long Nguyễn Đông7y agoPosted Jun 6, 2019, 4:50 AM

  I have an problem, my datatype in sql is smalldatetime, that was an Exception: System.Data.SqlClient.SqlException: 'Conversion failed when converting character string to smalldatetime data type.'
  • 

    Anoop Kumar Sharma7y agoPosted Jun 6, 2019, 12:44 PM

    You are sending the incorrect data format in the column/variable with dataType smalldatetime. Please debug it using breakpoint is Visual Studio.
• MS

  Marcus Sticher7y agoPosted Jun 6, 2019, 12:38 AM

  Cannot insert the value NULL into column 'Id',....dbo.tbl_Record'; column does not allow nulls. INSERT fails.
  • TH

    Tin Ho7y agoPosted Jul 5, 2019, 2:40 AM

    You need replace the insert query by this one "insert into tbl_Record(Id, Name,State) values((Select Max(Id) from Record) + 1,@name,@state)"
• MS

  Marcus Sticher7y agoPosted Jun 5, 2019, 4:57 AM

  Why in my project the ID (PrKey) is not inserted in no way, only error message? thanks
  • 

    Anoop Kumar Sharma7y agoPosted Jun 5, 2019, 5:35 AM

    Can you share what kind of error you are getting? Have you added identity on the primary key column?
• MS

  Marcus Sticher7y agoPosted Jun 5, 2019, 4:54 AM

  Thank you very much for this helpful sample, nothing superb like this in msd sites!
  • 

    Anoop Kumar Sharma7y agoPosted Jun 5, 2019, 5:34 AM

    Thanks, Marcus Sticher for your valuable comment.
• LK

  Lalrinchhana Khalthang7y agoPosted Apr 15, 2019, 10:26 AM

  How id ID number automatically counted
  • 

    Rohan Rao7y agoPosted Jul 25, 2019, 12:55 PM

    In the database where you have declared the ID row, go to Properties > you will find a field called 'Identity specification' > Expand the tree and click change the value of Identity increment to Yes.
• LK

  Lalrinchhana Khalthang7y agoPosted Apr 15, 2019, 10:26 AM

  Why ID number 1,2,3,4,6 come, why not 5
  • 

    Anoop Kumar Sharma7y agoPosted Apr 15, 2019, 12:03 PM

    One of the record with id 5 is already deleted so that's why you see the ID 1,2,3,4,6. That's just a sample preview of the example explained in this article.
• MN

  Mahnoor Naeem7y agoPosted Mar 30, 2019, 6:36 PM

  How to create dataGridView1_RowHeaderMouseClick Event??? I where I click in datagridView to create event please tell me??
  • 

    Anoop Kumar Sharma7y agoPosted Mar 31, 2019, 1:38 AM

    Select the Datagridview first then go to properties window. Click on Event icon in order to find the RowHeaderMouseClick Event of the DataGridView.
• JB

  Jim Brillantes7y agoPosted Mar 17, 2019, 5:14 AM

  Good day, I followed your tutorial and did everything on it. It does save on the datagridview, but if I stop the program and check the database, there are no records saved and the datagridview will be empty again after re-running the program.
• VT

  Valmy Tesmoingt7y agoPosted Jan 26, 2019, 10:49 AM

  Hello,Although this does not persist in the table, can you still tell me how to prevent changing the content of the datagridview, so that the only manipulation that can be made is to select a line? Thank you in advance.
• EA

  elnaz Amanollahy7y agoPosted Dec 26, 2018, 11:14 PM

  When a I select a row ,that info doesn't appear in the boxes
• 

  Jet Well8y agoPosted Sep 27, 2018, 8:02 PM

  That's late reply but i appreciate you for this example
• MS

  mp singh8y agoPosted May 29, 2018, 2:25 AM

  When I have changed in adding two more textbox thenover the insert button is properly working but the update and delete button is not working....pls send me the correct code for update and delete in gridview on [email protected] u
• PB

  Philip Bowser8y agoPosted Jan 25, 2018, 9:52 AM

  Update and Delete does not work at all it skips the IF statement in the delete.. and in the update button does not change the database values. Both problems seem to be related to the fact that ID int value stays at 0 when selecting row.
  • CJ

    Cimler Jan8y agoPosted May 15, 2018, 1:47 AM

    Hi Philip. I downloaded all and in my PC working all well.
• SV

  sophea vetey8y agoPosted Jan 15, 2018, 1:35 AM

  Why i use for in datagridview row not datatable show in textbox.
• AM

  Avinaash Menda8y agoPosted Jan 1, 2018, 3:45 AM

  There is nothing mentioned about ID - It wont allow to edit or update or insert if its null.
• 

  Muhammad Sulaman8y agoPosted Nov 23, 2017, 1:41 AM

  I really appreciate your work bro, thank you for your convince
• SD

  Swasthika Damle8y agoPosted Nov 14, 2017, 9:30 AM

  Thank you so much!!!!!
• VS

  vk sony9y agoPosted Aug 13, 2017, 2:48 AM

  Public void ExecStatement(String sql, List<SqlParameter> Parameters, SqlTransaction MyTrans) { using (SqlCommand cmd = SqlCmnd()) { cmd.CommandText = sql; cmd.Transaction = MyTrans; for (int i = 0; i < Parameters.Count; i++) cmd.Parameters.Add(Parameters[i]); cmd.ExecuteNonQuery(); } }
• SK

  sathish kumar9y agoPosted Jul 27, 2017, 9:33 AM

  Delete operation,update operation on grid not working,any property should change for data grid..? please tell me..datagrid click event not work..
• SK

  sathish kumar9y agoPosted Jul 27, 2017, 9:31 AM

  Data grid properties option change
• 

  Hammouzine Meddour9y agoPosted May 23, 2017, 9:21 AM

  Pls sir, how to create the database, we use SQL server?
  • AK

    Aditya Kumar9y agoPosted May 30, 2017, 1:54 AM

    Create database databaseName
  • AK

    Aditya Kumar9y agoPosted May 30, 2017, 1:55 AM

    For eg- create database Test "Test" will be the database name. Hope it helps you.
  • 

    Krishna Rajput Singh9y agoPosted Aug 18, 2017, 6:10 AM

    Hammouzine Meddour for your question my article hope helpful for you here you find all details how to create database and table insert delete and update more visite here.................................................................................................................................http://www.c-sharpcorner.com/UploadFile/a5f59f/how-to-create-database-in-sql-server-2008/

  View 1 more reply
• AK

  Aditya Kumar9y agoPosted Mar 28, 2017, 5:06 AM

  Sir you have written one airticle where you are showing datagrid view row on the condition based and changing the colur as well in windows application? Can you please post that airticle link here? Thanks.
• MB

  Milo Beitia9y agoPosted Mar 27, 2017, 12:05 AM

  'DataTable' does not contain a definition for 'datasource' and no extension........
• WM

  Worshipful Master9y agoPosted Mar 6, 2017, 2:42 PM

  No work, error in sql conection. Can you help me, Please !!! Where is error???
• AO

  Ahmet Ozkurt9y agoPosted Feb 20, 2017, 2:10 PM

  Hi, can you set up to access.
• AA

  ali ashrafi9y agoPosted Feb 17, 2017, 5:09 PM

  In wpf application I don't have a rowheadermouseclick an I use the mouse double click an in this method don't have rows.[e.RowIndex]
• AA

  ali ashrafi9y agoPosted Feb 17, 2017, 5:07 PM

  This code is not work on wpf application ineed the wpf code in this part ???private?void?dataGridView1_RowHeaderMouseClick(object?sender,?DataGridViewCellMouseEventArgs?e)?? ????????{?? ????????????ID?=?Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());?? ????????????txt_Name.Text?=?dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();?? ????????????txt_State.Text?=?dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();?? ????????}
• SS

  sunny sharma9y agoPosted Feb 17, 2017, 7:06 AM

  Nice oneIt keeps giving me connection error to the database by saying the following:
• XZ

  xinyu zhang9y agoPosted Jan 5, 2017, 3:41 PM

  It keeps giving me connection error to the database by saying the following:
• PS

  pooja suthar9y agoPosted Nov 30, 2016, 1:22 AM

  Nice ..but how to show tinserted data into gridview which located at another webform
• ST

  SHIVANI TRIPATHI9y agoPosted Nov 18, 2016, 10:47 AM

  I'm having connection property has not been initialized error help....
• 

  Rajesh Pawde9y agoPosted Oct 27, 2016, 7:13 AM

  Nice One Thanks !!!
  • 

    Anoop Kumar Sharma9y agoPosted Oct 27, 2016, 2:15 PM

    Thanks Rajesh Pawde.!!
• BS

  Buntu Subs10y agoPosted Oct 15, 2016, 4:39 AM

  I Input Datasource path, but same error
• AS

  Abhi Sanghvi10y agoPosted Sep 19, 2016, 10:05 PM

  Now datagridview error some time note display the data and how to increase the column width like in your program name width
• AS

  Abhi Sanghvi10y agoPosted Sep 17, 2016, 7:21 AM

  Error in run time help me please
  • 

    Anoop Kumar Sharma10y agoPosted Sep 17, 2016, 12:51 PM

    Plz Share error details so that I can help you.
• HM

  Harshit Mehta10y agoPosted Aug 23, 2016, 8:39 AM

  What if there was a combobox field instead of a textbox field? For example, if there was a combobox for 'State' field inside the datagridview as well as outside the datagridview.
  • AF

    Amine Farhat9y agoPosted Feb 3, 2017, 6:53 AM

    U can get the data provided by the combobox by the combobox.text
• 

  Laura Alma10y agoPosted May 31, 2016, 11:08 PM

  I'm beginning to learn c# by myself and this was really really helpful! i'm trying to figure out how to display the DataGridView and the Text Boxes in different forms right now, but this gave me a place where to start! Thank you so much!
  • 

    Anoop Kumar Sharma10y agoPosted Jun 1, 2016, 1:33 PM

    Thanks, Laura Alma for appreciation. :)
• KC

  kavita chavan10y agoPosted Mar 18, 2016, 4:36 AM

  nice
  • 

    Anoop Kumar Sharma10y agoPosted Mar 18, 2016, 5:14 AM

    Thanks kavita chavan..!!
• SC

  Shraddha Chavan10y agoPosted Feb 23, 2016, 3:29 AM

  what is ID in this code????
• 

  Chandu Kumawat10y agoPosted Dec 29, 2015, 2:33 AM

  nice
• 

  Vijay Kumar10y agoPosted Dec 15, 2015, 9:54 AM

  its
• 

  Anoop Kumar Sharma10y agoPosted Nov 17, 2015, 10:21 AM

  Thanks Divya..!
• 

  Divya10y agoPosted Nov 16, 2015, 12:21 AM

  great its helpful . thank you sir
• ZS

  zosangzuala sailo10y agoPosted Nov 6, 2015, 4:25 AM

  I cannot access the private variable(i.e variable dat is assign da datagridview value from another private.how can i access.thank u..
• RK

  Raj Kumar11y agoPosted Oct 20, 2015, 12:45 AM

  What do I do if "DisplayData()" is considered an error. And there is an error message that reads: The name "DisplayData" does not exist in the current context. PLEASE HELP
• BR

  bhushan raikwad11y agoPosted Oct 2, 2015, 5:51 AM

  When I m select the row nt show me data in txtname and txtstate.
• BR

  bhushan raikwad11y agoPosted Oct 2, 2015, 5:50 AM

  Not use update and delete command
• 

  Shahbaz Ahmad11y agoPosted Sep 1, 2015, 2:36 AM

  its great but i need all are operation are must be inside datagrid not use outside like textbox and buttons ..
• 

  Anoop Kumar Sharma11y agoPosted Aug 7, 2015, 10:08 AM

  Thanks Navnath Ugale..! :-)
• NU

  Navnath Ugale11y agoPosted Aug 7, 2015, 7:33 AM

  Good Very nice !!!!!!!!!!!!!!
• AC

  Alexander Chrome11y agoPosted Jul 21, 2015, 10:01 PM

  What do I do if "DisplayData()" is considered an error. And there is an error message that reads: The name "DisplayData" does not exist in the current context. PLEASE HELP
  • 

    Anoop Kumar Sharma11y agoPosted Jul 22, 2015, 12:18 AM

    I think you have not created DisplayData method in code behind file. Please Share code in forum or mail me so that I can find your mistake and help you.
  • RM

    Rishu Mohammed11y agoPosted Oct 9, 2015, 2:00 AM

    I have same error
• 

  Anoop Kumar Sharma11y agoPosted Jul 5, 2015, 9:26 AM

  Thanks nassim louchani
  • AC

    Alexander Chrome11y agoPosted Jul 21, 2015, 10:02 PM

    What do I do if "DisplayData()" is considered an error. And there is an error message that reads: The name "DisplayData" does not exist in the current context. PLEASE HELP
• NL

  nassim louchani11y agoPosted Jul 5, 2015, 2:53 AM

  Good !
• 

  Anoop Kumar Sharma11y agoPosted May 25, 2015, 12:36 AM

  You're Welcome.. majedul islam..!! :-)
• 

  majedul islam11y agoPosted May 23, 2015, 1:25 PM

  thanks
• 

  Anoop Kumar Sharma11y agoPosted Apr 6, 2015, 12:22 PM

  Thanks Karthik K..!!
• 

  Karthik K11y agoPosted Apr 6, 2015, 12:11 PM

  Good one..
• 

  Anoop Kumar Sharma11y agoPosted Mar 23, 2015, 1:58 AM

  Thanks Khargesh Rajput
• 

  Khargesh Rajput11y agoPosted Mar 23, 2015, 12:04 AM

  nice
• 

  Anoop Kumar Sharma11y agoPosted Mar 22, 2015, 7:00 AM

  Thanks RAK?SH Sir.!
• 

  Rakesh11y agoPosted Mar 22, 2015, 5:44 AM

  good one :)
• 

  Sibeesh Venu11y agoPosted Mar 21, 2015, 11:04 PM

  Anoop Kumar Sharma You are welcome.
• 

  Anoop Kumar Sharma11y agoPosted Mar 21, 2015, 10:18 PM

  Thanks Sibeesh Venu SIr..!
• 

  Sibeesh Venu11y agoPosted Mar 21, 2015, 9:17 PM

  Nice one.
• 

  Anoop Kumar Sharma11y agoPosted Mar 21, 2015, 1:26 PM

  Thanks Gowtham Rajamanickam..!! :-)
• 

  Gowtham Rajamanickam11y agoPosted Mar 21, 2015, 11:47 AM

  good one...