I am having dataset with 5000 records.I am reading them in the below 2 functions and writing to excel.
FillDataRows1(worksheet)
FillDataRows2(worksheet)
private sub FillDataRow1(byval ws as worksheet)
[code]....
When I create thread also it is taking same time .
I'm creating a password hash recovery tool that uses brute force. I have the brute force algorithm run in a background worker. It all works, but some similar apps I tried out have performance ~100x bigger then my app. (mine does 50k keys/second, some others do 5m keys/second or more.)I realize this is partly caused by using a .Net language, but I suspect there are ways to significantly speed up the brute force. A lot of ppl say I should use multi threading, but how is this done in practice? Splitting up the passwords to check would slow down my app I think.
View 1 RepliesHow do I update records in a dataset with records in a transaction file?
View 3 RepliesI want to build in the Mongoose web server into my application. My program consists of a form and a module. The module contains the Mongoose code copied from here: [URL] If I call the Main() function in the module from my form's Load event then the web server starts correctly and I can connect to it. However, that's as far as the applicaiton goes - my form doesn't load up. I guess this is because my application is only single threaded and the Mongoose code basically puts the thread into sleep mode waiting for a http request.
So, the question is how do I go about getting Mongoose into a separate thread that starts up when my application starts, but then allows my form to load and be operable?
I have a dataset in a Visual Studio 2010 Web App project which accesses the DB with a complex SQL statement. If I run the statement in SQL Management Studio directly, it loads in a less than a second. If however, I run it using the "Preview Data" button in the dataset designer, or I try to access it on a page (with a gridview for example), it takes over 40 seconds!
View 2 Repliesi have a datatable with about 10000 rows and few columns (4)I have noticed that the process of reading a big table its quite slow..is there a way to improve performance in reading a datatable?
View 15 Repliesi have this simple code from a vb.net project:
Using sr As New StreamReader(NewSwitch.ActFolder & NewSwitch.ActSShowName)
worker.ReportProgress(LoadSwitchProgressType.Normal, "Loading Active SupportShow, size " & NewSwitch.ActSShowSize & "...")
NewSwitch.ActSShowData = sr.ReadToEnd
End Using
Obviously it reads a file - a 20M text file to be exact. Now if this 20M file is on my PC, it reads in about a second. If i open this same file in a text editor, such as Conext, its about the same.However, if this 20m File is on a network location, the Context text editor loads the file in about 1 min 40 seconds. I would have expected similar times with my vb.net code, but it took 7 minutes 45 seconds.I have no idea what the text editor uses to read a file, but i figure i must be able to get similar time in vb.net somehow.
I have a program in where I need to loop though the entire dataset.datatable. I takes a long time. What is the alternative I can use to do the some job but faster?
View 4 Repliesfrom a performance point of view is it faster to work with linq to sql or dataset.datatable?
View 6 RepliesI'm currently working with a gridview that has a huge underlying dataset.I'm almost certain that I saw something about a new facility in Visual Studio 2010/.NET 4, which would improve the performance (e.g. doesn't download all the data on databind, but rather only what data required for current page). My guess would be that it was using AJAX.I didn't need it at the time I saw it, and now I can't find it, even though I've been hunting online for a while.
View 2 RepliesI want to import data from excel and move that to Datatable in VB.NET 2008. I wrote and working but its taking too long time.. for 1500 records its taking 4.40 min.
[Code]...
An in-line table valued function in SSMS takes about 6 seconds to return 11088 records. The same function in VB .Net 4.0 using TableAdapters.InputTableAdapter.GetData (Created with data set designer) takes about 15 minutes complete.Both are executed from the same workstation.Why does this discrepancy exist?
Workstation:
Windows XP SP3, 2GB
VS2010 Ultimate
.Net 4.0 Framework
Server:
SQL Server 2008
I just learned some basics of multi threading in VB.net recently as I came across processing a large List of records and inserting them into SQL database one by one.
I have code look like this:
Private Sub btnLoadNow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoadNow.Click
Dim autoLoad1 As New Thread(AddressOf AutoLoad)
autoLoad1.Start()
[CODE]...
Itemlists is a global lists i retrieved from database, everything looks fine to me but when i run this program, I found that the threads are inserting one records 9 times into the database(I have 9 threads in total), which makes me think that maybe i need to specifically assign 1/9 of a list to each thread? Is there another way to do it which doesn't require the splitting of the list, if not , how do i split it then assign?
I'm following a tutorial using serialization/saving records.I can make records, display them ok in a datgridview and then save them ok using serialization. Then I can reopen the programme and reload the dataset from the deserialised file, and show the records ok [code]....
View 1 RepliesI'm following a tutorial using serialization/saving records. I can make records, display them ok in a datgridview and then save them ok using serialization. Then I can reopen the programme and reload the dataset from the deserialised file, and show the records ok - but I cannot add any more records to the datagridview.
Here is my code:
Imports System.IO
Imports System.Runtime.Serialization
Imports System.Runtime.Serialization.Formatters.Binary
[Code].....
i have a register form and a dataset called clifs_project21Dataset.xsd
i just want to update
de info from register form to dataset and i use acces 2007
In Visual Studio i can select the target .net framework version, which for example defaults to 3.5. Now when i build my application with this setting, i guess it wont work on computers with .net framework 3.5 not installed, right?But lets say i choose .net framework 2.0 as target .net framework. Will my application work on computers that have .net 3.0 or .net 3.5 framework installed, but not 2.0?In other words: Is the .net framwork always backward-compatible?
View 1 RepliesI am writing an application that does a number of different things with data downloaded from hardware which is monitoring the power used in my home and produced by my PV Solar array. I have run into a roadblock early on, because I cannot seem to get new data into an Access database that I have linked to my application by means of a DataSet. I have checked the DataAdapter's InsertCommand, DeleteCommand, and UpdateCommand definitions (created by the DataSet Wizard), and they seem to make sense, and nothing is throwing exceptions or otherwise making VB complain, but new rows added to the dataset are not being added to the database.
[Code]...
im trying to get a selected time and my dataset doesn't return the selections what am i doing wrong in this statement
dim startindex as integer= 0
dim endindex as integer= 0
for each regel as datarow in my dataset.tables("Bookingen").rows
[Code].....
I want to return the top 5 records of a table in a dataset for datagrid view. The following does not work.
DataGridView.DataSource = DS.Tables("TABLENAME").Select("SELECT TOP 5")
having trouble adding records to an existing dataset, I tried the following code but it made a new connection which I don't want:
Dim inc As Integer
Dim con As New OleDb.OleDbConnection
Dim da As OleDb.OleDbDataAdapter
Dim sql As String
[code].....
I have used VB6 for all kinds of database programming. Now I am fairly new to the vb.net. How do we read the records (rows) from a dataset and manipulate data? I want to populate a combobox or a datagrid with a recordset (in VB6 language). What is the .net equivalent of ado dataset, and how do I use it. I have tried several ways using dataadapters and dataset, etc.
View 4 RepliesI am trying to use a ListView to display records from a dataset. In these records, I have 4 columns: EmployeeID, EmployeeName, CustomerID, and CustomerName. It is possible for both the Employee and Customer to be listed multiple times, but with different combinations.
For instance, if we have Employees 1, 2, 3 and Customers A, B, C we could have:
(1A)
(1B)
(1C)
(2A)
(2B)
etc.
What's going on with mine is I add say (1A) to the listView and then when it tries to add (1B) I get an error saying that it cannot add the same item.
Here is my code so far:
With list
.Clear()
.Columns.Add("Employee ID")
.Columns.Add("Employee Name")
.Columns.Add("Customer ID")
.Columns.Add("Customer Name")
[Code] .....
so I have chosen to add the database to my vb project when the connection was being set up in Visual Studios 2010. so the code below inserts it to dataset, but database doesnt seem to be updated, I am trying to add new records to Business and Login tables and have defined two functions to assign the value of text boxes to the fields on the records: [Code]
View 6 Repliesjust as I would read an SQL file in order with code such as:DCReader02 = DCCommand02.ExecuteReader()While DCReader02.Read() End While I am looking for the equivalent code to read each line of an Excel file until end of file. The Excel file was opened with
Microsoft.Office.Interop.Excel.Application / Workbook / Worksheet coding.
I have come up with this 2 methods of reading all records on a database table. Both work nice but I would like your expert opinion on which delivers best performance and why.We are reading table "DATA" and filling an array called lstData with the contents of the "Data" field.
1) Method one is using the bindingsourse to go through all the records.
[code]...
My guess is that the first method, while simpler to the eye could use more overhead. What I really would like to know is if the second method really delivers better performance and if it is worth doing all the manual SQL queries.
I will be developing a Windows Application that will write data to an excel file.I would like to know if formulas used in the computed cols will still work on the new rows that I add or edit through program.
View 4 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]...
This problem makes it so that when I view the data, any fields with text are blank - only integer values show.
Code:
Dim PathToCsvFiles As String = "\\umpqua\companies\shared\MLImports\"
Dim FileName As String = "Strategy.csv"
[CODE]...
Also it is pipe delimited so I have a Schema.ini
[Strategy.csv]
ColNameHeader=True
CharacterSet=ANSI
Format=Delimited(|)
this is strange, I've got a macro with an array containing several registry keys.
And I want to insert the values of these into predefined bookmarks in a Word document. This works great if the key is there, but if it isn't, I want the code to skip that and continue trying the next one in the array. I've got the code that looks like this:
[Code]...