Rookboom's Q&A profile

• SQL Server ADS Wizard, tutorials and examples - Please Help.

  Hi, I'm new to SQL Server Technology and am trying to learn how to create a Mobile Device application and to sync it with a desktop application that uses Access. I have found a lot of information but some of it doesn't seem to make sense. I found this blog: http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx which is the announcement of Access Database Synchronizer (ADS) CTP. I downloaded it and installed it with all the prerequisites. This is the part i can't understand: " The CTP setup installs the desktop component required for synchronizing Microsoft Access database with SQL Server Everywhere Edition database on the device." I cannot seem to find the desktop component to try out! The Readme sh ...Show All

• SQL Server Default Parameters Not being set

  Hi there, In my report, I have set the default parameters such that it is supposed to automatically render when the page loads. I have set the defaults in Report / Report Parameters and it even works in the preview pane, however, when I deploy the report, the defaults are not set. This report has subreports, and I've tried setting their defaults. Has anyone come across this Thanks, LBD I created a similar post today describing default values not being deployed. It's very odd that it shows up on the Preview but does not get deployed. The only way I got it to work is setting the default in Report Manager on the properties of the report. ...Show All

• Windows Forms How to access a form behind ModelForm( dailog window)

  I am using .NET 2003 framework 1.1 From one main MDIForm I opened an static Instance of a window(Say window1) and hide it after initialing some properties of this window(window1). Now I want this window to be shown from different child windows of MDI parent on clicking of some buttons. Problem is coming when 1] I open the first window(Static Instance of Window1) and minimize it. 2] I open one MDI child window which is a Model window( this is it is shown as showDialog). 3] From this window if I try to unhide/show that Instance of first window(window1) first window is not accessible as the second window is opened as Model. please help me. thanks in advance. if Window1 uses Show(), the calling form should also be shown usin ...Show All

• Visual Studio Express Editions Problems making a LabelArray

  Hello all, I'm having trouble making a LabelArray in VB 2005 Express Edition. First of all, I can't find an Index property when I look at the label properties. Secondly I can't use the same name on different labels. It for use in a loop: For i As Long = 1 To 4 Label(i).Text = TextBox1.Text Next i or something like that. I need a LabelArray, but how to make it in VB 2005 Express Well, I'm trying to work this out. I've now added the code mentioned above in the Form.Designer.VB part of the form. VB generates the labels, but it can't show the form itself (within VB) cause it can't read the code. ...Show All

• Smart Device Development How to use database for pocket pc application

  Hi I have a need to work on pocket pc application. Scenario: In general user will take database backup from database server to local system. User perform some changes to his local database based on his requirement. Again user connects to database server and click on update, local database should update to server database by informing each record status to the user. ex: record 1 updated / call closed do you want to update Here local database is going to be Pocket pc database and server database is on SQLDatabase. Can any one suggest best way to implement this feature in Windows Pocket pc, c#. I would appreciate your reply. Thanks, 1) Thank you for reply. In my case device sync back to serv ...Show All

• SQL Server Sensitive data

  Hi all, How can we protect sensitive data (custom properties) in a custom connection manager or a custom data flow component The SSIS Books Online indicates in the " Security Considerations for Integration Services" page that "If you write custom tasks, connection managers, or data flow components, you can specify which properties should be treated as sensitive by Integration Services". But how to do it programmatically Are there any attributes that can be applied on custom properties Thanks. Pascal To get more control about saving properties, you need to implement IDTSComponentPersist. You then override the two methods, LoadFromXml and SaveToXml. You are now in charge of ...Show All

• SQL Server Dataflow with 2 lookup using the same Table

  Hi there I'm getting into trouble everytime I want to setup a dataflow containing 2 or more flows, where I want to make a lookup into 1 other table. This fails, of some reason I do not know of. ex. Table 1 -> Lookup Currency Table -> Table2 with currency Table 3 -> Lookup Currency Table -> Table 4 with currency One of the lookup will fail. How do you avoid this /Bjarne You meant, you have more than 1 source component in your data flow that goes independently of each other toward different lookup transformations How are you setting the lookup transformations You shoud use a query to get only the columns you need and since the lookup table is used concurrently; you may want to use nolock hint to avoid deadlocks. ...Show All

