KitWest's Q&A profile

• Visual C# quick help with ExecuteNonQuery

  im using the following code to insert to database and i wish to know if it was a success but it insets into database but doesnt return the result, it just locks up. Any ideas System.Data.SqlClient. SqlConnection conn = new System.Data.SqlClient. SqlConnection ( "Server=SERVER1;Database=data;Trusted_Connection=True;" ); System.Data.SqlClient. SqlCommand cmd = new System.Data.SqlClient. SqlCommand ( "addData" , conn); cmd.CommandType = CommandType .StoredProcedure; cmd.Parameters.AddWithValue( "username" , a_username); cmd.Parameters.AddWithValue( "password" , a_password); conn.Open(); if (cmd.ExecuteNonQuery() != -1) // locks up here am i doing it right { ...Show All

• Windows Search Technologies Installation

  I am running Windows XP x64, in trying to install Desktop Search receive error message indicating that installation failed, check log file KB917013 in the windows directory. Log indicates: Global registry changes. Install error 0x5. INF Registry Failed. I'm logged on as the administrator. Any ideas as to what is wrong ...Show All

• Visual FoxPro OleDb provider and unc path

  I make ASP page for internet access and i need to read & write data from visual foxpro tables. These tables use new fields type (of last versions of foxpro) like autointeger fields so i can't use ODBC driver. The tables aren't on the sane server where is localized the web server and i need to use the oledb provider and insert this connection string Provider=VFPOLEDB;Data Source=\\DataServer\Application\Data\;Collating Sequence=Machine When i try to access the data i receive an error : Invalid path or file name..... There are problems using OLEDB and unc path names Why there is not an updated odbc driver from Microsoft for newer versions of Foxpro ! !! ! Thanks ...Show All

• Windows Forms MDI and TopMost...

  I have an MDI Form that has 4 child forms that have TopMost = true; However when I set TopMost = false; These windows still stay on top within the MDI Form. Is there any other setting that could cause these forms to stay on top Thanks for your help! Your question put me onto the answer, Thanks! The MdiParent was being assigned using a function that was in some unmanaged code in a dll that I have no idea about. So, I took that code out and set the parent directly. Thanks again, Mandragon ...Show All

• Visual Studio Express Editions MS ACCESS filter problem !!! HELP

  I'm trying to do a query based on a access database table called cars. For example in the car's table there is a field called "colour" How can i make in "Query Builder" a filter that retrieve all the cars, for example, with the colour "red" in the "colour" field. I already try the "@colour" but with one access database it doesen't works. Can anyone tell me what i have to do do populte a listbox with all the red cars Tnks Access Does NOT support named parameters..it uses the ordinal position of the parameter to fill values....in the query builder try using just a question mark or putting the string inside of square brackets: [@colour]   ...Show All

• Visual Studio 2008 (Pre-release) Clarification on SSDL ?

  Hey there! Ok, I've read numerous articles on vNext as well as been analyzing the samples. I would just want to have a couple of concepts clarified to me: General concept: ----------------------------------- As I have unserstood it, the *SSDL files contain the description of the "physical" database with all its tables translated into the Entity framework "types". *CSDL files contain the conceptual model which is exposed to the application, and should preferrably be as consistent as possible with little or no major changes. *MSL files maps the conceptual model to the SSDL description of the "physical" database Have I understood this correctly The part I'm a bit confused about is the SSDL, this has nothing to do with the conceptual model ri ...Show All

• Visual Studio How to include the license file as resource file through MSBuild?

  I have a '.license' file with me and I need to include that while building the project. Previously I used to do the following <cs.build projectFile='Service.csproj' compilerOptions='/res:"Service.exe.licenses"'> I have tried to include it as a project property as follows: < MSBuild Targets = " Rebuild " Projects=" Service.csproj; " Properties = " Configuration=Release;Resources=Service.exe.licenses; StopOnFirstFailure = " true " /> But this doesn't seem to work. BTW I am using the same .license file as I was using for ver 1.1. You would pass the .licx file in EmbeddedRssource item. .licences file would be ignored. So ...Show All

