Datagridview, sql server, vb.net Programming Software Development by ukfreak … requirements is, I need to display my data in a datagriedview on monthly basis only. I have done the retrieving of… the data from sql server to the datagriedview. But how do i show it only on monthly basis… Datagridview & Database Programming Software Development by Commando123 … user will be able to see that data on the datagriedview and insert his data in its field and update other… Re: Select Count not retreiving data Programming Software Development by Waldis_1 … exist a loan assigned to the client selected in a datagriedview and if there's one that is in status "… DataGriedview Cell Color Change Failed ON Form Load Programming Software Development by jaimin4829 public partial class FrmEndDateSummaryOnLoad : FrmErpSimple { List<string> mVehicleRemainderList; //SMdiForm mMdiParent; string mCurrentUserId; string mCurrentPeriodId; DataTable dataTableVehicleID = new DataTable(); DataTable … Re: DataGriedview Cell Color Change Failed ON Form Load Programming Software Development by Mike Askew Have you tried a `this.Update();` after the call to `SearchEndDate();`? This will force the form to redraw. Re: DataGriedview Cell Color Change Failed ON Form Load Programming Software Development by Maligui Keep in mind that Form_Load event handler will run on a background thread, and it is not recommended when changing state of objects, but more or less to ready data for the form. More then likely there is an error happening and it is silently throwing an exception (which is the normal behaviour of Form_Load) I would call the setcolor() method on … Re: DataGriedview Cell Color Change Failed ON Form Load Programming Software Development by jaimin4829 It properly works on btn_Click event.. Also at on_load debug..it enters in loop properly but can't show effect of changing color.!! private void btnSearch_Click(object sender, EventArgs e) { SearchEndDate(); } Re: DataGriedview Cell Color Change Failed ON Form Load Programming Software Development by Maligui The btnSearch event runs on the same thread as your UI. So the method SearchEndDate() also runs on the UI thread. It is possible you have a Cross thread exception going on when using Form Load - meaning that the thread to update the UI is not running on the same thread as the UI. The best way to code is to only do background threading on tasks … Re: Datagridview & Database Programming Software Development by roottybrian Get Clear please... Re: Datagridview & Database Programming Software Development by Commando123 i want to be able to update my database tables from the dataview it self and without using textboxs