JeffSkla's Q&A profile

• SQL Server iif statement problem

  hi all, i've browsed some of the smilar iif expression problems but no idea how to solve mine. i get an #Error when i wrote the following expr : =sum(iif(Fields!revenue_type.Value= "R" , Fields!amount.Value,0)) but no error when it's =sum(iif(Fields!revenue_type.Value= "R" , Fields!amount.Value,0) - iif(Fields!revenue_type.Value= "T" , Fields!amount.Value,0)) If i filter the dataset and just take in data where revenue_type = "R" then there won't be error... how come did i do something wrong please help... this seems so simple yet i couldn't get it.. You hit the nail on the head with "Maybe RS is not so clever.& ...Show All

• Visual Studio Express Editions Visual Basic windows forms

  Hey, I've only started using Visual Basic tonight, and I've never touched any previous form of VB and/or Visual Studio. So this is probably the newbie-ist question you've seen for a few years if not ever. Anyway, I've got a task set out whereby I must create a testing program as such, with multiple choices. I've created a form for every question, along with a welcome form and a grade form. My question is simply, how do you link the forms, so that a user can click the button labelled "Continue1" and it opens up form2, within the same space and so on and so forth. Any help would be more than gratefully received. Thanks! that would be the form you are going to show, which you have i ...Show All

