IDE :: How To Get SQL Server 08 To Work With Visual Basic 08
Dec 3, 2008
this is my first time here and im a little lost - so i'm hoping this is the right area to post this (I have used other forums before, but jumping in and out of various msdn area's makes figruing out a site map very differcult at first).
View 1 Replies
ADVERTISEMENT
Jun 18, 2011
how do I fix my button to run?
View 4 Replies
Feb 24, 2011
I'm doing a baseball program for a class project. And I almost have it complete, but it's giving me a syntax error. I can't figure out what i'm doing wrong. I'm using two functions to return a value for different type of baseball tickets to the button that calculates them. Here are the instructions 1.)User selects whether to purchase season tickets or single-game tickets 2.) User enters the number of tickets needed and the type of seats based on whether they selected season single-game tickets.3.) User clicks the Compute Ticket Cost Button to display final cost4.) User clicks the Clear Form button to clear the responseI just can't figure out what I did wrong. I know it's something stupid that i'm doing.the errors are happening inside the btnCompute sub routine. with syntax erros on SingleGameCost() and SeasonalCost() line 114 and 118
Public Class Form1
'Global Variables
Dim intTicketChoice As Integer
[code]...
View 2 Replies
Jun 23, 2010
I have a Visual Basic 2008 Express Edition application that operates as a front end for iSeries V6r1. The application was developed on a windows 7 machine. Users load the application from a shared folder on a server. Currently, there are 2 Vista, 3 windows 7 and 4 XP users. All had no problem in loading application, all users except 3 of 4 XP users can run the application with no problems. However, 3 of the XP users receive the following error message when they perform any action that tries to connect to the iSeries:
System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
All 4 XP users are on same service pack
View 8 Replies
Apr 8, 2010
using visual studio 2008 and programming in visual basic. i need to create a ftp server and am not sure where to start...i've tried to find anything that would help but all i come up with is the system.net.ftpwebrequest object but nothing really about how to use it. i need it to download files only, show connections, the ip addresses connected and the progess of the file transfer.
View 6 Replies
May 14, 2012
I am attempting to connect to Microsoft SQL Server 2008 R2 from within Microsoft Visual Studio 2010. My connection string is as follows:
connection = New SqlConnection("Server=localhost;Database=greenapplication;User ID=WindowsID;Password=WindowsPassword")
I keep getting this exception: System.Data.SqlClient.SqlException:Login failed for user 'WindowsID'.What am I doing wrong? Are there certain permissions that I have to set up?
View 2 Replies
Nov 24, 2009
I'm a beginner user of Microsoft Visual Studio 2008 and I want to ask what would be the initial code to connect a Visual Basic 2008 form to a SQL Server compact 3.5. I want to create an add new account program using the above applications.
View 1 Replies
Mar 4, 2010
I am looking into writing a web-based vehicle tracking system. The framework I have in mind looks something like this:
Client application --- Database --- Database updater.
Client application: This would query the database for information and then display this information on a map.
Database: holds vehicle information such as speed, location, payload etc.
Database update: This application would need to continually check for information received from vehicles and then add that to the database.
I am confident that with my current skill set and some research and learning, I could write the client application and interface it to a database. However, I am at a loss as to how to write the database updater. Presumably, this would be an application running continually on the server, waiting for information to be received from vehicles and updating the database. Is this something I can do with ASP.NET and Visual Basic? Or would this require a different way of thinking than writing web pages?
View 2 Replies
Nov 6, 2009
Would it be something like this
My.Computer.Network.DownloadFile("ftp://My.Site.com")
View 2 Replies
Mar 7, 2012
i want to add TimeOfDay (Time) in Table Record which datatype is use for add Time.i am created a field "JoinedTime" DataType "time(7)"[code] "Specified cast is not valid.Couldn't store <1/1/0001 3:35:42 PM> in JoinedTime Column. Expected type is TimeSpan"want store like "3:40:14 pm" How Can I do?
View 8 Replies
Mar 6, 2012
One of the client requirements is that the server generate files and store them on a special folder. This files created can not be modified by users or deleted.So the only way I thought is to generate this files with elevated privileges so a normal user can't delete or modify them.But the question is how can I generate a file with this privileges that normal users can interact with this files... only download from server.I use this code to generate the file... But I don't know how to configure it for elevated privileges.This is the button which generate the file and allow to download it:
Protected Sub ibtGenerar_OnClick(ByVal sender As Object, ByVal e As ImageClickEventArgs)
oArchivoTelecredito.NombreArchivo = txtNombreArchivo.Text
oArchivoTelecredito.SesionDetalleArchivosTelecredito = New List(Of
[code].....
View 1 Replies
Jul 7, 2009
i want to send mail through my exchange server 2003 using visual basic 6.0, can any one guide me through the process how i can do this, i am using windows XP at client end.
View 2 Replies
May 24, 2011
Visual Basic 2010 Express, lets the user to add a Local Database with .sdf extension. These databases needs MICROSOFT SQL Server to be created or they can run in the user's pc without any additional software? What are the limit of these databases unlike an external database?
View 2 Replies
Apr 18, 2010
Application based on Visual Basic 2008 and SQL Server 2005 using ODBC.
View 1 Replies
Aug 15, 2011
i am new with SQL server 2005 and visual studio 2008.how do i connect the forms and the tables in the database
View 4 Replies
Dec 29, 2007
I am a brand new user of MS Visual Basic 2005 Express and MS SQL Server 2005 Express. I have familiarized myself with both programs but have one extremely frustrating problem. Once I open SQL Server, I can not establish a database connection from Visual Basic using the Visual Basic Data Source Configuration Wizard (even if I close SQL Server). If I reboot and open Visual Basic first, I can then connect using the Visual Basic Data Source Configuration Wizard. But then I can not switch to SQL Server and open the database (even if I close Visual Basic). Again, I must reboot to open the database in SQL Server.I suspect there is a setting somewhere that needs to be changed, but I can not find it?
View 6 Replies
Jan 6, 2010
However I have hit a massive brick wall with my program. My program that I'm trying (can't emphasis this word the importance of that word) to create a Client/Server chatroom using TCPClient in Visual Basic. So far I can get my client to speak to my server. However, i'm trying to get the returned data to display in a listbox which never happened, i then tried a label, which again never happened then a text box which I'm sure you can figure out how that went! I'm not great at networking programmers nor am I not bad I'm terrible but duty calls when it comes to projects.
The code I currently have was mostly taken from the net but when I have the program fully work and I understand how the software works I intend to heavily modify for it to suit the needs of what I need to achieve. where I can get my client to display the data from the server that I have already sent to the server (which displays successfully within the server).
[Code].....
View 2 Replies
Nov 4, 2011
In my VB.net code i have:
cmd.CommandText = "SELECT * FROM [strfg].[dbo].[Myfunc] (@MyParam)"
Dim myparam As New SqlParameter("@MyParam", a)
cmd.Parameters.Add(myparam)
The function (runnig on SQL server) returns a table with four columns, one row.How do I call this function from Visual Basic? cmd.ExecuteScalar() is obviously not correct. In c++ I use a recordset. What is the equivalent in vb? Does anyone have a short example?
View 2 Replies
Feb 26, 2011
Iam developing a Windows application using Visual Basic 2008 with a SQL Server database. Throughout the program I give the user as many options as possible and have no problem with either the database or the windows forms. The program does not initially require a Login and I want toprovide the User with the opportunity to add a Login to the system. The default Login form is perfectly satisfactory.
The problem is that I can't figure out how to program the change sothat the Login from isopens the program rather then th form designated as the StartUp form. this forum I am able to prgrammatically change the form but I can't figure out how to make the requirement a permanent factor. I tried using a Constant, but if the User wants to change, you can't change the constant. Its an apparantly simple yes/no situation but if I set a varable to yes and then change it to no the next time the program runs, the change will be lost.
View 6 Replies
Jan 24, 2011
How do you extract source code from a VB.NET .EXE file?
View 3 Replies
Jun 1, 2012
I have a project where I added visually and successfully a datasource of MySql. I binded a datagridview with a table.
But, how do I change programatically the password, ip or user to connect with the MySql server? Because it can change at any time, so I can let the user change these values.
View 7 Replies
Jul 25, 2010
will SQL statements that work in Compact SQL Server also work in the Express Edition of SQL Server?
View 2 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
Aug 7, 2009
I am building a VB 2008 Express Edition application.I have built a database (with a single table) using SQL Server Compact 3.5 and have connected it to the project. I am able to view and edit the data using a DataGridView on a second form (tutorial made this very easy). I need to work with the data in the table within the application. how to easily load the entire table into an array or even read the table a row or cell at a time so that I can make all of the data available for manipulation within the application (the tutorials only seem to show how to display the data).
View 7 Replies
Jul 3, 2010
I need to write a paper on the comparison between (Microsoft Visual studio 2005 to develop web applications using asp.net) and (visual basic and Netbeans to develop j2ee applications using java).I need suggestions for good webpages,journals or documents which can help me out here. I have to write at least 1500 words so any suggestions are welcome.
View 1 Replies
Jan 17, 2011
In a while loop, I am writing a progressively increasing integer value (between 0 and 100) to the Value attribute of a ProgressBar control, when it disappears from the window in which it resides. I have verified at the time that it disappears that the Min is 0, Max is 100, and Value is a valid integer in range.
View 9 Replies
Aug 5, 2011
Does anybody know which version of Visual Studio 2010 contains the full set of Visual Basic SharePoint Templates? I am about to embark on a project to create Visual Web Parts to be used in a SharePoint report.
At the moment I am using Visual Studio 2008 and even though the WSPBuilder is installed none of the relevant SharePoint templates are present.Having searched SO and the web, most advise to install the templates via the Visual Studio command prompt: devenv /installvstemplates
Alas the Visual Studio command prompt is also missing from my VS2008 installation.So, the question remains: which version of VS2010 contains what I need for pain-free SharePoint development? There is a rather large price different between VS2010 Professional and VS2010 Premium, so can anyone tell me if the cheaper version (VS2010 Professional) contains all the Sharepoint templates?
View 3 Replies
Mar 20, 2009
How do I disable the background compiler for Visual Basic in Visual Studio 2008?
For my sins, I have to work on a large VB.NET project and it often locks up for 20 seconds at a time whilst doing the very helpful background compilation
I'd rather work blind between compiles and be able to do some work.
View 1 Replies
Nov 25, 2009
I am just wondering how I can add Direct X references to Visual Basic in Visual Studio 2010 Beta 2. I cant find them in the .NET reference list, or the reference list, or anywhere. I downloaded the Direct X SDK for August 2009, but I can not add the .dll files to the reference list. Is there anything I can do to add them? I need the references for programming reasons.
View 5 Replies
Jan 22, 2010
I am trying to make a console program in Visual Basic on Visual Studio 2008. I want to ask the user of the program if he wants the premium version or the standard version. If he chooses the premium version, then I want it to say premium in his "receipt" later on and if he chooses standard, then standard in the receipt.
[code]...
View 1 Replies