English 中文(简体)
如何保存对 DataGridView 的更改?
原标题:How to save changes made to DataGridView?
I thought I knew how to do this, but when I am actually doing it, doesn t seem like I know how to do this. What I am trying to achieve is display a filtered rows of table that is in dataset when search btn is clicked. Allow users to make changes on the datagridview or update selected rows with values provided on textbox on the update panel when Update btn is clicked. But I can t seem to achieve this. private void Display() { bindingSourceDisplay.DataSource=_dsNorthwind.Customers.Where(x=>!x.IsRegionNull() && !x.IsFaxNull() && !x.IsPostalCodeNull()).Take(10); dgvSearchResult.DataSource = bindingSourceDisplay; } internal void UpdateSelectedRows(UpdateBtnClickedEventArgs e) { //cannot do this because datagridviewselectedrow and customerrow are a type mismatch foreach (DS_Northwind.CustomersRow selectedRow in dgvSearchResult.SelectedRows) { selectedRow.Phone = e.PhoneNum; selectedRow.PostalCode = e.PostalCode; } //how do I update each selected rows in datagridview? Can t do selectedRow.Cells["ColName"] either for some reason... //if my dataset is connected to my database, isn t saving changes as simple as doing accept changes? _dsNorthwind.AcceptChanges(); }
问题回答
It seems you are missing a DataAdapter obejct. Look at this post: Updating Database using Datagrid in C#




相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

NSArray s, Primitive types and Boxing Oh My!

I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...

C# Marshal / Pinvoke CBitmap?

I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...

How to Use Ghostscript DLL to convert PDF to PDF/A

How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...

Linqy no matchy

Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...

热门标签