I am using a combobox in VB .net to show customer's name. They also can type new names if they wish. Can I somehow save these new names in my sql database dynamically?
What I mean is if the name is new and does not exist in my database, can it be automatically saved to the database?
My combobox is bound to my name table.
I am not sure how I could achieve this: allow the user to select a value (string) from the dropdown list of a ComboBox and display another value in the editable text. The user can modify this displayed value as well. In VB6 I had a combobox where the list property contained a two dimensional array. When the user selected a value from the dropdown list, the displayed value was set using the second dimension of the array. Something like this:
[Code]...
I was just wondering if this is possible. I have a site that admins use to add products to our database. The database is in SQL Server 2008 and I use Visual Studio 2010 using VB.net and was hoping that upon addition of a new product, it would automatically generate a folder assigned to that product's ID.I haven't found anything online that would suggest that this is a possibility, but it would make it a lot easier for me. As of right now, I have to remember to create a folder in the X: drive for each product that has been added. We are up to 645 products now,
View 2 RepliesI'm working with time and attendance application and i need to do something will help the data entry that will use my application so i want to create form to insert enter/leave time and date for all employees
[Code]...
I'm working with time and attendance application and i need to do some thing will help the data entry that will use my application so i want to create form to insert enter/leave time and date for all employees
textbox1 for inserting start of employee code
textbox2 for inserting end of employee code
textbox3 for inserting the date and time for enter
textbox4 for inserting the date and time for leave
I was wondering how can I fill a column automatically in the database with the GETDATE() ?
Like when I open the database the date of that column should be GETDATE() automatically
I am trying to go to the next item in a listbox automatically when a song finishes in my media player. I've done this in my other player, but unfortunately have lost the source code.
I have this code
If MediaPlayer1.playState = WMPLib.WMPPlayState.wmppsStopped Then
ListBox1.SelectedItem = Me.ListBox1.SelectedItem + 1
MediaPlayer1.Ctlcontrols.play()
End If
But everywhere I put it, it just doesn't work.
How can I get my textbox to automatically insert 'http://' before the url? It is an address bar in my web browser.
It needs to check if http:// is already there, and if it isn't, add it before the url.
when i input data to a textbox1 and then i press enter using keyboard, then another description will appear in textbox2. For example, i have to key in a company's code: A001 into textbox1, after i press Enter using keyboard, the company's full name will appear in textbox2.
View 4 RepliesI need to automate the installation of some Antivirus applications. I can easily do it by utilizing the Process Class, but I also needed to know if there was a way to automatically input the serial key.
I thought I remember someone mentioning a property or something that could be used for that, but I can't remember what it was or who said it.
When adding a new item (class, control, etc) in C# it will automatically add a namespace to the file depending on the location in the project.
Is this also available for VB.NET?
The code 'Namespace DataClasses.AX' and 'End Namespace' would be generated.
Namespace DataClasses.AX
<Serializable()> _
Public Class AxInventItem
[Code].....
When my application starts, it scans the computers registry for COM ports and adds them in the combo box. The combo box first index is just a blank, and the second is COM1, COM2,...COMn. What I want to do is by default, I want my program to select the first COM port in the combo box, so in this case, COM1.
I know I have to use the PORTNAME property of the serial object, but not sure how I would set that equal to the 2nd index of the combo box.
I have a textbox that represents a primary key in my database. Because the values are nvarchars I can't automatically increment for a new insert. Instead I have to read a value from a drop-down, perform some magic, and create a new incremented value for the new insert.
I've written codebehind that does all this when the drop-down is selected. It works, in that it puts correct values into the textbox. However when I try to insert, I get an error that that field cannot be null.
I'm pretty sure it's because I'm doing this in the codebehind : myTextBox.text = newValue
which wipes out the binding the textbox should have : Text='<%# Bind("UniqueName")
How can I calculate the needed value for this field programmatically and set it back to the screen so the user can see it (and possibly override it) and still keep the databinding intact so I can create the new record?
I'm trying to automatically insert commas after ever email in textbox1.text after the user imports a list of emails.Something like ..I want this to automatically occur after the user either drags n drops the emails into the textbox or copy n paste the emails into the textbox so that the user doesn't have to manually insert commas.
View 4 RepliesI'm trying to automate a form process from a previous employee. One of the things that I have to do to achieve this is select a COM port from a dynamically populated list. I've looked around and the closest thing I could come up with is something like:
.cbbCOMPorts.SelectedItem(1) =
True
While this compiles, the computer does not like this at run-time. It throws an exception out:
"Object variable or With block variable not set."
Is there an easy way to scroll an ASP.Net ListBox automatically to the first selected Item?[code]...
View 1 RepliesIf I set the capacity of a List(of T) and then want to add more item will it expand automatically or will I get an Out of Bounds error?Any source of information about List(of T) out there that I can check?I am writing an application that gets a text file read into a List(of T) and then searched by the user
View 10 RepliesLets say i have a class Employee which cotains two propeties (Name, Year) I have another which basically contains list of Employee object i.e EmployeeList.[code]...
View 4 Replieshow can i automatically update my value when a user changs the listbox item. At the moment i have a button click when the user changes the list box item and press the button the values get updated, everytime the listbox item get changed i have to repeat it click the button to update the value. I want something where automitically as soon as the listbox item selected the total value in the text box to change without clicking the button:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If ComboBox1.SelectedItem = "Seafood" Then
TextBox1.Text = 3.5 * ComboBox2.SelectedItem
[code]....
I have template designer form with scroll bar and maximized mode in MID form. Now, when I click on any of the item of ListBox placed at the the middle of the form, form automatically scrolls to the selected item. Is there any way to prevent auto scrolling?
View 3 RepliesI followed an example from a VB 2008 Wrox book on creating, binding and updating a data set but I am having a problem. The code is supposed to automatically generate the update/insert/delete statements for me (according to the book) but when I call the update command, the data is not saved.
Here is my code
Code:
Imports System.Data
Imports System.Data.SqlClient
Public Class FrmAddExpenses
[Code]....
After the form is loaded, I change the EntryDate field (which is a DateTimePicker) and close the form which should save the change but it doesn't work.
When I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
View 1 RepliesI am working on a project for a class, and am having trouble getting my program to automatically calculate the subtotal every time an item is added to the shopping cart list. I've tried sub procedures and functions, but I can't seem to get it to work.
[Code]...
could someone tell me what i am doing wrong in this codeProtected Sub insert_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Insert.Click
[Code]...
Visual Studio 2008VB.NETFramework 3.5Windows Application
I have a SQL database names TestSQLVB
In it a table called tblTest2, with a three fieldstest2id , int, pk, increment by 1field1, varchar(50)field2, varchar(50)
I have a dataset named Dataset2.xsd
A tableadapter named tblTest2TableAdapter
A insert query names InsertTest2 with fields @f1, @f2 and ExecuteMode = Scalar
When I run the following code per MSDN [URL] the database does not get updated.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim testds As New DataSet2TableAdapters.tbltest2TableAdaptertestds.InsertTest2("One", "Dog")
End Sub
im in the middle of doing sql queries i can search my data base usingGetDateFrom (Select, from, where) Me.nameTableAdapter.FillBy(namenDataSet.descip, Me.box1TextBox.Text,Me.box1TextBox.Text, Me.box2TextBox.Text, Me.box2TextBox.Text)i have this working fine im struggling with inderting data to my databse i have made the query ..
INSERT INTO `details` (`Forename`, `Surname`, `Username`, `Password`)
VALUES (''& ForenameTextBox.Text &'', ''& SunameTextBox.Text &'', ''& UsernameTextBox &'', ''& PasswordTextBox &'')
[code]....
I have a dropdown bound to a datatable. I'm trying to insert a new item at position 0, but when the control is loaded, I don't see the new listitem or any errors.
Public Sub Page_Load(ByVal sender As Object, ByVal e As eventargs) Handles Me.Load
If Not Page.IsPostBack Then
loadRegistrantAbstracts()
[Code] .....
i have a listview with 5 columns and how to insert data only in columns 4 and 5.
View 4 RepliesI have an application that manages orders in a system, it has multiple tabs e.g. "Summary" (New and Processing Orders), "New" (Only New), "Processing" (Only Processing) and "Completed" (Only completed).
View 3 Repliesmy test:
Public Class Form1
Public Const WM_SYSCOMMAND As Int32 = &H112
Public Const MF_BYPOSITION As Int32 = &H400
[Code]....
and i get an error:
PInvokeStackImbalance was detected
Message: A call to PInvoke function 'WindowsApplication1!WindowsApplication1.Form1::GetSystemMenu' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention and parameters of the PInvoke signature match the target unmanaged signature.