Barak Cohen's Q&A profile

• SQL Server Tutorial Lesson 2 - SQL Server 2005

  While building the expression for the property: ConnectionString, I am facing an issue. The expression, I am trying to assign is '@[User::varFileName]'. When I clicked on the 'Evaluate Expression' button, the above expression is not returing any value in 'Evaluated Value' window. Please respond we have a solution. I am kind of lost Where are you trying to use that expression HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Basic GotoNearest

  In Delphi it was simple to search a table and goto the nearest record (Line 10). How do you GotoNearest in Visual Studio 2005 Here is the Delphi code that does the job: if (FlightTb.FieldByName('Flight_Field').Text <> '') then begin with FlightTb do begin try Edit; IndexName:= 'FlightDate'; SetKey; FieldByName('Flight_Date').AsString:= DateToStr (DateTimePicker1.Date); 10 GotoNearest; if not GotoKey then {If the Flight date not found.} begin style:= MB_OK + MB_iconquestion; response:= Application.MessageBox ( 'No flight set for selected date. Gone to nearest!' , 'Error' , style); if (response = ...Show All

• SQL Server AS2005. SubSelect vs. WHERE. What can WHERE that Subselect can't?

  Hi AS gurus and fathers, By way of too many problems with WHERE in AS 2005 SP1 with Hofix i have rewritten all my queries for using of subselect. Can anybody give here an example what MDX using WHERE can, that SubSelect (SubCube) can't (exclisive [Measures] dimension under WHERE clausel). If you use subselect extensively, I would highly recommend the recently released SP2 CPT1 which is available to the public. There had been some very significant work done in the area of subselect in SP2. ...Show All

• Visual J# Can J#redist be installed in WinCE?

  and if so, any significant limits thanks - dave Is there any way around this We have some customers who desperately want Windward Reports on WinCE but we must have J# to port it. Or will you have a .NET CF version of J# soon We have a potential customer who wants our reporting solution very very badly but it has to run on WinCE. thanks - dave ...Show All

• Windows Forms Problem using ClickOnce's System.Deployment namespace in debug mode...

  I'm having a tough time getting past ApplicationDeployment.IsNetworkDeployed because it always returns false in debug mode - whether or not the application is deployed via ClickOnce. Because it always returns false in debug mode, the following code snippet does not work: if (ApplicationDeployment.IsNetworkDeployed) {   ApplicationDeployment deploy = ApplicationDeployment.CurrentDeployment;   uri = deploy.ActivationUri; //this is what we want } Does anyone know how to get around this [to get the deployment Activation Uri] in debug mode Why is ApplicationDeployment.IsNetworkDeployed dependent on the configuration mode [i.e., debug versus release] Thanks in advance. D ...Show All

• Visual Studio Express Editions void System::Array::Resize(cli::array<Type,dimension> ^%,int)

  How can I return a cli::array's size on a specific dimension and how do i resize multi dimensionnal arrays To get the size of a specific dimension you use the GetLength(int dimension) method: array < int , 3 > ^t = gcnew array < int , 3 >( 1 , 2 , 3 ); Console::WriteLine(t->GetLength( 2 )); As for resizing a multidimensional array I'm affraid you'll have to do it yourself. There is not support for doing it in the Array class. ...Show All

• Visual Studio Where Can I Find More Help?

  Hi everyone, We’d like to take a second here to tell you how to get more help with your Crystal Reports for Visual Studio projects. For information specific to your bundled version with Visual Studio 2005 visit our Business Objects Visual Studio 2005 Developer Zone . Here you’ll find: Sample Code Projects Walkthroughs Online SDK Documentation What’s New to Crystal Reports for Visual Studio 2005 and Compatibility Information You can also find the Crystal Reports for Visual Studio documentation on MSDN: See http://msdn2.microsoft.com/en-US/library/ms345074(VS.80).aspx under Development Tools and Languages > Visual Studio > Tools and Features > Crystal Reports. ...Show All

• Visual Basic How to Update message on SplashScreen

  Hi, How can I update a label on a splash screen to show load progress. Tried it in the obvious manner but get thread errors, how do/can I communicate with the splash screen so I can inform the user of load progress for an application that may take sometime to load. Gave up, removed the splashscreen. Nothing is controllable on the splashscreen, how long it stays, update displays etc. Found that it stays on long after initialisation of application completed, just gets in the way, looks nice and professional...but. ...Show All

• Windows Forms webbrowser remove frame

  is it posible to remove the 3d borde of the webbrowser i understand that that can be done with an active x or soemthing like thta.. and there is an article about this on codeproject.. but right now their site doesnt work for me.. any help I will recomment another demo for you. In this download there are 101 examples which are provided by microsoft,you can find the webbrowser example easily. I hope this will help you. ...Show All

• Windows Forms Including non referenced dll in ClickOnce deployment

  I'm deploying an applikation using ClickOnce I need to include a dll from another project in the solution. This dll is not directly referenced in the project I'm trying to deploy, but is added as a Project dependency. This dll is not getting bublished alongside the rest of the project files and references. How do I get the ClickOnce deployment to include this dll file -- sparrez Exactly... So, the easiest way is to build the project using Visual Studio, then use MageUI to modify the ClickOnce manifest if you need to. This way, you get the publish.htm and the setup.exe bootstrapper built for you and all hooked up. I did want to clarify something from before... you don't need to add the file as a re ...Show All

• SQL Server SQL Report Help

  I have a program that reads a table with quantities of different products from a SQL Server Database using Ado connection. After the quantities are modificated in the program I need to update them in the database. I was told that to write directly to my table I need to export a report definition with a Ado Connection in it( "Provider=SQLOLEDB;Integrated security=SSPI;Data Source=sqlexpress;Initial Catalog=MyDB;Table=myTable") . I was provided with an example file that has .RPT extention. The problem is that I dont understand how does the .rpt file writes directly to the database. When the exporting is done does the report file automatically connects to the database Eventually I was ...Show All

• .NET Development -Using Sproc to insert rows in the DB and the Sproc returns identity columns to my dataset

  If we use sqdataadapter to insert data from a datatable into a table in the database using an SPROC. The Sproc also returns the identity column values that are created by the database. If those identity columns are called “IDcolumn” in the physical DB but in my dataset I call them “MyIdentity”. So IDcolumn is an output of my SProc I use : Pm.Direction= ParameterDirection.Output Then I use pm.SourceColumn property : Should I use IDcolumn” or “MyIdentity” Like this: Pm.sourcecolumn=”IDcolumn” or like this: Pm.sourcecolumn=” MyIdentity” Thank you Thanks! I think i didnt quite understand the question, but yes of course, it would map to the datatable/dataset column name/source   ...Show All

• Visual Studio Express Editions open new outlook email window in program

  Can anyone point me in the right direction on how to click a button and open and MSOutlook new email window. I would also like to program to add an attachment as well. Thanks do you have any idea about my "attach contents of webbrowser issue" from two post ago. Also I am not having any luck with theStringBuilder.Append("&attach=C:\myfile.ext") everything works ok just no attachment. I even tried email to myself to see if it was there just not showing up. No luck ...Show All

• Visual J# help im a first time user

  i feel really stupid in asking but im getting real frustrated... how do i compile my code do i need a seprate program or is it in the options can you tell me how goto microsoft web site and download the express version of Visual J#.NET 2005 and start developing with J#. Enjoy it!!! ...Show All

• Visual FoxPro Speed issue

  Hi I have an open table in VFP. I am using vb.Net to get the records from the table. I use the following connection string to connect to the open table. Provider=vfpoledb.1; Data Source=\\Commercial\Data; Provider=Microsoft.Jet.OLEDB.4.0; Data Source= \\Commercial\Data;Extended Properties=dBASE IV;" The open table has more than 3,604,393 records in it. When I give the following sql statement Sql = “select * from ordDet where 1=1 and comp_code = ‘01’ and Itemcode =’02’” cmd = New OleDb.OleDbCommand(Sql, gconnMDB_I) Dim rdDept As OleDb.OleDbDataReader = cmd.ExecuteReader() Do While rdDept.Read() dr = dt.NewRow() dr(0) = rd ...Show All