GunasekaranT's Q&A profile

• SQL Server Grouping record based on a condtion

  Technology Type Size XYZ A 200 XYZ1 A 200 XYZ2 A 300 XYZ3 A 300 ABC1 X 238 ABC2 X 238 PQR B 320 MNO C 330 I have written a query on a table whose output will look like the above. I need to know if i should store this in a record set or create a temp table to get the following fuctionality. Now I need to concatenate the Technology based on Type and size. As you can see in Type A we have two sizes 200 and 300. We need to group the Technology of type A wi ...Show All

• SQL Server Row height issue on export to Excel

  Hi all, I've been having some problems with a report on export to Excel. I have four tables, contained within a rectangle at the top of the report, followed by a second page of tables dynamically generated by the data being fed into the report. On export to Excel, the top sections of tables appear to export with a fixed row height that does not show all of the string contained within the cell. I've had similar issues before with "title" textboxes, but these are usually easily solved by expanding the height of the box within the report. In this case, this hasn't worked! Any idea Regards, Jon Hi, I have the same problem. I have one table and the Header Row i ...Show All

• SQL Server RS2005 and SQL2000

  Hi, As per my reading, using RS2005 with backend database as SQL 2000 is possible. Can anyone tell me whether RS2005 connect to SQL 2000 database on same machine. i.e. in short can RS2005 reside with SQL 2000 on same machine Which edition of RS 2005 support backend as SQL2000 TIA, Tanmaya Please read my response in this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=627965&SiteID=1 -- Robert ...Show All

