DotNET_Guru's Q&A profile

• SQL Server The solution

  If I, for example, change the column width for a view in an Access Data Project in Access 2003 SP 2 I get this error message: "Object is invalid. Extended properties are not permitted on 'dbo.view1', or the object does not exist." To get it: - SA creates a new database in SQL Server 2000 SE SP4 running on Win 2000 Server Standard SP4, - SA creates a new view VIEW1 with one field, for example name from syscolumns, - SA gives login TEST database role db_owner but no server role to the new database, - I create a new Access Data Project in Access 2003 SP 2, open VIEW1, change a column width, choose Save and get the er ...Show All

• Visual C++ 2 questions

  1.) I am having problems installing the software. It gets to the downloading part says 0% and says it couldent load.   2.) I..want to become a game developer...but dont know anything. Anywhere I can go to get started learning   My bad!!! meant to put this in C++ .......nope.....found another place I should have put this.....When a mod gets to this, can they move this Hi, I guess you're talking about installing the VS. Are you behind a router/firewall that may block the download For the second question, firstly I recommend you to learn how to program. There are lots of tutorials online about c++ just searc ...Show All

• Visual Studio Installing Visual Studio 6.0 on XP SP2

  Before any setup screen appears for Visual Studio 6.0, the typical XP error appears and says 'setup has encountered a problem and needs to close'.  The issue is with v60wiz.exe, with an error code of 0xc0000005.  The setup screen does not even appear, just the error. I have attempted to install from several different burned ISOs, and have also attempted to copy the contents to the hard drive and install from there.  I have also attempted to install from safe mode with no results. However, ACMBOOT initializes properly, but from the looks of it, it's missing certain registry keys, or some other installed components to complete t ...Show All

• .NET Development ReadOnly XML Files

  I'm reading XML files using XmlDocument, in some cases i have XML marked with readonly, so when tried to write to them an Access Denied exception is generated,  is there a way to change the XML file state in order to successfully write to it. I just thought that I would add that although Jacky's solution is correct, it is better to do the following: File.SetAttributes(path, File.GetAttributes(path) & ~FileAttributes.ReadOnly);   This preserves any other attributes that the file may contain (ie Hidden, Archive, etc) but removes the read-only attribute. You can also use the FileInfo class to do the same thing: ...Show All

• Visual FoxPro MSGraph.Chart.8 control

  I need to make charts. I started with MSChart Control and so far I've accomplished almost all I wanted except for one thing which totally eludes me. I need a simple line chart, not columns or a pie. I need to display a row of data like DJIA or similar indices with no additional vertical bars or other embelishments. The curve comes out nice but a lot of space on the chart is wasted because the curve is being plotted too high on the chart in vertical direction. I have tried to manipulate MSChart.Object . Plot . Axis ( VtChAxisIDY , 1 ). ValueScale . Minimum value but it is not responsive at all. I do not know why: perhaps other paramete ...Show All

• SQL Server Urgent: ASP.NET 2.0 and SQL 2000

  When using Form authentication, can we not use SQL SERVER 2000 When I am working with the ASP.NET Web Site Administration Tool Wizard, it tells me that: Your application is currently configured to use: Advanced provider settings How can I use my existing database on SQL SERVER 2000 Please help. Does your SQL Server 2000 database contain all your user credentials that you will be using in Forms authentication Or you will just be using a SQL Server 2000 database to contain user credentials I used aspnet_regsql.exe to create a database to store user credentials in ASP.NET 2.0 using Forms authentication. For a step-by-step ap ...Show All

• Smart Device Development Using .NET CF with XML - displaying image in picturebox

  I'm trying to add a picture whose path is in an XML file to a picturebox.  I am programming in C#.  I have tried using the foreach command, but I keep getting an error.  XML file: < fragenkatalog > < ca_id > 4 </ ca_id > < ca_bildurl1 > kopf_ap.jpg </ ca_bildurl1 > </ fragenkatalog > Form code: foreach (ca_bildurl1 b in fragenkatalog) { ca_bildurl.Image((System.Drawing.Image)b.Value); } I get the following errosr: 'DataBindingDemo.ADONETDataBinding.ca_id' denotes a 'field' where a 'class' was expected The type or namespace name 'b' co ...Show All

