JFTxJ's Q&A profile

• Visual Basic Save\Load values as text file

  Hello In VB6, I was able to save and load values as text file, it saves them like this form: "V1","V2","V3" I was using this code: Dim A As String, B As String, Op Op = FreeFile A = "Value1": B = "Value2" Open "D:\File.txt" For Output As Op Write #Op, A, B Close Op How can I do it in VB2005 Thanks & Regards The following code ...Show All

• Visual Studio Crystal problem

  Hi hopefully someone will be kind enough to help. I am using a crystal report viewer to display my crystal reports.  I initially run a store proc to populate a table which I need to become the source of the report I wish to display.  However, when the report is displayed, it always shows the data from the table that the report was based upon when designed and not the new data table.  I have tried both the below methods to change t ...Show All

• Visual C# Error on a 'Add' in a Pivotcache in Excel

  I make an Pivotcache in C# and later want to connect an Access-database to this pivotcache, but i get an error on the 'Add'. The 'old' code in VB looks like this (and did work): With WbkXL_Workbook.PivotCaches.Add(SourceType:=Excel.XlPivotTableSourceType.xlExternal) .Connection = strConnection .CommandType = Excel.XlCmdType.xlCmdSql .CommandText = strCommand .CreatePivotTable(TableDestination:=WstXL_Worksheet_Bst.Range( &quo ...Show All

• SQL Server Add services to SSIS IServiceProvider model?

  Is there any mechanism for being able to add custom services into the SSIS service provider model so that they can be used by components at design and runtime i.e. if I can currently access service implementations such as the IDtsConnectionService from the Initialize method of a custom component (or in a UI type editor), is there a way to add a service of my own Thanks Thankyou for the response - actually d ...Show All

• Windows Forms bold groupbox text

  Hi, bold groupbox labels look awful. It seems the space needed for the text is calculated for the non-bold text and the bold text is squeezed into this too small space. Yes, I too am facing the same problem in my UI Control.& ...Show All

• Visual Studio Team System Do not indirectly expose methods with link demands

  the following code generates the warning "Do not indirectly expose methods with link demands" indicating that charkey = (int)m.WParam is the problem. It is a method in a control which is derived from TextBox. I have tried adding a try block and catching SecurityException and adding an assembly reference for the EnvironmentPermissionAttribute but I still get the error. Having read FxCops suggestion for fixing the problem I am still not entir ...Show All

• SQL Server SQLExpress database using SQL2000 driver?

  I recently converted my MSDE databases to SQLExpress and it seems to work fine. I noticed in my ODBC Administrator that the database names appear in the System DNS. The driver says "SQL Server" which in the drivers tab appears to be the driver for SQL2000. Am I running an instance of SQLExpress using SQL2000 drivers Will this cause a problem Should I try to set up new data sources (same database names), using SQL2005 drivers ...Show All

• Visual C# CopyFileEx and invalid parameter error

  Hi, I'm trying to use the CopyFileEx() method, and I occassionally get a failure. When I use GetLastError, it returns "87", which unless I've looked up in the wrong place, means "Invalid Parameter". I'm having no luck determining what this error actually means in this situation. Can anyone help I have been copying the same set of files over and over in testing, and this error recently cropped up. Most of the time, the e ...Show All

• SQL Server SQL Server Date/Time & other data typesV

  Hi I'm have big problems trying to save Unicode information into my MS SQL Server 2000 Desktop Engine. Alright, so the problem I'm having now is I'm working with MS SQL 7.0 and PHP5. I've trying to get information to save into MS SQL, however it is storing it all weird. When I save the information and try to view it in Enterprise Manager it shows it has random characters but for some weird reason I can output that information on the page ...Show All

• .NET Development problem with the ASP.NET application

  Hi, I have the following problem I created the ASP.NET application via vb.net Visual Studio 2003    IIS: 5.1  Framework 1.1.4322 on my local pc it's works perfect. On the Server computer my application does not work it does not run the .ASPX pages (even simple .aspx page) I get the Server Error in '/' Application. message (and not the real error message) ---------------------------------------------------------------------- ...Show All

• .NET Development Error adding to GAC

  Hi, Only over the last few days I have started getting an error adding a dll to the GAC. Failure adding assembly to the cache: Access denied. You might not have administrative credentials to perform this task. Contact your system administrator for assistance. I have admin access to the box. When I get this error, if I open explorer and navigate to the WINDOWS\assembly folder no files are listed. If I log out and back in the error goe ...Show All

• Visual C# Passing Arguments to new form

  How can I do the same below, in C#: I am looking at some vb code that declares a new form with a variable like this Dim pastForm As New frmForm2( Me .Name) pastForm.Show() Then in the frmForm2 form it has 2 functions, one that takes an argument and one that does not, each executing separate code when executed. Public Sub New ( ByVal f As String ) { } Public Sub New() { ...Show All

• Visual Studio Express Editions Help to translate these simple dll calls from c++6 to vb.net?

  void DecryptFrontCode(const BYTE *pSrc, BYTE *pDst); void CreateCryptKeyID(const WORD wID, BYTE *pBlock); const WORD GetCryptKeyID(const BYTE *pBlock); const WORD GetCryptKey(const BYTE *pBlock, DWORD *pUpKey, DWORD *pDwKey); const DWORD DecryptMXTCP(BYTE *pBuf, const int iLen, const DWORD dwKey); const DWORD EncryptMXTCP(BYTE *pBuf, const int iLen, const DWORD dwKey); void DecryptMXUDP(BYTE *pBuf, const int iLen); const BOOL GetFileHash(LPCTSTR ...Show All

• SQL Server Query Paging

  let's suppose that we have a table entitled "tab1" which has more than 1000 rows and about 10 columns so in SQL 2000, if I do this query: SELECT * FROM tab1 the result will be displaying all the rows from the begining. and my teacher told me that there's a new option in SQL 2005 which is you can display the result of the query in a page mode. so can anyone tell me how can I do so for this query: SELECT * FROM tab1 ...Show All

• Visual Basic Can I open a form when all I have is the name as a string?

  My project has a number of forms.  I would like to provide a procedure that would open one of the forms -- the form name would be passed as a string to the procedure.  The requested form is probably not already open. In other MS products, I would do this by iterating over a FormsCollection searching for a matching name.  No FormsCollection here.  I found another example that would build a collection of open forms, but my req ...Show All