glenragoonanan's Q&A profile
SQL Server Problem with Stored Procedure
Hi. I'm having problems with the stored procedure listed below. I have two rows in my forumcategory table, and two rows in my forum table. The query returns each forum row twice. Can anyone see what causes this Help would be highly appreciated! Thanks! ALTER PROCEDURE dbo.Forum_GetAll AS /* SET NOCOUNT ON */ SELECT DISTINCT F.ForumID, F.ForumCategoryID, F.Name, F.Description, F.FromDate, F.ToDate, TC.Threads, MC.Posts, LP.LastPostDa ...Show All
.NET Development What is the best programing lang.?
VB, C#, C++, or J# Hi, The Framework refers to the Base Class Library which is a collection of something like 6000 classes that offer functionality to various stuff like Database Access, Web Services etc. It kind of is a platform which provides the classes and methods for use in the programming languages. Its a core library of classes and methods. I think you could start with this link: http://m ...Show All
Visual Basic IDE
When I am in break mode, I cannot update code. I receive message "Cannot currently modify this text in the editor. It is read only." Can anyone explain why I get this message All the Best, Charlie In VisualStudio 2005, Edit & Continue is back, so in many cases you are able to edit the source code. Things that may cause this to happen include: - You attached to the process (didn't start it from within Visual Studio) - You ha ...Show All
SQL Server SSIS with variable
Newbie question. I'm new to using variables in SSIS. Are there any good examples around of how to return an @@identity value from a procedure and then use it globally within an SSIS package for multiple "execute SQL" tasks I've gone though the documentation but don't find it to be very complete. GC I'm assuming you know how to write a procedure to return the identity value. To return that v ...Show All
Windows Forms changing ip address
Hi, I am building a windows application that works as an administrative tool. In this application I want to give user option to change the ip adress of the system. The OS is Windows XP. there would be some kind of checkbox or drop d ...Show All
Windows Forms Using datagridview with two columns -> textbox and combobox columns
Hi all, i no undertand how i can use a datagrid to display a like master/detail structure of data of my access table that contain characteristics data. For example the access table have this structure: cod codcar desccaratter valcar CUF 1200 Profondita (mm) CUF 2810 Altezza (mm) CUF 3410 Larghezza (mm) CUF 5480 Peso (Kg) CUF 7170 Dolby ...Show All
SQL Server Troubles returning values with SQL Statement -
Hi, I just want to know the following. Is it posible to write a SQL statement that searches all values in a table where the e.g: "Jobid = 1" and sort the result set according to the "CategoryID" then if you want to display the values, you can populate them according to the "CategoryID" and then also write the result set to a "text file", and catagorize everything according to the "c ...Show All
Visual Studio 2008 (Pre-release) How to add MediaElemet in a MaterialGoup?
Hello! I’d like to apply a video inside my Viewport3d-object. I’ve have succeded with bitmaps but I haven’t figured out how to it with a MediaElement.. With bitmaps it looks like this: <MaterialGroup> <DiffuseMaterial> <ImageBrush> <ImageBrush.ImageSource> <Bitmap UriSource="file:///myPng.png"> . : : </MaterialGroup> Would be grateful for some hints.. /Erik ...Show All
Visual Studio Is it possible to have Secondary Axis in a Line Chart?
Hi, I need secondary axis to reverse it in one graph then user can compare data based on the timestamp which is the same for both axises. Is this possible Thanks. Robert Bruckner MSFT wrote: Secondary y-axis is not supported at this point. -- Robert This bug, it's fixed in sql 2005 reporting services ...Show All
.NET Development Regex question (lazy quantifier)
Hi, I have a HTML file which contains a lot of lines in form <tr><td nowrap="0">First cell text</td><td nowrap="0">Second cell text -</td></tr> and I need to extract text from cells in second column (take note of a dash at the end of text of each such cell). If I load content of the file to string variable s and try using MatchCollection mc= Regex .Matches(s, "<td ...Show All
SQL Server Breaking up parameters
One of my parameters is a particular date (in the datetime format 11/05/2002 12:00:00 AM) and I wanted to display only the month and year. How can I do this to just display November 2002 on my report. Try using the DATENAME function. Here's an example using the current date: declare @CurrentDate datetime set @CurrentDate = GetDate() select DATENAME(m, @CurrentDate) + ' ' + DATENAME(yy, @CurrentDate) ...Show All
Visual C++ Processes List
Hi, I want to create a list of all the running processes (in c or c++) and their properties (i.d. , name, user-name, IO-Reads and more). The list must include all the processes (idle system process too) of all the users of the computer (administrator, LOCAL SERVICE, NETWORK SERVICE and all the others). Does anybody knows how to do it Thanks I am sorry, I have no further idea. I just used the MSDN sample, added the code for the debug ...Show All
Visual Studio About WSS and Versions of Documents.
With Vs 2005 team system can I control the versions of the documents. Can I know who did what on what day on any document Can I see the diffferent versions of the documents with WSS . Hi Luis, There are several forums available for Team System questions. You can move your question to: http://forums.microsoft.com/msdn/ShowForum.aspx ForumID=20 ...Show All
Windows Forms CheckedListBox check state not getting updated in tab conrtol
Hi, I have a ChecekdListBox in a tab control. When I am setting the checked state of my CheckedListBox, it is not updating properly if the control i hidden in the tab page. Run the attached sample. Click Check button. Now switch to tabPage2, notice ...Show All
Visual C# Namespace for FtpClientException
I am using the following code if (bConnected) throw new FtpClientException( "Connection already open" ); it throws me an error Error 1 The type or namespace name 'FtpClientException' could not be found (are you missing a using directive or an assembly reference ) I had tried searching thru MSDN, but could not find any namespace relating to this. Can anyone please help Thanks My namespace declaration is as follow ...Show All