• Visual Studio Express Editions Format as zero if a Textbox is empty

  Hi Everyone, As a beginner I’m not writing a programme as such, just learning how to do various things – currently learning how to enter data into textboxes. I have 3 textboxes formatted to allow numeric data only and a button that when clicked will display the answer in a message box. Question: How do I write the code that says “if no data is entered then the textbox is to be considered a zero” .What I mean is, I press Tab to go to the next box, leaving the box empty, but instead of writing code to enter a zero I just want the empty box to be considered a zero (this is for adding numbers). At present, I have the button click event to assign a value of “0” to box 1 if it’s empty. (I’ve written code for box 2 differently than 1 and 3 for pr ...Show All

• Windows Forms How to use a progress bar ....in forms

  hi...how to use a progress bar...in forms i have used the toolbox and drag it ,,,pasted on form ...now how to implemnet it...thx..plz gave a coded example... hi, please take a look at the documentation for the progressbar http://msdn2.microsoft.com/en-us/library/system.windows.forms.progressbar.aspx ...Show All

• Visual C# Blocking Console closure?

  I have a Windows Forms app with Console playing a part. I now run an almost debugged code from an exec that is generated after the Build command. I need to prevent Console from accidentally being closed by clicking on the tiny button located at the right upper corner. I cannot figure out if it is possible to do. The corresponding button on the form is blocked but it does not prevent the form from being closed by clicking on the button on the Console. I want to immobilize it too. I do not the app being closed accidentally in any event. Thanks. Ernst Kuschke wrote: Why don't you log these messages to a textbox rather Will make your life so much easier. Using textbox is not an option. It won't work--it is not thread ...Show All

• SharePoint Products and Technologies WSS V3 mail alerts

  Hi, I've install WSS and I have a problem with mail alerts, in the Event Log the following errors is displayed... An error occurred while talking to SMTP host u . Any ideas why the SMTP host appears to be corrupted Thanks, Paul. Hi, Another cause may be anti-virus software protection on the server that prevents the use of SMTP on port 25. That's what we just had. HTH, DJ Lordee ...Show All

• Visual Studio Express Editions Window Effects

  Hello. 1 - How I can make my application window to fade when it start's or when is closing... 2 - How to make some parts of the window more opacity than other (ex: bottom: 75% opacity, top - 85%). Thanks...... I tried this before, but the problem is, that the form doesn't redraw itself for each opacity. It merely starts the redrawing (makes the original surface fade in some way). No matter what sleep interval you choose. I doubt the reason will be the speed of my PC or anything similar. I think the approach is wrong. Any other ideas, please ...Show All

• Visual Basic listbox items

  How can program a list box so that when a certain item is inputed the font color changes Rather amazingly, it seems that adding an item (or range of items) to a listbox only triggers the Format event on the Listbox, so you could put some in that event to check whether the new e.ListItem is one that causes a colorchange. But the more amazing thing, is that removing an item(s) from the listbox does not seem to trigger any event at all! I'm telling you that, because it means you'll have add a textcheck yourself after removing an item (as opposed to putting your code in an event's Sub). So you might as well use the same textcheck code after adding Items too, instead of putting it seperately in the Format event. The example below gives you tw ...Show All

• Visual C# Closing a C# App

  Hi, Here is a question that is pretty basic but I have never dealt with this in a C# app. I have something I need to close when the application itself closes. Where/how is the best place to do this Thanks Jeff What I said above still goes, subscribe to one of those two events (FormClosing is recommendation if it is the main form of your app) so that you can do any kind of cleanup you need including closing other forms by calling their Close() method. If this still isn't enough, what is it you need to do when the app is closing down ...Show All

• Visual C++ unresolved external error

  I am having an unresolved external problem. This is my error output: Linking... tryagain.obj : error LNK2019: unresolved external symbol _furnsh_c referenced in function _main C:\Documents and Settings\sharyl\Desktop\cspice\exe\tryagain\Debug\tryagain.exe : fatal error LNK1120: 1 unresolved externals I have the enviroment variables set so that the library that contains furnsh_c is in the lib path, and the include folders, etc are also in the system's enviroment variables. I have also added the lib that has furnsh_c to the additional dependencies. What am I missing Is it possible that I changed another setting that is causing this Thanks! It's a command line utility. You can open a command line prompt with the corre ...Show All

• Visual C++ Question about const_cast

  Here's round two of my silly questions. How come this compiles: ---------------------------------- int main (int argc, char * argv[]) { const int test1 = 5; const int test2 = const_cast<const int &> (test1); return 0; } ---------------------------------- But this does not. ---------------------------------- int main (int argc, char * argv[]) { const int test1 = 5; const int test2 = const_cast<const int> (test1); return 0; } ---------------------------------- Error 1 error C2440: 'const_cast' : cannot convert from 'const int' to 'int' j:\test\main.cpp 4 ---------------------------------- I definitely have the latest version of VC++ Express Edition this time.   einaros wr ...Show All

• SQL Server Failures in installing SP1 on top SQL Server 2005

  I am trying to apply SP1 on top of SQL Server 2005 and it keeps failing. I have a default instance and a named instance on the machine. The named instance disabled when I tried installing the pack. Then I enabled the named instance and tried the pack. This time the default instance failed as usual but the named instance was successful. The log is as follows ( when I attempted when the named instance 'TEST' was disabled ): ANy suggestions / insights Thanks. -chiraj 12/13/2006 12:23:18.661 ================================================================================ 12/13/2006 12:23:18.661 Hotfix package launched 12/13/2006 12:23:20.021 Product discovery successfully completed during the install process for MSSQLSERVER 12/13 ...Show All

• Windows Forms Program Warning problem

  Hey, I found this really cool Example on The Code Project website that was a MS Word/Exel like program, and for the recent documents list thing I have to have this line of code: private static extern bool PathCompactPathEx ( StringBuilder pszOut, string pszPath, int cchMax, int reserved); I highlighted green the part that has the warning...Below is the warning and this warning wont let me run my project until it is fixed...: Warning 1: Method, operator, or accessor 'Notebook_Pro.Form1.PathCompactPathEx(System.Text.StringBuilder, string, int, int)' is marked external and has no attributes on it. Consider adding a DllImport attribute to specify the external implementation. What do I do to fix this T ...Show All

• Windows Forms Is there any way to spin through the objects in a property grid

  Hello all, Is there any kind of an items collection buried inside a PropertyGrid I know there is a SelectedGridItem property, but I need to iterate through them and I have been unsuccessful in finding out a way to do that. Thanks in advance for any ideas and/or suggestions! Better late than never I guess.. Here is one way to do it. if the SelectedObect property is not null then SelectedGridItem property will always be valid , even if the SelectedObject contains no browsable properties. The GridItem object contains Parent, and GridItem s properties. This gives you a path to every GridItem on the PropertyGrid. In the code snippet below are two simple static functions. One for get ...Show All