reichard's Q&A profile

• Visual Basic splash screen and login screen focus problem

  Hi I'm using vb.net 2005 sp1 I have a splash screen, invoked by selecting a form on the project properties window, and a login window, which is called from MyApplication_Startup I have two problems a) if the user cancels from the login window, I set e.cancel = true from the Startup event - but the spash screen doesn't terminate so the program doesn't close b) The login box ends up going behind the splash screen - I tried setting frmlogin.topmost = true, but it still doesn't result in that form getting the focus - so they have to click on it with the mouse before typing in the username / password thanks bruce a) if the user cancels from the login window, I set e.cance ...Show All

• SQL Server "with" keyword - access only one time?

  i have a very silly problem .. following code does not work: with foo as ( SELECT * FROM table) select * from foo select * from foo the second select statement throws an error, that the foo object is invalid. can i access the "foo" object only once if yes, why i tried to script foo, foo1, foo2 as (SELECT * FROM table) and then the error would be "foo2" is not a valid object. any suggestions Because WITH is a construct of the SELECT statement in your case you have 2 SELECT statements and so you will need to repeat the WITH clause again. You can have multiple queries in you WITH clause i.e. WITH fred as (select x,y,x from mytable), joe as (select x,y,z from fred) select x.y.z from joe ...Show All

• SQL Server Nesting stored procedure, how to ?

  Hello, I'm trying to use nested stored procedure but can't get it to work. I've created a stored procedure named 'sousmenu1_parents' which does a simple select, no parameter. here's what I'm trying to achieve now : CREATE PROCEDURE SelectAllDroitSpe -- Add the parameters for the stored procedure here @UserId int AS EXEC sousmenu1_parents ; BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON ; -- Insert statements for procedure here SELECT sousmenu1_parents . menu_id1 AS sousmenu1_id FROM authorisations_speciales LEFT JOIN sousmenu1_parents ON authorisations_speciales . page_id = sousmenu1_parent ...Show All

• Visual Studio Passing main report values as parameters to subreport

  Guys, I want to pass the main report fields to the subreport as parameters. So for instance if it's displaying a list of cars, I want to send the itemlistid to the subreport so that the subreport can display the respective information for reach different cars What is the best way to do this using crystal reports visual studio.net. If I write code or formula, on which window do I do it Thanks for your help. Here's some C# code, which I found in one of the sample programs: num is the index of your parameter. arrParams is an array with the values for the parameters. int num = 0; foreach (Object strParam in arrParams) { this.reportDocument1.SetParameterValue(num, strParam); num ...Show All

