Lord Zoltan's Q&A profile

• Windows Forms Populating Form Dynamically Via DataColumn Name

  I am frequently frustrated with having to drag textbox controls to a form, name them, align them, and bind each one individually to data. Now, I am trying to do this dynamically. I would like to use the TableLayoutPanel, loop through my dataset, and create the label names and textbox via the DataColumn.ColumnName. I have the following thus far but am getting the error: "Cannot convert type 'char' to 'System.Data.DataColumn': oleDbConnection1.Open(); DataSet ds1 = new DataSet(); oleDbDataAdapter1.Fill(ds1); DataTable dt1; dt1 = ds1.Tables["paintsys"]; //for each field in ds1, create a label and textbox int i = 0; foreach (DataColumn dcCurrent in dt1.Rows.ToString()) { Label myLabel = new Label(); m ...Show All

• Audio and Video Development Sound

  hi..a rooki bothering u guys...i didnt know where to make this post.. got a little problem...i cant but my surround sound system on..i used soundstorm but even that doesent work :( I'm not sure where you should put this post either... maybe try the general Windows Media newsgroup and see if you have any luck there http://www.microsoft.com/windows/windowsmedia/community/newsgroups/WindowsMedia/default.mspx dg=microsoft.public.windowsmedia&lang=en&cr=US This forum is for developers interested in the Media Foundation multimedia platform on Windows Vista. ...Show All

• Visual Studio Express Editions Always Round Up in Visual Studio 2005

  Okay Ive gone threw the forums many times and I have yet to find a clear beginner answer. I would like something that has any number that has a decimal to round up..no matter what the number/decimal is. Sorry if I sound rude Im just a little bit annoyed and not being unable to understand a lot of this. Something like the following should work Module Module1 Sub Main() Dim x = RoundUp(1.1) Dim y = RoundUp(1.9) Dim x1 = RoundUp(2.1) Dim y1 = RoundUp(2.9) End Sub Function RoundUp(ByVal Value As Double) As Long Return Fix(Value - (Value \ 1 <> Value)) End Function End Module ...Show All

• Visual Studio 2008 (Pre-release) Office 2007-like hotkey preview?

  Hey! I'm trying to make a hotkey preview like in the Office 2007 beta (if you press ALT and hold, you will see what hotkeys are available with a small icon). I've tried to bind the LeftAlt key and the Control key to different event methods, but they won't execute: public static void SetGlobalAlt() { RoutedCommand mycommand = new RoutedCommand(); mycommand.InputGestures.Add(new KeyGesture(GetKey("Alt"))); CommandBinding mybinding = new CommandBinding(mycommand, new ExecutedRoutedEventHandler(ExecutedAlt)); Application app = Application.Current; Window window = app.MainWindow; window.CommandBindings.Add(mybinding); } public static void SetGlobalCtrl() { Routed ...Show All

• SQL Server SQL Memory Usage - Sudden Raise in Usage

  Hi, We were performing Stress test for our .NET application that uses SQL Server as Database. We could see a steep increase (about 1GB) in usage of memory by SQL server when we monitor Available MBytes through perfmon. The Available MBytes is reduced from 15300 to 13500 in 15 mts. I feel it is because SQLServer adds memory to its buffer pool, but not really using it for any process. Still I'm not sure about this. The questions that I have after looking this perfmon value 1. What causes this steep increase in memory usage 2. If the memory is allocated to Buffer Pool, how do we control this and how to justify that the memory is allocated only to buffer pool 3. Why does SQL Server doesn't release memory from Buffer Pool once the s ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DrawableGameComponent.GraphicsDevice

  I added a class I called Quad, that I hope to use as a rectangle. I butchered the code used to draw the cube and I inherited from DrawableGameComponent in order to make use of the GraphicsDevice property to do the drawing. Any reference to the property throws an "Object reference not set" exception. Any help Try this instead: GraphicsDeviceManager gdm = (GraphicsDeviceManager)this.Game.Services.GetService(typeof(IGraphicsDeviceManager)); GraphicsDevice gd = gdm.GraphicsDevice; // Initialize vertex declaration m_vertexDeclaration = new VertexDeclaration( gd , VertexPositionNormalTexture.VertexElements); // Initialize Effect m_effect = new BasicEffect( gd , null ); m_effect.Ena ...Show All

• SQL Server 2005 transactional replication statement delivery

  Hi There WHen creating publciations under 2005 i saw a very interesting option under stament delivery, for inserts , updates , deletes there is an option that simply says insert/update/delete statement. I could find very little in BOL about this under " Article Properties ", is this what it soudns like FOr example if you say : update Table set Cloumn = 'whatever', this will not trigger the update sp for each row at the subscriber , will it actually deliver the update statements and literally do the update/insert/delete statement at the subscriber Thanx The performance you're seeing has nothing to do with SQL vs custom stored procs. In fact, if you used SQL, I bet it owuld be much ...Show All

• SQL Server How can i secure my MDF file?

  If a user is a local admin of the box they can gain full access to the database via integrated security. They can create their own database and attach .MDF How can i secure the .MDF so that no one can gain access to it Of course he is worried about db structure, not data... Ok, exist a way doing properly what you want, but is compliacted, and not automated. Follow this steps: 1. Create a Windows User with Administrative rights. 2. Log on with that user 2. Create a folder for the mdf file. 3. Remove rights from that folder for all other Windows Users excpet the user you just created. 4. Encrypt that folder with windows encryption (owner will be only the user you are logged on) 5. Go to Services and change MSSQL service user to the use ...Show All

• Visual FoxPro Grid and textbox Refresh issue.

  I'm having this problem with an application I’m writing. I have a Grid with a couple of text boxes next to it. When you select a record it updates the values in the textboxes with the values from that record. I also have a few command buttons that switch the tables viewed in the grid. Now here’s my problem... The text boxes stop updating after I change the tables a few times. Not sure what I am missing because I don't get any error messages and it does work for a little while. If you need more information let me know. You need to use a safe select method to change data in a grid on the fly. See www.tightlinecomputers.com they have a complete listing of what this entails. ...Show All

• Software Development for Windows Vista Howto dynamicly load a workflow from another lib

  Hi, I'm trying to load another seq. wf into a seq. wf by having the calling wf requesting a manager object to return a wf that is defined in another wf lib. Is it possible Seems like everything is designtime with regards to the out-of-tha-box invokewf activity Do I need to build a custom activity> any examples Thx alot, this wf shizzle roxx Not sure this is exactly what you are looking for, but I dynamically load Workflows from a generic host and it goes something like this: private Assembly workflowAssembly; private Type workflowType; private WorkflowRuntime wfRunTime; private WorkflowInstance wfInstance; ... workflowAssembly = System.Reflection. Assembly .LoadFile(workflowA ...Show All

• Visual C++ random movement horizontaly...

  does anyone know how to generate random movement horizontaly using random function I know how the function works to generate the numbers but cant generate movement... Im using C language. Not sure what you're trying to do here. However, the rand() function returns a random integer value between 0 and 32767. That's not going to be a good value to use as the Y-coordinate value for gotoxy(); 99.924% of the time, you'll try to move something off the screen. Try something like this: i = 1 + (rand() % 25); ...Show All

• SQL Server Scary Problems with User Hierarchies

  In my training (at MS Ascend) and in my readings I was initially lead to believe that user hierarchies were nothing more than a way to "organize attribute hierarchies into user-friendly multilevel structures." (Spofford et al.) However, the more I use SSAS 2005, the more I see that this is not completely true. User hierarchies have more significance. For example, user hierarchies seem to be used more than you might think (or want) in the design of cube aggregations. More recently I discovered a very scary and unintended consequence of building and using user hierarchies. Consider a simple product dimension with three attributes (besides the key): Product Type ([Type]) Product Species ([Species]) Product Size ([Size]) Th ...Show All

• Visual Studio Express Editions Change a window position

  I am a beginner and I was wondering how I could make a form/window look like its sliding accross the screen. I have set up the timer and that, I just need something like: Me.location = (x + 1, (middle of screen)) Thanks Nathan "make a form/window look like its sliding accross the screen" "now how do I get it to move one pixel or many pixels to the right (or left" Answer: Me.Location = New Point(Me.Location.X() + 35, (Screen.PrimaryScreen.Bounds.Height - Me.Height) \ 2) Yeah, Right We obviously wasted our time.  How about not wasting it any further in future ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. StarRunner ... source included

  Just wanted to "showcase" my first C# as well as first XNA program I've done. It all started from GeorgeClingerman's CreatingA2DSprite and his background tutorial. Got to say thanks to him and also Gregory Wurm from learnXNA.com which pretty much taught me the basics of XNA programming. Now, by all means this is no advanced game as you may easily notice and doesnt include any complex ways of achieving things. It's source can be modified a lot as to look cleaner, etc.... but hell it was my first C# program. The main things I used were If Then Else statements, loops, arrays... The game is pretty much about moving a spaceship around and avoiding the asteroids (I don't know what the name of the classic game is though). No, the astero ...Show All

• Visual Studio Team System Recover files directly from TfsVersionControl database?

  First off, let me say that I'm fully aware that not backing up my databases was dumb.  I used to be a sysadmin before I got into software development so this is kind of like the equivalent of a doctor smoking 3 packs of cigarettes a day.  I should know better.  That said, I had my TFS running in a virtual server on a USB hard drive and it dropped on the floor yesterday while TFS was running.  I've got bad blocks on the drive and it's pretty dead.  The only TFS database I was able to retrieve was TfsVersionControl.  I've mounted it on another SQL Server and I can access it.  So, theoretically, I've got my files.  (I also was able to get the reporting services encryption key.) Here's ...Show All