sanj_vam's Q&A profile
.NET Development Working with many-to-many tables in Visual Studio 2005
I am building a form in C# using VS 2005 pro that works with a many-to-many set of data. Does anyone know of a good tutorial or something that would help I have lots of material on how to work with master-detail records but there seems to be little information out on dealing with many-to-many situations that use a link table. Hi Mike, Have you checked this one http://www.code-magazine.com/article.aspx quickid=0507051&page=1 Best, - Nikola. ...Show All
Visual Studio Express Editions runtime error visual c++
what can i do to stop or fix my pc to stop the runtime error from shutting me down http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=213107&SiteID=1 Thanks, Ayman Shoukry VC++ Team ...Show All
SQL Server Common Password
Hi, I would like to setup a common password for all the MS SQL Server Users. Is there any generalized script for the same Thanks In Advance. In SQL Server 2000, you can use sp_password. CREATE LOGIN is new DDL available in SQL Server 2005 only. Here's the equivalent syntax using sp_password: sp_password NULL, 'new_password', 'user' You can search for "sp_password" in BOL for SQL Server 2000 for additional info on this. Thanks Laurentiu ...Show All
.NET Development Whidbey System.DirectoryServices
Hello, I'm using Whidbey Beta 2. I need to work with Active Directory. Can anyone help me with regard to documentation What is the name of the assembly I need to import in Whidbey The System.DirectoryServices assembly seems to be gone. Please help! using System.DirectoryServices; Should be the code that you need. What error is it giving you exactly ...Show All
Visual C# Added C# to Visual Studio 2005
I just installed SQL Server 2005 along with VS 2005. The reason that I did this was to use c# to work with SQL. I have c# installed and am using IDE 2003. I can see using "About Visual Studio" that I have 4 installed products all relating to SQL 2005. This is great as this is what I wanted, but I also wanted to use c#. I can also see in the "about MS Developer Environment 2003" that c#.net is installed. But after several hours of searching I can figure out how to install c# (I am using standard edition) into VS 2005. Any help here would be greatly appreciated. Thanks, Bart ...Show All
Windows Forms SQL SELECT statement
SELECT * FROM POSTCODE WHERE STR='THE CRESCENT' AND PTN='' AND CNT='' AND LOC='' I have this statement which I generate from the values of four textboxes. It works fine if all the boxes are completed, however in this case the user has filled in only Street. So here I want to return all the str='the crescent' regardless of whats in the ptn/cnt/loc columns. How can I do it Tweak to make use of generics: List< string > parameters = new List< string >(); // add paramaters string sqlCondition = string.Join(" AND ", parameters.ToArray()); ...Show All
SQL Server IF statement with BEGIN END block
I'm working on a stored procedure which includes an IF statement at the end of the procedure which appends my sql call with two lines. But I'm getting an error that probably comes from the fact that I have a nested BEGIN END block in my overall procedure. Can anyone tell me if my assumption is correct and help polish of the syntax The error I'm getting is: Msg 156, Level 15, State 1, Procedure payments_sp, Line 55 Incorrect syntax near the keyword 'AND'. and the sql code looks like this: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[payments_sp] -- Add the parameters for the stored procedure h ...Show All
Smart Device Development Waking up from hibernation.
When my Pocket PC wakes up from hibernation, sometimes the application only appears in the background and can only be seen under Settings > System > Memory . 2 questions: 1. Any way of making sure the application does not fall into the background of the OS. 2. If I can't prevent if from just being seen under Memory, is there a way my application can detect the PPC has been powered on again. Thanks for any solutions, You can do this by P/Invoking into the CE function CeRunAppAtEvent or CeSetUserNotificationEx (both wrapped in the OpenNETCF.Win32.Notify namespace - www.opennetcf.org/sdf/ ). This allows you to register yo ...Show All
SQL Server Updating data
Hello. Is it possible to somehow update data as it is copied from source to destination using SSIS. Currently I extract data from Database A, load it into database B, then clean/update the data in database B and then load it into database C using DTS on 2000. What I would like to do is extract data from database A, clean/update it, then load it straight into database C without having to load it into database B first. I am unable to clean/update the source data in database A, as this would be the obvious thing to do. Thanks. yep, works if all columns are varchars. Un ...Show All
SQL Server SSIS - Data Sources - Configure for deployment?
I had posted this in the following pre-existing thread : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=89737&SiteID=1 Also wanted to start a thread on this to see if I can get some suggestions. Any suggestions on how to do this are appreciated. -------------------------------------------------------------------- Books-Online quote: >> In Integration Services, data sources are design-time objects that you use when you build packages in SSIS Designer. This is indeed the case but why I would like to see it changed or provide some way of including the data source in some kind of a "solution/project con ...Show All
Visual Studio CallBrowser Sample?
Documentation of VSIP refers to a managed sample named "CallBrowser". This sample is not included in the files installed with VSIP (VS2005 Beta2) while all other managed samples listed or mentioned in the documentation, are. Where can I find the CallBrowser sample Unfortunately the doc is wrong. The sample was not completed and added to the SDK so the docs got ahead of the content. The final docs will reflect this. Nor do I see this sample in the VSIP 2003 SDK. Sorry about that. ...Show All
Game Technologies: DirectX, XNA, XACT, etc. i need help! pls I want to begin to write games
I need documents to learn to use directx in c++ or vb, to not knoweverything about directx, thanks for its attention and hope can help me, and sorry for mi english Of course one simpler route would be to use a pre built game engine. Say you want to start building a first person shooter (which is a very big job to do it properly), look at one of the game engines built for this type of game. Whilst you will have plenty of programming still to do, it hides a lot of the complex stuff to do with talking to DirectX or OpenGL. You will still need to learn the basics however but its will be more gentle than trying to effectively build a custo ...Show All
.NET Development Forms authentication problems
Hi, I've got a simple intranet site that uses forms authentication in the web.config to make sure people are logged in. On my machine and on a development machine this code works fine, the asp.net bit realises they're not logged in and passes them automatically over to the Login.aspx page. However on the production machine this doesn't happen, it lets them straight into any page they want. What could be wrong I've made sure that anonymous login is ticked on all servers /Matt Hi Matt, I recommend that you post to the ASP.NET web forums. http://forums.asp.net This forum is specific to ASP.NET Web ...Show All
Visual C# Tabcontrol.tag
textBox1.Text = TabControl1.SelectedTab.Tag; That code doesnt work for some reason, could someone please tell what the working code is You can't put a object type in a string typed property. First cast or convert it: textBox1.Text = (String)TabControl1.SelectedTab.Tag; // Or textBox1.Text = TabControl1.SelectedTab.Tag as String; // Or textBox1.Text = TabControl1.SelectedTab.Tag.ToString(); ...Show All
Visual Basic Saving contentes of a graphic to a bitmap and load it
Hello! I have a form with a picturebox and I turn the picturebox into a graphics object by using the creategraphics. I then draw a few things, and then I want to save what I have done in to a bitmap, but on disk, just on memory so I can reload it. I do like this Public Shared Sub save(ByVal picb As PictureBox, ByRef bi As Bitmap) Dim x As Bitmap x = New Bitmap(picb.Size.Width, picb.Size.Height, picb.CreateGraphics()) bi = x End Sub I want to save to a bitmap ...Show All