I am encountering an interesting problem regarding using Crystal Report 9 with VB.NET 2008. Being asked to create Crystal Report without using attached DataSet or Tables. Instead use TEXT OBJECTS to be filled with data using DATAREADER.
The coding below running well except that it does not create a new row resulting in all the rows from DATAREADER overrides the one before it. The DATAREADER has 15 rows but on the Crystal Report it only display the last row from DATAREADER because of override the row before it.[code]...
I have a combo box in a form, I want to fill it with names I have stored in a database.I know I have to use the fill command, but I am not sure what code I need to use.I imagine I need to place this code in the form load event, where I wrote my code to connect to the database.Tell me if I am wrong, but, do I need to create a sql fill command, select Names From Users, then execute that command in the combo box object.
I have a combobox in a form, I want to fill it with names I have stored in a database. I know I have to use the fill command, but I am not sure what code I need to use. I imagine I need to place this code in the form load event, where I wrote my code to connect to the database. Do I need to create a sql fill command, select Names From Users, then execute that command in the combo box object.
I am having a bit of a problem working with textboxes, subroutines, and modules.I have a form (frmMain) with 30+ textboxes. These textboxes collect data input by the user either manually or the user can choose to have the program randomize all the numbers in the textboxes by clicking a button. To randomize these numbers, I have a subroutine in the module called randomizeData(). The problem I am having is that the textboxes on frmMain are never actually updating themselves with the random numbers generated in the module. No errors or anything, but no results either. Here is a simple summary of what I have going on.
Public Class frmMain Private Sub cbRandom_click() randomizeData() End Sub
Is this possible? I have tried a few different methods with no luck. I am more of a JAVA person, but am taking some classes for VB, and have been playing around. This is what I have tried:
[Code]...
I think I'm going about this the wrong way, but would like to know if anyone has achieved this. All I'm doing is printing a simple character map to 255 labels, each label containing a char. Not an assignment, just having fun.
I created this program to automatically post reviews I have written to this website. All the code works fine until the last line. It throws this error "Object variable or With block variable not set." I can't figure it out, because it works fine before this point when i call it on other pages.
Dim email, password As String email = "email" password = "password"
I have 100 text boxes on another form I have to populate. I don't want to use 100 Form3.txt1.Text = Mid(answer,1,1) as shown below, i would like to put them in a loop, like a For loop. But when I try I get Error1'txt' is not a member of 'WindowsApplication1.Form3'.Is there another way of doing this?
Here i have code filling a drop down box with the company name.
Private Sub Filllistcomp() listcomp.Items.Clear()
'define select statement
[CODE]...
This part works. The drop down menu is filled with all the company names. The following part does not work how ever.
Protected Sub listcomp_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles listcomp.SelectedIndexChanged 'create the select statment that serches for a record
[CODE]...
There is no error thrown either. The information is just not showing up.
I am using a Class_SQL that gets the table, creates the DataAdapter and DataTable.I have a combobox named cboFullname. I can fill the combobox with data from the database, ie: Dim sqlcmdtext As String = "SELECT *, Firstname + ' ' + Surname AS Fullname From Contacts". I can display full records in a datagridview.
I would like to be able to select a name from the combobox and have the record text boxes display the data and be changed with the cbofullname index changed subroutine. Here is my current code to date:
Public Class frmMain Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
I need to read data from text file to datagrid. I have a datagrid with 3 columns: Column1, Column2, Column3. I have two columns in my text file, eache is separated by double space. I need to make so that column1 from text file goes to column1 into datagrid and colunm2 from text file goes to column3 into datagrid. Column2 in datagrid will be filled with values from OPC server. So i made a simple
Dim mSr As StreamReader = New StreamReader("C:VBpirm.txt") Dim mLine As String = Nothing Dim mArray() As String
Im trying to fill my DataGridView with data where the Column "RefID" is equal to the tbRefID.text that is on the same form but its not working my code is as follows.
Public Sub New(ByVal lviQ As ListViewItem) InitializeComponent() Me.tbRef.Text = lviQ.SubItems(0).Text
[code]....
and the code for the FillByRef is
SELECT RefId, QuTask, QuCost FROM quote_tasks WHERE (RefId = 'tbRef.text')
all it does is add the 3 column header to doesnt add any data?
I have an object that is defined as a global variable based on custom class. Within that class I have an event that gets fired a certain intervals. These events are fired on the same thread as where the object is declared. How do I create a global object, but have the events within that object fire on a separate thread?
I am trying to write an VBA application in Excel 2010 using "Microsoft Soap Toolkit 3.0" on 64 bit Windows 7 to consume an web service. But i got an error while initializing an object of SoapClient30.
Would it be possible to make my program visit a website and basicly filling out a text field and using the submit button in a form?For example; I have a text field named "Field" in my webpage, and I want my Visual Basic 2008 application to visit that page, and automaticly fill out that field named "Field" with a string I gave my application, and next to click on the submit button.The purpose for this is because I want that the users of my application can post feedback on my webpage. I was looking for something like a MySql client but it's best if I would encrypt/hide the protected information such as table names or MySql passwords.And I believe that these users need to have specific MySql drivers installed to use it. So this idea sounds better. So, is there a way to navigate trough a website like this?
I was create Access database with Access 2003. I create VB project with Visual Studio 2005 Standard With connection wizzard I create coonect with this Access database, select all tablesI see this database inside Data sources and inside Server explorer Test connection is OK When I drag and drop table from Data sources, Wizzard don't create DataGridView, DataSourceBinding etc .. and I see popup window with mesage: Object reference not set to an instance of an object and then "game over"
I dont think I am writing the values to the object. Not sure if this is the best way to do this with multiple values.Public Function ListDMR() As DMRDataLists
Under component services, a COM+ component is used by the company, right-clicking it and choosing 'Activation' tab will show the 'constructor string' that is used for DB server connection by all applications. How can I access it the simplest way possible?
I have a class library that contains a number of classes. I would like to dynamically create an instance of one of these classes, set its properties, and call a method.
Example:
Public Interface IExample Sub DoSomething() End Interface Public Class ExampleClass
I'm trying to create a text file using the File Object and keep getting the following error message: "The process cannot access the file 'c:dataCompareResults5182009740.txt' because it is being used by another process." Here is my code below:
I am developing an IT Asset Tracking application using VB 2005 and SQL Server 2005 Express edition. Will I need to create classes to represent objects such as Computers, Printers, Scanners/Faxes, Contracts, Purchase Orders etc or are there any other approaches.For example, if I am correct, I will have a class called Computer and its properties will include Make,Model,CPU,Hard Disk,Memory etc. Is this the right approach.
Computers can be split up into Desktop PC's, Servers and Notebooks. Would I have to create separate classes for these as well or would they be ok under the Computer class.Once I create an object from the class, how can I use the object to interact with the SQL db.I am a beginner to VB.NET 2005 therefore I am slowly getting to grips with OOP.
i just got 1 question how do u create a (in excel ) variable table (database) inside a function which could be called for filling and reading through "for to next" loop module
I am attempting to create a new mobile app using VB in visual studio 2008. I select "File" "New Project". Select "Smart Device" in new project window. Select the "Smart Device Project" from templates. Select ".NET Framework 3.5". Select "OK" and get the dreaded "object reference not set to an instance of an object"
I have been getting some nullexceptions on the following lines of code...:
[Code]...
Its a text editor that i am working on. When a text is bolded and i have selected it, the button for bolding text becomes checked and same goes to the other ones like italic,underline and strikeout. but if I have selected a text with bold and italics and multiple ones, it gives me a "Object reference not set to an instance of an object." How could i solve this?
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.
Due to a discussion in another thread , I am starting to use business object in an 3-Tiered windows app. As a starting point, I am trying to build objects/classes on a table from my database.
I am using VB Express 2008, and I am trying to create a COM object to use in Excel. I have looked at the walkthroughs, but it seems they only apply to Visual Studio.
Is there a way to create a COM object in VB Express?