What is the preferred method of adding the current date/time into an SQL Server table with INSERT Command and executenonquery? I'm expecting something like ...
cmd.Parameters.Add("@theDate", SqlDbType.VarChar, 20)
cmd.Parameters("@theDate").Value = "getdate()"
SQL - DateAdd(dd, - day(getdate()),getdate())
need to convert this into VB.net
I have a database in sql server 2005 named as Addressbook and table Persons with PersonID as PK.I have created 4 textbox on form for FirstName, LastName, Address, CityID and an ADD button. When I input data to text boxes and press F5 then it show some error message. I hv tried eerything but failed.My code is as following and error messae is (The SqlParameterCollection only accepts non-null SqlParameter type objects, not Boolean objects.)[code]
View 1 Repliesi have to insert more than 200k records in sqlserver DB.
My idea is to add the data into DATA TABLE then doing Bulk Insert, but my TL said: "insert the data into CSV file format and do the bulk insert".
Public Sub cleanTables(ByVal prOKDel As Short)
Dim sqlParams(1) As SqlParameter
Dim sqlProcName As String
[code]....
and finally datatable dt = dbConn.Execute(CommandType.StoredProcedure, sqlProcName, sqlParams)
I am working in a project where i have to add employees in a company. I have a form with text fields(for example name,surname,age,...). What i want is to insert this txt values into a database. My project is connected with an sql database. How can i add the values into a data table on button click("submit")?
View 9 RepliesHow can i call sqlserver 2008 user define function in vb.net?
View 1 Repliesis there a way to get the GET parameters and POST parameters in just one function or Collection in ASP.NET? Like using $_REQUEST in PHP? I'm using VB.NET.
View 3 RepliesI'm currently working with a client's VB.Net code, which was developed for them by a small development shop a few years ago and which they purchased and have been maintaining and uprgrading since. This client's primary developer is out on indefinite (likely permanent) medical leave and I'm now filling in until they bring in a full timer (as I'm a contractor here). My current task is to add some functionality to a the VB.Net code they purchased. I'm finding practices and techniques in the code that absolutely baffle me and can't make the code do what I want. I'm starting to wonder if it's me and was hoping to get some thoughts on the code I've encountered.
For example: Setting a variable to accept the result of a function by calling the function with many parameters, clearing the parameters in the function, setting them to some value, calling another function with those new values, then never using the values returned by the functions. I'll add a code snippet in the first comment since this is already getting long.
The result will be '2010' for this query select year(getdate())
How do I get same result as Linq?select year(dateadd(yy,-1,getdate())), year(getdate()),
I am using vb.net 2005. I am trying to select data from a table where the field [hoteldate] is 2 days from now. The field's format is MM/dd/YYYY and when I use the Where clause :WHERE HOTELDATE = DATEADD([DAY], 2, GETDATE()) it returns nothing. I am assuming it's because the getdate() function returns something like 2012-24-02 T blah blah. How do I convert so I can get a match? I've tried several things including converting do a
View 4 RepliesI'm learning about VB.Net and need to work with an SQLite database using the open-source System.Data.SQLite ADO.Net solution.The examples I found in the HOWTO section are only in C#. Would someone have a simple example in VB.Net that I could study to understand how to use transactions when INSERTing multiple parameters?[code]
View 2 RepliesFor the last couple of days I've been having problems inserting data into my MySQL database. I'm using parameters to insert the data and have done so in the past without any problems, but for some reason I haven't been able to get it to work this time.I have a form that the user inputs data to be inserted into the database. This data is then pushed into an array and sent to my class (CastProduction.VB) via a Public Sub. The data than pushed into a datarow and than pushed into a datatable. Once this is done I send the dataset and sql insert statement to a private sub that inserts the data into the database.
[Code]...
I have run into a problem. When I insert some data into a table with the Insert Function, I want it to return to me Id key.Say a table is like this
ProductId
Product
Quantaty
If I run
Code
Insert Into [table](Product, Quantaty)Values(Cd, 3)
I want it to return to me the value of the ProductId so that I can use it, is this possible?
I have been posting almost 4 questions now where I have received 2 answers being solved. These are simple questions which any one familar with VB.Net can solve easily. Please understand, I'm a newbie to VB.Net.
Now my next issue is; I have a a form which has text boxes from where the user has to enter the data for the MS Access backend. I am getting the error as INSERT SYNTAX Error when entering the data and clicking the Save button. What is wrong with my insert statemnet below which is at the click even of the Save button?I desperately need to get this application working.
[Code]...
i want to get all available midi device by name. i found this: Declare Function midiOutGetID Lib "winmm.dll" (ByVal hMidiOUT As Integer, ByRef DeviceName As String) As Integer
but: how do i get these informations now?
where the VS debugger refuses to show certain field types including dates.My call stack contains FunctionA which calls FunctionB. FunctionB has about 45 parameters and many of them are dates.When I step into functionA,
1. the debugger refuses to show a date variable when you hold the mouse over it. It just shows {Date} instead of a value
2. If you do quick watch on that same variable, it also just shows {Date} instead of a value
3. If I do ?variablename in the immediate window, I get "System Error &H80131c23&"
When I comment out the call to functionB, the date variables all show correctly in all the above methods. I will stress that the code has not yet reached functionB, just its very existence in code screws up the debugger.I'm thinking this is a memory issue and maybe vs debugger can't cope with a huge function stack frame dataspace.devenv is only using 268Meg of ram on a 2Meg box, with not much else running. Thats reasonable for this size of project.
I use this code to invoke a function from a string, which I build in my application:
Public Class Form1
Dim f As New Foo
Dim methodName As String
Dim result As Object
[code]....
is there a way to return two parameters with function ?something like
Private Function blah() as string
Dim hl as String = "Hello"
dim tr as String = "There"
[code]....
I'm writing a VB.NET function with a ton of overloads. I've seen that most .NET functions have parameter descriptions in IntelliSense. For example, when typing in String.Compare(, IntelliSense says Compares two specified System.String objects and returns... you get the idea. This description changes and you click through different overloaded versions of the same functions. When you start typing in something for a parameter, it describes the parameter you're currently inputting as well. Example: strA: The first string to compare..
View 5 RepliesI have to create a program that finds the total cost for pizza, fries, and soft drinks, and places that in a list box. So far, though, I'm stuck. I have this code so far:
Public
Class frmBill
Private
Sub btnTotal_Click(ByVal
sender As System.Object,
[Code] .....
The errors that I am getting are:
"Argument not specified for parameter 'D' of Public Function totalBill(P As Double, F As Double, D As Double)
"Argument not specified for parameter 'F' of Public Function totalBill(P As Double, F As Double, D As Double)
"Argument not specified for parameter 'P' of Public Function totalBill(P As Double, F As Double, D As Double)"
Dim oList as new Hashtable
oList.Add("1","Value1")
How can I create a a function to return my objects like the above one.
[code].....
i have a function that i can't tell how many parameters i need to pass into it (could be anywhere between 0-10+), how do i handle this ?
View 7 Repliesi am using XML as database, so updating or inserting diffrent XML's currently i am manage a seprate class for seprate XML file, this process consuming my lot of time, i want to create a genrelize class. currently according to the XML need i am sending two, three, four or five parameter in my function.
now i want to send array of the parameter to my function, so becoz of this thing i could mange all of my functions via a single class...
i am sending u the example what currently i use now...
Public Function Update(ByVal Item_ID As Long, ByVal ProductName As String, ByVal Price As Long, ByVal Path As String) As Long
Try
[Code].....
Can we pass parameters to a function using delegates
Private Sub UpdateLabel(byval text as string)
If Me.Label1.InvokeRequired Then
Me.Label1.Invoke(New MethodInvoker(AddressOf UpdateLabel))
Else
Label1.Text = text
[Code]...
I need to convert the following C# code to VB.NET:
public bool TryGetRewriteMatch(UrlContext url, out RedirectMatch match)
{
// NOTE: Normally this would use regular expression matches, cached database
[Code].....
However, I need to reference Url and ProductID in the function and I don't know how to pass them as parameters or get their values from the original function.
I am interacting with VB code on a different tier, using a client-side c# program. The VB function signature looks like this:
Public Sub toggleExclusion( _
ByVal mouse As Double, _
ByVal study As Integer, _
[Code]....
I get an error saying no overloaded method of toggleExclusion takes 2 arguments?
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'
Public Function manyarrays(ByVal ParamArray ints() As Integer,ByVal strs() As String) End Function But it is error . How can i fix it ?
View 3 RepliesSuppose I have a function that accepts a string as parameter. But the parameter has a limited number of values (i.e. I've defined the function to work with only say, four exact strings). What I want is that when the user types the name of the function and starts the parentheses, the intellisense will show up giving the values that are defined in the function. Its just like a function that accepts a boolean parameter. The intellisense shows up giving the two values "True" and "False" when using the function.
View 2 Replies