• SQL Server Error in datetime validation

  xml including a datetime attribute is failing to validate against a simple schema held in an XML schema collection The same xml validates correctly against the same schema in .Net Is this a bug (same behaviour is seen with dates) Repro follows: CREATE XML SCHEMA COLLECTION MyCollection AS ' <xs:schema xmlns=" http://www.w3.org/2001/XMLSchema " targetNamespace=" http://ns " xmlns:ns=" http://ns " xmlns:xs=" http://www.w3.org/2001/XMLSchema " version="1.0"> <xs:complexType name="TestType"> <xs:attribute name="id" type="xs:string" use= ...Show All

• SQL Server user defined function in a select

  Hello, i would like to get the result of a function in a select-statement depending on the result of an other column. I attached a little sample that works on the table syscolumns, so everybody should be able to check by now. The only thing I get is an error  function name not recognized create Function fn_test( @N bigint) RETURNS Table AS   RETURN ( SELECT @N + id as Result FROM syscolumns ) Sample SELECT: Select typestat,  fn_Test( typestat ) FROM syscolumns Any hint would be very kind Thanks in advance Matthias It must work with SqlServer 2000, therefore I've splitted  the function and use now a single ...Show All

• .NET Development Threads

  Does anybody know a good tutorial on using Threads in VB.NEt. Try this one . ...Show All

• Visual Basic Another datetimepicker question

  I had a textbox(tboxAge) and a datetimepicker(dtpDate).When a user inputed his age in the tboxAge, the dtpDate value should be Jan.1,dateofbirth(1/1/19 ).Thanks... Create a new DateTime, from DateTime.Now and subtract the number of years you get from the text box, and set the date to Jan 1. ...Show All

• Windows Forms Can you do a partial match on a bindingSource Find

  I am trying to create a search text box. If I do int theFoundRow = bindingSourceX.Find("Surname", textBoxt1.Text) ; bindingSourceX.Position = theFoundRow; It will work if the full correct surname is entered and move the associated grid position to the correct place. However if incomplete but correct information is supplied eg "Smi" instead of "Smith" What I want to achieve is to find the first row where there is a partial match. Any suggestions would be greatly appreciated. I seem to be talking to myself here but if anyone else has the same problem this is the solution I found. Da ...Show All

• SQL Server Capturing Processing Status and Progress Messages

  When you use BI Dev Studio or SS Management Studio to process an Analysis Services database or object, there's a nice dialog box that shows very robust status and progress information. Is there any way to capture this information if you are processing something programmatically   Specifically interested in both the ability to capture and display this information to a user when processing via a custom application.  Also interested in whether or not there's a way to capture this information to a log (or table) for display and analysis after the fact (or if the custom application is running in a batch mode via a schedule). Thanks ...Show All

• SQL Server Dynamic sql problem

  Hello: I am tearing my hair out over this. I am using sql server 2005 and am getting the error "arithmetic overflow error converting nvarchar to numeric." The sp is below. It works fine when I do not include the numeric variable @z and only insert the other 3 fields. The varbinary(MAX) is not the problem. The problem is syntax error mixing numbers and strings. How do I put the numeric @z in the @query string so I can insert a value into the FileID numeric field set ANSI_NULLS ON set QUOTED_IDENTIFIER off ALTER PROCEDURE [dbo] . [uspInsert_Blob] @x as nvarchar ( 60 ), @y as nchar ( 5 ), @z as ...Show All

• Windows Forms Passing values from one form to another

  I am trying to pass values from a Button Click event in one form to a subprogram in the Windows Form creating code in another form. But the values are all 0s when I print them out....help please... Hi, how are you pasing the values to the other form in the constructor do you print them in the passing form so that you net to pass references if you wre using a value type you can use variables from one form in a different if you make properties in the form that is calling the other one. ...Show All