Visual Basic :: Non-bound Grid

Data Bound Grid Problem
I need to be able to add a new row so that i can insert the data from the database. but i am not sure as i have already tried using the for loop to increase the row number. This didnt work. Please Help.

Set rs = New ADODB.Recordset
Dim a As Integer
Dim b As Integer

SQLContact = "SELECT * FROM Contact WHERE aKey = " & lblKey.Caption & " ORDER BY Name DESC"
rs.Open SQLContact, cn

Do While Not rs.EOF = True
a = a + 1
rs.MoveNext
Loop
Set rs = Nothing
Set rs = New ADODB.Recordset
rs.Open SQLContact, cn
DBGrid.ApproxCount = a

'enters into a particular place of the grid

DBGrid.Refresh
DBGrid.ReBind
For b = 0 To a
If Not rs.EOF = True Then
DBGrid.Col = 0
DBGrid.Text = rs.Fields("First").Value
DBGrid.Col = 1
DBGrid.Text = rs.Fields("Name").Value
DBGrid.Col = 2
DBGrid.Text = rs.Fields("Telephone").Value
DBGrid.Col = 3
DBGrid.Text = rs.Fields("e-mail").Value
rs.MoveNext
End If
Next b

Bound Grid Or Disconnected Recordset?
Hello,

I have a Grid that I displays to the user 6 columns of information. 4 of the 6 columns are derrived from one column value from the database. My question is which approach would be the best for my App to update the results captured by the grid. Because the grid has derived columns that make it easer for the user to choose the mask value for each record...I thought of two ways I could update the underlying table.

1) 2 Grids one Bound and one unbound.
I could have one grid(A) that represents the the data that I want updated and bind it to the database but keep it invisible and have it work with my other grid(B) when the user updates rows in grid(B) have code that updates rows in grid(A) as they are changed.

Grid(A) ColumnA=dbKey ColumnB=MaskInteger <this would match directly to the table>
Grid(B) ColumnA=GroupID, ColumnB=Description, ColumnC-D=Boolean <this information is collected by several table by joins to get User friendly data for the User>

2) 1 Grid and 1 disconnected Recordset
I could also use a disconnected Recordset with ADO instead of using the Bound Grid(A) use similar logic using the events in the grid(B) to update the recordset the have user commit changes when they click a apply button.

Any Ideas or comments how I could implement these or other ideas? I would enjoy any examples as well!

Thanks
Richard

DataCombos Within A Data Bound Grid
Is there a way to have a DataCombo box within a column of a data bound grid? I am using VB6 with a SQL2000 database?

I would like for the user to be able to select from a list of values for certain columns of the grid.

Are there existing components that have this ability, or must it be coded?

Any help will be greatly appreciated.

Data Format To Bound Grid
I have a date field in a table that is in the format yyyymmdd and when I display it to a bound flexgrid I would like to reformat it to mm/dd/yyyy. I believe it can be done using the StdDataFormat but am having problems trying to make it work. Does anyone have an example, or a better way to do this?? Thanks in Advance!!

Licensing Problem Of Data Bound Grid
Hello All,
I have a problem with the Data Bound Grid control of Microsoft. When I
tried to place a Data Bound Grid control in a form, a message is coming
telling that the 'Licensing information is missing'. What could be the
reason for the problem. Is it possible to get the control with the licence
information from any site. If so, please direct me in the proper direction.
Please give the me the necessary information.

Thanking you in anticipation,

Sunil

J & P (O) Ltd,
Saudi Arabia.

Data Grid Bound To A SQl Server View
Hello freinds,

Most of you would have come across similar situations many times before and would have solved it in your own style and preference. let me explain the situation.

I have the

(1)ItemRefsLookup Table :

CREATE TABLE [dbo].[ItemRefsLookUp] (
    [ItemRef] [varchar] (25) NOT NULL ,
    [ItemDesc] [varchar] (50) NULL ,
    [ItemType] [varchar] (10)  NULL )
(2)ItemCostings Table :

CREATE TABLE [dbo].[ItemCostings] (
    [ItemCostingsID]  uniqueidentifier ROWGUIDCOL  NOT NULL ,    [ItemRef] [varchar] (25)  NOT NULL ,
    [SubsidiaryCode] [varchar] (3) NOT NULL ,
    [QuotedPrice] [decimal](18, 0) NULL ,
    [ProdCost] [decimal](18, 0) NULL ,
    [SellPrice] [decimal](18, 0) NULL ,
    [Commission] [decimal](18, 0) NULL ,
    [CurrencyCode] [varchar] (3)  NOT NULL )

I have a foreign key declared as