• .NET Development At least one element in the source array could not be cast down to the destination array type

  Hello, I am trying to pass someparameters to my reporting services web service. This report has 2 dropdown and one checkbox , I am trying to convert an arraylist to parametervalue[] This is teh code- ArrayList al = new ArrayList (); al.Add(DropDownList1.SelectedValue.ToString()); al.Add(DropDownList2.SelectedValue.ToString()); for ( int i = 0; i < CheckBoxList1.Items.Count; i++) { if (CheckBoxList1.Items .Selected) { selectected.Append(CheckBoxList1.Items .Value); selectected.Append( "," ); al.Add(CheckBoxList1.Items .Value.ToString()); TiposCompetenciasSeleccionadas++; } } ParameterValue [] reportParameterValues3 = null ; reportParameterValues3 = ( Para ...Show All

• Visual Studio Express Editions How do I get outlook express email from my desktop to function online?

  How do I get outlook express email from my desktop to function online This is off topic for this group, this group is for questions on installing and registering the express development systems. You will have to post your questions to the outlook express support groups.. ...Show All

• Visual Studio Express Editions C# Executable distribution?

  The article "How to: Set Debug and Release Configurations", implies that its possible to create a "release" executable for C# programs under all but VS 2005 Express edition. This implies that an application cannot be distributed to and executed by users without Visual Studio to run it with. Is this true - I can't create an applciation and give it to other users Is there another way to do this Another free IDE that might be useful Give your users the .exe that is built in the Debug or Release sub-folder of the project folder. ...Show All

• Visual Studio Express Editions Populating a Dataset from an SQL Database

  I am using VB 2005 Express Edition! Also - this is my first attempty at accessing an SQL database, so I acknowledge that I have probably done something very silly but at this stage I am stumped and need some help. As a reference on how to do this, I used KB Article 301216. I have basically copied exactly what was shown in the article changing names to suit my requirements and have come up with the following code :- Dim connection As New SqlConnection(ConnectionString) connection.Open() Dim adapter As New SqlDataAdapter ReadString = "SELECT * FROM configuration" adapter.SelectCommand = New SqlCommand(ReadString, connection) Dim DSetCONFIGURATION As New DataSet( "CONFIGURATION&qu ...Show All

• Visual Studio Express Editions Pass a variable from one form to another...

  Hey I've searched and searched but I haven't found a solution to this problem... All I want to do is pass a string from one form to another. And since C# doesn't allow global variables (or does it... ), I haven't found a way to do this. Let me know if you need more information to solve this problem. Thanks To do this, I use a Settings variable. It is very easy to do. Create a string setting "MyString" and when you need to send that data from one form to another, on the form that has a string that you need to send, do something like Properties.Settings.Default.MyString = thestringthatneedstobesaved; Thanks, paoloTheCool ...Show All

• .NET Development web service, App_Data - is this needed

  Hello, I have created a web service and will publish to a remote IIS, however the publishing takes over a hour and sometime longer. But this App_Data is 10mb in size. In my code all I have is about 10 methods which most of them return a dataset from a sql server database. I am wondering, do i need this App_Data what purpose does it serve What data does it store Many thanks for any advice, Steve Hi steve. Here is my view of it. The App_Data folders main purpose is to contain data files. (*mdb, *mdf, XML instance document, etc....) It's by default hidden for the internet user so that your datafiles is not by a mistake made accessible to others, not even read permission. So to run our application and to cor ...Show All

• Visual Studio Generate documentation under .Net 2.0?

  I really need to generate some documentation under .Net 2.0. I know that this issue has been raised in a previous post few month ago, but no explicit solution has been provided. Also the NDoc project seems dead (as suggest the broken wiki). Does anyone has a practical (even minimal) solution to generate documentation for .Net 2.0 Thanks in advance, Joannes Hi All, If you haven't already seen this, here is the hyperlink to the latest NDoc05 Beta on sourceforge: http://sourceforge.net/project/showfiles.php group_id=163095 Hope this helps, Kind regards, Frank M. Palinkas MCP, MCT, MCSE, MCDBA, A+ Microsoft Registered Partner Senior Technical Communicator & Web Accessibility Desig ...Show All

• Visual FoxPro Excel to cursor SPT problems

  I am using a SPT solution to take information from a .xls file and importing it to a cursor with this solution: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=509710&SiteID=1 However, I am now receiving problems where before I had not. Now I am getting Error 1466: Connection handle is invalid. Any ideas guys I can't see what the problem is but it occurs at the sqlstringconnect( ) line. Thanks! Dave's code is a subset of what I've posted and I think I have posted it before (not sure). If it's coming during SQLExec() makes more sense, because as I said before you shouldn't trust all tables in Excel are named "Sheet1$". For example: use customer copy to mycustomer.xls type xl5 Open the xls in Excel and chec ...Show All

• Visual Studio Team System Adding Objects to my solution

  I have created a new solution, and have a Data Connection open in Server Explorer, and can see a small DB where I created a few SP's, tables, etc, and I want to add the db objects to my solution, then have my solution link up with VSS. Cannot figure out how to do it. I thought I would script using SSMS and add to VSS that way and then somehow get project to work - but even SSMS doesn't seem to offer scripting objects to individual files anymore. This might have been the wrong approach anyhow. How can I get my DB objects in my project then get VSS to line up with them Hi Joe, I am not too sure on your question but hopefully the following will give you some pointers: 1. If you have create a ...Show All

• Visual C# Embedding Images

  Hi, For this little application of mine, I was thinking about embedding the image file within my solution in Visual Studio 05 as a resource, instead of accessing the folder on my hard drive. I followed the steps of embedding the image as taught in MSDN, but for some reason after I click on Project->Add existing item..I don't get the option of having the image as an embedded resource. Can someone tell me how to actually get the image as an embedded resource and subsequently use it in my code. Thanks.... You don't need to bump so much. To add the image as an embedded resource, go to Project->Add existing item, as you said. Change the file type dropdown to Image Files and select your image. The ...Show All

• Software Development for Windows Vista How to generate xaml file from rehosted sample??

  Hi, in the rehosting workflow designer sample ( Lab 10), the generated files are: .xoml, .cs and .rule. My question is what if I want to view the workflow in xml file format .xaml How could I change the code so that the generated files include .xaml file Thanks.. NMM wrote: Hi, in the rehosting workflow designer sample ( Lab 10), the generated files are: .xoml, .cs and .rule. My question is what if I want to view the workflow in xml file format .xaml How could I change the code so that the generated files include .xaml file Thanks.. The XOML language underneath is actually the same language as XAML. The only difference ...Show All