• Visual C# losing image in picturebox

  I have an app that draws a simple bar chart into a picturebox. The chart is in the picturebox until the function finishes and then the chart disappears and the original background color fills the picturebox. The following is the code I use to create the graphics. The picturebox is named gBox. I would like to find out what to do to keep the image in the picturebox. Bitmap objBitmap = new Bitmap (iMaxWidth, iTotalHeight); System.Drawing. Graphics objGraphics; objGraphics = this .gBox.CreateGraphics(); Brush gBrush = new SolidBrush ( Color .White); Rectangle gRect = new Rectangle (0, 0, iMaxWidth, iTotalHeight); objGraphics.FillRectangle(gBrush, gRect); gRect = new Rectangle (0, 0, iMaxWidth, iM ...Show All

• Visual Studio Express Editions How do I calculate a person's age with datetimepicker

  I have a form with a datetimepicker and a textbox1.text where I want to show the age in the texbox1.text box when user pick a date for the datetimepicker. How do I use it and do I put it under thedatetimepicker or texbox. privaite subs I was just getting clarification for myself I've started looking at this for you, and I can tell you how to get the age from the datetimepicker box, but I seem to be having problems getting it to display. Here's what I've got so far. Dim birthdate As DateTime birthdate = DateTimePicker1.Text Dim age As Integer age = DateDiff(DateInterval.Year, Now, birthdate) If you use the command textbox1.show(age) line, it comes back with an error saying ...Show All

• Software Development for Windows Vista Workflow Compile Error

  I use the following code to compile my workflow WorkflowCompiler compiler = new WorkflowCompiler(); WorkflowCompilerParameters parameters = new WorkflowCompilerParameters(); WorkflowCompilerResults results = compiler.Compile(parameters, strArr); and I got a compile error "The root activity is invalid" The xoml file of my workflow begin with "<ns0:mySequentialWorkflowActivity ... ..." I think this is the problem, because this is the type I defined myself public class mySequentialWorkflowActivity : SequentialWorkflowActivity How can modify my compile code to compile with this workflow I'm using WWF beta 2.0 Thank you. What you are doing ...Show All

• SQL Server mySQL to MS SQL 2005 - ODBC?

  Hi, Posted this at the tail end of another thread but that one appears to have died. Thought I'd try again since my question was a little distinct from that one anyway, but apologies if I've committed forum sacrilege. I am having a heck of a time trying to migrate a fairly simple MySQL DB to SQL Server I am using SQL Server 2005 Standard Edition SP1. I tried following MS' instructions in this article: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx hoping that what worked for 2000 would work for 2005, since the principles seem sound. No luck. I can create the ODBC link, but SQL Management Studio, the '.NET provider for ODBC' option doesn't give me the choice to copy tables - only to write a query. ...Show All

• Visual Studio Tools for Office Outlook 2007 Form Regions and User Properties

  Hello fellow coders, I've developed an outlook 2007 addin that makes use of a few form regions and some custom user properties to extend outlook's standard items and I seem to have a problem with my formregions getting 'infected' with properties. From what i can tell, if you drop a field onto a formregion in design mode, the formregion tries to ensure that property is always available by saving it internally and then injecting it into the userproperties collection of an item when it is created and displayed. The problem is it doubles up on properties that already exist in the item, standard or custom properties. For eg. I have an employee item (IPM.Contact.Employee) which contains one userproperty 'ParentEntry' which sits in the publishe ...Show All

• Visual C# Anyway to know if the program is running under VS IDE ?

  I would like to do conditional compilation based on whether the program is running under IDE, is this possible Thanks. Hi, I understand from ure question that u want to setup a conditional complitaion only if ure runnding under Visual studio. U can do this by adding a conditional compilation only in the debug mode by editing project properties in Visual studion. Visual Studio enables multiple configurations (Debug/Release and u can add other configurations) and each one has it's own properties. So when compiling in release mode the parameters you set for the Debug mode are not used. HTH. ...Show All

• SQL Server Duplicate record trigger

  This is part of my trigger on table T1. I am trying to check if the records inserted to T1 is available in myDB.dbo.myTable or not (destination table). If it is available rollback T1. It does not do that although I insert the same records twice. -- duplicate record check SET @step = 'Duplicate record' IF EXISTS ( SELECT i.myID, i.Type FROM INSERTED i INNER JOIN myDB.dbo.myTable c ON i.myID = c.myID GROUP BY i.myID, i.Type HAVING (COUNT(*) > 1) AND (i.Type = 'In') ) BEGIN ROLLBACK transaction RAISERROR('Error: step: %s. rollback is done.', 16, 1 ...Show All

• Visual Studio What is #IND, #DEN etc.

  Hi, Often, if some floating point operations fail, i see values such as -1.#IND000000000000000000000 and 3.4353453453535342#DEN in the Debugger. Does anyone know what exactly this means. I could not find any documentation explaining these special double values (#DEN, #IND etc.). Thanks for help, cheers, Stefan I can't seem to find #DEN but not #IND is floating point NAN (not a number). This page talks a little about it. http://msdn.microsoft.com/library/default.asp url=/library/en-us/vclang98/html/sample_Members_of_the_numeric_limits_Class_(STL_Sample).asp ...Show All