I have a database (sql server) where i store activity information example (activityid,id,summary,signs etc.) I can successfully save this information to the database. what I also want to achieve is to add this information to a listbox so that it can be displayed in the corresponding textboxes at runtime for an encounterid.
View 6 RepliesHaving found the following post on datareaders Topic Posted On DaniWeb i have managed to successfully create a datareader in a class that updates a listbox on the calling form with entries retrieved from a SQL server database.I was wondering if it is possible to achieve the same thing using a dataset?My ultimate aim is to read a SQL table / view of information (ie customers), add this into a list box so that when i click on a specifc line in the list box i can then use that selected entry to do something further (ie click a line and then an edit button to edit that records details)[code]
View 3 RepliesI've recently decided for my VB final that I'd like to tackle something my professor and I discuss constantly; portable game server apps.
What I'm wanting to do, essentially, is create just a rudimentary programme that allows you to check the server status of either the north American or European servers for the game Rift and just (instead of opening your default browser, which I know how to do already) displaying the info in a listbox inside the programme itself.
The information I have to work with (aside from the obvious direct .php link to the web page) is two separate .xml links that contain all the information that is contained on their webpage. I could easily just turn these .xml files in an access database but I want something dynamic rather than static, but I honestly have no clue of how to turn this info I have into something I can actually use in my programme lol.
How could I link a Listbox to a Textbox? So each Listbox item holds string data, and when I click that Listbox item, it shows it's string data into the multiline Textbox. For example
I have a listbox item names "Numbers". It holds this data:
1
2
45
84
So I want it to when I select this item in the listbox, it display the number data into the multi line textbox. How would I do this?
I got 3 tables in database namely A,B,C. how am i going to link the column a in A and column b in B to table C so that table C can have both my data a and b?
View 3 RepliesI'm creating a system (for a project) that is based on a vet.I want to create a combo box that has a list of different animals (e.g. Dog or Cat etc.)and when an animal is selected,a group box, with loads of checkboxes inside appears. Then the user can tick a check box (a vaccine to be given to the animal) and the record is saved to a database.I have hard coded this to work, but I want a more sophisticated code set, that links to SQL so that when a new vaccine is to be added, I would only need to add it in a table, in the database. I don't know where to start for this could any one give me a nudge in the right direction?
View 2 RepliesHow do I go about linking a picture to a database? I'm using VB 2008 Express and SQL Express.I want the user to click a button when editing a recipe; the button click will then open some kind of dialog where the path to a picture will be selected. Then a button on the dialog will be clicked by the user and the picture will be saved to a folder in My Documents called "My Recipes" at the same time the recipe will be renamed using the Title and ID of the record being edited ending up with a name like "Nick's Milktart 237.png" (preferably with a space between "Milktart" and "237"). Also at the same time a link to the database must be created to a field called "Picture".I have never tried linking pictures before, I understand the app. will respond much faster this way as to imbedding the picture into the database.
View 10 Repliesi having trouble in linking a database which contains name ,address, etc and most importantly the signature for each individual to vb.i know that microsoft access is used in linking those database to vb, but couldnt get the signature part to be done.
View 1 RepliesI want to connect to a database Ive created using Microsoft Access 2007. Im using Visual Basic 2005. I also want to be able to perform basic tasks such as searching.
View 1 RepliesA friend at work is trying to write a piece of database software for an HND project and when adding his database file, he gets the below error message. I'm too much of a greenhorn to know what it means, can anyone make sense of it?
View 1 RepliesI'm trying to link a datatable from one access db to another access db but i get this error:
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.[code]...
I have already linked the file into the form, but can't figure out the code to write for buttons to beable to view the first record in the database in the file that i linked. I need to make buttons to find the first record, last record, previous and next record. Then I also need to code buttons to add, change, and delete records.
View 4 Repliesi had created a form with datagrid view , in that a table is linked with MS Access database , i need the coding steps in vb.net
View 2 RepliesThe Calendar control (the Month Calendar) control in VB 2008. I am creating an attendance timesheet and I want the Calendar to color each date differently like e.g An employee Paul is selected from a list.
On the calendar I select the month. (The dates are not supposed to be selectable). Then lets say it is June. He is late on the 1st and the Second, so those days are supposed to be colored red (the whole block). Let's also say he is absent on the fourth and so I want that date to be coloured black. How do I do this? I tried finding a query and my friend told me that this functionality is not available in the current control and that I was best off making my own control (???).
I have tried selecting specific dates and bolding them (there is a function that allows this) but I am stumped trying to find two different ways to differentiate colours. Second:- How do I link a calendar with an Access Database?
After trawling around the net for a good few days, i decided to post something here.
Basically, i've got a problem linking a data source (Access 2007 database) to a VB 2008 project.
I've broken it down to having a problem dragging a table onto my form, when it generates the nav bar, it says "0 of {0}", and the table is empty (despite the actual database containing values)
However, this happens only at home, at college it works totally fine. The only difference that's obvious is that i'm using Windows 7 at home, and Windows XP at college.
I am working on a project that requires us to create a bracket type tournament and I am now stuck. I linked my access database to my project, and have 32 labels (lbl1-lbl32) and I cannot figure out how to integrate the labels to read from my database. It can be random or not, I just cannot get the labels to display the names of the fighters.
After the labels are integrated, the next coloum of the bracket has a link that opens a new window with each of the fighters match results, does the link have to include anything particular to display the attributes from the database?
Ok, so I`ve been studying a bit of VB lately.. bought a few books and read lot`s of articles and seen hours of instructional videos, and I slightly start to get the hang of a few things.. :) I`ve recently started a fun little project, but I seem to lack a bit of knowledge to reach my goal. I`ll first try to describe my project:
[Cde]...
I am currently doing a project which is to be linked with another project. I.e., when I click on some button in my current project's page I should get a page from the other project..
View 2 RepliesI have an e-mail that i send out and everything works fine exceptthe hyperlink doesn;t link.
taskMessage = <a href="C:\Program Files\Microsoft Office\OFFICE11\powerpnt.exe"> Powerpint </a>
myEmailClass.SendEmailMessage("myemail", "your email", "You have a new stalker",
[code].....
was just wondering if it's possible to link up excel and vb so that data can be inputted into vb and then transferred to excel which would carry out calculations using functions and send the data back.
View 2 RepliesI'm trying to do is access a DLL that is outside the original EXE's file structure. So like this
C: estexe estexe.EXE 'The EXE that needs to access the DLL
C: estdlls
eturnstring.dll 'The DLL I'm trying to access.
So far everything I've tried has failed. I keep getting a FileNotFoundException.
I've added the following code to my app.config
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
[Code]....
If I set a ListBox.Height = ListBox.PreferredHeight when the control is hidden and IntegralHeight = True, then set it visible:
a) Actual Height reduces by typically 3-5 pixels after redraw (but not 1 pixel per item).
b) PreferredHeight does not not appear to give the correct integral of item heights.
Is there a way to make ListBox calculate the correct integral Height before the ListBox is made visible, so it can be correctly pre-positioned from bottom edge?
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
ListBox1.Visible = False
ListBox1.IntegralHeight = True
[CODE]...
i want to add all items from my listbox into a database. the first item has to go into the first row of the table followed by the second item into the second row followed by the thir in that order. I have already created the connection with the database. I now want to write an insert query to insert the items into the table with the sql command in a loop but i don't know how to get each item from the listbox and add it to the insert statement. I want to assume that non of the items in the listbox has been selected.[code]
View 1 RepliesThe following is the code that i used to store all the values in the listbox ito the access database.but it is not working.I didn't get any error.but the values in the listbox is not being stored in the database.The field in sample table that stores the value from listbox is a multivalue field.[code]...
View 2 RepliesI'm using VS 2010 professional and the basic programming language. I have an access database which is pretty simple. I have 1 table named Cards which have 4 feilds Question, Answer, Topic, and Source. I've got two other table which hold the lookup values for Topic and Source.On the Form I've got 2 bound listboxes for Topic and Source. I want to populate a third list box with the Question and Answer based on the records in table cards who's Topic and Source feilds match the selected items in the other 2 listboxes.
View 3 RepliesI've given up on my harder stuff and have simplified it to something else. There are no errors that pop up now but the list box doesn't populate! I took the code from a book and there's a data adapter, data connection, and data set on the form already (they're not named in this code though, since the book didn't say to). When the program opens, the list box has a line of text in it and the list box doesn't fill with the right items.
Private Sub EditStock_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
Dim dsitemlist As New DataSet
Dim itemlistadapter As New OleDbDataAdapter _
("SELECT ItemName FROM Stock", ConnectString)
[Code] .....
And here's what shows in the box.
system.data.dataviewmanagerlistitemtypedescriptor
Ive got my listbox which has a list of values from which I got from a database in microsoft access, like below
Apples
Bannanas
Oranges
[code].....
i'm trying to pull information out of my listbox and put them into a set of textboxes. I then want to be able to take the data from the textboxes and the labels i have and save it into my database.
Here is a screenshot of how the form looks
[URL]
I've been working on this for three days now and I can't seem to get my listbox to populate. I'm connecting to an sql database. Where am I going wrong? Dim cmd As New SqlCommand("SELECT DISTINCT natureport FROM rates ORDER BY natureport", conn)
[Code]...
Individually the Draw red and draw white work. The delays work.When in series the only color seen is the last color. Why? [code]
View 5 Replies