Saad Kanawati's Q&A profile

• Visual Studio Team System Schema Compare Problem #2

  I have noticed that when I compare a Database to a Project, and as a result of the compare, objects need to be deleted out of the Project, the objects are never deleted. I can run the compare process over and over again, the same objects show up to be deleted, I will click on Write Updates button to update my project (which should delete the objects), but the objects are never removed. Is this a known issue Or am I doing something wrong Amos. At 5 to 10 minutes per delete I would yell loud and clear too! Wow. I hope someone can come up with an explanation for that much delay. Could it help to check out the item before deleting instead of letting DB Pro take care of that Alle ...Show All

• .NET Development C# 2.0 Dynamic Members

  My Code: using System; ... using Microsoft.Practices.EnterpriseLibrary.Data; using System.Data.Common; namespace DataAccessLayer { public class EmailQueue { private Database db = DatabaseFactory.CreateDatabase(); private DbParameterCollection dynParams; private DbCommand Command; public EmailQueue() { Command = db.GetStoredProcCommand("DAL_EmailQueue_AddMessage"); db.DiscoverParameters(Command); dynParams = Command.Parameters; } public DbParameterCollection AddMessageParameters { get{return dynParams;} } public int AddMessage() { int RecordsAdded = db.ExecuteNonQuery(Command); foreach (DbParameter param in Command.Parameters) { param.Value = null; } return RecordsAdded; } } Currently my code works just fine like this: EmailQu ...Show All

• Visual Studio Crystal Reports XI and Visual Studios 2005 Questions?

  OK I have read a lot of post here that lead me to believe CRXI is not compatible with Visual Studio 2005. Or should I say not till CRXI r2 comes out in which case it will support VS2005 .net Framework 2.0. On a Project that is updated to VS2005 from VS2003 and CRXI for the most part went very smooth.   Except and for me this is major CR Version is 10.2.3600.0 in VS2005 where as it was VS2003 it is Version 11.0.3300.0 for me. Ok from all the post I understand this has dumbed down my reports since CRXI is not ready for VS2005 till r2. In the mean time should we just use the dumb down version of our reports I have seen a lot of post that indicate people can not do this do to controls, processes, or design of there certain proj ...Show All

• SharePoint Products and Technologies How do I display a filtered view of a list in a sub-site...desparate...

  Hi, This is killing me! I read this post , in which things are getting clearer. Here's what I am struggling with: I have Master List in a Exec Site(WSS2.0). I have aseveral sub-sites for each of our satellite offices. I'd like to be able to display filtered views of the Master List applicable to each office in their sub-site. I was able to create a part, paste the list and setup the required filter (in FrontPage 2003). Well, each office still has to have read permissions for the Exec Site and the Master List . That means they can discover the main site and read content they are not supposed to. Is there anyway to pull the filtered data into a list on a sub-site I'd like each office to authenticate themselves to their ...Show All

• Windows Search Technologies No results with full word. WDS 2.6.5.5378

  Hi Sometimes I get "no items found" when I enter a word. However, if I leave out the last letter of the word, I get the correct result. This affects only some words, but I cannot see any pattern to this. I have seen several posts, but no resolution, on microsoft.public.msn.search with this same problem. It also occurs on machines with a German keyboard. Can you help me to resolve this issue I have a WinXP-SP2 machine with a Swiss German keyboard, I am in a workgroup, and I am logged in as administrator. With kind regards, Matthias Klay Can you describe what search query you used and what is the actual result from that query. Then also let me know what you expect that query to ...Show All

• Visual Studio Team System Not getting email alerts on checkin?

  I set the project alert and entered my email address, but there have been 7 checkins over the last 12 hours and I haven't seen an email. How often are they sent, on every checkin or only once per time period If it is not working, what do I look for Thanks Found out relay was not being allowed through the local SMTP server on TFS box, so I pointed at our exchange server... that worked. ...Show All

• Visual C++ MFC, how to set data to an EditBox by its ID?

  Hey all, I have a Edit box which needs to be linked to a u_short variable. From Dialog design I added my variable to the Edit box and when i wanted to set and retrieve data betwin the control and my variable I used UpdateData true/false, and it does nothing :/ So I wanted to ask, how do I assign a value to/from the Edit box using its ID Thanks :) BTW forgot to tell you. Suppose if your member varibles which is attached with edit is m_uEditVal. UpdateData(); m_uEditVal = 10; //Some values UpdateData(FALSE); The above code should work fine. Please make sure that the added variable has attached with the control in the DoDataExchange function ...Show All

