I'm getting this warning in my Output window (which doesn't affect functionality but I don't really understand it:
Warning: 0 : Use Procedure Bodies is now obsolete.Use Check Parameters instead
I'm using MySql.Data 6.3.7.0?
I wanted to know how to encrypt data.And I've found a solution at this web site.This script works if I use it as a function.Nonetheless, Visual Studio throws a warning that says the following.[code]Visual Studio underlines the second line after the equal symbol above.I have no idea what that means.Does anybody have any idea how I can resolve this warning?
View 6 RepliesI have the following Sub Routine in my vb.net project which runs fine, but I constantly get build warnings:
'Public Overridable Sub RegisterClientScriptBlock(key As String, script
As String)' is obsolete: 'The recommended alternative is
ClientScript.RegisterClientScriptBlock(Type type, string key, string
[code].....
Is it possible to prevent compiler warning caused by a static factory method returning an instance of an obsolete class? For example if an instance of an obsolete class (Foo) is created through a static method (Create) a compiler warning is caused by the factory method.
<Obsolete()> _
Public Class Foo
Public Shared Function Create() As Foo
[code]....
In C# the warning could be suppressed using "#pragma warning..." but I don't think that this exists within VB.Net. Migrating to C# is not an option due to business requirements.
Is it possible to prevent compiler warning caused by a static factory method returning an instance of an obsolete class? For example if an instance of an obsolete class (Foo) is created through a static method (Create) a compiler warning is caused by the factory method.
<Obsolete()> _
Public Class Foo
Public Shared Function Create() As Foo
[code]....
In C# the warning could be suppressed using "#pragma warning..." but I don't think that this exists within VB.Net. Migrating to C# is not an option due to business requirements.
I am trying to create a DisplayAverage sub procedure that accepts 3 integer numbers as parameters. This procedure should find the average of these 3 numbers and display the numbers along with their average in the list box.
Private Sub btnAverage_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAverage.Click
Dim a As Integer = CInt(txtone.Text)
Dim b As Integer = CInt(txtTwo.Text)[code].....
I am still quite new to different ways to connect to different in the SQL and Access, i am trying to connect to a StoredProcedure in SQL and pass parameters to append to it. There is a similar program already been built for us which does a similar thing but it is done in VB6 and i am trying to upgrade everything to .NET and this will be the last bit.Here is a snippet of the VB6 as there are a lot of Parameters that need to be passed but once i know how to add a couple it'll be the same for the rest:
View 1 RepliesI need to update a table with values from a listbox. I am trying to create as many parameters as there are items in the list, my code below, but how do i name them differently? so that they dont' overwrite each other?
For Each item As ListItem In ris
Dim pID As New SqlParameter("@userid", SqlDbType.Int)
pID.Value = objFormat.CheckSQL(item.Value)
[Code]....
and on the SQL side, is it possible to write an update statement, that will take a dynamic number of parameters?
so for example, i need to update multiple users with the same value in the "active" field...
Switching from Microsofts Oracle Driver to ODP.NET version 10.2.0.100. After changing the data types to OracleDBTypes in a procedure, that worked perficetly using System.Data.OracleClient, the procedure fails if we try and pass in more that 20 parameters. The error returned is:
[Code]...
i have a stored procedure to update a table. not all fields are required and some can be blank.
for example, title is not required, but when it's blank i get an error
Dim ptitle As New SqlParameter("@title", SqlDbType.NVarChar, 20)
ptitle.Value = objFormat.CheckSQL(title)
myCommand.Parameters.Add(ptitle)
ex {"Procedure or Function 'sp_UpdateUser' expects parameter '@title', which was not supplied."} System.Exception
how can i fix it so that it allows for nulls if the data field is blank?
This code calls a store procedure that takes input parameters. With this code I'm confused as to how the parameters are passed to the stored procedure. The parameters are first stored into 2 string variables (strCategoryName & strOrderYear). They are then copied/moved to an sql parameter prm.value. But the stored is stored in an sqlcommand (cmd ). I can't understand how the stored procedures knows what the parameter values are.
Private Sub btnWithParameters2_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles btnWithParameters2.Click
Dim cnn As SqlClient.SqlConnection = _
New SqlClient.SqlConnection("Data Source=SKYROCKET;" & _
"Initial Catalog=Northwind;Integrated Security=SSPI")
[Code] ......
Im trying to pass parameters to a stored procedure in SQL but for some reason its storing the parameter(s) in the columns....
My code
Public Function AddRec(ByVal textbox1 As String, ByVal textbox2 As String, ByVal textbox3 As String, ByRef Creation As Date)
'Adding a new Record to SQL
Dim Conn As New SqlConnection
[code]....
the addwithvalue all the textbox`s have a value in which i would expect but for some reason when i go to db in SQL it actually shows the @Username,@Account,@Password,@DatCreated not the values im passing in please see the attached image.
I am confused about how to pass parameters to a stored procedure. The stored procedure is written in sql server 2005 and the code is in vb.net.
I have included the sub that I am working on. I know that my use of parameters is wrong.
Public Sub AddRecipe()
Using myDBconnection As New SqlConnection(setConnstring)
Using SQLcmd As New SqlCommand()
[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 am building a three tierd app, and therefore have all my data access methods in a class by itself.This class only calls stored procedures, basically, I need to pass in the following:
1) stored procedure name as string
2) parameters as IDataParameter() -- an array of parameters
3) other fields ( not important to this discussion)
If I use a GridView on my web form and choose an ObjectDataSourceObjectDataSource, and then choose my business object and method, since the method is a call to a stored procedure with a parameter array, I don't know how to pass it values in the IDataParameter format.The Method Signature listed on the wizard is "RunSP(String spname, IDataParameter[] params), returns SqlDataReader" which basically is calling a method called RunSP with two parameters, of which the second parameter is a parameter array for a stored proc.
I have created a database with on table that is very similar in setup to ProductCostHistory from the Adventureworks database. Using the adventureworks database as an example, when the procedure is given the parameters of date and productID it will change the EndDate of the currently active cost to the date value and insert a new record with productID as the ProductID and Date as the StartDate, leaving EndDate null for the newly inserted record. I am looking for a way to create a simple form with two textboxes and a button. textbox1 accepts the ProductID parameter and textbox2 accepts the Date value. when the button is pressed, the stored procedure is executed and the table is updated. This seems pretty simple and I am very familiar with tieing stored procedures to a table in a dataset when each prcedure handles only a single simple action (either, SELECT, INSERT, UPDATE, or DELETE but not a single procedure that combines UPDATE and INSERT as the procedure described above does). I've done some reading and played with this on myown but can not find the simplest straightforward way of accomplishing this seemingly simple task.
View 2 RepliesI use codes below to inserts values to database by executing stored procedure.
Dim connstring As String = "dsn=test"
Dim oConn As Odbc.OdbcConnection = New Odbc.OdbcConnection(connstring)
Dim com As New Odbc.OdbcCommand("{? = call sp_test1(?,?,?,?)}", oConn)
[Code]...
1. A dataset contaning all the tables, views and stored procedures from a db in the Data Sources
2. A stored procedure that makes a query using a parameter
3. 2 comboboxes with their DataSources defined
The first combobox gets populated with a stored procedure (with no params, through the Combobox task). When the user selects an item from this combobox this should trigger an event that populates the second combobox with the second stored procedure that requires a parameter.
Since the Dataset is already add to the Data Sources and contains all the procedures I need, I don't wanna to create more datasets or calls to the data base, however I don't know how to set the query using the procedure I already have passing the parameter.
I have a stored Procedure
CREATE PROCEDURE sp_DescriptionLookup
-- Add the parameters for the stored procedure here
@manfactureid as int
[Code].....
I am developing a complicated search form, and I would like to know best method of passing search criteria to stored procedures.Possible options that I know are, 1) Create sql statements in Visual Basic and send statements to SP as strings to execute2) Pass search fields to stored procedure and build command in SP (Stored procedure) in database?
View 9 RepliesFaxDocument.Bodies is an object. I understand it should look something like Fax1.txt;Fax2.txt;Fax3.txt So is that not a string of Filepaths seperated by ';'. When I tried ... FaxDocument.Bodies = strBodies it gave me this ... Com Exception The operation identifier is not valid. (Exception from HRESULT: 0x800710DD)
I have also forced the strBodies to be type object and that doesn't work also
I have a stored procedure that takes in 2 parameters and returns an integer value. I would like this value to be the value for a gauge chart on the page. The 2 parameters will change depending on the attributes of the selected item. Is there a simple way to pass the one value from the stored procedure to the chart to display? This will be embedded in an asp.net application (vb) - so depending on the previously selected item, the values for the parameters and result will change.
View 1 RepliesI'm refactoring VB.NET code where methods routinely run five hundred lines and the references are so tightly coupled that the code defies simple refactoring such as method extraction. And that's why I thought I would try regions within a method body. I just wanted to organize the code for the short term. But the IDE didn't let me (resulted in a compiler error.) I'm just curious as to why? Seems like code regions shouldn't impact the compiler, intellisense etc. Am I missing something? (Still using VS 2005 btw.)
Interesting: This seems to be language specific. It's OK in C# (I didn't check that initially) but not in VB.NET.
public module MyModule
Sub RunSnippet()
dim a as A = new A (Int32.MaxValue )
[code]....
that gets a compiler error but the C# version is ok.
typeof(Nullable<>)
public static bool IsNullableType(Type t)
{
return t.IsGenericType && t.GetGenericTypeDefinition() == typeof(Nullable<>);
}
I was using this to check whether Lamda Expressioin parameters are nullable.
Just have a quick question really, I am just making a simple application that allows me to check if a user exists in SQL here's my code
Public Function Check(ByVal textbox1, ByVal textbox2) As String
Dim comm As New SqlCommand
Dim conn As New SqlConnection
Dim Adap As New SqlDataAdapter
[Code] .....
And when it comes to the Comm line I get this error
Operator '&' is not defined for string "Select * from Login where Userna" and type 'TextBox'.
I've tried removing the "&" and well i cant figure it out.
I have a stored procedure that has a if statement in it. This if statement checks a count select. If it's greater than 0, it selects a set of data, if it's 0 then it selects a different set of data. The problem I have is in the vb code, I have been trying to check a value to see if it's there. If it is, then I add the value to a couple labels, otherwise I don't Here is the vb I have commented it so you can see what I mean.
Try
Dim lrd As SqlDataReader = selectCommand.ExecuteReader()
While lrd.Read()
[code].....
Let's say I have a MySql stored procedure that inserts a record with some nullable CHAR fields. In VB.NET if I don't check for Nothing (or Null in other languages), I get an exception from the db driver, so I write:
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("_name", if(name Is Nothing, "", name)).Direction = ParameterDirection.Input;
And this is the first thing I don't like; I'd like to pass Nothing and the driver knows it has to put NULL in the Db. But then, in the stored procedure, I have to check back the field if it is empty:
INSERT INTO mytable
(name, -- other 200 char fields)
VALUES
(NULLIF(_name, ''),
-- other 200 char fields
)
I have to check for nothingness/emptiness twice. Is there a better, more direct, way? Even worse, for non reference types (i.e: Integers) the check for nothingness makes no sense, since a primitive type can't be nothing (yes, I could set an Integer to a non meaningful value, say -1 for a positive id, but...).
I defined a procedure in splash screen to check application trial time, but now it is still working after deleting the procedure from splash screen form. I am not able to understand why and from where it is working.
View 4 RepliesCheck if park_id already exist in table calendar by stored procedure? [code]...
View 2 RepliesI have VB.Net code in VS 2008 using an obsolete method, and would like to suppress the warning.Unfortunately, following the recommendation is not a good solution, because it requires using a different class, which works differently, in important ways.I'm trying to suppress the warning using System.Diagnostics.CodeAnalysis.SuppressMessage, but I don't know what to write as the parameters for the attribute, and can't find any relevant reference.
I should also say that, right-clicking on the error in the error list I don't have any 'Suppress Message' option.