Ramanujam Sampath's Q&A profile

• SQL Server my script not working when the name of a DB has - (the dash character)

  Hi, this script uses MSforEachDB to check all the SPs in all the databases and look for a keyword LockCookie . The script runs well except when there is a database with a dash - in ots name. ie: When in the script is replaced by a database whose name contains a dash - the dash and the rest of the database name after the dash is ignored. And I get the message for example: Could not locate entry in sysdatabases for database 'SharePoint_AdminContent_f5c0f71f'. No entry found with that name. Make sure that the name is entered correctly. Here is the script: exec sp_MSforeachDB ' use select ''LockCookie'' as searchedTxt, o.name AS ProcName ,Len(SubString(object_definition(o.object_id),1, PatIndex(''%LockCookie%'', object_definitio ...Show All

• Windows Forms Error installing Winforms 2.0 application with ClickOnce deployment

  Hi. I have an Winforms 2.0 application that I want to deploy using ClickOnce deployment. I have tried it and the deployment seems to work. I get the webpage where I can install the application from, but when I try installing the application I get an Windows error dialog and a '.NET Runtime 2.0 Error Reporting' entry in my Windows eventlog. Detailed error message: EventType clr20r3, P1 app.exe, P2 1.0.2211.28810, P3 43d0fb04, P4 mscorlib, P5 2.0.0.0, P6 4333ab80, P7 32f8, P8 d8, P9 system.io.filenotfoundexception, P10 NIL. I publish the project to a server within the network I'm on, and the error occurs when I try to install from the generated ClickOnce website from my laptop. Does anyone know what could cause this error I wish it ...Show All

• Visual Studio Express Editions Custom coloured scroll bars?

  My program so far is looking good except I got these nasty looking blue scroll bars, which don't fit in with the look of my program. Is there a way to change the color of these scroll bars You could draw your own. This is just a starter. You will have to do most of the work yourself.... Dim ProgValue As Integer Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click ProgValue += 15 End Sub Private Sub Form1_Paint( ByVal sender As Object , ByVal e As System.Windows.Forms.PaintEventArgs) Handles Me .Paint Dim myPen As New Pen(Color.CornflowerBlue) myPen.Width = 2 Me .CreateGraph ...Show All

• Smart Device Development HTTPS problem on Palm Treo 700w

  Hi, I've been having problems POSTing to an SSL server on the above device using .Net 1.0. I've seen the other posts on ensuring the latest Service pack is installed and it is for this device. When writing to the output stream I seem to be getting a 100036 i.e. ' WSAEINPROGRESS ', usually the first request goes through OK but subsequent requests fail with this error. Using plain http, everything works fine. Sometimes when debugging on the device if I break before the write then continue it seems to work. I've cut the code into a test app to check things out and included it below (data has been truncated). Any thoughts would be appreciated, Thanks Graeme try { Uri ourUri = new Uri("https://myserver/response.asp" ...Show All

• Visual Studio Express Editions SQL Server error, Build a Program Now, less 8

  When I try to add a SQL Server database object from the templates ( to windows application) a connection to the SQL Server cannot be established. Message says this may be due to the fact that under the default settings the SQL Server does not allow remote connections. The function mysteriously worked once but it won't work again. How do I correct the default settings (provider: SQL Network Interfaces error:26 - Error Locating Server/Instance Specified) VB Express IDE does not support connections to databases other than SQL Express and Access. SQL Express does not support remote connections and is intended for local database purposes only. As this is in the VB Express forums, I would assume you a ...Show All

• Windows Forms Where is the C# Login form template in VS 2005

  I noticed that for VB Projects in VS 2005 there is a Login form template. I can't find this template when I create a C# project. Is this an oversight or how can I add it to the list of templates. Thanks I can't find this example application either.  Would someone happen to have a link handy   Thanks!   ...Show All

• Visual Studio Team System How can you specify the workspace in TF Checkin

  Hi, I posted a similar thread about this. But now that i have done more experimenting, i know exactly what to ask: I try to do a simple recursive check in using tf.exe. However, it keeps telling me that i was unable to determine the workspace. Well, no worries, i'll just specify the workspace using the ./workspace parameter like in the checkout command but NO, the parameter does'nt seem to exist for checkin... The funny thing is, the command works if i do not specify the /recursive parameter... For example: This work: tf checkin /noprompt /override:"Overriden from MSBUILD" "C:\myfiles\*" But not this: tf checkin /noprompt /recursive /override:"Overriden from MSBUILD" "C:\myfiles\*& ...Show All

• Visual C++ Can not compile MessageBox

  I am trying to compile a program containing a call to MessageBox in Visual Studio. I recieve the following message when I compile Error 19 error LNK2028: unresolved token (0A00002B) "extern "C" int __stdcall MessageBoxW(struct HWND__ *,wchar_t const *,wchar_t const *,unsigned int)" ( MessageBoxW@@$$J216YGHPAUHWND__@@PB_W1I@Z ) referenced in function "int __clrcall type_message(char *)" ( type_message@@$$FYMHPAD@Z ) little_functions.obj I have added the following with no luck #ifdef UNICODE #define MessageBox MessageBoxW #else #define MessageBox MessageBoxA #endif // !UNICODE Is there another setting that I need Thanks Mike, Thanks. ...Show All

