HD Land's Q&A profile

• Visual Basic Searching a Database

  Hi, I have a table within a database which is organised by date. I wish to write a program which will allow the user to select a date using the month callender control which will then will automatically search the database for selected date and dispay in a text box the contents of the fields in the same row as the date. How could I go about doing this. Many thanks Well if you are filling your records in a dataset using a dataAdapter for example, just query through it using a rowfilter. Example: Dim theResults as new DataView(theDataSet.Tables(0)) theResults.RowFilter = "[DateField ] >= dateEntered" the results will be stored in "theResults" and you would have to bin ...Show All

• SQL Server windows control library in a webpage accessing sql has a security error

  I know this should be the easiest thing in the world but I cant seem to find out how to allow my windows control library dll which is loaded in a webpage to access sql. It works perfectly from within visual studio though, what do I need to do allow my webpage dll to access sql without throwing a security exception Any links or help would be greatly appreciated. Are you using integrated security (what's the connection string Does it have a username/password there ). Probably you ARE using integrated security - in that case the user being used to call sql is the one configured on iis to run the website. Give permissions on the database for that (iis's website) user, or create an application pool usin ...Show All

• Smart Device Development Notification and Radio buttons

  Hi, i've a notification with 2/3 radio buttons and one button. I can get the selected item through WM_NOTIFY and SHNN_LINKSEL clicking on button. I would like to know how get selected item clicking on softkey menu (like in wifi network availables notification for example) Any idea Thanks in advance Sir I have similar problem.I am drawing radio buttons using Owner DrawItem Method in MFC......When we try to do the event handling then both are get selected....the selection has to be one out of 2 /3/4......I need a soution in connection with the same...... I am using CMyButtonclass(for eg) derived from CButton Class from MFC and using DrawItem method for dra ...Show All