ALTER TABLE [dbo].[ItemCostings]
ADD CONSTRAINT [FK_ItemCostings_ItemRefsLookUp] FOREIGN KEY ([ItemRef]) REFERENCES [dbo].[ItemRefsLookUp]
([ItemRef]) ON DELETE CASCADE  ON UPDATE CASCADE ,
GO

Now I need to design a data entry screen for these two tables using Visual Basic 6.0.

(1) I created a View as follows:

CREATE VIEW dbo.VIEWItemRef
AS
SELECT  dbo.ItemRefsLookUp.ItemRef AS ItemRef, dbo.ItemRefsLookUp.ItemDesc, dbo.ItemRefsLookUp.ItemType, dbo.ItemCostings.QuotedPrice, dbo.ItemCostings.SellPrice, dbo.ItemCostings.Commission, dbo.ItemCostings.ProdCost, dbo.ItemCostings.SubsidiaryCode,dbo.ItemCostings.CurrencyCode, dbo.ItemCostings.ItemCostingsID FROM dbo.ItemRefsLookUp INNER JOIN  dbo.ItemCostings
ON
dbo.ItemRefsLookUp.ItemRef = dbo.ItemCostings.ItemRef

(2)Created a VB form with a DataGrid control in it with a ADODC control. The View was used as the record source for the Grid and then the ADODC was used as the source for the grid.

(3)Brilliant it does display the data properly allows me delete any rows selected and also allows me to edit the rows whichever I selected to edit.

(4)But when i try to add a new row it comes up with errors asking me to check on the status of each OLEDB.

(5)I have read in this forum that to insert using Views we have to use an Instead Of Insert Trigger.

(6) I did create a trigger in the lines what some freinds suggested as follows:

CREATE TRIGGER UTrig_INS_ItemRef ON [dbo].[ViewItemRef]
INSTEAD OF  INSERT
AS
BEGIN
Declare @SubsCode As Varchar(5)
Declare @CurrCode As Varchar(5)
SET NOCOUNT ON

-- Check for duplicate ItemRef in ItemrefsLookup table . If no duplicate, do an insert.

IF (NOT EXISTS (SELECT IR.ItemRef
      FROM ItemRefsLookup IR, inserted I
      WHERE IR.ItemRef = I.ItemRef))
   INSERT INTO ItemRefsLookup
      SELECT ItemRef , ItemDesc, Itemtype
      FROM inserted

IF (NOT EXISTS (SELECT IC.ItemRef
      FROM ItemCostings IC, inserted
      WHERE IC.ItemRef = inserted.ItemRef))
      INSERT INTO ItemCostings
      SELECT ItemCostingsID, ItemRef ,
      '100' As  SubsidiaryCode,
      QuotedPrice, ProdCost,  SellPrice, Commission  ,
      'HKD' As CurrencyCode
      FROM inserted
END

(7)This trigger works fine when I directly try to do an insert using the Query Analyser. But it still wont work via the data grid.

I am really stuck and would appreciate if someone can help please. If you have different approach to design this data entry please do advice. Its only very recently I started using Stored procedures and triggers etc. So please ber with my ignorance.

Truegrid V7 Summing Two Columns On Bound Grid????? PLZ HELP!!!
Hi All,

I'm using Truegrid V7 and I am showing stock figures using a bound ado control. That bit is fine but I also want to have one of the columns as a sum of the other two. Does anyone have any ideas as I am well and truely stuck!

Thanx very much inadvance,

Jiggy!

Data Bound Grid Date Format
Is it possible to set the date format for the columns of a data bound grid (DAO)?

Right now, I have short date as the default format, but it comes up with 8/28//2002...

But I want it to be 28/08/02 instead.

Can this be done without setting the regional settings? I don't want it to change whenever the system changes regions.... thanks.

Passing Information From Data Bound Grid
I am having trouble finding the function to use in a data bound grid (DAO). What I'm trying to do, is to allow the user select a record from the databound grid, and then when he clicks the "edit" button, it would pass the "name" field from the data bound grid to a text field on the editing form.

I'm sure this can be done, but I couldn't find the function to do this. I have read about the selbookmarks function, but I don't understand how it can be applied here.