• SQL Server expressions in layout view of Reporting Services

  ok Using MS Visual Studio / Reporting Services Table = calllog Field 1 = RecvdDate Field 2=RecvdTime in my layout view I have combined these two - Txt header CallRecvd (Value=Fields!RecvdDate.Value & " " & Fields!RecvdTime.Value) I have a txt box called [Today] Value =Today() (I am showing this in a box but it actually doesn't have to show at all last txt box - I need to do the following =DateDiff([ CallRecvd] ,[Today]) (error CallRecvd is not declared) not sure where I do this thanks please advise Jewel You can reference the value of other textboxes within the current or parent scope by using the ReportItems collection of the ReportObjectModel ...Show All

• SQL Server Problem installing SQL Express

  SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and the run SQL Server 2005 Setup again. Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435 Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1187.07 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00 I used Add/Remove Progs and used the list in the order suggested to remove all beta versions of VB, SQL, .NET and etc. Nothing is listed. I do have VB6 PRO. I have looked for directories and removed all. I have searched for SQLexpress in the registry and eliminated all I co ...Show All

• .NET Development Retrieve output inserted multiple columns

  Hi everybody I execute the following sql statement in order to retrieve 2 consecutive identities: delete from empaward where EawSystemID = '64SZGE000080' INSERT INTO EmpAward ( EawAwardID, EawProvider, EawEEID, EawSystemID ) output inserted.EawID AS [EAWID_e596fb61_2df9_422f_8173_d7038536d74c] VALUES ( 'EM', 'Z', '3EZ9C605L080', '64SZGE000080' ) delete from empaward where EawSystemID = '64SZGE000080' INSERT INTO EmpAward ( EawAwardID, EawProvider, EawEEID, EawSystemID ) output inserted.EawID AS [EAWID_e596fb61_2df9_422f_8173_d7038536d74d] VALUES ( 'EM', 'Z', '3EZ9C605L080', '64SZGE000080' ) When I run that in the SQL Query analyzer I get 2 different consecutive values. Then I try to retrieve the results from an ADO.NET applica ...Show All

• Visual C# Change System Timezone Programmatically

  Hi, By using System.Timezone.CurrentTimezone I can get the DST Dates of it, is there a way to change the system timezone so that i can use the CurrentTimezone for other timezones Thanks HI, to make things clear, I would like to change the Timezone of the System (Programmatically using C#) then I will use the System.TImezone.CurrentTimezone to do the things I wanna do. Thanks ...Show All

• Software Development for Windows Vista how to skip frame for compressed viedo

  hello friends, i created a source filter to play compressed viedo in windows media player, since it's compressed, i need to skip frame in order to show the frames corresponding to the position of windows media player scroll bar. my question is : how can i get current position of windows media player scroll bar especially when i am only developing a source filter, Hi, Is it sufficient to support IMediaSeeking on Source filter only or is it also required to implement some pass through functions on the transform filters as said on http://msdn2.microsoft.com/en-us/library/aa919887.aspx under "when to Implement" section Regards, ...Show All

• .NET Development DataTable internal index is corrupted: '13' in NET Framework 2.0 (VS 2005)

  Hi In .NET Framework 2.0 I am getting the error "DataTable internal index is corrupted: 13" when I attempt to accept changes on a DataSet. The problem seems to be caused by having the AcceptRejectRule on my relationship set to "Cascade". We have worked around the problem for the moment (by removing the rule and processing datasets in a different way) but will there be a fix for it The error is intermittent in our application but the following code will emulate the problem every time. Cheers 'Create a new dataset for employees where 'each employee has a name and (optionally) a manager Dim Table As New DataTable( "Employee" ) Table.Columns.Add( "Id" , GetType ( Integer )) Ta ...Show All

• Visual C++ Is there a macro which converts a 32 bit signed integer to 64 bit unsigned integer ?

  Hello All, Is there a macro which converts a 32 bit signed integer to 64 bit unsigned integer Thanks in Advance, CPPUser7 Coming to my problem. I have a function which currently returns a long and I have to change this function to return unsigned 64 bit integer so I have chosen ULONGLONG. ...Show All

• SQL Server External Activation with "n" servers processing messages.

  I am attempting to use Service Broker to distribute message processing across multiple machines. I have mulitple queues setup to all notify a single service with the QUEUE_ACTIVATION event. My external application then sits in a "WAITFOR RECEIVE" on that event queue and when it receives a message for a particular queue, will begin processing the messages in that queue if that particular server is configured to process messages of that type. My problem is that once one server starts receiving messages, the others don't always start processing and I end up with one server attempting to process all the messages by itself. What is the best way to notify multiple servers that there are messages in a particular queue which need process ...Show All