Dietz's Q&A profile

• Visual C# C# and SQL Query

  Ok... Ive started learning C#. I have loaded a datasource odbc connection and dropped 1 of my tables onto my form. Now I also have a textbox and button on my form. The text box takes the current date and converts it to excel serial date and stores that into a variable 'serial'. Now I need to make a query on my table. I can create a query comparing 2 columns without a problem. My problem is that I cannot use my variable 'serial' in my query. Here is what it looks like: SELECT ... FROM ... WHERE WHERE TranDetail.EndDateTime = TranHeader.EndDateTime AND (TranDetail.EndDateTime >= @serial) I am using the query builder. I cannot get the TranDetail.EndDateTime >= @serial to work. I know its not able to use my variable ...Show All

• Windows Forms Install Certificate for WSE 3.0 Encryption via ClickOnce

  I have an application that is made up of Webservices and a SmartClient that comsume those webservices. The clients will be installed over the internet so for security I was going to use WSE 3.0 and usernameTokens. This requires a X.509 certificate with the private key installed on the server and the public key installed on the client. Ideally the location on the client would be the Current User store. For the final release I intend to sign my code and download with a Digital ID certificate. This would allow the application to be installed with Full Trust which I imagine it is going to need to install certificates on the local machine. Does anyone have an examples or articles that demonstrate how to install a certificate via Clic ...Show All

• Visual Basic Bypass Print Button on ReportViewer

  I'm developing an application that will print a random 10 digit integer on a receipt (passcode for temporary use of application), but I'm not sure how to bypass using the Print icon on the toolbar of the ReportViewer. I would like to use a single button to create the value, put it in a database and print the receipt. I have everything working, but I have to click my create passcode button and then click on the print button once the report is showing. My question is: Can I call the print function from the ReportViewer toolbar within my Create Passcode button's code It would be really annoying to have to click twice to do what should be a single function. Thanks. btnLast moves the recordset pointer t ...Show All

