andrewajc's Q&A profile

• Visual Studio Express Editions Clear a file from cache

  I have a program that filters an online database then downloads a CSV file from a webserver. Then I download the file to my hard drive. I then want to able to change the filter parameters thus recreating the CSV file on the server and redownload it. however, for some reason, the program just copies the one from cache over to the destination location rather than getting the brand new one. How do I - a) Clear it from cache or b) Make it get the new one and overwrite the one stored locally Currently, the only way this works is when I close down the program and then reopen it. I want to avoid that. I'm using the URLDownloadToFile API to get the CSV file. All help appreciated Andy hmmm. I think im missing something here. Why dont you down ...Show All

• .NET Development Data Access Layer - Design

  Hi I have been reading a few of the recent tutrials on 3 tier design (Data/Business/Presentation). In My database i have a customers table, employee tabel, supplier table and an address table which has either a customer, employee or supplier foreign key. In these tutorials it says that each database able should only be access by 1 data access layer class. If this is true then how is it possible with this database stucture, for example my Orders DAL needs to know about an address because each order has a billing, and send to address. But also my Customer DAL needs to know about address as each customer can have many address's Thanks lee Hi fmardani Sorry i suppose i did not write it very clear, what i am doing is the op ...Show All

• Windows Forms done!! Change backcolor on Edited Cells in DataGrid 1.1

  hi, I have an editable datagrid in my app. When the user edits a cell i would like the backcolor of that cell to change.This is to be done so that the user can easily review the changes before submitting them to the database Will i need to override PaintText . any inputs to point me in the right direction would be appreciated (Using 1.1 Winform DataGrid) thanks Rohan Wali You can change the back of the cell from any where not only from paint. DataGridView1.Rows[0] .Cells [0] .Style.BackColor = Color.Red; But before u change it make sure that you are able to catch correct rowindex and columnindex. This you can do in mousedownevent or keypress event And now after getting the row and column index, during onmouseleave event change the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Playing (avi) video's in XNA?

  I would like to play a little into-video before my game starts, its simple and small and it's an avi (though I could easily change its format), how do I play it with XNA MDX used to have AudioVideo playback, but I can't find that in XNA. I was wondering if there may be some way for the XNA team to leverage the work that is being done in WPF/E to play back WMV files. For those that aren't familiar with WPF/E it's basically a Flash alternative written on top of a micro .Net Framework and from what I have read it includes a built-in codec for WMV playback. Bill ...Show All

• .NET Development NET 1.1 AND 2.0 UNINSTALL/FIX/INSTALL/UPDATE INOP

  I can not do a thing with these programs. Totally hosed! My other 3 computers seem to be fine, but there is a problem when you can not remove a program in safe mode. This has to be a very common problem and where is the fix Update fails also for .net. it may not be a common problem :-) can you explain any error messages you have What are they Why can't you uninstall them from outside of safe mode - in other words within Windows normal boot up mode ...Show All

• Windows Forms Why the WebBrowser vertical scrollbar is always shown?

  Hello, I'm wondering if I can hide it when there's no big contents that require a scrollbar. Is that possible Thanks. Hello everyone, This property is useful when the content is short. If you go from short contents to longe one, you wont able to see some contents if I set scrollbars disable. Is there any way to show the as I need (e.g. show the scrollbars when the contents is too long and hide it when it is short.) Thanks ...Show All

• Visual Basic UserControl in StatusStrip

  Hoping someone can help me figure out how to add a Usercontrol into StatusStrip. There seems no obvious way in which to add any controls other than the default ones allowed through the Items Collection Editor. Hi, the key here is to use the ToolStripHost class , which would host your user control. This MSDN's How To article will guide you through the process of generating a wrapper around your control, allowing you to put in on your status strip. Andrej ...Show All

