bb32223's Q&A profile

• SQL Server Insert Trigger

  I am facing problem in creating a insert trigger for the following scenario. i have transactions, control tables whenever i insert a record in transactions it should get value from the control table, increment that value in control table and update the same value as transaction_id for new transaction in transaction table. control table has these fields (control_desc, control_value) can some one help me to write a trigger (insert trigger) in transactions table. Tanks for the Help   Coudl you please provide more information like DDL code, showing which column you want to upda ...Show All

• Visual C# How to call an API function by ordinal?

  Hi all, I'm working on a project that uses some DLL that export nameless functions, in which exported only by their ordinal numbers; How can I make a declaration for that ordinal function in C# and call it Also, if I have an API function retrieved by address using GetProcAddress, is it possible to call a function in C# directly by its address Is so, how Thanks in advance, -chris Chris, The DllImport attribute has an EntryPoint member that can be used to refer to a method by its ordinal value:   // The # character is required.   [DllImport("dllname", EntryPoint="#123")] If possible, don't use GetProcAddress.&n ...Show All

• Software Development for Windows Vista Compile error when Namespace name =Workflow class name

  Hi, I came across something that looks like a bug of the xoml compilation. I created a sequential workflow class library (model after the MSDN article http://msdn.microsoft.com/msdnmag/issues/06/03/CuttingEdge/ ) and an interface that marked [ExternalDataExchange]. After that I dropped a CallExternalMethod activity into the workflow which coincidently has the same name as the namespace. For example, the full qualified name of the interface is HelpDeskWorkflow.IHelpDeskService and the workflow class is HelpDeskWorkflow.HelpDeskWorkflow. The interface type and method name were set properly. No exclamation mark in the designer. Howe ...Show All

• Visual Studio Tools for Office VSTO Question: Looking for WORD Action Pane example that lists and select contacts from Outlook

  Would really appreciate any help or guidence. I want to have an Action Pane in Word that somehow allows the user to select a contact from the Outlook contacts and insert that information in different parts of the document. Are there any examples of integrating contatcs and using the action pane Thanks for any help, VA Actually, you do not need an 'actions pane' example because what you want to do can be done in a variety implementations (winform, user control, etc.). What you are going to do is work with the Outlook OM programmatically to retreive contact names and display them. I have compiled a list of resources to ge ...Show All

• Visual C# Talk to me VS 2005: Why do you go from 25 MB to 300 MB in less than 60 minutes ?

  MSFT VS 2005 IDE coders VS 2005 IDE  takes a lot of memory..wonder what it is doing Is there anything I can do to help it consume less memory. It sucks I don't know if you guys will be proud of 35 MB to 3000 MB in less than 60 mins.. Memory leak uh Vague question, is there anything that you guys need that I can send to help you solve this problem Thanks I cannot repo this problem, I am guessing you have a memory problem (physical RAM) To me - VS.NET 2005 has increased performance heck of a lot and I love it! And I am using this on my laptop and my development computer. The specs are the same as yours ( ...Show All

• Visual Studio Open From Source Control problem

  When I do this with my provider I get this error The source control bindings for this project do not match the bindings reported by your source control provider. This solution, or part of it, may have been forked or branched. To update the projects source control bindings use the Change Source Control on the Source Control menu. If I click OK and let VS reload everything is fine.  But I can't figure out where this is coming from.  I've even diffed all the files before and after this error.  The only difference is the .suo  What is the mechanism that causes this error Thanks, JD Hi I sus ...Show All

• .NET Development Draw the text on image

  1. I want to ask how can I draw the text on image. 2. Also the code below I don's know how to call the drawlinePoint in Page_load , anyone can help me. I write this but has error that I call the function, how can I call DrawLinPoint It is the Window Application.NET Private Sub drawPoint_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load DrawLinePoint(e) End Sub Public Sub DrawLinePoint(e As PaintEventArgs) ' Create pen. Dim blackPen As New Pen(Color.Black, 3) ' Create points that define line. Dim point1 As New Point(100, 100) Dim point2 As New Point(500, 100) ' Draw line to screen. e. ...Show All

• SQL Server Numerical Dimension

  I have a dimension representing the Age of a client. I would like to create a Named Set filtering all clients whose age is upper 80. Something like this : [Dimension].[Age].Value > 80 But this kind of expression is not valid, Is there a way to do that ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. problem with multimedia timers

  hii i am working on a directx application which uses a multimedia timer( http://www.codeguru.com/Cpp/G-M/mult...cle.php/c1581/ ) problem am facing is that the timer is behaving indifferently when it comes to CPU usage. It takes 0-1% CPU on WindowsXP...But its taking 15-20 % on Win2000. When i tried it on another system with Win2000 it gives 0-1 %.But after running the application for sometime the CPU usage automatically increase to 20 % and i gotta restart the system to bring CPU usage to 0-1% cheers vinod http://msdn.microsoft.com/library/default.asp url=/library/en-us/directx9_c/Game ...Show All

• .NET Development Question about SqlString

  Hi there, I'm using the datatype System.Data.Common.SqlString to convert "normal" DateTime-values into SQL-compatible values. One thing irritates me: Method "ToSqlString()" always format the Year with 2 digits (yy/MM/dd). Is there any chance to change this behaviour so that ToSqlString() puts the year as a 4-digit number in the output Thank you. Reiner Were you calling SqlDateTime's ToSqlString() method The method actually calls System.DatTime.ToString() with a null IFormatProvider. Quote from MSDN: The provider parameter is typically a DateTimeFormatIn ...Show All

• .NET Development Problem copying dataset from one Database to another

  Hello, I m trying following code to copy a dataset created from one database to another database. Code runs errorless but data doesn't update in another database. Where am i going wrong Please help private void Page_Load( object sender, System.EventArgs e) {       this .insertDataR(); } //This function returns Dataset public DataSet getDataR() //return Data Set { string conStr="Provider=msdaora;" + "Data Source=abc;" + "User ID=sss;" + "Password=uuu"; OleDbConnection a = new OleDbConnection(conStr); a.Open(); OleDbDataAdapter da= new OleDbDataAdapter("selec ...Show All

• SQL Server Compact Database Error Code: 0

  I am currently working in VB.NET with SQL Mobile 2005.  I am trying to compact a database, .sdf, using the SqlCeEngine Object compact(connectionstring).  When I use this code to compact a small database, only about 300KB, it returns okay however when I try to compact a larger database, about 9MB, it returns with a SQL Error Code: 0, "The operation completed successfully" however with no compacted database.  The code works however it only seems to work for smaller databases.  Does anyone have any ideas on how to correct this error or tell me why it returns with that type of error. Snuggs ...Show All

• Visual Studio Accessing watch window

  Hi, Can i access watch window within a Visual Studio (.NET 2003) addin or is it accessible only via VSIP SDK I am currently developing a LUA (a scripting language) debugger and one convenience that i want to give to the user is to add LUA variables to the regular Visual Studio watch window and watch their values. I have already developed a seperate tool window where i let users watch variables but i think that is not a good idea since it does not integrate well with the regular IDE. Even if i make it look like a regular VS watch window, i want the addin to be compatible with future versions of the studio where the UI might change. Thanks ...Show All

• Visual Studio Team System June Beta 2 compatibilty with team fundation july CTP...

  Hi, Is it possible to connect to team system server july CTP with a Visual studio beta 2 client Is it also possible to connect a July ctp client to a beta 2 team fundation server Alain Martineau Publishing Business System For more information about upgrading from Beta 3 to RTM, see Soma's blog: http://blogs.msdn.com/somasegar/archive/2005/08/22/451026.aspx ...Show All

• .NET Development ApplicationSettingsBase doesn't save custom class

  Hello. I want to store my object in the application settings file. My object class is NamedStringCollection (derived from StringCollection). I saved it according MSDN (topic: ApplicationSettingsBase class overview). But when I save my object (in the application settings file) it looks like an object of a base class. For ex: There is a form with one button. When I press the button the application saves my object. private void button1_Click(object sender, EventArgs e) { ApplicationSettings Settings = new ApplicationSettings(); NamedStringCollection collection = new NamedStringCollection(); collection.CollectionName = "Collection1" ...Show All