Click here to Skip to main content

Submit your article

DataGridView

DataGridView

Great Reads

Reducing flicker, blinking in DataGridView

by Shweta Lodha

Reducing flicker and blinking in DataGridView.

Display Loading Indicator in Windows Form Application

by Dukhabandhu Sahoo

This article explains how to display a loading indicator (a GIF image) in Windows Forms application when some long running task is performed in the background.

Filtered Paged Sorted Customizable clientside Table

by Super Lloyd

A fully featured yet short (only 436 lines) replacement for datatables

C++ DateTimePicker in DataGridView

by Ger Hayden

C++ DateTimePicker in DataGridView

Latest Articles

Master Detail Datagridview in C#

by kevinuni

This is an alternative for "Master Detail Datagridview"

Paging WPF DataGrid

by WyoMetz

Simple and easy paging of a WPF DataGrid with DataTable and LINQ queries

File Explorer Clone with Tabs and Parallel File Search Tool

by Wade Harvey

This article shows how to use Winforms, WPF and C# to create a File Explorer Clone with Tabs and an extremely fast parallel file search utility.

Display Loading Indicator in Windows Form Application

by Dukhabandhu Sahoo

This article explains how to display a loading indicator (a GIF image) in Windows Forms application when some long running task is performed in the background.

All Articles

DataGridView

Reducing flicker, blinking in DataGridView

23 May 2012 by Shweta Lodha

Reducing flicker and blinking in DataGridView.

Datagridview automatically update in c#.

8 Apr 2011 by Wendelius

As already said, if you modify the contents of the same datatable in another window the datagridview binded to that datatable will be updated.If you want to do programmatic operations, one way that you add a new event in the frmNewBook, for example:public event System.Action...

Display Loading Indicator in Windows Form Application

7 Dec 2017 by Dukhabandhu Sahoo

This article explains how to display a loading indicator (a GIF image) in Windows Forms application when some long running task is performed in the background.

The delete button is too slow what is the problem

8 Jan 2019 by RickZeeland

Instead of sending lots of commands you could try sending one command using the "IN" clause, see example here: SQL IN Operator[^]

Filtered Paged Sorted Customizable clientside Table

27 Jun 2014 by Super Lloyd

A fully featured yet short (only 436 lines) replacement for datatables

C++ DateTimePicker in DataGridView

15 Oct 2010 by Ger Hayden

C++ DateTimePicker in DataGridView

How to make the selected datagridview row ReadOnly Property to false

15 Apr 2011 by OriginalGriff

Try: DataGridViewRow r = dataGridView1.SelectedRows[0]; if (r != null) { r.ReadOnly = false; }

DataGridView selected row's column values to textbox

5 Oct 2011 by André Kraak

