Bijan Javidi's Q&A profile

• .NET Development ADO/SQLExpress Connection String Question

  I'm working on a customer project and deployment project. SQLExpress is part of the installation and there is a pre-existing database. As installed, the database is detached. This application uses ADO.NET to establish SQL connections and it also uses Excel VBA to connect to the database via ADO. The following SQL Connection string works for SQL (as far as I can tell) Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\XYZ_Data.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True What is the appropriate ADO (not ado.net) connection string The one that has worked when the database is attached looks like ...Show All

• Visual Studio Disappointed by the limited functionality

  I doubt this is the right place to complain, but I want others to know when they have the same question. The report controls are nice but are a big disappointment.  When using local reports they don't provide parameter prompting and they don't grab the data from the datasource for me like the Sql Server Reporting Services reports do.  This means I have to work with and develop two seperate reporting mechanisms.  I was hoping to use the same reports for both the Reporting Services and the Reporting Control based on the database the client uses (some clients will travel with MSDE and want access to all of their reports on the r ...Show All

• Windows Forms Clickonce: Publish

  Hi, Clickonce deployment works fine for Server to Client updates (Checking updates on client) ...I would like to know what if I want to release the new product updates to server's where clickonce files are published Do I have to go for product like Installshield updater service or can Clickonce handle this Any Ideas Regards YT If you want to update the product, create a new deployment with a new version number. The new deployment will be using the same URL so that the client can detect updates from the server. Deployment provider in the deployment manifest is where ClickOnce checks the updates from. If you want ClickOnce ...Show All

• .NET Development Delayed send with smtpclient in .net 2.0

  Is there any way to force the smtpclient to send mail immediately with the .send method in system.net.mail 2.0 Right now it takes anywhere from 90 secods to two minutes before the mail is actually sent once the .send method executes. I've tried setting the object to nothing immediately after the .send method call, but no luck. The real issue for me is the send delay is also causing the smtpclient  to hold a lock on attached files that are being sent for that same 90 seconds to two minutes. I need to move the file immediately after emailing it, and right I get an exception telling me two processes can't access the file at the same time ...Show All

• .NET Development Accessing an Access database on a network share.

  Hello, I am having a problems connecting to an Access database hosed on a network share and I am running out of ideas and time. I have referenced several threads in this forum as well as other sources with little success. I have attempted to add the user id and password to the connection string as in post, <http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=95215&SiteID=1 >, which failed. I have tried both the user id and password you see below as well as my own user id and passwork which has "Admin" privileges on both the server hosting the website and the server hosting the network share. Connection Strin ...Show All

• Windows Forms Crystal reports : Database login dialog - how to awoid it?

  I'm using Crystal reports as a part of Microsoft Visual studio .net 2002. I'm using field definition file (ttx) and a datatable as a datasource for report. (In VB .net code, Datatable is filled with data and then is set to be datasource for the report). Program works fine on the development PC. But when I try to show report on some other  ...Show All

• Windows Forms Multiple [Modifiers] property is added to each component in design time when rebuilding projects…

  Removed from the forum... ...Show All

• .NET Development How distribute Configuration Manager?

  Hi all, I need to distribute .Net framework 2.0 configuration manager. This tool is not included in redistributable file but only in sdk. Is it posible to distribute only Net framework 2.0 Configuration mmc   Thanks. Official MS comment found here: http://msdn2.microsoft.com/en-us/library/2bc0cxhc.aspx If anyone's bored enough to figure out which CLSID's etc to register, i'd love to know two. ...Show All

• .NET Development Moved DB to Server - do I have to recompile and change all of the dataSet Names??

  Using C#, Windows Forms app, VS Pro 2005 edition: I moved my app's backend SQL Server Express database to the main server. The dataset/tableadapter/binding names that were automatically generated using my local PC SQL Server data source are now not the same as the server datasource. For example, my old dataset name is "myDataSet", and the new one is myNewDataSet". Ditto tableadapters. (OK, they aren't actually named "my...", but you get the idea). The database structure, etc is identical. The new server-based datasource was generated in Visual Studio OK, and all the tables, views, etc work fine. Is there ...Show All

• .NET Development Assembly strong binding

  Hi, I have strange problem: I try to build .NET application which use Microsoft.DirectX assembly, but i have installed more than 1 version DirectX SDK on my PC and now i have such problem: //=========================================================== Error 1 The type 'Microsoft.DirectX.Direct3D.Device' exists in both 'c:\WINDOWS\Microsoft.NET\DirectX for Managed Code\2.0.0.0_x86\Microsoft.DirectX.dll' and 'c:\WINDOWS\Microsoft.NET\DirectX for Managed Code\1.0.2902.0\Microsoft.DirectX.Direct3D.dll' C:\Documents and Settings\LLIAMAH\My Documents\Visual Studio 2005\Projects\DirectX 1\DirectX 1\FMain.cs 16 38 DirectX 1 //========= ...Show All

• Visual Studio How to retrieve the EnvDTE.Project from a VCProject?

  Hi,   When using C++ projects extensibility, given a VCProject, how can I get the EnvDTE.Project . The VCProject.Project property seems to return itself, so it does not work. The docs seems to confirm it:   http://msdn2.microsoft.com/en-us/library/microsoft.visualstudio.vcprojectengine.vcproject.project.aspx   In VB.NET / C# projects, VSLangProj.VSProject.Project does what I mean, but I want to do it for C++.   Thanks in advance,   Carlos Quintero Hello Mr. Quintero, I ran this issue by our VC++ dev team and they replied with the following: "You cannot do this because t ...Show All

• Windows Forms DataGridView not showing values for first added row

  I have a DataGridView bound to a custom collection that implementes IBindingList.  Everything works great except for the very first time that I add a new item.  When I first add a new item to the underlying collection, a new row in the DataGridView appears with all of the proper columns, but the values are blank. I know the values are there because I've implemented an "Edit" button which opens up a customized form for the item in the collection.  The DataGridView appears to be getting notified that a row has been added; I just can't see the values!  I can even raise a ListChangedType.Reset event in the cust ...Show All

• Microsoft ISV Community Center Forums Open an excel file

  Hope you will help a beginner .. Here's what I want to do:  In a VBA subroutine, try to open an excel file with a particular name say, P01GAB.xls.  It may not be in the diretory, if not, wait for 10 seconds and try again.  If so, open it and go on to the next thing.  (Eventually, it will be in the directory...)  So, I take it, I need some sort of error trap on the Workbooks.Open command... Thanks much.   Hi A "nicer" solution is to Reference the Microsoft Scripting Runtime and then Dim fso as FileSystemObject Set fso = New FileSystemObject If fso.FileExists(strFileSpec) Th ...Show All

• SQL Server varchar (max) - is this correct

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/282cd982-f4fb-4b22-b2df-9e8478f13f6a.htm varchar [ ( n | max ) ] Variable-length, non-Unicode character data. n can be a value from 1 through 8,000. max indicates that the maximum storage size is 2^31-1 bytes. The storage size is the actual length of data entered + 2 bytes . The data entered can be 0 characters in length. The SQL-2003 synonyms for varchar are char   varying or character   varying . ---- How can this be How can SQL store the data-length (a 32-bit number) in 2 bytes (a 16-bit space) Sure it is right Use varchar(max) when the sizes of the column data entr ...Show All

• Visual FoxPro Fonts, Fonts and more Fonts.

  Hi everyone, I have posted this quetion before, but I still don't have a reaonable solution. I have a whole bunch of reports which are created in FOXBASE. These are generated using simple commands. Initially we want to run them as they are. The problem is that no matter what font I try, it is not identical to the older 'text' font. Since we are printing on forms, we need the font to be identical. Is there no way to print something in VFP so it comes out exactly as it did in FP2.6 Dos I tried variations of Foxfont, Fixsys, serif, courier etc. The closest is Foxfont but I can only use it at 10pitch (Too small) or 16 (too big ...Show All