• .NET Development IO.Ports.SerialPort DataReceived EventType=Eof

  I never get an "Eof" EventType fom the SerialDataReceivedEventArgs. When the DataReceived event is raised the EventType is allways "Chars". I played around with the SerialPort.NewLine property but no success. Any ideas why Thanks, Eduardo It was technically possible to get an Eof event in the old days. The DCB structure, used to initialize the serial port, contains an EofChar member that allows one to define a special end-of-file character. Modern Windows operating systems no longer support non-binary transfers so the Eof event will never be raised. Accordingly, the SerialPort class doesn't have a EofChar member, the DCB member always gets initialized to 0x1A (Ctrl+Z). Why MSFT still defines Seria ...Show All

• Windows Forms SaveFileDialog how to use?

  I have a richtextbox1 on a child form inwhich I write a small bit of text in. I then want to save the text from this richtextbox into a .txt file. I have got the saveDialog menu at the bottom of my screen But I am unsure how to correctly make this all work. I know there should be some dialog.filter and index for txt files code somewhere but I dont know where. The code i have done so far is :- private void saveToolStripMenuItem_Click( object sender, EventArgs e) { DialogResult dr = saveFileDialog1.ShowDialog(); if (dr != DialogResult .OK) return ; else { StreamWriter sw = new StreamWriter ( "filename" ); sw.Write( ); //What should I put in the Write function } } Also is ope ...Show All

• Visual Studio Express Editions iTunes kind of Search in C#? (Dynamic Search Result on input)

  For all those who have used iTunes might get an idea what I am talking about, But just for the info, iTunes has three dynamic search display fields Namely Genere Artist and Album...Think of it as a List Box. And it has a Seach Option on the top which is a Textbox The really neat thing is "As you type in your search criteria ,the files are searched and displayed" Now I know this is possible in ATLAS (i.e ajax)..but I want to implement the same in a Form. Can anyone give me a idea how to go about this problem Thanks for your reply! Try something like this: private string[] mSelections = { "one", "two", "three", "four", "five" }; private bool ...Show All

• SQL Server Simple query chooses clustered index scan instead of clustered index seek

  the query: SELECT a . AssetGuid , a . Name , a . LocationGuid FROM Asset a WHERE a . AssociationGuid IN ( SELECT ada . DataAssociationGuid FROM AssociationDataAssociation ada WHERE ada . AssociationGuid = '568B40AD-5133-4237-9F3C-F8EA9D472662' ) takes 30-60 seconds to run on my machine, due to a clustered index scan on our an index on asset [about half a million rows].  For this particular association less than 50 rows are returned.  expanding the inner select into a list of guids the query runs instantly: SELECT a . AssetGuid , a . Name , a . LocationGuid FROM Asset a WHERE a . AssociationGuid IN ( '0F9C1654-9FAC-45FC-9997-5EBDAD21A4B4' , '52C616C0-C4C5-45F4-B691-7FA83462CA3 ...Show All

• SQL Server How to group by time that spans two dates! Help!!!

  Lets see if some of you RS Gurus can help me on this. I have a start_time column that returns the date and time. I have converted these out to return the date for one column and the time (24 hours) in another column. I have a report that I need to group by a 24 hour period that starts at 20:00(8pm) and should end again 24 hours later (20:00) 8pm. This should be my time period for each day. The problem is that when I group for each day it is returning the results for the day on a default 00:00 to 00:00 time period. I need to group for each day but I need that days time to be from 8pm to the following 8 pm. So for my polling results I am getting some stores that look like they posted twice for one day instead of once so my count is ...Show All

• Software Development for Windows Vista conime.exe procedure issue in console application

  Hi all, I am using a non-western language Vista, when I start my console application, the extra procedure conime.exe (as I know, it's shared to use for all console application) is launched automatically. But when my console application exits, the procedure conime.exe still has some relationship with my console application, I can't remove my console application folder (my console application is installed, I launch it, exit it, and remove all files and folder of my console application). But after terminating the conime.exe procedure, I can remove my console application folder. On Win2l/XP, I can remove the folder after exit my console application, without terminating the conime.exe procedure. Since conime.exe is used for all console ...Show All

• Smart Device Development Best Platform for my Application

  Hi, I've developed an application for a PPC running Windows Mobile 2003 in Java (a J2ME MIDlet). As I came to find out, this isn't really for me, mainly because I want to run the application in the background or even better, a windows service. I've now seen the light and am developing the same application in VS2005. Before I move forward, I wanted to see which platform I should choose so I have the least issues in the future. I would like it to be able to run in the background and unnoticeable. It needs to read the Virtual COM port, access GPRS to do requests on the net, use a timer, and listen to key events. Support for Windows Mobile 2003 and Windows Mobile 5 (and any future WM versions) is essential. It would be desirable if it ...Show All