Justin98TransAm's Q&A profile

• Visual Studio Express Editions Visual Web Developer and SQL

  As someone new to ASP I think VWD is a great step forward ... it promises a lot. But there is one major problem .... your new site runs well until it comes to loading ASPNETDB.MDF across to your hosting company. The process isn't easy and the VWD tutorials don't help, which is confirmed by the number of posts appearing here and on ASP.NET. All I want, like thousands of others is to get the site running ... to see a tangible return on the time spent so far so that I can be motivated to stend more time learning about ASP, SQL Server and VWD. New users (like me) are becoming very frustrated by the 'GAP' between VWD and SQL. I don't want to spend hours trying to find solutions, I want to get my VWD site running and then learn by 'trial a ...Show All

• SQL Server Compilation of Stored Procs

  Hi, I would like to know if the execution plans of stored procs also get migrated when we do migration to 2005 from 2000 using attach\detach method or we will need to re-run the stored procs The thing is when I am running the Stored procs in 2005, its performing really slow in first run. Any help in his regard is highly appreciated. Thanks, Ritesh yes, dropping, removing of anything will most likely remove the cached plans for that object. The first run can be really slow, this is expected and by design, additional run should use the cached plan. ...Show All

• Visual Studio 2008 (Pre-release) Wish: [CheckParamsAtCompileTimeAttribute]

  There is a class of problems that could be prevented at compiled time, and Linq widens the opportunity for run-time crashes. This was already discussed extensively on this forum. I would like to propose that methods be marked up with a an attribute, which would specify a validation method that could analyze the parameters. If this markup was used, we could provide warning to users who compile code such as this: void user_code( string arg) { new Regex("("); //this will blow up, and is easily preventable new Regex(arg); //not easily preventable from c in db.customers where IsEven(c.ID) select c; //throws, easily preventable } bool IsEven( long i){ return (i%2)==0; } For this to work, the authors of methods Regex.Re ...Show All

• SQL Server Variables and ForEach container

  Is there a way to set a variable as a substring of the enumerator in a Foreach File Enumerator type The Variable Mappings tab in the Foreach Loop Editor does not allow you to enter an expression. Fred The first time I did not have SP1 installed. Now I do and the expression builder gives this error message: TITLE: Expression Builder ------------------------------ Expression cannot be evaluated. For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Controls.TaskUIFramework.TaskUIFrameworkSR&EvtID=FailToEvaluateExpression&LinkId=20476 ------------------------------ ...Show All

• Windows Forms How do I reference a dynamicly created control on a tabpage?

  I have code that successfully creates a group of nested controls. A tablelayoutpanel contains two splitter panels and another tablelayout panel. There are further controls under the splitter panels, both labels and datagridviews. If I want to refer to one of these controls when I switch tabs, how do I get that reference to work I have tried: Private Sub EmpPopulate( ByVal index As Integer ) 'populate the employee list Dim name As String = "DataGridView1" & index Dim grid1 As New DataGridView grid1 = Me .TabControl1.SelectedTab.Controls(name) grid1.ForeColor = Color.BlanchedAlmond End Sub As I am confident everybody sees, this causes a nullreferenceexception. Is this even the ...Show All

• Visual Studio Express Editions Visual Studio Ney side-by-side with Visual Basic Express 2005

  I wanted to learn Visual C++.Net and I registered at a local college. I had to buy Visual Studio .Net Academic version 2003 and even though I didn't do all that well with the course I still have this software. I've also downloaded the Express products. Am I better off having the .Net product installed along with the Express products or will it make no difference whatsoever   Adrian  ...Show All

• .NET Development PrintDocument leaves a large bottom margin on some printers

  I'm trying to print a Bitmap which fills a complete A4 page (portrait). I use the following code: PrintDocument pd = new PrintDocument (); pd.PrinterSettings.PrinterName = printer; foreach ( PaperSize ps in pd.PrinterSettings.PaperSizes) { if (ps.Kind == PaperKind .A4) { pd.PrinterSettings.DefaultPageSettings.PaperSize = ps; break ; } } pd.PrinterSettings.DefaultPageSettings.Margins = new Margins (0, 0, 0, 0); pd.PrintPage += new PrintPageEventHandler (pd_PrintPage); pd.Print(); private void pd_PrintPage( object sender, PrintPageEventArgs e) { e.Graphics.InterpolationMode = System.Drawing.Drawing2D. InterpolationMode .HighQualityBicubic; e.Graphics.SmoothingMode = System.Drawing.Drawing2D. Smoo ...Show All

• Windows Forms How to perfrom custom ownerdraw in listview ?

  hi I have a ListView with *View* property set to *LargeIcon* view. And a imagelist is associated with that listview. I want to have control in drawing label text, so I have set ownerdraw=true, so now I want to know to perform this ownerdraw in detail Thanks P.S: I already checked http://msdn2.microsoft.com/en-us/library/system.windows.forms.listview.drawitem.aspx but its pretty useless as it does not deal with LargeIcon view. ...Show All

• Visual Studio Express Editions several questions about vb express

  i downloaded express yesterday and I have several questions. does this program replace vb6, or is it strictly for the web a big question is, How do I get new components from my tool box list such as 'image' on to the toolbox itself. I checked one of the image components but it does not show up. I really need the image component for a program I want to write. #1: well in a sense yes it replaced VB6 since it is newer and much better and more "now". There is nothing strictly about it for the web - you can develop with this, desktop applications. To develop web stuff, download the VWD express to develop ASP.NET websites ...Show All

• Windows Forms Can't Get API To Work Properly with SysListView32

  I have been trying desperately for a while to retrieve the selected items from a SysListView32 contained in the webbrowser control (when you .Navigate to a folder on the local computer). I have been through Reflector with the framework classes, googled like crazy for maybe a bit of info on this process, if indeed anyone has even tried it, to no avail. The .NET code I studied in Reflector doesn't seem to work at all on this particular listview! Should it Could someone please check out this code It's only 64kb and it's coded in VB Express 2005. Please don't tell me a PInvoke signature is wrong somewhere, I might die. http://downloads.wickedorange.com/FileBrowser.zip Looking forward to any suggestions! ...Show All

• SQL Server Stop run in Stored Procedure for msg errors

  Is there a way to stop the run of a stored procedure when a msg error occurs I've already got a Try...Catch setup, and is stops when an actual error happens (i.e. inserting a duplicate row). But when just a message occurs (i.e. msg 4864, which is a bulk insert error and no rows are inserted), the stored procedure runs as if the insert worked, and finishes the procedure. I need it to stop and process as an error so I know the row was not inserted. I'm running SQL Server 2005 Thanks, Laura Yes, that error is not getting caught. But I think its because it comes as a msg 4864, and not error ####. Here is my sp: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[Imp_H ...Show All

• SQL Server Table join problem

  Hi CREATE TABLE [dbo].[Users]( [Id] [int] IDENTITY(1,1) NOT NULL, [UserName] [nvarchar](50) NULL ) ON [PRIMARY] INSERT INTO [dbo].[Users] VALUES('Unal') INSERT INTO [dbo].[Users] VALUES('Volkan') INSERT INTO [dbo].[Users] VALUES('Duygu') INSERT INTO [dbo].[Users] VALUES('Elif') INSERT INTO [dbo].[Users] VALUES('Mehmet') INSERT INTO [dbo].[Users] VALUES('Demir') CREATE TABLE [dbo].[Agenda]( [Id] [int] IDENTITY(1,1) NOT NULL, [ActivityName] [nvarchar](50) NULL, [UserId] [nvarchar](50) NULL ) ON [PRIMARY] INSERT INTO [dbo].[Agenda] VALUES('school excursion','1,3,4') INSERT INTO [dbo].[Agenda] VALUES('party','6,2,3,1') Table Name : Users Id UserName 1 Unal 2 Volkan 3 Duygu ...Show All

• SQL Server Encryption related overflow?

  Recently restored a SQL 2000 database to a SQL 2005 Server. The database contains a series of user stored procs (one calls upto 5 other sps) which are all encrypted using 'WITH ENCRYPTION' clause. When run on SQL 2000 Server this runs without error. When run on SQL 2005 Server it reports an error: Msg 565, Level 18, State 1, Procedure SPDM_MP1_SOURCE59, Line 5143 A stack overflow occurred in the server while compiling the query. Please simplify the query. Investigating the error line reported does not reveal any problems with the sp and the error line number reported is not always consistent. However, altering the stored procs so they are not encrypted and it all runs without error. Is there a compatibility issue running SPs e ...Show All

• Software Development for Windows Vista How to add Images like JPG,tiff into XPS Document

  Hi , Can any one tell me how images like jpg , tiff can be added into the XPS Document. Thanks in advance for earliest reply. Santhosh Hi , Can any one please let me know what are the features that are supported in XML Paper Specification viewer - Beta 2 version. I would like to know exactly is there any difference between Beta 1 & Beta 2 for opening the same XPS document in both the viewers. I am facing the problem when i was trying to open a jpg embedded image in Beta 2 version , the viewer is getting hangged. But the same xps file is getting opened in the Beta 1 version. Any one please let me know what could be the reason at the earliest possible. ...Show All

• SQL Server Referencing and renaming tables..

  help how to reference n rename table.. is it possible by code referencing ... To reference a table from another database in the same server, simply prefix the table with the database name. In other words, use the 3-part naming convention of the table. To illustrate, to select from the [dbo].[Authors] table in the pubs database from the Northwind database, the SELECT statement will be as follows: SELECT * FROM [pubs].[dbo].[Authors] ...Show All