CODE:
This tells me "End of Statement" is expected. I'm trying to instantiate a new form, and I'm trying to pass information into the form that I will use to populate other data fields on the form.
I've tried looking up constructors, but I can't find where my is different than other examples.
I am trying to populate a web from from a SQL table.
Public Class userDetails
Public address1 As String
Public address2 As String
Public city As String
[code].....
however, there are like 50 fields in the User db, and it seems like a lot of retyping...
I have a MDI app that I am creating. It, of course, will have multiple MDI child forms. In each child form, I have an options button so that each child form can have it's own set of options. When I click the options button it opens an Options form. This options form is not an MDIChild.
I have a class that contains the child forms options. I pass this class to the options form using a constructor. This is how I call the options form:
Dim dlgPatternOptions As dlgOptions = New dlgOptions(thisPatternOptions)
thisPatternOptions is the class that I am passing to the Options Form.
This works fine and the options form does populate the options correctly. The Options form constructor is this:
Public Sub New(ByRef thePatternOptions As CanvasOptions)
Me.InitializeComponent()
Me.txtCanvasWidth.Text = thePatternOptions.CanvasWidth.ToString
Me.txtCanvasHeight.Text = thePatternOptions.CanvasWidth.ToString
End Sub
I change the options in the options form. How can I get those changes back to the calling form? Do I need to somehow pass a handle of the calling form to the constructor to get the changed values back to the calling form? Is there some way to pass a handle to the options form so that changes made to options will be pushed back to the calling form?
experience on how to create an engine using C# (VB.NET is okay too) that is generic enough to handle most cases of MS Word text fields I need to fill with data I'm getting from a database? In short, I'm about to embark on this little Office automation excursion and I'm hoping a little bit of feedback here.
View 2 Repliesi have this code which i am using to display data on fields on form.And if i read from the database and the reader has no rows the ballon tool tip should display from some time indication a message.The problem is anytime i select from the database and the if all reader doesn't have rows only the last message of the ballon shows.the rest doesnt.Please what have i done wrong
[Code]...
I am developing an application on VB2008 with MySql as database. I opened the connection without any errors. I have three fields/columns in my database and on the form. When I am running vb form data is not reflecting on to form fields.
I have written the following code in form load event.
'Dim cn As ADODB.Connection
'Dim rs As New ADODB.Recordset
'cn = New ADODB.Connection
'cn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" + "SERVER=localhost;" + "DATABASE=in_out;" + "UID=root;" + "PASSWORD=pacvision;" + "OPTION=3;"
'cn.Open()
'MessageBox.Show("Connection Opened Successfully")
'rs.Open("Select * from deptno", cn.ConnectionString, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic)
I'm using: [URL]. I already have the listener up and running. For the 'client' I'd like to change it to a 'form' program with a text field so i can enter one line of text and then a send button. I know how to drag the field and button over to a form but I'm not sure how to tell the program to use them?
Imports System
Imports System.IO
Imports System.Net
Imports System.Net.Sockets
Imports System.Text
Imports Microsoft.VisualBasic
[Code] .....
I am making a booking system. I am using same form for insertion and updation. How can I update by taking the values from the textboxes. For example if the user enters value for just 2 out of 8 fields then How can i update just 2 fields without affecting the rest of the record. I mean to say that if I use a single update query using all the fields then if some textbox is left empty then it will replace the database field value by null or something else.
View 2 RepliesI am trying to auto populate some fields in my datagridview on my form called frmInfo.
I will try to explain what I need. The main form of my project is called frmEntry. frmEntry is mainly a data entry form only. A binding navigator is present to navigate between different record stored in the database. I want the datagridview on frmInfo to "grab" info present in the text fields of frmEntry.
how i can implement below requirement using asp.net and vb.net.I have three fields in a form which are filled by users. Based on these three values, i need to auto-populate the 4th field.I have planned to implement this in the following way.Write a separate class file with a function to calculate the possible values for the 4th fields based on 1st 3 inputs. This function can return some where between 1-10 values. So I've decided to use drop-down for 4th field, and allow users to select the appropriate value.Call the above function in onchange function of 3rd field and take and use the return values to populate the 4th field. I'm planning to get the return values in array field.(Does this need a post back?)
View 3 RepliesI need to populate listbox datavaluefield with multiple field. The value will be coming to datatable - (dataset). I can't change the sql statement because it is under stored proc that uses globally lstSearchResult.DataSource = dt lstSearchResult.DataValueField = "EMP_ID" & "LNAME" &"ADD" ->> could it be possible lstSearchResult.DataTextField = "LNAME" lstSearchResult.DataBind()
View 1 RepliesI'm trying to create a table in Word using data from a table in Access. There are four fields in the access table that I need. 3 fields are text which I can populate the Word without any issues. However the fourth field is a memo with >255 characters.I'm struggling to come up with the proper code to allow me to populate the Word field with the memo data that has more than 255 characters. The code I have so far is listed below. But when it hits the memo field, it crashes on the line I marked with **. I know it's not text, but I've tried many different field types, but nothing has worked so far.[code]...
View 1 RepliesI have the following "contact" data (exampled below) stored in an xml file.I've created a frmContacts windows form and placed a list box control inside it.I'm new to the list box but plan to have the users manage the list by letting them add, delete, and pick from it. For searching there should also be a sort function/button (by last name then first name).If the user deletes from the list the corresponding data in the file will be deleted.If the user picks from or adds to the list, I'd like to find the best way to populate the corresponding data elements on another form (i.e., in their respective text boxes). This will include the ability to edit/save from this other form too.
<?xml version="1.0" encoding="utf-8"?>
<Rows>
<Row>[code]......
i am working on windows application.In this Application iam using two forms one form is for save and modifying the details of the Patient. This First form contains a 'Find Patient' Button .when we click on button. new form will be opencode in the 'Find Patient' button click//open a form2 from form1 dim f2 as new form2f2.show
In this form2 iam searching for particular patient according to their Id and retrieving all the details of the patient in a datagridview wat i have to do is when i click on any cell in datagridview of a particular employee. [Code]
I have WebBrowser1 and this code on a button: WebBrowser1.Navigate(URLBox.Text) That all works fine and I can enter text and go to the webpage. How do I:
1. Check for when the page has finished loading?
2. Auto populate 2 fields on the webpage and click login?
On a word document I would like to populate same data captured via User Form on multiple locations of a document... i.e. LastName I would like to appear on salutation paragraph and also in the body of the letter... I used REF LastName on the document when using VBA but it seems the same document when it is being populated via a VB application this skim does not work and instead "Error! Reference source not found." appears where ever the REF LastName has been used..
View 3 RepliesCurrently working on a project to automate the input based on the Summary file (xls format)
1. I want to be able to do the following: update, append, delete and populate the records to the various files based on two distinct fields, column A & F (see attached file).
2. Researched the process, requires knowing VB codes, are you familiar with this language? If so, how can I simplify the process? Please advise.
3. The files will reside on the SPP.
I have an abstract class which requires a delegate to function. I pass the delegate into the constructor. Now that I have a non default constructor I need to call the abstract class's constructors from the concrete class which means that I need to use MyBase.New(...). I have included a quick example below.
Public MustInherit Class BaseClass
Public Delegate Sub WorkMethod()
Private _Work As WorkMethod
[code]....
I have tried to do this but I keep getting the following error: "Implicit reference to object under construction is not valid when calling another constructor".Can I not do what I am trying to do above? I initially had the delegate setup in its own setter method. But then I am creating a deceptive API because it does require a point to a method to work properly.
what's the rationale behind this limitation: Constructor call is valid only as the first statement in an instance constructor i want to pass an argument to my constructor which validates this argument and calls mybase.new according to this argument but it doesn't let me
example:
Public Class prob
Inherits System.ApplicationException
Public Sub New(ByVal problem As String, ByRef inner_exception As Exception)
[code]....
how to execute this SQL Statement
Scenario:
Given Tables T_Data, T_AllDesc, T_System1, T_System2
Given Fields:
T_Data= f_id, f_Desc, f_CreationDate, f_CreationTime, f_System1, f_System2
[Code].....
I need to put following code in the Constructor of my startup form.
JohnKenedy.BusinessSQLEXPRInstaller _ins = new JohnKenedy.BusinessSQLEXPRInstaller(" _ <Installation Display Name>", "localhost", "<New database instance name>", _
"<new database name>", "<database password>", "<database backup filename>");
if (_ins.IsDone == false) _ins.ShowDialog();
if (_ins.IsRestart == true) {
Application.Exit();
this.Close();
return;
}
But I really do not know what the Constructor is and how to access it?
How come when I create new instances of a form and show it, it loads the form twice?[code]...
View 2 RepliesI have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
I am suppose to call a method and define it from the constructor of a form.
MSDN says this in regards to something im doing.
Whatever, does it mean?
I developed an app, tested on few computers and all seemed fine. But now, some people suddenly get an error, which I can't repeat on my computers. Part of the exception:
** Exception Text **
System.TypeInitializationException: The type initializer for 'NumoABC.functionsBurtuSummas' threw an exception. ---> System.InvalidOperationException:
The form referred to itself during construction from a default instance, which led to infinite recursion. Within the Form's constructor refer to the form using 'Me.'
at NumoABC.My.MyProject.MyForms.Create__Instance__[T](T Instance) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 180
at NumoABC.My.MyProject.MyForms.get_MainForm()
[Code] .....
The If Me.Created = False Then is because while the form is loading, some events fire the updatePersonDataHandlers() sub, but I don't want it to happen until form is fully loaded. In the module functionsBurtuSummas line 2
Module functionsBurtuSummas
Private f As MainForm = MainForm
I have many modules who work with the MainForms' controls, so I use a private variable f to refer to the MainForm.
where can I find the default constructor of a windows form? I mean:
Public Sub New()
End Sub
I should say that I Use Visual Studio 2008 as my editor.
I've constructed a custom System.Windows.Forms.Form that requires arguments to New. I want to use one of these as the MainForm in a Windows Forms Application. How do I get the Application Framework to pass those arguments as needed?
View 1 RepliesWhat I am trying tot achieve is the following:User inputs data in one form that saves to the dataset table no problems. On an edit screen I want the current data saved to appear in this page within all the relevant fields but when saving I want this data to add to the dataset table as an additional line of data so the transaction records are kept.I want to add a new datarow regardless of it saving one change or all 7 changes that are possble.
e.g. Line 1 - user inputs 7 cells of data Line 2 - user amends 2 cells of data Line 3 - user amends 1 cell of data an so on. Unfortunately the terminology for certain items above may not be correct as I am still new to this programming and still on a massive learning curve.At the moment I do not have the code for what I am trying to achieve as I really dont know where to start with it.I am currently able to save the data and have it appear in the "edit" panel however only the cells changed are saved an it overwirtes the initial input.
[code]...
I�d like to pass data from my VB 2008 project to data fields set in Word. Can it be done and if so
View 10 RepliesI have a combo box with a data source. This box shows one column of a table and allows me to select one item.Next, I have an ordinary text LABEL that I need to put text from another column of the item selected above.I tried to set the data binding field of the label, but this grabs only the first row or data and shows the selected column. That is nice, but I can not figure out how to update the selected selected ROW when the combo box item is changed.In this case the combo box lists a bunch of inventory parts. When I select a specific part, I need the change the text in a label to show the manufacturer. (like a sub-form). This same behavior will be used in several other places, but the relationships can cascade.
View 4 Replies