am an computer engineering student, & these days engaged in a project, the front end tool is vb.net 2008 & the back end tool is oracle10g... am using windows xp as OS.... am not getting option of connecting oracle10g.. i guess, oracle10g is properly installed in my system... then so am not able connect it...
View 1 RepliesI have some stored procedures to execute that use dbms_output.put_line() to put data into the output buffer.I know I need to use dbms_output.get_line(:line, :status) to retrieve that output.I'm using ystem.Data.OracleClient to avoid headaches with Oracle deployment.So what am I doing wrong with the code below?
Dim cmdSproc As OracleCommand = cnOracle.CreateCommand()
Dim strOracle As New OracleString()
Dim opaLine As New OracleParameter("lineOut", OracleType.VarChar, 255)
[code]....
I am inserting a block of 5000 records at a time, one block right after the other. The commands are created in a seperate DLL and can call anyone of 4 different stored procedures. Is there a bulk insert method that might speed this up. Currrently it takes about 1.5 MS per record and would like to get this down to about .7 MS.
[Code]...
I really like the coding speed that vb.net provides, but I don't like the possibility to forget to declare variable types, return types of functions, etc. and that is why in each class I use[code]..
Is there a way to define those two options on the project/solution level?
the combo box style 1 has both the drop down option but also a manual entry option. I need to know how to code it so that when you manually enter data, it takes that data and places it in a text message "The shipping charges for "data" is $15" displaying in a text box. Shouldn't be hard but have developed a mind block.
View 4 Replieswhat does these two code means in vb.net: Option Explicit on Option strict on i think option explicit means the compiler is not going to do any kind of conversion and i need to do all of them by the code;also it becomes case sensitive i.e;
[Code]...
I want my console application to be able to do one function I have when you click one option on the windows context menu, and another function when you click another option.
View 3 RepliesHow can I get round this error: Option Strict On disallows implicit conversions from
[Code]...
1. I have read that keeping Option strict on and Option infer off is good practice and will insure your code is tight and properly written. I would like input regarding this, pro's and con's from those who are in the know.
2. Having said that, I have set Option strict on and Option infer off in an existing program I wrote (that was working perfectly mind you) with them off and on respectively. I went through and cleaned up all the errors on the 'need AS' and casting of variables, but one is leaving me a bit put out.[code]
I have also read where using My.Computer.System.Directory.GetFiles() instead of System.IO.Directory.GetFiles() is probably not a good thing, but when I change to this I get no error, but also no dataI am thinking I should stay with the strict on and infer off but am really slogging through getting this code correct.Running Win7 on Dual Quad Core XEON Intel Extreme with 8Gb RAM.
I am writing a text editor program and I have written the new, open, save as, exit menu items but I am struggling with writing the save option.Now I have created the menu itself (well vb did, I just used insert standard items) but how do I code up the save menu option so that it updates the current document or if the documnt has not yet been saved bring up the save file dialog.Here is the code I have so far
Public Class Main
Private Sub NewToolStripButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NewToolStripButton.Click, NewToolStripMenuItem.Click[code]....
I know I have some finishing touches such as messages and error handling and stuff but at the moment I want to get all the basics working,I think the save menu option is all I am struggling with at the moment.
Using VS2008, targetting framework 3.5, trying to update some VB4 code. Yes, VB4.I have a bunch of legacy code I'm trying to update, and I had the idea of trying to work through it by executing the old code, working out what was causing each error as I came to it, solving the problem, and then moving on.In order to do this, I have sinned and set Option Strict Off, Option Explicit Off and Option Infer On.Yes, I'm going to hell for this.Problem is, I'm still getthing errors that various things haven't been declared.All of these the items showing errors are in the form: itemName(obj)Is my problem that the compiler thinks that these are method calls for methods which haven't been declared?PS: For anyone wanting to tell me not to use these settings, I already know
View 2 RepliesI have to take over a project written in vb.net, which contains more than 400k lines of code written in option strict off mode. I want to build it under option strict on first before I do anything else -- which maybe converting it into C#. I found there's thousands of lines of code raises compilation error, mostly are about implicit type casts. Is there any tool would help to make it compile under option strict on mode if I don't want to correct every single line manually? Because it's really painful to add CStr/CInt invocation into every line of Code myself.
View 3 RepliesI turned Option Strict On and i get an error on all the ".Cells" lines saying option strict on disallows late binding.
a = 1
b = 3
c = 2
d = 1
With oSheet
[CODE]..................
[Code]...
I really prefer to keep Option Strict On. the proper way to do this?
I have inherited a VB.NET application that I need to compile so I can run dorkumentation on it. I first received "Option Strict On disallows implicit conversion from x to y" errors, so I turned off the Option Strict option in the Project file.
So why do I still fail with the same error message?
I have two comboboxes which are related to each other. When a make a choice in the first there are different choices possible in the second. So far so good. But is it possible to remember the second choice when i change the first? the program should select the the option in the second if possible or other select the first option.[code]
View 4 RepliesI am trying to figure out a way to connect 2 users within my VB.Net application.The goal would be to send strings/integers/booleans from one computer to another that could be translated on the other side. The effect being a multiplayer game, or a chat box or anything of the sorts.If I wanted to connect to a computer here in the office, I couldn't because I can only connect to the shared IP and not the local IP's...
View 7 RepliesI'm trying to write a method in VB.net so that when I click a button it queries the database and returns all the values which match a textbox which is located next to the button. I have no idea how to do this, I assume in the onclick method for the button I will need to pull in the value from the textbox, connect to the database and display the results to a gridview?
View 2 RepliesI have a database in the same workspace, I've tried to connect to this DB using this codes :
[Code]...
i have to do a hospital mangment system by VB.net and connec it with a DB and i do that by using Wizard ,the problme is that i dont know how i can validat the data thet the user will enter it and i don't know how to give each patient and staff member a uniqe ID and send it to the DB?
View 2 Repliestrying to connect to my access DB, run a query, and do something with the result set
View 2 RepliesI got vb.net 2008 express and sql server 2005 and 2008 express editions whic I downloaded from microsoft website.Now I just want to connect vb.net with sql server 20o5 or 2008.I am using a connection string as
PubConnstring = "Data Source=RAMANSQLEXPRESS;Database=FirmTest11;Trusted_Connection=Yes"
'Create your connection object
Dim objconnection As ADODB.Connection
Dim strSQL As String
[code]....
Getting Error : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
I am having a problem with my 64-bit Windows 7, where a program I am creating in class (well, a group of us are creating) will not run on my 64-bit Windows 7.I know that problem stems from the Microsoft Jet OleDb connector, and that it's only for 32-bit windows and does not work with my 64 bit (and is not even listed in the Data sources page of the admin tools in 7).So, what can I do to resolve this problem? is there any way for me to connect to the database?I know the connection string is on this line:
<connectionStrings>
<add name="PrioritySystem.My.MySettings.systemDatabaseConnection"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\UserData.mdb"
[code].....
I'm having problems connecting to a database. I have sql server 2005 express installed on my PC, and i am using the following to code to connect to it.
Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhostSQLExpress;Initial Catalog=northwnd;" & _
"Integrated Security=SSPI")
[code].....
I have to buttons that I'm trying to connect to. The names are: Search and Schedule. When I'm debbugging, and I try to click on one of the buttons to go to the form that I'm not on, it tweeks out. Here is the code I'm using:
System.Diagnostics.Process.Start("Schedule.vb")
&
System.Diagnostics.Process.Start("Search.vb")
The error that I get is this:
Quote:
The system cannot find the file specified and then it has tips on how to fix it, but none of them help. Am I just coding it wrong or what? I'm using VB 2010 Express.
Ok I'm finally getting to put on big boy pants and have now moved beyond doing everything in Access (yay me).o here is the problem, can't connect to the Server. created a test button on my form, which is what I usually do with Access so Ican be sure everything is where it needs to be pointing.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connetionString As String
[code]....
is it possible to connect to a database residing on a website (eg., MS Access)to get/update data.can we do it by a VB.net windows application.
View 9 RepliesDim objConn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;" & "Data Source=C:\popsCatering\popsCatering.db")
Dim objCmd As New OleDb.OleDbCommand("INSERT INTO personalInfo (Name) VALUES ('test')", objConn)
objConn.Open()
[code]....
when i try to debug i get this error:
OleDbException was unhandled Could not find file 'C:popsCateringpopsCatering.db'.
however i'm confident that the file exists and that the path is correct?
Dim con As New System.Data.SqlClient.SqlConnection
con.ConnectionString = "Server=iraq\sqlexpress ; Database=stats ; Trusted_Connection=True ;"
Dim com As New System.Data.SqlClient.SqlCommand
com.CommandText = "insert into users values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "')"
[Code]...
There are new events happen when i adjust the connection string
con.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=C:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesWebSite2App_Datastats.mdf;Integrated Security=True;User Instance=True"
show me error with com.ExecuteNonQuery()
I want to connect to IBM mainframe thru VB.net and run jobs present in mainframe directly through VB.net and view the output back.... how to connect to IBM mainframe and run jobs directly through vb.net....
View 1 Replies