• Visual Studio Express Editions pulling data from one table then saving to another?

  Hello World, As the title suggests im populating textboxes and comboboxes from a table in an ms access db, I have created another table in the same database and i would like to save the data im pulling from table1 to table2.. this means that my data will be repeated in the new table so is probably not the best idea performance wise so im stuck on how i do this i need the data in table2 (invoice data) to work together with table1 (customer data) im I doing this the right way or is there an easier way to go about this Any help in this matter would be great :) I understand the basics of the code but the insert and the reference to an sql connection, is that for MS Access as well Thanks! ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Raytracing with DirectX

  [original question from split thread http://forums.microsoft.com/MSDN/showpost.aspx postid=1274336&siteid=1 ]  As a sidenote, if you know, could you explain to me the relationship between Shader Model 3.0/4.0 and DirectX9/10. I've read the documentation, but am a little confused. If a motherboard supports DirectX 10, does it automatically have support for SM4.0, or can it be DX10 and still only have support for SM3.0   Actually, there is a case where some new motherboards support DirectX 10. The Intel, DG965WH says in its manual:   http://www.intel.com/design/motherbd/wh/wh_documentation.htm that it does support DirectX 10 through the onboard video chipset X3000. There are conflicting reports on the int ...Show All

• Smart Device Development Overriding wceload's install directory in WM5

  In previous versions of Windows Mobile (starting with 2002, anyway), there was a way to programmatically override the install directory for a CAB with wceload.exe by using the /noaskdest command line switch and populating the following registry key: HKLM\Software\Apps\Microsoft Application Installer\Install With WM5, though, that functionality is half-broken. It's not completely ignoring that key, because the CAB file specified there is still installed, but it's ignoring the install directory that's specified there. What I'm wondering is, when will this bug be fixed, or is there now an alternate way to do it My reasons for wanting to do this instead of using wceload's install destination GUI are two-fold: - Uniform destination selection G ...Show All

• Visual Studio VSS20005+VS2005 Certification error

  I've been trying to get VSS2005 to work over the Internet by following the directions at http://alinconstantin.homeip.net/WebDocs/Scc/Default.htm but i can't get it to work. All the settings are done (ie setting VSS to use SSL, filling in the adress, configuring VS2005 to use the VSS over Internet plugin). I used SelfSSL to generate and assign a certificate on my server and installed it via IE (on my workstation via the View Certificate->Install in IE6 and on my server via the IE7 Content->Certificates->Import) but it doesn't seem to accept it. In IE it works because i can now access https://myserver/ without IE showing the messagebox about certificates. If i disable the Over Internet-setting it works just fine, howev ...Show All

• Community Chat What version of vista are YOU getting?

  So, out of all of the editions, Home Basic, Home Premium, Business, Enterprise, Starter and Ultimate , which are you getting I am going to get Home Premium because it seems like it has mostly everything I would need. Comes with mostly everything except backing up software which you can just download. So, what are you getting I'm going for the Ultimate. I'm going to needed it, for everything I need to do. Now here's to hoping I'll find an OEM that will include it on a system of theirs... (why do I doubt this) ...Show All

• SQL Server Save query results for Word Mail merge

  Real beginner question, I have an ASP.net web app for a little ordering system. I want to be able to easily save the results of a SQL query someplace so that I can use Word to do a mail merge to produce Avery Address labels. Seems to me this should be very simple and yet I'm lost between the worlds of VB.net 2005, ASP.net 2.0, SQL2005, VBA, Office2003. If anyone knows off the top of their head I'd really appreciate it, its really easy using Access however I already have the dBase created in SQL and really don't want ot have to back-pedal.... Thanks, Rick Thanks I figured that out and so I guess I can merely drop a query into a temporary table on the dbase and then use the mail merge wizard...... Of course I was real ...Show All

• Windows Forms Links in a FormsApp and controlling the browser

  Opening links is easy, like this private void button1_Click( object sender, EventArgs e) { System.Diagnostics. Process .Start( http://www.google.com ); } private void button2_Click( object sender, EventArgs e) { System.Diagnostics. Process .Start( http://www.yahoo.com ); } But is there a way to control if the link is opened in a new browser window or an existing one Well, I'm not sure. but at least you can have a try HKEY_CLASSES_ROOT\HTTP\shell\open\command\ddeexec\Application indicates the default browser and, HKEY_CLASSES_ROOT\HTTP\shell\open\command indicates the command line passed to the browser ...Show All

• Software Development for Windows Vista Unable to create folder in C:\Windows\WinSXS in Vista OS

  Hi, I was checking compatibility of one of my MFC application in Vista OS. Usually if the MFC shared dlls are not present, i used to copy them in WinSXS under folder with the required folder name like x86_Microsoft.VC80.xxxx. (Installing VC++ Redist also didnt work in my case.) And this would make the application work perfectly. When i tried to do the same thing in Vista OS, it failed to create the folder. I removed the read only attributes and tried again but in vain. The error i am getting is "User didnt have enough permission to perform this task" but I logged in as Administrator. I tried to change the security attibutes of Administrator but could not find the Users under Computer Management. Is there any solution ...Show All

• .NET Development Email Ordering

  Hello everyone, I have a small design issue with a site that I have been contracted to develop. The site is a basic online catalog of dvd's etc... and can be ordered online. But the issue is that for about 6 months or so they wont be implementing online credit card purchaing. they want to be emailed the ordering details such as credit card and user information. Now this is obviously very sensitive data and must be encrypted, can someone please give me an idea as to how to implement this Thanks thanks for that, that is a great start for me, and looks like it will do. In regards to s/mime I wont need it, since the emails will just be text I think... ...Show All

• Visual Basic XML Documentation Comments not working.

  Hi there. After struggling a bit with XML Documentation Comments earlier today, I just thought I would leave this comment, in case someone else has similar problems. One of the Projects in my VB.NET Solution seemed unwilling to let me write XML Documentation in my code. When tapping ''' on the line directly above a method declaration, nothing would happen. The project consisted of modules and classes only(no forms), so I initially thought that had something to do with it. Later I found that under project properties and the Compile tab, the "Generate XML documentation file" checkbox was left unchecked. Checking this instantly allowed me to place the comments normally. After doing some testing, I also found that Creating an Empty pr ...Show All

• Visual Studio Team System Cherry Pick Merge causes conflict

  I know this subject has come up a few times in the forum, and I've read the answers to those - but still not sure I'm following the answer. I am following an admittedly old webcast from TechEd 2005 by Douglas Neumann that talks about TFS Promotion Modeling, and the ability to Cherry-Pick merge a particular changeset. I'm wondering has something changed since the beta when this seemingly worked Very similar to the demo, I have the following setup: DEV branched to QA (changeset 29) DEV class1.cs QA class1.cs Make a change to class1.cs and check it in + add new property called "NewFeature" for the next release (changeset 30) Make another change to class1.cs for a bug fix and check it in + add new property called "BugFix", need this in th ...Show All

• Visual Studio Team System How to run web tests using command line tool.

  Hi all, I have recorded web tests . can anybody help me how to run these tests using MSTests. Peetha, You can run .webtest files using the mstest.exe file with the following syntax: mstest.exe /TestContainer:<yourtestname>.webtest If your web test is coded, you can run it from the compiled DLL using this syntax: mstest.exe /TestContainer:<DLLName>.dll /Test:<testname> More information can be found by accessing the help on mstest.exe using the / switch. Hope this helps! --Mike ...Show All