r1ck5-focus's Q&A profile

• Smart Device Development Querying SQL Server Mobile (CE 3.0) with Visual Studio

  Hey all! I'm comming across fustrations with the sql querying tool that is built into visual studio 2005. I'm trying to query a Sql Server CE 3.0 database, and have dropped a few tables onto the diagram pane, and select my columns and everything queries fine. However, if I change my join between the two tables to a Right outer join, the designer automatically slaps a '{ oj ... }' around my where clause which isn't supported by sql server ce 3.0. Anytime I remove it and try to execute my query it automatically re-adds these sumbols and displays an error to me. Is there any way I can get visual studio to stop automatically adding these sql symbols when talking to a database that doesn't support them Below is the query it produce ...Show All

• Visual C++ Creating Windows Shortcuts (Shell Links or .lnk files)

  I am having issues figuring this out. In Visual C++ 2005, I am trying to create a shortcut. At this point I don't care what the shortcut is for or where it will go. I've seen references to the Windows Scripting Host Object and the IShellLink interface. Neither of which can I figure out how to use. When I referenced the WSH, I was getting errors about undefined identifiers, I guess because I don't have any kind of header file to use. Any help would be appreciated. Thanks. There it is said about how to use the shell interface. There has a sample snippet. To refer MSDN is a default. If he refers MSDN, he can know that what are the interfaces and what's it for. MSDN has a definite description on IShellLink int ...Show All

• Architecture Question on Custom Entities

  I have a scenario wherein the UI talks to Service layer --> Business Layer --> Data Layer and fetches data and passes along the layer via custom entities. Typically when we retrieve records it would as a set of entities inside an entity collection or should I say an array of entities. Now when I update a particular entity in the entity collection I either have the option of sending the entire entity collection or just extract out the updated entity and send the same across the layers to be updated in the database. Looking apparently, it would suggest sending only the updated entity instead of the entire entity collection bcos its always best to pass small size data across the layers. Is this analogy correct or is there some scena ...Show All

• Visual Basic Communication Skills

  I need to know all about communication and the skills involved. Lets start with articulation: < http://dictionary.reference.com/browse/articulate > 7 results for: articulate View results from: Dictionary | Thesaurus | Encyclopedia | the Web Dictionary.com Unabridged (v 1.0.1) - Cite This Source ar?tic?u?late Cite This Source ar?tic?u?late / adj., n. r t ky l t; v. r t ky le t / Pronunciation Key - Show Spelled Pronunciation [ adj., n. ahr- tik -y uh -lit; v. ahr- tik -y uh -leyt ] Pronunciation Key - Show IPA Pronunciation adjective, verb, -lat?ed, -lat?ing, noun –adjective 1. uttered clearly in distinct sylla ...Show All

• Visual Studio Team System Iterations and builds

  I'm new to VSTS and trying to set up a few projects across the company using the Agile template. The one thing I'm not sure I understand is the mechanics behind work items, builds, and iterations, and how they relate to releases. My end goal is to be able to track what bugs are in which releases, and what bugs are fixed in what releases. My thinking was to set up an iteration with a release build number - I guess what I'm having trouble resolving is that the template wants you to apply a 'found in build' number to a bug, and the builds don't really relate to releases or iterations in any way. I'm not particularly interested in mapping bugs to nightly or dev builds - I just need to be able to tell for a client on version x, they have this l ...Show All

• SQL Server Could not load file or assembly 'Microsoft.Data.Odbc...

  I have developed an application in C#, and it uses both a SQL server database, and as part of its operation it opens up a Foxpro database. I am using Odbc to connect to the fox pro database and everything wortks just fine on my devleopment machine. However when I deploy my application I am getting the following error text when ever I create the form that does the Odbc work. ************** Exception Text ************** System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Data.Odbc, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.Data.Odbc, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c56193 ...Show All

• Visual Basic is it possible to tel wich control raised the event?

  is it possible to tel wich control raised the event Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click, Button2.Click ' Add event-handler code here. End Sub For example i want to disable button wich raised this event How can i do that Rememer that the above code could cause an error, since the sender is not necessarily a Button object: if you try to cast the sender as a button and it cannot be cast, an exception will be thrown. You would be better served by checking that the sender is what you are expecting by checking the sender type, or performing a TryCast(). Neglecting such tests are a common cause for program crashes. ...Show All

• SQL Server Cannot Connect Remotely to HTTP EndPoint

  Dear all, I appologise that incarnations of this topic have been posted several times on this forum, however I cannot find a scenario that is the same as my own so I've resorted to starting a new thread. I can successfully create and connect remotely to an HTTP EndPoint on my Windows 2003 machine using Integrated security, the administrator username and password via my static IP address. I have read that Windows XP SP2 supports HTTP EndPoints, and it would be much more convenient for me to be able to create EndPoints in XP, and connect remotely. I have created the endpoint like so... CREATE ENDPOINT sql_tvr10 STATE = STARTED AS HTTP( PATH = '/sql/tvr10', AUTHENTICATION = (INTEGRATED), PORTS = (CLEAR)) FOR SOAP ( WEBMETHOD 'Stor ...Show All

