473,387 Members | 1,502 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

How to clear MSFlexGrid data (Completely)

284 100+
I am using MSFlexGrid , I am using the follwing code to clear the data on click of button

Expand|Select|Wrap|Line Numbers
  1. grid1.Clear
  2. grid1.Row = 0
  3. grid1.Col = 0
But, that only clear the data and still showing the entire fields there , let say before clearing the data I am displying 10 Record, the Grids of 10 Recored still visible but the data is vanished.

I also want the rows and columsn to be vanished.

How to achieve thei.
Jun 27 '10 #1
3 16016
Guido Geurs
767 Expert 512MB
This clear a MSflexgrid:

Expand|Select|Wrap|Line Numbers
  1. With MSHFlexGrid1
  2.    .Clear
  3.    .Rows = 0
  4. End With
Jun 27 '10 #2
muddasirmunir
284 100+
This code does Not works
Jun 27 '10 #3
QVeen72
1,445 Expert 1GB
Hi,

Try This :

Grid1.Clear
Grid1.Rows= 1
Grid1.Cols = 1

I'am assuming, Grid Is not Bound with a data source..
If Bound, then Clear the dataSource/RecSet..


Regards
Veena
Jun 28 '10 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: MouseHart | last post by:
I've written a simple program in VB 6.0 to list all my MP3 files. To show them on the screen I used an MSFlexGrid named TextGrid (which is not associated with any table or text file) in the...
2
by: Jacky Luk | last post by:
Hi, I can't seem to find a way to delete all records of a table. I created my tables in MySQL Query Browser, then fill them up with VC++, but some records were incorrect, And I had to recreate the...
0
by: bienwell | last post by:
Hi all, I have a data entry form in ASP.NET (Web development) which has some fields (field1,..., fieldN) , button ADD THIS RECORD, and button CANCEL. In button ADD THIS RECORD, I have VB.NET...
2
by: Jyoti Khalap | last post by:
Hi, I am new to Visual Basics. Can anybody help me out to get the data in MSFlexGrid to be written to word file or a text file I have succesfully ran my visual Basic form to get the output in...
0
by: David Mayerovitch | last post by:
As an exercise in learning Visual Basic 2005, I am putting together a simple XML editor. I place on the form the objects DataGridView1 and DataSet1. ' Read an XML file into DataSet1:...
1
nev
by: nev | last post by:
For example I have 2 different bindingsource, each with their own data. Let's name them bs1 and bs2. If I do this... dim bstemp as new bindingsource bstemp = bs1 How can I clean bstemp...
6
by: tuxy94 | last post by:
I do not understand why the variable @data_file keeps the data from the previous call. My goal is to use this in order to clean a file from specific lines I do not desire, I do so, but if I run...
3
by: JennDavila | last post by:
Hello, Not sure if my title was correct, but here is what I am dealing with. I have created a DB that contains different tables that are linked to a form through combo box's. I have createad a...
9
by: stack | last post by:
Hi all, I am creating a web app using JSP. I have a bean with some variables whose values are set by the user by using a form in a jsp (method is post). When the user enters those values these are...
1
by: Ozone | last post by:
Hi, I need to know how to validate encrypted column which may by chance loads clear text or unencrypted value. An exception should be triggered if encrypted column receives any clear text data....
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.