RogerVillela's Q&A profile

• SQL Server How to create XML documents over 8000 bytes?

  I have a script transform object that is creating XML to be inserted into a SQL 2005 database. It seems only an N_TEXT can be inserted, but N_TEXT is read-only in the script task.  The only way I've found to make this work is to have the script transform produce the XML into a DT_STR(8000) string, then convert that to N_TEXT in a Data Conversion task so it can be inserted. Now I have a problem in that my XML has exceeded the 8000 byte DT_STR data type.  Is there another way to do this Jay Actually, since we're talking about NTEXT, that should be Unicode.GetBytes(). ...Show All

• SQL Server SSMS Express: Using PIVOT operator to Create Pivot Table - Error Messages 156 & 207

  Hi all, In MyDatabase, I have a TABLE dbo.LabData created by the following SQLQuery.sql: USE MyDatabase GO CREATE TABLE dbo . LabResults ( SampleID int PRIMARY KEY NOT NULL, SampleName varchar ( 25 ) NOT NULL, AnalyteName varchar ( 25 ) NOT NULL, Concentration decimal ( 6.2 ) NULL) GO --Inserting data into a table INSERT dbo . LabResults ( SampleID , SampleName , AnalyteName , Concentration ) VALUES ( 1 , 'MW2' , 'Acetone' , 1.00 ) INSERT … ) VALUES ( 2 , 'MW2' , 'Dichloroethene' , 1.00 ) INSERT … ) VALUES ( 3 , 'MW2' , 'Trichloroethene' , 20.00 ) ...Show All

• Smart Device Development Interaction with bluetooth headset

  Hi, is there an easy way to play some audio via a bluetooth headset or capture the audio from the headset I didn't find a lot of information about this on the web & msdn but I'm sure I'm not the first person trying to write an application interacting with a BT headset... michivo If the device uses the Microsoft stack and uses the Microsoft headset profile (Doesn't work on most WM2003 devices as the headset support was OEM implemented) you can toggle the system audio to be played through the headset. See here for an example:- http://www.peterfoot.net/DivertSystemAudioToABluetoothHeadset.aspx This a ...Show All

• Windows Forms Update not opening

  I on a win XP Home with sp2, I can get to the Microsoft site but when clicking on the windows update link or try to access it from tools on IE all I get is a blank page. ...Show All

• Visual Studio 2008 (Pre-release) Trigger runtime exception

  Hi, What's wrong with this XAML that throws an exception at runtime <StackPanel.Triggers> <Trigger Property="IsMouseOver" Value="True"> <Setter Property="Cursor" Value="Hand" /> </Trigger> </StackPanel.Triggers> Thanks, Fernando Only EventTriggers are supported in this case - Property triggers are not, and hence the exception. To achieve this, you can try setting this via a style. Thanks, -Unni ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Terrain Rendering

  I have a quick question... What are some of the best/simplest ways to render large terrains for games such as a MMO or a FPS like Far Cry I have skimmed over some LOD stuff using quadtrees and this seems to be ok but I was thinking of using an LOD technique that changes with distance from camera. I am not sure what this is called. But i was wondering if this would be a good way to go about it. Thanks in advance. Sorry to hijack a bit here. But I have heard abou streadmin/paging before, but it is hard to find any info on it. Info like, how big should the terrain parts be, and how do you load the other terrain In an other thread with low ...Show All

• Visual Studio Express Editions Syntax Error, Missing operand after '=' operator

  hi, i have this code to fill a data adapter in c#.net: this.freedomScooterServiceBindingSource.Filter = "CustomerID = " + comboBoxCustomer.SelectedValue; It worked fine during running of the application, but when i exit the application, it threw error " Syntax Error, Missing operand after '=' operator " on this line of code i checked it against some sample code, ther is no syntax error, but why is this happening plz help ssfftt: I'd start be seeing whether you are missing the single quotes in your filter string. The example for BindingSource shows this: BindingSource1.Filter = "ContactTitle='O ...Show All

