VB SQL Express Beginner Explanation Sought?
Aug 8, 2010
Dim conn As New SqlCeConnection, in the position marked **, it makes the program fall over on the cmd.prepare statement: requires an open and available connection
Public Class Form9
Dim compactStr As String
Dim conn As New SqlCeConnection
[code].....
View 3 Replies
ADVERTISEMENT
Aug 20, 2010
I just need a good nights sleep, but Im simply reading through a file (2010 data) and for selected teams, accessing the corresponding data for the previous year (2009 data), which is held on a separate file. (I painstakingly input all the 2009 data manually)
ds1.Clear()
cmd1.CommandText = "SELECT * FROM Teams WHERE Team = ?"
cmd1.Parameters.Add(NewSqlCeParameter("Team", (ds.Tables(0).Rows(x) ("Team"))))
cmd1.Prepare()
cmd1.ExecuteNonQuery()
[Code]...
View 8 Replies
Dec 25, 2009
While I reading a sample I found this code which I could not Find its functionPrivate Sub LoadList(ByVal lst As ListBox, ByVal typ As Type)lst.DataSource = System.Enum.GetNames(typ)End Sub Actually I understood that This code create a method to do some thing as I think to list some thing but what is DataSource and what isSystem.Enum.GetNames(typ) and I never created a method before with (ByVal 1st As ListBox, ByVal typ As Type)
View 2 Replies
Dec 2, 2010
How to add my explanation to auto finish in user classes or enum etc?
View 3 Replies
Mar 21, 2011
with the code
Marshal.GetLastWin32Error
I obtain a number.... but WHERE can I find an exhaustive textual explanation relative to the number?
View 1 Replies
Jul 22, 2010
I want to learn visual basic, what book or books are the best to take me from beginner to intermediate?Would it be more advantageous to go through VB 2008 or VB2010 tutorials first or should i start with a book before going through VB2008 or VB2010 tutorials?I am comfortable with Sequel (SQL) language, learned on the job and am at the advanced level of Excel/Access writing formulas functions,etc. the next logical step is to learn VB.
View 6 Replies
Oct 8, 2011
I am trying to create a program that calculates the prices of different payment methods of a buffet.The program requirements are simple. The buffet start in 1/7/2011 and ends 31/8/2011. Payments methods are online, cash and coupon. coupon is only valid from 1/8/2011 to 31/8/ 2011. 1 child is free for every 2 adult that pay. There are different prices for weekends (sat and sun) and different prices for weekdays. [code]
View 3 Replies
Mar 15, 2011
I am beginner in VB.net and want to learn socket programming suggest me some good articles to refer at beginner level
View 4 Replies
Sep 25, 2011
I'm trying to pick up some simple object-oriented programming skills so I am trying my hand at beginner's problem - and I am totally stuck...I'm trying to write a program that will print to a label, the area and perimeter of your shape of choice, dependent on the Length and Width (for Rectangles and Triangles) or Radius (For Circles) you input and the shape you select.
I know how to do this easily with simple event-driven programming, but I'm trying to do this by using classes and inheritance.The idea I have is that you enter in length/Radius and/or width into text boxes (txtLen, txtWid) and then you can click a button to display the Length, Width and Perimeter or Radius and Circumference, and Area.
I'd create a Super-Class: Shapes to define my overarching parameters - all shapes have area and perimeter. Then I would create sub-classes for each shape inheriting the overarching "Shapes" class - dim'ing all of their respective extra pieces. Then the buttons would display the appropriate info when clicked.I understand this seems like a lot - but really I just need help getting my feet on the ground for this.
View 4 Replies
Apr 13, 2010
I am working on Excel programming . Can you suggest the best publications for the beginner in Excel Programming.
Tasks Ahead:
To create a comboBox dynamically in Excel Worksheet Write events for comboBox_ change/click Dynamically changing the items in the combo Box
View 2 Replies
Jun 12, 2011
I have been working on this all weekend and can't figure out what I am doing wrong. The objective is to collect 3 numbers from the user then display to them the numbers they entered, the lowest number entered, the highest number entered, the total, and the average. Can someone review this and tell me what I am not getting?
[Code]
View 3 Replies
Apr 13, 2011
I do not know anything about SharePoint and we will be moving to SharePoint systems in a few months at work.
My manager told me I will be one of the developers developing systems based on SharePoint.
Is there any good video tutorials on SharePoint Development?
View 2 Replies
Mar 13, 2009
The program should request the person's occupation, the amount of the bill, and the percentage tip as input and pass this information to a Sub procedure to display the person and the tip. Title is gratuities, first line Person's occupation, amount of the bill:, Percentage tip: Compute Tip, and show the tip. Im not sure how to approach it properly.[code]
View 2 Replies
Aug 31, 2010
I need comprehensive tutorials of VB 2008 for beginner's which give additional support to my studies so that I can learn VB 2008 easily in less time.
View 2 Replies
Jan 13, 2010
I had this incredibly ambitious goal to make a video game and so I am teaching myself/relying on kindness and knowledge of others as I go along. So far I have learned a lot, however needless to say, this is a monstrously difficult challenge, however one that I am very passionate about completing. The idea is that I am making a trading card style game and I was hoping that I could continue to use this thread and your kindness to keep me going whenever nessecessary throughout this challenge.So, here is where I am now. (Please forgive me if i have posted too much details/not enough details. Since I am new, I am not sure what information you need to help me. This will be corrected as time goes by and I learn more)I have created a card class with two properties. name and picture with name As String, and picture as PictureBox. the constructor looks like this: [code]
My next goal(and where I am currently stuck) is making i so that when the user clicks on one of the items in the listbox, a picture of the appropriate card(saved in a pictureBox of its own on a different form, and referenced in the card via the picture element) will be placed inside the empty picture box on the deckPage.
View 7 Replies
Mar 31, 2009
Im using Visual Basic 2008.Okay I got all the design, and everything set up, even the hangman body parts coming on the screen and stuff. So my problem is creating the BLANKS, the underscores "_", and replacing them with a letter...
I was thinking creating Lables which i have no idea how to dynamically. Then giving each label name the letters they belong to, and everytime the user gets the rigth letter they get replaced.
View 3 Replies
Nov 27, 2009
I am having an issue getting my code to work. It is not showing my Look-Up Button for me to calculate the rate based on the weight and zone and it continues to constantly show that I have an error that I cannot seem to correct.
[Code]...
View 4 Replies
Jul 8, 2011
I have been looking for a good beginner tutorial on polymorphism, inhertance,and related terms.Something where I can start at and go through and get most of the common programming terms and techniques explained with examples
View 1 Replies
Sep 8, 2009
I'm beginner programmer in the amazing world named ".Net".I've a lot of questions
well, what I should learn C# or Vb.net What's the best blogs which talk about .Net technology and Open source projects Where can I find good tutorials, free books and ideas of projects how can I progress in ".Net" please, share your knowledge , your OPML of your favorite blogs or web sites about ".Net "
View 12 Replies
Apr 28, 2010
Student pursuing BSIT degree, employer expectations, entry level. I would like to solicit opinions from this forum as to what your professional expectations are as regards an entry level position in working in the database realm... I see many job opportunities that require a minimum of 2 or more years experience, how does one go about obtaining this experience (I have tried very hard to maintain a minimum 3.70+ GPA) but have ZERO work experience in this field... I spend non school time working in VB and SQL to try and increase my proficiency. I have considered postponing my job search until I obtain certifications from brainbench etc... Any criticism and or advise is welcomed... Again I have no experience in database other than undergrad work in class.
View 2 Replies
Aug 2, 2011
I am trying to create a program that the user enters the number of enrollments for 5 different campuses during two semesters. I just got started and here is what I have so far but when I run the program it is stuck in an infinite loop and will not go to the next function. I am not sure how to end the loop. Here is what I have so far:
Module Module1
Dim SIZE As Integer = 5
Dim campus() As String = {"Decatur Day", "Decatur Evening", "Huntsville Day", "Huntsville Evening", "Distance Learning"}
Dim semester() As String = {"Fall 2010 semester", "Spring 2011 semester"}
[Code] .....
View 10 Replies
Mar 18, 2009
I am just for learning purposes trying to develop a one player text based game.
I have a rich text box (GameWindow)
I have a text box (InputWindow)
I have a button (InputButton)
and a bunch of labels that aren't really important
I have two questions first is easy probably. How do i get InputWindow to respond to me hitting enter when text is in it?
[Code]...
But if i plan to have more that is only going to increase the size and code needed and im sure there is an easier way i just don't know how to do it.
View 1 Replies
Jan 22, 2011
i am new to asp.net and i was told that i need to know UML thoroughly to build successful software, is this correct? i mean cant i just "code and fix" and "model" in my brain. how important is UML and what is the best way to learn it?
View 3 Replies
Oct 19, 2011
I have a custom window form control contained within its own project that is referenced in the solution's main project. I am currently get an error stating: "Could not load type ... because format is invalid." The type in question is actually a structure. I get the general problem in that for some reason the struct can't be obtained from its assembly, but I don't quite understand what is meant by "format is invalid.". I originally had the solution running on a full Win XP machine before transferring to my Win7
View 1 Replies
Mar 7, 2010
I'm writing a program for my algebra students to practice integers.Stuff like....
3-6
-4 + (-5)
3(-4)
-15 � 3
etc.
I want to show an explanation and for the addition and subtraction, I want to show it on a number line. For example, if the problem is 3 - 7, the number line should show and arrow to that goes right to 3, and then left 7 units (starting from 3). Then the student can see that the answer is -4.I could probably do this with some string manipulation, but what would be the easiest way to do it in a picture format? Maybe a bitmap.
View 1 Replies
Jun 21, 2011
Im hearing about this, can someone explain it to me or please show some basic code of Lambda with explanation.
View 2 Replies
Oct 3, 2011
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]....
View 3 Replies
Oct 16, 2010
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.
View 3 Replies
Nov 1, 2011
Is it possible to connect to a database on SQL Server R2 Express from Visual Basic Express? I am following a set of tutorial videos done in SQL Server 2005, but cannot seem to connect to create the database. I have created the database in SQL Server R2 Express, but cannot connect. Is there a work around?
View 4 Replies
Feb 29, 2012
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 Replies