I'm using VB Express 2008 with Access 2007 as a database. My problem is getting an average from the database with a query and copying that into my labels. I have a query for every one of the attributes that i want an average for (10 queries). the layout of my database looks like this:
[Code]...
I have a text file that the first part of my program writes data to, but for this second section, I need to read that file and use pieces of that data and average them out. The text file is setup up with 90 lines of data starting with the first 9 lines containing data and the 10th is a blank space. I need to read line 6, 8, and 9. I need to Loop through the file so I am using the Do While Loop. Where I am confused is when using the For...Next Loop to tell the program to read a specific line. If you have any info that can lead me to the answer that would be great. I would prefer you just point me in the right direction because I would very much like to somewhat figure it out in the process.
View 2 RepliesI want to include an average in a column where the average ignores zero values in a report cell where the column may have
17
19
0
[code].....
I want 16, not 11 so (17 + 19 + 12 + 13 + 19) / 5 not (17 + 19 + 0 + 0 + 12 + 13 + 19) / 7 Something like this if it would work.
=SUM(Fields!fieldname.Value) / Count(iif(Fields!count_cycle_per_hour.Value >= 0,Fields!fieldname.Value,0))
Essentially just average everything in the column NOT a zero?
I'm working on a function to return a exponential average and there are a lot of examples of exponential moving averages but they all start with a moving average that is just the mean as a lead in to calculating the continuing moving average. I needed just a exponential average of a value set. After Googling my Bing off I still haven't seen anything so here is my attempt at a basic exponential average. Is this correct? Are there any errors? I have seen some text about adding a smoothing value to change the curve of the exponential average but not how that would be implemented.
[Code]...
I put comments on the average output since I kept getting error messages about that. My out keeps saying:
Maximum value: 33
Minimum value: 33
what am I doing wrong?
Option Explicit On
Option Strict On
[Code]...
I'm in a computer science class, and we are writing simple programs using Visual Basic 2008. I am really inept when it comes to this, as I have never done it before. I need to write a program that: "Asks the user for 5 numbers and computes the average. It then displays the average with an appropriate message before the average."
I have been really close with this, but I can't get the numbers to add up, then divide by 5, and display a pop up message.
trying to give an average of an array in VB MVS2008. I tried using a sample code online but the averages it gives me are completely off. If I enter three ages (20) it gives me an average of 0.6, instead of 20. Here's the code:
Spoiler
Public Class Form1
Dim Names(100) As String
Dim Ages(100) As Integer
[code]....
how I can implement my calendar with VB .net express 2008 and MSSQL 2008 Express. How do I get it to work with datasets, binding source etc.If I go to Properties>settings my connection string is:
Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|CalendarDatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True
and I have a table with fields:-
CalendarID
Subject
Location
Purpose
[code]....
I can Add the event to the calendar I have the necessary items on my form linked to my table and I can save them to my table:
Me.Validate()
Me.CalendarTableBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.CalendarDatabaseDataSet)
But I cant keep the event displayed on my calendar when I close it and open it again.
I'm just using the default SQL Server Express in my vb 2008 express edition as my database server for my database operation. When I tried to update the records on my table I got a runtime error which indicates the error on this line 'myCommand.ExecuteNonQuery()'and it highlights a yellow background on it. The runtime error says "SqlException was unhandled: An expression of non-boolean type specified in a context where a condition is expected, near 'Number'. ".
Imports System.Data.SqlClient
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim myConnection As New SqlConnection
Dim myCommand As New SqlCommand
[code]....
I tried to start using VB 2010 Express with a program I originally developed with VB 2005 Express that I moved to VB 2008 Express successfully a couple years ago. It uses a database file (*.mdf) that is on the computer ( not out on a server). When attempt to run the program in debug mode, I get the following error "An attempt to attach an auto-named database for file C:Documents and SettingsTomMy DocumentsQuizzing StuffQuestion Database 2010QuizQuest ionGameQuizQuestionGameinReleaseQuizQuestionDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I first made a copy of the entire project folder that was working in VB 2008 Express and gave it a different name. In VB2010 I opened the project in the copied folder and it said it successfully converted the project. I am able to open the Data Source inthe Designer and see the database structure as I expect. I think the project is still using SQL Server 2005 Express (because it is what is checked in the list of prerequisites on the Publish tab).
Note, I have programmed off and on for many years, but fairly new to using databases and SQL Server.
Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 1 RepliesI am trying to re write a VB6 program using MS Access, many years ago, using VB 2010 express and SQL server 2008 R2 Express. I have a database with several tables, which I created using the designer. I am able to connect to the database and select data and display it in textboxes etc in vb code. What I have not been able to in code is to INSERT rows DELETE rows or UPDATE any data in the tables. I can do any of these operations using the Query Designer, but I want to do it in code. I can post some code if necessiary, but I thought it might just be some property that I had not set in the designer.
[Code]...
there Dream in Code Community! Im an okay programmer as far as skill right now I am still learning as we all are I need some help from some experienced VB.NET programmers in the community, Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords.
[Code]...
The program I am trying to modify was initially written using VB 2005 Express. I have subsequently downloaded the 2008 version. The program creates a monthly spreadsheet from a template. The old code that will no longer (highlighted and underlined) compile is as follows:
[Code]...
i want to know the code for an average of numbers from 1 to a number entered?
View 31 RepliesI'm trying to calculate the average hours worked from a set of data imported from a text file using streamreader. My problem is counting the number of entries and the total hours worked imported from a text file within a loop[.
[Code]...
I'm using VB 2008 Express for our College Project. I'm also running SQL Server 2008 Express and have installed SQL Server Management Studio and used it to create my database. Both software have been installed and running locally. I'm trying to connect to the database from VB 2008 Express. Database connection wizard have 3 options:
connecting to Access db
connecting to SQL Server 3.5 compact db and
connecting to SQL Server db file.
[code].....
I have SQL 2008 Express and Visual Basic 2008 Express runing on XP Professional SP2. When I select add new data source from VB I don't have the option to connect to SQL Server 2008 express to get at the to SQL Server Database. I also notice that the OLE DB connector is not availble as a data connector. Can somebody please confirm that VB 2008 Express can connect directly to SQL Server 2008 Express and how I can achieve it.
View 5 Replies'm trying to use Visual Basic 2008 Express and connect to a DB of SQL Server 2008 Express but ... you can tell me why in the Database Explorer and the Data menu of VB only have the following options for data source? Microsoft Access Database File Microsoft SQL Server Compact 3.5 Microsoft SQL Server Database File does not have the options Microsoft ODBC Data Source Microsoft SQL Server obs.: I have the Visual Web Express 2008 installed, and there are the options available.
View 10 Replieshaving problems with my code it is showing wrong values on the shortest , longest and average sentence the values are not corresponding with my sentences.I need help this my code:
[Code]...
I need to create an console application that computes the average monthly rainfall, number of months with above average rainfall, and the number of months with below average rainfall, given the rainfall amounts for each month in a particular year. The program must read in and store in an array the monthly rainfall amounts entered by the user one by one.
So far this is what I have got
Const intMonths As Integer = 11 'Constant Month variable
Dim sngRainfall(intMonths) As Single 'Rain for the month
Dim intCount As Integer ' Loop Counter
Dim sngTotalRainfall, sngAvgRainfall As Single 'Total and Average Rainfall
[Code] .....
How to set this up properly and I am having a real hard time figuring out how to make the data go from this loop to another and add the data to the total.
Need code for 10.12 on page 217 it's based on toutorial 10, been looking at it to long and can't figure out how to make it work.
View 2 RepliesI am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 3 RepliesI need a start date, a Total time passed until now, an average time per step, and a estimated time to finished. How can I do that? Also, I can close the application and when start up again I want to get the time counters as the last time, so How can I store that data is normal txt file (I say txt to take advantage of the ini app file which is a txt).
View 1 RepliesWhere in Visual Basic 2008 Express Edition Software program do you specify a specific installation directory for a program?
c:Program Filesfinished program
I want to publish my program to try it out on another system and I want to ensure its installed in the directory structure I want.
I recently created a very simple project in VB express 2008 to interface with a COM object from an external vendor. I then downloaded the VS2008 90 day trial and found that the identical code in a VS2008 project results in a COMException error "Object is out of scope". Is anyone aware of any differences in how the two packages handle COM object interfaces as I have run out of ideas. Both projects have identical code and all the references are the same. The CreateObject() method correctly creates the object, but any attempt to access methods inside the COM object result in that error. I can even open the VB 2008 Express project inside VS and it still generates the same error.
Here is the code - the vendor dll in question is from Siebel v8.0.0, you'll notice that I have commented out most of the code that comes after the error. Creating a watch in the debugger on the siebApp variable sees it correctly created as {System.__ComObject}type SiebelHTMLApplication. I first tried this by creating the Property Service for variable siebSvcs, but after I started experiencing the COMExceptions, I reverted to using the most basic method inside the COM object I was creating.
Imports
SIEBELHTMLLib
Public
[code]......
using Vb Net 2008 with SQL Express 2008 R2 in windows forms. that being said, I have a syntax problem in this form, form has 2 texbox an a datagridview and also the 4 components DataSet. BindingSource. TableAdapter, BindingNavigator. When I filter by LastName no problem it work fine (it's a String) but when I try to filter by CustomerID (it's alphanumeric) I get an error "Invalid character" here is part of my code: Private Sub surnameFilterTextBox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles surnameFilterTextBox.TextChanged
[Code]...
I recently installed vb express 2008 and with that download i also installed Sql server 2008. Earlier i have been working in MS Access so i have no experience in SQL server. My first problem is how to start sql server. I can see only following:
Start>All Programmes>MS SQL server 2008>Configuration Tools, Import and Export Data(32 bit)>SQL server configuration Manager,SQL server Error and Usage Reporting,SQL server Installation Centre. Moreover in Programme Files i have two folders:
1. MS SQL SERVER and
2. MS SQL SERVER COMPACT EDITION
how to start to create a database in SQL server with Vb express 2008.
registration code for vb 2008 express edition.
View 2 RepliesI am using VB 2008 express and SQL Server 2008 express on a test basis and I used to connect VB express to a SQL database (created in SQL Server 2008 Express management studio) file and it work perfectly until my hard drive packed up and I had to get a new one, so I had to reinstall both of these again and copied my old databases from a backup I had. Now when I try to connect to the database file it cannot connect. Network related error or the instance name is incorrect. When I look at the advanced options in the connect dialog it shows my instance as .SQLExpress and my correct instance name is .SQL2008Express. I clicked OK on the connect dialog and manually changed my connection string to the correct instance and that worked but whenever I run the application in debug mode it give me the same error as above.
View 1 Replies
