Assume I have a large dataset and I want to run a "like" function in the dataset eg column - Name..Is there any way to run a like statement in a dataset.Is it possible with ASP.NET? I dont want to run a query to the database.
View 3 RepliesAssume I have a large dataset and I want to run a "like" function in the dataset eg column - NameIs there any way to run a like statement in a dataset.
View 5 RepliesI have a function which return the Dataset and my question is that, is dataset memory release automatic when function work finished if not please suggest me how i release memory in below sample question?
public function givemedataset()
dim keepme as new dataset
'grabbing record into dataset
return keepme
end function
Private Sub forumbrowsebtn_Click
dim getme as dataset=givemedataset
end sub
I need to execute a stored function in oracle or sql through vb.net. I created a command object. Depending on the database type(oracle or SQL) i am preparing the Command text as Select functionName(?,?,?,?,?,?,?,?) from dual; (For Oracle) Adding the parameter values of the function. Now performing the ExecuteScalar which is not working saying invalid parameter. This works with ODBC connection string. But ODBC doesn't with 64bit. My Requirement: Code should execute a user defined stored procedure by taking the values at runtime.
View 1 RepliesAs the reference values are stored in the heap as a data; where do the type information of any reference value is stored?If there are a couple of instances of class Artist; when they are stored in the heap how the .Net tags those memory blocks as type of Artist?
View 3 RepliesI'm writing a application that has to check live what's going on somewhere. The data is stored in a integer array.But this data comes from a PLC over a COM port. So imagine if someone pulled out the cable while my application is running. I have to find a way that the integer array will be stored somewhere when my application crashes. I thought maybe I could do something with a text file? But how do I get my application to store the data when it crashes? Do I have to surround my whole code with a try catch and then in the catch save everything to a text file? Well I like to know if some of you have better ideas or can point me in the right direction.
View 4 RepliesI am working on completing the Clear event for Button Clear Sub routine. I have been able to clear the textboxes with the code I already have. However, in playing with the application, I noticed that the memory remains stored somewhere in the program. How to both clear the textboxes, and clear the memory?
Code
Private Sub btnReset_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnReset.Click
txtTestScore.Text = ("")
lblNumberOfScores.Text = ("")
lblAverageScore.Text = ("")
lblBestScore.Text = ("")
txtTestScore.Focus()
End Sub
So i have a DB with 3 tables. User Table with U_ID and U_Name, Class with C_ID, and C_Name and User_Class Table with U_ID and C_ID. Foreign keys are set.I want to display the classes associated with the selected user. The user is identified by their name. I know these are the two SQL statements I need to execute:SELECT U_ID FROM User WHERE U_Name = current_U_name
then
SELECT C_ID FROM User_Class WHERE U_ID = current_U_ID
then
[code].....
I am attempting to create a tier application. Im wondering which approach would be better to take on. Should i have stored procedures on the database and then call these from my Data Access Layer (this is when you right click your dataset and add a table adapter, select existing stored procedures or create the entire query in my Dataset under TableAdapter?
My reason for asking is because my Stored procedures are created to insert and update in one command (by using an If statement), but saw the other approach recently. Any reason for one over the other?
I need to loop through a gridview to find records that match items in a different table (in SQL). Is the best method to loop through the gridview and call an SQL procedure on every loop to find matching records? Or should I pull the entire sql db into a datatable and query the dataset in my gridview loop?
'find source ID based on make/model/serial No combination.
Dim cSource As New clsSource()
Dim ds As DataSet = cSource.GetSources()
[Code].....
I am working on a project, and have defined a strongly typed dataset. Normally I create a single instance of a dataset and use through out an application. In this case I have need to clone the dataset, and clear 2 of the table and then fill those 2 tables with fake data for creating a sample report. at the end of the retuine, I dispose of the dataset. So I was think all was good.
View 1 RepliesI have written the following stored procedure: ALTER PROCEDURE ProcGet Add the parameters for the stored procedure here @id as int output, @name as varchar(50) output ASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON;
[Code]...
In vb.net is it possible to execute a sp for a dataset (datatable) ?
If no is there any alternative to do this as when I execute a sp from database it gives data saved in my db but if I am working on local dataset how to get updated data from same sp without saving to sql db first
Public Class stat
Dim WithEvents connection As SqlClient.SqlConnection
Dim connectionString As String
Dim da As SqlClient.SqlDataAdapter
Dim ds As New DataSet
[Code] ....
I am trying to fill the dataset by calling the stored procedure "top5_best_selling_products" but the connection is not closed so the error is with the adapter or something.
I'm trying to get VB6 to access an Oracle (9i) procedure and return a dataset without much success.Not used VB6 that much but I need to do it for this application as we are not able to install the .Net framework on this particular server.Oracle procedure has an input param and an OUT param which is defined as a sys_refcursur
CREATE OR REPLACE PROCEDURE "LOGMNR"."LM" (p_filename in
varchar2, p_recordset OUT SYS_REFCURSOR)[code].....
I get the same error message regardless of wetheror or not the second output parameter is enabled.3709 The connection cannot be used to perform this operation. It is either closed or invalid in this context.how to return a recordset from Oracle to VB6?
things look good till I reach the Bind Commands to Existing Stored procedures page of the wizard and I select my target spproc (rpt_IPR_...) then I hit the finish button and see the message: invalid object name '#TmpResults' now the dataset seems to setup correctly but was wondering why we are getting this message and should I be concerned. The same proc in Access had no issues. [Code]
Because we where not seeing info on the spproc parms we began to suspect that the query made by the IDE to get metadata was failing and that indeed is the case. (we also switch to non-production database to reproduce the issue)after some great SQL debugging from Kevin Currier here at Mindsolve the problem seems to be the SET FMTONLY OFF; SET FMTONLY ON; that the framework is using to get metadata info for the [Code]
I am trying to call a SELECT query (with parameters) in Access from VB.Net 2008. I am able to call queries without parameters using the code below. The problems are (1) how to apply the parameters to procName and (2) how to get a dataset returned. I have looked around the net for hours and have found some examples. However, they are all for ms access action (update, delete, etc) queries using ExecuteNonQuery which does not return a dataset.
[Code]...
In a DataSetIf I right-click on a TablesetAdd QueryCreate New Stored Procedure. The creation will fail for me using a SQL 2008 database. "There was a Problem with the UPDATE stored procedure. The stored procedure was not created."If I "Preview the SQL Script..." copy it and run it manually it fails because it is not putting brackets around my user name. "CREATE PROCEDURE SDSDBLUESKY.UpdateQuery" Fails"CREATE PROCEDURE [SDSDBLUESKY].UpdateQuery" WorksThis is a work around because it links to this if I do manually when it gives me the preview option, and don't rewrite it. But is there some setting change in VS2005 to get this to work correctly in the first place?
View 1 Repliesdoes VBasic allow a MS Access Database DataSet create a Stored Procedure or will it only allow SQL Database DataSet create SP...
View 4 RepliesI wanted to know if u define a dimension in a function or subroutine and that func/sub is called say 5 times, does the memory new block of memory get assigned to it every time the func/sub is run or does it use the one it got assigned the first time?
View 6 RepliesI don't use VB.Net very much, still mostly do VB6, but I am doing this project in .Net. I have a huge string of data, 168 Mb that I stream in from a file to a string variable. Then I have to perform a number of replacements on it before using the data to compile statistics. Because of the nature of the data, I can't break this up into smaller strings.
The problem is that I get a system out of memory error after a few replacements.
I've used both Replace(x,y,z) and X.Replace(y,z). The second one gets a little farther in the code before it crashes, but they both crash.
When I run it in the IDE, the IDE is using about 130 Mb of RAM, the Exe of the app is running about 350 Mb, and one svchost.exe runs about 300 Mb
Other than that there are no major RAM uses going on. The PC has an i7 980x cpu with 12 GB of RAM.
I have this relatively short function, triggered when the mouse is moved over a picturebox. When being called, it slowly increases the RAM and PF usage of the program which never recovers.[code]I just wanted to report back and say that I did solve this issue (more or less).I added a manual garbage collection call at the end of the loop and it kept the resources usage under control. It did seem to slightly slow the response time, but it's worth it to avoid the program hogging multiple GBs of RAM.
View 1 RepliesRead (search a value) in a non specific process memory. Write a value in the address found in the last function requested.
View 2 Repliesim getting this error when i run my app, i have looked at my stored procedure and VB code and cannot see anything wrong with been stuck on this for the last couple of days
View 5 RepliesThis code updates the fiscal year automatically.[code]...
View 1 RepliesI have that code running into a windows service and the service seem to have a memory leak, something is wrong for sure. After looking at the whole code, I think it might be inside one of these function but I cannot seem to find where it could be.
[Code]...
I found this function for plotting a graph online somewhere. I am pretty sure it has a memory leak but cant figure most of the functions as I am new to VB and windows API. Looking for some quick tip on what I should be looking at.
[code]...
I have a VB Function (in Visual Studio 2008 with .NET 3.5) that opens up a connection to an Oracle database and queries the database for information. Apparently after some trial and error, I discovered when the SQL statement is being processed and filling the dataset, it apparently is taking up too much memory trying to complete the task. I'm running into System.OutofMemory exceptions and other unpleasantness.I'm wondering, is there some sort of program out there to measure memory consumption of your SQL code that is being processed in a Visual Studio application?
View 1 RepliesI have a VB Function (in Visual Studio 2008 with .NET 3.5) that opens up a connection to an Oracle database and queries the database for information. Apparently after some trial and error, I discovered when the SQL statement is being processed and filling the dataset, it apparently is taking up too much memory trying to complete the task.I'm running into System.OutofMemory exceptions and other unpleasantness.I'm wondering, is there some sort of program out there to measure memory consumption of your SQL code that is being processed in a Visual Studio application?
View 2 RepliesI am working on a project that requires me to hop into to separate DB's. So I have figured that I need to have multiple functions inside of my VB page. The only problem I am having,is I am not to sure how to get this all accomplished. So far I have figured out the overall structure, just need to implement that structure.
Here is my idea:
The main Function would call two other functions. We can Call them Sub Function 1 and Sub Function 2. So, the main Function takes the saved sessions information for the E-mail address and dumps in into Sub Function 1. It needs to open up a new connection to the db/stored procedure and RUN the following procedure and then return the result. Here is the stored procedure and what I think is correct.
CREATE PROCEDURE WEB_User
(@EMAIL_ADDRESS varchar(80) = [EMAIL_ADDRESS])
AS SELECT MEMBER_NUMBER
FROM WEB_LOGIN
WHERE EMAIL_ADDRESS = @EMAIL_ADDRESS
So my question is, what is the function suppose to look like? how do I send the session information to the procedure? and finally, how do I return the stored procedure results and push back into the main function so it can be carried into sub function 2?