Dybber's Q&A profile

• SQL Server getting primary key out of insert into statement

  Is there a way to get the primary key that is causing a primary key violation when inserting via a insert into with a select statement. This violation is being caught using a try/catch statement. Is there anyway, short of doing yourself via brute force coding, to get what the values are that are causing the error. Basically, I'm doing: begin try insert into TableA select col1, col2, col3 from TableB end try begin cat ...Show All

• Visual Basic Problems installing...Adobe Photoshop 7.0????HELP

  Ok, when i place my vb.net 2003 cd into my computer, it does the setup thing and I got to step 2 out of 4. Then when I try to install the thing it gives me the setup for photoshop 7.0 and then leads me to a prompt where I need to put in a adobe photoshop serial number. I tried the one that came with the cd and that didnt' work. Any suggestions on how I can avoid this adobe photoshop installation All I want is to install vb .net. Thanks for your ...Show All

• Visual Studio Team System Data collection during load test

  My load test is having trouble reading data from counters. I'm running it from my local machine. My current sample rate is set to 15 sec on a custom counter set that contains just the bare minimum that I want for my test. Increasing the sample rate doesn't seem to have much effect on the amount of data. I've also tried it with a standard counter set. The server isn't very busy (15 - 25% processing time). What's the best way to tweak my test to g ...Show All

• Windows Forms Setup/Deployment project for custom install procedure

  Referring to VS.nET 2003. With the standard Setup/Deployment configuration, I can easily prepare the MSI package for my Windows Service and install. However, the nature of this Service program has some requirements: 1. there is an older VB6 version to it, and ...Show All

• .NET Development new to Web App - problem w/ IIS

  Hi out there - - This is the message that comes up when I attempt to Open a new Project as a ASP. NET Web Application rather than a Windows Application: Visual Studio .NET has detected that the specified Web server is not running ASP.NET version 1.1. You will be unable to run ASP.NET Web applications or services. Looking in the 'About' area of Visual.NET I read that I have the: Microsoft Development Environment 2003 versio ...Show All

• Windows Forms How do i assign this?

  let say i wanted to sum up all the price in my database and assing it to a listview table.  how do i do it   what i did was  ....  myRS.Open("Select SUM(Price) FROM Store",myDb)  how do I assign it to a listview    where doe ...Show All

• Windows Forms Dates between...

    I have  a problem fetching data between two dates, from access database in Vb.net I am formatting the from and to dates which i select from the date pickers to dd/MM/yyyy Dim f As Date = dtpFromReport2.Value       ' value from Date picker1 Dim t As Date = dtpToReport2.Value         ' value from Date Picker2 Dim fromDate = Format(f, "dd/MM/yyyy") D ...Show All

• .NET Development Why IDbConnection no have getMetaData ?

  I need extract the database metadata and saw that the IDbConnection no have suport. Why Somebody have a open source alternative solution Hi, If you're looking for a way of getting database schema information, ADO.NET includes a new API for obtaining it. The main entry point to the API is the "GetSchema" method in the connection object. You can find out more detail in the MSDN documentation. There is also a good introduction to the top ...Show All

• SQL Server sqlcmd and scripting variables

  Hi, I'm trying to use sqlcmd file with scripting variables to build a file path and the issue the OS command MKDIR using that path to create the directory. Something like this: :SETVAR DataDrive "'D'" Declare @DataFilePath NVarchar ( 260 ); -- Data File Processing Set @DataFilePath = $(DataDrive) + N':\MSSQL.1\MSSQL\Data'; !!MKDIR @DataFilePath However, I can't get sqlcmd to resolve the value of the variable in the !!MKDIR str ...Show All

• Visual Studio Logos in Report Header

  Hi Everyone, I'm doing a project with local reports. In my reports the logo comes from the database thus I've to use a 'Database' image.My report logo is inside a report header alone with other info. The problem I have is that I cant refer to Database fields inside the report header. I got round this by having the other report header fields as Parameters. I also tried to cross-refer the image from an hidden image box located inside the report b ...Show All

• SQL Server data mining

  hi my final project is on datamining for bank data but i need the help how to start it and develop a successful software . i also need help about how to devlop and implement the data warehousing and use the olap technology on it. please answer in detail I recommend starting with the following book The Microsoft Data Warehouse Toolkit : With SQL Server 2005 and the ...Show All

• Visual Studio Express Editions preventing thread from abort at specfic stage

  i am creating a thread that will do some work and then enter those info in database. use can abort that thread but i want to prevent that thread won't abort when it is inserting some thing in database, instead it will abort after that Why not disable/enabled the button at the appropriate times.  If the button is disabled then they cant execute the button click event code containing the thread.abort command Button1.enabled = fals ...Show All

• Smart Device Development Ensure password activated?

  Hi, Using C# .NET 2.0 Compact, is it possible to ensure that the user has set up a password on their mobile device I want to restrict my application such that it refuses to run unless a password has been enforced on the PDA. Currently I'm using PocketPC 2003 SE Emulator. Thanks in advance, Sigol. .NETCF does not natively provide a class to tell you if the user of your device signed in with a ...Show All

• Smart Device Development Question about Synchronizing/Connecting to Internet

  I am toying around with an idea, and the RSS-solution I initially thought about is becoming too cumbersome, and my programming skills are not good enough to pick apart the actual lines of code I would need. I thought I would throw out this question, for all you experienced programmers: I would like to inform people about recent updates on a website in a simple way (in the way of - if there's an update on the internet server, then a Messag ...Show All

• Visual Studio 2008 (Pre-release) DependencyProerty at run-time

  Hi, Is it possible to add  DependencyProperty dinamicaly at run-time thanks in advance, miljac Maybe you are talking about something like this: public static readonly DependencyProperty MyStringProperty = DependencyProperty.Register("MyString", typeof( MyString ), typeof(string), new UIPropertyMetadata(new MyString ())); [BindableAttribute(BindableSupport.Yes, Bindin ...Show All