[thava]

i think may be he is still wrong there
i see a code

lRow = 0
While objResultset.EOF = False
	lRow = lRow + 1
	.Rows = lRow + 1
	.Row = lRow

there is no such property Rows in DataGrid

[aeondev]

BobRodes, on 01 June 2012 - 06:32 AM, said:

Well, now you know why maj asked you what kind of grid you were using, way back in post number 2 or so. And you also know why he was a bit annoyed when you wouldn't tell him.

So, if you had told him that, I (and he also, no doubt) could have told you that all you have to do to get your DataGrid control to show all your stuff is:

1. Create a recordset, as you have done.
2. Set your DataGrid's DataSource property to the recordset variable, e. g.
Set myDataGrid.DataSource = objResultSet

Suppose you give that a try, O Prodigal Son. If it works, you can lose a lot of messy code and call it a learning experience.

This whole exercise reminds me of a snippet of a poem I know (from Eliot's "Little Gidding"):

We shall not cease from exploration
And the end of all our exploring
Will be to arrive where we started
And know the place for the first time.

Well. Bob, There seems to be no datasource property of the datagrid...For example:
The name of mydataGrid is GRID1, now if I check with the dot[.] then there is no datasource property for the given grid...whereas.....for objResultSet there is a datasource property......so should i give like:
Set objResultSet.datasource = objResultSet

I am really sorry is this is a silly question....

[aeondev]

thava, on 02 June 2012 - 12:36 AM, said:

i think may be he is still wrong there
i see a code

lRow = 0
While objResultset.EOF = False
	lRow = lRow + 1
	.Rows = lRow + 1
	.Row = lRow

there is no such property Rows in DataGrid

Hi Thava,
Thnx for your reply.....
Well there is .Rows property in GRID1. I have checked and confirmed....

[maj3091]

I think you need to check and confirm the grid you're using.

The Datagrid control does not have a ROWS property, but it does have a DATASOURCE property.

You have given opposite replies to the above, which suggests you're not using the standard MS datagrid control.

Please clarify otherwise people are going around in circles trying to help you.

[aeondev]

maj3091, on 04 June 2012 - 12:37 AM, said:

I think you need to check and confirm the grid you're using.

The Datagrid control does not have a ROWS property, but it does have a DATASOURCE property.

You have given opposite replies to the above, which suggests you're not using the standard MS datagrid control.

Please clarify otherwise people are going around in circles trying to help you.

I know it is my responsibility to give you guys the correct info and believe me I am giving you all I know....I really dn't have much idea of VB and on the top of it this application is pretty old.....
I am very thankful to all of you for helping me....

And as per the control goes, this has BOFAction, EOFAction property and do not have datasource property and can be set dynamically at run time....Uses .Rows and .Row both as well as .Column and .Text to fill...

From what you have told I can assume this is not DAtagrid nor it is MSFlex.....
With reference to MSDN, DAta Control can be most apt over here....

This post has been edited by aeondev: 04 June 2012 - 04:40 AM

[aeondev]

aeondev, on 04 June 2012 - 12:06 AM, said:

BobRodes, on 01 June 2012 - 06:32 AM, said:

Well, now you know why maj asked you what kind of grid you were using, way back in post number 2 or so. And you also know why he was a bit annoyed when you wouldn't tell him.

So, if you had told him that, I (and he also, no doubt) could have told you that all you have to do to get your DataGrid control to show all your stuff is:

1. Create a recordset, as you have done.
2. Set your DataGrid's DataSource property to the recordset variable, e. g.
Set myDataGrid.DataSource = objResultSet

Suppose you give that a try, O Prodigal Son. If it works, you can lose a lot of messy code and call it a learning experience.

This whole exercise reminds me of a snippet of a poem I know (from Eliot's "Little Gidding"):

We shall not cease from exploration
And the end of all our exploring
Will be to arrive where we started
And know the place for the first time.

Well. Bob, There seems to be no datasource property of the datagrid...For example:
The name of mydataGrid is GRID1, now if I check with the dot[.] then there is no datasource property for the given grid...whereas.....for objResultSet there is a datasource property......so should i give like:
Set objResultSet.datasource = objResultSet

I am really sorry is this is a silly question....

Bob, Ignore my previous posts ...
This is Microsoft Grid control....GRID32.ocx

[BobRodes]

Well, no, I'm not going to ignore 32 posts that are based on faulty information that you've provided. However, if you choose to ignore the fact that your careless and lazy thinking has created a monumental waste of time in this forum, then feel free to do so. Perhaps when you wind up wasting a monumental enough amount of your co-workers' time for the same reasons, there will be consequences of sufficient gravity to get your attention. Let's hope it doesn't come to that, but it's pretty clear that you have a habit of undervaluing the effort of others to work with you, with the result that you probably have a reputation of nice guy, unreliable, hard to get anything done with.

This post has been edited by BobRodes: 04 June 2012 - 07:18 AM

[aeondev]

BobRodes, on 04 June 2012 - 07:17 AM, said:

Well, no, I'm not going to ignore 32 posts that are based on faulty information that you've provided. However, if you choose to ignore the fact that your careless and lazy thinking has created a monumental waste of time in this forum, then feel free to do so. Perhaps when you wind up wasting a monumental enough amount of your co-workers' time for the same reasons, there will be consequences of sufficient gravity to get your attention. Let's hope it doesn't come to that, but it's pretty clear that you have a habit of undervaluing the effort of others to work with you, with the result that you probably have a reputation of nice guy, unreliable, hard to get anything done with.

I just wanted you to avoid my last post and Yes..Bob..you are right about everythng.....And thanks for everything specially ur time....I didn't intend to waste anyone's time here...and I do realize the effort and patience anyone has given to me....
And regarding work...I handle mostly asp.net applications and SQL SERVER on db side.....

The person who was looking into this VB application has to go urgently....so being his colleague...and into the same project I had to give extra effort to understand this VB application....Nevertheless to mention that I had my own tasks too which needed to be done also.....
For the past 1 week...I am virtually living in my office rather than going home....just to get this done...

May, be I am not a nice guy...but certainly I am not irresponsible...It is just that this is not my domain.....
And thanks again.....
My sincere apologies...