SoCalChristopher's Q&A profile

• SQL Server An easy way to reference the nth row from a table meeting a condition x, and the mth row from the same table meeting condition y

  Hi I am developing a scientific application (demographic forecasting) and have a situation where I need to update a variety of rows, say the ith, jth and kth row that meets a particular condition, say, x. I also need to adjust rows, say mth and nth that meet condition , say y. My current solution is laborious and has to be coded for each condition and has been set up below (If you select this entire piece of code it will create 2 databases, each with a table initialised to change the 2nd,4th,8th and 16th rows, with the first database ignoring the condition and with the second applying the change only to rows with 'type1=1' as the c ...Show All

• .NET Development newbie needs HELP with SQL insert/update in J# windows form

  Thanks to anyone who helps! I'm building a data entry windows form that requires the data to be sent to a SQL Server table (the table's name is "Local") when the form's "SAVE" button is clicked. I've built the form using the windows form designer, and now I'm attempting to use SQL statements to insert/update data into the table. There are six fields that will use SQL statements to send data to the Local table, and none of the fields are permitted to be null values. Two of the fields are comboboxes that are populated through the use of their own respective datasets (DisasterType and Dwelling); the datasets were ...Show All

• Windows Forms Help with WndProc override in .NET Visual C++ 2005

  I have inherited from ...::UserControl and have a need to capture private window messages. I have been all over the Internet and tried everything and have found no means to override virtual WndProc. My latest definition looks like ... protected : System::Void WndProc(System::Windows::Forms::Message m) {    __super ::WndProc(m); } ... where from the debugger I am sitting on __super ::WndProc(m); to see if the break point catches. Breakpoints elsewhere in the code catch just fine, but no definition of WndProc seems to allow for an override. Any suggestions   bxs122 wrote: I have ...Show All

• .NET Development How to get the list of available satellite assemblies for the main assembly?

  I found just Assembly.GetSatelliteAssembly() which returns just one satellite assembly. I want to retrieve to list of all for users to select their appropriate languages.Please suggest!!! Thank you!!! Not really sure how u mean this.  But i'll take a shot: To call Assembly.GetSatelliteAssembly() u need to give it parameters. Look at this: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfsystemreflectionassemblyclassgetsatelliteassemblytopic.asp Wat u can do is to create a dropdownbox and let the user select's a language. After the selection u lookup the CultureInfo something like this: ...Show All

• Visual Studio Express Editions Web application...?

  Is it possible to create a web application using visual basic express edition I'm trying to create a web form using vb-express edition, please let me know if i need to install any additional components and also the URL for installation. Thanks, Balaji Hi liquid, I studied the bitmap you linked to and I'm not sure what is missing or broken. Could you provide details about what you're trying to do but can't Do you see any error messages thanks, Paul ...Show All

• SQL Server ISSCEStatusReporting interface - replication progress in C++

  Hi, I'm not sure if my previous post was in the right forum so, please accept my apologies if I'm doing "double" post. I have created 3 years ago C++ class wrapper -MFC like- for SQL Server CE 2.0. I migrated those two months ago to support SQL Mobile. Today, I would like to get notifications from Replication progression but I couldn't figure how to override ISSCEStatusReporting interface. If anyone could give hint or sample code, it will be greatly appreciated. Thanks in advance, Regards, Fabien. The merge process will call methods on an interface to an object instance that you have provided to it (ISSCESt ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Reading compressed textures

  Hi, I have been working on a small 3d project for myself and i was wondering if anyone can help or point me in the right direction. Im trying to read in dxt compressed textures, i have been reading about the format in msdn and have been looking for some source code or tutorials on how to read these formats in. Im using C# and MDX i have posted the the source code that i have been playing with so far, this is to read a DXT1 compressed image. If anyone has some sample code, links or a better way to go about this please let me know. Thanks for any help,     -Dave   // CODE SurfaceDescription s = t ...Show All

