I have a problem with something I have done many times but this time it just doesn't work. This is what I am trying to do (in Visual Studio 2003 and VB.NET). Earlier in the [Code]
View 1 Replies
I keep getting a strange error message when I try to call my stored procedure. Possibly I have a syntax error? Not my store procedure does not return a value. Also the error message is included at the end of this post.
--VB .NET Code
Dim connString As String = ConfigurationManager.ConnectionStrings("EMRConnectionString").ConnectionString
Dim conn As New SqlConnection(connString)
' Create a new sql command, and reference the stored procedure by name
[code]....
I got this error message:An OleDbParameter with ParameterName 'p.Fornavn' is not contained by this OleDbParameterCollection.The line that is marked with yellow is:
Me.OleDbCommand1.Parameters("p.Fornavn").Value =
SELECT l.ID, l.Etg, l.Rom, l.Lokasjon, l.tilkoblingID, p.ID AS Expr1, p.Fornavn, p.Etternavn, p.Epost, p.Tlf, p.lokasjonID, t.ID AS Expr2, t.port, t.Modul,
[code]....
I have a web application running written on ASP .Net.We have a class accessing the back end written in VB .net which has shared functions for DB interactions.The above error comes up when ever two users are in the same page... tying to do the same thing.Couldn't find a reason why this would happen.The scope of the SQL command is limited and parameters are cleared at the end.
View 2 RepliesI'm getting the following error message in my vB code when I run the program:An OleDbParameter with ParameterName '@EarliestOrderDate' is not contained by this OleDbParameterCollection.[code].....
View 1 RepliesI'm using SharpZipLib to compress files. The library is wrapped in a plugin interface, in a separate DLL. I pass the plugin dll a ByRef parameter to keep track of the compression progress.SharpZipLib, while compressing, will periodically call a delegate sub passed when launching the compression. I can't figure out how to update the ByRef parameter when the delegate is called. If I try to assign the ByRef variable in the body of a lamba expression, I get a 'ByRef' parameter '<parametername>' cannot be used in a lambda expression error.
[code]...
In one of our application the parameters passed to a stored procedure in this way
Dim parm As New SqlParameter("searchText", SqlDbType.VarChar)
parm.Direction = ParameterDirection.Input
parm.Size = 50
parm.Value="test"
cmd.Parameters.Add(parm)
and the procedure contains a parameter as @searchText
ie the parameter name passed from the code is searchText and that in the stored procedure is @searchText .
But it is working properly, i am always getting the required results.
So my question is like so there is no need to specify @ before the parameter? Whether it will append @
I know to define integer type sqlparameter but I do not know the decimal type sqlparameter for the precession.
I am giving a sample example.
//Code
Dim sqlparameters(2) as sqlparameter
sqlparameters(0)=new sqlparameter ("@RMID", SqlDbtype.integer,7)
but in case of decimal I am giving like this
sqlparameters(1)=new sqlparameter ("@RMID", SqlDbtype.decimal,7,2)
which is wrong
I have a class, LogRequest, which contains parameters (members) for an object.This object is turned to an sql query using another class, DataAccess.And lastly, I have the class Search which run the sql query.[code]...
View 2 RepliesI am experiementing with table updates and the code below gives me the following error message: "The variable named "@Processed" has already been declared... at the following code line: clsWTAdapter.Update("clsWTDataTable"). I fear that all of my code is a general mess, and I am sure there is a much better way to go about it.
Dim clsCmd As New SqlClient.SqlCommand
Dim clsCMAdapter = New SqlClient.SqlDataAdapter("SELECT * FROM CatalogMaster WHERE Processed <>-1", clsCnn)
Dim clsCMDataTable = New DataTable("CatalogMaster")
[code]....
I'm a beginner in VB.NET programming.. Please help me on how to pass SQLParameters in the below function..
This my code:
[Code]...
It has been way to long since I have been involved in VB so I need some help here. I have the following in my C# code
[Code]...
I'm changing old, vulnerable SqlCommands with SqlParameters but get a SqlException: System.Data.SqlClient.SqlException {"Conversion failed when converting datetime from character string."}
on sqlCommand.ExecuteScalar:
Dim sqlString As String = _
"SELECT TOP 1 " & _
"fiSL " & _
"FROM " & _
[Code]...
I created stored procedure in sql server 2000 that's it
CODE:
In vb.net 2005 how to pass date and time of dateandtimepicker without to make sqlparameter
I'd like to make it like vb6
CODE:
I tried to make the same way in vb.net with different ways but i failed to do it.
I am developing a VB.NET application with SQL Server 2008 and I get the above error when I try to run this ASPX file. What is the cause?
[Code]...
In newer editions of .Net I can pass -1 for the output size for VarChar(Max) columns, but in Visual Studio 2003 I get the following System.ArgumentException: Invalid parameter Size value '-1'. The value must be greater than or equal to 0. What should I specify as the size for a VarChar(Max) column in Visual Studio 2003?
View 1 RepliesI am getting this error, Not sure why it is happening "Error The SqlParameterCollection only accepts non-null SqlParameter type objects, not Int32 objects."I have tried with all sorts of possibilties, now try to enter default data as dummy data,
Using connection As New SqlConnection
connection.ConnectionString = ConfigurationManager.ConnectionStrings("DentalDeviceConnectionString").ConnectionString
connection.Open()[code].....
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Using conn As New SqlConnection("Database=Clinic_Management_System;Data Source=.SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|Clinic Management System.mdf")
Dim cmdRecord As SqlCommand
[code]....
I want succeed in having a file contained in my executable. This means that I must be able to copy it alone on any folder in the local system.I can upload it somewhere and then make my VB program do download it, but what if the user is online ? And I want it to be only one exe.
View 14 RepliesI want to extract text which has no tag.
The HTML looks something like like this[code]...
I am thinking I can read it into a string and then search for the parts in the <a> and <strong> tags but don't know how to write it.
I am developing a software using vb.net.
In one case I have this output : Developing Area Number Declaration (DAND)
Suppose that one has a panel an inside it there are many buttons with Dock=Top. The button would tend to be stacked on top of the panel. How can I get a reference for each button from top to bottom? The button would be created in a random order, so I don't think that using the index of each button in the Controls collection of the Panel would suffix.
View 4 RepliesI have created a usercontrol that contains two rectangle shapes to create a unique button effect and a rounded-corner rectangle shape serving as a border to provide a look similar to a group box. It also contains two labels, one for use with a Text property of the control and the other to indicate the status of expansion of the control. The control is designed to collapse itself when the "button" is clicked leaving only the "button" visible. Clicking it again toggles this affect. I've dubbed it an ExpansionBar. It is also designed to be a container control so that I can add controls to it and allow these to disappear when the bottom portion collapses. This seems to work great! The problem is that the controls contained in this usercontrol cannot be accessed during runtime. In other words, I can add a checkbox to it and it will disappear correctly when the control collapses, but I can't select the checkbox to check it... same thing with any other controls, you can see, but can't touch.
View 2 RepliesI'm trying to delete all the worksheets contained in a workbook using the code below but I get this error:
"Attempting to call into managed code without transitioning out first. Do not attempt to run managed code inside low-level native extensibility points, such as the vectored exception handler, since doing so can cause corruption and data loss."
For Each obj In xlWorkBook.Worksheets
xlWorkBook.Worksheets(obj.Name).delete()
Next
I tried to do this a different way yesterday and it told me I couldn't have a workbook with no worksheets. Is this written in stone or can it be done?
dim l as List(of MyClass) = new List(of MyClass) and I want to get the type of the objects contained in the list, how do I do that? The obvious answer, that doesn't seem to be possible from my actual implementation, would be to do something like this...
public function GetType(byval AList as IList(of GenericType)) as System.Type
dim lResult as system.type = nothing
if AList.Count > 0 then lResult = AList(0).GetType
return lResult
end function
But what if the list is empty and I still want to know the type it contains?
I am having some real issues with this one. I have a class which contains two other objects...but I cannot seem to instantiate those sub objects. Here is the code for my class:
Code:
Option Explicit On
Public Class Boot
[code]......
How do I easily navigate textboxes contained within a form.My form has a lot of textboxes so I don't particularly want to make a KeyDown event for each.I think I need to group the controls and handle it that way somehow with their TabIndex.I'm lost without the control array of VB6 and can't find anything to show me how to do it.
View 8 RepliesI keep getting the error " Object reference not set to an instance of an object." in relation to the line : selA = CType(lstStudents.Items(r.Index), String)
[Code]...
I am using vb express 2008. how i can print the data contained in Listview.
View 2 RepliesI have a form like this
And its code :
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If TextBox1.Text.Contains(" ") Then
[Code].....
Now what code should I use when I click the button, if TextBox1 contains 2 SPACE characters, it will split into 3 parts, but if it contains only one SPACE, it'll split into 2 parts ?