Information grid is strongest part of the .internet atmosphere and can be utilized to populate knowledge internet/ and widows averment. On this tutorial I’m going to show you few knowledge dealing with strategies of knowledge grid management. It offers you to develop knowledge pushed utility in .internet atmosphere and supply some nice and wanted futures like pagination, sorting, row modifying and so forth.
I’m right here going to introduce a few of the coding approach that may be very helpful to improvement of knowledge grid base functions.
At initially we have to know easy methods to bind the information. Information grid routinely binds the information sources like dataset/ IList, IBindingList, IListSource and so forth. and able to routinely load the information.
1 2 3 4 5 6 |
<ol> <li class="li1"><div class="de1">Record<span class="sy0"><</span>Buyer<span class="sy0">></span> customerList <span class="sy0">=</span> <a href="https://www.google.com/search?q=new+msdn.microsoft.com" rel="nofollow"><span class="kw3">new</span></a> Record<span class="sy0"><</span>Buyer<span class="sy0">></span><span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1">grdCustomer<span class="sy0">.</span><span class="me1">DataSource</span> <span class="sy0">=</span> customerList<span class="sy0">;</span> </div></li> </ol> |
Above code routinely load the information with none formatting. A while you want to present formatted knowledge on knowledge grid scenario like desk has giant column and we need to visualized some.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 |
<ol> <li class="li1"><div class="de1"> <span class="kw4">void</span> CreatingGrid<span class="br0">(</span>Record<span class="sy0"><</span>Firm<span class="sy0">></span> CmpnyList<span class="br0">)</span> </div></li> <li class="li1"><div class="de1"> <span class="br0">{</span> </div></li> <li class="li1"><div class="de1"> DataTable dtCompany <span class="sy0">=</span> <a href="https://www.google.com/search?q=new+msdn.microsoft.com" rel="nofollow"><span class="kw3">new</span></a> DataTable<span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> dtgCompany<span class="sy0">.</span><span class="me1">DataSource</span> <span class="sy0">=</span> dtCompany<span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> dtCompany<span class="sy0">.</span><span class="me1">Columns</span><span class="sy0">.</span><span class="kw1">Add</span><span class="br0">(</span><span class="st0">"COMPANY ID"</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> dtCompany<span class="sy0">.</span><span class="me1">Columns</span><span class="sy0">.</span><span class="kw1">Add</span><span class="br0">(</span><span class="st0">"COMPANY CODE"</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> dtCompany<span class="sy0">.</span><span class="me1">Columns</span><span class="sy0">.</span><span class="kw1">Add</span><span class="br0">(</span><span class="st0">"COMPANY NAME"</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> dtCompany<span class="sy0">.</span><span class="me1">Columns</span><span class="sy0">.</span><span class="kw1">Add</span><span class="br0">(</span><span class="st0">"COMPANY ADDRESS"</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> dtCompany<span class="sy0">.</span><span class="me1">Columns</span><span class="sy0">.</span><span class="kw1">Add</span><span class="br0">(</span><span class="st0">"COMPANY PHONE"</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> <span class="co1">//dtCompany.Columns.Add("Edit");</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> <span class="kw1">foreach</span> <span class="br0">(</span>Firm firm <span class="kw1">in</span> CmpnyList<span class="br0">)</span> </div></li> <li class="li1"><div class="de1"> <span class="br0">{</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> dtCompany <span class="sy0">=</span> <span class="br0">(</span>DataTable<span class="br0">)</span>dtgCompany<span class="sy0">.</span><span class="me1">DataSource</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> dtCompany<span class="sy0">.</span><span class="me1">Rows</span><span class="sy0">.</span><span class="kw1">Add</span><span class="br0">(</span>dtCompany<span class="sy0">.</span><span class="me1">NewRow</span><span class="br0">(</span><span class="br0">)</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> dtCompany<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">[</span>dtCompany<span class="sy0">.</span><span class="me1">Rows</span><span class="sy0">.</span><span class="me1">Depend</span> <span class="sy0">-</span> <span class="nu0">1</span><span class="br0">]</span><span class="br0">[</span><span class="nu0">0</span><span class="br0">]</span> <span class="sy0">=</span> firm<span class="sy0">.</span>_com_id<span class="sy0">.</span><span class="me1">ToString</span><span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> dtCompany<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">[</span>dtCompany<span class="sy0">.</span><span class="me1">Rows</span><span class="sy0">.</span><span class="me1">Depend</span> <span class="sy0">-</span> <span class="nu0">1</span><span class="br0">]</span><span class="br0">[</span><span class="nu0">1</span><span class="br0">]</span> <span class="sy0">=</span> firm<span class="sy0">.</span><span class="me1">com_code</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> dtCompany<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">[</span>dtCompany<span class="sy0">.</span><span class="me1">Rows</span><span class="sy0">.</span><span class="me1">Depend</span> <span class="sy0">-</span> <span class="nu0">1</span><span class="br0">]</span><span class="br0">[</span><span class="nu0">2</span><span class="br0">]</span> <span class="sy0">=</span> firm<span class="sy0">.</span><span class="me1">com_name</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> dtCompany<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">[</span>dtCompany<span class="sy0">.</span><span class="me1">Rows</span><span class="sy0">.</span><span class="me1">Depend</span> <span class="sy0">-</span> <span class="nu0">1</span><span class="br0">]</span><span class="br0">[</span><span class="nu0">3</span><span class="br0">]</span> <span class="sy0">=</span> firm<span class="sy0">.</span><span class="me1">com_address</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> dtCompany<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">[</span>dtCompany<span class="sy0">.</span><span class="me1">Rows</span><span class="sy0">.</span><span class="me1">Depend</span> <span class="sy0">-</span> <span class="nu0">1</span><span class="br0">]</span><span class="br0">[</span><span class="nu0">4</span><span class="br0">]</span> <span class="sy0">=</span> firm<span class="sy0">.</span><span class="me1">com_PhoneNo</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> <span class="br0">}</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> <span class="br0">}</span> </div></li> </ol> |
Then I’m going to indicate you easy methods to add a row to our buyer knowledge grid.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
<ol> <li class="li1"><div class="de1"> grdCustomer<span class="sy0">.</span> <span class="sy0">.</span><span class="me1">Rows</span><span class="sy0">.</span><span class="kw1">Add</span><span class="br0">(</span><span class="br0">)</span> <span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> <span class="kw4">int</span> rowIndex <span class="sy0">=</span> grdCustomer<span class="sy0">.</span><span class="me1">RowCount</span> <span class="sy0">-</span><span class="nu0">1</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1">DataGridViewRow newCustomerRow <span class="sy0">=</span> grdCustomer<span class="sy0">.</span><span class="me1">RowIndex</span><span class="br0">[</span>rowIndex<span class="br0">]</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1">newCustomerRow <span class="sy0">.</span><span class="me1">Cell</span><span class="br0">[</span>“NAME”<span class="br0">]</span> <span class="sy0">=</span> “JOHN”<span class="sy0">;</span> </div></li> <li class="li1"><div class="de1">newCustomerRow <span class="sy0">.</span><span class="me1">Cell</span><span class="br0">[</span>“ADDRESS”<span class="br0">]</span> <span class="sy0">=</span> “COLOMBO”<span class="sy0">;</span> </div></li> <li class="li1"><div class="de1">newCustomerRow <span class="sy0">.</span><span class="me1">Cell</span><span class="br0">[</span>“AGE”<span class="br0">]</span> <span class="sy0">=</span> <span class="nu0">30</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1">newCustomerRow <span class="sy0">.</span><span class="me1">Cell</span><span class="br0">[</span>“EMAIL”<span class="br0">]</span> <span class="sy0">=</span> “<a href="https://www.sourcecodester.com/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="561c191e18160f171e1919">[email protected]</a><span class="sy0">.</span><span class="me1">COM</span>”<span class="sy0">;</span> </div></li> </ol> |
Deciding on a knowledge row of knowledge grid is one other very helpful performance.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 |
<ol> <li class="li1"><div class="de1"> <span class="kw1">non-public</span> <span class="kw4">void</span> dtgCompany_CellContentClick<span class="br0">(</span><span class="kw4">object</span> sender, DataGridViewCellEventArgs e<span class="br0">)</span> </div></li> <li class="li1"><div class="de1"> <span class="br0">{</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> <span class="kw1">if</span> <span class="br0">(</span>e<span class="sy0">.</span><span class="me1">ColumnIndex</span> <span class="sy0">==</span> <span class="nu0">0</span><span class="br0">)</span> </div></li> <li class="li1"><div class="de1"> <span class="br0">{</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> <span class="kw4">int</span> rowNumber <span class="sy0">=</span> e<span class="sy0">.</span><span class="me1">RowIndex</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> <span class="kw1">if</span> <span class="br0">(</span><span class="sy0">!</span>DBNull<span class="sy0">.</span><span class="kw1">Worth</span><span class="sy0">.</span><span class="me1">Equals</span><span class="br0">(</span>dtgCompany<span class="br0">[</span><span class="st0">"COMPANY ID"</span>, rowNumber<span class="br0">]</span><span class="sy0">.</span><span class="kw1">Worth</span><span class="br0">)</span><span class="br0">)</span> </div></li> <li class="li1"><div class="de1"> <span class="br0">{</span> </div></li> <li class="li1"><div class="de1"> <span class="kw4">int</span> grdRowRow <span class="sy0">=</span> Convert<span class="sy0">.</span><span class="me1">ToInt32</span><span class="br0">(</span>dtgCompany<span class="br0">[</span><span class="st0">"COMPANY ID"</span>, rowNumber<span class="br0">]</span><span class="sy0">.</span><span class="kw1">Worth</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> Firm company_O <span class="sy0">=</span> CompanyDAO<span class="sy0">.</span><span class="me1">GetCompanyById</span><span class="br0">(</span>grdRowRow<span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> <span class="kw1">this</span><span class="sy0">.</span><span class="me1">bingObjectToControls</span><span class="br0">(</span>company_O<span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> Locationfrm loc_frm <span class="sy0">=</span> <a href="https://www.google.com/search?q=new+msdn.microsoft.com" rel="nofollow"><span class="kw3">new</span></a> Locationfrm<span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> loc_frm<span class="sy0">.</span><span class="me1">Present</span><span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1"> <span class="br0">}</span> </div></li> <li class="li1"><div class="de1"> <span class="br0">}</span> </div></li> <li class="li1"><div class="de1"> </div></li> <li class="li1"><div class="de1"> <span class="br0">}</span> </div></li> </ol> |
Deleting knowledge row on grid with none errors is essential. To keep away from occurring errors now we have to synchronize knowledge grid with knowledge sources. you need to discover the right row within the Information Supply utilizing the first key of the chosen row. You may retrieve the chosen row’s main key by calling
string key = grdCusomer.DataKeys[e.Item.ItemIndex].ToString();
That is works when you may have assign main key subject on knowledge grid. Then you will discover the corresponding row on knowledge grid utilizing above key and delet the row from datagrid.
1 2 3 4 5 6 |
<ol> <li class="li1"><div class="de1">DataRow selectedRow <span class="sy0">=</span> grdCusomer<span class="sy0">.</span><span class="me1">FindByau_id</span><span class="br0">(</span>key<span class="br0">)</span><span class="sy0">;</span> </div></li> <li class="li1"><div class="de1">selectedRow<span class="sy0">.</span><span class="me1">Delete</span><span class="br0">(</span><span class="br0">)</span><span class="sy0">;</span> </div></li> </ol> |