FredK5813's Q&A profile

• SQL Server Problem with CASE Expression

  Hi, all here, I have a problem with CASE expression in my SQL staments. the problem is: when I tried to just partly update the column a , I used the CASE expression : set a=case when b=null then 'null' end the result was strange: then all the values for column a turned to null . so what is the problem tho Thanks a lot in advance for any guidance. Is it something like this you're trying to do create table #x ( a in ...Show All

• Visual Basic Is is possible to write a macro to alter the company information in the properties within word

  Hello, I am currently working on a problem for a Client.  We offer a service using Word. When the Client downloads a Word document via our website our company name appears in the properties option from the file menu, which is obviously undesirable for the company using the document. Is it possible to write a VB macro that we can run to allow a different company name to be displayed   We can then use the code to change the company nam ...Show All

• Smart Device Development SQL CE Merge Replicate without IIS

  Is it possible to do a SQL CE Merge Replicate without IIS   IIS is a bit of a security hole from time to time, and I'd rather just do a direct sync with SQL Server. Thanks. ...Show All

• Visual Studio Express Editions database saga

  I am at my wits end. I am trying to create a program that will add users to a database. I have read the various posts regarding the output file and have changed the Copy To Output File to Copy Never. I have also tried Copy If Newer. The database still does not retain my changes/additions. The code I have used is shown below. Code Here... Private Sub AddUser_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AddUser ...Show All

• Visual Basic How to download a file?

  Hello Please help me to downlaod a file with visual basic 6.0 Thanks I am sorry this forum is not for vb6 questions please try one of the newsgroups . ...Show All

• .NET Development Finally not called unless exception caught outside?

  Is it expected that the code inside a finally block is not executed when the exception is not caught elsewhere Or perhaps I am seeing something else... in the following the code in the finally is never executed: Have you stepped through the debugger, or just run the program I suspect that the thrown exception is stopping the console app long enough for you to see that the finally block was executed. No - I am wrong.  Your basic pr ...Show All

• Visual Studio Express Editions VB + SQL server vs Access

  I am very new to programming etc so I may be misunderstanding the situation, but my question is this: VB.Net Express is a programming language which comes with database functionality via SQL Server Express, whereas Access is a Database which is programmable via VBA. So, if one is developing a (fairly simple) database based application what are the pros and cons of using one set of software tools versus the other Thanks for any insights. Eric ...Show All

• Windows Forms How to get a value from BindingSource?

  Hi all, I have a DataSet connected to Access database and CarsBindingSource where datasource is set to DataSet and represents table Cars. So, is there any way to get a value from database via BindingSource (like recordset) E.g. I want to put a value from database - table: Cars - column: Type (at actual BindingSource position) to ComboBox. Something like: Cbo.items.add (CarsBindingSource.Items("Type").Value) doesn't exist ...Show All

• Visual Studio Express Editions VWD 2005 Express

  After installing VWD 2005 Express, I get the following every time I start Word or Excel 2003: Please wait while Windows Visual Web Developer 2005 Express Edition - ENU Then: The feature you are trying to use is on a network resource that is unavailable. Click OK to try again, or enter an alternate path to a folder containing the installation package 'VNSSetup.msi' in the box below. If I point to the file, it tries to install somethin ...Show All

• Visual Basic Copying data from one listbox to another

  Does anyone have idea the best way to copy the data that is in one listbox to another one Hi there, Well the .Items property of a list box is read-only so you can't do something like: ListBox2.Items = ListBox1.Items Whenever I have to do this a loop seems the easiest way: Dim iter As Integer For iter = 0 To (ListBox1.Items.Count - 1) ListBox2.Items.Add(ListBox1.Items.Item(iter)) Next I'm sure one of th ...Show All

• .NET Development Connecting to a database and parameters in sql

  Hi, I am creating a small web app, that searchs a database depending on the information the user enters onto the web form. I create the connection to the database by using the visual studio wizards by binding the data top a grid view. Below is my code SqlParameter word1 = new SqlParameter(); word1.ParameterName = "@tb_1"; word1.Value = TextBox1; SqlCommand cmd = new SqlCommand("SELECT * FROM ApprovedComponents WHERE Vendor = @t ...Show All

• Visual C++ #import no longer works

  Hi there I have been using a COM DLL in VS .NET 2003 and it has worked fine. I create a reference in the solution explorer and add a #import statement at the top of the form.h file, add a var which is a pointer to the "command interface" of the DLL and it all just works. I've been struggling to do the same under VC++ 2005 and it just seems to be completely different. Using a #import statement generates the following error: #import is not suppor ...Show All

• Visual C++ SetWindowLong with Class Member function

  Here is the skeleton of my class class MenuBar { private: WNDPROC oldWndProc; public: LRESULT CALLBACK newWindowProc(HWND hWnd, UINT wMsg, WPARAM wParam, LPARAM lParam) { } BOOL CMenuBar::CreateMenuBar(SHMENUBARINFO *mbInfo) { if( ! ::SHCreateMenuBar(mbInfo) ) return -1; if (mbInfo->hwndMB ) { oldWndProc = (WNDPROC)::SetWindowLong(mbInfo->hwndMB,GWL_WNDPROC, (long) newWindowProc); } } }; -------- The compiler is giving me t ...Show All

• Windows Forms Big Problem, I think it's bug

  -VS2005 RC -Framework 2.0 release When I close a form with bindining datasource on it, I have this error.   An unhandled exception of type 'System.ArgumentException' occurred in System.Windows.Forms.dll Additional information: Sort string contains a property that is not in the IBindingList. Yes,I have the same problem. It only happened on my first table in my DataSet. If I remove the sorting string,the problem disappeared ...Show All

• SQL Server Is (local) really local?

  I have one outstanding problem to address before I can ship my product. In all my searches, I have not seen this problem mentioned. It seems that you guys are my last hope. Sorry if it has already been asked and answered. When connecting locally to a named SQL 2000 instance (SP2, SP3, SP3a, and SP4), I am noticing a lot of network traffic that I can't explain. It happens on every machine I've tried. Here is the setup: Conn. Stri ...Show All