Wajdi Georges's Q&A profile

• Visual Studio 2008 (Pre-release) wcf based sample for sync service

  Hi Rafik Thanks for the great example. I was actually looking out for a viable solution to implement sync feature with our product. Ours is a health care product and we need to make available the application and the data (partail content) to doctors who go to remote locations to visit patients. I was looking out for various options like SCOAB, SQL Merger Replication, etc.. finally got hold of the ADO.Net sync service, and I hope this would provide me with the right solution to for adoption. I initially had a look at the webcast from Steve, was pretty interesting and then was looking out for samples, which I could run through. then luckily happened to come across your samples, which were of great help. Rafik, do you also have a sam ...Show All

• Visual Basic Entering text into site

  I will have a web browser in my app and I want it to enter text into a textbox on the page, how would I do this, I am just making an app to restart my router. dakota367 wrote: I will have a web browser in my app and I want it to enter text into a textbox on the page, how would I do this, I am just making an app to restart my router. This can be done. you need to try and get the element by ID, the textbox, then once found, set its text on the documentCompleted event. Example... private sub webbrowser_documentcompleted(byval sender as object, byval e as WebBrowserDocumentCompletedEventArgs) handled webbrowser.documentcompleted Dim theElement as HtmlElement = Me.webbrowser.Document. ...Show All

• SQL Server create table from select result

  Hi, I need to create a table which has the columns from the select statement result. I tried in this way drop table j9a SELECT er.* into j9a FROM caCase c LEFT OUTER JOIN paPatient pp ON c.caCaseID=pp.caCaseID Left Outer JOIN paManagementSite pm ON pp.paManagementSiteID=pm.paManagementSiteID Left Join exexposure ee ON ee.cacaseID=c.caCaseID LEFT OUTER JOIN exExposureRoute eer ON eer.caCaseID=c.caCaseID LEFT OUTER JOIN exRoute er ON er.exRouteID=eer.exRouteID WHERE c.caCallTypeID =0 AND c.Startdate between '1/1/2006' and '12/1/2006' AND (ee.exMedicalOutcomeID=4 OR ee.exMedicalOutcomeID=10) AND pp.paSpeciesID=1 AND c.PublicID_adOrganization_secondary is null declare @1 int,@2 int,@3 int,@4 int,@5 int,@6 int,@7 int,@8 int, @9 int,@10 int,@11 ...Show All

• Visual C# Create website is missing from Home screen

  Hello, I have used VS2005 for quite sometime now and I always had option to open or create website from homepage, now I see only "Project". I can still create and open website from File menu but option is gone from homepage, anybody has any idea why would that be G Try re-importing the Visual C# Development settings. There is a setting that controls whether that option shows up on the start page. You can also try running devenv /resetuserdata and then choosing the Visual C# Development settings from the initial screen you get the next time you launch VS. Hope that helps! Anson ...Show All

• Visual C# I would like to search for a record(rate) using C# code from 2 tables and display the

  Hi All I would like to search for a record(rate) using C# code from 2 tables and display the rate in a textbox on a form. The tables are State and Zipcode. State is the primary key in th State table and it is also a foerign key in the Zipcode table. The Zipcode table has 2 fields, zipcode and rate and the primary key is zipcode. Any sugestions are welcome well firstly, how are you obtaining the data from SQL have you filled a dataset using the SqlDataAdapter You may also need to create a relationship between the 2 tables as a "datarelation" in the dataset you can do a query if you have done the above, to return your results...like:   DataRow[] theResult = theDataSet.Tables[0].Rows.Select("State = '" + state + "' A ...Show All

• .NET Development Update using SQL Exp not working

  Hi I'm trying to update a database (sql express) with values, using a stored procedure and parameters (a fairly simple and straight forward request, or you'd think so!). Code to create parameters, etc set connection sproc //get provider name static string providerName = ConfigurationManager .ConnectionStrings[ "Dolphin.Properties.Settings.ConnectionString" ].ProviderName; //create instance of fatcory static DbProviderFactory factory = DbProviderFactories .GetFactory(providerName); //get connection string static string connectionString = ConfigurationManager .ConnectionStrings[ "Dolphin.Properties.Settings.ConnectionString" ].ConnectionString; public static bool Upda ...Show All

• Visual Studio 'Unable to find the report in the manifest resources' - Build Action is missing??!

  Hello, I have just upgraded my VS2003 project to VS2005. Had a million things to fix, but I'm finally down to the last few. The biggest remaining problem is my Crystal Reports don't work. The error message is below... On googling it the answer seems to be I have to include the *.rpt's as an embedded resource. However, and this is the really odd bit, the properties that should show up in VS2005 to allow me to do that are simply missing! No matter how I fool around with it, there is no Build Action property when I select a file in the Solution Explorer. I notice that if I create a Windows application in VS, the Build Action property (and 3 others in the Advanced category) are available. Just not when I'm working with web projects. ...Show All

