akuehn's Q&A profile

• .NET Development Can't connect to database from web service!

  I have a web service that I am trying to get to connect to a SQL 2000 database. I have tried connecting with ODBCConnection and OleDbConnection and I am not able to open a connection with either one. The code I tried with both of these connection methods works fine in a .Net Windows Forms application. It seems to fail both times on the connection.Open() call for whatever reason. Anyone know what might cause this and a solution I can do Thanks, Michael do you have access to edit the code try { connection->Open(); command = new OleDbCommand(query, connection); reader = command->ExecuteReader(); reader->Read(); if (reader->HasRows) { this ->recurren ...Show All

• .NET Development What is the best book that covers using XML in c#?

  I've been looking for a good XML reference using c#. I've found an older ".net and XML" from O'Reilly books, but it doesn't seem to cover the topic in enough detail. Is there a better one available Most of the books I find are purely about XML. This is such a common topic; I'm a little surprised by the lack of publications. There are several online tutorials, but there isn’t a tome on the subject Thanks in advance for suggestions. Hello Tryst, I got the book, and it has been very helpful. Lots of information and examples on using the classes in System.Xml and System.Xml.Serialization, both of which were of interest to me. Thanks for the recommendation. WTW ...Show All

• SQL Server Only show field on last page

  Hallo, i would like to show some fields only on the last page on the report. How can i achieve this (The field is in the body area) King regards, Christian Niehaves The idea was to create a VB.NET variable in the report properties Code tab. Since PageNumber and TotalPages are available only in the page header/footer, use one of the exression-based properties of the Page Header band to set the variable and then read it from the Textbox in the body section, e.g. =Code._PageNumber (assuming that _PageNumber is the variable). ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. ExternalReference from custom ContentImporter

  I'm writing a custom Importer in which I have a number of references to textures. It seems I must reference the built files (xnb files) in my ContentWriter; how can I build the textures in the import-stage of the pipeline (in ContentImporter.Import()), and how do I get a reference to the built files Aha, but how do I create the ExternalReference<> It complaints that... Building content threw ArgumentException: External reference "F:\dev\Lidgren\XNA\Lidgren.Xna.Render\RenderTestApp\Content\Skybox\0001" is not a compiled .xnb file. ... I assume I could use context.BuildAsset<>() but i'd prefer not to hardcode the processor used into this processor - i'd rather just reference the ...Show All

• Visual Studio Team System Unable to fix binding using tfpt

  Hi all, Here what I've done. Please let me know if I missed something. 1. Get files from VSS 2. Added into TFS by add folder 3. Create workspace. 4. Get latest into workspace 5. From command line prompt go to workspace directory and execute tfpt bind /convert /r. As a result, nothing happen. No error/warning message. Best Regards, The only thing you need to do at this point is open the solution in Visual Studio. Any other fix up required (if any, depends on the solution layout and workspace mappings) will be done when loaded in Visual Studio. Ed ...Show All

• Visual Basic save option on the MenuStrip

  I have already written code to save a items from my form by clicking a button. The code can be seen below: Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click 'Save the order and display feedback Dim Details As New ArrayList Details.Add(cbxItem1.Text) Details.Add(txtQty1.Text) Details.Add(txtPrice1.Text) Details.Add(cbxItem2.Text) Details.Add(txtQty2.Text) Details.Add(txtPrice2.Text) Details.Add(cbxItem3.Text) Details.Add(txtQty3.Text) Details.Add(txtPrice3.Text) MessageBox.Show(Controller.Save(txtID.Text, txtName.Text, txtDate.Text, txtStreet.Text, txtCity.Text, txtState.Text, txtZipCode.Text, Details)) lblFoodTotal.Text = Order.Foo ...Show All

• Visual Studio Express Editions Move It

  How do I make a button on my form to be always 10 pixels from the left side of the form and 10 up from the bottom, when each time the form loads it resizes to match a picture in a picture box Keep that copy of the MSDN library handy when you program. Me.ClientSize = new Size(pbCrop.Width, pbCrop.Height + 100) ...Show All

• .NET Development Add SSL WebService Reference to VS.NET Project

  When i try add web reference to ssl webservice. the error 403 appear . How can i add reference to SSL webservice the error print screen attached . This problem is Microsoft Known BUG in VS-2003. but you can used the workaround. You must download the WSE 2.0 SP1, if you haven’t already ( http://www.microsoft.com /downloads/ThankYou.aspx familyId=dab3ad9f-be8f-42e1 -95fe-9aae41a487f3&displayLang =en ), and add a reference to Microsoft.Web.Services2 in your project. and you need change your code by adding mannualy the certificate to Instance of Webservice object, this is a sample code: using WseX509 = Microsoft.Web.Services2 .Security.X509; [...] // Create web servi ...Show All

• .NET Development dataset throwing arithmetic exception

  I have a function that is throwing an arithmetic exception when I try to store a 10 digit number. I checked the database, the field is set to bigint and I can enter the number manually without any problems. I also tested the stored procedure I use to insert the data and it too will accept the number without any problems. However, when I use the data table's add row method I get an arithmetic exception. The field in the dataset is set to System.Int64. I am lost as to what may be causing this. Any help would be greatly appreciated. thanks, Luis Here is the source code I'm using. Basically I get a DirectoryInfo or FileInfo object and pass some of the values to a database table in memory Private Sub AddFileToEx ...Show All

• Visual Studio Express Editions grrrr - registering

  For some reason the registration page says my email address is invalid so i can't get the key, but its the same one i logged on with. Help Thanks!! I came across the same problem. I have had my email address for many years and it's find, but it keeps barking about it. I'm stuck as well and MS is no help unless I pay $99 for them to resolve this issue. ...Show All

• SQL Server transactionoption=required

  Hi I set the transactionoption = required at package level. This package has a couple of dataflow taks and both the tasks are set transactionoption = supported. If one of them fails, both the tasks should be rolled back. When I run the package, it simply hangs at the first dataflow task with no error message. I had to stop debug to stop the execution of the package. My system has DTC service enabled with Network DTC access enabled and the sql server is running on my local machine, which is windows xp box. Any idea why this happens and the solution or workaround for this Thanks Ramani Hi Ramani, The problem may be due to following reasons: 1. It seems there are many data f ...Show All

• .NET Development execute stored procedure on only selected rows

  using inventorytableadapter.updateQuery1("itemno") I'm able to subtract Invoicedetails "Qty" from Inventory "Instock" but I need to add a where clause to this query so that only the selected rows are updated here's my query UPDATE Inventory SET InStock = Inventory.InStock - InvoiceDetails.QTY FROM Inventory INNER JOIN InvoiceDetails ON Inventory.ItemNo = InvoiceDetails.ItemNumber; where ( Itemno=@Itemno ) SELECT ItemNo, ItemDescription, InStock, Units, Cost, ItemID FROM Inventory WHERE (Itemno = @Itemno) Any Ideas Hi,   What is that you want to do Because in your thread it seems that you want to do somethi ...Show All

• SQL Server SQL Way to Suppress Repeated Values

  This is a problem I usually solve with procedural code, but I am wondering how/if it could be done with SQL queries. A simple one to many query like: Select inv.invnbr, inv.freight, invline.quantity, invline.partnbr, invline.cost from inv inner join invline on inv.id = invline.InvID Returns something like: invnbr freight quantity partnbr cost 100 50 3 abc 50 100 50 6 def 65 100 50 10 ghi 70 Is there way I can rewrite the query, or add a subquery such that the result set would be: invnbr freight quantity partnbr cost 100 50 3 abc 50 100 0 6 def 65 100 0 10 ghi 70 Eg, the freight value, which comes from the one/header table, ...Show All

• SQL Server Installing sql express

  When I run the install script, I always get a warning that the hard drive (space ) won't support the install, but I have installed successfully with the new tools etc. and I still have 20 gigs left on my laptop. Why is this warning given thx, Kat Thank you for telling me how to get the error message... I'm learning something new everyday! Error message below: "The current system does not meet minimum hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online" Kat ...Show All

• Visual Studio 2008 (Pre-release) Syntax for Binding Attached Properties

  Hi, I am trying to bind an attached property to another dependency property. I believe I can do something like this, but I'm not sure what the right syntax is: < ScrollViewer Name = " scvPageViewer " HorizontalScrollBarVisibility = " Auto " VerticalScrollBarVisibility = " Auto " > < Grid x:Name = " PageSizer " > < local:BrickPanel x:Name = " LayoutPanel " /> < local:BrickPanel Orientation = " Vertical " HorizontalAlignment = " Left " VerticalAlignment = " Top " Background = " Gray " > < local:PriorityOffsetPanel local:BrickPanel.Offset = " {Binding RelativeSource={Relat ...Show All