You will probably want to respond the to the DataGridView.SelectionChanged Event[^].In its handler check if a single row has been selected then get the values from that row and place them in the text boxes.private void DataGridView1_SelectionChanged(object sender, EventArgs e){ if(...

Drag drop multiple selected rows of datagridview with left mouse button

2 Mar 2012 by PWFisch

Drag drop multiple selected rows of datagridview with left mouse button

DataGridView Find String

7 Jun 2012 by VJ Reddy

If your purpose is to find the Cell in the DataGridView containing a given Text, then I think it is better to use the Rows and Cells collection of DataGridView to generate a List of DataGridViewCell which contain the given text. Then on a button click set the CurrentCell of DataGridView to the...

Dynamic object binding

14 Aug 2012 by Clifford Nelson

I am trying to bind a dynamic object to a DataGridView using a BindingSource. Is there some way to bind a DataGridView, so some other grid to a dynamic object? I cannot even hard code columns and get the binding to work.UpdateWhen talking about dynamic object I am talking about an object...

Row associated with the currency manager's position cannot be made invisible

21 Sep 2013 by Mike Meinz

A Google search found this[^] answer.It looks like you have to suspend binding and then resume binding. I adapted example from the web page found at the link above.CurrencyManager currencyManager1 =...

how to make multi line cells in data grid view

3 Nov 2013 by CHill60

Firstly make the cells that you are interested in wrappable by setting the default style ... dataGridView1.Columns[0].DefaultCellStyle.WrapMode = DataGridViewTriState.True;Note I've chosen only the first column here [0]. If you wanted all cells to wrap then use...

Loop through datagridviews on a tabcontrol

2 Apr 2019 by BillWoodruff

You gotta drill-down; I'd use Linq: private List DGViews; private void Form1_Load(object sender, EventArgs e) { DGViews = tabControl1.TabPages .Cast() .SelectMany((TabPage tab) => tab.Controls.OfType()) .ToList(); } Since every...

Summing columns

23 Oct 2010 by shakil0304003

I think there is some problem in your code. Write something like this decimal mon = 0; decimal comPrice;for (int i = 0; i

How to differentiate Records

13 Jan 2011 by Simon_Whale

import the excel data and run an outer join queryAccess Outer join query[^]

Editing selected dataGridView row in another form ?

19 Feb 2011 by Abhinav S

This[^] example should definitely help you out.

Inconsistent accessibility Error

16 Mar 2011 by Henry Minute

If you want to use your Enter_DataGridView in other projects, it should be declared as public. public class Enter_DataGridView { ................... }

How to bind to a header of data grid view?

11 Feb 2012 by Wonde Tadesse

Google will give you lots of articles. Perhaps you should search it before asking quesion. Anyways here is what found for you.Using The Silverlight DataGrid[^]

Change mouse cursor on DataGridViewCell Hover

7 Apr 2012 by VJ Reddy

The CellMouseEnter event of DataGridView control can be used for this purpose as shown belowprivate void dataGridView1_CellMouseEnter(object sender, DataGridViewCellEventArgs e) { //Skip the Column and Row headers if (e.ColumnIndex

merging tables in code behind

17 Apr 2012 by VJ Reddy

The Merge method of DataTable can be used for this purpose as shown below:Private Sub Main() Dim people As New DataTable() people.Columns.Add("Id", GetType(Integer), Nothing) people.Columns.Add("Name", GetType(String), Nothing) people.PrimaryKey = New DataColumn()...

Draw On DataGridView on a separate surface i.e. Panel to create a layer effect

16 Jun 2012 by Dave Kreskowiak

You don't need the Panel at all.Create your own DGV class by inheriting from it, then override the OnPaint method with something like:Public Class MyDGV Inherits DataGridView Protected Overrides Sub OnPaint(e As System.Windows.Forms.PaintEventArgs) ...

Copy Rows from One DataGridView to Other DataGridView in C#

9 Jul 2012 by Prasad_Kulkarni

Refer:Copyin...

Copying DataGridView Contents To Clipboard

9 Nov 2012 by miteleda

Copy DataGridView contents to clipboard regardless of current selection.

How to Highlight Datagridview CELL not a ROW.

12 Mar 2013 by OriginalGriff

First off, that test will never work:theRow.Cells[colIndex].Value.Equals(null)Translates to:Object o;o.Equals(null)If the object being tested is null, then there is by definition no instance to call the Equals method on, and since it cannot be static, a null value will always throw an...

passing primary key from one form to another

24 Oct 2013 by Sergey Alexandrovich Kryukov

In essence, this is the popular question about form collaboration. The most robust solution is implementation of an appropriate interface in form class and passing the interface reference instead of reference to a "whole instance" of a Form. Please see my past solution for more detail: How to...

Configurable Data Generator for GridView and DataTable

17 Nov 2013 by Hazem Torab

Generate reasonable sample data for you GridView without using databases.

Sudoku Generator using DataGridView

21 Feb 2014 by Ivan Tsurkan

Sudoku Generator

How To Set The Cursor Property To DataGridViewComboBoxColumn?

12 Jun 2014 by Sergey Alexandrovich Kryukov

You cannot directly do it, because columns of the DataGridView are not controls. You can try to achieve desired effect by modifying the property Cursor of this control, depending on the current location of the mouse withing the control, using columns widths to calculate the location of each...

Bind ComboBox and Other Controls to DataGridView using STT

25 Mar 2015 by TarikHuber

Use STT (SQL Table Toolkit) to bind WinForm Controls to a DataGridview and to define ComboBox data sources

DataGridView with Formula Support

14 Jan 2017 by Miguel Diaz Kusztrich

Custom DataGridView that allows you to add formulas to cells

Loop through datagridviews on a tabcontrol

4 Apr 2019 by Richard Deeming

Here's a helper method I find useful in this sort of situation: public static class TreeExtensions { public static IEnumerable SelectRecursive(this IEnumerable source, Func> getChildren) { if (source is null) throw new...

Vb.net datagridview add empty rows ?

14 Jul 2020 by CHill60

In your example code you appear to be trying to do both methods. Pick one. See the comment from @Richard-MacCutchan. If you go down the datatable route dgvOne.DataSource = dt then add 12 blank rows to the datatable before assigning it to the...

Enter key as tab not working properly in datagridview

1 Jul 2023 by Graeme_Grant

Microsoft Excel moves the cursor down a row if the enter key is used. I would recommend using this as it is familiar. However, to move the cursor right, not down, on using the Enter key, it is possible. The following code will wrap the cursor...

custom-controls

DataGridView, add unique gradient to each Row

22 Apr 2010 by William Winner

You probably want to override the RowPrePaint event. There is sample code at DataGridView..::.RowPrePaint Event[^] on how to paint a gradient row background if the row is selected. You would just need to modify it to your needs.[Update]Man, it took me forever to actually figure out how...

DataGridView data editing

18 May 2010 by radix3

hello,I have tried to solve this query in button1 i have binded the grid with data and in button 2 i whatever u edit in the grid and hit button2 those records will be saved in the databaseusing System;using System.Collections.Generic;using System.ComponentModel;using...

DataGridView Exception

21 Jul 2010 by Sandeep Mewara

Error is in this part of code:for (int i = 1; i

Write something While datagridview is loading

31 Oct 2010 by Nish Nishant

You need to load the data in a background worker thread, so your main UI thread will remain responsive while the data loads. This will let you show a loading message on the dialog/form while the user is waiting for the data to load.

simple question about sql server and c#

24 Nov 2010 by Toniyo Jackson

As i understand ur question,Select count(*) from tablename where paidDate >= '01/11/2010' and paidDate

simple question about sql server and c#

24 Nov 2010 by Sandeep Mewara

Well, first of all design the datavase tables such that you can capture all data.For now, assuming once a transporationID is related to a ClientID, whole month is used. It would give something like, transportation cost of that transportationID * 30 days!Thus, to be generic, you need to...

Change the RightToLeft property of DataGridView for a column

5 Dec 2010 by wILDFriCK

Hi all,How can I change the RightToLeft property for the column of a DataGridView and not the whole DataGridView.i.eI want my DataGridView to contain two columns, one RightToLef and the other one LeftToRight.Solution found:Handle the DataGridView.CellPainting event and add the...

Whats best practice regarding DataGridView and Entity Framework

29 Dec 2010 by Ole Morten Heien

Hi all.I have a question for you regarding EntityFrameWork and DataGridView. Actually this Q is more generic because it would be the same if using EntityFramework, DataSet/DataTable, Linq2Sql, etc. etc.Ok. Here goes:I have a DataGridView. This DataGridView is filled with data from a...

How do I get cell value after change in CellValidating Event within DataGridView

5 Feb 2011 by OriginalGriff

Use the DataGridViewCellValidatingEventArgs.FormattedValue property[^]

how to use paging in datagrid in asp.net

14 Mar 2011 by Sandeep Mewara

:doh:I am sorry but there is no quick question here. This is your college assignment, you should put some effort.We expect you to put some time in trying the issue that you are facing and then some time in formulating the question while posting here. I see both missing. :doh:Here is...

Submit changes from DataGridView (which it's datasource is a LINQ query) to actual database

27 Mar 2011 by Albin Abel

You can do in LinQ. You can even submit multiple changes at once.From the grid view event get the key for the row, which can be used to query the linQ object.For example assume you have Products table in your dataContext class. 1)Instantiate it. 2) Get Product LinQ object you...

DataGridView AutoGenerateColumns on Binding

6 Apr 2011 by Henry Minute

When you define your columns set the DataPropertyName property to the required column from the dataset. MSDN Example[^].

How to make the selected datagridview row ReadOnly Property to false

15 Apr 2011 by a1mimo

if you want the row ReadOnly property to be false then use thisdataGridView1.CurrentRow.ReadOnly = false;

Insert a New Record to Table

18 Apr 2011 by DipaliKolhe

Use gridView.Rows.Insert(0, gridviewRow)

DataGridView with ComboBox events [Solved]

13 Jul 2011 by wizardzz

I casted sender as DataGridViewComboBoxEditingControl. I was unaware of this object, but it seems to have a row property that I needed.

I have a class containing a list...

16 Jul 2011 by Marc Clifton

Not that I would normally do this, I'm actually just goofing around with .NET's DataGridView...but I have class, Person, that has a List as a property.I'm creating a BindingSource with a DataSource=new List();OK, fine, the grid displays the properties in Person. But...

datagridview multiselect but on 1 row only

5 Oct 2011 by markypm

hi guys,so i want the user to be able to select multiple rows. i've done this by setting multiselect = true and selectionmode = cellselect.. the problem is the selections spans multiple rows.. i want the user to only be able to select on the row where he/she first mousedown..any suggestions?

datagridview multiselect but on 1 row only

5 Oct 2011 by Sergey Alexandrovich Kryukov

It sounds like you want multi-select and single-select at the same time :-). Not so, of course: what you want is clear: to have arbitrary cell selection within the single row.Such DataGridViewSelectionMode option does not exists, and I think, for a good reason: the users expect something...

remember selection from previous form

17 Nov 2011 by Wayne Gaylard

Just pass the id for the new member in the constructor of the edit form, and use it to select the right person in the datagrid.Hope this helps.In reply to your comment.Say your second form was called EditForm, then you would create a constructor in this form that takes an int...

Text from datagrid view into variable string c#

17 Nov 2011 by OriginalGriff

No. Sorry.But - you can tell yourself where it is.If you can cause a failure in development, then put a breakpoint on the MessageBox line, and examine the exception itself. SQL server is pretty good at reporting problems, and it can help you quite a bit with what it causing it. You can...

Filtering beyond DataSets

20 Nov 2011 by Mehdi Gholam

I have found a possible solution here : http://www.dotnetmonster.com/Uwe/Forum.aspx/winform-data-binding/1042/BindingSource-Filter-fails-when-datasource-derives[^]

Double Click in Datagridview, display in textboxes on new form

5 Feb 2012 by Shahin Khorshidnia

Hello,I hope it helps:Following code generates a "Winform" and a number of "TextBox"es dynamically.private void MyGrid_DoubleClick(object sender, EventArgs e){ if (this.MyGrid.SelectedRows.Count == 0) return; System.Windows.Forms.Form form = new...

How to sort dataset with xml

23 Feb 2012 by Maciej Los

First of all you need to understand Scope of variables[^]And here[^] you'll find complete example (ReadXml & WriteXml).

Copy Rows from One DataGridView to Other DataGridView in C#

27 Dec 2017 by Itz.Irshad

Hi All,How we can copy one or more than one rows from a data grid view to other data grid view on same form. Here, I've searching option which search from the first grid and if found some matching rows then copy them to 2nd grid. How I can achieve this ?Thanks

Dynamic object binding

14 Aug 2012 by Clifford Nelson

Finally gave up using DynamicObject. Created a DataTable instead: public static DataTable CreateTable(IEnumerable model){ var Good = imageToByteArray(Properties.Resources.Check16); var Bad = imageToByteArray(Properties.Resources.Block16); var table = new...

How to make dataGridViewTextBoxColumn receive a datetime value

5 Jan 2013 by Reza Alipour Fard

HiI test you code it execute without error.Please attend to bellow point:1)This code is OK.dataGridView1.CurrentRow.Cells[YourColumnNumber].Value = DateTime.Now;2)The first column number is zero, therefore if you want add date to third column you must use from 2 az...

Datagridview in WindowsForm

12 Mar 2013 by Abhinav S

You can get the last row cell value as described here[^].Once you have this value, simply do string.contains[^] on this text.

Can't catch Enter Key in Custom EditingControl

17 May 2013 by Mayur Panchal

I think u should handle OnPreviewKeydown event to catch 'Enter' key in user control and write your stuff there.

custom-controls

Validation check is only checking the first if statement and ignoring the second

3 Jul 2013 by santosh_131

If the cell has to be checked for both the conditions try the following code:If (e.ColumnIndex = 0) Then 'checking value for column 1 only Dim cellData As Integer IF Not DataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Value is DBNull.Value Then If...

How to make Enter to work as tab key in datagridview and cell leave error if cell is empty

3 Aug 2013 by Aarti Meswania

create a custom control inherit from gridview override below two methods. and use this custom gridview instead of datagridview.Protected Overrides Function ProcessDataGridViewKey(ByVal e As System.Windows.Forms.KeyEventArgs) As Boolean Try If e.KeyCode =...

How would I convert this c# code to vb.net?

8 Aug 2013 by Sergey Alexandrovich Kryukov

In addition to on-line tools for translation (the one referenced in Solution 1 seems to be one of the best), there is a really good and comprehensive off-line open-source solution.This is ILSpy:http://www.ilspy.net/[^],http://en.wikipedia.org/wiki/.NET_Reflector[^].First, you need to...

Updating a dataset and displaying it back to datagridview

24 Aug 2013 by Dave Kreskowiak

That code does not update a DGV. It updates a DataTable, which you then have to bind to a DGV.You can find an example of using the OleDataAdapter here[^].

Fetch from sql tables using loop

16 Sep 2013 by Maciej Los

Test it:DECLARE @lessons TABLE(LessonID INT IDENTITY(1,1), LessonName VARCHAR(30))INSERT INTO @lessons (LessonName)SELECT 'lesson A'UNION ALL SELECT 'lesson B'UNION ALL SELECT 'lesson C'UNION ALL SELECT 'lesson D'--UNION ALL SELECT 'lesson E'DECLARE @subject_lesson TABLE...

Help: filtering the month of a datetime SQL column

18 Nov 2013 by bowlturner

You don't seem to be using SchedStart correctly in either of them. I am assuming that you are meaning to use the column name in all 4 places. in your first example you are saying where '2013-11-18' = 11; that is why you get null.what you'd want is where v_Month = MONTH(SchedStart). ...

SQL-Server-2005

Datagridview selected row passing to another form2 textboxes

19 Nov 2013 by T-Maz

public partial class Form1 : Form { public Form1() { InitializeComponent(); dataGridView1.Rows.Add( 1,2); } private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if...

"system.security.permissions.h...

19 Dec 2013 by agent_kruger

i have developed an application and it is running fine. But when i uploded the software to one of my client machine it gives the following error.system.security.permissions.hostprotectionattribute from assembly mscorlib.I Am using c# windows application and database is access.Note: On...

DataGridView Calculated Column update when move to new row C#

24 Dec 2013 by Maciej Los

Use one of DataGrigViewCell's method[^], for example OnLeave, and force datatable to re-calculate Total using Compute method[^].

SQL-Server-2005

Add a new row to a DataTable

13 Jan 2014 by OriginalGriff

Perhaps it would help is you added the new row to the table?DataTable.NewRow[^] just creates a new blank row with the correct schema / columns...

How Do I Segregate Decimal Column From Datatable To 2 Datagridview Columns Based On Value

14 Feb 2014 by OriginalGriff

Try:SELECT CASE WHEN field=0 THEN field ELSE 0 END AS Above FROM MyTable

use of unassigned local variable 'ext' - what is wrong here?

26 Feb 2014 by Sergey Alexandrovich Kryukov

The Solution 1 will help to formally compile the application, but it will leave it defective. You need to address the root cause of the problem. Think why it is not allowed to work with unassigned variables. A dummy value will allow your code to skip both if ... else if statements of your code,...

how do I show data from multiple tables in datagridview C# winforms

9 Mar 2014 by AndrewCharlz

Hi, Now You have Table : Vehicles, Months, Fuel_Bill, Lubi_BillI have one best idea to do this.Now these tables are related let me consider Vehicles Table have the Collection of various Vehicles. and each vehicle will have a unique id which is the primary key.secondly ill give u...

entity-framework

How do I use PIVOT in this scenario ?

29 Mar 2014 by Maciej Los

Have a look at example:--TDCREATE TABLE #tblTicketDetail( TicketID INT, IssuerName NVARCHAR(30), TicketDescription NVARCHAR(30))--ENCREATE TABLE #tblEngineer( EngineerID INT IDENTITY(1,1), [Name] NVARCHAR(30))--TECREATE TABLE...

get datagridview cell column values of specific row

21 Apr 2014 by ccalma

Use DataGridView1.CurrentRow.Cells("name").Value orDataGridView1.Rows(DataGridView1.CurrentCell.RowIndex).Cells("name").ValueDim rowContent As String = String.Empty For columnCounter As Integer = 0 To DataGridView1.ColumnCount - 1 rowContent = rowContent & " " &...

Loading data to DataGridView is taking lot of time.

25 Apr 2014 by Dave Kreskowiak

It takes forever because you're populating each cell, individually. That's 10,000 calls to set each cell. The DataGridView is NOT Excel! You're trying to force the DGV to do something it was not designed to do.On my machine, your code takes less than 1 second to run. What are you running...

DataGridView . Index was out of range when getting value from a cell

17 Aug 2014 by OriginalGriff

Two possibilities here:1) RowIndex is out of the range, 2) Cells is out of the range,If it isn't the RowIndex, then it has to be the Cells - are there any?Or...should that be dataGridView1 at all? The method name implies the control is called ExcelDGV...Use the debugger to look at...

Faster way to fill DataGridView

28 Sep 2014 by Dave Kreskowiak

Yeah, there's a faster way. DON'T LOAD IT UP WITH 50,000 RECORDS!!Honestly, who in their right mind is going to want to look at ALL Of those records?? NOBODY!!Use paging and filtering techniques to help the user get the dataset down to what THEY want to see, NOT what YOU want to throw...

Faster way to fill DataGridView

28 Sep 2014 by Raul Iloc

1.By default, in using the GridView control for manipulating a large amount of data (a few hundreds of rows), the performance is very low, and if the number of rows increases to several hundreds or several thousands, the web page becomes useless. Note that there is the loading time from DB, then...

How to pass data from childform to parentform

1 Apr 2015 by Maciej Los

I'd suggest to read this: Many Questions Answered at Once — Collaboration between Windows Forms or WPF Windows[^] and this: Transferring information between two forms, Part 1: Parent to Child[^]

VB.Net DatagridView Add Header

4 May 2015 by Peter Leow

Check this out DataGridView – Stacked Header[^]You have to translate it into vb.

how to align datagridview data in center

28 May 2015 by CHill60

Columns - in the designer click on the property ColumnHeadersDefaultCellStyle and select Layout, Alignment = MiddleCenterFor the data fields do the same for DefaultCellStyle

i have a question on c# datagridview

29 Jun 2015 by Animesh Datta

You can simple use Loop to clear the column value from DataGridViewforeach (DataGridViewRow myRow in dataGridView1.Rows) { myRow.Cells[0].Value = null; // assuming you want to clear the first column}

adding data to database from datagridview c#

4 Aug 2015 by Richard Deeming

Using a properly parameterized query will fix the SQL Injection[^] vulnerability in your code, and also fix the error you're seeing:using (SqlConnection connection = new SqlConnection("-YOUR CONNECTION STRING-"))using (SqlCommand command = new SqlCommand("INSERT INTO Bills (ItemName)...

SQL-Server-2008R2

Index was out of range. Must be non-negative and less than the size of the collection.

25 May 2016 by Alan N

-1 is the index of the header row and CellValueChanged events with RowIndex = -1 are raised when a Column's HeaderText property changes. You probably have no interest in these events and can ignore them by testing for RowIndex = -1 in the handler. For example:Private Sub...

Index was out of range. Must be non-negative and less than the size of the collection.

25 May 2016 by Dave Kreskowiak

The solution is kind of easy. The RowIndex is -1 because there is no selected row. So, just check for that and if it's -1 return, don't do anything.Next, you have to make sure that the index you're getting is actually a valid index for the range. So, check for it before you try to use an...

Filter datagridview in C#

21 Oct 2016 by Suvendu Shekhar Giri

One of the way is to, instead of adding rows to the datagridview, add datarows to a datatable and then once datatable is ready make it the datasource of your datagridview.Something like-DataTable table = new DataTable();table.Columns.Add("Name", typeof(String));table.Columns.Add("...",...

Change color cell in datagridview with condition C#

31 Oct 2016 by Mehdi Gholam

Try setting the cell style not the column :DataGridViewCell.Style Property (System.Windows.Forms)[^]datagridView1[1,1].Style.ForeColor = Color.ForestGreen;

entity-framework

How to select data from date

3 Jan 2017 by Wendelius

There are quite a few problems to fix. Consider the following alternativestring sql;DataSet dsa = new DataSet();DataTable dt = new DataTable();dsa.Tables.Add(dt);using (OleDbConnection connection = new OleDbConnection(connectionString)) { sql = @"SELECT * FROM [Sales Record]...

Winform | decrypt & load data in datagridview | slow

10 Apr 2017 by CHill60

Loading 25000 items into a User Interface is just silly. That is the politest way I can put it. WPF collections? I think your friends are talking rubbish. How to speed up the load times? 1. You should implement some sort of paging - for example only load the first 40 items until the User...

How to insert picture in the datagridview and converted it into the database VB.NET without using parameter

27 Aug 2017 by Patrice T

Never build an SQL query by concatenating strings. Sooner or later, you will do it with user inputs, and this opens door to a vulnerability named "SQL injection", it is dangerous for your database and error prone. A single quote in a name and your program crash. If a user input a name like...

C# select value from textbox and multiply

19 Sep 2017 by OriginalGriff

Move the bracket, and don't do it like that! Never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead. When you concatenate strings, you cause problems...

How to edit data in search result in C#

25 Oct 2017 by Richard Deeming

Try something like this: private DataRowView GetCurrentRowData() { if (JOGridView.CurrentCell == null) return null; int rowIndex = JOGridView.CurrentCell.RowIndex; if (rowIndex == -1) return null; return JOGridView.Rows[rowIndex].DataBoundItem as DataRowView; } ...

Crosstabs/Confusion Matrix for AI Classification Projects

18 Nov 2017 by asiwel

Construct a confusion matrix or crosstab for binary or multi-level classifier training or validation data in C#

artificial-intelligence

How do I export datagrid data to an XML?

9 May 2018 by Maciej Los

Maciej Los: Does your DataGridView is bind with datasource? If yes, what kind of datasource: BindingSource, DataTable, DataSet? Primo Chalice: It is DataSet In this case, the simplest way is to use: DataSet.WriteXml Method (System.Data)[^] and DataSet.ReadXml Method (System.Data)[^]

Showing error :index was out of range. In datagridview please help....

31 Jan 2019 by OriginalGriff

The VB For loop runs from the start to the end value inclusive - so this: For index As Integer = 0 To 3 Console.Write(index.ToString & " ") Next Will print 0 1 2 3 So your code For Z1 = 0 To DataGridView1.RowCount will work from the first index to the one after the last index inclusive,...

How do I convert an array to a list of double

4 Feb 2019 by OriginalGriff

Your first problem is: you have completely the wrong approach. Quote: When a user has many thousands of items selected in a DataGridView (we're talking hundreds of thousands or even millions) Do you seriously think that any user will conscientiously select that many records? That he will even...

How to fill datagrid without changing the header name.

8 May 2019 by OriginalGriff

Not like that! Never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Always use Parameterized queries instead. When you concatenate strings, you cause problems because SQL receives...