• Visual C++ Directory listing

  I was thinking about writing a quite simple program in c++ which purpose is to write all .mp3 files in a folder and subfolders onto a .m3u file. I cant find any standard library functions returning the next file or folder in a directory... Does anyone know how to do this (I'm quite a beginner in c++... I have read "c++ whitouth fear"! Does anyone recommend a book to continue learning ) Check this FAQ, http://www.codeguru.com/forum/showthread.php t=312461 ...Show All

• SQL Server How to locate the database folder in sql 2005

  We want to locate the database folder/files (where the databases are stored) like SQL Server Management Studio UI does, when you click on attach database / Add. The question is how to retrieve this folder/files programmatically (C# or VB, SMO ). For example we want our application client to connect remotely to an SQL Server and attach a new database, using the folder/files obtained from the retrieved method. Verry verry sorry.. I don't know the folder and the name of the database . The database is NOT attached . That is why I want to locate it. ...Show All

• Visual Basic User Login Password Encryption In Database

  How to do encryption for user login  I need to encrypt it in database and after the user key in password, i need to do checking based on the encrypted password in database. Do we need decryption for this  Thank you. I used the following for encryption and decryption but after i stored the encrypted string into the database and decrypt it again for checking if user inputted password is same as the decrypted password, an error occurred when the pointer hit decStream.FlushFinalBlock(). I think this has something to do with the random generate key. May i know how to solve this Thank you. Private TripleDes As New TripleDESCryptoServiceProvider Public Function EncryptDat ...Show All

• SQL Server Sequel 2005 installation Perflib problem

  Hey everyone, I'm trying to install SQL 2005 developers edition on my local PC and I get the following error during the System Configuration Check: - Performance Monitor Counter Requirement (Error) Messages Performance Monitor Counter Requirement The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online. I looked it up in MSDN and i'm having problems resolving the problem. How to: Increment the Counter Registry Key for Setup in SQL Server 2005 says I should match the values of "Last Help" and "Last Counter" f ...Show All

• Microsoft ISV Community Center Forums MSDN Download

  Hi, I found out at microsoft download site that the latest version of MSDN could be downloaded free of cost. Has any body tried downloading the image file and is the MSDN fully functional Or is it an evaluated version which will expire after some days Please find the link to the page below. http://www.microsoft.com/downloads/details.aspx familyid=94596AF5-CC58-45AF-A14B-DF627A31E783&displaylang=en You might be able to find out for sure by emailing the MSDN Subscription team. Here's a contact form: http://blogs.msdn.com/msdnsubscriptions/contact.aspx -brenda (ISV Buddy Team) ...Show All

• Visual Studio Express Editions Images folder under Chapter6 , companion content

  I downloaded the ebook to " Introducing Microsoft Visual Basic 2005 Express Edition", on page 101 refers to the image folder under chapter6, which I could not find. What is the companion content and from where do I download it You can download companion content for Visual Basic 2005 from the next url: http://www.microsoft.com/mspress/companion/0-7356-2213-2/ Hope this will help you. Thanks. ...Show All

• Visual C++ Elevating a User application to write to a named pipe created by a service running in LocalSystem

  I have a named pipe that is used between a service running as LocalSystem and a client running in the User group. If the service passes a NULL to CreateNamedPipe the EVERYONE group only gets GENERIC_READ, hence the CreateFile for the pipe in the User application returns an access denied error when it requests GENERIC_READ | GENERIC_WRITE. How do I give the user application write capabilites My thinking is to build a SECURITY_ATTRIBUTES with EVERYONE set for GENERIC_READ/WRITE and pass it to CreateNamedPipe. Is this correct -- The personal opinion of Gary G. Little From the documentation of SetSecurityDescriporDacl you can learn Quote: There is an important difference between an empty and a nonex ...Show All

• Visual Studio Express Editions if, else, end if gives me an error - help

  I'm new to VB. writing only my second app and trying to get a simple line to work,almost a direct quote form a book,  i just wanted a simple if textbox is empty show error box if not go to next section a textbox input to be recalled later that will not accept blank entry. heres the code If TextBox1.TextLength = 0 Then MessageBox.Show( "please Name the yourself" ) else section2() end if i get 2 errors Error 1 'Else' must be preceded by a matching 'If' or 'ElseIf'. Error 2 'End If' must be preceded by a matching 'If'. what am i missing or what should i do to correct try this: If TextBox1.Text.Length = 0 Then    MessageBox.Show( ...Show All

• SQL Server Removing Mobile Edition BOL

  I'm hoping that someone has any ideas on this. I want to completely strip the entire Books Online module for SQL Server Mobile Edition. Why It gets really irritating when I try to look up topics and it always yanks up stuff from the Mobile edition and I could care less about those. There are entire sets of topics that BOL will do nothing but pull up the Mobile edition topic which is completely irrelevant for other editions. Hi Michael, Yes, you can remove the Mobile edition topics from the help collection. See the Books Online topic " SQL Server 2005 Combined Help Collection Manager " (ms-help://sql90/sqlcc9/html/b06d0f98-ef00-4b03-9f5d-b5c184b8df92.htm). In that topic under the heading "Available Help Collectio ...Show All

• Internet Explorer Development IE7 and desktop icons

  I just installed Internet Explorer 7 today, which I guess is a.k.a. Windows Live . All of my fancy customized shortcuts on the desktop disappeared and each got replaced by the same generic windows icon. Right-clicking & changing the icons in properties no longer works. Also, when I create an internet shortcut while browsing, that creates a shortcut with that same generic icon (not even an explorer logo). Now my desktop is just one forest of identical icons. Anyone know how I can fix this I've wasted all day without success. The issue is not the favicon. In my case it is for a shortcut to a webpage that has been placed on the desktop. I have several web based applications that I had c ...Show All

• Visual Studio I need Header Section of the Crystal Report only on the first page

  I need Header Section of the Crystal Report only on the first page, in my application i print company name and some such information in the header but there is no need of that info on the rest pages where i have detail information of the invoice. Try adding the content to the Report Header section . The Report Header is only displayed once, at the very beginning of a report. You can use it to add a cover page, page header or other one time information to the very first page in a report. - Dave ...Show All

• Visual Studio Express Editions Scanning a Drive

  Hello all. I am currently working on an Anti-Spyware program. I am needing to know how I can scan all the fiels on a Hard Drive, Floppy Drive, and CD Drive and show the fiels that are being scanned in a labelbox. I have got it to where it shows all drives on the system. Now I am needing to when the user slects the drive they want scanned from the listviewbox it will go If drive.drivetype = 0 Then Call DriveType0Scan Then it will continue and scan all the files on the drive and look for harmful files using info from my ref files. Thanks in advance and I hope you can help me. Microsoft does have an AntiSpyware program fyi. Simply, when the user selects the drive they wish to scan, simply perhaps do this: foreac ...Show All

• Visual C# How to make several Textbox control use a single method.

  I have a form with 10 textboxes. The only value I want to accept is a number between 1 and 9. I have a validation routine that checks the value and if a wrong value is entered an error message is displayed and the text box is cleared. Question 1: How can I setup the ten textboxes so that no matter which textbox is changed I will go through only one event. Right now it looks like I have to copy the same code in ten versions of: private void textBox1_TextChanged( object sender, EventArgs e){ logic...} private void textBox2_TextChanged( object sender, EventArgs e){ logic...} private void textBox3_TextChanged( object sender, EventArgs e){ logic...} etc etc. Question 2: If I really am stuck with ten T ...Show All