how i see if my cache is empty all my syntax errors are coming when i am trying to see if the cache is null and if it is to run the stored procedure
If RadioButtonList1.SelectedIndex = 0 Then
If Cache["netcache"] = null Then
bcmd.CommandText = "yearlynetsales"
[Code].....
I have a datagridview bound to a datatable setting its datasource property to the datatable. I would like to have a child form that contains a list of columns associated with the datatable that contains a checkbox that will allow the user to hide and show the columns ( I do not know the best control to use here) (I assume this is the easy part as All i need to do is loop through each of the datatable's columns to get the column name)
now I would like save these visible columns on some event like form_closing so that the next time the user opens the form up it will remember the settings
I have the following code in my config.vb file in app folder and almost all of my pages use this code for permormance issues i need to have it cached for exp use cache.insert to cache each property How should i use caching?
BR>Public Class Config
Private _physicalPath As String
Public Property physicalPath() As String
[CODE]..........................
I just need to set the archive bit on a file. I see the archive attribute in the FileInfo object which I would think allows me to read the state of the bit, but I'm not sure how I would actually set it.
View 2 RepliesFirst off a great piece of code [URL] you saved me soooo much time. I am a somewhat newbee to VB2010 and was wondering how would i go about setting lets say setting column(4) to a date format so that i can get it to sort in the correct order.
View 8 Repliesadding to the binding source then setting the combobox to selectedIndex of newly added row is not working.the new row is in there but it does not set the selectedIndex to the specified index. but if I run the code a second time it selects it.what can i do to make sure the combo uses the specified index?
Dim drv As DataRowView = CType(Dispatch.M8CustomersBindingSource.AddNew(), DataRowView)
drv("custID") = "999999"
drv("CustomerName") = "Select Customer"
[code].....
I need to retrieve a portion of xml into a datatable
<Product>
-<productID>123</productID>
-<productName>123</productName>[code]......
Now Under product tag there are ProductID, ProductName and ProductFeatures.Under ProductFeatures tag there are three "productfeaturetext" tags.I only need to extract "Features" tag into a datatable to loop it, how this can be done ?
I am trying to write a countdown timer I finally succeeded with MSDN. I get to work whatever I wanted, but this drives me nuts: How can I read and set the volume control? I want, once my timer is run down to zero, read out the current system setting, then play a system sound using
Media.SystemSounds.Exclamation.Play()
Over time I like to ramp up the volume to 80% or until one clicks the Alarm off button (then stop the timer, no sound, and reset volume).
I have a button which reads a comma separated value file and loads it into a richtextbox. Each line contains comma separated chars.
Once the file is loaded in the richtextbox, i want to be able to select specific values from each line and store them into an array.
For example:
Line1: a,b,c,d,e
I want to be able to place only the values "b" and "c" into an array.
I was thinking something like creating a menu for the richtextbox which will be triggered on right click, then highlight the values I want, press right click and select 'place these values in an array'.
it doesn't have to be the way i proposed it, but it definitely must use a richtextbox.
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 RepliesMy program reads a 3rd party .txt file using OleDb and reads the file into a datatable. It's overall working fine except a user will occasionally have a problem reading a file. At this point.
Line that gets hung up
Try
Dim comm1 As New OleDbCommand("SELECT * FROM " & safeFileName & " Where " & Status & " = '" & StatusClosed & "'", con)
Dim dasold As New OleDbDataAdapter(comm1)
dasold.Fill(dtsold)
AddColsold()
[Code] .....
It can not retrieve a date for one of the fields, then gives error and does not get dates for each records after the one it gets hung up on but the date is in the file. If I open the file in excel and play with the column sizing, for instance just autoformat column width then it read the date and will work fine. I have looked at the file in notepad and cant see anything wrong in particular on the record it gets hung up on. I have no control over the .txt file since it comes form a 3rd party.
I have an untyped-Dataset with two related DataTables, and I have a grid bound to the parent DataTable. I used the WriteXMLSchema() method of the parent DataTable in order to save the schema in a xml file. Then I opened the file with the Notepad, deleted two columns from the schema file and saved it. After that, I used the ReadXMLSchema() of this DataTable but -contrary to what I would have thought- the DataTable's structure was unchanged. Using the debugger I noticed that after calling the method the number of columns was the same. Why? How can I make the DataTable's schema to be changed by using a file?
notice that I am using the DataTable's methods and not the Dataset's because I do not want to touch the child DataTable.
Dim ds As New DataSet
Dim xmlfile As XDocument = XDocument.Load("devices.xml")
Dim reader As XmlReader = xmlfile.CreateReader
[code].....
I 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]...
Question 1: What is the difference between "Background Worker" and "Worker Pool" as indicated within the MSDN samples provided.
Question 2: I noticed while using, AddressOf _Function_, variables cannot be passed; what would be an efficient solution to this?
Question 3: While using multithreading is it required to invoke before setting variables, or only form properties?
Question 4: While using System.Net.Sockets is it safe/efficient to use Application.DoEvents while waiting for new data; or would be using a Do While loop be fine without DoEvents since the action would be multithreaded? Note: there can be up to 2000-3000 sockets in use at a time.
Heres the InnerException:{"Unable to read data from the transport connection: A blocking operation was interrupted by a call to WSACancelBlockingCall."}Stack Trace:
" at MyNetworkStream.HandleOrRethrowException(Exception e) at MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count) at
[code].....
I've been searching but just can't seem to find an answer. I can't believe this should be hard but I just can't get it to work. I'm reading in some records from an Access DB into a DataTable. I list one of the columns in a listbox. The user selects an item, then I want a textbox to display what's in a different column for that row.
[Code]...
I have an application that allows users to bid on items that are put up in an online silent auction type of deal. Currently, When a user clicks submitBidButton, the application stores the bid in the database, and then updates the price. Sounds simple? It was.. until it got popular. If there is a bidding war on the page, my application, and SQL database start crying.. literally.
About consuming the data with jquery/JSON.. and WebMethod. It works like a champ. BUT. How can I take advantage of Caching to increase the performance of my application? SQL Caching? Asp.NET Caching?
Each member places a bid, and I want to add a ajax timer that calls back to the server every .5 seconds to see if a user has placed another bid. The app was built in vb.net.
I have 2 dll files from a third party, and they have the same name (v7 and v8). My program needs to be able to use both of these dll's (meaning wether the enduser has a lisence for v7 or v8 of the thirdparty dll, they can still use the program). But I am stopped from referencing both of them as they have the same name. How do I resolve this? Searched the web and found info about sn.exe and strong names, but can't find a good explanation of how this works. Anyone?
View 5 RepliesI'm working on a program but i'm having a small problem. I need to search the IE cache for multiple URL's that contain a specific string. [code]....
View 2 RepliesAnyone know how to read the ARP cache in VB or .net?jj
View 7 Repliese.g.
Abcdefg.vbproj.GenerateResource.Cache
I need help and wondering if you can help me to get my first project...it's a hobby and wondering if you can get me code for this so i can see how it does it* Evaluate( ) Prints the evaluation of the hand to the evaluation Label.
o If IsFlush( ), prints "flush; "
o calls SetPipArray( )
o Uses a For Loop to go through pipArray. For each element, uses a Select Case statement to
[code]....
I have a function GetAllProducts() which fetches all products from a database and stores it in the cache for future requests. This works fine, but if I then call the function e.g. ProductSearchResults = GetAllProducts(), and then modify ProductSearchResults variable, this also modifies the cache, which is very important this never happens, as the cache affects the whole website.
I understand this is because both ProductSearchResults and the cache now have the same reference, but how do I solve the problem? Is there something that I can put in GetAllProducts() to ensure the cache always uses its own value?
CODE:
If you build and deploy UserControls, Components etc do you give them strong names and put them in the GAC or do you simply place them in the same folder as the executable?I've made a component that will be given to other developers and they will, in turn, deploy it with their own applications. If I give my component a strong name and install it into the developer's GAC then I assume that the developer using my component will also need to place it in 'his' customer's CAG when he deploys his own application containing my component.
View 2 RepliesI am working on a web based project using .net 2.0. I dont want my pages to be stored in cache or internet history.
View 2 RepliesTwo separate but related questions about deploying a Visual Basic 2008 .net application:1. Click One installs in a cache under local data. The EXE launches from the cache even if not on-line. I don't want my users to have a runnable EXE left over in their cache after exiting the program. Is there a way to delete or disable the cache contents on close of app or equivalent?
2. My EXE uses an interop DLL. I want my EXE to be a single stand-alone file so that I don't have to copy both the EXE and the DLL to the user. Is there a compile setting to incorporate everything, includng the DLL, into the EXE.First question relates to Click Once Web deployment. Second question refers ONLY to ordinary COMPILE, not click-once.
I am currently developing a advanced web browser in Visual Studio 2008. I was reading information about a browser i currently use, it said that the browser goes faster thanks to a "advanced cache algorithm". I was wondering if it was possible to implement this into my web browser, and if so how would i do so? I am using Visual Studio 2008 writing in .Net.
View 3 RepliesHow can I clear my cache using VB.Net? I'm making a web browser, and this function would be nice. I've tried this to no avail:
Response.Cache.SetCacheability(HttpCacheability.NoCache);
In our projects we use setting variables to store user setting for the applications. Moreover, with every latest version of the applications, we upgrade these variables to retain user settings.Normally, this works fine, but recently one of my end user reported an error i.e.Configuration System failed to initialize". The error is related to user.config file. Therefore we requested the user to send us his file.After received the folder, we noticed that it contains 3 files (3begfjb.newcfg,3begfjb.tmp and user. config). 3begfjb.tmp is an empty file, while 3begfjb.newcfg and user.config are identical files. We tried to open these files but the data in user.config isn't proper xml rather its unreadable formatted file.Do any you guys had experienced this sort of issue or any ideas how and what may have created these files and corrupted user.config file.
View 3 Replies