Grid - How to show a progress bar in a cell. 1: When we going to Export in to.PDF format, progressbar showing but the progressbar desired cell value not showing in PDF file. 2: When we going to Export in to.XLSX format the progressbar value is showing but progressbar not showing. 3: Custom 'column Caption text' not showing properly in both XLSX.
I have a DataGridView in which I load data from a SQL server database. When I load the data it takes quite long time.I would like to give user information that the data is loading. May I ask you what is the best way connecting Progressbar when data is loading into the DataGridView?I don't want anyone to make a fully working code for me. I just would like to know how it can be done.I see someone awarded my question with bounty.
I would like to say that at the moment Iam using this code which I would appriciate if it would fit. DTGdataTable = new DataTable;SqlDataAdapter SDA = new SqlDataAdapterSDA.Fill(DTGdataTable);dataGridView1.DataSource = DTGdataTable;Thank you everyone for your time. The problem is all the data load together and return back from database.You need to get the data loading progress. This can be done from database.Get the count to data rows from database. (This query would return a single number, so it would be quicker).Get the data in parts (Divide & conquer strategy), you can use OFFSET and FETCH database queries. (This is return part of data on each call)OFFSET and FETCH is available on different database.
In MSSQL, it was introduced in version 2012.When we are getting the data in parts from server, we can calculate the progress.
Hi,I am running a windows forms project.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |