auSwDev's Q&A profile

• SQL Server Scheduled sql cannot access the network drives???

  I have a stored procedure performing several tsql operations with MS Access and Excel files stored into the network file system, and therefore using OpenDataSouce with these files in the network, accessible through mapped network drives. My user has a profile that maps the necessary network drives at boot. SQL Server runs on the server with an account created for that. This accont has also a profile mapping the necessary network drives. The stored procedure runs fine only if I launch it with SQL Server Management Studio on the server, logging in directly on the server (at this point the network drives are mapped correctly). If I launch the Stored Procedure with SQL Server Management Studio on my client, it doesn't find the ne ...Show All

• .NET Development SQLDataSource update using parameters not working

  I'm passing a parameter to a stored procedure stored on my sqlserver, or trying to atleast. And then firing off the update command that contains that parameter from a button. But it's not changing my data on my server when I do so. I'm filling a dropdown list from a stored procedure and I have a little loop run another sp that grabs what the selected value should be in the dropdown list when the page loads/refreshes. All this works fine, just not sp that should update my data when I hit the submit button. It's supposed to update one of my tables to whatever the selected value is from my drop down list. But it doesn't even change anything. It just refreshes the page and goes back to the original value for my drop down list. Just to ...Show All

• Visual C# typeof permissions

  hello, I've been getting an error in my code, that I think occurs when I try to get the typeof my created object: System.Resources.ResourceManager resources = new System.Resources.ResourceManager( typeof (Control_object)); Are there security permissions needed for this to work properly, without getting a security error Thanks for any help. >> this .MyButtonControl.OcxState = ((System.Windows.Forms.AxHost.State)(resources.GetObject("MyButtonControl.OcxState"))); Now, if I follw this right, the object is MyButtonCOntrol, and OcxState is a property of it. Hence: MyButtonControl mbc = (MyButtonControl) (resources.GetObject("MyButtonControl"); this.MyButt ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Help With Model of SpaceShip

  Hey, i've been looking at the tutorial provided by microsoft on how to render a 3D model of a spaceship. I have completed it and added a reversing option with left trigger but now i want to make the camera follow the spaceship and to be able to also rotate the camera using the right thumbstick, does anyone know how to do this i will post my code below so you know what i have, any help would be nice. Thanks #region Using Statements using System; using System.Collections.Generic; using Microsoft.Xna.Framework; using Microsoft.Xna.Framework.Audio; using Microsoft.Xna.Framework.Content; using Microsoft.Xna.Framework.Graphics; using Microsoft.Xna.Framework.Input; using Microsoft.Xna.Framework.Storage; #endregion namespace My3DGame { public ...Show All

• Visual Studio Express Editions Making A Media Player

  Hi. I am making a media player. If sombody could answer these questions, it would be very helpful! 1) Is it possible in VBE 2) What code would I use to... a) Show a dialog to open an MP3 b) Begin to play the selected MP3 c) Stop the MP3 3) Can i show visualations (Spelling wrong, sorry) a) What code can I use Thank you! there was a series of elaborate dialogues on this. Use Search, Look up Cheyenne. Also there is a tutotial based around an MP3 player called How to use the debugger. Those should be very rich resources for you. ...Show All

• Windows Forms select distinct

  Hello, i hope someone could assist me... i could display my data by datagridveiw but found that there're some duplicated rows. how could i implement "select distinct" DML or same function working with datagridview but no DB existed. there're six columns on my datagridview, some lines(rows) are the same... msgsender msgreceiver subject date size msgid thanks in advance Richard Check out these kb articles on how to implement DataSet Select Distinct in VB or C# ...Show All

• Windows Forms License code / register code / key code

  Hi In my newly created solution I need a license key to make a install valid, How is this done (like microsoft key code) for example, A tutorial would be nice to read. My solution was maid in .NET C# VS2005 KK HI Thanks I did some brief looking, and many thanks its looks good. I will do some deeper reading later. Once again tahnks for fast reply. ...Show All

• .NET Development What is the best approach for mapping external data? Any ideas?

  Hi all: My boss and I are having discussions on what is the best way to migrate data from one (unknown) database to our database. Let me explain: We are looking to develop an application that should be able to attach to any ODBC database to grab data or individual records and import them into our database. Here's the problem, we may be unfamilair with the database or how the tables are laid out, we don't know where the data is located (up to their DBA), it could be normalized where our database or table is not, etc... I wanted to have the DBA for the database we are attaching to create a view of some sort or "export" the data into a specified format and then our application just do a field-to-field read into our da ...Show All