Please help... =(

Woobi.

Ammending Code To Show On Data Bound Grid
Normally when i open an ado code i do it as the code is below.

I would like to know how to ammend the code so it shows it in a databound grid???????????????

I know it has something to do with datasource property but cannot work out the correct place to place it and what to call it with.
I no longer want to show it in a textbox.

VB Code:
Private Sub Form_Load() Set r = GetData textbox1.text = r![InvoiceNo]End sub Public Function GetData() As ADODB.RecordsetOn Error Resume NextDim strsql As StringDim r As ADODB.RecordsetDim c As ADODB.Connection Set c = New ADODB.Connectionc.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False; Data Source=.home.mdb;"c.Open strsql = "SELECT * from Invoice"Set r = New ADODB.Recordsetr.Open strsql, c, adOpenDynamic, adLockPessimistic Set GetData = rEnd Function

Bound True Grid Dont Refresh After Delete
I'm having a problem with the grid not getting refreshed after
deleting a record. Even though the record is deleted from the table. I
have the following code in a Delete button event:
sql = "Delete from OrderDetails where Orderid = " &
datOrderItems.Recordset!OrderId
sql = sql & " and ProductId = '" &
datOrderItems.Recordset!ProductId & "'"
gconn.Execute sql
datOrderItems.Recordset.Requery
datOrderItems.Recordset.MoveNext
If datOrderItems.Recordset.EOF Then
datOrderItems.Recordset.MoveLast
End If
datOrderItems.Recordset.Filter = "Orderid = " &
cmbOrders.Columns.Item(0).Text
grdOrderDetails.ReBind

Why does the row that was deleted still show in the grid after the
delete. If I change the filter on the recordset, it will display the
new results, but when I come back to the old Order#, the same contents
will display, even the deleted record. If I close the form and load it
again, the record gone. What the heck is going on. Please help.
Thanks Michael

Copy Text File Into Data Bound Grid In A Sorted Order?
I have a text file and i need to move its contents to DB Grid .
For Eg.
following is my test.txt

ravishah885 kent confirmed posted
ravi_sarla lamar pending
kent8541932 NCSU pending
kent8541933 ohio pending
kent86541934 northcarolina confirmed posted

for each line , I want "ravishah885" to be stored in one cell,"kent" in other ,"confirmed" in third cell and "posted" in fouth cell.
After storing all values i need to sort it in Data bound grid.

please mail me ASAP .
Thanx
ravi

Why I Cannot Find "Microsoft Data Bound Grid Control 5.0" Component?
Hi guys,

I'm using Windows XP, and I have installed VB 6.0 Enterprise Edition. But why I cannot find "Microsoft Data Bound Grid Control 5.0" component in VB? But Windows 98 can see? What can I do? PLEASE HELP!

THANKS!!

Bound Dropdown Box Not Updating Bound Text Boxes...
Hi All,

I have an Access 97 form with bound textboxes, and a dropdown combo. The user selects a value in the dropdown to populate the textboxes.

Because there could be duplicates values in the combobox (the values are people's last names), I have made the combo into a multi-column dropdown, adding a first name and a date of birth. It works well, until there are multiple occurrances of the same last name. What happens in that case is only one record displays in the textbox no matter which of the combobox's values is chosen.

For instance, I have a bunch of "Smith" values, and when any of them are selected, the data appearing in the text boxes remains on "Richard Smith"... Furthermore, I checked a few different duplicates other than Smith, and it is inconsistent as to which record is always displayed. Sometimes it's the first in the bunch, sometimes it's the last, etc...

If this helps, here is the Row Source of the dropdown:

SELECT DISTINCTROW [Hospital].[PatLName], [Hospital].[PatFName], [Hospital].[PatDOB] FROM [Hospital] GROUP BY [Hospital].[PatLName], [Hospital].[PatFName], [Hospital].[PatDOB] ORDER BY [Hospital].[PatLName], [Hospital].[PatFName], [Hospital].[PatDOB];

Anyone out there ever run into this before?

Thanks,
RichS

Bound Data Fields Not Bound
I am connecting to an Oracle data base via ADO. When I open my form the first time, the first record is displayed, but then, when doing a "moveNext" or "movePrev" or a "moveFirst" or a moveLast", the fields are not updated on the screen, but when I check the recordset programmatically, the record is the correct record (the next record or previous record and so on).

Now, for the crazy part: when I close this form and open it a second time all is well, the first record is displayed and as I navigate through the recordset (next, prev, first, last) the correct record is displayed on the form.

Any ideas?

Thanks,
zina

What's The Different Between Early Bound And Late Bound?
What's the different between early bound and late bound?

MSHFlexGrid 2 Things I Want To Edit Data In Grid And 2 I Want To Re Populate Grid
  Ok First I want to Edit the Data in the Grid... Note this is partially setup.

  I have it so that I can Edit each cell however, I havent the slightest idea of how to go about saving the edited row after its edited.

  Ok, I have 3 option buttons.... I want to select an option button and it re populate the grid with a new MDB file. I figure I will need to Close the current open MDB so I can repopulate the grid... but How to accomplish this is the question.

Please Help To Displaying DB Grid Or Flex Grid Entry On Textboxs!!
Could someone make a sample or code for displaying entry that I choose from DB Grid or Flex Grid
and I want to display it into textboxs.

Like example : I find some data in DB Grid or Flex Grid, I choose/click one of them and
the details displayed on the textboxt.

Please, help me!!
Many thank's.

GRID - Free, Spreadsheet Style Grid
Free, spreadsheet style grid. Does such a thing exist? I have reviewed a number of different grids and gotten a feel for limitations etc....

Listed at end of this email.

Here is what I was (am) looking for;

1.)Ocx, DLL style control that will run on VB 4.0 (yes I know many will scream at me to upgrade, but due to current constraints this is not possible for me
and won't be for quite a while - funny, even when I state this upfront I still get replies that tell me to just 'do that anyhow'. I cant do that at the moment so please
dont suggest it. I already KNOW this, but I cant upgrade due to the constraints....

2.)Grid that can appear like a normal spreadsheet on a form and will allow direct entry into cells

3.)Will allow me to specify specific cells by some sort of cell coordinate scheme, i.e. Xgrid1.row = 1, xgrid1.col = 1

