SIYER's Q&A profile

• SQL Server SQL SERVER 2005 Desktop Engine Version avaliable?

  hi dear developers; i just finished my program and i am making a setup for it but the db is MSSQL SERVER 2005. the home users how will they use sql server 2005 is there any thing like sql server 2000 desktop engine something like that... shortly the user don't have to know sql server and settings of it so how will we do it thank you very much... hi thank you very much. i have seen that connection string i tired and it worked Data Source=.\SQLEXPRESS;AttachDbFilename='D:\databases\test_Data.MDF';Integrated Security=True; so how can i add  sql server express edition to my setup  one more question; can i use sql2000 files with sqlexpress 2005     ...Show All

• Visual C++ how to convert CString to const char *

  hi, i have one function which returns CString object. i need to pass that return value to another function which accepts const char * i should not change any of the function signature when i try to convert from CString to const char * it is giving error message saying it is not possible is there any way to convert CSting to const char * plz help me thanks in advance Suneel, If your program is in UNICODE and your function is not, then you might try reading your CString into a buffer in BYTE(s) and then casting the buffer to a NON-Unicode char*. For Example: unsigned short i, length; BYTE ByteBuffer [128]={0}; TCHAR szCString [256]={0}; wsprintf(szCString,TEXT("%s" ...Show All

• Smart Device Development Speech

  How i can use speech sdk in compact framework please help me for Microsoft or other Companies SDK's Best Regard That was answered before, so please search for "speech" in device related forums. Search button is on the top of your screen. ...Show All

• Visual Studio Express Editions How to search listbox for "Full Name" using lastname/firstname

  I'm using vbexpress with MSAccess backend on WINXP sp2. I want to be able to search a listbox which is pre-populated with "lastname + firstname". I want to type my search string in a textbox and have the listbox select the first occurence of a match. I know about the "findstring" method but my quest is slightly more complicated. I want my search string to be a combination of lastname and firstname with a de-limiter. For eg: Listbox contains: Bloggs Joseph; Blocks Jim; Bloggs Joe; My search string may be "Blo / Ji" where forward slash is the delimiter between the lastname and firstname. This should have "Blocks Jim" automatically selected by the listbox. NB: The delimiter can be anythin ...Show All

• Visual C++ how to build a project with one-cpp-file-based multi obj files using vs2003

  In the project I am working on, there is a cpp file that contains conditional compiling and 5 obj files should be generated from it based on different defined variables. What is the right way to do to build this project with visual studio 2003 Usually I set the preprocessor definations to define specific variables to be checked by the compiler, but I have no idea how to set different definations for one file within a project. Suggestions are appreciated. rich   ...Show All

• SQL Server Getting an identity column value returned from an insert trigger on a view referencing multiple tables

  I have a view employing multiple tables with the same ID. The master table has an identity column (REG_ID) as its primary key and that key is used as the primary key for the other tables in the view. I have the insert trigger working except for one item. New records are properly written to all the tables in the trigger, but the value of the just inserted record is not appearing in the "Open Table" View from SQL Enterprise Manager when I insert a new record in the table. What am I doing wrong Code Follows: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER Trigger [View_1_INSERT] ON [dbo] . [View_1] instead of INSERT AS BEGIN SET NOCOUNT ON ; Declar ...Show All

• Windows Forms How to Remove ListItem from a ListBox

  Hi friends when i try to remove ListBox item(ListItem) its giving error error : List that this enumerator is bound to has been modified. An enumerator can only be used if the list does not change. i have only ListItem objects in my ListBox and my code as follows foreach ( ListItem removeitem in listBox1.SelectedItems) { listBox1.Items.Remove(removeitem); } any help pls, Regards Ranadheer. Hi, You cannot remove the items in this way, since foreach statement is used to iterate through the collection to get the desired information, but should not be used to change the contents of the collection to avoid unpredictable side effects. You can do the same thing by whil ...Show All

• .NET Development Singleton vs. Shared class vs. Global object declaration.

  These are so similar that I wanted to get some feedback on which might be better for my project. I am making a custom tracing framework that does NOT inherit from Microsoft's because I don't like much of it's functionality. Well, the main issue is, I want my trace source class to be available to all components that reference my trace source, and I don't want each component declaring their own instance of a trace source. If a program is a collection of 10 components, I don't want each of them writing to a different file for example. So I need a class that's available everywhere in an assembly of multiple components. It appears there are 3 ways to do it... 1. A global variable 2. A singleton 3. A shared class. Do you ...Show All

• Community Chat please let me know

  Hi all could someone please let me know if this is working thanks http://10cents.pwp.blueyonder.co.uk/avoca.html Now, don't get discouraged! There's atleast one person to whom your code was useful: You. You learn a lot more by coding things that nobody will use, so don't stop doing it! ...Show All

• Windows Forms Data binding and Checkbox values

  Ok... I have a value in my Sql table called "Disconnected" is a bit type....0 for not being disconnected 1 for being disconnected, Now i have a checkbox in my windows form that will submit information on a product....if the Disconnected checkbox is checked how do i send that value to the sql db...I know the checkbox is a bool value so if its checked it returns true if not it returns 0 for false.......I know i can type cast a bool to a bit, so should i do that within a property or something anyhelp or any links on how to get this done will be most helpful!!! it should be: if (Convert.ToBoolean(IsDe) == true) { ... } ok, well since you are using a DataReader, what I suggested won't work. You will have to in this case ...Show All

• SQL Server X12 with SSIS Anybody?

  Does anyone have any examples where they've successfully parsed EDI X12 using SSIS ISA*00* *01*000000 *ZZ*00000 *ZZ*ZMIXED *051220*1040*U*00401*000075004*1*T*:~GS*HC*00000*ZMIXED*20051220*104033*75004*X*004010X098A1~ST*837*000000001~BHT*0019*00*075004*20051220*101233*CH~REF*87*004010X098DA1~NM1*41*2*FINAL SUPPORT*****46*00000~PER*IC*CONNIE GOSS*TE*8172820300*EM*V00979~NM1*40*2*TEXAS THIN*****46*ZMIXED~HL*1**20*1~NM1*85*2*MEDICAL CLINICS,PC*****24*451234564~N3*3790 W. FIRST ST~N4*RICHARDSON*TX*75248~REF*1G*Z46489~REF*0B*MDQ4512~HL*2*1*22*0~SBR*P*18*******MC~NM1*IL*1*MARSHALL*JACKIE****MI*354787451~N3*300 LAMESA COURT~N4*CARROLLTON*TX*75006~DMG*D8*19500812*F~NM1*PR*2*MEDICAID OF HAWAII*****PI*D86916~CLM*000133*160***11:: ...Show All

• Architecture database watcher ... need suggestions !!

  Hi all, i'm trying to develope a windows service which will listen on a database table (Oracle database) , when a record updated ,the service will store it on another database . (Sql Server database) the question is what is the best methodology to detect database update my idea is to run a query periodically and check the update is anyone have a better solution thanks. If you want to catch every version then you will need to use a trigger on the Oracle to post it into another table (which could be inside SQL Server). If you only run a query periodically then you may not catch every version. This will effect performance. However if you don't need to have every version and only want updates every hal ...Show All

• Visual C++ How do you make a single file compile without making a whole project in vc++ 2005?

  Now this is totally absurd. I am learning C++ as a beginning programmer and bought vc++ 2005 and installed it but its so freaky complicated further more inroder to make simple programs such as heelo world, adding 2 integers, etc you have to make them into projects for them to compile when i used a new file option there wasnt any option for building or compiling. Everytime i have to solve an exercise from my book i have to make a new whole seperate project with there headerfiles,source files etc how can you make a only single .cpp file and get it to compile in vc++ 2005 There is an option inside the project properties under the c\c++ folder called "enable minimal rebuild". This should only r ...Show All

• SQL Server Set results destination with script?

  In SQL Server Management Studio, can you set the destination of results (e.g. Results to Grid) with SQL script, or do you have to use the toolbar Thanks Chris I assume you mean "can tell the server to get the results in either a grid, file or finally text using t-sql" No. You have to use the toolbar, obviously thats not neccessarily true for text. You could get output to text using code. Is this what you require Barry ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. ALPHABLEND Problem when using "Front to Back" order to draw objects!

  I Draw many objects (transparent or opaque) in my project. In order to increase performance , the scenes are rendered from front to back(according to "Performance Optimizations" In DirectX SDK) . I use the code below, but nothing appeared! Please Somebody tells me why thanks a lot!!! C++ Code in Render Function: pd3dDevice->Clear( 0 , NULL, D3DCLEAR_TARGET | D3DCLEAR_ZBUFFER, D3DCOLOR_ARGB( 0 , 0 , 0 , 0 ), 1 .0f, 0 ); Pixel shader: technique TVertexAndPixelShader { pass P0 { ALPHAREF = 0x00000001; ALPHATESTENABLE = TRUE ; ALPHAFUNC = GREATEREQUAL ; ZENABLE = TRUE ; CULLMODE = NONE; ALPHABLENDENABLE= TRUE ; BLENDOP = ADD; DESTBLEND = ONE; SRCBLEND = INVDESTALPHA; VertexSha ...Show All