AndyL's Q&A profile

• .NET Development add parameters to oledb

  I'm trying to do something very simple... not for me :) I just want to select a MarketCode from a 1st combobox and fill a 2nd combobox with names I tried this Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load daMarketCode.Fill(DsMarketCode1) End Sub Private Sub ComboBox1_SelectedIndexChanged( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboMarketCode.SelectedIndexChanged Dim cmdSelect As System.Data.OleDb.OleDbCommand cmdSelect = Me .daAgentName.SelectCommand cmdSelect.Parameters.Add( "Market" , OleDb.OleDbType.WChar) cmdSelect.Parameters(0).Value = Me .cboMarketCode.Text Me .cnOp ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Managed -> Unmanaged Interop

  Hello to the XNA team! Looks like some pretty awesome work you've got done here guys! Me and my colleague are professional game developers considering writing "Yet Another 3D Game Engine(tm)" for XNA. So I have two questions for the team: 1.) Is there any chance of getting a preview of XNA before december so we can start developing immediately 2.) It would be nice if we could do a bit of interop between XNA, managed C++ and unmanaged C++. What are the chances of us being able to achieve this Thanks in advance! AndyL wrote: 2 - As far as I understand, interop will be possible only on the PC version, and both platforms are C# only. Just to clarify - for now it's C# only. Other lang ...Show All

• SQL Server Login failed for user 'XXXX\ASPNET'

  Hi all, I review my server report from my asp.net app through reportviewer, and I got this error: Cannot open database "myDB" requested by the login. The login failed. Login failed for user 'XXXX\ASPNET'. I use username and password to login my app, and 'XXXX\ASPNET' is my ASP.net service account. Any idea Thanks, Jone If you want to authenticate your users in DataSource, you need add to web.config in your web-application: <identity impersonate="true"/> and use "Windows integrated security" in your DataSource configuration. As result, your users will be authenticated in you database. ...Show All

• .NET Development Trusted_Connection Problem with VS2005

  I'm sure this is a known problem, but I can't seem to find the fix. My VS2005 app connects to the SQL Server database through web services. If I connect with a connection string that uses userid and password, no problem. But, if I change that to use a Trusted_Connection instead, it won't work. This worked fine when the app was compiled under VS2003, but has not since migrating it to VS2005. Is there some setting I need to tweak somewhere In IIS maybe TIA, Putting a username/password in the web.config file, encrypted or not, is not an option. As I said, this worked just fine in VS2003 with a Trusted_Connection. Not doing anything different (other than installing VS2005 and migrating my existing VS2003 app to VS2005), this sud ...Show All

• Windows Live Developer Forums About SSI for Messenger

  Hello dear My company(internet game company) want to login by MSN Messenger. It is SSI. So i wanna know about logic. If user already logined in Messeger and he open P4 window with someone. Where dose it redirect in P4 It redirect live.com or my RPS server I know when i want SSI, i have to use RPS. Thanks a lot ...Show All

• Visual Studio 2008 (Pre-release) enabling metadataSupport behavior via code

  I am emplementing a WCF service via c++/cli and hooking it into a legacy application. So far so good except that I can't seem to find the proper interface for enabling the metadataSupport behavior via code instead of a config file. Am I missing something obvious I am sure that you already noticed that metadata support has changed in recent bits. You can read about it e.g. here . The code listed below was written on June CTP and also works on July CTP. Ok, just C# code, but you get it... To enable HTTP GET WSDL retrieval, do this: ServiceHost sh = new ServiceHost( typeof(ITecTv), new Uri("http://localhost:7777/tectv")); ServiceMetadataBehavior smdb = new ServiceMetadataBehavior(); smdb.HttpGetEnabled ...Show All

• Visual C++ Proper code syntax for successfull connection with an ADO.net database

  Hi; Could someone point out my code error here. When I try to compile I get a C2065 OleDbConnection undeclared identifier error msg. Here is my code: #using <mscorlib.dll> #using <System.Data.dll> using namespace System; using namespace System::Data; using namespace System::Data::OleDb; #include "stdafx.h" int _tmain(int argc, _TCHAR* argv[]) { // The connection //string cnNwind; OleDbConnection * conn = new OleDbConnection(); conn->ConnectionString = S "Provider=Microsoft.Jet.OLEBD.4.0; " S"Data Source=C:\my_databases\taxLots.mdb"; // The connection string try { // Open Database conn->Open(); Console::WriteLine(S"Connected to database successf ...Show All

