I'm attempting to pass in a collection of dates to a T-SQL 'IN' clause via a date array (see below for how data is collated).
'Workout weeks difference between start and enddate
Dim wksDifference As Integer = CType(DateDiff(DateInterval.WeekOfYear, bookingStartDate, bookingEndDate), Integer)
[code].....
what are the changes I need to for my DAL to support this.
View 1 RepliesI am working with some code that uses array lists and I am using some of these to pass data back and forth like this: whatFile = (sideLookUp(x)) and its working, BUT when I turn this code into a sub/function then I call it I get problems, like double to string errors, even though its all set to double.
[Code]...
I am wondering if datatype can be passed as a parameter in a function..
for example..
Private Function CreateDT(ByVal myDT As DataTable, ByVal myColName As String As DataTable
(
myDT.Columns.Add(myColName, GetType(myColDataType))
)
I am getting error when debugging a project. The error is as below,
"FormatException was unhandled
String was not recognized as a valid DateTime."
Highlighting the following line
[code]...
I want to pass a date as parameter in vb to query the data from the table.If I hardcore the value in the query it works fine for me, but if I pass it as parameter to query, like I am getting the data from edit text and trying to send that as a parameter, this does not work.
SELECT *
FROM VehicleAnalogParamDownload2
WHERE Vapd2_Date between 'From_date.Text' And 'To_Date.Text'
Jst recently i came across the select() method of data table and felli n love with it instantaneously.
Basically I want query the data table on a date field, unfortunately the format of the date string returned from y database in to data-table and the date string i'm passing as inputs are different.
How can i make sure that the data is compared irrespective of the formats ? Can I use something like SqlParameters whoes data type is date for comparison ??
this is what i'm tying :
dim dat as date = "#1/3/2009#"
dt.select("StzDate ='" & dat "'")
entry in datateable dt : StzDate : 3/1/2009 12:00:000
Am I do'in something wrong ??
Also, can anyone redirect me to some site where I can learn a bit more about passing parameters to the select statement,etc...
I'm wondering if this sort of thing is possible in VB.NET.. say I have a routine which accepts an integer array, defined as:
Sub WriteTable(iRows As Integer, arrColumns As Integer())
The arrColumns parameter is an integer array of column widths.
I can pass a value by doing this:
[code]....
From what I understand, when you use AddHandler you're not actually calling a Sub, so you can't pass a parameter. I'm confused on what to do though about this. I've just populated a DataGridView and added a button to it in the codebehind. I'm then using an AddHandler to add a click event to the button. So when I get to the click event, I need to be able to access to the datagridview because clicking the button takes data from the datagridview and loads it into excel. What would I do about this. This is my Method where DataGridView was just populated
Dim btn As New Button
btn.Name = dgv.ToString()
btn.Location = New Point(0, 0)
[code]....
have a subroutine which parameter is an array like below:
Private Sub DoubleArrayValues(ByVal arr() As Integer)
Double the values.
[code].....
I have this in VB6
Private Sub LoadDaysOfMonth(pintWhatMonth As Integer, pctrlWhatControl As Control)
Dim NumOfDays As Integer
Dim i As Integer
Select Case pintWhatMonth
[code]....
Originally Posted by Error
'items' is not a member of Systems.Windows.Forms.Control
It works just fine if I use pctrlListBox As ListBox or if I use pctrlCombo As ComboBox, but I need to be able to use both with the same routine.
(PS: Yes, I do have a leap year check in here which I took out as it is not germine to my translation problem.)
(PPS: Using a control such as the monthview or datepicker is not an option.)
i am working on visual stdio 2008(vb.net) and sql server 2008 i working on crystal report 9 i have created a stored procedure in sql server i have add this procedure in crystal report data expert now i just want to pass a parameter to crystal report so that it will show me data in crystal report?
View 2 RepliesTitle pretty much says it all. How do I format the date of a dateandtimepicker to insert it into the SQL date datatype?
View 20 RepliesI created a User Defined Function with VB.NET and want to use that function in SQLServer. Everything seems to work fine. Now I want to use an array as parameter. Example of my test method (without parameters):
Partial Public Class UserDefinedFunctions
<Microsoft.SqlServer.Server.SqlFunction()> _
Public Shared Function TestFunction() As SqlString
[code]....
i'm not 100% sure about sql server but i think it doesn't accept null value for date type columns but in oracle, a date column can accept a null value. and since i'm using oracle, this is causing some problems because in my form, a textbox item bound to a date column will not accept a null value. reading thru some threads, it would seem that it is not possible to pass a null value to a date type in .Net.
[Code]...
How can I use BigInt datatype of sql server in my vb.net code?
View 10 RepliesI have an Sql server 2005 table called Emploeefl with 2 fields, EmployeeCode and Date of Birth. The data type for the date of birth is Datetime. I have a Date time picker on a vb.net 2005 form called dtDateOfbirth. When I click on the save button I get the error message "Conversion from string 'yyyy/MM/dd' is not valid. Below is the code
Dim newQE_Date As Date
newQE_Date = Format(Me.dtDateOfBirth.ToString, "yyyy/MM/dd")
'newQE_Date = String.Format("2008/09/10", "yyyy/MM/dd")
[Code]....
In my VB.NET project I wanted to run a JAR file in a separate thread. Now the question : Is it possible to pass parameters to a JAR file during run time from VB.NET??
View 1 RepliesI'm having trouble passing an array of a user defined type to an procedure in a COM DLL. The prototype for the procedure i'm using is this:
HRESULT STDMETHODCALLTYPE GetData(
/* [in] */ DWORD dwCount,
/* [size_is][out][in] */ CSimData *puData) = 0;
CSimData is a structure which is also defined in the interface.
I'm trying to call it with the following code but am getting an exception:
Dim temp(1) As MACHPLANTSIM18Lib.CSimData
temp(0) = New MACHPLANTSIM18Lib.CSimData
temp(1) = New MACHPLANTSIM18Lib.CSimData
[code]....
The exception i'm getting is "COMException was unhandled - Exception from HRESULT: 0xC0000005" It looks to me that the array isn't passing properly to the COM function. I'm able to send a single object, but when I do an array of objects I get this exception.
I have populated an array.
Button1 click event
Dim array1 (3,3) as string
array1 (3,3) = "BLA"
End Event
Now, in the same class, I have another button.
When I click on this button2, i want to use this array to stream files to textfile.
The problem is that I cannot pass data from button1 click event to button2, as I have to declare the array again, and that causes array to lose data on button2 click.
If I however, declare array on top of class, I get a funny error sying out of index range etc.
I have a Dialog Box that creates a Link Label for each item in a list.When one of those LinkLabels is clicked the DialogBox raises a LinkClicked event.Before, I was using code like this in the Form that was instantiating the Dialog:[code]But I don't like that for several reasons.What I want to do, and what I thought would be straight forward, was to pass the AddressOf the UserClicked PoLink Method into the ShowClickableLinksDialog Constructor and do an AddHandler within the constructor and also assign the Delegate to a Property on the Dialog so as to RemoveHandler when the Dialog is Disposed.[code]But I get a squiggly on the tempLinkClickedEventHandler after the AddressOf Operator saying: "AddressOf operand must be the name of a method (without parenthesis)"I don't get it.I've played around with a number of permutations and can't get what I feel ought to work, to work.
View 3 RepliesI am having trouble with a mySQL query with the .NET connector. When I create the query, it automatically creates my parameters as objects. I usually change the type to the correct type, which in this case is Date, but I get different results passing in the parameter as a date.When I do "Preview Query" as an object, I get the correct results, but bad results as a Date. I would just leave them as objects, but it errors out when I try to pass a date in.Here's the part of my query that I'm having trouble with:
(Tickets.Resolved >= str_to_date(@startDate, '%m/%d/%Y')) AND (Tickets.Resolved <= str_to_date(@endDate, '%m/%d/%Y')) AND
(Tickets.Status = 'resolved' OR
Tickets.Status = 'rejected')
how should i initialize the string array in this procedure call
vb
Private Sub SetAddres(Optional ByVal Addrvalues(4) As String ) End Sub
how to initialize it with values and also with empty strings or null values
Here's the situation. Due to the design of the database I have to work with, I need to write a stored procedure in such a way that I can pass in the name of the table to be queried against if at all possible. The program in question does its processing by jobs, and each job gets its own table created in the database, IE table-jobid1, table-jobid2, table-jobid3, etc. Unfortunately, there's nothing I can do about this design - I'm stuck with it.
However, now, I need to do data mining against these individualized tables. I'd like to avoid doing the SQL in the code files at all costs if possible. Ideally, I'd like to have a stored procedure similar to:
[Code]...
Is this even possible in SQL Server 2005? Alternate ways to keep the SQL out of the code behind would be welcome too, if this isn't possible.
I have two function having same name only datatype changed in parameter
SaveData( Byval p as byte())
SaveData(Byval p as string)
By the definition of polymorphism this should work.It does not show any compile time error but when I run the application and call the function it does not recognize it. And gives the error Function SaveData is not defined.But when I put a break point on the function it works fine.
[Code]...
I want to compare between the cell value with the value (parameter) in database. As example, if my cellvalue value is 3 and my paramater(a) in my database is 5 it will be like this
if cellvalue<a then
(some code)
end if
I don't know the exact data type. The reason I need to use data type is because my data is dynamic.
Here is my
protected SubGridView1_RowDataBound(ByVal Sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:UsersmeDocumentsVisual Studio 2005WebSitesCSGCSG1.mdb")
con.Open()
[Code] ......
I want to pass a comma delemited list of values as a parameter to a query I'm building using the designer in Visual Studio 2008 based on some strongly typed DAL tutorials I was going through. The query is going against a DB2 database. Here's what I want to do:
select * from prices where customer in(?)
It works fine win I pass in 123456 as ?But fails when I pass in '123456' (it is a char field so I don't know why this doesn't work; it must be adding these behind the scenes) or 123456, 123457 or '123456', '123457' I'm adding this page to a portal where all the data access is being done based on the DAL designer model with a BLL that calls it so I wanted to do it this way for consistency.
I'm new to webservices and xml.I've been given the task of creating a webservice with a method called UploadData. UploadData(Username as string, Pwd as string, XMLdata as String)The XMLData will be xml data 2-5mb.Is String the best data type?I've tried the stream datatype and that does not work as a parameter on a webservice.
View 2 RepliesIn the TableAdapter configuration wizard I am using this query:
Code:
SELECT AttendanceID, StudentID, ClassId, DateOfClass, Absent
FROM Attendance
WHERE (DateOfClass BETWEEN #5/1/2010# AND #5/30/2010#)
Can tell me the correct syntax to change the #5/1/2010# AND #5/30/2010# so the WHERE clause uses dteStartDate AND dteStartDate which are date variables ?
I tried this but it tells me I need to use the to_date function. dteStartDate is already a date variable so I know my syntax is wrong.
Code:
SELECT AttendanceID, StudentID, ClassId, DateOfClass, Absent
FROM Attendance
WHERE (DateOfClass BETWEEN #" & dteStartDate & "# AND #" & dteEndDate & "#)
I have read many post and none of them worked for me. This is what im trying to do. I made a login box in form 3 and when the user types in his login or pass word both gets saved to different Variables and I want to send to form 2.
[Code]...
Also I was wondering If I made a variable in form 2 and I access it from form3 and what ever value is in form 3 gets sent to form 2?