• Microsoft ISV Community Center Forums datagrid control in access

  hello, i am developing an access application using forms and i don't have the datagrid control. i tried downloading msdtagrd.ocx and install it but the control doesn't seem to be working properly. is there a control i can use that has a menual on how exactly i use it (either in the code and on the form). thanks refael I don't know of any tutorial. It's only complicated because you've came up with an approach that Access has not been designed to handle. You've came up with an approach without looking at the technology your going to implement the approach in. It's only as complicated as you make it. ...Show All

• Visual Studio Error:The language-neutral solution package was not found

  Hy, I used Windows SharePoint Services 3.0 Tools Visual Studio 2005 Extensions November CTP to create Web Part project. I reseive the following error: "The language-neutral solution package was not found", when use Depliy option to deploy my Web Part. Petar Petrov Hi Petar, You will need to contact the Sharepoint community about this issue as this is not related to Visual Studio Extensibility. Sharepoint Community site: http://msdn2.microsoft.com/en-us/sharepoint/aa905689.aspx Thanks, Aaron Marten ...Show All

• SQL Server Using Foreach Loop Container

  Hi Guys, (I have searched this forum extensively, but still can't find the solution to this problem) Here it is: I have step in my ETL process that gets facts from another database. Here is how I set it up: 1) I have to package variables called User::startDate and User::endDate of data type datetime 2) Two separate Execute SQL Tasks populate those variables with appropriate dates (this works fine) 3) Then I have a Data Flow Task with OLE DB source that uses a call to a sproc of the form "exec ETL_GetMyData @startDate = , @endDate = " with parameters mapped accordingly (0 -> User::startDate, 1 -> User::endDate) When I run this I get an error 0xC0207014: "The SQL command requires a parameter nam ...Show All

• .NET Development XML DateTime serialization

  Hello, I am upgrading a .Net Framework 1.1 application that uses an XML document and writes this document to a file. One of the fields in the document has the xml datatype dateTime. This dateTime is output in a format containing 7 digits for the fractions of the seconds (yyyy-mm-ddThh:mm:ss.sssssss+timezone). As the dateTime we use is only accurate to the minute, the seconds and fractions of seconds remain zero and are output as zeros. After compiling the application with the .Net Framework 2.0 this changes. If the fractions of seconds are zero they are no longer written to the file (the seconds are still written as 00). As we exchange this file with a business partner who requires the fractions of the seconds to successfully parse t ...Show All

• SQL Server Concatenate Rows into Columns

  I have a table 2 columns (Object and Weight) with data like below: Object Weight(lb) table 5 Chair 6 Computer 3 Computer 5 TV 20 TV 15 Radio 10 Computer 10 Question: I would like to create a new table with one column that would join the above two columns like below Object table 5 Chair 6 Computer 3, 5, 10 TV 20, 15 Radio 10 Thanks for your help in advance. --We can use CTE in SQL Server 2005. The recursive function will take care of the number of records for the same object in your table. With MyCTE ( Object , Weight , Weights , myNum ) AS ( SELECT a . Object , CONVERT ( varchar ( 50 ), MIN ( a . Weight )) as col1 , CONVERT ( varchar ( 50 ),( a . Weight )) as Weights , 1 as myNum ...Show All

• Visual C# How can i set/get metadata of a file

  Hi, Is there any .Net class or methods to set or get metadata (like Autor, Title, Description etc...) of .png, .jpeg files Any idea Thanks! Thanks a lot PJ! It's work! The Id was not correct (i.e. Title: propItem.Id == 800, see PropertyItemDescription for the definition of other Id). Actualy i can read these properties only with Paint Shop. I can't with MS Paint or with "right click" --> "Properties" of the image file. Is there any reason ...Show All

• Software Development for Windows Vista Extract values from persisted workflow without instanciate it

  Hi there I'm trying to extract the initial parameters of a persisted workflow for comparison purposes, without the need to instantiate him. I'll try to explain it... I have a workflow that describes the life cycle of a customer inside a business home. When the customer arrive, they are admitted in the reception where a few personal information is gathered. A workflow is created for every one that is admitted. They pass through 3 different steps and talk to 3 different end users of the application until the workflow is finished. For every step I want the end user to have a display list of customers in list for that step by order they arrived. Throught SQLTrackingService I manage to track in what activity the workfl ...Show All

• .NET Development How to not show the security dialog box with a WebBrowser

  Hello, I'm using a WebBrowser in C# and when i navigate to some adresses a dialog box is shown saying i will be redirected to a website non protected. How can i hide this dialog box Thank you! SendKeys is an interesting solution but if the Form is minimized the SendKeys will not work! To be verifyed! Do you thing it is possible to know if the dialog box is shown or not It's not on www.msn.com but on it's something like that, i use the cookie of the Passport Network but sometimes the dialog box is shown anyway and i don't know why It's annoying! Thank you for your help! ...Show All