I have following code and it's slow to load first time. CSV file is about 4mb 16000 rows.
If Session("tb") Is Nothing Then
Dim str As String()
If (IsNothing(Cache("csvdata"))) Then
[Code].....
i 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 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]...
I'm using vb.net 2010.I have a DataSet with a Table and data. MyDataSet1 which contains Table1 I want to create another table that is the same as the Table1 but without data, but it should have the columns, etc.
View 1 RepliesI have a form that has a datagrid and a tab control with a few textboxes , all bound to the same binding source, no code other than loading the tableadapter at loadup.
Problem - After the form loads and all the data populates, when selecting a diferent record in the datagrid, there seems to be a delay on the binding source record change. But I have noticed that after selecting each tab, the delay goes away.
I have the following function so far and I dont know how to continue
Public Function getdetails(ByVal id as Integer) as Data.DataTable
Dim query as string
Dim mydatatable as Data.DataTable = new Data.DataTable()
[code]....
basically I am using to C# and just learning vn.net..What I want to do is save the information t,id and t.color in a datatable in vb.net..How do i do that.
When I create a form using only one table in a database this works fine. However when I create a form that uses at least two tables I am getting an error on my ReceiptsAdapter (or my SQLDataAdapter). It's saying that I am using the incorrect syntax and need the keyword "From." I am assuming that I am getting this error because I am using multiple tables in my SQLCommand statement.
Imports System.Data
Imports System.Data.SqlClient
Public Class Receipts
[Code].....
I have got a datatable which contains many columns in which three are main:
hotelid
dshotelid
hotelname
Some hotels contain only dshotelid, some contains only hotelid and some contain both dshotelid and hotelid.
I need sort in such way so that those hotels who got both dshotelid and hotelid should be on top and then those hotels who have got only dshotelid and at last those hotels who have got only hotelid...
create such a sort expression.
I created this :
dtmaintable.DefaultView.Sort = "dshotelid, hotelid"
but it Is not giving me desired output.
I'm wanting to have some datatables that are just used temporarily, mainly for creating and listing friendly versions of data that will be easier for the user to read in drop-down combos etc.
I would like them to be strongly typed to pick-up bugs at design-time. However I'm struggling to know how to achieve this. Do I need to create a custom class and inherit from DataTable and build the columns in the class constructor?I don't need a Dataset, just a DataTable?
I want to modify this function to populate an array with each item in the database.
I have tried various options, but I just can't get it to work[code]...
I have a array based on a structure that I want to build a datatable from. Here is what my structure looks like currently,
Public Structure QRQFiles
Public Complex As String
Public DescriptiveName As String[code]....
Since I have a structure with in the structure will I have to define two datatables to represent this?
I have connected my sql db with vb and I m trying to make a UI. My question is that when I write code in order to create datatables and I fill them with the results of queries I've created, where do these datatables belong? I'm wondering if I have to define a new dataset or do they belong to the existed dataset which is created by the dataset configuration wizard??
View 3 RepliesI have a datatable which has a number of rows containing dataThen I need to add some empty datacolumns which I do like this:
Code:
Dim OT_Hours As New DataColumn("OT_Hours")
OT_Hours.DataType = System.Type.GetType("System.Double")
[code].....
I am working on a winform project like to dynamically create chexboxes from a datatable rows.
View 6 RepliesI want to modify this function to populate an array with each item in the database.I have tried various options, but I just can't get it to work
Private Function ConnectMe() As DataTable
Dim conn As String = "Server=192.168.0.36;Port=3306;Database=wswc;Uid=r oot;Pwd=Jack"
Dim cmd As String = "SELECT * FROM st_users"
[code]....
Instead of fill, I want to one by one add it to the dataset and also an array?
Whenever i work on form, so i use this code
CODE:
Now i have 2 things to ask?
1) is this right way which i use?
2) I use the same on every form regardless on number of forms? is it fine to use it on every form?
whenever i work on form, so i use this code,[code...]
now i have 2 things to ask?
1) is this right way which i use?
2) I use the same on every form regardless on number of forms? is it fine to use it on every form?
I have worked in Windows Forms for years, and still do. I'm not acquainted at all with the ASP.NET technology and no other Web related technology. I have worked with:
Oracle Form Builder;
Visual dBase 7.5;
Delphi 2.0, 3.0 and 7.0;
Sybase Power Builder 10.5;
Visual Basic 6;
Visual Basic 2003/2005/2008;
And ultimately, Visual C# 2005/2008.
I'm mostly a C# programmer with a growing experience in VB.NET for the current year. What would be the way to go to learn WPF the best possible way while taking into account my experience? And I'd like to know, will learning WPF improve my skills in ASP.NET and the like?
I read a text file every second..[code]The file is generated from another program and it's costantly updated more times per second.The sense of the code (StartIndex) is to read only the rows that I have not read from the last time.The code works without problems until the file is about 2.5 Mb in dimensions... for higher dimensions I have problems and all becomes very slow.Using and fs.Dispose() are like Microsoft suggest (and in fact if i run the code analisys I have no problems), but surely the problem is not here.The question is: is my code right or there is way to improve the reading?? Is there way to read only the tail without to open the whole file?
View 5 RepliesI am having a problem in paging for XtraReports. How can I improve the report paging from runtime and also I would like to initialize the reportviewer from pageload.We are designing the reports from runtime , so the data on multiple pages is not working i mean I am not comfortable with it. I woulld like to do paging and limit the number of records on the page from runtime.for example i would like to add a PageInfo component and add a "Go to page no.." like this.
View 1 RepliesI'm currently in a programing class for vb.net. It's my first true exposure to OOP and I'm looking for some advice on areas where I could improve. I was wondering if someone would be willing to look at one of my programs that I have written and offer advice on areas where I can improve and things that I made much more complicated than they need to be. I'm not looking for a line by line critique just a general look at things to improve upon in the future.
View 2 Repliesi'm developing vb.net application. There are 10 ways of transactions. I want to produce 'Purchase register report'. For that I want to find what amount of effect has been made by each transaction on ledgers of 'Purchase account'. Purchase account has almost 30 ledgers. And transactions can produce about 10000 rows in database for a year. Now if I produce month wise report for a year, there will be 10000*30=300000 row scanning which makes it very slow in execution.
View 6 RepliesI'm currently writing a football management game (Australian football) and would like to pretty it up a bit. The match engine simulates each player as a small circle, much like the old Championship Manager games. While I'm fine with this style, I'd like to improve the look. I'm just using the simple graphics tools in VB to draw circles and the oval in the background which they play on. They move around using a timer. It just doesn't look very good. The movement isn't smooth and the circles look jaggy and unprofessional. Given that I'd ultimately like to release this product, I want to make it look a lot better.
What are some 2D graphics engines that I should look at? I don't need fancy animations or anything, just some nice smooth movement and nice looking circles. Doesn't seem like I'm asking for much does it? It'd be also nice if I could add in a chrome-like look or something along those lines.
As for the menus and such, well, they are currently just the boring grey VB style. That's fine for now but, as mentioned earlier, I want to release this game at some point. How can I change all of the menus and such so that this doesn't look like a game made in visual basic...basically. I've seen skins before but I'm not really interested in giving my game some generic style. I want to be able to customize all of it for myself. I just don't know how to! Simply fiddling with the colours and fonts of the default VB controls isn't enough.
I've a class that has a list of IDs with a function for adding new IDs from a list of objects.I've got this resolved, but I'm sure this can be done with much less code.Public Class Page
Private _IdList As List(Of Integer)
Private _HasNewItems As Boolean = False
Public Sub AddItems(ByVal Items As List(Of Item))
Dim itemsID = From itemX In Items _
Select itemX.ID
[Code]...
In Reporting Service, I need to have a vertical, starting at bottom, bottom-to-top, horizontally middle aligned text.The only way to do this is to create an image in code, and set this image into the title column.See the code below.Basically, it works fine, just that the anti-alias quality is pretty crappy.Is there anything I can do to improve it ?The vertical text is somehow pale, and not full black, and also there is smearing all around the text, in the background color.As well as it appears bolder than the text on the left, but both have format arial, size 8, bold I've tried all other values of System.Drawing.Text.TextRenderingHint.*, as well as no anti-alias at all but the current one seems to be the least crappy.I've also tried to change the image format, to no avail:
Function LoadImage2(ByVal sImageText As String, ByVal sImageTextMax As String) As System.Drawing.Image
sImageTextMax = sImageTextMax.PadRight(15)
Dim iFontSize As Integer = 8 '//Change this as needed
[code]....
I'm trying to improve my app with some error catching. I have a module that downloads a file from the Internet to a local folder. At the moment, if the local folder doesn't exist, it just crashes here:
strLocalFile = New FileStream(pPath, FileMode.Create, FileAccess.Write, FileShare.None)
with error:
System.IO.DirectoryNotFoundException was unhandled
Message="Could not find a part of the path 'C:Documents and SettingsSimonDesktop estdownload.zip'."
Source="mscorlib"
How can I do something with that error and stop my app from crashing? Ideally, have a messagebox show saying 'directory not found' or similar.
I am doing a project of inserting the data into the database through the used of textbox. I am using 5 textboxes when I run the application. The application is working fine but the problems is that when I post this codes, there is answer that I have to modify the inserting part to make it better. Is there any other way to make it better for the part when I am inserting the data? The program that I am using to make this application is visual studios 2005 and sql server 2005 for the database.
Imports
System.Windows.Forms
Imports
System.Data.SqlClient
[code]....
I am writing a VB.NET app that connects to a legacy application using TCP.
The communication is working fine and is very quick once connected, but there is always a delay (of around 2.5-3.5 seconds) when I create the new connection even though I am connecting to my local machine[code]...
I have this block of code that splits txt/csv files. It is working just fine but its a but "ghetto"
[Code]...
I have an application in VS (vb) with a database in Access 2007. In the application I have some search functions. They were running very slow until recently when I played around with access andthe indexes. I found that made great improvement in speed. But as the application is running the speed of the searc function diminishes.how to improve speed of the search function and make my database provide faster results.
View 6 Replies
