A portion of my code is below. I am making a database application using FlexGrid and an ADO Control. I get errors on the statements following .saying that "Overload resolution failed because no accessible 'Fields' accepts this number of Arguments". Can someone explain this error and also a fix for it? I am using Visual Basic 2008.
[Code]...
WIth vb 2010 beta2, is it possible to use a Microsoft access save file instead of sql server (with no reduced functionality)?
View 2 RepliesI have a VB form and want to add a flexgrid control during runtime to a tabpage I am creating during runtime. how do go about this?
View 1 RepliesMy VB.NET application uses Microsoft Flex Grid Control 6.0. This is a legacy application which has been ported from VB6 with the Visual Studio conversion wizard. Although I can compile the assembly, I get a COMException because some class is not registered. I've found out that this class is the Microsoft Flex Grid Control 6.0.
Where can I find the control and how can I register it on machines so that the application will run?
i just want some opinnion or suggestions regarding database softwares. we are going to develop a system for 20 or less users, i am planning to use MYSQL community server as our database to lessen the budget for that system, i just want to know if it is ok to use that version.is there a big differece between mysql community server, enterprise server and MS SQL Server in terms of handling data i.e security, speed, etc...
View 2 RepliesI need to display a graphical representation of database(access) in vb 2005. is there any way to do it. I dont mind how I just need to display barchart but data is in Ms Access.
View 2 RepliesI am creating a reporting app that pulls information off of a Sql database and populates the data in a datagridview control (DVG). I am using tab pages (Tabcontrol), and I have about 10 tabs with within the control. What I have done is created a dynamic control that will populate in each tab page once the tab is selected. I am using a split container and in my split container.panel 1 is where all my buttons and search functionality will be. In my split container.panel2 to is where the main DGV control will be. I have got this to function properly, however now I am unable to add anything to my split container.panel1. I would like to add diffrent labels and buttons in the panel1 one without putting another panel on top of the split container.panel1, and also if i do this when I resize my container the panel will just sit there. I am using the selected index changed event to get my split container to show in each of the diffrent tabs
Private Sub searchTab_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles searchTab.SelectedIndexChanged
searchTab.TabPages(searchTab.TabPages.IndexOf(searchTab.SelectedTab)).Controls.Add(splitContainer1)
[code]...
converting a speadsheet into a proper data source. I have imported it in to a table called "B" in access 2007. The problem is that the data is spead out of multible columns and rows, looks like a crosstab query. I need to convert it back to its data. I could do it with UNION Queries but this would be unpractical due to the number of columns.I have created a public function in my module. But I am not sure on how to call it. I get the error:
Quote:
Circular reference caused by 'BOut'.
on this line:
Code: Set rstout = CurrentDb.OpenRecordset("BOut", dbOpenDynaset)
Here is my first try:I have a table called "B":
Quote:
InvoiceCode,XXX001,XXX002,XXX003,...
A,$10,$15,$20,...
B,$1,$2,3$,...
[code]....
In a program I am creating, i want to let the user add and remove fields on an entity, lets say "people". So I have a table named "People", with ID and Name columns. Now, I want to let the user choose "add field" in a webpage, define for instance "email" field, and then use "ALTER TABLE" from the codebehind to create the new field in the table. What I want to know is: is this recommended? It seems like a simple way to do this, but since I have never seen any other programs doing it like this (Using ALTER TABLE statements from codebehind in a live environment) - and since it changes the design of the DB -
View 3 RepliesI am making a exe application and i am using mysql as my database. So the thing is, when i change to a new computer, i need to change the file path for the database connection string to that computer.
like below:
Dim connectionString As String = "Data Source=----------SQLEXPRESS;Initial Catalog=Flexlink;" & "Integrated Security=SSPI;"
i need to change the data source = --------------- SQLEXPRESS to the computer name that i am using for my project.
May i ask is there any method such that the user dont have to go in to the source code to change the computer's name like those normal installer?
Just install and the application will run according like any exe file that we buy.
I am Using VB.NET 08 code for Creating FlexGrid Control.Now i am showing the data table in the FlexGrid.But now i want to put a Button Control on the FlexGrid Cells.The Button acts like When i click button some of the Rows in the Flexgrid should be Hide/UnHide.So how can i write a code for Creating control on the Flexgrid and applay the above criteria?
View 1 RepliesI'm in the process of rewriting some old VB6 projects in VB.Net which are still in use in my office. One project I'm having trouble with is one that displays a flexigrid which contains data from an SQL database, I know I can use Datagridview and this will fill most of my needs, but there is one characteristic of the flexigrid is the ability to "freeze" the far left column which hold peoples names and scroll all the other columns to see the data to the left, is there a way I can get Datagridview to do the same?
View 2 RepliesI recently worked in Flexgrid vb6.0.In the ouput there are 10 to 12 columns are there.In the Flexgrid i changed the columns as i need. For this i used my logic as below.But i want to know how can i do this same logic in DataGridView?For example one of the Flexgrid Property .Cols using to rearrange and modify the columns.But in the Datagrid view wht is the property i can use to apply same logic??? There is property Columns , it is Readonly Property.some articals i studied that their is property like DataGridColumnStyle.Is this property is suitable for generating vb6.0 to vb.net.I am sending my vb6.0 code where i used FlexGrid.
[Code]...
how to add a row on a flexgrid because i have a new table that i created and the table has nothing on it.
[Code]...
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 RepliesI am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
View 1 RepliesI installed a dot.NET FrameWork 2.0.exe to open my vb.net code. when i open the file. i cannot compile the program because of C1.Win1.Flexgrid error and some report errors. what is?
ComponentOne FlexGrid for .NET
ComponentOne REports for .NET
do i need this in the system? is it the same with the installer ComponentOne for studio?
I have installed VB2008 EXPRESS EDITION.
i have added com component msflexgrid ,but Getting error with this component
An error occurred creating the form. See Exception.InnerException for details. The error is: Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))
Recently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 Repliespublic class form 1
private dim row as integer
private num() as integer
[Code]....
i can't found flexgrid for .NET on standard control.
what other control for flexgrid ? datagrid ?
can use vb6 com control to use flexgrid control ?
I�m having trouble accessing a flexgrid from a different thread.Basically in my main mdiParent I have some code like this, this code is triddered when the aplication receives a message from a remote client
Public Delegate Sub UpdateActionsGridStatusDelegate()
Me.Invoke(New UpdateActionsGridStatusDelegate(AddressOf frmActions.UpdateActionsGridStatus))
I also have a form called frmActions, which contains the function �UpdateActionsGridStatus�
Public Sub UpdateActionsGridStatus()
MsgBox("Actions row cnt = " & Me.flxActions.Rows.Count - 1)
End sub
If I run it from a button on the flxActions form it works fine.When I run this function from a thread it returns 0 rows!
In Visual basic 6 I often use Flexgrid component, I see that in VB.NET these components are not available. Component should I use instead of Flexgrid. What do I need to call Flexgrid componet (VB6 Version) into the project. NET from COM.
View 4 RepliesI have this code in vb6 the result of this query is bond in flexgrid how can i do this in vb .net using data grid.
Dim SQL As String
Dim rs As ADODB.Recordset
'SQL = "SELECT PO_Header.OrderID, PO_Header.RefNo AS [PO Num], PO_Header.OrderDate AS [Order Date],Category.Description + ' ' + SubCategory.Description as Department, " & _
[CODE]...
I am trying to send Flexgrid Data to Excel By using below Code,But it gives Error:
[Code]...
I've created a control class that inherits a Panel control. This control then contains two other panels, one of which I would like to be an IContainerControl.I know how to turn the entire control into a IContainerControl but have been unable to do the same to a child control. I've tried in both C# and VB.Net and failed with both.
Does that make sense? I tried searching but didn't find anything that helped, hopefully someone here can get me on my way
I am trying to write a program to control the speed of all my fan's (GPU,CPU, Case fans) I have my form set up now I just need to code it. I have a button that when used will detect the different fans and fill txt boxes with information for each fan but when I started looking for info on how to do this I found a lot of posts saying its not possible with Visual Basic. Is it possible or isn't it? Where would I find the info that would show me how to do this?
View 2 RepliesI'm making a text editor. I found that control-i automatically adds some sort of space block into the textbox by default; like how control-z undoes even if I don't code. I want to use control-i for making italics text; but the spaces are interfereing. It's one big block of spaces.
View 3 RepliesI am trying to make a user control for information received from a database but i get:The class WFUserControl can be designed, but is not the first class in the file. Visual Studio requires that designers use the first class in the file. Move the class code so that it is the first class in the file and try loading the designer again.
Do i make the user control directly and add the code? Because thats what i did.. Or are there steps to do first before creating it?
Which one is more faster between DataTable and SqlDataReader while I'm trying to fill Data into FlexGrid with VB.NET?
View 3 Replies