I am wanting to create 2 tables called Stores and Locations. Locations is a table containing a unique location_code and a location. Stores is a table containing a unique store_code a store name and a variable number of location_code's and a relationship is set up between the 2 tables.
creating the Stores table in particular the location_ code. Can rows in a table have differing numbers of columns? as a particular store type could be in many diferent locations. I feel it should be possible to set up some sort of array of Location_code's in the Stores table.
Is there a problem with changing the column length in table and using comboboxes that display a partial list of the records from that table.I had a column(Name) that was 18 chars long. I would then display only a subset of those names in a combobox by not listing records where a column called privileges was set to X. This and other uses of combobox worked fine till I increased the column length to 24. The combobox no longer filters on the privileges field though when I select the column priviliges after my selection it will display the value X.
I have Dataset ds filled up with values Until now I was displaying values in GridView. Now I want that all the rows should be columns and columns should be rows.I have 2 options: Either 1 I can directly convert grid to columns and display it, or 2 I can convert the GridView to html and then write loops to convert. I was trying the 2nd option but I cant figure out how I should do that.[code]With this code I am still getting same as GridView. Please help me for converting rows to columns and vice versa.
I have three table and I want to put the three table's data in one variable and from that variable i will produce the datatable and then want to write the data in CSV file.I am Following this step..
I have an integer that is storing the result of a division between two numbers. I usually receive an result that looks like 5,2496874654. How can I limit the variable length so it looks more 'approximated', like 5,25?
Me and my coworker were discussing variable names today because we both have completely different naming conventions...but we were wondering is the a limit on the length of the variable name??? is it posible to do this: dim
ItsPeanutButterJellyTimePeanutButterJellyTimePeanutButterJellyPeanutButterJellyPeanutButterJellyWithABaseBallBatPeanutButterJellyPeanutButterJellyPeanutButterJellyWithABaseBallBat as string = "lol"
I need to truncate to sertain amount of decimals for example : dim x as double;x= 6.98455 textbox1.text = x that mean textbox1.text= 6.98455 I need textbox1.text= 6.99
I'm trying to call the GetInterfaceInfo Windows API - it accepts a structure as one of its parameters and this structure has a member that is an array. The API populates the contents of the array when it is called and there can be any number of items in the array. How can I define such an array in my structure?
If I just use a normal .NET array like so then the program just crashes (no exception thrown)
<StructLayoutAttribute(LayoutKind.Sequential)> _ Public Structure IP_INTERFACE_INFO Public NumAdapters As Integer
[Code]...
and this works fine, but the problem is I have to define the SizeConst attribute as you can see to something large (64 in this example) so that the API doesnt fail because the array wasnt big enough. Firstly this is a waste of memory as in most cases the number of items the API sticks in the array will be less than 10, but secondly if there was ever a case where the API wanted to put more than 64 items in then it would fail.
Using ReDim to set the length of the array at runtime seems to have no effect, and that SizeConst attribute has to be set to a constant value so there's no way I can dynamically set it.
Is it possible to have a 2 dimensional array of a type struct such that the size of the last dimension can vary by element of the first?eg:-structure mydatadim param1 as integerdim param2 as byteend structuredim main_array(100,10) as mydataThen at anytime change the size of the last dimension like...redim main_array(10, 5)redim main_array(15,7)leaving all other array entrys' last dimension unchanged and independent??VB2005 starter
I have a query that I have to run that requires me to get rows from a table based on the value of a field in another table (which I have gotten earlier). I currently have it done like this (simplified).
I try to determine the lenght of a string variable, but get the wrong outcome when using: testje = Len(testSTR). When I insert the following line of code: testje = testSTR.Length the answer is still wrong but when I click "Length" I see the correct value. How to get at that value, so I can use it?
I have a problem when debugging a code. On top of class I declare an array, and the length of array is an integer variable which is applied value below declaration of array.
E.g. class declaration Dim array1 (2, integer) as string Public Sub integer = 5 End Sub
So basically, array is created with integer being 0 or whatever, because it is declared before integer was assigned a value. But the problem is, I need it to be declared at class variable so I can use array in different subs.
I am using MS-SQL and I am trying to write a query which fetches rows from the master table and related rows from the detail table. Now, the thing I want is that it must only fetch the first row from the master table and related field from the detail tables should be blank in that first row, now if there are related rows found in the detail tables, they must be shown in the separate rows. I have been trying using the following query but it is not giving the desired result.
Structure MyInformation <VBFixedString(4),System.Runtime.InteropServices.MarshalAs(System.Runtime.InteropServices.UnmanagedType.ByValTStr,SizeConst:=4)> Public ReturnStatus As String
Using VB or C#, I am getting a string of variable length from the database. This information is sensitive information that only certain users will be able to see.I have two cases that will use the same logic (I think).scenario 1: replace all characters with xscenario 2: replace all characters with x except the last 4 characters (assume length > 4 - this check is being done).I thought that this would be easiest using Regex.Replace(input, pattern, replacestring). As opposed to a lot of string handling with substrings and forcing a length of 'x's.
While using the Socket.Receive method to receive messages through network, you should define a variable as the buffer and you have to specify the length like this: Code: Dim _ReadBuffer As Byte() = New Byte(LENGTH) {} My question is: What is the bad thing about increasing the length of this variable even if the received messages are sometimes shorter? (i.e. if some body let it 10000).
I have an existing vb.net application which uses a home grown database. The database has over 60,000 unique multi-field records in it.The user can search in each field using drill-down to find a record, and then can add that record to a separate database.(60,000 collectibles described in a master database. User can drill down by category, manufacturer, year produced, etc. to find a record and then add it to their own 'collection', 'wanted', 'have for sale', or 'spares' database for record keeping.)
Instead of having them drill down, I would like for them to be able to perform a search and have all of the results (any amount of matches from 1 to 60,000+) appear on a scrolling form with a checkbox next to each so that they can simply check any that they want and do a mass add to their list databases.
The part I cannot figure out is how to have vb.net (2008) create a variable length scrolling form with the results, and how to identify the checkboxes (generated by the system for search matches) to see which, if any, have been checked by the user.
I have three sub tables that I want to process. For each I want to combine the rows, as they are only different by contents in the second column(I want to do the same to the fourth column, later):
I've got a table in an SQL server that often has large amounts of data imported into it via an automated process - the problem is that a lot of the data that gets imported is a duplicate of data that is already in there (for example if we have a customer in there called Mr Customer Ltd, a duplicate with a slightly different name could get imported, like Mr.Customer Ltd).
So I am using the Fuzzy Logic class that Wild Bill put in the CodeBank to find names that are similar and then highlight these items. The thing is that the target table that the imported data ends up in has several thousand rows and the table that contains the data to be imported often contains several thousand rows as well, so I'm trying to decide how to do this. Obviously reading both tables into memory is not an option as it will consume too much memory on the client PC that is running this app. So this is what I am doing at the moment:
1. Read the table that contains data to be imported into a DataTable in memory
2. Open a connection to the target table and use the SQLDataReader to start to loop through it
3. In this loop, for each row that the data reader reads I then loop through the entire set of rows in the DataTable and run this fuzzy logic method that compares the account name from the current row in the datatable loop to the account name in the row that the datareader is currently on.(there is also a Thread.Sleep(1) after each row is processed to prevent the process from eating up 100% of the CPU while it runs)
My DataGridView sorts by date. For grins I entered the date 11-02-2010 fully expecting it to be at the bottom of the list, not listed right after the last 11-02-2009 row and before the first 11-03-2009 row.How do I handle this so that come January 1, I won't see all the 01-01-2009 rows listed first followed by the 01-01-2010 rows then the 01-02-2009 rows, etc?
Can anyone tell me why "Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound." I keep getting an error "Invalid Operation Exception was Unhandled" error. All I am attempting to do is allow the user to select products from a list(or a second datagridview) and have it added to the datagridview so they do not have to type in every cell since the other cells are not visible because they do not purtain to their needs. Plus they will be able to save all items at the same time.
I have two datagridview's both are databound. First one shows items for sale and the second stores all the items that were sold. I am trying too transfer selected rows from one to the other but no matter what I keep getting told "Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound."
How do i use Variables as the values to insert into the SQL table. I tryed:
Dim cnnConnection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=" & Application.StartupPath & "DatabaseRecords.mdf;Integrated Security=True;User Instance=True") Dim ImportValuetoSQL As String = 1 Dim cmd As New SqlCommand
