smanche's Q&A profile

• SQL Server extracting the specified record no of records from database table

  hi all, I need to select the no of records on the basis of specified range of records. In oracle i found rownum, i could not find it in sqlserver. how the data are extracted from the huge records.. I have used temporary table,map the table primary key to the next table with identity but i dont find it good. I need to ignore the insert the data in next table or craeting new table having the rowid ... Is there some other best way to extract the specified data here is the type of query. select * from customers where rownum between 1000 and 10000 this is in oracle i am in need to do this in the sql server waitin ...Show All

• Visual Basic trying to understand classes, module, subs, functions

  I would like to know the differences between a class and a module, and the difference between a sub and a function. I know how to use them. I've been programming for years. But I would like to know the deep details of them so I know where and when to use them. So I can have the most efficient programs. Thanks sub and function is an artificial construct so that VB can avoid having a void return type. Apart from a function returning a value, there is no difference. ...Show All

• Smart Device Development Text Formatting in a ListBox

  Hi, I'm trying to add some formatting to items being added to a list box. Using the code below, 'System.Windows.Forms.ListViewItem' is added to the listbox instead of the text. Dim lvi As New ListViewItem lvi.Text = "Out of Stock" lvi.BackColor = Color.Red lstProducts.Items.Add(lvi) ...Show All

• Visual Basic Caption -> Text

  ok in vb 6.0, you could easily define library's (for lets say GetTickCount) and easily set the main caption on any form. Me.Caption = "Blah" i just got visual studio 2005, and dont understand how Me.Caption doesnt work and i have even tried Me.Text. i get syntax errors, something here im not understanding for the conversion factor The forms caption property of VB6 has changed to the forms text property in .NET and as stated Me.Text="The Forms Caption" works...were are you trying to set it ...Show All

• Smart Device Development Own ToolBoxItem

  Is it possibility to use own ToolBoxItem in Pocket PC project It seams that Xml Design-Time File doesn't support ToolBoxItem attribute ! While there is no Toolboxitem attribute support, you can use the following steps to "get the ToolboxItem attribute in". 1.Compile you control lib (e.g. PPCCtrlLib.dll) 2.decompile: ildasm PPCCtrlLib.dll /out:PPCCtrlLib.il 3.edit to add the ToolBox attribute, e.g. notepad PPCCtrlLib.il add toolbox attribute, e.g. .class public auto ansi beforefieldinit PPCCtrlLib.UserControl1 extends [System.Windows.Forms]System.Windows.For ...Show All

• Visual C# Setup Set Version and Install Overwrite Properties

  I managed to do this once, but never again In a VS2005 Setup project, by some combination of actions, I was able to get to a properties list that allowed me to directly set the Version Number and the flags that forced the setup project when compiled to overwrite any pervious version (for sllent install running under administrator role) on the users system. Can anyone help me to know how to access this property list. Thanks Hi, Seems like you need to access your setup project's properties' list. If so, just select the project node in the Solution Explorer, then Press Alt+Enter to invoke the Properties window. Thanks ...Show All

• Windows Forms Convert MFC Fonts to c# Fonts

  hi, I have an application developed in MFC( VC++ 6.0 ) where the information all the parameters of CreateFont function of CFont is stored in a file. Now I am rewriting the whole application in c#. But I am not able to map all the paramters of CreateFont to the Font class of c# and to provide backward compatibility it is important. Can anyone suggest me a possible workaround for this problem The information about the font is stored in the follwing format: 1. LoByte (Point size for Font) 2. LoByte (Point size for Font) 3. LoByte(LoWord(Height)) 4. HiByte(LoWord(Height)) 5. LoByte(HiWord(Height)) 6. HiByte(Hi ...Show All

