I am executing stored procedure using ExcuteReader() command. If I execute Stored Procedure in SQL server it is taking 2 secs. But in code taking around 2 mins. I tried DataAdapter.Fill(). Still the same.
What is wrong in the code?
spString = "usp_graph"
sqlcmd_q.Connection = sqlCnn
sqlcmd_q.CommandText = spString
[Code]....
I have List (of class). having 1800 of count and each object has 90 properties. When I terate earch with 90 properties taking more and more time. How to resolve this
Dim cellIntStyle As HSSFCellStyle = hssfworkbook.CreateCellStyle
cellIntStyle.DataFormat = HSSFDataFormat.GetBuiltinFormat("#")
Dim cellDateStyle As HSSFCellStyle = hssfworkbook.CreateCellStyle
[Code]....
below code is taking 150 to 200 second to read data (actualy my response data is very large) [code]
View 1 RepliesSetup taking toomuch time for installation
View 5 RepliesI am using vb.net in which I have put the background image to every form. The image size is 1024X768. When I open the form it is taking too much time to open. and screen is fluctuate.
View 1 RepliesI have a backend database in MS access, which is updated using excel as front end. Due to network issues the record updation takes lot of time. Would it be faster if i use VB.net as the front end.
View 1 RepliesI am on one asignment of convering C# to VB.net and stuck up with this problem.C# application has one class having inline two dimensional array initialized with size 168X168. I converted same class to Vb.net. Now whenever I create instance of my this VB.net class, It take almost 3 minute.
To figure out problem, I put break point on sub new() (first line of my constructor), and behaviour is realy strange because it takes 3 minutes to reach at first point of my constructor.Whenever I comment out my large size array initialization code, It works perfect. Now please note that same code is working fine in C#. It is not taking even few millisecond to initialize that class.
I am writing an application for managing mp3 files. I use AXWindowsMediaPlayer1 for playing files and UltraID3 for reading and writing ID3 tags. Every time the user selects to switch to next song, the ID3 tags of the current file need to be updated. My problem is with Media Player taking a long time to release a file for access after doing a "close". Currently I need to add a 6 seconds delay between the "Close" method of the media player and the ID3 tag "Write", otherwise I get the error saying that the file is currently in use. Anything less than 6 seconds does not work...
I attached a short version of my application which focuses on the issue.
An error that arises when I take a vb project Visual Studio 2010 that works on my local machine to a server. How precisely would I work around it?
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. review the specific error details below and modify your configuration file appropriately.
Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
Source Error:
Line 24: ASP.NET to identify an incoming user.
Line 25: -->
Line 26: <authentication mode="Windows" />
Line 27: <!--
Line 28: The <customErrors> section enables configuration
I want to take the values from textboxes on a windows form and then update the values in the sql server database...I want to update only those fields for which a value has been entered by the user and leave the fields for which the textboxes are left empty by the user.....How can I generate the query dynamically for such a situation???
Edit:
I haven't yet coded for the update option...Here is my insertion code and i wanted to implement the update feature the same way just couldn't figure out how i can generate the query dynamically....It's a Booking System application
[Code]....
I am upgrading user control from vb6 to vb.net.In the vb6 application I am loading 3000 labels using a label control array.In vb.net I am doing same but it's taking too much time to load.In vb6 it's taking 1-2 seconds, but in vb.net it's taking 30-40 seconds for same work. Why does it take too much time in vb.net for same work?Code is given below, here Led is the label control array.
For l = 1 To 3000
Led.Load(ledCounter)
ColLed.Add(Led(ledCounter))
[code]....
I'm writing a program to search files.The result is saved in a text file.Everything it's working fine, but when I say to look for files/folders in C:* the process takes long time and in task manager it's displayed as "Not Responding", this is not true because I see that CPU and RAM are working with this process.I've disabled in DEBUG OPTIONS the line "ContextSwitchDeadlock" just to prevent the error message "this operation require long time ... bla bla bla".Is there any way to display a progress bar or something like that that shows the program is running and it isn't "hang"?Here's my code (in red the line where the program hangs):
Code:
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cartella, scelta, cosa As String
[code]....
I think that it's like when you type in the command prompt "tree" it doesn't hang... I know... it's not the same thing but...I'm using Visual Basic 2008 Express?
I am working on a windows application project on NIST time synchronization, but can't get a proper solution for it. If anyone can send me the code to synchronize time from the global time server in VB.net or C # code
View 2 RepliesI am using stored procedures in my application using vb.net, while executing stored procedures on mysql database server thru application, the response time from the server is more. Is there any settings that i need to set on mysql db server or any changes in connection string or in code.
View 14 Replieshow to set my pc time application sync with my remote time server?...my pc application is 192.1.2.1 and my time server is 192.20.10.1...
View 1 RepliesHow to use the ExecuteReader calling a stored procedure with a parameter array?
View 1 RepliesI am getting an ArgumentOutOfRangeException when I try to run the following code,[code]the table that is being read has a single row of data, the database and connection are fine as I can run INSERT/UPDATES etc but wherever I have used a datareader I am getting this exception each time on the "Using reader As MySqlDataReader" line.
View 2 RepliesI am using Microsoft visual basic 2010. I am using the following code to connect to a local access database. After the line myReader = cmd.ExecuteReader () no code runs. I am not receiving an error message.
Dim connectionString
As String =
"Provider=Microsoft.ACE.OLEDB.12.0;data source=C:UsersmikeDocumentsFCE_Database.mdb"
[code]....
I have used this method to connect to the same database multiple times in the same program without a problem I've also tried using OleDb with the same result.
Can anyone tell me How do I solve this error.Error: NullReferenceException was Unhandled - "Object reference not set to an instance of an object."
Line: Dim reader As OleDbDataReader = dbCommand.ExecuteReader()
Database: MS Access
IDE: VB 2010 Express
[code].....
Dear friends I am new in .net world and I am trying to display a single row to a literal. I prefer VB so my code is as follows but I'm getting the error "ExecuteReader: CommandText property has not been initialized".I also tried sqlCmd.CommandText = "getLastModificationDateTime" without the EXEC statement
View 3 RepliesPublic Class app_mainform
Dim mssqluname As String
Dim mssqlpword As String
[code].....
i have this code in form1 at buttonpreview
[Code]...
i have problem with my code
here is my code
Public Sub increment()
Dim dr As SqlDataReader
If con.State = ConnectionState.Closed Then
[code].....
Public
Class Form1
Dim conn
[code].....
i have app that connects to a mysql db.i get data from the db with executereader.but i want to execute some sql depending on the result from a other db.but i get a error when doing ExecuteNonQuery() when the reader is still open.Here's a part of my code where the problem occures.
Code:
tracecom.CommandText = "select * from testsms left join customer on customer.id=testsms.id where date_sub(now(),interval 1 minute) > testsend"
tracerd = tracecom.ExecuteReader()
If tracerd.HasRows Then
[code]....
I'm getting the error below for this SQL statement in VB.Net 'Fill in the datagrid with the info needed from the accdb file
[Code]...
I am using below mentioned Ado.net function and resultset bind with grid view, however I am getting the duplicate rows in the resultset.
[Code]...
I have a program using the OleDbCommand to read an indexed Access database. [code]I notice that when step debugging the program, the file is not being read in correct order.Example: it will read the record with "B" in the D01 field before a record with "A" in the same field.The record with "B" is the second record in the database.I do note that all records in the database are read before exiting the loop, just not in any apparent order.
View 5 Repliescould someone help me with some simple coding methodology for doing database searches within the ExecuteReader function that will return results regardless of case?For example, if the variable to search for within the database is John Smith,I would want the search to be successful if john smith is the user-provided variable.
View 8 RepliesI have a stored procedure that repeats a block of T-SQL statements using WHILE logic until it finds a matching record in a table. When I execute the procedure directly from the SQL Management Studio, it works and returns a record, even when the statements within the WHILE logic have to be repeated over and over again before a matching record is found.
However, when I use the same stored procedure as the commandtext property of an sqlcommand object in Visual Studion 2008 (VB) and call the executereader method of the sqlcommand, the resulting SqlDataReader will only return a row if the T-SQL statements within the WHILE logic find a matching record after a single pass. If it takes more than one pass to find a matching record the SqlDataReader does not return a row. It's like it abandons the execution of the stored procedure after the first pass of the statements within the While logic, disregarding the repetition.