I'm making a database app. I've finish the search, add new, and add function. What I'm trying to do is to expand the functionality of the add new item function.
View 2 RepliesI am working on a media player, and I would like to setup a local playlist feature. I am using a single ListBox and its "Display-" and "Value-Member" properties. The display is the song's Artist and Name, and the value is the song's file path (i.e 'C:UsersUSERMusicetc.').To write the file path to the .txt file, I believe I can use the following code:[code]
View 18 Replieshow to create Quick info and/or parameter info for own code?
View 6 RepliesI am making a program, obviously, and I require some assistance. I found an explanation on how to read information from a Text file and have modified it for my needs. Here is my (modded) version:
Public Function GetInfo(ByVal playlistname As String) As String
On Error Resume Next
Dim PlaylistInfo As String
[code].....
I am trying to do is fill out a form with certain info, put the info into an array, and write it to a listbox using loops, arrays, and maybe a function if I need one. This is for VB2010 and here is what I have so far... I think there are ways to make it shorter but I cannot figure it out.... maybe just brain dead from all the coffee I have been drinking!
[code]...
Private Sub DisplayList(ByVal CusRef As Integer)
Dim ConnectionString As String
Dim SQLString As String
Dim TitleString As String
Dim conn As System.Data.OleDb.OleDbConnection
[Code]...
So that works, but how do I display multiple things, CustomerID & CustomerName on the same line?
I can't get it going, it only puts my CustomerName under the ID
under my project I have the following
However when I use this code.
lblABOUT3.Text = "Version : "
lblABOUT3.Text += My.Application.Info.Version.Major.ToString()
lblABOUT3.Text += "." & My.Application.Info.Version.Minor.ToString
[Code]....
how to correlate info from a textbox based on a listbox item selection. For example the user will select an item from the listbox, enter say the length of a song in the textbox say 2:00 for song #1, select say song #2, enter the song time for that song say 3:00, click on song #1 again and have the same textbox display the length of that song and be able to do that until there are no more songs on the list.
View 5 RepliesCan I get info from stored cookie on the local machine. I have a Webbrowser control in a winform, and I would like to output data from a cookie to a label or so.
View 4 Repliesi am trying to make a login screen that is connect to a database(NOT MS ACCESS).i keep geting an error when i try geting it to conect to the database
"Value of type MySqlData.mySqlClient.MySqlDataReader cannot be converted to System.data.OleDb.OleDbDataReader
At rdr = MyCommand.ExecuteReader()
dose anyone know whats going on
[Code]...
I created a database in access 2007, linked it to my project in visual studio 2008 (vb). When I enter some data using the UI, it does not save it in the database, and it's gone as soon as I run the program again. I dragged the textboxes from the datasource panel, onto the UI..
this is the code that was automatically generated by vs for the save button:
[code]Private Sub StaffBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StaffBindingNavigatorSaveItem.Click
[Code].....
I have 3 labels I want to populate with info from my database. I have a SELECT statement that works for only one piece of info but I need it to include the other 2 as well.
I have 3 labels: Current, YTD, and MTD My select statement is working for YTD but I don't know how to write the SELECT statement to include the others.
[Code]...
This code is correct...
Do While rdr.Read
issuebook.cbmember.Items.Add(rdr.Item("FName"))
Loop
Suppose i want to add both last and first name..I tried this but getting a error
Do While rdr.Read
issuebook.cbmember.Items.Add(rdr.Item("FName" & " " & "LName"))
Loop
I have selected the info that i want from my database but im unaware of the syntax need to be used to add them to the datagrid.The datagrid has the column...BookName, DateRetun and DateIssued.
cn.ConnectionString = "data source = RayonRayon; initial catalog = library; uid=sa; password=minnie"
cn.Open()
cmd.Connection = cn[codee]....
got a new problem while trying to add a new user into the database. After i've submitted all the data i get an error message saying "Conversion failed when converting the varchar value "Aron" to data type int" to be honest, im totally stumped as to what this could meen, does it meen its trying to convert string type data to an integer? Anyway heres the code im using
[Code]....
im trying to add a new user login to my database through my program, and i've got the procedure worked out, i just dont know how to retrieve the inputted data.
Basically i've got three text boxes that ask for "Name" "Password" "Phone Extension" but how would i work them into his statement?
CreateLogin.CommandText = ("INSERT INTO Users (UserID, Password, Phone) Values How would i follow up after "Values"??
I have a gridview with four template fields that I need to be able to put info into to save to the database. When I hit the edit button and my columns change into edit mode I can enter information just fine. But when I try to loop through the control to get the information it doesn't pick anything up?
Private Sub gvOLIAdj_RowEditing(sender As Object, e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles gvOLIAdjst.RowEditing
gvOLIAdjst.EditIndex = e.NewEditIndex
BindData()
End Sub
Here is the update event that I have so far... any ideas? Am I just not doing this right?
Private Sub gvOLIAdj_RowUpdating(sender As Object, e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles gvOLIAdjst.RowUpdating
Dim dts As DataTable = DirectCast(Session("BudgetsTable"), DataTable)
Dim row As GridViewRow = gvOLIAdjst.Rows(e.RowIndex)
[Code]...
how do i get info from 2 different columns in an Access database and put them together in a drop down menu. (i know how to get data so that i can see it in just a textbox but i dont know how to put 2 data together and then display in a drop down.
another question is how do i save info that has been changed back into the access database i got it from
last question- how do i make a textbox only take numbers
I am working on a project for my final in vb.net and I have a weird error when I try to insert info into my database. When I run the application it errors out on command.ExecuteNonQuery()and the error is Syntax error in INSERT INTO statement. I have the fields in my database are set as text at 255 chars. I have both inmports statments at the top, and as far as I can tell my statement is right.
Here is my code.
Dim con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source =../../Base/LogTextCopy.accdb;Persist Security Info=False;")
Dim StrSQL As String = "INSERT INTO TIMEANDDATE(DATE, TIME) values(@date, @time)"
Dim command As New OleDbCommand()
command.CommandText = StrSQL
[Code] .....
So I'm having more database problems. The specific problem I am having is that I am trying to update a DataGridView to display new information that was input into the database programmatically. I have tried several methods, but none have worked, and one actually "broke" the program. So I am in need of some more assistance.
Here is the current code that I am trying to use to update the view (this contains pretty much everything that I have tried up until this point):
[Code]...
I am just trying to get the information i collect from the pc's hostname and pass it into a db. All the db passwords, location etc are correct but i am getting nothing.
Imports System
Imports Microsoft.Win32
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1
Private Sub DB()
[Code] ......
I have been tasked by my boss to create an application that takes information from an excel database holding sales figures, margins, budgets etc calculates all the figures and exports the totalled values to a table and graph also in excel. Although this is fairly easy, there is some complications I am dealing with. In the database there are many territories, and each employee has 1 or more territories.I'm not sure what I have done wrong, however the totals are not adding up properly. My code is:
'Defines Excel Objects
Dim objExcel As New Excel.Application
Dim objWorkbook As Excel.Workbook
Dim objSheet As Excel.Worksheet
[code].....
I'm really new to any form of VB programming and I am trying to create a form which will allow me to take information from an attached database holding information on:
class names (i.e. Year6 Dragons)
Students names (i.e. Sarah Jessica Parker)
I want the design to look very similar to the form used in MS Access for the query wizard, which will allow me to choose a class and then specific students.
i am creating a booking system for my A2 project but i cant create tables or field in the database and enter information in them. I have created a ms access database in vb but after that im stuck. The database must be created in vb programatically as i get more marks for complex code.
here's my code
Imports ADOX
Module Module1
Sub Main()
[Code].....
What I am trying to do is get specific info from a database and what I am getting is the first entry.
I have made a database connection, made the top bar not visible and I have inserted a text box and multiple labels. My MDB database has 3 columns (street, city, postcode) and multiple rows.
What I want is when a user enters a postcode in the text field the other labels get the info related to it. I.E. when a user enters "FY1 3DL" the labels update to "King street" and "Blackpool". With the code below I get the first row from the database.
Code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.StreetsTableAdapter.Fill(Me.WcipcodeDataSet.Streets)
End Sub
When I insert a new record into my DB the same information gets two records not one. I am using A datatable and sqlcommand and sqlconnection and sqldataadapter and I'm using me.bindingcontext(datatable).position to move between records.
View 2 Replieshow to insert info into a database through textboxes on an asp page.
currently what I have to insert is this:
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim commandtxt As String
[Code].....
I am using the following SQL statement to retrieve information from an access 2003 database but this command keeps stripping out the proceeding 0 from the number of the month. The variable is called TBookingsDateFulldate
Dim sqlQuery As String = String.Format("SELECT [ID], [Date], [Zone], [Year], [Subject], [Teacher], [LessionID]" & _
" FROM tblBookings" & _
" WHERE (((tblBookings.[Date])={0})" & _
" AND ((tblBookings.[Zone])='{1}')" & _
" AND ((tblBookings.[Active])=0)" & _
" AND ((tblBookings.[LessionID])='{2}'));", TBookingsDateFull, TBookingZone, TBookingsTimes(B, 0))
just want to know how will i able to display the info description in my list view but the one that appears in the database is its id(using vb.net)
View 1 RepliesI'm writing a program in VB.Net and loading the info into a SQL database. Debugging it works fine on my machine that I am programming it on, it connects to the database and runs through all the info perfectly. However trying to get it to run on another machine it will not connect to the database. I realize the reason for this is the connection string, it's looking specifically at the file directory for the database. How do I change this so that it will function on any machine. The program is only intended to run on one machine at a time and not over the internet.
View 2 Replies