Puzzl3b0x's Q&A profile

• SQL Server dynamic change of graphs type

  We have a requirement where we show a particular simple graph in type columns. we wanted to give the user a parameter like Type: which has some or different charts in it. i would like to give a user a feature of dynamically changing the chart type. hope you understand me. let me know which is the property i need to assign the parametere value and where i should write that there is no such property available. For this you need to writhe the function and make it DLL and refer in your report or u can write the code in code window and refer that in your report ...Show All

• Visual C# how to Get all of SelectedValue and put it in On textbox?

  "I've one checkboxlist in a webform, I was tried to retrieve all of SelectedValues from CheckBoxlist"; way 1 : string i = SelectBoxList.SelectedValue; Label1.Text =i; this way is only shows "1" Value in Textbox whatever how many CheckBox I Select. way 2 : (I Use Array) string [] checklist = (string) (CheckBoxList.SelectedValue); Label1.Text= checklist[0,1,2,3,4]; when run Theme way 2 , System throw Error message .... could someone help Me to Resolve this problem thank you very much ! not sure I follow. What is the selectedValue property you are referring to a listbox listview What control secondly ...Show All

• Visual Studio Team System I really didn't understand why branching would lost history?

  I think this is a bad decision about TFS. To keep the history, I have to take a "MOVE". In other words, in addition to "MOVE", what else can I do to make a branch with original history Thx in advance. Hello, we know that this is weakness of history command (it doesn't follow branches). In v1 you can use tfpt history (unfortunatelly no gui provided). We are also investigating adding this feature in the next versions of tfs. Please keep in mind that move and branch are quite different (I don't say that there are no case when you can't use both of them) - with branch you create of the items (connected by branching relationship). ...Show All

• Visual Studio DateTime Comparisions in C#

  Hello, everyone. Here's my problem:    I have two dates to compare. But they are in different formats. One in US format "mm/dd/yyyy" and the other one is in Eropean format "dd/mm/yyyy". Here's the question:    How can I compare these two dates without writing my own function or how do I convert a date from one format to another Any answer or hint will be appreciated. The dates should compare regardless of the format. Don't compare the strings, compare the DateTime objects. Make sure that both of them have the same "time" component. In other words, both are set to 1pm or midnight, etc.. ...Show All

• SQL Server DTS- Destination Column Name has spaces causing error

  I am using Advantage ODBC 6.2 to connect to a Advantage Data Server to push data from a SQL table into this server.  I can view the data from the ADS with DTS and I can insert data by using "Insert into TempTable ("Last Name","First Name") values ('test','test)" from a Execute SQL Statement. The issue is when I build up a DTS package to pull from SQL into the Advantage ODBC, I get a "missing closing ")"" error.  I have narrowed it down to the column names in the destination table having spaces (Last Name, First Name, and a bunch of others.  DBA 101 here).  How do I beat this I have tried editing the destination column names in disconnected edit by adding the double quotes but get a "Column Name '"Last ...Show All

• Visual Studio QueryStatus() isn't called until running a command for the first time

  Hi, I am writing an addin to VS 2005. I added 2 commands to the project context menu. I have a code in QueryStatus that controls the status of these commands. the problem is that QueryStatus isn't called until the first time I run one of my commands. after the first time QueryStatus is called whenever the menu opens, which is the correct behavior for me. I put a System.Diagnostics.Debugger.Break() in QueryStatus to verify when it is called. How can I make QueryStatus be called even before the first run thanks. Hi again, I ran into another problem with this. When the user disables the Add in in the add in manager, the menu items are not removed. I saw you said in another post to not use AddCo ...Show All

• Visual Studio Express Editions How do you erase desktop icons?

  Is there a code that lets you erase an icon from your destop of from your "all programs" list Well.. the icons are actually or programs or shortcuts....its not just an icon ;P and i think you can do that IO.File.Delete("c:\Documents and Settings\Owner\Desktop\Application.txt") it sets to desktop...but you can change it to others...just go to that path in you're PC and find w/e u want and import the I/O class ofcurse Imports System.IO ...Show All

• .NET Development SQL installation script with parameters, how to run from install and config app.

  Hi, I'm making an application that makes heavy use of an SQL (Express) database. I have made an SQL installation script, which runs fine. But the script has to be altered for every user, and every different environment. so it has certain parameters (location of remote database, defenition of local to remote user mapping, local location of the database files and logfile that have to be created, etc) I was wondering if there was a good way to have these things put into parameters and set from installation or when reconfiguring the application (for instance when the remote database location is changed) I know I could just write an app that would send all this data as a single query to a database, but that would mean reading in the en ...Show All

