How can i refer to an access recordset in vb.net? when i just type the name of the dataset/recordset i am given an error that i need to declare it.Do these not work like forms or classes or modules?
View 1 Repliesi just started programming using DAO recordsets and almost everything works great, most of what I did is database stuff.including movefirst and other stuff like that. But when my boss came and deleted everything in the database and clicked on movefirst i got an error that says no current record. is there any way for me to trap that error
Dim AccessEngine As New DBEngine
Dim db As Database = AccessEngine.OpenDatabase(DatabasePath)
Dim dbs As Microsoft.Office.Interop.Access.Dao.Recordset = db.OpenRecordset("myTable",
[code].....
I am using Windows Forms on VB 2008 Exp. combining with Access 2007 as backend.I have designed a form to use ADODB connection with recordsets to retrieve and display data on label controls on the form.On the Form I have buttons like (First, Previous, Next, Last).... I want to use these buttons to navigate the rows of the recordset.However, I have problem in the codes - when I click the PREVIOUS button, it will tell me that either EOF is true. But if I click the NEXT button, it moves to the next record once.... Clicking on NEXT again, does not move to the next record..
See my code below:
Imports ADODB
Imports Microsoft.SqlServer.Server
Imports System.Data.Odbc.OdbcConnection
Imports System.Data.OleDb.OleDbConnection
[code].....
i suppose this is an IDE related question; (correct me to another forum if not)
View 1 RepliesI am trying to read an Excel workbook with VB 2008. I am fairly successful but I need to make the code more flexible. Currently I use.[code]There are a variable (unknown) number of sheets within a workbook, all with the same format, and their names are given in "SHEET NAMES". What I need to do is now loop through these remaining sheets and transfer the data. I can do this into individual "cells" arrays but I would like them in one 3-dimensional array, something like sheets(sheet-number,columns,rows)I am new to VB and I'm not too sure about variant type, but any suggestions would be most welcome.
View 2 RepliesI have just moved over from VB6 to VB2008 Express and I cannot get a simple recordset to work.All I want to do is create a very simple recordset form a single table in an access 2007 database file.In VB6 I just dropped a data object on a form, told it the database name and the table name and the job was done.I have been trying bits of code and the wizard for 10 hours I cannot get a simple recodset to work can some one give me some basic pointers please.If I try using the wizards I get some bizarre error message about ConectionString.[code]
View 4 RepliesI am trying to add a new record to a Visual FoxPro data table using an ADO dataset with no luck. The code runs fine with no exceptions but when I check the dbf after the fact there is no new record. The mDataPath variable shown in the code snippet is the path to the .dbc file for the entire database. A note about the For loop at the bottom; I am adding the body of incoming emails to this MEMO field so thought I needed to break the addition of this string into 256 character Chunks.
cnn1.Open("Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBC;" & _
"SourceDB=" & mDataPath & ";Exclusive=No")
[code].....
I have recordsets in my MySQL database like this (in german): Karrieren im Porträt: Interview mit Thorsten Franck - „Ich liebe Produkte" Now when I get the data with the MySQL connector reader and write it into an xml file I get just this: Karrieren im Porträt: Interview mit Thorsten Franck Ich liebe Produkte As you (hopefully) can see, the minus (it's one of those long ones) and the upper and lower quote signs are not shown. The table is defined as UTF-8, the output of the xml file also.
View 1 RepliesI have this piece of code which goal is to compare ALL records from recordset rs1 to ALL records of recordset rs2. Im doing something wrong because, when the code finishes I find that some records that fulfill the matching condition are not being considered as matched.
[code]...
My experience with Stored Procedures is limited and I'm hoping this will solve my payroll problems. Further, for what I'm attempting to accomplish a Stored Procedure may not be the best answer.I'm attempting a Payroll function in which the goal of the Stored Procedure is to fetch the data for a given Payroll Period, do math on the first returned employee, output a calculated result, then move to the next. Let me explain a bit more...Based on a Pay Period ID which is given to the Stored Procedure, I would like it to do the following:Select the employee in that period, add a total of his hours worked, then add that employees total commissions, whichever amount is greater - return that value (along with the totals - such as the total hours and total commission) - then move to the next employee until completed.
View 2 RepliesI am trying to learn the new methods in .net, but, I cant see a way to step through the data like you can in an ado recordset. I want to pull data from a table once, then split the data with a filter, then step through the rows gathering the dtata till eof. Clear the filter and reset it for the next batch.
View 1 RepliesI have a basic three form application. It doesn't seem to close after navigating through forms. If I were to open the application, and the main form is displayed. If I press the X button, the application closes fine(Goes from processes) If I were to open the application, and then navigate from the main form to another form using me.hide & form1.show, and press the red X on Form1, the application again, closes fine.
[Code]...
.NET developing and have a simple question, i've been stuck on this for a while and searched many forums first with no solution so i'm posting myself. In VB for excel i've used Screenupdating=false to disable the screen updating however now i'm creating a visual studio 2010 windows forms application and its not showing up as a property. Here's the code i've tried.
[Code]...
just wondering if it is possible to add a method to all forms in my project without having to do it on one form and Inherit all my other forms from that one
View 3 RepliesI'm using VB 2010 and need to multiply 2 user input numbers in forms, so basically: TextBox5 = TextBox2 * TextBox3 That obviously didn't work but it shows what I want it to do.
View 3 RepliesI'm working on a website where we'll be getting a lot of videos to be uploaded. To keep things simple and secure, I'm just writing VB.net windows app to suck all the files in a directory in, allow you to set some options, and start the encode by spawning a new FFMpeg process.
[Code]...
I have the requirement to create an application that has multiple front ends developed using Windows Forms, WPF, ASP and Compact Framework Mobile Forms.I would like to be able to create a series of obejct representing the business logic and have this logic accessible from the various front ends available. My first thought was to use remoting as I'd like to be able to pass the business objects back and forth between client and server but the compact framework doesn't support remoting and also transferring a full framework business object to a compact framework business object doesn't seem possible.My next thought was to use web services but again the passing of business objects seems to be very hard to accomplish. Without doing this I would have to create individual web methods for each business operation.
Finally my next option is to use sockets and write the whole client/server logic within some classes and expose them to the UI/Business layer. My only problem with this is it is not scaleable should the number of clients increase dramatically whereas using remoting or web services I can host the solution via ASP.Net.Does anybody have an ideas on the best way forward for this or even have any input on how they would write an application that required a windows form, wpf, asp website and mobile device GUI all of which want to use the same business logic?
We have an application that has a main form with a map on it. Right now the paradigm is to have forms that are displayed using menu items to display information to the user. Most of these forms are modal forms, but a couple are non-modal forms that interact with the map. For some of the forms, it really would make for a better user experience if we could dock them in the main form of the app and allow the user to see both the form and the map. For instance. We could have a list of map features in a docked window, and select one of the items on the list and have the map zoom to that feature. Or do the reverse: let the users select a map item and have a docked window that shows details of the feature. Sounds great, but I wonder about what sort of gotchas we may encounter. In particular, what if we have two windows docked at the same time? Could we get tangled up in our event code?
View 2 RepliesI would like to know if its possible to start up a second windows forms inside the parent form. Ex: A button is pressed and a new form is showed. I would like to keep that new form inside the parent form, and have it not be able to go outside the parent form.
View 2 RepliesI am writing a program for my A-level coursework But for some reason I got this build error this has never occurred to me before, I have no idea why I can't use string for the name of my form.
View 8 Repliesa program and i need to have a button put a file into a folder, i know how the button works i already have it doing some other stuff. i just don't know the code to copy and past it to a folder.
View 1 RepliesWhen I add a new, empty form to my VB.NET VS9 project, the linenherits System.Windows.Forms.Formis missing.What am I doing wrong here?I thought it would be added automatically.I experienced that some thing get weird if this line is not there (Form_Load is not firing, I think).
View 3 RepliesPassing data between forms without any public methods or properties on the forms. everything but the "Controller" class, which I would like you furnish. I just changed the title from "Intermediate" to "Beginner" This solution is an example of the Observer Pattern. The "Controller" class is the "observed" class, which in this case means it publishes events.
' File Definitions.vb
Public Delegate Sub MessageDelegate(ByVal sender As Object, ByVal e As MessageEventArgs)
Public Class MessageEventArgs : Inherits EventArgs
Public Message As String
[CODE]...
The program should initially display Form1, and Form2. Clicking of the button on either form will modify the Title Text of both forms. I think that you will find the final end result to be pretty neat, as it works with any number of open forms not just two. I think asking for the Controller class is easier than asking for the code in the forms. My solution for Controller class has 7 lines of content, 9 lines if you include Class, EndClass. A minimal solution could achieved with only 4 lines of content, but it would a textbook example of bad programming.
I'm looking forward to reading and adding more to the community here. I've created a text based rpg. Next semester we are learning Visual Basic. I'm on winter break and I would like to get a head start on my learning. I've been working on creating some forms and message boxes. What is throwing me off, is that I have a good feel for doing coding so that I get functionality the will produce effects in a console. Coding the forms is a bit confusing for me. Is this something that others have run into? Is their some good primers for VB? I don't have my text books yet.
View 10 RepliesI build my first Project composed of several forms and it�s working just fine. Id like now to redesign the project as a MDI Application. Once created the parent form, I can create child forms but thats not what I need. What I would need is convert my already designed and working forms to MDI child forms. How can that be done?
View 1 RepliesHow to create a data forms with the data forms wizard in VB 2005
View 6 RepliesI have no idea what I have done wrong here, so I'll just attach my project as a zip file and see if any of you are kind enough to look into it for me.I am reasonably experienced in C#.NET but having trouble using VB.NET for a school assignment.I cannot open half of my forms in designer view because "To prevent possible data loss before loading the designer, the following errors must be resolved".
View 1 RepliesI was playing a game recently and saw that they could use args in the shortcut, and I decided to try to impliment this into my application...so far, I got: (runs this sub on load)
Sub startup_args()
If Environment.GetCommandLineArgs.Contains("+game") Then
Dim path As Array = Environment.GetCommandLineArgs
[code]....
just to see what it returns, but the application crashes. I also tried path.tostring(), but that didn't work. When I did:
If Evnironment.GetCommandLineArgs.Contains("+game") Then
Dim path as string = Environment.GetCommandLineArgs.tostring
MsgBox(path)
[code]....
but that returned the value "SString.Array[]"...
What is the vb.net equivalent to accomplishing this?
static void Main()
{
frmCalcView view = new frmCalcView();
[code].....
Ive been working on this project of mine for some time now... though im not involved in IT in my current company, im just trying to help to at least have their system computerized (they are still doing it manually by paper & calculator)... I have one problem though which made me stick for 2 days (and still counting) without progress...How To Drag & Drop Between 2 Datagrids Between 2 similar MDI Child Forms
View 16 Replies