Itzik Katzav's Q&A profile

• Visual Studio Express Editions Problem with quering access DB

  hello i have an access database that i want to query with an select * from where sql statement. I would like to build the statement in the code, and not in the dataset designer. i have an existing dataset connected to the DB but using tableadapters and the existing dataset how do i A. run a query on this db B. modify said query to change the filter on the returnning dataset C. change the Datagrid to use the returning dataset as source all i really need help with is applying the query to the DB I would be grateful for any help provided Matt take a look at this thread to see if it helps... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1175290&SiteID=1 ...Show All

• Visual Studio Express Editions relays...

  Could someone point me towards some material on programing with the serial port or if someone saw a post on a site like hackaday that uses serial port programming. I am trying to be able to control 4 relays (or i can start with 1) over the serial port. or usb, you decide what the best thing would be to use. Thanks to all the people who post on msdn forums.. Average Joe As has been stated, you probably shouldn't use the RS232 port to power a relay...I would say your best option would be to use a STAMP chip of some kind which communicates serially, is programmable, and has I/O ports that could be used to power some small relays (or at least interface boards are available). You can have quite a bit ...Show All

• Visual Studio Express Editions how to build a web browser in build flash player like opera

  hi pls respond me quickly i also like how can we add tab at run time that is allowing the user to view more pages in web browser narasiman, What is the meaning of view more pages in web browser Would you like to see more contects or just some certain configurations on IE7 to see more tabs when you run the IE7 Generally speaking, when you close IE7 with several tabs, there is a dialog box shown after you click the close button. In the dialog box, you are asked "Do you want to close all tabs " with the follwoing two options: Open these the next time I use Internet Explore and Do not show me this dialog again. This piece of message will be shown when the RadioButton Show Options clicked. It means that the state of the Ra ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. SpriteBatch.Draw(..., float layerDepth) No Longer Works For Me

  I guess that the deprecated BeginScene() used to automatically changed some device states in order to make it possible for layerDepth to work. But since that function is gone in Beta 2, I no longer know how to automatically depth order my textures. Is there a set of device states I need to be in to get this automatic sorting If not, I'll just write my own sorting code. Thanks! Terry A. King wrote: I have a question which sounds quite similar, or may offer a solution, to this. My question is how do I depth sort more than one SpriteBatch My initial test shows using : batch.Begin( SpriteBlendMode .AlphaBlend, SpriteSortMode .BackToFront, SaveStateMode .None); will correctly draw the sprites in the correct ...Show All

• .NET Development C# Interop problem with ASP.Net

  I am using DllImport to call the win32 API of our own C++ dll. The API takes pointer to pointer to struct. So I am passing reference of IntPtr to that API and getting the data . I am using Marshal.ReadIntPtr to get each pointer to struct and get the data within the struct. If I call this API from any windows application (console) I am getting the proper output and everything works fine. But incase of ASP.Net, when I call the API from the code behind, the data comes properly but, in many cases the aspnet_wp.exe crashes. When I debug that, I found that till the page_unload of the web page everything works fine, and after that only suddenly the worker process crashes. Thus I felt there can be some problem in deallocat ...Show All

• Visual Basic A Few Questions (VB, Studio 05)

  I have a couple of questions, I've used the "service control" tool to control spoolsv and a few other non-essential system processes(starting and stopping) I'm using the following code; in this case I'm using the spoolsv code. StartSpool.ServiceName = "Spooler" StartSpool.Start() Is there a way of adding an If/Else to error handle As when one of the processes is already stopped and I click the "stop spool" button it crashes the application and (for me) causes an extreme slow down on my pc for a few minutes. I would like to know if its possible to add a message box, if the process is not running. Further to this, is it possible to use checkboxes to select items, then through 1 command b ...Show All

• Windows Forms Concurrency error with VB2005 and SQL2000

  Ok im trying to do an update on a dataset into a single non related table on my sql database. Ive written my own insert/update commands, added a new row to the datatable done an update and acceptchanges and i sometimes get the concurrency error. What am i missing here   Im more than happy to overwrite any changes that may be made on the database, the last edit takes priority.  Not very clean no,  but i need a quick fix :o)  Is there a setting somewhere i can make to allow it to ignore any changes made elsewhere   Dim row As DataRow = dsAddressTables.Tables( "PartyRole" ).NewRow row( "PartyRoleTypeID" ) = m_intPartyRoleType row( "TheirRef" ) = m_strTheirReference row( "ContactName" ) = m_strC ...Show All

