venkata ramana's Q&A profile

• SQL Server CLR Trigger to write file.......

  Hello, theres, I have a request to write to a file whenever new record added to the table. When records insert row by row, it goes well. but when more than 2 session insert at the same time, sometimes it duplicate some record in the file. I try to add synchonize code ( like lock , Monitor) but it doesn't work. any idea Regards, Agi I assume you are using this to generate an Audit log or something similar. Here is the route I took. http://sqljunkies.com/Article/4CD01686-5178-490C-A90A-5AEEF5E35915.scuk ...Show All

• SQL Server Can't Create New Database on Device via ActiveSync

  In VS2005 RTM using Server Explorer --> Right Click DATA CONNECTIONS --> Add Connection --> Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition--> ActiveSync  Connected Device when I hit Test Connection I hear ActiveSync's connect sound and I get this error Microsoft Development Environment Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding. OK Has anyone experienced this   I can very easily create the database on my desktop, ...Show All

• Visual Studio Express Editions VB Lessons

  How do i download the VB lessons. When i click on the link, it streams to my wmp. The quality is bad, it'd be much better if i were able to download them. Point to Download Lesson..... Right Click.... Click on - Save Target As .... And Away You Go..... Cheers ...Show All

• SQL Server join stored procedure and view

     Hi everybody I have this stored procedure called flydate CREATE PROCEDURE FlyDate AS declare @gencalendar table (cal_date datetime primary key) declare @p_date datetime set @p_date =getdate() while @p_date  > DateAdd(mm, -3, GetDate()) BEGIN insert into @gencalendar(cal_date) VALUES(@p_date) --getdate SET @p_date = DateAdd(d, -1, @p_date) END select cal_date AS KF_DATE,0 AS KF_STATUS  from @gencalendar GO ----which returns all the date for the past three month and this is my view CREATE VIEW dbo.rpt_Kids AS SELECT     TOP 100 PERCENT KF_ID,dbo.just_date_formal(KF_DATE) as KF_DATE,KF_STAT ...Show All

• Windows Forms Server Install Error: The parameter is incorrect. (taskvisionsource_1.1.0.0.msi)

  So I am trying to setup a server of my own and was installin g the server piece has anyone found a fix for the "The parameter is incorrect." message during the installation I am running Windows Server 2003 IIS 6.0 SQL Server 2000 I do have the .NET Framework v1.0.3705 also installed. Is there a way I can install via Source Any help would be gre ...Show All

• Visual C++ Problem with VS6->VS2005

  Hi need help... lots of help... 1] What the hell happened to stprintf function 1.a] How can i convert a char* to TCHAR* 1.b] why in nine hells does VS2005 say sprintf - undeclared identifier when stdio is included I tried looking for some reasonable answers, but god forsake me, i wasn't able to get from either MSDN library or anywhere else something useful... 2] VS2005 for some mysterious reason doesn't know anymore LVITEM, LVM_SETITEM, they are normally in commctrl.h, part of listview control,at least in VS6 it worked, but now... have they deprecated listview or what thx a lot for any help 1) For better confo ...Show All

• Visual C++ Where is the context menu to add class member variables/functions?

  I have installed Visual C++ 2005 Express version. I tried using the class wizard to create a new member variable by opening class view and right clicking on the class, but Add Function and Add Variable are missing from the context menu. Is this something not included in the express version or is there a configuration setting that needs to be set These features are not available in Express, as we package these as MFC-related functionality, which only exists in our other editions. ...Show All

• Visual Basic resource generation

  I have three (VB) projects which share a couple of user controls. One project contains the actual source files whilst the others have a Link to the source. When I run the code, the resource manager fails to locate the resources for the controls when instantiated via the "Link" scenario. Investigation shows that the embedded resources have the root (filename/namespace) of the original project. Am I doing something wrong Has anyone come across this before. anyone come across this before. I don't fully understand your problem. Did you have three VB projects, and you add source code fil ...Show All

