Gess Man's Q&A profile
SQL Server SSIS Inner Join Problem
I have a Merge Join transofrmation that takes as input Table1 and Table2, which are each OLEDB Sources. Both tables have IsSorted set to true and the join key set to position 1. Table1 contains 242 rows. Table2 contains 61 rows. I connect Table1 and Table2 to my Merge Join Transformation, and slect the join key. For some reason, during transformation, the join is messed up because it spits out 69 records. If I write an equivelent statement is T-SQL, the results are correct: Select Table1.Col1, Table1.Col2, Table2.Col1 FROM Table1 INNER JOIN Table2 ON Table2.JoinKey = Table1.JoinKey The results are 242 because every instance of JoinKey exists in both tables. Having double cheked sorting and data types, I am ...Show All
.NET Development How to emit delegate call (System.Reflection.Emit)?
I have to emit delegate call into dynamic method. What is the right way to do it This will create delegate, but how to call it Should I call it's "Invoke()" method like MethodInfo delegateMethod = (TypeOfdelegate).GetMethod("Invoke"); ... generator.EmitCall(OpCodes .Callvirt, delegateMethod, null ); ...Show All
Windows Forms DataGridView update
hi Private Sub DataGridView1_CellValueChanged( ByVal sender As Object , ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellValueChanged 'Usually after editing, the enter key is pressed and the current in th dgv goes to next row, 'how do i make it go to next column instead. i have the code to make it go to next column. it is 'going to next row automatically. End Sub That is just lovely, million thanks ken, There is one bug though: i cant type . (dots) in the noentertextbox. it is accepting all keys but i cannot enter my decimals. and also, i will keep it like that for the time, with textboxes behaving right and combos not. i'll report one bug w ...Show All
Windows Forms "Foreign" msi files in a Setup project
Hi there: Quick question: my application uses SMO, and I need to install that on the user's machine. I got the download from Microsoft in the form of a .msi file (the Microsoft SQL Server 2005 Management Objects Collection download from http://www.microsoft.com/downloads/details.aspx familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en ) . Is there any way for me to incorporate that msi file into my setup project I tried going through the prerequisites (I already have .Net 2.0 and Sql Server Express in there), but it is not dynamic enough to allow that. I could try and package the SMO assemblies one by one (the dlls were already added as dependencies), I'm just not sure how to force them to be installed in the correc ...Show All
.NET Development Remoting in Distributed Environments
Is there any reason why TCP Binary should not be used in a distributed environment using IIS I don't seem to gain much since I have no access to sessions or application state. Clearly every call from a web server to an application server is stateless. Hence, what difference does it make if I shut down IIS and use port 80 for pure TCP Binary remoting hosted in a windows service or host my remote objects in IIS. ps- I know about the securoity and all that I was just wondering if there was a gotcha i'm missing here. Well, there could be a reason.... if your service is accessed concurrently by many users it would be a good idea to use IIS as it is optimized to work in this scenarios..... (like a web appl ...Show All
SQL Server Bulk Insert performance
I have a situation where I need to do multiple inserts into the sql mobile db at one time. I am wondering what would be the most efficient method to do this. Right now I am just doing many inserts, but the performance is lacking. I tried to wrap all the inserts into 1 sql command and process it like that, but it does not seem to want to execute. Any help would be appreciated. Form a loop to write the columns (tab seperated) in the order exactly as in the table in database using SteamWriter object's WriteLine() method. Code Block using System.Data.SQLClient; cnMessage=new SQLConnection("Your Connectionstring") string PathToFile="\\\\DBServer\\Messages\\File.txt" cmdMessag ...Show All
SQL Server Full Text Search... alpha AND numeric searches
I have a Full-Text Index set up on a table called "Codes" in my db (sql2005). In this table I have 2 columns that I've set up as part of the FTI, AlphaCode and Name. The AlphaCode column primarly contains numberic codes (ex: 45278) but is actually defined as a varchar since the are some codes that do contain letters (ex: AT456). When I search, if I only enter a number... SELECT fts.rank, C.* FROM Codes C INNER JOIN CONTAINSTABLE(Codes, *, '"*4537*"') fts ON C.CodeID = fts.[Key] ORDER BY fts.Rank DESC I get results of every record that has 4573 as part of it's code. However, if I do it in combination with alpha characters... SELECT fts.rank, C.* FROM Codes C INNER JOIN CONTAINSTABLE(Codes, *, '"*4537 ...Show All
.NET Development Error in .net Framework 2.0
Sorry moderators if I posted this in the wrong section. I use a x86 32bit machine and I am experiencing problems using the new .net framework 3.0 on Windows XP 32bit. Whenever I use a .net web thing like webclient to download a string from a site, I get a pause and Visual Basic freezes and shuts down during compiling. I am using .net framework 2.0 SDK with Visual Basic 2005 Express Edition because it is the only compatible one with my c86 machine as far as I know. Is this because .net framework is intended for Windows Vista Skeletron, Whilst .Net 3.0 may come preinstalled on Windows Vista, it's also fully compatible with 32bit Windows XP. The reason for this is that .Net 3.0 actually uses the runtime provided by .Net 2.0. It's a ...Show All
Community Chat MS Dos prompt
The appearance of my MS Dos prompt has changed normally the cursor flashes at the top left hand corner of the screen but mine has moved to the bottom left corner and slightly off the screen particularly when I select full screen I have looked at the properties and compared with another PC and can't see anything different I would like to revert back to the old way any suggestions would be very much appreciated ReneeC wrote: YaaaaaaaaaaaaaaaY!!!!!!!!! Questions like these are not what these fora are for. ...Show All
Windows Live Developer Forums How to Add PushPin using FindLocation (without providing lat and long)
Hi guys, Just started playing with the API. I am trying to add a pushpin to general points e.g. Cities, Provinces, Postal Codes but everytime I try to the pushpin appears in a totally different point. Any insight would be much appreciated. Thanks K <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <script src=" http://dev.virtualearth.net/mapcontrol/v3/mapcontrol.js"></script > <script> var map = null; var pinID = 1; function GetMap() { map = new VEMap('myMap'); map.LoadMap(); FindTO(); AddPin(); } function FindTO() { map.Fin ...Show All
Visual Basic Creating MSSQL Tables from DataTables
Hey everyone, quick question, I'm populating a datatable on a client based on data out of a local database on the client systems, it than pushes that datatable to a webservice where I would like to recreate that table on the server. Originally I was going to push generic lists to the server to track column names, column types, column lengths etc. but than I figured the datatable has all that information in it already, problem I have is actually creating a MSSQL table based on this datatable. If you query the column datatype properties from the datatable the types come out different than the types that MSSQL requires such as the datatable pumps out "system.int32" for what the database considers simply a "real" number. I ...Show All
Visual Basic Different Versions ? What is that?
hi folks Just joined here ,curious about few things before i leap into Visual basic What are these different versions here Visua Basic Express Edition Visual Basic 2005 Visual Basic 6 Professional ,standard etc etc editions...So confusing ..Could some one elaborate this please.. Thanx There are many versions of Visual Basic : Visual Basic 6 (1998) Visual Basic 7 (2002) (.NET) Visual Basic 7.1 (2003) (.NET) Visual Basic 8 (2005) (.NET) There are many editions, one of them is Express and it's a 100% free edition. Product Feature Comparisons . ...Show All
Visual Studio VS2005 Registration Benefits - not allowed access to Registration Benefit Portal
I just registered my copy of VS2005 Standard Edition that I received at the VS2005 Launch. One of the benefits of registering is free icons, components, etc. When I try to go to the Registration Benefit Portal to download them I get a page stating that the page is missing or I lack authorization. Is there a trick to this -Chris For anyone having problems accessing the registration benefits page, follow this link: transfers.one.microsoft.com/ftm/default.aspx target=install ...Show All
Visual Studio Express Editions Another Question
Currently I'm making a media player which is using Windows Media player DLL. And I would like to get the length of the sound which is currently playing in Progress bar, How would I do that Please Help . How about showing those in Progressbar Very sorry If i disappointed u. I'm just a beginner, This's my first big project. ...Show All
Software Development for Windows Vista oscilloscope over running video
I am trying to display an oscilloscope (aka audio scope) over a running video. The directshow filter i am using to produce the audio scope is in: http://virtualvcr.sourceforge.net/html/virtualvcr/filters/scope.php. This filter creates its own window and produces the scope. What I want to do is, instead of creating its own window, it should display the audioscope over a running video. Please point me in the right direction. You have a good sample of how to do this in the same project : the histogram filter, which is a transform filter. You need to modify it so that it accepts audio instead of video, and replace the processing done in tranform by the one done in the receive function of the scope filt ...Show All