kegerdal's Q&A profile

• SQL Server Querying on a Date

  I want to query on a field called AccessDate that is a datetime data type. How do I query against this field and get distinct dates (omitting the times) select distinct date(AccessDate) Thanks in advance for the help jim ...Show All

• Visual Studio Express Editions Server Error in '/' Application Failed to map the path

  Need some help on this error. Everything was working fine for me. I had one site up and running with the Visual Web Developer 2005 Beta 2 and Microsoft Framework 2.0. I created a second website and put it in its own directory, configured IIS to use Ms Framework 2.0. Everything should work being the same just different directories. Unfortunately, now both websites are down. I have posted the error below. I have attempted creating the folder that it is yelling about even though I do not use it. I even tried creating a basic hello world website. It also receives the error. I have uninstalled and reinstalled to no avail. Any help would be apprec ...Show All

• SQL Server Running a SSIS package remotely on the SQL Server

  We have a package (which uses SQL Server Destination Task) imported in the SQL Server. Is it possible to invoke this SSIS package from a remote App Server through C# .NET. We would like to execute the SSIS package in the SQL Server itself and pass on the results of execution to the calling C#.NET application via the output variables declared in the SSIS package. Thanks, Loonysan You can do this with relatively few lines of code from either a remote component or a Web service, by using one of the Load... methods of the Application class, then calling the Execute method of the package. -Doug ...Show All

• Visual Basic Searching via a textbox string

  Hi... I'm just jumping in to VS2005, and have tried to create a simple database search that will return all the items that are similar (begins or like ) text in a 3 column database table. The form has an input textbox, and a datagrid, similar to the output of an ASPRUNNER-PRO page...only I don't want a web page, I want to do this on a form. Everything IO've seen and read pertains to bound data to text boxes, whic is the opposite of what I am trying. I want to search and display the results of my matches. For instance... If some text is typed in a text box such as: trans, or gear, or raz, I would like all the matches to be output in a grid di ...Show All

• .NET Development Invalid character value for cast specification.

  Hi all, I am runing SQL Server 2000, Windows 2003, and doing this in C# on .Net Framework 2.0. I have the SQL Statement: insert into test_table (col_1) values ( ) OleDbParameter Value = 65788 OleDb Data Type is OleDbType .Numeric col_1 has a data type of Numeric(18,0) But I keep getting this error message: Invalid character value for cast specification. The same procedure works for all column type available on SQL Server 2000, and I have created a test table that contains every available column on SQL Server 2000, and all works except  OleDbType .Numeric and OleDbType .Decimal. I have also tested the sa ...Show All

• Windows Forms [C#]DataGridView howto sum cells

  For example, in my grid cells, i write some numeric value: col1    col2   col3    col4  Total 1.5      5.5         6      7          How can i obtain the sum of that values in column "Total" considering that my rows and my column are generated at runtime Works perfectly :) Only need to use an array (for my scope) of decimal: private decimal[] d; ........ d = new decimal[31]; for(int count = 0; count < myVariable; cou ...Show All

• Windows Forms Creating Toolbars similiar to MS Office

  hello, I need to create Toolbar in  Windows Forms which has the functionality of Toolbar in MS Office. I do not want to use any third party controls.. Can anybody help me Shabari Try http://www.divil.co.uk  The components there are free for use in freeware programs. And they aren't expensive either for commercial applications. I can really recommend this  ...Show All

• Visual Studio Express Editions Can I install Express side by side with VSTS?

  I have VSTS installed on my work computer. I'd like to install the Express editions as well, because I think they are lightweight and are suitable for small and quick tests. My question is - can I install them side by side with VSTS   Yes they can all be installed side by side. They are considered to be seperate products. I currently have all of the express systems install as well as VS2003 std, and VS2005 Pro edition. ...Show All

• Visual C# Opening a file / stream.

  Hi folks, i've got a file in a System.IO.Stream object. kewl. i have a button on my windows form which, when the user clicks it, the file will open with the appropriate default program. I'm not sure how to 'kick in/execute the file'. examples: 1) If the filestream object is an mp3 (ie. extension is .mp3), the default program for .mp3's will kick in 2) if the extension is .txt, notepade or wordpad (whatever is setup as defaults) will kick in. 3) if the extension is .aaa then the 'Please select the program to run this file default dialog thingy' is asked.   cheers :) EDIT:Replaced FileStream -> Stream. Typo. ...Show All

• Visual Basic Which Control did I RightClick on?

  hi all... Is it possible to find out which control a user rightclicked on and show the name of the control in a messagebox For example I have three buttons on a form and a contextmenu that is used in common with all the buttons. When a user rightclicks on a button the context menu is shown. Kind of like the "Whats This" menu in MS Apps. So instead of writing a rightclick event for all of the controls on the form, I thought that if I could find the name of the control that the user rightclicked on to open to context menu, I could show the appropriate response. Is there a way to find if a coordinate of the mouse click falls ...Show All

• Visual Studio Team System Set new field - Owner inside of WI and pull values from Active Directory

  Hi, I'm trying to have on my WI field name Owner and to pull values from the Active Directory the same way as Assined to field get his own  values  from the Active Directory I Couldnt find a way to do it except of importing all the values from the active directory inside of a global list and then use the global list as optional values inside of my owner field. There must be a better way to do it Thanks in advance, Shmulik. The list of allowed values may include groups of the following types: AD group: <LISTITEM value="domain\group" /> ...Show All

• .NET Development VS.NET 2003 to build applications using .NET Framework 2.0

  Can one use VS.NET 2003 to build applications leveraging the .NET framework 2.0 Hi, Definitely. But you should use MSBuild . cheers, Paul June A. Domag ...Show All

• Visual Basic Cross-thread operation not valid

  Please tell me that you are going to fix this before the official release!! I am using VB not C++.  I really shouldn't have to care that my code is not running in the same thread as the one that created the form that contains the control that I am trying to update. Please fix this or at least have some real examples that show how to update a control on a form.  The examples that I found were not helpful at all. Well you really should care what thread is accessing a control. You are not using VB6 now. There are hundreds of examples on how to do this correctly. Some including: http://msdn.microsoft.com/library/default ...Show All

• Visual C# Increase Memory Pressure for Garbage Collection

  Dear all, I would like to ask if any API or efficient way for making GC run more frequently, without calling GC.Collect() What I am doing is I am checking if the objects are referenced by other objects, by using weak references. Unfortunately, it was found that as the latest made forms had not been garbage collected yet, and the Target in the weak reference still showed the object. I tried to increase the memory pressure by composing new garbages, but not successful. I found some posts saying that it is possible to increase CLR memory pressure for acheive this Is it right If yes, how to implement Thx a lot! Gabriel ...Show All

• Visual FoxPro Memo file is missing or invalid

  Hello, I have a DBF file an I need to open it. I have VFP9.0 and when I try to open it I get a message suc as: "Memo file C:\....\myfile.fpt is missing or is invalid." Is there a way to open this file I will deeply appreciate advices or ideas.. Thanks. Hi slarin, No he didnt give the .fpt file, but I solved my problem already, I used dbf recovery trial, and then from there I saw the structure of the table (memo), then I followed cindy's instruction. TY. Thanks also cindy. Mark ...Show All