rtaiss's Q&A profile

• .NET Development DataBinding Question (RESOLVED)

  Hey all, Ive been looking at this sub for nearly two days now and its starting to wear a bit thin. Im trying to query my database and display information in various places based on whats selected on my CBO... here is the code; Private Sub formDirectReceipt_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim strCnn, strSQL As String strCnn = "provider=sqloledb;data source=pe750-d;initial catalog=TestHSS;trusted_connection=yes;" strSQL = "SELECT [Product Code], [Short Description], Cost, ProductionGroup " & _ "FROM Product " '& _ '"WHERE Product.[Product Code] = @prdCode AND Product.ProductionGroup = @cellVar" Dim da As New OleDb.O ...Show All

• SQL Server Slow Quick Find Dialog performance vs. F3

  I'm running SQL Management Studio SP 2 on Windows XP SP 2. I frequently use Quick Find to look for errors in large result sets by looking for the string "MSG". My result sets are frequently just the # of rows affected by SELECT INTOs, UPDATEs, DELETEs, etc. I'm not doing large SELECTs and looking at the results. What I've noticed in result sets larger than 1000 rows, is that the Quick Find box will often freeze up for several minutes when I'm looking for msg. There is no disk activity, but CPU activity will be maxxed at 100%. No other apps will be open, plus my task tray is pretty empty. My PC is a IBM Pentium 4 w/ 768 MB of RAM, and plenty of hard disk space. However, if I click over to another query window with "MSG" ...Show All

• Visual Basic Com Interop problem with VB.Net project

  I have built a variation of the Ldap Authentication function referenced in http://support.microsoft.com/default.aspx scid=kb;en-us;326340#3 The problem i am having is accessing the resultant .dll Do I need to research and develop a "strong name" for the assembly   The properties are set to "Register for Com interop".  Is C# a better platform for building COM objects I know it is a little bit old of a question but I had the same problem and just found the solution so I think it can help somebody else. What you just need to do is register your dll using regasm http://msdn.microsoft.com/library/default.asp url=/library/en-us/cptools/html/cpgrfAssemblyRegistrationToolRegasmexe.asp ...Show All

• SQL Server Dynamic Textbox height?

  Hi, I often have a 'label' text box next to a 'data' textbox. If the data textbox expands how can I get the label to match it in height . I tried to set the height of one to the height of the other but got errors. Thanks, Dear, U can do it by using functioin.Your testbox and label size will be same. U can try this ="hello" & space(len(Parameters!SaleOrderNo.Value)) & "." In passed these parameter with in a lable(textbox). Parameters!SaleOrderNo.Value in a textbox. Hope this helps u. from sufian ...Show All

• SQL Server 0 aggregations was designed (0% optimization)

  When I try to design aggregations it always produces 0 aggregations. what am I doing wrong You might find this article on my blog useful: http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!907.entry As Thomas said, 0 aggregations could be due to the way you've designed your attribute relationships; it could also be the result of other things, such as the the number of members on each attribute. Chris ...Show All

• Visual Studio 2008 (Pre-release) Concatenate doesn't work

  Any reason why below code doesn't work string[] names = {"MSFT","IBM","CSCO","GOOG"}; //Get a list var msft = from s in names where s == "MSFT" select s; //Get all symbols from global list except microsoft var msft1= msft.Concatenate(names); //Gives compile-time error Thanks in advance As Steve Eichert said,"Concat" will work for you: var msft1 = msft.Concat(names); Based on your comment in the code, "Get all symbols from global list except microsoft", you might want to use the method "Except": var msft1 = names.Except(msft); ...Show All

• Visual C# suppress the enter key for certain controls

  I have a set of asp:ImageButton's that I am using to provide a collapsable navigation system. Some of my pages also have a login / signup page. The problem that I am having is that once the page loads, if I click anywhere on the page and then hit the enter key, the first ImageButton is firing it's onClick event handler. I have put a causes validation = false. On the pages with a submit / login button, I have created a panel with the default button set to the submit button. For some reason, the validation being performed is different when hitting the enter key than it is when clicking on the submit button. Is it possible to suppress the enter key for the asp:ImageButtons the url for my dev site is at: http://208.109.32.134/ just c ...Show All

• SQL Server Question about Font size

  I'm trying to set my font to any size smaller than 8. Is that possible I am trying to use portrait orientation instead of landscape but I can't fit everything on one page using portrait orientation with 8 point font. Thanks! Its not that I received an error, it's that I can't figure out how to do it. While I am constructing the report in layout view, the smallest font size available is 8. If I change the font to a 6, it reverts right back to 8. How can I set the font size in layout view to smaller than 8 Thanks! ...Show All