• Windows Forms Tab Based MDI

  Hi All The application I'm working on currently has multiple forms/instances of the same form open at once. Rather then have the user minimise and maximise each window each time they want to look at it, I want to create some kind of Tab-Based MDI, similar to the one used in Visual Studio 05 and applications like Dreamweaver etc. How do I go about creating something like this Thanks! My suggestion would be to create a TabStrip and use it as the parent container for each subform.  Each subform should be docked with DockStyle.Fill in the container.  The TabStrip's change event can determine which subform should be visible. [Edit: this isn't doable.  My post below is more appropriate.] ...Show All

• Windows Forms Fatal Execution Engine Error when working With Form in Design View

  I have an application in VS2005 using XP Pro that hangs when I click on a particular form in design mode. The form has a tabControl with multiple TableAdapters. The application compiles and runs fine but I cannot click on the form in development. I've even tried in SafeMode with no success. I've tried on different machines with no success. What is wrong here Below is my error: .NET Runtime version 2.0.50727.42 - Fatal Execution Engine Error (7A2B45A2) (0) Hanging application devenv.exe, version 8.0.50727.42, hang module hungapp, version 0.0.0.0, hang address 0x00000000. as near as we can figure it has to do with serialization of the controls. Code is written behind the scenes that does not ...Show All

• .NET Development ExecuteNonQuery not working within CLR Stored Procedure

  I've written a CLR stored procedure that pulls the results from a SQL stored procedure using a SqlDataReader. I send out the information via a web service and then try to log information returned by the web service using another SQL stored procedure via the SqlCommand.ExecuteNonQuery method. The information never gets written back and I get no exception. Any thoughts on how I can get this to work Thanks. CLR UDF code: [SqlFunction(FillRowMethodName = "FillRow", TableDefinition = "AccountNumber decimal (18, 0)," + "PurchaseOrder nvarchar (50)," + "OrderDate decimal (18, 0)," + "OrderTime decimal (18, 0)," + "VendorCode nvarchar (50)," + ...Show All

• Visual Studio Express Editions Can't find compiled program

  I compiled the Hello World program with no erors, but i can't find the .exe file for the program Kyle Mck, Do you know where you stored the whole project If you stored the project bu default, the folder is in the following path: C:\Documents and Settings\[Your Login Name]\My Documents\Visual Studio 2005\Projects When you open it, you will find many folders which contains all the projects you have compiled. For example, if you project is called HelloWorld, the exe file is in HelloWorld\HelloWorld\bin\Debug. Use the command line of SDK Command Prompt, when you compile the project here by the cvb command line, you will also get the exe file in this folder: C:\Program Files\Microsoft Visual Studio ...Show All

• SQL Server PLEASE HELP!!!! MDX-EXPERTS!!! LOCAL CUBE SECURITY

  Hi, I read in the following article http://sqljunkies.com/WebLog/mosha/search.aspx q=local+cube&p=1 that the standard security model of SSAS 2005 is not applicable to a local cube. I have to deliver local cubes for users with different credentials. When the sales managers can see all the sales data of the Company, the Sales Representatives can only see all the sales data of his customers (even if the sales are generated from other Sales Reps). How can I create the local cube for my Sales Reps following these requirements I have a Sales Reps dimension, a Customer dimension and a Sales fact through which the relation between a customer and a Sales Reps exist. I hope you can advice me because I'm really stuck. FYI I'm new i ...Show All

• .NET Development Installer for pocket PC

  Hi I am developing an aplication for pocket PC in VB.NET . I want to make one installer for my application . I added one setup project and one cab project , but i am using one dll written in vc++ While running after adding the dll , it shows an error "the dll is not an window image " so let me know how to integrate that dll in the setup. Please repost to the .NET Compact Framework forum http://forums.microsoft.com/msdn/showforum.aspx forumid=33&siteid=1 ...Show All

• .NET Development Reading any file format with FileStream

  I want to be able to send ANY type of file (Text, .Doc, .Zip,. Etc.) with sockets. Everything seems to be going as planned, except when I read the file, the bytes are little bit different. How can I correctly read (ANY) file, for transferring over sockets Real Line 1 of File: +o[C€‥46( § cgZ C)E xn[y"QO Cp After reading with code below: +o[C (46( ,' cgZ6C)K xn["QS Cp It seems I am reading the file wrong. Only a few characters are not being read correctly. Here is the basic code for reading the file: fs = File.OpenRead(@"c:\mailroot\MENU.pdf"); br = new BinaryReader(fs); byte [] currentBuffer = new byte [1019]; currentBuffer = br.ReadBytes(currentBuffer.Length-5); Logger.Log(Encoding.ASCII.GetS ...Show All

• SQL Server Broken BI Studio after Office 2k7 install

  After an install of Office 2k7 last night, I'm getting some errors in my event log when i run BI Studio. The errors occur when i click a tab that tries to browse the metadata of the cube. IE: The calculations tab, or KPI's, etc.. These are the 2 errors: Event Type: Error Event Source: MSOLAP$LocalCube Event Category: (289) Event ID: 1 Date: 1/09/07 Time: 8:54:08 AM User: N/A Computer: WS124 Description: The description for Event ID ( 1 ) in Source ( MSOLAP$LocalCube ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The f ...Show All

• Visual Studio 2008 (Pre-release) Writing about performance?

  Hello! How is it now, we may not write about performance issues here, but should write about such things to the Microsoft Connect forum, or may we write about performance aspects here as well Best regards, Henrik Dahl Thanks Henrik. We will investigate this matter. BTW, I did not know that one could attach files (e.g., zipped) to posts. I had not noticed the little attachment icon. If you want to do that in your previous post, that would also be fine. ...Show All

• SQL Server InfoPath 2003, Shape, Order by, two tables, can't get sort to work

  InfoPath 2003 I have an Infopath form to edit the values in the NotifyMembers table. I want to list the email addresses alphabetically when the query returns data to the form. Unfortunately, I use EmailAddressID as an int in the table, so I need to join the NotifyMember table with the EMailAddress table, which has a column EMail which is the address. Both have EmailAddressID as common fields. I can't get the Shape command (edit SQL in the Datasource) to be happy with any syntax that I have tried. For (non-working) example: select "GroupCode","EmailAddressID","DelBit" from "dbo"."NotifyMembers" as "NotifyMembers" Join "dbo"."NotifyMembers"."Emai ...Show All

• Visual C++ Generating XML Files

  How to generate XML files from C++/VC++ Is there any library available or we have to write each element ourselves I agree, that if you want to read/write a simgle XML file, a few tags, perhaps no attributes, is simpler to code that yourself, and not use a library such as MSXML or Xerces. However, if the format of the XML file is getting complicated, such a library is much more in handy. ...Show All

• Smart Device Development Problem with an existing connection was forcibly closed by the remote host

  Hi, I got a very strange problem on WM5. My code works fine on PC2002, PC2003, .NET1.1 (WinXP) but it does not on WM5. The code works fine when I query a web-site that respondes with Keep-Alive tag and it doesn't work when a web-site respondes with Proxy-Connection : Close. The code is very simple - it accepts connections and for each connection creates two sockets, one is accepted socket and the other soket is to a proxy server. Then the code just passes queries-responses between browser on PDA and the proxy server. There are 2 threads per connection, one thread reads from browser and writes to my proxy server, another thread reads from the proxy and writes to the browser. I have removed all unnecessary code t ...Show All