• SQL Server Is there a way to parameterize lock type?

  Hello, I have a stored procedure where I select data using a lock hint, e.g.: select * from MyTable with (UPDLOCK) Depending on arguments passed to a procedure I need to be able to turn locking on and off, otherwise I will have to create two versions of a stored procedure (or two SELECT blocks in one) with duplicate contents that differ only in lock directive. Is there any way in SQL server to parameterize locking Thanks in advance ( I did test this after the last post, but despite what I previously said, I did NOT see any measureable slowdown because of changing the isolation levels. I was wrong. Sorry about that. ) ...Show All

• SQL Server server timeout

  In SQL server management studio: When doing ex count(*) for a big table or create index or like, I get timeout error. The timeout setting = 0 Even timeout = 888888 gives timeout Does not the query execution timeout parameter work Or are there other parameters needed to be ajusted Could you apply SQL Server 2005 Service Pack 1 Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ ...Show All

• SQL Server Poor performance with functions in selects

  Hi We have the following query that we were trying to execute and it performs very poorly... SELECT ITEM_ID , PART_NO , PART_TITLE , dbo . SFDB_NVL_VARCHAR ( DRAWING_NO_DISP , 'N/A' ) AS DRAWING_NO , dbo . SFDB_NVL_VARCHAR ( DRAWING_CHG_DISP , 'N/A' ) AS DRAWING_CHG , DRAWING_NO_DISP , DRAWING_CHG_DISP , REV_SOURCE , ITEM_ID AS ASSY_ITEM_ID , dbo . SFDB_NVL_VARCHAR ( DRAWING_NO_DISP , 'N/A' ) AS ASSY_DRAWING_NO , SFMFG . SFDB_NVL_VARCHAR ( DRAWING_CHG_DISP , 'N/A' ) AS ASSY_DRAWING_CHG FROM SFSQA_CHAD_PART_DSPTCH_DSP_SEL ORDER BY PART_NO The function SFDB_NVL_VARCHAR is nothing but a replication of nvl function of oracle. CREATE FUNCTION [dbo] . [SFDB_N ...Show All

• Software Development for Windows Vista XOML Custom Activity

  Hi There, Is it possible to have a Xoml custom activity And have the dependency property and execute method calls in xoml [without using the xmol.cs file] Any work arounds and pointers with samples will be helpfull. Thanks!! No, this is not possible in WF V1. We're working on improving this story for our future releases. Here's another post on the same issue: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=996072&SiteID=1 ...Show All

• Visual Studio Tools for Office MS Office add-in with licensed components

  Hi I wonder if I can write a MS Office add-in with VSTO that uses some third part licensed components. How the licenses will be "transfered" to the executing process (e.g. Outlook.exe) Can I use licensed components in my add-in or I have to use only the components that are shipped with Visual Studio (For example I've tried it with TxTextControl and is not working). You can use third-party components, chart and reporting controls, etc. with VSTO SE or VSTO 2005. I am not sure what you mean by "transferring" the license. Most third-party vendors provide their own guidance for installing, distributing, and licensing their product. the VSTO tools are agnostic in these matters. For example ...Show All

• Visual Studio 2008 (Pre-release) MessageVersion.None problem

  Hi, I created a custom POX binding with the following binding elements: 1. HttpTransportBindingElement 2. TextMessageEncodingBindingElement( MessageVersion.None , ...) 3. A custom inteception channel that intercepts a message and Logs it in the following code void Log(ref Message msg) { ... using (XmlTextWriter writer = ... ) { msg.WriteMessage(writer); } msg = msg.CreateBufferedCopy(int.MaxValue).CreateMessage(); } When I try to write the message (bolded above) I get "The body reader is in ReadState 'Initial' and cannot be consumed." exception(detailed below) What do I need to do to be able to use the message System.ServiceModel.Channe ...Show All

• Windows Live Developer Forums newMediaObject support

  I read that this is not supported, but Windows Live Writer seems to use it. Has anyone tried this --Scott Thibault ...Show All

• .NET Development Best method to insert the content of an XmlWriter into another XmlDocument?

  I have an XmlWriter stored as a MemoryStream. I would like to insert it into an existing XmlDocument. So far I have loaded the XmlWriter into its own XmlDocument and then imported the nodes into the existing XmlDocument. Is there a better way using XmlDocument of doing this Thanks, Tad p.s. I have used the CreateDocumentType (see below) in my code but it appears incredibly slow. Is there a faster method of creating the Document Type element When I tried it on my XmlWriter it raised an error. xmldoc.AppendChild(xmldoc.CreateDocumentType("svg","-//W3C//DTD SVG 1.1//EN","http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd",null)); You can insert nodes to XmlDocument from ...Show All