• Windows Forms Problems with creating a usable report

  Hello everyone, I am new to blogging and forums. I have writen a basic report for home inspections and I want to have autotext enter automatically when a check box is checked. I have been trying to find information on the best way to get the autotext to appear in the comment section of my report. Can someone please help me with some simple ways of doing this Thanks Aaron Hi Bhanu The report has one page per component for the house. I need the ability to have canned texted placed in the comment section of the page whan a user checks on the check box. So each check box will have a set text that will be inserted at the bottom of the page (comment section ) when checked. Argylle ...Show All

• Visual Studio Express Editions HELP! Print preview Dialog

  little help pls... Im using printpreviewdialog in my application. when i run the application and decided to print the document, the dialog still there.... is it possible to autoclose the dialog after printing... Public Class Form1 Public CalledDirectly As Boolean = False Private Sub PrintDocument1_PrintPage( ByVal sender As System.Object, ByVal e As System.Drawing.Printing.PrintPageEventArgs) Handles PrintDocument1.PrintPage ' The 'If' statement below takes care of the autoclose If Not PrintDocument1.PrintController.IsPreview AndAlso Not CalledDirectly Then PrintPreviewDialog1.Close() End If e.Graphics.DrawString( "a" , Me .Font, ...Show All

• Visual Studio Express Editions How do you change form's focus to the internet?

  Basically that's my question: how do you hcange the form's focus to the internet I'm trying to make my form detect stuff from the internet when I open it up. ahmedilyas wrote: if you mean you open up an instance of IE and the application "sniffs" items from packets...that kinda would be illegal in a sense (packet sniffer) Illegal Eh What (in any sense) is illegal about that Packet sniffers are not illegal at all. ...Show All

• Software Development for Windows Vista ignore state machine events

  Is there a way to take no action when an event occurs I want events to get ignored instead of throwing an exception when they are not allowed in a specific state. I have many states and many events that can occur. If I want to simulate this behavior in the workflow I have to attach each event to each state, and set some state in the event handlers when I want to do something, and set the same state again when I want to ignore it. Is there any better approach (I would like to have the logic in the workflow and do not restrict the host in which kind of events it can send) Thanks in advance for any suggestion! There is no way to suppress EventDeliveryFailureExceptions. If there are no HandleExtern ...Show All

• SQL Server SQL Server 2005 Service Pack 2 CTP is available

  Hi, SQL Server Service 2005 Pack 2 CTP (Community Technology Preview) is available... http://www.microsoft.com/sql/ctp.mspx The list of new features and fixed was published here on KB Article http://support.microsoft.com/default.aspx/kb/921896 Regards Nilton Pinheiro www.mcdbabrasil.com.br Hi maddesco, Is there a date yet for the public version No. Now, the December CTP of SP2 is available at: http://www.microsoft.com/sql/ctp.mspx If not, any estimate of when it might be Dec CTP is the last SP2 CTP release, so I believe that between Jan end and Feb middle will be a most likely date. thanks Nilton Pinheiro www.mcdbabrasil.com.br ...Show All

• Visual Studio Team System Get command returns "server returned content type text/html, which is not supported"

  Hi Forum, We are currently experiencing the above error message on our test TFS enviroment. It seems only to manifest itself with binary files, such as .GIF & .PNG. We have checked the files for zero-length, and that is not the case, although one way to reproduce is to upload a file with zero-length. The result is that we cant get the files downloaded to the workspace, but we can add the files initially. The files are all marked as binary, when we look in their properties with the Source Control explorer. Any ideas TIA, GertCh Hello, It looks like this problem occurred during the download of a file. To further help us debug the problem, please can you: 1. Re-run the get, from t ...Show All

• .NET Development ASP 2.0 NET SQL Provider Membership Management

  Hello I need to connect this provider to a database being hosted by my hosting provider. I am a little confused about how this works. I take it I need to first create the tables using this tool -->aspnet_regsql which connects to my database and creates the tables. I have done this. How do I connect this database to the sql provider in the asp 2.0 Website Administration Tool. I believe I need a connection string and it should all connect and work the way it should. Is this thinking correcting and could someone please provide me with the connection string I can use to connect to a ms sql 2005 database hosted by my hosting company. Thank You Joe Hi Joe, This post should be in http://foru ...Show All