• Visual Basic VB 2005??? PT 2

  Public Function Plus( ByVal ad As Integer ) Dim id As Integer Dim cm As Integer End Function I want to pass this fuction a varible that when i call it in the code i can enter any number and add it to another number any help with that, i know it sounds rather simple but i am not sure if i should pass two varibles or one i am thinking i should pass two and declare a local var and i dont know thats where i draw the blank....any help would be great You can do it something like Public Function Plus (Byval A as integer, B as integer) as integer Return A + B End Function Then just ...Show All

• Windows Forms BackColor Property of textbox

  I discovered a very strange behaviour concerning BackColor/ForeColor properties of a textbox. On a form, I have a textbox which contains a url. I want to implement the hypertext behaviour into this textbox, so I override the OnMouseEnter function to set the ForeColor to blue and the Font to underline. In the OnMouseLeave function I revert those Properties to their originals. It's the OnMouseEnter function where the strange things happen: protected override void OnMouseEnter( EventArgs e) { if ( this .Text != string .Empty) { this .cachedBackColor = this .BackColor; this .cachedForeColor = this .ForeColor; this .cache ...Show All

• Visual Studio Tools for Office Excel PIA Problems

  Hello, I have a component library that I'm trying to reference Excel with.  I'm referencing the Microsoft Excel 10 Object Library which points to Excel.exe in the correct folder.  But it's not using the Office XP PIA that I installed; instead, it uses the normal reference, which has problems.  How can I reference the PIA to use it in my application   I don't understand why it wouldn't work; I got Word to work this way. Thanks. Hello Brian, what do you mean by "...it uses the normal reference..."   Are you saying Visual Studio generates an Interop Assembly instead of using the ...Show All

• .NET Development SQL Express Connection Problem - Please Help

  I get the following exception from SQL EXPRESS An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) from the following three lines of code: Dim SQLConn As SqlConnection = New SqlConnection() SQLConn.ConnectionString = "server=local;database= ; user id=sa; password=;" SQLConn.Open() I am running this on a single XP Pro system. The SQL ...Show All

• Windows Forms Stop Multiple Instances of Child Form

  Hi, i want to stop multiple instances of child forms in a MDI application, can anyone suggest what can i do  my code is like this. Private Sub MenuItem5_Click(ByVal sender As System.Object, ByVal e As    System.EventArgs) Handles MenuItem5.Click         Dim b As Form3         b = New Form3         b.Show() & ...Show All

• Visual Studio Team System Code Coverage using Webtests

  Hi. I am trying to obtain code coverage results for the webtest run. When I enable code coverage, I get an error message "Empty results generated: none of the instrumented binary was used. Look at test run details for any instrumentation problems." in the CodeCoverage results and no data is collected. The detailed error is "Code coverage instrumentation warning while processing file filename.dll: Warning VSP2013 : Instrumenting this image requires it to run as a 32-bit process. The CLR header flags have been updated to reflect this." Can you please explain Also, Do I need to have vsts loaded on the same system as ...Show All

• Windows Forms Tab behavior in design mode. New objects in first position.

  In VS 2005 RC there is new behavior with regard to tabs in design mode.  That is, lets say I have a form showing on a tab in design mode.  If I then select a new form (or object) to show, it moves to the number one position, or in other words, becomes the first tab of those tabs seen.  I am not sure what the logic or thinking is as to why this would be desireable.  Perhaps someone can enlighten me.  It would also be helpful to know if this behavior can be turned off.  If so, how ...Show All

• SQL Server Errors when attempting to use DataReader destination

  Hi, We have an ASP.Net app that consumes data from a SSIS package. I have proved that this works by building a noddy ASP.Net app against it on my local machine. Unfortunately the same isn't true of our project-wide solution where we get error "Package failed to execute." In our package log I can see that the things that were failing were various property expressions that are in my package. The expressions are all on the SQLStatementSource property of various Exec SQL tasks in my package. Here's an example of just such an error: OnError,FR23011958,CT\aeqz,SQL UPDATE StreamHistory,{30BD52FA-8077-4D40-BFA7-248173C34000},{C84EF8C0-4B15-41FC-B205 ...Show All