Plod's Q&A profile

• SQL Server Compress or Compact Database with SQL Express

  How do you Compress or Compact a Database with SQL Express If feedback is of benefit, this would be a useful feature to include with SSME. Regards, Flavelle ...Show All

• Visual Studio Express Editions Amazon-Enabled Movie Collection

  I've downloaded the web-enabled MovieCollection and got it to run, but for some reason, it does not save any of the data.  I type in movie names but as soon as I exit the program and restart it, the data is gone.  What could be the problem You bet.  And you're right - the project model has built in roll back functionality so the code you build is the code you ship.  This feature is nice for ...Show All

• .NET Development Select all records if not filled in the Text Box

  Have basic text box and button and grid textbox will be empty and need to select all if left empty otherwise if put in value only selects these Tried setting the text box to NULL...in the define parameters nothing happens its ignoring the NULL SELECT * FROM [SALES_BACKLOG]  WHERE ([SALESREP_ID] = @SALESREP_ID OR @SALESREP_ID IS NULL) Im using the grid view < asp : SqlDataSource ID ="SqlDataSource1" runat ="server" Connectio ...Show All

• SQL Server simple question on writing query

  Hi, I have two little identical tables. Pdates - (here pid is foreign key field linked to diff table proposal) pdate pid pkid-primary key Cdates - (here cid is foreign key field linked to diff table confirm) cdate cid tid strttime endtime pkid-primary key I wish to just copy the records from pdates to cdates selected based on pid value with diff cid. The other fields tid,strttime and endtime will be updated ...Show All

• SQL Server When to use varbinary(max) and when to use image?

  When should I use varbinary(max) datatype and when should I use image type With SQL 2005, if you've already determined you definately need to use one of the above, we'd recommend you make use of varbinary(max) anytime instead of image. Storage of the max datatypes is much more sophisticated than that of the image/text datatypes, and management and programming against the max types is much easier than with the im ...Show All

• Visual C++ need help with console window closing to early

    hey, my names mike im 15 and i just bought this book beggininning c++ game programing, i have made a file that is supposed to after icompile and run open up the console window and let me input some data, now it does open up and let me input the data (3 things an even number a number less that that one and a warriors name) after i type in all of those it  is supposed to take that information and fill in the blanks of a story that i ha ...Show All

• Windows Forms Implementing editor for all props

  I`ve made a bunch of controls for colormixing, setting gradients, using hatchbrushes etc..etc.. I`ve also made some button controls and plan to make similar controls for other elements. My question is: How do I implement an editor that covers all the relevant ...Show All

• Windows Forms SVG

  Does anybody have an idea how to display SVG graphics with windows forms. We have a requirement to display and print SVG and to have an editable layer on top of the SVG graphics. is there a XAML component that is already working with the .net 2.0 framework. We can't ship a comunity technology preview. thanks for any help Chris Try this link: http://www.adobe.com/svg/viewer/install/main.html At the m ...Show All

• .NET Development how can i do this?

  Hi what i am doing is i am searching for empty records in my table if any cloumn is empty it should return me column name for perticular id lets suppose 1 is our id if 1 has two clomns that are empty i want write like "u are missing column_1,cloumn_2 as so on" but right now i can only do with one column how can i convert it into dynamic form lblReport.Text = "There are only " & flyer_alert_days & " days left for " & column_ ...Show All

• SQL Server performance of indexed views

  I see their benefit -- trust me. one question I have is that it looks like my indexed view has to get updated each time the underlying base table changes. What happens if I do an insert or bcp into the underlying table -- will me table go offline while this data gets re-aggregated -- is there a way for me to schedule this I see UDAs as well, and I think they are more flexible, but I'd be concerned that they are getting too far away from the opti ...Show All

• Windows Forms type Q??

  Hi all, i'm just starting programming in .net and got the folowing Question Somebody can explain why this is not valide Function Something(ByVal Expr As Object, ByVal somType As Type) As Type ...... ....... ........         Return CType(Expr, somType) End Fun ...Show All

• Visual C# C# Exception

  when i open a sqlconnection i enconter with this exception: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. Doesn't leave much to go on... Are you trying to access a remote SQL Server instance Can you connect with the designer and/or the server explorer ...Show All

• Visual C++ Including resources in EXE?

  I'm converting an app from VB to C++ that uses the CrystalReportViewer in a winform. The VB App seems to include the *.rpt files in the EXE file. When I compile the C++ program, move the built EXE to the network, it says it can't load the report. if I move the *.rpt files to the same network directory, the program runs fine.(I did not have to copy the .rpt's with the VB App) Am I missing something or is this just how it is when converting ...Show All

• .NET Development Routing web service calls using SOAP extension

  Is there anyway by which I can route my web service calls using SOAP extension ...Show All

• Visual Studio Tools for Office My Pet Peeve of the day

  When Word goes to load Add-Ins, we really, Really, REALLY need a way for it to tell us what Add-Ins it is loading (the assembly and file location) and if they fail, why they failed. And for the fail, the core error too. For example, saying mscore.dll was unhappy is not very useful. Saying that it failed because assembly X is not strongly named - that IS very very useful (a problem I had many many months ago with my AddIn). thanks - dave ...Show All