• Visual Studio 2008 (Pre-release) Unlimited LifeTime of WCF Services

  My client stops working if I leave it unattended for sometimes. I do not want this to happen. What is the way I can do I create a static field, and then create the field once and the use use for as many as I want. Here is the code: if (iCustomerInvoice == null ) { iCustomerInvoice = new ChannelFactory <Company.Common.Interfaces. ICustomerInvoiceSystem >( Binding, GetEndingAddress( "ICustomerInvoiceSystem" )).CreateChannel(); SetToken(iCustomerInvoice);//to set the token of the login for the customer! Is there a better way } I use iCustomerInvoice for the lifeTime. But this iCustomerInvoice stops working after a while. I am using PerSession. First, make sure you've defined your binding ...Show All

• Visual C++ CProgressDlg - is it available in VC2005

  I remember that in VC 6 you could go to PROJECT | ADD| COMPONENTS AND CONTROLS and select a progress dialog, I cannot seem to find this in vc 2005, does anyone know if this is still available or has it been replaced. It used to generate a CProgressDlg class. Thanks in Advance! I see the same CProgressCtrl based progress bar when I use the ActiveX control Wizard. I am specifically talking about the "progress dialog" component which was available in VC6 under Project|Add|Components and Controls....it was based on a CProgressDlg class, I dont even see this class in the list of MFC classes in VC2005, so is it no longer part of MFC after VC6 Anyone know anything about the "CProgressDlg" c ...Show All

• SQL Server How to export attachments from SQL Server 2005

  I’m storing file attachments (.txt, .pdf, .doc, etc.) in a table with a varbinary(max) column. Now I need to export the attachments and E-mail the files; any suggestions on the syntax that I would need to export to a given file During my research I found the following: You could then use SSIS's Export Column task to export the data from these rows into external files again, assuming you added a file path and name column for the transformation to use. Anyone know the next step Thanks in advance for your help. hi you can use BCP & DTS & ... for more info visit: http://www.sqlteam.com/item.asp ItemID=242 and more: http://www.sqlteam.com/item.asp ItemID=4722 good luck ...Show All

• SQL Server Hierachy drill down stops at point

  I have the following scenario I have a Staff Parent child hierarchy and that links down to a division. A staf member is in charge of a division but we want the managers to drill down into the children and see which divisions they are in charge of etc. So here is what the data looks like Staff Lev1 | Staff Lev2 | Staff Lev3 | Staff Lev4 | Division | Value ------------|------- -------|--------------|-- ------------|----------- |--------- A | B | C | D | DivA | 1000 A | E | | DivB | 2000 the problem is, with drilling down though the staff hierarchy I can never see DivB, I can see the value associated to the Staff member E but when I try drill down it j ...Show All

• Visual Studio Express Editions OK...Maybe I didnt make myself clear

  Ok, I cant believe at MSDN forums there is NOBODY who can tell me how to compile and execute an ansi console C++ program which works in borland C++ builder and any other standard c++ compiler!!! Or is VC++ express 2005 incompatible with standard C++ and only a vehicle to push microsoft's bastardization of any coding standard it comes across The code below, which would be written by a first-year college undergraduate fails to link (with heaps of errors about loading CRT libs when surely none should be needed!!) in VC++ 2005 express!!!! #include <iostream> using namespace std; int main(){ cout << "Hello World" << endl; return 0; } A supposedly cutting edge IDE should compile a simple, basic, easy, trivial, m ...Show All

• Windows Forms Build a Query from form

  Help, please... I have made a form with a list box that users can select a name from which creates a query with one column containing the list box selection. I now want to add a text box to the form, which once the button is pressed will add another column to the query creating an AND query which will also filter results with the date (text box entry) and name selected from the list. How do i do this, spent hours on it:) the code for the form is as follows: Option Compare Database Private Sub cmdOpenQuery_Click() On Error GoTo Err_cmdOpenQuery_Click Dim i As Integer Dim strSQL As String Dim strWhere As String Dim strIN As String Dim flgSelectAll As Boolean Dim varItem As Variant Set MyD ...Show All

• Visual Studio Express Editions Newbie: Resize a Captionless Forum

  Hi all. New guy here =D. I've been learning vb.net 2005 for about a week, and I think I've made relatively good progress. I've got to the point where I can drag my own form with no caption and skin it completely. My last hurdle is that I can not resize the Form with the caption set to None. Though I've seen ton's of software with no caption that can resize, I can't figure it out as of now. So if anyone has any information or tip's to accomplishing this, it would be greatly appreciated. Thank's in advance. Travis To resize a form: Me .Size = New Size(X, Y) works whether the form has a caption or not. Maybe I've misunderstood the question ...Show All

• Visual Studio Express Editions Problems when writing to textboxes from txt-file

  I brought this question up in another thread but the main question had allready been solved so I guess I better start a new thread. My problem is with a code that gives me the error " Object reference not set to an instance of an object". My code looks like this: Dim layerselect As String = layerbox.SelectedItem Dim strContents As String = My .Computer.FileSystem.ReadAllText(acadtroot + layerselect) Dim crlf() As String = {vbCrLf} Dim line As String () = strContents.Split(crlf, StringSplitOptions.None) Dim i As Integer For i = 0 To 5 Me .Controls( "L" & i + 1).Text = line(i) <-- Where the problem is pionted to Next ...Show All