• SQL Server DataBase Connection

  hi everybody; my questions about when database connection : i am when connecting database latter receiveing exception error.Error is : An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll codes : SqlCeConnection cnn=new SqlCeConnection("Datasource=\\My Documents\\Business\\LOREAL.sdf"); cnn.Open(); // Exception is here help me.. can i doing Mehmet, Try the code below instead - it fixes your connection string and provides you with a way to get more information about specific exceptions you may encounter using SQL Mobil ...Show All

• Windows Forms ChildForm...

  I nedd your help, guys. I've a rather simple win app: main form with simple menu & child form. I want to call child form from menu, do some operations on child form & then I want to change text on main form. So, my 1st attempt was rather simple: on child form I've tried (child form is called from menu item): this.ParentForm.Text = "Re ...Show All

• SQL Server search a database

  Hi, All In my trusty VB6, i would use some simple SQL to update a data grid as the user types into a text box, somthing like : Public Sub SalesSearchproductsquery1() Dim andrequired As Integer 'called on the lost focus of the search text boxes 'Build the search critera andrequired = False gsqlstr = "" gsqlstr = "Select * from productstbl " 'Build where only if something has been entered If Len(SerchItemCode1_txt & SerchSuppCode1_txt & SerchSuppName1_txt & SerchDiscript1_txt) > 0 Then gsqlstr = gsqlstr & " where " End If If Len(SerchItemCode1_txt) > 0 Then ...Show All

• .NET Development SerializationException on Sending Data Back to Serviced Component Via Remoting

  I've developed a distributed app in C#. The various components of the application are as follows: A SQL Server database. Data Access Layer - Hosted in COM+ as Library application. Business Logic Layer - Hosted in COM+ as Server application. User Interface (Windows-based). Types - Exposes various typed DataSet objects used by DAL, BLL, and UI. ServerHost - A Console app that exposes the BLL objects via remoting. The application is hosted on a machine running Windows XP SP2. The DAL and BLL are both hosted in COM+ on the same server that hosts the SQL Server database. Both of these projects and the UI project reference ...Show All

• SQL Server Lookup - full caching vs partial caching vs no caching

  I needed to do lookup on tables with approx 1 million records (how else do I know if record already exists ). Full caching: SSIS caches all million records (consuming around 1 GB RAM) and cripples my lowly system with only 1GB physical RAM. This works for now, but the lookup tables will keep on growing. This means that full pre-caching may not scale for this scenario. Partial caching and No caching: I don't really know how SSIS works in these modes. I can make my guesses but it will be great if someone can explain those. The behavior that I see when I use partial cache of varying sizes or when I use no cache at ...Show All

• Visual C# Message Box

  I'm using c#.net Windows application Before delete I want to prompt with a message box.. I want to have only two buttons Yes & No (As I feel cancel has the same functionality as Cancel - so I don't require that button) - But I want the Control Button on my Message Box window (i.e X on the right top of the window) But without adding the cancel buttong in the buttons - I'm not able to get it... Is there any other property to add it other than adding the cancel button. No. The MessageBox class is simply a wrapper around the standard Win32 message box. In this specific case I'm not sure that you'd want the "X" any ...Show All

• Windows Forms Create a windows application similar to Microsoft Outlook

  HI, Im trying to develop an application similar to Microsoft Outlook. If you open the contacts in Outllook using category view. There is a listing of contacts. Do I need to use a Datagrid for that. And if we click on any of the rows the full details of the record is displayed as a windows form. Can anyone suggest me or provide links as&n ...Show All

• Visual C# Restricting Certain URL's

  I would like to know how to design a code to be able to restrict URLS that are in a database. If someone could help me please. I got this code from a different question I asked, but it seemed like it is what you are after "There is a Navigating event which is fired just before the WebBrowser navigates to a new document. Realize this event fires anytime the location of the document displayed in the WebBrowser is changed, whether it be by clicking a link or programmatically." Link : http://forums.microsoft.com/msdn/ShowPost.aspx PostID=101785 ...Show All