• SQL Server Can we change the name of the instance ..

  Can we change the name of the instance (SomeSQLInstance1, Some SQLInstance2) to be "SomeSQLStdInstance" while upgrading to SQL 2005 from MSDE 2k or SQL 2000 hi, Rubal Jain wrote: Yes. You can change the name of an instance as long as the server is not clustered. For more information, visit the following Microsoft Developer Network (MSDN) Web site: http://msdn.microsoft.com/library/default.asp url=/library/en-us/instsql/in_afterinstall_5r8f.asp the feature you reported is only able to resync the server name to a SQL Server instance and not to just "rename" an installed instance.. if you installed a local named instance of SQLExpress, usually named (Local ...Show All

• Internet Explorer Development IE7 Crashes when undocking

  Since I upgraded to IE7, I notice when I undock my laptop (to carry it to another location with an ethernet connection) IE7 disappears.  I assume it crashes but does not produce any kind of message.  It disappears from the task list altogether.  It doesn't prompt me to close tabs or anything.  FYI, I have a second monitor in my docking station but I move IE to the laptop screen before I undock.  My enabled addins are as follows: Adobe PDF Reader Link Helper (Version 8) Diagnose Connection Problems Shockwave Flash Object SSVHelper Class Sun Java Console Windows Messenger I do not have any Office 2007 apps installed.  Only Office 2003. Have you tried startin ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Joypad problems

  Hi have just set up C# EE and XNA game studio, no problems there. Compiled and run ok, but I get absolutely nothing from my Joypad, no buttons, no direction, nada..So am forced to use keys which respond fine The joypad works fine in other games, so is XNA only compatible with Xbox 360 joypads TIA Brian If you don't have the latest DirectX SDK you might want to download it and take a look at the DirectInput samples. They'll show you exactly what you need to do to get it running in your game. There's also a ton of resources available on the various game dev sites (you might start at GameDev.net). ...Show All

• Visual Basic INSERT INTO SQL in VBA Not working.

  Hello out there, I am a first time programmer developing a database to track publications for my office. I have set up an Access database for it. I am attempting to create a user friendly form called "Articles". Within this form there is a combo box, "Status of Publication", that is linked to a table called "Status of Publication." I would like to create an event procedure to do the following: 1. Upon NotInList, I would like a message to ask if the new entry should be added. 2. If they select "Yes" I would like the new entry to be added as a row in the table "Status of Publication". 3. I would like a confirmation message to appear confirming the new entry in the table. 4. If ...Show All

• Visual Studio Team System Shouldn't Extraction Rules execute before Validation Rules???

  Somehow I have this nagging feeling I missed something simple somewhere and am asking a stupid question, but I will ask it anyway... I am setting up some tests creating custom extraction rules and custom validation rules. When I set them up for a given web test, they show up in the UI and execute in the order of Validation Rules, then Extraction Rules. It seems to me that it should be the other way around. FYI, I am primarily manually setting up Requests (not using the recording mechanism). Here's what I am doing and expecting: Create the web test. Add a Request to a URL (let's say http://localhost/test/default.aspx ) Add an Extraction Rule (happens to be Custom in my case) to pull out the data in XML format using XSLT and H ...Show All

• SQL Server Connecting to Remote SQL Server

  Hi all, I have been encountering problems in connectiing to an sql server remotely. I have a SQL Server installed on a machine with a public IP. I am, running an application on one of my other Servers having a Public IP as well. Now i want to access the SQL Server Database of my first machine from my second machine, but i cannot get connected to it. I give the IP address of the machine in the connection string but it fails. I have also tried it with the port number. What could possibly be the solution for a problem like this Regards. Can you check whether there are any issues with WINS issue on the network, ifyou are not able to register with name as explained you might try PING between the ...Show All

• Visual Studio 2008 (Pre-release) UpdateObject() / AddObject issues

  I just got done reading Danny's excellent article here and I just tried to incorporate that logic into my own ObjectDataSource. When I call db.AddObject(), the entity's ID gets reset to 0. This doesn't seem right at all. :) Is there something I could be overlooking Thanks for any help! (Have I mentioned yet that this is AWESOME STUFF I haven't been this excited about programming in years!) Mike Ok. Found the problem. The problem is that even though the values for the ProductID is set, the actual Key property is null. If I put the following line in before the AddObject is called: entity.Key = context.CreateKey( typeof ( T ), new KeyValuePair < string , object >[] { new KeyValuePair < string , ...Show All