4.)Will allow me to change the background colour of any cell in the grid

5.)Will let me customize the number of rows, columns - but only need this to a limited degree, 100 rows by 100 columns is fine, 400 by 400 better, but no more
than that is needed

6.)Will let me assign cell values to variables and vice versa during runtime

7.)Will let me refer to cell values in one grid to those in a secondary grid and allow me to inter-operate between the grids

8.)Won't expire or become crippled after some 30 day trial date

9.) Reasonable docs, good enough to follow and get it working.

Thats it, thats all I need to do, dont need any other bells and whistles.... surely there is some reasonable OCX out there, some limited, lite version of some kind
that can perform these simple functions?

Here are some of the grids I've already tried, and have found to be seriously wanting for some reason or another;

vb accelerator
PROBLEM: too limited in features, difficult to easily and quickly do what I need as listed above, limited properties... cant even directly set the number of columns?

easy grid
PROBLEM: Best of the bunch found so far, meets all the requirements above EXCEPT the docs suck. Has an unreal number of properties, etc.... but so many it makes the darn thing pretty complex, seems to be very robust in utilty but the faq, help file is resplendent in broken English and the docs in general are just plain poor and sketchy, took me far too long to just figure out how to set the # of cols, rows. Further, it has a 30 day trial period, which the company claims can be avoided by simply turning the computer clock back one month, but I actually NEED the clock to be accurate in time, for what Im doing - so this is not a good solution.

scgrid - still testing this out, but so far does not look promising

ExtendedDataGrid control - part of a pack of other tools, seems limited in function, frustrating to get running

Janus - way out of my price league, great tool, but cant afford to sell one of my organs at the moment to afford it.

DataGrid - too limited in scope, cludgy for what I want to do, too pricey

truegrid and dbgrid - too limited in scope, cludgy for what I want to do

itGrid - too pricey

VSFlex/OCX and VSView/OCX - too pricey

GRID - the one that ships with VB 4.0 - severly limited in capabilities, overall this one just plain sucks

HELP!!?? Any suggestions ?

Report In Grid Or Grid Type Control
Hi,

I have a form which searches database on user critera and displays the result in FlexiGrid and if user wants to export the result to excel they can. Everything is working fine. But now I want to modify this program a little.

The result in Grid is display like this:

Year-----Field1-----Field2-----Field3
2000----- A ------- A -------- A
2001----- B ------- B -------- C
2002----- C ------- C -------- C

But I want this to be displayed in Grid like this:

Year----2000-----2001----2002
Filed1----A--------B-------C
Field2----A--------B-------C
Filed3----A--------B-------C

How can I do this? Any help?

Thanks

Grid Like Windows Explorer Or WinZip Grid?
Hi,

It seems that the FlexGrids that come with VB6 are very limited.. What I'm trying to do is find a grid that would provide that same functionality and look/feel as the grid that is in WinZip or Windows Explorer.. In other words, I need to be able to do a mulitple selection (shift and ctrl type selections) and sorting by clicking the column headers.. It would also be a nice touch if when you click on the column headers, they press in and out like a button, like it does in WinZip or Windows Explorer..

But, I was hoping to not have to purchase an expesive commerical grid..

Any recommendations, would be appreciated..

Dan

Select A Row In A Grid(true Db Grid Or Something) With Code
hallo,

