I'm rewriting a small application and I'm working on moving the data access logic from the form to a separate class. All was working will when I had all the code in the form. Lets say I had code similar to this in my form:
[Code]...
I've got a program where the insert/update SQL was created with the values coded directly into the SQL string. I've changed this to use the Command's Parameters.AddWithValue method and all worked well. I'm now in the process of separating the data access code out into it's own class. I've got the Select code working using a DataSet in the form that I pass ByRef to my data class so it can populate or refresh it. My sticking point is in how to pass the parameters for the Insert/Update commands to the class since from the form I no longer have access to a Command object. Do I need to make the Command object in the data access class available to the form?
View 6 RepliesI am trying to execute a command line EXE (busobj.exe) with required parameters through VB.Net. Because of unknown reason the report is not being generated. Here's the commandline:
Shell(txtBOExecutable.Text & _
" -user " & txtUserName.Text & _
" -pass " & txtPassword.Text & _
" -system " & txtDomain.Text & _
[code].....
I have a stored Procedure
CREATE PROCEDURE sp_DescriptionLookup
-- Add the parameters for the stored procedure here
@manfactureid as int
[Code].....
I've been creating short test apps repeatedly to try to understand some of the concepts in VB.NET.For the most part it has been illuminating.I read Bucky's .NET knowlegebase tutorial on passing objects as parameters to newly created forms. He shows how to create a new class that inherits from the base form class and define a New() method with parameters Extending the concept I thought about doing the same thing with a form that was created at design-time (In this case Form2).
[Code]...
I am running visual basic 2008 express. When I run the code that I have written it gives me the the following error message
- Incorrect syntax near '?'.
Does anyone know what causes this error. My code is as follows -
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.OleDb
[Codee].....
I have been working on this all day and still haven't had any luck at getting it to work. I am using the SqlDataReader Object to retrieve data. I am using the code below to send a value to the stored procedure.The problem is that the value is sent enclosed in quotes so I dont get any data back. I have tried using .text.replace("""","")
View 9 Repliesi am running a dos command. now i created checkboxes to add parameters to the command. [code] but it only gives me a 1 or 0 but i want the parameter -h, -t, -v when the checkbox is checeked.
View 10 RepliesI am passing some comma separated parameters to console Application. I want to split those string for that I have written below script but it is giving error .
static void Main(string[] args)
{
Console.WriteLine("Command Parameters :" + Environment.CommandLine);
[code].....
I am trying to setup a variable in VB, which will execute a shell command (autostatus.exe) with a parameter (-j JobName), and later display the output of the said variable. The code thus far is...
Dim JobName
Dim JobStatus
JobName = "asysr11_set_global_var_2day"
JobStatus = ShellExecute("autostatus.exe", -j, JobName)
What is the easiest way to achieve this? Currently, the above code returns error message "line:4, Type mismatch: 'ShellExecute', code: 800A000D"
as i need add the two commandline parameter on debug window.
/url=
one is okay
[code].....
I don't know where the extra character 'N' is coming from, there should only be one parameter coming from my SP which is the ID:
cmd1 = oStringConnection.SetCommand(sqlConnectMain, _
cmd1, "TestStoredProc", _
DBConnections.myType.cmdAsProc)
[code]....
When I ran the SQL Profiler, I found this:
exec TestStoredProc @StudentID=N'12345'
I'm currently creating a new process and then executing an executable from a specified location:
[Code]...
I use the following VB code to execute a scalar function on my sql server:
cmd.CommandText = "[STFRA].[dbo].MyScalarFunc"
cmd.Parameters.Add("@Fastener", SqlDbType.Int)
cmd.Parameters("@Fastener").Value = 4148
[code].....
I would like to create a console program in VB.net that would allow parameters. What i would like to do is in the code below add parameters so the webpart page can be created from the Run menu. e.g. C:.......MyProgram.exe "Design" --This would then create the Design webpart page.
I tried looking at the internet but was not very successfull.
Module Main
Public Sub Main(ByVal args As String())
Dim prj As String
[Code].....
I need to give an app 2 string values on startup via the command prompt like this
C:myapp.exe string1 string2
How do I accept these values?
how to send a procedure call to a Command Button.
What I would like to do is have one button be able to call any number of other sub routines when needed. In other words...the app is running and I need it to stop so the user can either read information presented...or make choices...then click the CONTINUE button to pick up where the app left off. However, I need this to happen many times across several forms and modules.
I know I can use a MessageBox and get the same effect..
Need a SQL Server "SQLClient" (VB) Data Layer Class?
View 2 RepliesCurrently working on a web-service with Oracle10g as back-end. Here is my problem.
1. The table I need to populate has 100 columns. I have no control over the design of the table.
2. I wanted to use the "deriveparameters" method of OracleCommandBuilder, but found out that this is "costly" in terms of performance. What I initially planned to do was to derive the parameters from an open connection, close the connection, then maybe cache the parameters obtained but I don't know if this is possible.
I am unsure how big of a hit the performance will get if I continue using the "deriveparameters" method WITHOUT caching the parameters driven. The environment is as follows
-intranet
-around 2000 users
-users spread out in different parts of the country
I am not familiar where they will put the web pages of the application, the web service and the database. I don't know if they'll be putting it in different servers or on one server, but that's something we cannot control too, that's why I am looking for the best approach.
I just don't want to hard-code all that parameters and if, for instance, we need to change some properties/parameters, it will be a pain to maintain the code. It would be nice if someone here can point a way to automate the whole thing w/o the performance of the system taking a hit.
I'm trying to create a program that will read in a custom file similar to a config/INI file and parse the data and store them into variables of a custom class. Essentially I want to be able to read in line by line, split the line by the space and then store the value into a class object's variable with the same name.
For example, I have a class called body.
Public Class body
Dim height As Double
Dim weight As Double
End Class
A friend in work suggested the use on classe to store the parameters BEFORE call a method. He's said this is called "Abstract Class". My "know how" of VB.NET is small... so, I want to know of you what mode is the best way: Call a function/sub like that:
[Code]...
Most of our code base is in VB.NET. I'm developing a project in C# that uses a lot of the assemblies from the VB.NET code.There are three relevant classes in VB.NET:
[Code]...
Im currently working on mendhak ADO.net tutorial and I keep getting this error when trying to add a new customer to the database.Load Event
[code]...
I am using a form which is having a listbox having a column of access table. When I select an item n press deleting it its working fine. But from the next time its showing an error "No value given for one or more required parameters".
Refer the ecode below:
Private Sub load_listbox()
Dim m_DataAdapter As OleDbDataAdapter
Dim m_DataSet As New DataSet()
Dim tbl_name As String = "Fld_detail_" & Datamaker.Application_Datamaker_ListBox.SelectedItem
m_DataAdapter = New OleDbDataAdapter("SELECT Start_loc FROM(" & tbl_name & ");",
[Code] .....
I am trying to returns records based on the last name of a customer in an access db. When I run the query in Access it works fine, the name in the examples returns 3 records with that last name. I use the same basic structure for other queries based on other fields (ID, UnitID etc) and they work fine.
[Code]...
How to add parameters to app.config file while during msi file installation. please look at the attachment.
View 12 Replieshave a web form using Asp.net 2.0 with vb.net. I have two date fields on the form but I would like to validate them before my gridview uses them as parameters. I am using a Dataset for the source of the gridview and two parameters called StartDate and EndDate.
Basically in the code I am setting the values of the fields to the current date at runtime. Also the date fields in the SQL Server table are datetime and I only want the user to have to enter the date and it would grab all records within that date range regardless of the time. When the user enters the two dates and clicks a button on the form I need it to reset the parameters to the enter dates and refresh the data.
Here is the
Partial Class DispatchRequestList
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[code]....
I have this code to update my SQL database from data in a textbox, in VB. I need to use parameters in case the text contains a tic mark ,', or a quote ,", etc.[code]...
View 2 Repliesim making a class.vb which has a sql connection. The class.vb will be used by all forms/windows on the application. So whenever a form needs to access the database, it will call class.vb.
This is the code in class.vb:
Public Sub Openconn()
Dim myConnection As SqlConnection
Dim connstring As String = "Data Source=192.162;Initial Catalog=db1;User Id=sa;Password=1;"
[code]....
but it gives error: value of type sqlconnection cannot converted to array of Sqlconnection.I just want a method that's useful for opening the connection and that is also useful when asigning to a command object.
At the moment I have the following Command class:
Public Class SubscribeCommand
Implements ICommand
Private ReadOnly _vm As MainWindowViewModel
Public Sub New(ByVal vm As MainWindowViewModel)
_vm = vm
End Sub
[Code]...
In a tutorial i read, you have to implement add {} and remove {} for the canExecuteChanged-Event. But how can i do that, with vb.net?