• Visual C# Question related to string in C#

  Sorry to ask such noob question at here if i got a string like this string ss ="4a0368"; how to convert this stings ss to byte[] test = {0x4a,0x03,0x68}; i am trying to use getbyte() but didn't work test= ss.getbyte();  or in short: how to convert a string ss2 = "4a"; to byte 0x4a in C# Thanks for your suggestion. byte.Parse( hexString.Substring(i*2, 2), NumberStyles.HexNumber ); This line solved my problem. Thanks and Regards ...Show All

• Visual C# Implementing OLE

  I am fairly new to C#. I need to convert some VBA code to C#. I am not real sure how to do this. I am using VS 2003. Here is a clip of the VBA code. Dim mytpo As Object Dim LbGroup As String icell = 1 ' ' Create a object and set the connection info in it Set mytpo = CreateObject("CCSOLE.TPO") mytpo.protocol = "TCP/IP" mytpo.Server = "db1p" mytpo.Userid = "test" mytpo.password = "test" ' Make a connection to server mytpo.connect ' ' Check if the connection was ok If mytpo.ErrorCode < 0 Then MsgBox mytpo.ErrorMsg End End If Thanks Hi sandsdad, Since the property requires a reference ...Show All

• Audio and Video Development Creating custom MPEG2 media type

  I would like to modify BasicPlayback media foundation sample in order to be able to open MPEG2 files. I know that native MF does not support MPEG2 format.But it is possible to create custom media type of MPEG2. Could you provide me a sample code how should I do that Thank you So if you wanted MF to be able to play back MPEG2 files, you would first need to write a Media Source for MPEG2, since Media Foundation doesn't natively provide one. I'm sure you've noticed the wavsource sample in the SDK. You would also need to write decoder(s) as MFT(s), for which the MFT_Grayscale sample might be useful. You're correct that this MPEG2 Media Source would need to provide mediatypes to describe its stream ...Show All

• .NET Development Trying to send a mail via SMTP in VB 2005 - Authorization problem

  I am having a the same problem. I created a VB 2005 app that would try to deliver mail with both System.Web.Mail and System.Net.Mail. Both methods will work if I don't authenticate. If I use the fields property to authenticate through System.Web.Mail, I can authenticate and send to users of the outside world. If I use the Credentials property of the SmtpClient class, I can't authenticate. Here is some code. System.Web.Mail - Authentication works If the authentication code is commented out, the code can still send to anyone that has an email address on my domain but can't send outside of the domain. If I include the authentication code, it can send to either internal or external. ----------------- ...Show All

• .NET Development Connecting to Access Database

  Does anyone know how to connect to a access database using vb.net I created the database in access and added the Odbcdataadapter and was able to preview the contents of the database. I have a text box with a next button and a new button. Each time I click next i want to see the names that i have in the database appear. When i click new i want to be able to enter a new name in the textbox and it gets written to the database i already have with the names. Any thoughts Thanks!! You have this code: if Me.theDataSet.Tables(0).Rows.Count <= curPos then Me.theTextBox.Text = Me.theDataSet.Tables(0).Rows(curPos)(" ColumnName ").ToString() curPos = curPos + 1 else Me.theTextBox.Text = & ...Show All

• Visual C# Why is fixing runtime bugs expensive?

  I am a novice C# programmer. In the title “Learning C#,” the author states that it is much more expensive to fix a bug at runtime than at design time or compile time. I am wondering if it would indeed be as expensive as he says if the application goes through an SQA cycle before it is deployed. Whether you catch it at design or compile time, or rather at runtime, why would there be more or less cost involved Please shed some light on this. Nimrand wrote: ...developer could produce the same level quality software with much less time/money if... This assumption is wrong. Same developer with same tool used at initial step of development process will create same result (same bugs). The on ...Show All

• Software Development for Windows Vista Type Intialization Error for Custom State Activity

  Hi, We have Created our own custom State Activity called " WorkflowState" by deriving it from System.Workflow.Activities. StateActivity. We have succesfully created the workflows using visual studio. The Designer shows the custom state and we could add the event driven activities. But when we come back later and open the Workflows using the Visual Studio Designer, we get the following error. Error Loading Workflow The type initializer for UTProduct.Web.Workflow.Activities.WorkflowState threw an exception. This behaviour is different on different machines. Sometimes after cleaning the solution and re-opening visual studio helps me in opening the workflows. But sometimes it never opens. Please find the co ...Show All