On the SQL server I create a UDF. Let's name it fnCompanyDetails. It selects some information about a company from several joint tables.I then drag-and-drop this function in the new .dbml of my VB project. I want to use it with LINQ. Smth like this:
[Code]...
I'm building an application that will need to run a specific functions at user defined times I need help with setting up the schedule part of the app. What I would ideally like to do is be able to set up an "event" which will occur at a specific time and date or at a specific time on specific days such as 9:00 Monday's Tuesday's Wednesday's and Saturday's.
View 2 RepliesI have the following Query:
SELECT *
FROM tbl_Muffins
WHERE OvenLoadId IN (
SELECT OvenLoadId
[code]....
The idea of the query is that I want to specify an OrderId, and I want all Oven Loads that have items from that order in them, as well as ALL OTHER ITEMS in those loads, even though they could be from other orders.The query works as expected, but I'm not able to use it for my Crystal Report I've written it for.I have put this query into a User Defined Function, however I'm unable to use a call to that function as a table source in my Crystal Report. I am using Visual Studio 2003 (I know it is old, the client refuses to upgrade).
I have a database with about 180,000 records. I'm trying to attach a pdf file to each of those records. Each pdf is about 250 kb in size. However, after about a minute my program starts taking about about a GB of memory and I have to stop it. I tried doing it so the reference to each linq object is removed once it's updated but that doeow can I make it clear the reference?
Private Sub uploadPDFs(ByVal args() As String)
Dim indexFiles = (From indexFile In dataContext.IndexFiles
Where indexFile.PDFContent = Nothing
[code]....
just want to know if linq to sql auto updated the id column of a class (table row object) after SubmitChanges is called inserting a new row to that table, that would be fantastic, would anyone be able to confirm this?
View 2 RepliesI am trying to redirect command line output to a list box in a vba macro, and I've found some code that I think might point me in the right direction, but I keep on getting the same error. When I use this code [code]It gives me the error in the title and highlights the first declaration line.What does it take to define a new "process".
View 1 Replies[Code]...
a messagebox appear that show user-defined type not defined i had try another code but it still same error.. i'm using vb6
I'm converting a user generated list box to an array and then generating a user defined number of random strings and placing it in a textbox.The code I have works fine as it will generate the number of random strings the user wants, except sometimes a line is blank at the top of the list but is counted as a string.
View 4 RepliesIn this following
[code]...
in the query creation part,the evensQuery and num are not defined.....then how does it work Secondly,i read this from MSDN:In Visual Studio you can write LINQ queries in Visual Basic or C# with SQL Server databases, XML documents, ADO.NET Datasets, and any collection of objects that supports IEnumerable or the generic IEnumerable<(Of <(T>)>) interface Now how can i know whether the collection of objects supports IEnumerable<(Of <(T>)>) interface or not?
So I wanted to check when last a table was changed, and I basically came up with this query:
SELECT DB_name(database_id) as [Database],OBJECT_NAME(object_id ,database_id) AS DatabaseName, last_user_update
FROM sys.dm_db_index_usage_stats
where DB_name(database_id) = 'Database Name'
Now what I want to do is put this in my code using LINQ. I have added the view to my datacontext and all that good stuff, but I don't really know how to do the SQL built in functions DB_Name and OBJECT_Name. I realise that I could do some sort of join to get the values for the id's instead, but I don't know which views I can find the database name and object name in.
Is there a linq equivalent to these functions? Alternatively, what are the system tables/views I need to look at to convert these ID's into their respective names?
How do I pass parameters of LINQ DataTables through Functions and Subs
View 1 Repliesi am downloading data from xml using linq library those data i want to add them on a textblock item
TextBlock1.Text = TextBlock1.Text & result
but it has an error :
Error 1 Operator '&' is not defined for types 'String' and 'System.Xml.Linq.XElement'.
When i am changing this line to :
TextBlock1.Text = TextBlock1.Text & result.Tostring
it works but it adds this data :
"<"data> data <"/data>
instead of :
hello
What I am trying to do is have a class where the functions of the same name are both instance functions and shared functions.
Public Shared Function Get...(byval xx as xx)
and
Public Function Get...
The Public Function uses a Property xx created in the constructor, whereas the Shared Function has the parameters (byval xx as xx).
I have created a User Defined Control that contains Add, Save, Edit, Search, Delete & Close Buttons. I added this User Defined Control in a New Form & How can I call Add, Save, EditSearch, Delete & Close Buttons of User Defined Controls from the New Form. What is the Code for calling a button of User Defined Controls from its Parent form?
View 2 RepliesI've got a piece of code that inserts a row into a table - the kind of thing I've done in dozens of other apps - but the end result is nothing happens on the database end, and no errors are generated.
Here's my code:
Partial Class MyDatabaseDataContext
Public Sub CreateEnrollee(subId, depId)
dim newEnrollee = New enrolee With {.subId = subId, .depId = depId}
[Code]....
After SubmitChanges is called, no new row is created, and "test" is zero. No errors are generated. I have no idea why it's not trying to insert the row.
example of a user-defined exception in VB.Net. I already have two examples that I was able to find online, but other than that, I cannot think of any more. I need to find at least 5 to put in my notes, and then submit to my teacher.The two I have so far are: invalid login information (such as improper username or password), and expired credit card information on an online store.
View 3 RepliesI'm a new user of VB.Net. I do have doubt on accessing a user defined Function or Sub. In some place of program, I do see the term "Call" when using the Function/Sub. In some other place without "Call". But both works perfectly. May I know the difference between the two.
[Code]...
I apologize in advance about asking a newbie question. I am a less-than-intermediate programmer who has done most of his work in VB6, and now trying to wrap my mind around the new concepts of the NET languages.In VB 2010, I have a Structure called "Direction", with one data member -- an integer named "Value". It's supposed to represent a value of degrees from 0 to 359.
Public Structure Direction
Private d As Integer
[code].....
Is there a way to create a user-defined ImageList? I would like the user to be able to assign images to ImageList that would be stored for use in future sessions.
View 3 RepliesWell I had a thread going that branched out to this topic, so rather completely veering off the main topic there, I felt creating a new thread was adequate.So as the title says, I'm trying to create a user-defined type. It's not a simple type at that but a user here had showed me a way to fix all my problems. That was to create a type BigDecimal. Which my initial thought was to utilize the BigInteger type. Being that the Integer Part, and Fractional parts would be split off into two variables, both BigIntegers. Which would be combined at the end as a "decimal". However I have many many questions see that this is my first attempt at truly creating a type of my own. So as of right now I'm basically swinging in the dark here.
[Code]...
Im using a simple access database with only 2 tables and I creadted a form with a datagrid to show all data inside the tables, and now i want to create search buttons for each field of the table . like, "seach by Name", Seach by date" etc... i tried to use the simple code
Code:
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim cod As String
cod = InputBox("Type the Id to search: ", "Search By ID")
If cod <> " " Then
[code]....
My biggest problem now is that this code works very well to search by id (which is my table primary key), but now i want to search by other fields and this code only allows to search by primary key! Is there any way to use something similar to this code to search by other fields?
This program would allow users to click a button and display three different types of patterns (shown below). The user could also enter the number of rows they wanted to display and a character that they wanted to use for the pattern (*, &, etc).[code]...
View 3 RepliesI am having trouble with this code. Can someone tell me why the "Project Processing' section doesn't run at all? The 'Client Processing' section runs and executes find but it seems the 'Project Processing' section does not. very frustrated at the moment!
[Code]...
I have a database of 7 items that I want the user to be able to choose the order in which each is listed for use further along in programming. I'm thinking of using combboxes bound to the database. I found out that each combobox will have to have its own dataset otherwise they will all show whatever the current one that has focus changes to. Is there an easier way to be able to do this or is having 7 datasets bound to the comboboxes the best way? For this purpose I don't need all the contents listed in a DGV, only need the component name for now if this helps. Database programming is new to me and I'm a hobbyist programmer from VB6 days making the transition.
View 6 RepliesI have derived a textbox. This user control works fine everywhere. However, i have added a property in this as follow:
Public _propertyValue As Boolean
Public Overridable Property AllowNull() As Boolean
Can we add a user defined property to a textbox (NOT TO A TEXTBOX CLASS)?
e.g. MyTextBox.MyProerty = "GOOD"
I have a structure like this:
Code:
Public Structure Interval
Public temp As Double
[Code].....
'I want to be able to add to the array like an ArrayList though... 'after assigning values, like this:
interval(0).add
The main function receives data, uses additional functions to calculates the result and gives it back. But at one point, the function needs data from the SQL Server. I wrote a second UDF, made it visible and deployed it to the SQL Server. I see now two functions under > programmability > functions > scalar value functions:
1. The main function (IsCalcDay) and
2. The function with the data access (IsHoliday)
If I call directly the second function from VST in the debug mode, it works fine, bur if I call it via the main function, the code stops if the connection will be opened. The error is "Data access in this context is not permitted. The context is a function or method that is not marked with DataAccessKind.Read SystemDataAccessKind.Read or a callback to retrieve data from the FillRow method of a table-valued function or a UDT validation method." (translatet from German, probably slightly differnt in English)
VST (2010 prof) and the SQL Server (2008 R2) are running in my virtual W7 maschine.
Here is the code of the second function:
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
[Code]....
Why can I open the connection if I call the function directly, but it fails if the function is called from another function?
Maybe I have missed something obvious. Currently I am using the feedback interrupt to change the cursor to one of the Windows supplied cursors
Instead of using the pre-packaged cursors, is it possible to use my own custom-cursor (icon), and if so - are there any rules re size etc., or can I use something like a png/jpg etc.. ?
I would like to make a "deep copy" of a class object that I have defined. See Visual Basic 2005 Code below
Dim MyStuff1 as new MyClass
Dim MyStuff2 as new MyClass
mystuff1.getbyID(anID)
mystuff2 = mystuff1
Unfortunately the statement "mystuff2 = mystuff1" makes a "shallow copy" of mystuff1. Therefore, if mystuff1 is redefined then so is mystuff2. What do I have to do in MyClass to implement a deep copy method such that operations on mystuff1 and mystuff2 are independent?I would prefer something like
mystuff1.deepcopy(mystuff2)
or
mystuff2 = mystuff1.deepcopy()