Gagandeep Singh's Q&A profile
.NET Development Syntax Error
I am trying to insert into a table that has an Autonumber ID field. The following is the code that I use to create the SQL statement followed by the ExecuteQuery command. Of course the Autonumber field is not listed in the SQL statement At the bottom I have copied the actual string value for strSQL_Write from the debugger. All of the field names are right. I recieve a Syntax Error in the INSERT INTO command at runtime. Any ideas strSQL_Write = "INSERT INTO tblOptionPrices (OptionID, Date, TradeDate, BestBid, BestOffer, LastTradeDate, LastTrade, Volume, OI, ImpliedVol, Delta, Gamma, VegaKappa, Theta, AdjustmentFactor) VALUES (" _ & intOptionID & ", " _ & strDate & ", " _ &am ...Show All
.NET Development XML and C#
I am looking for a way to authenticate a user for a program, it has been suggested that I use XML credentials to do this, but honestly I do not have the first clue about useing XML for anything. I have been unable to find any resources on the subject, does anyone know of any or could someone point me in the right direction to do this. All the help I have found has something or another with ADO.NET or web forms which I have no interest in my app is a standalone application doing standalone tasks nothing to do with web programming. Thanks Thomas An important thing to understand about both Mahesh's and Yisanda's suggestions is that there's a fundamental problem with having your program encrypt and decrypt pa ...Show All
Visual C++ A compiing error about template
Dear Expert: I use visual studio 2005 to compile NeuroLib ( http://www.ia.unc.edu/dev/ ), and there are a lot of error like the following: ---------- e:\unc_proj\lib\neurolib\libraries\datatypes\Vector2D.txx(33) : error C2244: 'Vector2D<T>::{ctor}' : unable to match function definition to an existing declaration 3> definition 3> 'Vector2D<T>::Vector2D(const Vector2D<U> &)' 3> existing declarations 3> 'Vector2D<T>::Vector2D(const Vector2D<U> &)' 3> 'Vector2D<T>::Vector2D(const T &,const T &)' 3> 'Vector2D<T>::Vector2D(void) ------------------------------------- this is implementation of the .txx function: inline Vector2D<T ...Show All
Visual C# Controls Transparency
My purpose is to display rotated text or image on the running movie. For that I have used windows media player control in .net. I add the AxWindowsMediaPlayer (Windows Media player Control) on my form and set dock properties to fill. And put the Label and set the BackColor to Transparent. But instead of displaying the movie as background its displays the BackColor of the form. I want the background movie run in background and display the rotated text amd image on that without background color of the text and image. Thanks in advance. Hi Nayan. I believe there is no easy way to do this. I had to do a similar aplicatio ...Show All
Internet Explorer Development IE 7 opening to Run Once page with error on it.
I downloaded updates last week. I have been using IE7 for a while with no problem. I dwnloaded the updates. Now when I open my browser the page tries to go to http://runonce.msn.com/runonce2.aspx . There is an error reported for this page and it will not open up I get a blue screen. How do I eliminate this I have my home page set in the tools section but when opening it won't go to my home page until I hit the home button on the tool bar. The error appears to be a web page error I copied what was displayed for the error Line 56 Char:2 Error 'windows.external' is null or notan object Code O URL:http://runonce.msn.com/runonce2aspx ...Show All
Visual C# C# Interop causing memory leak
I'm having a very strange issue with an inter-op between my C# application and an unmanaged DLL written in C++. The problem is that I have a memory leak on the C# application. I'm mostly a C++ programmer so I'm having great difficulty debugging it. Commenting out all calls to my unmanaged DLL will remove the memory leak error however, so I'm sure it has something to do with the inter-op. I tried to create a separate unmanaged C++ application that loads the exact same DLL, and to my surprise the new unmanaged C++ application does NOT have a memory leak. I repeat, this is verified to be using the exact same DLL. So my real dilemma is that I have a memory leak in C# that I can't reproduce in C++. I know, funny isn't it There are a few techni ...Show All
Visual Studio Express Editions Displaying numbers in a label box.
I'm trying to create a dice rolling program for 6 sided dice. It has a textbox, a button, and a label. what I would like to do with it is put a number in the textbox, click the button, and have the label display that many results. For example, I put 3 into the text box. The program runs the randomizer and comes up with 3, 1, & 6. I would like the label to display 3, 1, 6. Here is my code. Using it, I get one number displaying in my label, but I'm not too sure how to get the others to show. Can anyone help please Public Class Form1 Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load ' Initialize the random-number generator. Randomize() End S ...Show All
.NET Development SqlDataReader throws NullReferenceException
Is this a bug in the .NET 2.0 framework Error Message: Object reference not set to an instance of an object. Stack Trace: at System.Data.SqlClient.SqlDataReader.Bind(TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) a ...Show All
Visual Studio Install VS2005 after SQL 2005: Report Designer package fails to load
I installed SQL2005 with Reporting Services and Analysis Services. It installed a stub version of VS2005 for the Report Designer the the BI Designer. Now, after installing Visual Studio Pro, the Report Designers and other designers installed by SQL2005 will not load into VS2005. VS2005 was not listed in the Add/Remove programs after installing SQL2005, so I did not uninstall anything prior to installing VS2005 Pro. How can I fix this Is there a way to "reregister" these packages so they will load, or do I have to reinstall everything in some particular sequence I'm not at that site today, so I can't reproduce the exact package names and GUIDs from the messages, but the error messages were of this form: ...Show All
SQL Server Change filename for flat file connection manager at runtime
I need to add the current date to the end of the filename of a flat file at runtime. This was previously done with ActiveX script in SQL Server 2000. oConn = DTSGlobalVariables.Parent.Connections("FlatFileConnectionManagerName") oConn.DataSource = sNewFileName oConn = Nothing I would really appreciate if someone could give me some information on how to achieve this in SQL Server 2005. Thanks in advance! Regards, Sara Basically, use property expressions: http://blogs.conchango.com/jamiethomson/archive/2006/06/28/4156.aspx -Jamie ...Show All
Visual FoxPro buffering, Rlock() and FLOCK()
Hi; I think I don't understand the concept of buffering. Can someone explain the following behavior I have a form which uses opt. table buffering. While that form is open by a user, I manually rlock() one of the records. Then, I ask the user to change the same record. The change, including the =tableupdate() goes through fine. I try the same with FLOCK(), and the change still goes through fine. Shouldn't FLOCK prevent the user from comiting a change thanks. Why It's the same user (session) doing rlock()/flock() and tableupdate(), no If I didin't understand it wrong, tableupdate() needs a lock during write and you already have it. ...Show All
Visual Studio 2008 (Pre-release) IsDisposed equivalent on WPF
I need to know if a form has been closed so that its instance is no more usable, does WPF has a sort of IsDisposed property counterpart Thanks Corrado This means that there's no built-in IsDisposed counterpart What I'd like to know is if a variabile pointing to a Window instance indeed refers to a Window that has been closed. Actually I'm setting a flag inside Window OnClosed override, but just curious to know if a built-in mechanism exists on WPF, from your answer answer seems to be: No. ...Show All
Visual Studio Express Editions How can i read the information stored in a .xls file??
Hi, i'm trying to develop a program for reading the information stored in a .xls file using Visual C++ 2005 Express Edition. I'm new using c++, so i've been searching some help in google and i've found existing codes. I have written my own code from these ones, but, when i build the solution, the compiler shows an error because the file sqltypes.h does not exist. I've searched the file on internet and i have copied it in the folder "include" of Visual Studio, but building the solution again a new error message appears indicating more than 150 errors (all located in the file sqltypes.h). I've tried with several sqltypes.h, but the compiler always shows the errors. The code that i've developed is the following: // excel.cpp : Defin ...Show All
Visual Studio trouble installing the Web Service Software Factory
Every time I run the Web Service Software Factory - July 2006.msi it stops at the Status: Registring ASMX Guidance Package: install with the following error The project factory Web is not registered, template C:\Program Files\Microsoft Service Factory\Guidance Packages\bin\templates\solutions\projects\ASMXHost\Host.vstemplate cannot be installed Upon clicking ok it rollsback the entire setup. I looked into the path specified and did not find anything unusual. any help wpuld be great! Thanks, Jyoti Hi, You can find the Service Factory community site here . Hope to see you there :-) Edward ...Show All
.NET Development XmlSerializer exception when consuming response of RPC encoded Java WS in .NET 2.0
I want to consume a SOAP RPC encoded webservice based on Java (FastBugTrack.wsdl) from a .NET 2.0 WS client. The WSDL looks like this: < xml version = " 1.0 " > < definitions name = " FastBugTrack " targetNamespace = " http://fastbugtrack.pace.de:6665/FastBugTrack.wsdl " xmlns:tns = " http://fastbugtrack.pace.de:6665/FastBugTrack.wsdl " xmlns:soap = " http://schemas.xmlsoap.org/wsdl/soap/ " xmlns:soapenc = " http://schemas.xmlsoap.org/soap/encoding/ " xmlns:wsdl = " http://schemas.xmlsoap.org/wsdl/ " xmlns:xsd = " http://www.w3.org/2001/XMLSchema " xmlns = " http://schemas.xmlsoap.org/wsdl/ " > ...Show All