here's what I'm doing. I'm putting together a program that will allow employees that work under me to all submit shift reports in the same format instead of getting multiple different formatted text files.
I have a list box that they add "actions" they've performed throughout the day. It's populated by a combo box and some text boxes.I've got it all functioning minus one aspect...
[Code]...
Here's my problem... it's only outputting the FIRST set of items. The "Upgraded" accounts all list but the "Downgraded" and "Canceled" are not there.In a perfect world, I wouldn't ever need to worry about "Canceled" or "Downgraded" but... the world isn't perfect so,
I've been having some trouble being able to pull the text from the monthly balance column and displaying in the textbox (remainbalancebox) beneath it, all I can make it do is display the text in the bottom left column, when all i really want displayed is the last text on the RIGHT column?
I know this is pretty simple but Im a little stuck. I need to take items from a listbox and print however many items are in that listbox to a receipt. So far I have
For i = 0 To lstselectedtoppings.items.count - 1 lblreceipt.text = lstselectedtoppings.items(i) Next i
I know this is pretty close to what I need , what am I missing though?
I am trying to pull wind direction, temperature and speed, data from this webpage, I have had not much success with it at all, I think that I have the correct method but get stuck on the HTML coding. the webpage is: [URL] I sort of know how to get to the HTML code, but get lost on how to define the ellements that are required. I have a screen capture of where I get up to.
This is in ASP.net iwth VB.I have a quiz project that I've been assigned for work.This quiz project contains two main SQL Databases it pulls the info from. First is a Quiz table, which contains three columns: QuizID (Pri Key), Title, Description. This is where I declare the quizzes, indicated by the QuizID (1, 2, 3....etc)
The second table is the Questions table, containing the following columns: QuestionsID (Pri Key), Title, Answer1, Answer2, Answer3, Answer4, Answer5, CorrectAnswer, QuestionOrder, QuizID....The QuizID in the Quesitons table matches the QuizID in the Quiz table.Thus for QuizID = 1, it consists of all the questions with the matching QuizID in the Questions table. The CorrectAnswer I want to assign a simple value (1, 2, 3...etc).I need a way to take a set of questions (based on the QuizID) put them in some sort of table and randomize them (or rather shuffle them) so that each time this quiz is taken, it pulls all questions randomly, but not repeating any)...I then want the code to pull the question and coorepsonding answers to pick from in a radiobuttonlist. However, It only needs to pull the number of answers. Example, a True/False will only have Answer1 and Answer2. The other Answers will have the NULL value in it.
There needs to then be a way to go through each one of these questions that have been placed in the table (in that random order) using a "next" button. When a question and possible answwers are displayed, I alaready have code to keep the answers in the session to grade it at the end (using correctAnswer and selected answer.I have no specific way to bind the data to the Database. I have used SQLDataSource to make other connections before, but I don't know if this is the best way.
I was wondering which way would be the easiest in VS2005 to connect to and pull data from a MS SQL database. I have already setup the database connection by choosing the datasource for a DataGridView but I'm not able to retreive any information.
The steps I have taken so far:
1. Make new form
2. Drag and drop DataGridView onto the form
3. Setup the data source and respective username password
I am trying to insert data into two lables from an access database(2 different tables) by doing a search. I have code that wont work
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click Dim SearchPatient As String = txtNPatientID.Text
I just got put on a new project to design an app that will retrieve data from an excel data sheet that holds information from our VoIP server's call log. Conveniently, this call log is stored in a fixed location on the local drive that this app will be running on. After working on this for a bit, I knew right away I'm going to need someone smarter than I am...I got to the point where I can show data but heres the issue : Every time I am retrieving the date it shows it as, "08/27/2009 12:00:00 AM", how do i remove the unrelated time stamp? Here is my code in Visual Basic 2008 Express Edition:
Public Class Form1 Dim cn As System.Data.OleDb.OleDbConnection Dim cmd As System.Data.OleDb.OleDbDataAdapter Dim ds As New System.Data.DataSet()
When it is installed on a machine, it will run for all users. But for some users, it is unable to get some data from the database. I have found out that if it is run-as either administrator,or in winxp compatibility mode, it works. But if not, then some users have the problem.The database is in the same C: drive location as the exe, and it doesn't change from user to user.The computer is using windows 7 professional 32-bit.
I am trying to pull sql data into a text file. The code works just fine, until some new data comes in from lazy employees and a couple fields (used for notes/comments) are now left blank. Originally I've never seen them blank so I didn't think anything of it. col2 = myreader.GetString(1) It will error if the field is ever null - I even tried using a case when: case when note is null then '" & empty & "' else note end and set the variable emtpy = '', but vb still thinks that it's null and errors?
I generate a print preview, the only thing is, if there is enough data to fill like 2-3 pages I don't know how to generate a new page. It only fills the first page and that's it....
Private Doc As New PrintDocument() Private Sub btnPrint_Click(sender As System.Object, e As System.EventArgs) Handles btnPrint.Click[code].....
most of the code it's just pulling data from database and printing necessary charges to the invoice, but if the invoice is more than 1 page then I don't know what to do because it only generates 1 page.
I am pulling three coloums of data from a SQL view into my data drid Day,TimeIn,TimeoutI want to colour my datagrid rows red if timeout is null and green if both the timein, timeout have data in them.[code]
I am building a VB.NET frontend to access an ACCDB backend built with Access 2007/2010. The backend will be on a share and accessed simultaneously by multiple users (5 max for the time being, maybe a dozen or more eventually?).My question is, what is the best way to pull the data for the fastest possible acquisition, manipulation, and updating? I'm thinking that pulling it in, then severing the connection and running all of my queries against in-memory structures would be best; am I wrong in this line of thinking?
Do the "DataRow" objects (e.g. "TicketsRow") maintain a connection to the database? I started in on building custom classes to store the data in memory which would pull from DataRows and then dispose of them, but wasn't sure if this was the best approach. My Access frontend was horrendously slow, which is part of the reason I migrated to .NET. I'm not convinced the app itself was the problem, but this solution should give me far more granular control over how the data is accessed and stored, besides the fact that VB.NET seems orders of magnitude more powerful than VBA.
Is it possible to select an item in one listbox and then display the data of another listbox with the same indexed position? I am planning a project and this is something I would like to attempt but I haven't figured out how to do it.[code..]
I tried doing the above code but instead of displaying the listbox text the message box just returned false.
I've pretty much just started in playing with Visual Basic Studio 2010 and have been using this site for lots of answers so thought I'd join up and harass more directlyI've been trying to move items between two lists, one is databound to a bindingsource, the other isn't. I found out that you can't really move items from databound lists, but you can remove from the datasource instead. This works fine until I want to move the item back - it fills a blank line with seemingly no data.
I have an Address Book project with a listbox. The listbox is bound to the database via the little arrow pop-up box in the corner of the listbox. I have the DisplayMember set to FirstName, and obviously only display the First Name of the contact in the ListBox. Is there an easy way to change it so that it displays the First and Last names? I can't change the binding because I need it to get the ID of the record selected.Here's the basis of my code...
Private Sub MainForm_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'CompanyDataSet.Contacts' table. You can move,
I have a listbox in my form that gets its values from a data table by data binding. My question is, when the data (row) is loaded it also selects the first line automatically. I do not want this because I want the listbox to select an item only when the user clicks on it. Otherwise, the iteme should ony be listed. Is there a way to manage this?
I have an application that receives data input from an automated set of devices. This data stream I have managed to capture & get it into a list box which I can sort based on the Device ID & the time that the response was received.There is a set time window for the devices to transmit their data into the application and during this each device is not limited to the number of responses it can send (ie :- Device 1 can send in 2 responses where Device 3 can send in 40 responses, etc).All of the responses are captured, listed & sorted within the listbox (this bit is working ).I now need to extract the last (ie:- latest) entry in the listbox for each Device ID & this is where I am stuck. I can retrieve the last item in the list but cant seem to extract the last item for each Device ID.[code]
Private Function currentv(ByVal version As String) As String Dim filePath As String filePath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) & ".minecraftin"
[Code]....
im trying to pull from the file located at: filepath & "rpgversion.txt"
and display it in the textbox2
as "0.5.3" for example
text which is located inside the .txt file rpgversion.txt
I also got as far as creating an XPath Query: (/main/SourceType/@ID) but for the life of me do not know what to do with it. Im trying to pull all source type ID's into an array of strings if it is possible!
I have a textbox where a user enters the time in minutes:seconds format. I want to take whatever number that is in front of the colon and store it in a variable called minutes, and whatever is after the colon and store it in a variable called seconds. I have everything declared and my code written, I just don't know how to take the text from a textbox and when the value is stored in my variable to only include up to the colon. I think it has to do something with the string remove method, and I can remove the colon, but I don't know how to get the characters after it. (and I can't use number of characters because I don't know how many the user will enter)
I currently have an unlimited amount of columns and rows in a DataGrid. Pendinginformation from a user I would like to display every row from the datagrid into a checkedListBox but I only want to show specific columns depending on their column Names. Currently my code will display every row. My problem is getting only the selected columns depending on the name of their header.
The code that I have currently is: For Each row As DataGridViewRow In CSVInput.DataGrid1.Rows If Not row.IsNewRow Then
I'm trying to learn a little about pulling information from other applications and finding it pretty difficult to find what it is I need to do. Let me give you an example of what I'm trying to do and perhaps someone can point me in the direction I need to work in.
I want to read Ventrilo from my VB application, specifically I want to know when someone is talking in the channel I am in. That is my end goal. I can pull the handle using FindWindow
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" _ (ByVal lpClassName As String, _ ByVal lpWindowName As String) As Long
Basically we're creating a multiform app for class with 3 different forms. its going to be a game. My startup form asks only for your name and your total units to play with. Then you're able to click a play button, which opens up a new form that will display your total units available (from the first form) and allow you to enter how much you wish to wager for that round.
I wish to know how to pull the info from my textbox (txtUnits) on the first form (frmWelcome) and have it show up in a label(lblCurrentGameStake) on my second form (frmMain).I thought about maybe putting the value in a string and then calling that on my second form but it doesn't work. Private Sub btnPlay_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPlay.Click strStake = txtUnits.Text