• Visual Basic Send output to stdout from gui app...possible?

  I have a simple vb.net gui application (an alternative file requester in a form) that I would like to run from the command line. It executes fine, but I find that I cannot send any output (a string representing the file selected) to the command line upon completion. It appears that "console.writeline" doesn't actually write to the console Any suggestions as to how to send info back to the console window upon completion Keep in mind that this is a gui app (not straight console). I instantiated that streams and received valid streams although, the second was a null stream. There is abother approach. You begin with a console task and add forms capability as shown here: http://www.geoci ...Show All

• Visual Studio Express Editions How do you create a string expertblob?

  I'm messing with the remote assistance api's and need to use an expertblob for one of the calls.  The only problem is I have no idea how to declare or use this type of variable. If anybody could render me a reply it would be much appreciated. Thanks all. *** Followup *** After reading over my own question I realize that I have not given enough detail. I'm attempting to use the builtin windows remote assistance dll rdchost.dll and am trying to use the RDCCLIENTHOSTLib. SAFRemoteDesktopClient. ConnectToServer(string expertBlob) function and no matter what I try to put into the string it will not work, it throws an exception:  "Value does not fall within the expected range." I have tried using the IPAddress from System.Net, standard ...Show All

• Visual Studio modifying parameters for crystal reports

  I am trying to set or modify a parameter for a crystal report that I am opening in a .NET .exe and would appreciate any help on this issue. Thanks. Please read my post at URL below, hope it's help you out. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=805447&SiteID=1 ...Show All

• SQL Server scheduled subscription

  I always confused about scheduled subscription what does scheduled subscription can work for me how to use this thanks in advance Well, that's a very good question. Maybe I can turn it into a blog in the coming days. In the meantime, as you well know, an event driven subscription is rather straightforward. When an event occurs, notify the set of subscribers who are interested in that event. For example, I want to be notified when a certain stock exceeds a threshold that I set. A scheduled subscription is similar; it notifies subscribers of certain event data. However the primary difference is that it does so at an appointed time. For example, I want to be notified at the end of each day with a ...Show All

• Windows Forms How to include SQL Server database with ClickOnce deployment

  I am writing an application that I want to distribute with ClickOnce Deployment. It seems easy enough, simply click the "Publish" option and answer the questions from the wizard. However, there are a few questions that I can't readily determine the answer to: 1) My application uses Sql Server. I see that as part of the prerequisites, Sql Server 2005 Express Edition was included. However, how will the database I created on my development machine be transferred to users machines Can I just back up my database and programatically run restore as part of the install Or, will I have to use scripts in order to creeate and populate the database 2) I currently have a connection string that is unique to my system. What connection s ...Show All

• Visual Studio Where are Studio 2005 Help Files?

  I have VS 2005 Pro and SQL Server 2005 Dev installed. My problem is that the VS 2005 help topics/table of contents does not show anything related to VS. It only shows SQL 2005 subjects. I have been to the help manager, after finding out online about it, but it only allowed me to add Reporting services documentation. I have reinstalled VS 2005, with the Repair option to see if that would fix it, but to no avail. How do I get the help topics for VS to show up Thanks, Chris Hi Stamey, You haven't mentioned it, but after you initially installed VS 2005 Pro did you also select to intall the companion MSDN Library (VS 2005 Documentation) This choice would appear in a dialog box after the successful ins ...Show All

• Gadgets XMLHTTP help, please!

  I have utilized xmlhttp on many occasions to power ajax enabled projects and have never had a problem with it until now. The following javascript code is debugged and runs flawlessly in IE7, but does not work when installed as a gadget. Is there something in here that gadgets do not support but IE7 does function GetXmlHttpObject(handler) { var objXmlHttp=null; var strName="Microsoft.XMLHTTP"; try { objXmlHttp=new ActiveXObject(strName); objXmlHttp.onreadystatechange=handler; return objXmlHttp; } catch(e) { alert("Error. Scripting for ActiveX might be disabled"); return; } } function showDisplay() { var url=" http://www.ourwebsite.com/phpscript.php variable=one"; xmlHttp=GetXmlH ...Show All

• .NET Development Soap Error "SQL Server does not exist or access denied"

  Hello All, I have a webservice uses a vb.net component that accesses thrid party dll to connect to a sqlserver dbase, username,dbase name ,server and password are passed to the third party dll for login purpose. This works fine in development evironment when pda client calls webservice, A soap error is thrown to the client "sqlserver does not exist or access denied" when the client calls the deployed webservice. I have tried the following 1. Added ASPNet user to the database 2.Added domian user to the database both has public and dbowner rights Can any one help Thanks Regards I am curious why you need a third party dll to access SQL Server when you can do so using ADO.Net Use SQL ...Show All