how I can pass data from my VB form to InfoPath?
I'd like to have a link on my VB form that will open an InfoPath Form with some information already pre-populated (name, date, etc.) with information that is already filled in on the VB form. I'm pretty sure there is a way to do this, just haven't figured it out yet.
I am trying to extract a hyperlink using the open file dialog with no success.System.NullReferenceExceptionObject reference not set to an instance of an object.
at DPR_Library_5.FormCode.CTRL177_5_Clicked(Object sender, ClickedEventArgs e) in \srv-na01user
epInfoPathProjectsDPR_Library_Final_1_GetFileFormCode.vb:line 76
[code]....
Does anyone know how to call an InfoPath form to open from VB? The form is located on a webserver so the path would be something similar to[url]...
View 1 RepliesI've got a program where the insert/update SQL was created with the values coded directly into the SQL string. I've changed this to use the Command's Parameters.AddWithValue method and all worked well. I'm now in the process of separating the data access code out into it's own class. I've got the Select code working using a DataSet in the form that I pass ByRef to my data class so it can populate or refresh it. My sticking point is in how to pass the parameters for the Insert/Update commands to the class since from the form I no longer have access to a Command object. Do I need to make the Command object in the data access class available to the form?
View 6 RepliesI'm trying to create a save button on my infopath form that when clicked, it automatically saves the infopath form to a directory. I'm running into some issues, I thought it would be simple but is quickly becoming confusing. [code] I've tried searching all over but couldn't find an answer that pertained to xml documents such as an infopath form.
View 4 Repliesi got 2 forms.there are 2 buttons in the 1st form and what i wan is,when a user click button 1,then will show form 2 will related data,click button 2 will show related data which is different with form 1.so far wat i get is,i oni manage to make when a user click button 1,then show form2 n in d form 2 there is another button to click n get d data...which mean i nid 2 create more forms...erm...u can say that i would like to make the form 2 to become a template...and send data into it.[code]i just wana make like i click button1 in form1,it will pop out form2 wit related data.
View 7 RepliesDoing a small project where I would like to be able to print the results of certain calculations. I want to open a new form where the data can be neatly presented and printed. I just can't seem to make the data get passed along to the new form when I open it..
[Code]...
i have two form in vb form1,form2form1 contains button1,textbox1form2 contains utton2,textbox2form1 button1 contains code to show form2 myfrm2 As New Form2myfrm2.ShowDialog()
View 1 RepliesIn reference to this post [URL] I have another more specific question about passing data between forms in VB.net I have a form with over 50 variables that I need to access on a second form and if i followed the method above, my form 2 will end up way too long and time consuming. I'm making a complex calculation software that prompts user inputs values and calculates all those unknown variables. I need to display all the resulting values in the 2nd form. and from the 2nd form , i want to give the users an option to export all those values to an ms Excel sheet.
[Code]...
I have returned to a project I started a while ago. I have a small members database showing basic info (Title, Forename and Surname) in a data grid view with all data populated from a SQL database. I have the dataset populated with all this info as well as other data through the use of relationships/foreign keys (Addresses and Telephone Numbers, etc)I have tested the relationships using a simple form which shows the correct addresses, telephones, etc for each user as you navigate through it.
I now wish to show just the datagridview on form 1 which is read only with the row select set to full row (I have done all this so far). I have also set up a second form which displayes just the relationship data.I want to be able to load the second form (with the address and telephone number data, etc) when the row is double clicked by the user. ie - if row 15 is double clicked on, then the second form should load the address and telephone number data for record 15.
In a threadpooling situation is it possible for a modal form to be opened and data from that form to be passed back to the thread that opened it ?
View 1 RepliesI'm new to Visual Basic 2010, I programmed in VB a long time ago. getting back into it. I have a SQL 2008 database and I want to use Visual Basic 2010. what I want to do is bring up a form with a group of products for my company. Based on the users selection they will put a check mark next to the product and then submit the query/data filter/ selection.passing that information to another screen with the details of all the sales for that item.
View 6 RepliesIn my WPF Form1 I have TextBlock1 that fill from AddressTableAdapter. To edit address user must click EditButton to open Form2 to perform changes. My problem is passing data to Form2 from Form1. In Form2 I have 3 TextBoxes Street, City, Zip, and StateComboBox. I try to code in Loaded procedure of Form2 like this and got error message:
Private Sub Form2Detail_Loaded(ByVal sender As Object, ByVal e As System.Windows.RoutedEventArgs) Handles Me.Loaded
Me.AddressTableAdapter.Fill(Me.AbcDataSet.Address)
Me.StreetTextBox = IIf(IsDBNull(AbcDataSet.Address.StreetColumn), "", AbcDataSet.Address.StreetColumn))
Me.StateComboBox = IIf(IsDBNull(AbcDataSet.Address.StateColumn), 0, AbcDataSet.Address.StateColumn))
End Sub
i have three forms
when i click button1 on form1=====> form2.showdialog()
then click button 1 on form2 =====> form3.showdialog
then click button 1 on form 3 =====>
[code].....
I use VB to get data through my form. I have some optional fields in my form and I have a problem with the following code:
MsgBox(myXPathNavigator.SelectSingleNode( _
"/my:Status/my:Questions/my:Questions1", Me.NamespaceManager _
).IsNode.ToString)
When the optional field 'Questions1' is inserted into the form I get the value 'true' by the IsNode() function.
If the field it is not inserted I have an exception stating that the reference is not correct (and it is indeed true). Is there a way to verify about a node, whether it is present or not in my form?
I am new to Office programming. I am trying to automate sending Infopath forms through Outlook. The form must be displayed in the body of the e-mail, which the customer can fill in and send it back. I am able to do this manually by selecting File->New->Choose Infopath Form through Outlook.
View 1 RepliesI'm having trouble passing an array of a user defined type to an procedure in a COM DLL. The prototype for the procedure i'm using is this:
HRESULT STDMETHODCALLTYPE GetData(
/* [in] */ DWORD dwCount,
/* [size_is][out][in] */ CSimData *puData) = 0;
CSimData is a structure which is also defined in the interface.
I'm trying to call it with the following code but am getting an exception:
Dim temp(1) As MACHPLANTSIM18Lib.CSimData
temp(0) = New MACHPLANTSIM18Lib.CSimData
temp(1) = New MACHPLANTSIM18Lib.CSimData
[code]....
The exception i'm getting is "COMException was unhandled - Exception from HRESULT: 0xC0000005" It looks to me that the array isn't passing properly to the COM function. I'm able to send a single object, but when I do an array of objects I get this exception.
I have populated an array.
Button1 click event
Dim array1 (3,3) as string
array1 (3,3) = "BLA"
End Event
Now, in the same class, I have another button.
When I click on this button2, i want to use this array to stream files to textfile.
The problem is that I cannot pass data from button1 click event to button2, as I have to declare the array again, and that causes array to lose data on button2 click.
If I however, declare array on top of class, I get a funny error sying out of index range etc.
How can you add data in a window form to a sql database in visual studio 2005?[code]...
View 1 RepliesWhen the form loads I want to fill the combobox with the data present in the database. So I did the below
Private Sub BindCombo()
con = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:UsersGautamDocumentsVisual Studio 2005ProjectsF1pracF1pracBank_Account.mdb")
con.Open()
cmd = New OleDbCommand("Select * from BankAccount", con)
[Code] .....
Doing this code the data is added up in the combobox dropdown list. But when I am selecting a data from the combobox dropdown list,the all the corresponding data of the other combobox also get filled automatically. I don't want to let the other combobox filled with their data automatically....
regarding the DataGridView Checkbox.. I have two Forms, The 1st one has a datagridview..but in order to load the data to form1 datagridview, i need to open another form w/c also has a datagridview w/checkboxes on it.. I need to select a data in the form2 datagridview w/the use of checkbox..when i select an item..then press the ok button, the checked checkbox with the info corresponds to the data i selected will appear in the form1 datagridview. I have done this and works fine, but when i select two data or when i checked two items on the form2 datagridview.. only one info is added on the form1 datagridview.. here is my
[Code]...
I want to connect a form with an excel datasheet.
View 15 RepliesI have an Infopath form that retrieves data from a datasource, then populates a repeating table with a dynamic number of rows depending on employid. Once the data is populated, a "user" can enter numbers, times, etc. That part works fine. Now, what I would like to do is submit the data to a sql database. I just can't figure out how to navigate through each record of the repeating table. I have tried the following code, but have been unsuccessful. I can not get the XpathNodeIterator to work on the secondary datasource.
Dim domNav As XPathNavigator = Me.DataSources("getEmpHourlyPaycodes").CreateNavigator()
Dim rows As XPathNodeIterator = domNav.Select("/my:myFields/my:ReturnedData")
While rows.MoveNext()
Dim field1 As String = rows.Current.SelectSingleNode( _
"my:descriptn", NamespaceManager).Value
' Submit code will go here.
End While
We are using VB 2005(Visual Basic.net) with SQL server as database and MS Access for the Reports. Right now we are passing the footer label from our VB app to MS Access for a selected report. If the user closes that report(not closing access) and opens another report the footer label is not being displayed. Is there any way I could send the footer label to all the reports in Access as soon as I open the database.Right now in below code we are sending the footer label just for the report selected. Is there a way to send the footer label to all the reports that are existing in the Access database.
Here is the code we are using right now.
Public Sub printReports(ByRef trn As ITTransaction, ByVal blnPreview As Boolean)
Dim intSelectRptCnt As Short
Dim intI As Short
Dim strRpt As String
[code]....
From what I understand, when you use AddHandler you're not actually calling a Sub, so you can't pass a parameter. I'm confused on what to do though about this. I've just populated a DataGridView and added a button to it in the codebehind. I'm then using an AddHandler to add a click event to the button. So when I get to the click event, I need to be able to access to the datagridview because clicking the button takes data from the datagridview and loads it into excel. What would I do about this. This is my Method where DataGridView was just populated
Dim btn As New Button
btn.Name = dgv.ToString()
btn.Location = New Point(0, 0)
[code]....
I am working with some code that uses array lists and I am using some of these to pass data back and forth like this: whatFile = (sideLookUp(x)) and its working, BUT when I turn this code into a sub/function then I call it I get problems, like double to string errors, even though its all set to double.
[Code]...
The following is a text file of 4 lines delimited with (,) making 8 elements and 1text string making 9 eliments in all.In my Environmental dictionary Environment and Conservation, Devoid of life non-biological.The Oxford University Physical and Theoretical Chemistry Laboratory definition says free of biological organisims. Does this mean the water in a pond is not abiotic but pure water is?"The following from the MSDN help that works:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Using MyReader As New Microsoft.VisualBasic.FileIO.TextFieldParser("L:GlossaryListBox0
[code].....
I'm upgrading a project from VB6 to VB2008.I have a routine that clears a combo box, named 'cmbDataTable' which could be on any form. I pass the form and the combo box is cleared.
[code]...
I assumed it would be the same in VB2008 but I get the error.'cmbDataTable' is not a menber of 'System.Windows.Forms.Form'I am working my way through the project, first updating the global procedures - this is one - I haven't written the calls so cmbDataTable doesn't yet exist.
I have exported data from a SQL Server table into a XML file and the output looks like this:
Filename = 11190.xml
Table name = LRTest
<NewDataSet>
[Code].....
Now I want to save the above XML file into my SQL Server 2005 table
With the same columns using vb.net windows forms, in every exported xml file there are 100 to 200 records. .
I have a form program that runs long, and for kicks I was wondering if I could out put some data to a "real console" -not the Console useing the Output debugger.
View 8 Replies