• Visual Studio Express Editions UGH....Save Function

  I am not getting why this is not working. I have tried to get this to work, TallDude has done a great deal to help me better understand this all. But I am still having trouble to get this to work. I want to understand how the NotePad FIle>Save works. I am thinking, as TallDude as suggested, that they use StreamReader/Writer. So in that thinking I am strying to get the File>Save Function to work. Here is the entire code: Imports System.IO Public Class Form1 Public FilePath As String = "" 'Open Option Private Sub mnuOpen_Click( ByVal sender As Object , _ ByVal e As System.EventArgs) Handles mnuOpen.Click Dim open1 As New OpenFileDialog 'display only text files ...Show All

• Visual Studio Team System Work Item Attachment

  When a document is attached with the work item, where is it stored Is there any size limit on the attachment You can check TFSWorkItemTrackingAttachments database for attachment data and WorkItemFiles table in TFSWorkItemTracking db for its pointer. You can check the default by going to http://<TFSBox>:<port>/WorkItemTracking/v1.0/ConfigurationSettingsService.asmx and using GetMaxAttachmentSize call. It is 4MB by default, but can be changed using SetMaxAttachmentSize call. See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=160471&SiteID=1 for more details, though most info in that post is related to Beta, there are only minor changes in RTM. ...Show All

• Visual C# Easy way to copy a DataTable

  Is there no easier way of copying a DataTable than this int i = 0; foreach ( DataRow newRow in newTable.Rows) { DataRow drCopy = oldTable.NewRow(); drCopy.ItemArray = newTable.Rows .ItemArray; oldTable.Rows.Add(drCopy); } This returns an empty table: oldTable = newTable.Copy(); Hi; Usually DataTable.Copy() works fine for me. Try doing newTable.AcceptChanges() before doing the copy. If you need to copy only the structure then use DataTable.CLone(). Shivam ...Show All

• .NET Development datetime xmlserialization

  when I invoke the webmothod,if one of the parameters is datatime,it will be serialized like:2007-02-08 16:30:21 +08:00,and it will be deserialized correctly on server according to the servers' timezone.But if the client misset the timezone,the server will get a wrong datatime.Is there any way to serializie ( deserialize) the datetime independenting upon the timezone If both the client and the server use .net v2 you can do that by using new exposed property on teh DateTime instance: Kind property, just make sure that all your DateTime instances are either DateTimeKind.Utc or DateTimeKind.Unspecified. Thanks, Elena ...Show All

• SQL Server Casting...

  I've got an ftp task that will be downloading a couple of files each night. today they're called blah20060830blah the date value in the middle changes each day. I'm trying to adjust this value with an expression. The expression doesn't want to cast my getdate function into a string that this property will accept. I know i'm missing something stupid. Thank you so...if the remote variable is now being set w/ an expression, why can't I leave the field blank Aside from making lost of extra variables is there any advantage to putting these strings in variable derived from my date variable Thanks ...Show All

• Visual Studio Programmatically enable/disable menuitems within the Export button

  I understand that extensibility is limited in ReportViewer.WinForms.8.0.0.0. Is there a way I may access the visible properties of the menuitems within the ExportButton control ShowExportButton has been published as a property, however, I require access to the menuitems within the Export button such as "Adobe PDF", "Excel". Our company policy requires that certain reports such as annual statements be exported to "read-only" PDFs, as Excel documents may be altered. I have attepted to iterate the controls within ReportViewer.Controls to no avail, but have only been able to iterate to paramSplitContainer. Is there any way I may access the properties of these menuitems without using Win32 API I understand ReportV ...Show All

• Visual Studio Team System Test List Results and Reporting

  I am wondering about how to track the results of a test list containing a number of manual test cases In other words, if I have say 10 different scenarios created in 10 test lists, where can I see the total number of test cases that I need to run Also, if I only select 1 test list to execute (run) at a time, is there somewhere to see the overall project solution execution statistics PM's would like me to report on progress based on how many test cases are run based on total available and also how many have passed or failed of those that have been run. Not sure how to get these statistics out of Team Suite for Testers. Anyone know how to do this Hi, I am just following on from this question as I have the same problem. ...Show All

• .NET Development NetworkStream.Send doesn't throw exception on disconnect

  The problem in brief: When I pull out the network cable on a PC with the client app, the appropriate exception, on the server app, gets thrown on NetworkStream.EndReceive() and NOT on NetworkStream.Write or EndWrite(). Some more detail. I've done a fair amount of research on this topic. I understand that the only way for TCP to know that one side of the connection has failed at a low level, (i.e. hardware failure or perhaps below level 4 in the OSI model), is for several packets to go un-acked when one side sends some data. I understand that retransmission timeouts get progressively larger, and that by default, Windows sends 5 retries. In my case, I'm using NetworkStream.Write() and NetworkStream.BeginReceive() and EndReceive(). Everything ...Show All