In the long rung, I'm trying to setup a program to have a local database of files (It's a media player, so think of the library in WMP). I'm just trying to figure out how to do it, so this is a proof of concept thing I'm having a problem with.
Here's the code:
Code:
Dim dsDataset As New Database1DataSet
Dim drRow As Database1DataSet.FilesRow
[code].....
When referring to a list or group in .net, generally, it starts with 0 as the first item, but concerning the starting place in an Access table the first row is considered 1. Is this correct and, thus, represented in the code below?
Code:
intCurrRow = 0
If dtOrderEntry.Rows.Count > 0 Then
ShowData()
[code]....
I have an application where I would like to allow the user to change one field in a datatable but leave the other ones uneditable. I am using a datagridview to do this but I can only make the whole table editable or not. The result should be an order form where you have a determined product and should only be able to change the number of items.
View 2 RepliesTrying to export fields to excel. Have set the references to Excel 12, But, the i, j loop cuts short the number of fields to export to 10 when there are about 16 to export.
[Code]...
I am writing a little program that does the following:Allows the user to enter a id number.Then when the find button is clicked, we connect to the database and run a select statement for the id.I am trying to figure out how to get the first name, last name and birthdate into textboxes on my form.
I would like to have a way to display a messagebox if the resultset = 0 so as to tell the user no records found.Then if the information is correct I am going to have a button to update the information which is going to call a stored procedure I have in place to update the record.how to make the connection which I think I have working and then loading the individual fields into the appropriate textboxes.
I use the following code in vb.net to search across several Access database fields, which works well, is there a way to find out WHICH field had the search data in?
[code]
Public Function Incomming_Number(ByVal strNum As String) As String
Dim oConnect As New OleDbConnection
Dim sql As OleDbCommand
[code]....
I have a combo box and a subform that uses continuous forms format. When Combo box changes, the subform POINTER points to the correct record. How could I at the same time highlight (change color) of all the fields in the selected record?
View 1 RepliesI have this code that I got from somewhere, I forget where, but it adds a checkbox array to my form. Now I have a button on the form that when pressed it will check all the checkboxes but instead I keep getting the error NullReferenceExpection where I put that red arrow. What am I doing wrong?
Public Sub frmAlarm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim Ypos As Integer 'Need to move the position of the checkboxes down
Dim NumWeek As Integer ' This is the number of checkboxes
[code]....
I need to produce a report for my program. I would have liked to make the report an excel file that gets data through my program. However this program may go out to people who dont have excel on there pc or have different versions to what we are using.So i had an idea that perhaps if i reference excel in my program then it will not matter if a user does not have excel on there PC.
View 1 RepliesI have written a program in VB.NET 2008 Express that references a .NET managed dll. I simply added a reference to the dll to the project. I then 'Imports' the dll at the beginning of the program and then can use it. Everything works fine when I am running the program in debug mode (and it uses the dll as intended), but as soon as I go to build the project I get an errors that it "Could not reslove this reference" and "Namespace of type specifier in the Imports 'ModbusTCP' doesn't contain any public member or cannot be found." The dll is located in a different location on my hard drive to the project location, but this was referenced when I 'added reference'.
View 2 RepliesI'm converting a VB6 app (that works fine) to VB.Net app for work using Visual Studio 2008 Express. I have Word 2003 SP3 on my laptop. I need to open an existing Word document; edit it; and save the changes. Now in VB.Net, when I try to do 'Imports Microsoft.Office.Interop.Word', only Microsoft.Office.Core shows up as a choice. I have Microsoft Office 11.0 Object Libary referenced. I've been searching the internet for hours but can't find any thing that helps. Can anyone here point out what I'm doing wrong? How do I get ...Interop.Word to show up as a choice?
View 3 RepliesBasically the code below is supposed to load data from a reader into a datatable, then compare a date to the start date and end date in each row of the table.However, I am getting errors on the if statement indicating Overload resolution failed because no accessible '>=' can be called with these arguments.I can probably do this with just the reader but I am playing around with a data table because I know I will have to learn how to cycle through the records and look at them at some point and this is a simple example I can use to do this.[code]
View 2 RepliesOften I have a list of object A, and I have another object type B that needs to hold a reference to one instance in that list. So, as far as I can imagine, it's three ways to hold such reference:
1. Make B hold the instance variable of type A
2. Make B hold some other key/ID of the A instance
3. Make B hold an integer of the list index of the A instance
I guess 3 is quite limited, and mostly suited for use locally inside a method, in a for-next loop etc. But with the other two I tend to have the feeling that I should use 2) over 1), as I believe I shouldn't "duplicate" the object.. But wonder if that is a mistake. I guess it's only holding a reference to the stack memory, so it doesn't really make any overload compared to holding just an integer key/ID..
Further my thought is that with 1), I don't have to loop through the list to get the correct instance, as it already holds it. However if A changes, it may not be reflected in B.A, if the A has been given a new instance, so then 2) would instead give access to the updated object A. So perhaps if A is a "dynamic" object that may have been reinitialized (if that's a word), I need to use method 2). However if it's a type of object that is only changed when for example the user opens a program settings form, and this setting form only changes value type variables, then perhaps 1) is appropriate?
This is kind of the case I have some times, and I wonder if I should then use 1), as it doesn't require me to loop through the list by key/ID. It makes other object hold the full reference, which is not really necessary, but maybe still more efficient? Although at the same time, maybe I shouldn't really care much about looping through an object list either, if the list is not very big.
I have a collection class, say ITEMS, that inherits a Dictionary (of String, SINGLEITEM). From the SINGLEITEM class, I would like to reference a property in the parent ITEMS class, what is the best way to do this? For example, say the ITEMS class has an IsDirty property and I would like to set that if ANY of the contained SINGLEITEM objects is modified, what's the best way to go about doing this?
I know I could add a reference to the collection class in each SINGLEITEM class (since I override the ADD method, I could make this assignment), but this seems like overkill.
I cant grasp it right now, lol. So here's what Im trying to do: I have two tables, a main table, and an employee table, with a foreign key in the main table pointing to the employee number in the employee table. Im trying to use a databound datagrid to show everything from the main table, and the corresponding name of the employee number referenced in the main table. Is there a way I can do that using DataSet.Table.Column.Expression, or what would be a simple way of doing this? I cant use TableAdapter b/c sometimes the database is offline, so preferably with datasets.
View 1 RepliesI'm currently refactoring an old Visual Basic DLL (VB.Net), which stores all of its data in one module called Globaldefinitions as public fields. There are about 200 fields, referenced thousands of times all around the code:
Public Module Globaldefinitons
Public a As Short
...
Public zz10 As Double
[Code]...
I need to change the module into a class with non-shared fields. This means, each and every of these thousands of references needs to reference the instance of that class:
globalDefinitionsInstance.a = 5
How do I go about this efficiently?
Regular expressions operating on the source fall flat. Refactoring tools like Re-Sharper or CodeRush don't seem to offer this functionality. Visual Studio 2010 cannot do it automatically either.
Class Foo
ReadOnly name As String
Public Sub New(name As String, dependentUpon As Foo)
Me.name = name
[code]....
The output of New Bar() is:
Dependent created. Dependent upon nothing.
Independent created. Dependent upon nothing.
It seems fields are initialized in the same order as they appear in the source code, which (a) leads to an unexpected result, and (b) seems a little puzzling, given that one is normally not permitted to read from uninitialized variables in .NET, yet that seems to be working fine above.I would've expected VB.NET to be smart enough to initialize referenced fields first, and only then those that reference it; i.e. I'd have liked to see this output instead:
Independent created. Dependent upon nothing.
Dependent created. Dependent upon Independent.
how to get VB.NET to behave like that instead, without simply having to swap the declaration order of dependent and independent inside class Bar?
I'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 RepliesMy intent is to have the code - on a button.click event - check the Username and Password fields and return an error depending on which is wrong. Or if both are wrong, return a different error message. I've set the username as parts and the password as parts (still learning how to use external authentication). [Code]
View 2 RepliesI have several sqldatasources for my gridview. All of the columns are autogenerated. However they all have some consistent fields and I'd like to make those fields template fields so I can modify the edit template for them such as adding a drop down menu. Is this possible?
View 1 Replieshow do I search for records using keywords from a textbox in all fields within my table (within my database).I am only aware of filtering rows based on a single column value only
View 2 Repliesexperience 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 RepliesWe have currently upgraded our development machines to Windows 7 and Office 2007. We have a vb 2008 app that references 2003 Office components to use for mail-merging to word.We loaded up our app in the vb environment today and were instantly greeted with missing components/functions which are related to the 2003 Office components. We can update these to use the Office 2007 components/functions instead, however we are unsure whether after doing this our vb app will work with machines only with Office 2003 on. can machines with Office 2003 on work with our vb app that references Office 2007 components?
View 5 RepliesI'm using a SQL Express 64 database on a separate server virtual machine. I've been developing my app for some time now in VS2008 on XP SP3. Using .Net 3.5 I've just come across a strange problem. If I update a checkbox from unchecked (the default) to checked, it saves OK. If I click to uncheck it, the change does not get saved. I'm using the UpdateAll method. I tried a single Update command as well, just for that table, but it was the same.
[Code]...
im new to this Submit information to web fields but this is what i came up with... im not sure if its corrent. that the WebBrowser1.Document.Submit is wrong def but here is my code
[Code]...
I'm trying to create a recordset with 4 fields. So I created the recordset as: Dim rs As New ADODB.Recordset..I am new to VB .net and I dont know how to define the four fields in rs.
View 2 RepliesI have the following SQL Expression Field in my Crystal Report 11.5
{fn CONCAT({fn CONCAT("SPR_PRODUCT"."PRODUCT_ID","SPR_PRODUCT_SUB_ITEM"."P_SUB_ITEM_ID" )},{fn CONCAT("SPR_PRODUCT_ITEM"."P_ITEM_ID","SPR_PRODUCT_GROUP"."P_GROUP_ID" )} )}
It works well in the Preview Mode. But when I use the report in my VB.NET 2008 Project it says the following:
[Code]...
I've been attempting to tinker around with connecting a MS access database to a vb 2008 app. I've successfully connected and can access the data by using the add data sources tab. But what I'm trying to do is create a form that has a (1) single line text box, (1) button, and (1)multi line text box. I enter a name in the single line text box, click the button(search db), and when the info is found, it is displayed in the multi-line text box.
View 1 RepliesCan I display two fields of a data in a combo box. E.g. when I have to select a customer, its name and city should be shown.... Like...
M/s Ananad Traders, Mumbai
M/s Anand Traders, Kolkata and so on.
I want to display in a combobox the names of the fields of a table (table is in SQL server 2005).
View 6 Replies