Mystery's Q&A profile

• Visual Studio Express Editions Sql Express in Visual basic express

  Hi Is it possible to create a table in visual basic express with functions to calculate amounts in columns for example column 1+column2 =column3. I tried importing from excel to vb express but the excel I have is too outdated to work. I have gotten as far as creating the table but when it comes to adding "functions" to the table i havent got a clue Thank you What you are looking at is something called Computed Columns SQL Server 2000 does support them and I'm not aware of anything having changed to SQL server 2005. http://www.sqlservercentral.com/columnists/tchapman/complexcomputedcolumns.asp You may want to do a quick web search on SQL Express + Computed Columns Th ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Error 1920 - failed to install DX sdk

  "Error 1920.Service DirectX Debug Service (DXDebug) failed to start. Verify that you have sufficient privileges to start system services." When attempting install of the Direct X sdk - this question has been asked on this forum before but the solution presented did not work for me - Info - I'm using a games development PC, which has a ton of old software on it. I reinstalled Microsoft Visual C# 2005 express edition. No luck, same error on sdk. On my machine is something called Microsoft Visual Studio .NET Enterprise Architect 2003 - so I tried reinstalling / repairing that and after a while it asked me for a disk for a resource. I have no disks to go with this software - do I even need this Enterprise Architect software on ...Show All

• Community Chat VB.NET

  please does anyone know how to create a non visual class that has the behaviour to count characters, words, alphabets, vowels, consonants, digits thanks thanks alot for going out of your way to help me, i am still finding it a little difficult, probably because i didn't put my questions right.i am having a go at what you inially sent me but i have below the main question of what i have been trying to ask, i will be glad if you can help me with this one. Program specidfication 1. a mechanism for locating a file (e.g dialog box). 2. the file must be displayed on the GUI 3. the following statistics (i.e number of each) must be display; a. Words b. characters c.letters (a-z, A-Z) d. digits (0-9) e. ...Show All

• Commerce Server Taxation data

  Hi, following on from my previous question: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1094829&SiteID=1 I'm looking for the most suitable place to store tax rates. I thought of creating a new profile object but don't think that is the most efficient place to store the data. The tax rates need to be easily accessible for my tax pipeline, without having a large performance hit. Thanks in advance Paul Hey Paul, I've been out with the flu this week and I haven't had time to wrap everything up. If you can send me an email (colin.bowern@officialcommunity.com) I'll give you a drop of the code to look over and I'll get it posted in full this weekend. Thanks, Colin ...Show All

• Visual C++ Custom Dll with MFC linked

  Hello people! Now i have this tricky task: I would like to create a regular dll, but with MFC statically linked and initialized, to use the MFC classes. BUT the MFC library provides it's own DllMain. How can i override the MFC's DllMain, while still linked to MFC The reason i want to do that is that CWinApp doesn't give me an opportunity to handle the THREAD_ATTACH and THREAD_DETACH events. I DID IT But this was tough if you are interested, here is the code: BOOL WINAPI MyDllMain(HANDLE hDllHandle, DWORD dwReason, LPVOID lpreserved ) { BOOL retcode = TRUE; __try { if ( dwReason == DLL_PROCESS_ATTACH || dwReason == DLL_THREAD_ATTACH ) { if ( _pRawDllMain ) retcode = (*_pRawDllMain ...Show All

• Visual C# Want to run the job at 12am (Mid Night)

  Hi, I have been developed a window service that is send the email to all user in email list. Service is working properly. I set the sleep timer to 24 hours(24*60*60*1000). So service is start counting when start the service and then run the job at whenever completed 24 hours timer. But I only want to run the job at 12 am mid night (to avoid the peek hour) everyday. Please let me know how I do code. Thanks Alex Just check the current time.   DateTime.Now   you may want to place a time ticker (unsure if Windows Service project has this) and then set the interval to every hour then check on the hour if the Time is 12am (00:00)   on your time ticker tick event, get the current time: stri ...Show All

• Community Chat so the Zune's a flop

  or so says every review I have read. anyone have any sources saying otherwise installation HORROR stories. questionable collection of "features." incompatibility with WMP and pretty much any non-Zune marketplace source for music. handicapped wifi. I was on the verge of pre-ordering a Zune, but Microsoft has jaded me over the years, so I held off. I think I'm pretty happy with that decision. Zune owner here... Let's see, yes, it's not compatible with WMP even though WMP11 and the Zune software appear to be the same program(or dang close) just re-skinned with different features. WMP won't even acknowledge it as a device. There are those that seem to be having installation issues, but it al ...Show All

