syj's Q&A profile

• SQL Server having a constraint on a adding a record

  how can i make a stored procedure for inserting a record in the database where it detect if the title is already present and then disregard insertion and just update the number of copies in that specific record i would be so thankful for any hel out there...tnx! insert into yourtable(pk, col1, col2, col3) select @pk, @col1, @col2, @col3 where not exists (select * from yourtable x where x.pk = @pk) if @@rowcount = 0 -- nothing inserted b ...Show All

• Windows Forms Another DataGridView Background Row Color question ....

  I'm writing a simple app which goes through a folder, takes each file thats in that folder, and sees if it's in a database. If the file is found in the db, then I do a DataGridView1. Rows.Add( False , file.Name.ToString, folder.Name.ToString, "kb" ) , which adds the file name and folder name to the new row and keeps it unchecked. If the file can't be found in the db, then I do a DataGridView1.Rows.Add( True , file.Name.ToString, folder.Name ...Show All

• Software Development for Windows Vista ICredentialProvider

  Did anybody make a successful user logon using the new ICredentialProvider interface My credentials are displayed, but I can't make them to logon. And what worse - after 20 or 30 seconds, the winlogon crashes completely with no recovery possible excepting hardware reset. I thought I basically did something wrong and decided to wait for more detailed documentation or some sample code. But MS doesn't seem to put too much effor ...Show All

• Software Development for Windows Vista How to run a extra workflow defined by enduser workflow desinger from a web page

  The test in lab10 show a workflow designer, which can run a defined workflow from an extra xoml file.It is a winform application, and I wonder if a web page can run the workflow like that and how to do that. Though not as easy, it is definitely possible to create a complete in-web designer. Ghendie Plingau has created such a thing, which you can have fun with here: http://www.netfxlive.com/ Thanks, Angel ...Show All

• SQL Server copy table structure

  Hi, In SQL Server, Is there any DDL available to copy a table structure alone and not the data, I believe 'SELECT * into new_table from table1' will copy both structure and data as well. Please advice, Thanks, Smitha You can do: select top 0 * into new_Table from table1; --or select top 0 * into new_Table from table1 where 1=0; -- or in SQL Server 2005 select top(0) * into new_Table from table1; ...Show All

• Visual C++ What will cause AfxGetModuleState() return different values during DLL initialization?

  My application has over 100 Dlls. During startup, many resources failed to be found. I finally find out this is because AfxGetModuleState() returns different values in the CDynLinkLibrary's constructor, but I get no idea how can this happen. Anybody can help Thanks. Could it be a failure to use AFX_MANAGE_STATE(AfxGetStaticModuleState( )); on your DLL entry points This macro informs MFC that a DLL boundary has be ...Show All

• Visual Studio Tools for Office help with excel

  i'm trying to write a simple function, all i want is that when i write anything in a cell(on column 'A'), the current time (hh:mm:ss) will be displaied in the same line but in the 'E' column and that it WONT update itself each time a type someting.. i just can't make it work.. plz help me.. I'll let you handle the details, but basically you could add an event handler to the worksheet (handle the change event) and see if the target.co ...Show All

• Visual C# Voice Chat,Audio Streaming

  Hello everybody... I have a TCP/IP client/server chat application.I want to add voice chat feature to my application.What is the start point How can I implement this feature in c# How can I implement audio streaming in c# Please guide me. Note : My application works on LAN and is not on the internet. You can download complete source code and demo of my chat program from here. You need .Net FrameWork 2.0 http://www.codeproject.co ...Show All

• Visual Studio Tools for Office Best way to do this?

  Hello, Hopefully someone would have some advice, I'd like to trigger an action inside outlook from outside outlook. I.e. pop-up a new contact window for the user to access. Should I approach this from a mapi standpoint or use IPC with a VSTO add-in inside of Outlook... I'm not sure what the "most correct" way to go about this is. Thanks! Well, I'm far from being an expert, but in my opinion an Outlook ...Show All

• Windows Forms Determine When an Edit Begins

  Hi, I'm trying to determine when an edit begins on data bound controls on a form so that I can enable only the 'Save' and 'Undo' buttons on my BindingNavigator. I'm using VB .Net 2005, I'm accessing data via an OleDBDataAdapter, which populates a DataSet.DataTable. I have a BindingSource connected to the DataTable, and the form fields bound to the BindingSource. Lastly, a BindingNavigator is tied to the BindingSource. Rather than try an ...Show All

• Smart Device Development What will be target binary CPU?

  Hi All, Created default MFC smart device application and checked its target cpu model using depends.exe. It shows THUMB. Then I removed MACHINE:THUMB from linker command options. I still got the same CPU type as THUMB. Does the linker considers default CPU type as THUMB for any WM 5.0 application created What changes do I need to make if I want CPU type to be ARM for WM5.0 applications -Seemit   ...Show All

• Visual Studio Team System TFS Beta 3: Files and folders converted to lower case

  We have run a test conversion of our VSS database into TFS Beta 3.  During this process, the conversion has renamed nearly all of our files and folders to lower case names.  This is a problem as we have cafefully used PascalCasedNames for all of these items for better readability, and to match the casing of the class names that many of them contain. For example, in VSS we had \SolutionName   \FirstProject   &nb ...Show All

• Windows Forms Forms Designer & My Panel Control

  When I place a TableLayoutPanel on a blank form, and then add a Button to the top-left (0,0) cell, the following code is generated: // // tableLayoutPanel1 // this .tableLayoutPanel1.ColumnCount = 2; this .tableLayoutPanel1.ColumnStyles.Add( new System.Windows.Forms. ColumnStyle (System.Windows.Forms. SizeType .Percent, 50F)); this .tableLayoutPanel1. ColumnStyles .Add( new System.Windows.Forms. ColumnStyle (System.Windows.Forms ...Show All

• Windows Forms linklabels in middle of a text

  Hello, I'm in need to grab news from a website, those news can have multiple links anywhere in the text and the link's name must be kept to still have a logic message displayed. I was wondering how to do it, and I couldn't figure out  ...Show All

• SQL Server recursive query vs iterative

  any body know how i can transform a recursive query to iterative one if possible i need a simple example witth little explanation really needs that There is no need to use real recursion in sql server. The main feature about recursion is that the procedure calls itself untill it is finished and goes futher and futher down the path.. Usually this is done "one line at a time" An example would be "List all Folders" -Start with the startfolder ...Show All