I needed to create an Access table programmatically an was able to by using Martin Xie's post but how can I set the Field1 - Field Property Index to Yes (No Duplicates)?
[code]...
I am looking to create an order reference which is something like this
PLC0000001
Where the 1 would be my order id
but lets say it gets to 100 would like
PLC0000100
In VB.NET how could I build up a string like where i know i.e.
the starting part = PLC
Ending part = Order ID
middle = fill in 0's
I have made a front-end application in Visual Basic .NET that will store data entered by the user in a backend Access 2003 Database. The application has other functionality as well.If the user searchs for a previous record that has been stored in the Access Database, I query the Database (SELECT ... ) using an OLEDB Connection and then display the records on a Datagrid on my Form. Everything is working fine, however, the Column Headings of the Datagrid are the Field Names in my Database (FirstName, LastName,...) rather than Caption Values (First Name, Last Name,... )
I tried looking up the net, but most of the topics addressing a similar problems use DAO, and I understand that it is not completely supported in VB .NET. I am fairly new to VB .NET and I am not quite sure how to address the problem or where I am going wrong. I tried using FirstName.Caption but that gives a Runtime error (One or more parameters missing from the Sentence)
I have an multi dimed array of stock sizes, material type and count. The array could have duplicate arrays. In the end I need an array that is condensed with no duplicate and the count field is how many there were in the array.
Example:
Original array
Material: STL TUBG Stock Size: 3" X 3" X 0.250" W/T X 254MM
Material: STL TUBG Stock Size: 3" X 3" X 0.250" W/T X 254MM
Material: STL TUBG Stock Size: 3" X 3" X 0.250" W/T X 254MM
Material: STL TUBG Stock Size: 3" X 3" X 0.250" W/T X 254MM
Material: STL TUBG Stock Size: 3" X 3" X 0.250" W/T X 102MM
Material: STL TUBG Stock Size: 3" X 3" X 0.250" W/T X 102MM
Material: HRS Stock Size: 1" X 4" X 175MM
Material: HRS Stock Size: 1" X 4" X 175MM
Material: HRS Stock Size: 1" X 4" X 175MM
Material: HRS Stock Size: 1" X 4" X 175MM
I need
Material: STL TUBG Stock Size: 3" X 3" X 0.250" W/T X 254MM Count: 4
Material: STL TUBG Stock Size: 3" X 3" X 0.250" W/T X 102MM Count: 2
Material: HRS Stock Size: 1" X 4" X 175MM count: 4
I have used ADOX for create some fields in my database in access but the required property of this appended fields (columns) are set in "yes" but I want to be them "No" who knows how can I solve this problem
View 3 RepliesI am creating a search function which searches a database for keywords in a selected field in FilmTable (name of table to be searched)
This is the SQL I am using:
CODE:
It is saying there is an error in the FROM syntax
I am building a data based application using VB 2008 an SQL Express. I need to create textboxes on my form using code, (With & End With) method. I need a simple code string that will allow the app to check if the field to wich the textbox wil be databound is Nul, If so the textbox will not be created.
View 8 Repliesplease tell me what is below code doing? is it creating array with two values or its creating to string index which will take value later? [code]
View 4 RepliesSo I'm just trying to understand why someone would want to use the shorthand property instantiation
Public Property CarModel As String <-- property
As opposed to
Public CarModel As String <-- variable
when I'm creating a new property in Visual Basic .NET in Visual Studio 2010, the rest of the Property (template?) doesn't complete the basic framework of the property in the code editor. It is now treating a statement like:
Public Property Length() As Integer
Instead of completing the property as it used to (code follows), it simply goes to the next line:
Public Property Length() As Integer
Get[code].....
What happens now is that, if I type in the 'End Property' code, the name of the property will now be highlighted as an error since it doesn't have a 'Get' or 'Set' portion.However, when I THEN type the 'Get' on the line following the 'Public Property Length() As Integer', then the balance of the property is created in the code automatically.I don't know how this got changed, but would love to change it back.Does anyone know if there's a setting in VS2010 that addresses this, or if it's something with the basic templates that visual studio uses for creating the basic code components?The weird thing is that for everything else, from class declarations, structures, functions and subs, the IDE still creates the balance of the code structure correctly. The only area where it doesn't is for Property declarations.
I know the question is a little choppy and perhaps misleading,but I have a gridview with dropdownlists on the rows. I created an AddHandler and a Delegate for the SelectedIndexChanged and it gets to the sub. Here is the code for that:
AddHandler ddlmgr.SelectedIndexChanged, AddressOf ddlmgr_SelectedIndexChanged
Public Delegate Sub DropDownList_SelectedIndexChanged(ByVal sender As Object, ByVal e As DropDownList_SelectedIndexChanged)
Protected Sub ddlmgr_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
End Sub How can i get the row's Id if GridView_RowCommand is not called?
There are lots of questions about this but I've not been able to solve my problem using the answers to any of them (after many, many attempts..)
I'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page.
I want to change the DoNotMail boolean value represented by a Gridview checkbox and automatically update in the database if the checkbox is checked from 0 (False, Will Mail) to 1 (True, Won't Mail) here is the code I used. [code]...
is it possible to do a two way sync on the entire gridview when the user hits a button so you don't have to do an update every time a row is changed? because the user might check the box and then check another box then uncheck a box and it would be a lot of updates...
I created a local Database in VB2008 with 4 tables, the problem is that I have a textbox in one table and a combobox in other table and I want that the information that I put in textbox appear after in combobox from the other table... that's possible?
Table: Filmes ... Field: NomeTextBox
Table: Tempo de Aluguer ... Field: Nome_FilmeComboBox
I'm Using Griaule Grfinger X 4.2 SDK for a project. I am able to enroll templates into database, also identify and verify fingerprints against registered ones in the database.But I have a further challenging issue. I want to be able to run through the database to check for duplicates so as to identify them in which I would put duplicates in a hotlisted database.
View 1 RepliesI have a page which has a GridView on it, which is populated from a database. Some of the columns in the GridView have text boxes, as well as Checkboxes.When the user saves the page, the page may error if they have not entered their data correctly. At this point, I need to re-display what they have entered already so they can simply make the correction instead of having to change everything from scratch again.
View 1 RepliesDim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
View 1 RepliesIve got two lists (each representing a table in a DB, so they are related). lstTransaction has t_id, date, and cust_id. lstCustomer has Name, and cust_id.For each item in lstTransaction Id like to find the index in lstCustomer where lstCustomer.cust_id = lstTransaction.cust_id.
View 5 RepliesI need to get the ID number from an acces table (I am working with GIS .. I do not nkow if that helps) from a record (I do not know if I am using the correct technical words here)
View 4 Repliesmay i know why I can't locate the index property for the radio button in VB.NET? This is because for my existing project which is converted from VB6, there is existing 4 radio buttons with indexes. And now I want to add one more radio button with index 5, but I can't find the index property for the newly added button. The VB.NET treat it as a new button.
View 4 RepliesI have some code and there are 2 errors which I don't understand I have tried all sorts...
1)The type for variable 'Index' will not be inferred because it is bound to a field in an enclosing scope. Either change the name of 'Index', of use the fully qualified name (for example, 'Me.Index' or 'MyBase.Index').
2)Function 'GetNewPhrase' doesn't return a value on all code paths. A null reference exception could occur at run time when the result is used.
I can't get it to work..
I have a For Each block loops through a list of objects, the objects are all instances of a single custom class I have made which has multiple properties.The logic used in this block uses a property of the custom class to do a set action, is it possible to dynamically supply which property it uses in the logic? This will be more efficient and prevent me from having to create this logic over for each property of the custom class.My best guess was that maybe it is possible with reflection, however my searches into reflection have left me more confused.
View 2 RepliesI am using System.Collections.Generic List.I created new class[code]but i want "UserName" in "ONE" class property created dynamic.
View 1 Repliesi am struggling with something quite elementary and simple. I am creating 200 dynamic textboxes with the following code :
[Code]...
Now, I need to restrict the user to type a maximum of 5 characters inside. The MaxLength property is supposed to help me with that, but the user is still allowed to type more than five characters!Later on, after I have crossed this bridge, I'll need to allow a minimum of five as well - so that the user will always be able to enter only five characters inside each textbox. Another problem in the future will be to allow only numeric digits. These are product codes, whic are always numeric, and always 5 characters in length
I have a VB.Net WinForm Program. I dynamically create panels with controls.Each panel has:
2 Labels
1 DataGridView
1 Button
Everything works fine the first time I create the panels.
Everything gets created, and everything is functional.
If I have to re-create the form, I get rid of the existing panels (and their controls) with this code:
[Code]...
When I re-create the panels, I get the panels and all of their controls except Buttons.When I step through the debugger, I see the buttons being removed, and I see them being created, but they don't appear in the panel
i want to create a modalpopup dynamically but i come across a problem.I pasted my sub here and i dont know what to do for that problem.When i want to show modalpopup,it says "Control 'mdldelete2' of type 'ModalPopupExtender' must be placed inside a form tag with runat=server."
Public Sub Raise_Alarm(ByRef p_Page As Page,
ByRef p_AssignedButton As System.Web.UI.WebControls.Button,
ByVal p_Message As String)
[Code].....
I am trying to access VB.Net exe on a client system through LAN.Its working fine for server with static IP address.In case I try to access it with server having dynamic IP address, It doesn't provide access(config file containing server name).
View 2 RepliesWhat im trying to accomplish is I have a table which im creating dynamically and I want in the first tablecell a radiobutton, second tablecell first name, third tablecell last name.The second and third tablecell work fine but having trouble with the radiobutton. Im making it a radiobutton list b/c only one name should be selectable. Below is how im creating the radiobutton list. I have omitted the second and third tablecell as its working properly. The yesNo variable is used to say i
tblrow = New TableHeaderRow
tblcell = New TableCell
If yesNo = "yes" Then
[code].....
heres my code i have it set up so when i press spacebar it should create and display a picture box my help is two parts one why is the picture box not displaying and how to i set it so that every time the space bar is pressed a picture box is created. The second part to that is how do i create a timer with that picture box that makes it move, i know how to make a picturebox move im just not sure how to do the for each statement to set a dynamic name and how to use the timer to affect it...
Private Sub Form1_KeyDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles MyBase.KeyDown
' Sets Handled to true to prevent other controls from
[Code].....
I need to develop a function called SetComboBox that accepts the category(ies) in the ComboBox as a string and returns an integer indicating the index position of the category in the ComboBox. The function is supposed to set the category in the ComboBox Selected Index property to match the string category stored in a database for an inventory item.
View 1 RepliesI use drag'n'drop from a datagridview to a panel. The panel holds an array of objects (think rows) so that the items from the datagridview can be dragged to the different objects. I use the y-index from the top of the panel to define what object the item is dragged onto.This works great as long as the object is visible from the start. However, if I scroll down to an object and then drag the item from the dgv, it gets released on the wrong object, as the y-index doesn't take into account the number of pixels I scrolled down. So, what I need is (if it exists) the scroll offset property for the panel, i.e., the number of pixels that I scrolled down. (Then I can add this offset integer to the y coordinate on which the user drops his/her object.)
View 5 Replies