• Windows Forms how to move items from listbox to another listbox?

  I have 2 listboxs in webform is it possible let items transfer on each listbox and save final result to database for example: listbox1 have 2 items : Joan and ViVi listbox2 have 1 item : Kevin if I choose Joan from listbox1 and click bottn Joan will disapper from listbox1 and appear on listbox2 so that I have this result after click bottn listbox1 have 1 item: ViVi listbox2 have 2 item : Kevin and Joan ======================================= also I would like to know could I do a mutiple select and remove all items to another listbox at one time when I select Joan and ViVi from listbox1 and then click bottn , Joan and Vivi will be added to listbox2 and remove from listbox1 . I want the result to be l ...Show All

• Visual Studio Team System can not delete pagefile.sys

  Hi Guys, I don't know if this is the right place to post this issue. Please help. I have done some tweaking and reconfigured pagefile of our server. Previouly, the pagefile was distributed to different drives (6 drives in all). Now, I stored the pagefile on a single drive. After doing this, I noticed that the pagefile from the other drives still exist and I can't delete them. I want to delete this file on the other drives so I can free up some space but I couldn't. Please Help. Thanks, Larry ...Show All

• Visual C# ConfigurationSettings in with Remoting

  Good day ppl, What I'm trying to do is allow my user to edit certain settings in my config file for a .net remoting application i wrote. I know that ConfigurationSettings.AppSettings allows you to enter the AppSettings key. What i want to do is through code, be able to edit my config file keys like - "povider" and "formatter". Really all of this is just to change the port and minor settings. My point is, ConfigurationSettings.AppSettings, limits me to just the "AppSettings" key, and i need to kow how to edit the other keys. ConfigurationSettings.AppSettings is just for setting configration beforehand(and it is absolete now more info: http://msdn2.microsoft.com/en-us/library/system.configuration.conf ...Show All

• Windows Forms How to prevent ComboBox auto DropDown

  Hi, I'm writing a custom CheckedComboBox with a multiple item select future but when I select an item from the dropdown menu, the dropdown menu automatically closes. How can I keep it open to select more than one item thanks for any help. I think that you want something like this: protected override void WndProc(ref Message m) { if (m.Msg == (WM_REFLECT + WM_COMMAND)) { if (HIWORD((int)m.WParam) == CBN_DROPDOWN) { ShowDropDown(); return; } } base.WndProc(ref m); } public static int HIWORD(int n) { return (n >> 16) & 0xffff; } ...Show All

• Visual C# Retrieve network name?

  Is there a way to retrieve your wireless / LAN Network name like: linksys kirby ersnet1 Thanks, I dont think you can - if you are talking about the Router/switch names that have been assigned within the device. The way I think would be to do a shell out/telnet and perhaps the routers support a command to display its name. ...Show All

• Windows Forms ADO Control

  hi I have seen programs that bind a DataGrid to an ADO Data Control. But i want to know, how to display the fields in Edit Controls. Is there some way to bind the Edit control to the DataSource(ADO Control). DataGrid can set datasource that is source for the whole datagrid Normally we bind a whole table or view to the datagrid, then choose columns we need to display. what do you mean bind Edit control to source does it mean you want bind cell one by one please show me a little detail:) ...Show All

• Visual Studio Express Editions problem with property

  Can somebody tell me, why my compiler deosn't want to eat this: class Foo { public : float x,y; property float time { float get(){ return x*y;}; } }; There are two other solutions, too: With the comment /clr:oldSyntax I can do like that: __value class Foo { public : float x,y; __property float get_time(){ return x*y;}; }; Because I don't want to use both /clr and /clr:oldSyntax, I'll make it the classic way with __declspec: class Foo { public : float x,y; __declspec ( property (get=get_time)) float time; float get_time(){ return x*y;}; }; ...Show All

• .NET Development Excel import fails to import every row into a DataSet

  Basically I've tried both ODBC and OLeDB using Microsoft.Jet to load an excel file into a DataSet, everytime the file is over 254 lines it only retrieves the first 254 lines **unless** Excel has that file open, then it imports every line. Any Suggestions, the code is below //Code Start String connectionStringExcel = "Driver={Microsoft Excel Driver (*.xls)}; DBQ=" + textBox1.Text.ToString(); //set the excel file as a source OdbcConnection xlsfr = new OdbcConnection(connectionStringExcel); //set the statement to preform on the file OdbcDataAdapter xlsda = new OdbcDataAdapter("Select * From [sheet1$]", xlsfr); //preform the statement on the file into t ...Show All