On my program I am trying to make so the combo-box's items save after when the user adds something to it. Like if the user closes the program and re-opens it can the items that the user added still be there?
View 5 Replies[URL]
how to make a filter that only show the items that checked and unchecked don't show in checklistbox
I am using VB.NET together with ADO.NET to create a program. I have set my TableAdapters as needed and bound the correct tables-columns to my comboboxes.My problem though is this:My combobox2 item is bound to a datatable. The table adapter's Fill method (the select command basicaly) includes a public variable in the where clause to fetch the correct results. I ll put some code here to clarify it a bit more.Public Class Frm_inv
[Code]...
I want to get all items from one column of database table to the combobox items.
View 2 Replies[Code]...
I'm making a combobox on a form. I want the combobox to have a list of choices from a table in a db. The two columns are a String and a Date. I want the date column to only show the year. I'm hoping I have the code right as it is above, but I'm not positive I've done the whole date thing right.
I have a form in my vb.net application used to take the data about the returned stock. The form contains two comboboxes. One, named combobox5, contains invoice numbers and the other, named combobox3, contains party codes. Both the comboboxes are pre_loaded using sqldataadapter.
Now what i want is to change the party code in combobox3 when the invoice number is changed in combobox5. Elaborating it further, When Stock is issued the party code is stored along with the invoice number to keep track of to which party was the stock issued. Now when stock is returned i want to keep track that which party has returned the stock and i want that the party code should be automatically selected when the invoice number is changed and it should be what is stored in the database against that particular invoice number....
I'm using the following code for doing so:
Private Sub ComboBox5_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ComboBox5.SelectedIndexChanged
' defines a new connection to the database
Dim con As New SqlConnection("Data Source=TAHA;Initial Catalog=ADT;Integrated Security=True")
[Code].....
i'm creating a simple search application which have a TEXT box and some combo boxes and radio buttons and a search button.radio button names "Videos", "Audios", "Pics" etc..when radiobutton of video is selected, a combobox is appear having options "DailyMotion", "Metacafe" etc I want that when i click "Metecafe" item in combobox of video, an other combo box appear having items Like "Entertainment", "How To", "+18" etc(categories of video search).
if combobox1.SelectedItem = "PAKISTAN" Then
combobox2.Visible = True
End if
if combobox1.SelectedItem = "INDIA" Then
[code]....
I'm doing this project where I need to save the names of the items from a listview to a .csv
Imports System.IO
Public Class cv7import
Private Sub cv7import_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code].....
Am using this INI Reader from CodeProject. I have a listbox with some items in it. I wanted to save the items in listbox to my ini file. I used the following code but the problem is, it only saves the final item.
Dim INI As New IniFile
INI.Load(Application.StartupPath & "Config.ini", True)
For i As Integer = 0 To List.Items.Count - 1
ini.GetSection("Initiate").AddKey("Part1").Value = List.Items.Item(i)
Next
[Code]...
I am happy that there is a forum like this with very supportive people.So on topic.I am a student creating an Inventory System software for my school using VB on VS 2008.I am having trouble saving items from a DataGridView to Access 2007.The codes I browsed here are quite different from what instructors teach us at our school.These are some of the codes we are using to save items from textboxes to Access 2007 database with a table named studenttable and database named student for your added information.
[Code]...
I'm trying to save each item in the listview to the database.Below is my code in saving items in the database. The MISSING CODE HERE is where I should place the listview item.
Dim commandText As String = "INSERT INTO tblBorrower (TransactionNo, IDNumber, SerialCode, DateBorrowed) VALUES (@TransactionNo, @IDNumber, @SerialCode, @DateBorrowed)"
Using connection As New SqlConnection("Data Source=GAMER-6SQLEXPRESS;Initial Catalog=dbInventory;Integrated Security=True"), _
command As New SqlCommand(commandText, connection)
command.Parameters.AddWithValue("@TransactionNo", intTransaction)
[Code]...
i am trying to add subjects and their corresponding grades to a table in you database. the table has these fields: Table1(subjCode,stdID,Grade1,Grade2,Grade3,Grade4,Grade5,Grade5,Grade6,Grade7,Grade8)And i have a checked listbox for the subjects and another for the grades. for each subject, the re are 8 items in the chklistbox, checked. The code should insert into the database a subject and its coresponding 8 grades
but when i try to Save i gives me an exception that index out of range(index was out of the bounds of the array)
[Code]...
I am writing some code and want to check if certain things are in my database. Is there a better way than just creating a new string, performing the select and storing it in the string? I have to do this a few times for several items in my DB columns, but is there a way I should be doing this that would not require me to make a new string, and a new select for several items, well a better way? The items in my db aren't all strings and the data types vary.
View 2 RepliesI have run into an issue and need help solving it. I know how to go about adding items to My.Settings and I have already created the Specialized String Collection to My.Settings called List but I am having some trouble getting the items and the subitems to save to the list.
View 3 Repliesa save button called sl and basically I want for all the items in my listview to save to the database I created called logins and I have 4 columns Email,Password,Proxy and Port. So how would I make it save to the database when I click that button. Also how would I make the database load automatically into the listview when the program is opened?
View 4 RepliesI have some items in my listbox which I will store everyone of them into my database, what I am doing now is looping the box and call my database saving logic to save every single item. I thought this is pretty inefficient, is there anyway that I can use to batch save my items so that I don't open and close the connection as many times as my items.
For Each item In outletToBox.Items
.CamCode = Items.ToString
.CamCampaignAutoID = retID
.CamRemarks = uitxtCamRemarks.Text.Trim
'---use savetable object to save to database table---
Next
How do I save the contents of a listbox?
View 18 RepliesI can save textbox1 items to txt file using this
System.IO.File.WriteAllText("C:log.txt", TextBox1.Text)
Reading is okay, but it overwrite on old txt which are in log.txt file. I want it to save all items with some SPACE like..
I write 12345 - saved to log.txt okay. but when i write 123456 - that old txt gets removed and new one overwritten. It should save it like..
12345
Space..
123456 and so on..
I have three (3) tables namely tblSection and tblEnrol. The following are the fields I used:
For tblYearLevel
YearLevelID===PK
YearLevel
[Code]....
I am quite new to VB.NET and I am attempting to create a console application that can write, save, load and edit sets of data. Lets say I have something like this:
[Code]...
However, I have no idea how to load the data so I can manipulate it in the EMPLOYEE structure system. I am not sure if I have made my question clear enough, for as you can see I'm quite new to programming and am not essentially familiar with the terms of speech.
i am able to add items in listview at runtime ,but not able to add this items and subitems in database?
View 3 Replieshow do you go about to Save Items that are added to a List Box into a Text File, with the Users Details, from when they log in?
View 12 Replieshow can i save all the items in listbox ex.
and here is the escalar command that i use to save to mysql db.
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim connection1 As New MySqlConnection(connStr)
[Code].....
Lets say you have a few text boxes, I know how to save the information in each box to a text file, but that creates a file for each box. Is it possible to save the contence of lots of different text boxes to 1 text file, and then when loading them it would load it all back to the right places?
View 9 RepliesI'm working on a program in which I have 2 comboboxes and have to be able to add new Items in both of them, now that all no problems at all but as soon as I close the program I loose all my Items. Is it possible to add a code which checks if an Item already exists and if so give a error message and don't add the new Item to the combobox?
View 4 RepliesI have an app I'm working on with multiple forms. One of the forms, frmLocationInfo, has textboxes and comboboxes which are automatically populated based on a combobox selection from a previous form, frmLocations. I've been able to get any changes made to frmLocationInfo's textboxes to save to the SQL database, however, when attempting to select a different item from any of its comboboxes, it's not saving to the database and instead, I receive a "Procedure or function...has too many arguments specified" error.
Here is the code for the Save button:
'Save changes to Locations db
Private Sub btnSaveClose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code].....
I do not have any code to show, but using asp.net, vb.net, and SQL with stored procedures.If on a page I have an item that is added to the database and therefore that information is "saved", is there a way to have an ("exit without saving") button on the page that does away with those changes?Using infragisitcs ultrawebgrid, you add an item to one table. You can add an item to another table on that page. i assume adding these items to the table automatically saves in the database. There is also a text box but without clicking save I do not believe that those items are actually added to the database. Update panel is used, I don't know if that matters.
If after someone adds to the table but then decides.. oh wait.. I don't want to do this just yet, is there a "one-click" way to act as if I never visited that page to add info? I'm assuming it would be deleting the entries but this would have to be limited to deleting ONLY those items added while making... we don't want people adding info, then going back and deleting once the "save" button has been pushed.
I am trying to be able to add everything within a listbox to a program setting that can be re loaded when its opened up again, I have the part to load them upon opening, but I don't know how to make it add all the items within the listbox to the setting, so it has something to load.
This is to load them on startup:
For Each item As String In My.Settings.logs
log.Items.Add(item.ToString)
Next
I'm trying to program a personal project, but I've hit a bit of a bump in the road.I've got a Button, a Textbox, and a CheckedListBox; when the button is pressed, whatever is in the TextBox is added to the CheckedListBox. However, when the form is closed and reopened, all of the CheckedListBox's items are no longer present. My CheckedListBox's name in the code is ZapList.
Can someone assist me in, not only saving all of the CheckedListBox's items, but retaining whether or not they were checked as well as the order they were in? I've run out of hair to pull (figuratively) and I really don't want to quit this project, too much effort has gone into it and I'd hate to see it go unfinished like my numerous other projects. :icon_cry:
I would like to be able to save to a db and send task to email or as text msg for instance nevermind that.. I have two variables of type ArrayList they are "_mList1" , "_mList2" and "_mList3"
_mList1 stores the list of Telephonenumbers , _mList2 stores the list of StaffIDs and _mList3 Some concatenated string.
theses variable lists will hold some data in runtime as explained and i would like to use them to populate a DB table again mentioned
tblTask (TaskID(PK), Action, StaffID(FK), AssignedBy, TelephoneContacted, NotesCotent)
tblStaff (StaffID(PK), FirstName, Surname, Telephone, Address etc..)
[Code]....