• .NET Development One call to DB for multiple datatables?

  Is it possible to fill multiple datatables in a dataset with ONE call to the database Ex:  Select OrderNumber from Orders where OrderNumber = @OrderNumber Select OrderItem, Quantity from OrderDetails where OrderNumber = @OrderNumber There are two select statements which are master detail related.  In my application, I would actually need three or four related tables.  I tried using the .GetChildRows method but that requires that both datatables already be filled.  I basically want to bring back several orders and ALL of their related order details at one time! What I am trying to do is load a treeview with 3 or 4 levels of data.  I am trying not to have to make a call to the database for each node le ...Show All

• Visual C# Program Crashes.

  I have been creating this program for a while now.. its a program that scans my works network IP's to see there hostnames.. and remove ip addr that does not have any host names.. but the program keeps crashing... The program crashes when I enter an IP address that does not have a hostname.. Can someone point me on the right direction Also.. Please forgive the way I coded it... I'm still learning.. and I'm still reading tutorials on a daily basis. Anyways.. I added the codes in a pastebin.. also any recommendations on the program would be helpfull. here is the link to the codes...   http://pastebin.com/823524 P.S: Unless you want me to post it here.. I will. Same here as Mike Said, I also ran it and provided some IP Addr ...Show All

• Architecture Designing multi-company databases

  I'm designing a website that can be used by multiple companies. It seems that there are two options: 1) The set of tables used by a company is owned by that company. This implies a database per company. This allows each company to upgrade individually but could cause managment problems with having many databases. 2) Use only one database but place a company ID column on each table. This implies only one database for the entire website but restricts companies from being able to upgrade independantly. Are there any other options besides the two listed above If not then which option do you think would be the best Certainly both approaches are feasable (and there's a third one); a lot depends ho ...Show All

• Visual C# Little Help

  I have figured out how to open webpages, but, if on the button click you open a webpage, say www.google.com. But, if you have a textbot on the program, and on the button click you want www.google.com/i-typed-this-in-the-textbot, how would you go about coding that Thanks I get errors with that. Error    1    'Thottbot.Form1' does not contain a definition for 'theTextBox'    C:\Documents and Settings\Justin\My Documents\Visual Studio 2005\Projects\Thottbot\Thottbot\Form1.cs    40    22    Thottbot Error    2    'Thottbot.Form1' does not contain a definition for 'theButton'    ...Show All

• Visual C++ nmake U1073 error on target file name contains Japanese characters

  Under Japanese XP SP2 - Use Visual Studio 2005 nmake to build a project with some target .cpp files contain Japanese characters resulting nmake fatal error U1073: can't find target file (in Japanese). The file refers to the cpp file with Japanese characters in the file name. The command window displays these Japanese characters incorrectly in this nmake error message. Basically it shows the binary equivalents of these DBCS characters. The problem is not there using Visual Studio 2003 and nmake can display DBCS characters correctly when running. ...Show All

• .NET Development Storing and Retrieving Connection Strings

  There is an article on msdn2 ... see http://msdn2.microsoft.com/en-us/library/ms254494.aspx which suggests that you can add this for the app.config file: <connectionStrings> <add name="DatabaseConnection" connectionString="Persist Security Info=False;Integrated Security=SSPI;database=Northwind;server=(local);" providerName="System.Data.SqlClient" /> </connectionStrings> and this in the code Option Explicit On Option Strict On Imports System.Configuration Module Module1 Sub Main() Dim settings As ConnectionStringSettings settings = _ ConfigurationManager.ConnectionStrings("DatabaseConnection") If Not settings Is Nothing Then Console.W ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Heightmap Collision testing

  This question has been mocking me all day. I know it's doable, I have even used such a function somewhere long ago, and I have even found quotes of people saying "the calculation is easy and quick," however, I cannot find an example of heightmap collision testing. In other words, I want to be able to type MyLandscape.GetHeight(x,z) and it'll return the height (y) at that point. Now, this is not a simple, find the vertex at (x,z), and return the array value. There is distance between each vertex so, (x,z) wouldn't always be a vertex location. If I recall my calculus from ages ago, I think I remember there being a way to do this, but I don't remember. Answers or links would be deeply appreciated. ...Show All