My problem is when I change computers, I have to change the drive letter the jump drive is located. Currently, I have the following code and have to comment out the connection to the letter drives I do not need to use.
' Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:Grad ProjectProject.mdb;")
' Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
I have been creating some asp.net sites that connect to an AS400 for data and I use a SQLDataSource for this with the following connection string (changed for security reasons). Now I need to create a winform application in VB.NET and am wondering how I would do this? I have only used MSSQL in winforms and use the sqldatareader for Select statements and execute non-query for others. I need to call some stored procedures on the AS400 passing parameters. I was hoping to do this by code like I do with MSSQL rather than drop in controls to bind to.
xml <?xml version="1.0" standalone="yes"?> <Data>[code].....
Now the problem is, B1Text (which is a string) is not either receiving the value or holding it, but B1Vis is getting the value just fine, and its right below the other one.
How do I assign a My.Settings.Item connection string to cmd.Connection connection string value?
Dim cmd As New SqlCommand() cmd.Connection = My.Settings.Item("csStaffHoursWorked") cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = "spSaveDeltekImport"
I got this Error Message while I try to preview the records in Dataset Designer:"The connection string could not be found or Data provider associated with the connection string could not be loaded"
so as to open an MySQL connection how can i have a procedure to open a connection to an MySQL server duly passing my connection variable name in to my procedure as a parameter like some thing the fallowing one is not opening the connection
I understand the possibilities for encrypting a connection string in .net v4. I have a win forms application that will be used by multiple people on different machines. I understand that I need to protect the connection string at time of the app being first run on the target machine. However I am concerned that for a period of time my connection string will be unencrypted. I am looking for advice in how to deploy my app with the connection string already encrypted or encrypted during installation. encrypting the connection string in a secure way?
I'm developing an app in vb.net (visual studio 2008). I have a Teradata back-end that will be supporting multiple users in a production environment. I need to use variables in the connection string as the user/pass will be changed every 3 months.
For the gist of the application:
In it's most basic form - I have a search form which works correctly - it pulls results into a listbox and the user then double clicks the list box which will then open a form that is bound via table adapter to the back-end table (Teradata). My connection string is fine everywhere in the application. My problem is using a modified connection string for the "fill" function of the table adapter once the form is opened.
I'm using the code below for the on-load event and keep getting an "invalid connection string" - again, the connection string works fine everywhere else in the app, and the variables etc... are working correctly.
Private Sub adaptertest_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim DBConnStr As String = "Provider=TDOLEDB;Data Source=TDDEV;Persist Security
I'm facing a problem after installation any software setup that has a database in access(mdb file) How to I transfer file path in our connection string.
I am trying to connect DSN from my VB 2008 project. When i try using myoledb.connectionstring="DSN=myDNSname" I get the following error message An OLEDB provider was not specified in the connectionstring.
Why doesn't an exception get thrown when this function is called when there is no ConnectionString set for the Connection? I just spent 15 minutes debugging and staring at it and finally figured out it needed the connection string. Shouldn't an exception get thrown?
Friend Function GetValues(ByVal TableName As String, ByVal FieldName As String) As DataTable Dim cn As New SqlConnection Dim cmd As New SqlCommand[code].....
Trying to convert XML file to string and pass to stored procedure. Dim fs As FileStream = File.Open(fileUpload1.PostedFile.FileName, FileMode.Open, FileAccess.Read) Dim buffer(fs.Length) As Byte fs.Read(buffer, 0, fs.Length - 1) txtRawXML.Text = System.Text.ASCIIEncoding.ASCII.GetString(buffer)
When I tried to upload file I got error. The error description is 'A name contained an invalid character.'. Could not find prepared statement with handle 0. Could not find prepared statement with handle 0. sp_xml_removedocument: The value supplied for parameter number 1 is invalid. The statement has been terminated.
I have a stored procedure in DBML and I try to pass the result to "sqlQryArray" as an array(1 dimensional array). But the bottom code causes error like below message. What else should be done?
Error 1 Value of type '1-dimensional array of aaaDatabase.stp_GetSomethingResult' cannot be converted to '1-dimensional array of String' because 'aaaDatabase.stp_GetSomethingResult' is not derived from 'String'.
The return result from stored procedure is a just list of first names of students(only one column)
Dim sqlQry = aaaLINQ.stp_GetSomething(bbb,ccc,ddd) Dim sqlQryArray As String() = sqlQry.ToArray()
In a nutshell, I am selecting values from a checked box column in a grid view. After checking the boxes I have a function that concatenates each customer number into a string called @CusList to use a parameter for a stored procedure Public Function SelectCusList()
Dim CusShow As String Dim CusStr As String Dim CusList As String CusStr = ""
I have a application which is on timesheet. I have total of 54 columns out of which 10 columns are visible rest invisibleFirst 3 columns are Project, MileStone and Classes. Rest are Sun- Sat work hrs, TaskId, TaskDesc and so on for each day. On my grid only first 3 columns and Sun - Sat work hrs are visible, rest are invisible.These Columns from Sun - Sat do not exists in database. They are identified on the basis of date and displayed on the grid. They exists as row in database but displayed as column over the grid.
Now I have columns named SunTaskID,MonTaskID and so on till SatTaskID for holding each days taskid[TaskID is the PK of the table from which data is pulled out. And each has its own task id.] Now on the selection of SunHrs (Sunday's Work Hrs), i retrieve that days taskid and on the basis of task id i then retrieve attachments which is displayed under a listbox.Now the problem is that since a day can have multiple attachments and a user can attach multiple attachments at time. I am not able to hold the attachments.
I'm trying to do here is get VB to hold a key down until I tell it to stop. Perhaps I'm missing something but I don't understand why this isn't working. This code can hold down shift and so on for as long as I want it too but absolutely refuses to hold down what i need it too (any letter key or numpad key)[code]
In my project I am using a LINQ to SQL class that contains a stored procedure which includes a string value as an output parameter.So to capture that, I created a string variable as follows in the procedure:Dim spOutput As String? However, when I do this I get the following message "Type 'String' must be a value type or a type argument constrained to 'Structure' in order to be used with 'Nullable' or nullable modifier '?'"
I am trying to create a procedure which will evaluate a string expression as if it were a line of code...Kind of like what a graphing calculator does when you enter a formula. Does anyone have any experience with this in VB? I have an example of C++ code which uses CodeDom, but I am a bit rusty with my C++!
I've been working on my Pacman-ish game, and I want to have a high score table be available to be seen on the main options screen. Therefore, I need to save score information, and be able to separate it into a table, specifically 3 columns (Name, Orbs Collected and Time Alive). [code]However, I have no idea where to start with the high scores table.
I am creating a game and when dice have been rolled I want the user to be able to hold certain dice.I have changed the design of the dice from labels to button controls, because whichever dice the user wants to hold thet can simply click on the relevent dice button, I used this code for holding the dice button.
I am using VS 2008, VB and using a dorpdown listbox in my asp.net webpage. I select a value from the dropdown, click the submit button, when the page comes back from the server, the value in the dropdown is blank (default). The dropdown controls viewstate is enabled.
I seem to have a problem in finding a solution to threads.I am opening a .PDF file via an <iframe> using vb.net. Then the file is opened, it is then moved to another location. But for some reason I am unable to move the file because it "The process cannot access the file because it is being used by another process." The only way round it i have found is to kill the process for Adobe Acrobat, so the file is released. Even if i fill the iframe with something else.How would I close the file, and stop that particular file from being accessed before the move ?
I'm using a KeyPress event in a VB form to move a game character around with keys. There are obstacles being moved every timer tick event. But if the player holds one of the movement keys down, the objects moving on timer ticks stop moving.
I have a button that searches through a binary file to bring up customer information with the following code:
[Code]...
My problem is, I need to create a variable which holds the record number, so that the record can be edited, and put back into the file at its previous location, how would I implement this? Not sure about the code.
I am currently writing a program that takes a joystick input, and simulates key presses (hold) in the active window (a game). This should be used for a virtual H-Shifter, like the one in a car, to change gears.[code]...