• Visual Studio Team System Cant build after TFS upgrade to RC

  Hey guys. We finally got aroung to upgrading from B3R to RC. After the install I tried to perform a Team Build on one of my projects and it fails immediately with the following message found in the BuildLog. Target InitializeEndToEndIteration: UpdateBuildNumberDropLocation BuildNumber='3.02.0.056' DropLocation='\\fileserv\Develop\ReleaseSoftware\2.0 Framework\Billing\3.2.0.56' C:\Program Files\MSBuild\Microsoft\VisualStudio\v8.0\TeamBuild\Microsoft.TeamFoundation.Build.targets(165,5): error : Attempted to perform an unauthorized operation. Done building target "InitializeEndToEndIteration" in project "TFSBuild.proj&qu ...Show All

• Visual Studio 2008 (Pre-release) Location transparency

  Hi to all, I would like to know if in the WCF framework there is some features similar to JNDI in java, or similar to what a "Broker" pattern do , someone that receive a request and know where the real service is Or do I have to implement it (maybe extending the Entity aggregation sample ) Could you give me any suggestion Thanks in advance Alex Are you refering to a router scenario Thanks! Scott ...Show All

• Visual C# '' is not a valid win32 application ?? Win64

  Hi, I'm migrating my project over from my old setup (.NET1.1, VS2003, Win32) to my new setup (.NET2.0, VS2005, Win64). The solution consists of a class library and a win forms app that references the library. When I try to debug (after rebuilding all for 'any CPU'), i get the following exception at the first point where the app tries to instantiate a class from the library: '' is not a valid win32 application Has anyone seen anything similar Is it some kind of assembly binding problem, perhaps compounded by the 64 bit architecture and OS Perhaps its some kind of .NET version mismatch Any help will be greatly appreciated. Thanks ...Show All

• Visual Studio Express Editions Upgrade SQL 2000 database to SQL Express?

  I have a small SQL 2000 database that I wish to migrate to SQL Express to test etc. What is the easiest way to go about this please Excuse the newbie question please... Cheers Craig I initially installed 2005 Express on my game computer and then created all the tables, constraints, keys, stored procedures, etc. Then I wrote a VB6 utility program to copy records from SQLServer2000 to SQLServer2005 Express. It was quick!!! I checked all the tables to make sure the keys where there and correct. I copied over about 500 meg of data. Not much is it ! Then I blew away my development machine and installed ...Show All

• Windows Forms DateTimePicker in WinForm

  Hi Is it possible to set dafault value is null for DateTimePicker Thanks Thyagu I also would love to see your version of the DateTimePicker control ...Show All

• Visual C# How to format a single TextBox

  HI, Coming from a ‘ Oracle Developer ’ background and just entering C# developments I am kind of disappointed with C#. I mean you have to write tons of code to do anything. Also the number of web sites you have to go to and also the amount of on-line help you have to read in order to learn even a simple operation really frustrating. All I want to do is this.  I have a database table called EMPLOYEES and I have created a form for it .   The form works fine.     All I want to do is format the SALARY column to this format: 999,999,990.00 (I.E. if salary is 49749.55 then it should display 49,749.55).   ...Show All

• SQL Server Weird INSERT INTO SELECT results

  Hi all, I am having a weird problem occur when trying to insert missing records based on an INSERT INTO...SELECT statement. Basically, I am populating a temporary table with data, then inserting into a main table those records from the temporary table that aren't in the main table. In addition, I am updating those records that are in the main table. When I call the following SQL, all of the records from the temporary table are inserted even though those records already exist. Bizzarrely the update statement works perfectly. INSERT INTO AffiliateCategories (Identifier, AffiliateID, NetworkID, AffiliateCategoryName, NetworkCategoryName) SELEC ...Show All

• Visual Basic Select A Row in a Datagrid

  I want to be able to delete a row from a datagrid based on the row the user has clicked on. Whichever row is highlighted, I want to delete it from the grid. But I cannot find any examples on how to do this. Any help would be great! Thanks! There should be plenty of examples of this... providing you know what you're looking for. The trick here is understanding that the DataGrid is only a display control; that is, it does not itself contain data. It gives you a view of data stored in some other object, such as a DataSet or Collection. So you don't delete a record from a DataGrid, you delete the record sele ...Show All