MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem
Go Back  Xtreme Visual Basic Talk > > > MSHFLEX Grid Refresh Problem


Reply
 
Thread Tools Display Modes
  #1  
Old 04-14-2004, 10:45 AM
bbrendan bbrendan is offline
Freshman
 
Join Date: Sep 2003
Posts: 36
Default MSHFLEX Grid Refresh Problem


hi im just i desparate need of some help here,

I have a MSHFlexgrid and im adding new records to the Database.

I cannot seem for the life of me get the grid to refresh unless I close and re-open the form. which I dont want to do!

I can see that the data has been added to the SQL table but once I add it, I cannot get the Flexgrid to show the newly added record

Ive even tried putting a button on the form to run the statemetn below and it doesnt refresh.

Now here's the odd bit.

If I update the records in the table then press the refresh button the records currently in the grid refrsh but still the new record is not shown!!!

Any ideas PLEASE!!

-----------------------------------------------
Dim oRSOrderDetReq As ADODB.Recordset
Dim strConnect As String
Dim strSQLDet As String

strConnect = INI_getString("String", "ConnectString1", App.Path & "\dataconn.ini")

strSQLDet = "Select ISBN, Description, Quantity ,UnitPrice, Discount, Discount_Type,Discount_Amount," & _
"Tax_Code,SalesTax, ExtSalesTax, ExtAmount,Location, Kit_Item,Weight_Ea, ExtWeight, OrderID, Row_ID, Date_Added from Orders_Detail where OrderID = " & frmOrders.OrderID.Text

Set oRSOrderDetReq = New Recordset

oRSOrderDetReq.Open strSQLDet, strConnect, adOpenKeyset, adLockOptimistic

Set MSHFlexOrdDetail.DataSource = oRSOrderDetReq

-------------------------------------------------------

thanks
brendan
Reply With Quote
  #2  
Old 04-14-2004, 12:06 PM
DaddyHarris's Avatar
DaddyHarris DaddyHarris is offline
Centurion
 
Join Date: Feb 2004
Location: Alabama
Posts: 194
Default

Set the grid data source to nothing, then set it back and that should refresh it for you.
__________________
There are no Stupid Questions, only Stupid People
Reply With Quote
  #3  
Old 04-14-2004, 03:25 PM
MKoslof's Avatar
MKoslofMSHFLEX Grid Refresh Problem MKoslof is offline
Cum Grano Salis

Retired Moderator
* Guru *
 
Join Date: Jul 2002
Location: Baltimore, Maryland
Posts: 14,636
Default

The MSHFlexGrid is a bound control. You have to reset the datasource in order to see the changes. So, as stated befrore, you need to set it equal to nothing and then re-bind it to the updated DataSource
__________________
"Artificial Intelligence is no match for natural stupidity." ~unknown
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MSH Flex Grid problem with databound text control Tanzeem Khan Database and Reporting 1 07-02-2003 02:37 AM
Refresh Problem to Picture Box andioliver Interface and Graphics 2 03-10-2003 08:51 AM
can refresh the data grid! clonefish Database and Reporting 1 09-16-2002 08:45 PM
data grid problem clonefish Database and Reporting 1 09-13-2002 04:31 AM
Data Grid Problem sachin Database and Reporting 4 06-08-2002 07:55 AM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem
 
MSHFLEX Grid Refresh Problem
MSHFLEX Grid Refresh Problem
 
-->