• SQL Server Sql server Express 2005 Advanced

  Have been trying to use an 'iif' statement as a simple expression within a computed column. I cannot get the server to accept the statement. Every variation of commas quotes, spaces within the iif statement produces the same result. The statement is very simple : iif(Mileage>0, Mileage*.40, 0). The column is of data type 'money' and mileage is a numeric field (within the same table of course) I'm in the process of adding data tables into a new database, using Management studio express. Could someone please give me a valid example. I have worked with Access Databases for a number of years and am rapidly losing what is left of my ...Show All

• Visual Basic Status bar clock

  How to display the clock in status bar on form1 of my application Heh, that should be easy enough!! First of all, add your status bar strip from the toolbox, and click the newly created bar, so that vb adds the text ToolStripStatusLabel1. Now leave your strip and add a timer to the form from the toolbox. Under the properties for the timer, set "Enabled" to true and "Interval" to 1. Now, under the timer's tick event, add one of the following codes: If you want the time to be shown as hour:minute, use: ToolStripStatusLabel1.Text = DateTime.Now.Hour.ToString + ":" + DateTime.Now.Minute.ToString If you want the time to be sh ...Show All

• SQL Server sql mobile database connection on a desktop application

  Hello, Was wondering if its possible with VS 2005 to create and populate a SQL Server Ce database on the desktop Reason why I'm asking is it takes a very long time (~40 minutes) to process xml and insert the values into the sdf database on the Pocket PC. I would assume it is much quicker to create the database and insert records on the desktop. Any suggestions would be appreciated. Thanks Hi to all in this forum. have been involved in this discussion for over 3 weeks now and here is the perspective from what I now understand. MS does NOT support direct management of  Mobile SQL:data on the desktop EXCEPT for the foll ...Show All

• Windows Forms Is it possible to create a Wizard from Windows Forms?

     I am creating an application in MS Visual Studio C++ .NET 2003 Standard, that gives the user utilities to create, modify, print, and view files of data.     The data acquisition part follows a standard process, similar to filing taxes, you don't start at the end. This data acquisition could have numerous options and depending on the options selected it may provide a different set of questions or objects.    For this application I felt a wizard would be helpfull, but I have not been able to get it to work. So, I used windows form added a panel at the top for the title and description. Then ...Show All

• Windows Forms TaskVision Bugs

  Has anyone tried the "Export to Excel" function in TaskVision, only to find out that TaskVision tries to reinstall Microsoft Office   The attempted reinstallation has now permanently disabled all my MS Office applications;  even Norton AntiVirus wasn't spared. Has anyone else experienced this problem, and is this one of the reasons TaskVision was pulled from the  ...Show All

• Visual Studio Need Help on graphs display in crystal reports

  Application is using crystal reports 8.5 version in ASP to display bar charts. It displays the bar charts fine in windows NT   o.s. The problem is when the application is moved from windows NT to XP machines, the bar charts are not displayed.   Crystal reports is not installed in new machine and dlls   registered are crxf_pdf.dll crxf_rtf.dll Crxlat32.dll u2dapp.dll u2ddisk.dll u2dmapi.dll u2dnotes.dll u2dpost.dll u2dvim.dll u2fcr.dll u2fdif.dll u2fhtml.dll u2fodbc.dll u2frdef.dll u2frec.dll u2frtf.dll u2fsepv.dll u2ftext.dll u2fwks.dll u2fword ...Show All

• Windows Forms Gridview validation problem

  I have a integer column on a gridview of a webform. The problem is that the user can put in a character (like an "A") in the field and when the update button is selected the user gets an ugly message. What is the best way to deal with this problem Well, to start with, convert your boundfields to be TemplateFields. In that way you can give meaningful names to your input boxes like "txtCompanyName" which can be used in the aspRequiredFieldValidator. For example using your bound field <code> <asp:TemplateField > <EditItemTemplate> <asp:TextBox ID=" ...Show All