does anybody know how i can select a row with code ?? (of course to click on a grid and get the row content is easy)

thank you very much

About Data Grid Flex Grid And Other Family
1. what is the best control with the latest updatable fetures in this family
2. right know (until someone tell me that thire is a better control) i am using data grid, now i want to send data during my program to the data grid and i want that the data grid will show this data, now i dont want to send this data to the data base but directly to the grid, is that possible if yes how does it done .
thanks you all

janiv

Diffrence Between Flex Grid And Data Grid????
HI,

I want to know what is the difference between Ms flex grid and MS data grid?

pls tell me

thank u

sowmya s

Selected Row In A Data Grid Or A Msh Flex Grid
The user has to select a row from a data grid of a mshflex grid. The information seen in the data grid or the msh flex grid depends on a selection in an other combo box, this works fine. Now the goal is to copy one single column of the selected row in the data grid or msh flex grid to a ordinary listbox.
I've tried all methods but nothing works!

PLEASE HELP ME! I'M SO BLOODY DESPERATED!

Can I Be A Bad Boy And Bound ?
I generally hate doing this..and I do understand sometimes there are performance issues, but I hate to have to write so so so much code to modify some type of data in a grid.

Im connected to a sql database and need to pull back some records and allow a user to modify the data. There could be easily 50-100 rows to modify and I cannot stand the fact that there is not a single easy way to modify data in a grid. Rather than using the MSHFlexGrid writing to code or anything else for that matter...what is everyone's thoughts...should I bound the data (just this once ). If so I've never bounded data to a grid..I know people have in the past...can someone give me some examples ?

Thanks

Bound Control In VBA
Dear Forum,

I have stored some formulas (generated with the formula extension in MS Word) in a MS Access database. Then I have extablished a User Form in VBA and connected it to the database.
Now I like to view the formulas within a VBA form, but only cryptic letters appear in lable boxes and text boxes. Also image boxes don not work. Can anybody tell me, if there is a bound control (like in MS Access ... there it works fine) or another control with which I am able to view the formula?

Thanks for answers!

Hermann

Upper Bound?
sorry folks i got a blank!!
how can you retreive the upper bound of a multidimentionnal array like
array1(0 to 7, 0 to 85, 0 to 3)
lets say i need the 7 or the 85??

I'll be among the best soon, very soon!!!

Bound DBCombo
can Data Bound Combo bound to DAO or whatever other than Data Control?

for example: i have a dbcombo named DBCombo1 and set it's RowSource property to Data1 (Data1 is a Data Control), and ListField property to StudentCode. This will automatic list all the StudentCode when running the program. My question is, other than bount to Data1, is that any other method? I got a recordset named rsStudent, and i wish that the dbcombo can bound to it, but not Data1. can this work? and how?

pls advise, tq.

Bound Datagrid
I have set a datagrid's datasource to a recordset. The user then has the option to search, which utilizes .filter to filter the recordset and update the datagrid. My problem is that when you close the form(which also closes the recordset), and then open it back up...it somehow shows the same filtered recordset. So, if you searched for someone with the last name of Budnick, closed the form and then reopened it: it still shows the same search results. I've tried a requery of the recordset on the form unload event and everything else I could think of. How can I get it to go back to the original state of the recordset? I'm both confused and baffled...ugh. Thanks in advance.

Bound Controls
I was told to stop records automatically appearing in text boxes when i load the program i should not use bound controls. What are bound controls? How do i make it so that when i load my program no record is visible in the text boxes but when i click the arrow on the data bar it will then show the first record? I thought of making a new first record that is blank but that is not thw right way i imagine.

Bound DB Listbox...
I have an Access form with a listbox in the Detail section. It's RowSource is a query:
SELECT Subcomponents.Major_ID, Inspection.* FROM Inspection INNER JOIN Subcomponents ON Subcomponents.Minor_ID=Inspection.Minor_ID;

The control source is set to Major_ID and BoundColumn is 1. The form's RecordSource is the table Major_Components. When I browse through records with the form, the listbox highlights the first item with a Major_ID matching the selected major component. What I want it to do is filter the list based on the selected major component's Major_ID. That is, if the selected record is major component with ID of 1 then the list contains the result of the query:

SELECT * FROM Inspection WHERE Minor_ID IN (SELECT Minor_ID FROM Subcomponents WHERE Major_ID = 1)

See the attachments for clarification...
what_it_does - the behavior i observe
what_i_want - the behavior i'm trying to achieve

If I were only displaying one record at a time, I realize I could change the recordsource when the user switched from one record to the next. But I want to display multiple records at once each with the correctly populated list.