Hassan Ayoub's Q&A profile

• .NET Development passing dbnull to splserver express

  I have an application i'm writing connecting to sql server express. there is a field call PayDate which is a text field and it passes the date to a coloumn in splserver which is a "date" type and allow nulls is checked. I can add and update the dates changed with no problem, but what I want to do is when the date on the textbox form is removed, I want to pass a "null" back to the PayDate column in sqlserver so it shows as "NULL" . When I used "mySQL", I had no problem passing a null back, but with sqlserver I can't seem to get this to work. Is there a way that when I remove the date from the textbox on the form and press "save" myBindingSource.EndEdit() myTableAdapter.Update( Me .myDataSet.myTable) I can pass ...Show All

• Microsoft ISV Community Center Forums setting up pet shop 4.0

  Hi I am a .NET newbie here. I have downloaded petshhop 4.0 from MSDN. How can I get it working please I want to take a look at how the application works My machine is win2k3 with SQL 2005, VS2005 and framework 2.0. I realised that if I use 3.0, it will work straight away but it only works with SQL 2k. I would like to try with SQL 2005, hence I am looking at 4.0. Do I have to rebuild to see the application works Am I missing something Thanks in advance. win Moving to architecture forum. The forums at http://forums.asp.net should be able to help as well. Thanks. ...Show All

• Windows Forms Get instance from object in user control

  I have a user control that i create by clicking a button...On this user control it contains a button that brings up details about a object....this object already has values....But i dont know how to pass the current object to the user control....when i do myobject obj = new myobject...the properites all lose thier values when i do that...i need to keep values from the object when its loaded the first time....any help on this or is everyone lost Here is the code for the button i have called btnBuild Detail and i try to pass a reference of the Order object through but i get the object ref not set to instance of a object....check it out   private void btnBuildDetail_Click( object sender, System.EventArgs e) { ...Show All

• Visual Studio 2008 (Pre-release) Change Source of Frame to display different web pages?

  Hi, I trying to display different web pages in a frame using timer to change its source but it keeps displaying the same page even when its source is changed.. I am writting following code: string[] webAddressQue ={ "http://gmail.com" , "http://yahoo.com","http://bellset.com"}; public void window_loaded(object sender,RoutedEventArgs args) { dtTimer = new DispatcherTimer(); dtTimer.Interval = new TimeSpan(0, 0, 10); dtTimer.Tick += new EventHandler(dtTimer_Tick); index = 0; dtTimer.Start(); } void dtTimer_Tick(object sender, EventArgs e) { if (index == webAddressQue.Length) { index = 0; } myWebBrowser.Source = null; myWebBrowser ...Show All

• Visual Studio 2008 (Pre-release) Create ellipse where myEllipse.Opacity=.40 & Stroke.Opacity=1

  I want to create an ellipse in c# where the Fill.Opacity is less than 1 but the Stroke.Opacity of the ellipse is still 1. Also, I simply tried setting the ellipse opacity to .40 and the stroke to Black and I expected to get a gray border but it doesn’t show at all. What are the ways I can create a border around the ellipse where the fill has an opacity less than 1 Here’s me code: void DrawEllipse() { Ellipse myElippse = new Ellipse(); myElippse.Height = 10; myElippse.Width = 10; myElippse.Fill = Brushes.MediumBlue; myElippse.Opacity = .4; myElippse.Stroke = Brushes.Black; myElippse.StrokeThickness = 1; //myElippse.Stroke.Opacity = 1; //No can do: myElippse.Stroke is ReadOnly. Canvas.SetLeft(myElippse, 15); ...Show All

• Windows Forms overlaying a docked panel?

  Hi, I've got the following problem. I am working on an application that has a main form with on the left side a tree view and on the right hand a panel. Both objects (treeview and panel) are docked, so they stick on the sides of the screen. i thought that might be usefull when the application is used on different screen sizes. However, when the user clicks on some nodes, some dialog forms open. Is there any way i can make sure that the dialog forms that are opened perfectly overlay the (docked) panel on the right hand side. That would make my application a bit more easy to handle on different screen sizes. I hope this is clear. Thanks so much for a reply PS I'm using VS 2005 A related problem. Is there a way to open fo ...Show All

• .NET Development DATA SET

  Hai, I have doubt in dataset(data layer) creation in asp.net2005. i need example for data set like, 1.How to create the dataset. 2.how to write the methods in the dataset. 3.how to call these in aspx froms. Do you mean ado.net dataset Or what kind of dataset If you want to know ado.net dataset, You can see this aritcles in msdn... http://msdn2.microsoft.com/en-us/library/zb0sdh0b.aspx ...Show All

• SQL Server Enterprise ETL "Appliance"

  At least one company has developed such a product. Here's a link: http://www.dataintegrityinstitute.com/copula.htm I am interested to read your thoughts on this. DISCLAIMER: I don't work for the aforementioned company and don't benefit from them in any way. Phil Brammer wrote: Duane, Please tie this post back to SSIS, or it will get deleted. This is an SSIS forum, not a bulletin-board. Ok. My understanding is that ETL appliances are the wave of the future and that many of these devices work with ETL software tools. Considering that SSIS is an ETL software tool, I am curious as to whether SSIS can work in tandem with such devices. In as much as this is a forum dedicated to SSIS, I believe that any discussion regarding ...Show All

• Visual Studio 2008 (Pre-release) XAML to JPEG converter... memory leaks

  Hello, I have created very simple console application which converts xaml file to jpeg. I have found that there is big memory leak when running this application. After some 5000 conversions almost all RAM is eaten (about 400 MBytes). I have tested this inside virtual PC 2007 with WindowsXP and Vista as guest operating system. Any idea what can be wrong… Thanks Edvin namespace Console1 { class Program { [System. STAThreadAttribute ()] static void Main( string [] args) { try { for ( int i = 0; i < 5 000; ++i) { if (i%100==0) Console.WriteLine(i.ToString()); ConvertToJpg( "ImagePlusText ...Show All

• Software Development for Windows Vista Using transactions to access database within Worfklow

  Here is my scenario (in an abstract form): Say I want to get a value in a database table, and then based on that value perform some other action. I do not want that value within the database to be able to be changed until after I have performed the follow up action.  I have no problem implementing this process within a SqlTransaction in my data access layer, and getting the desired atomicity. However when putting this inside a workflow, I cannot get the atomicity.  Within a transaction scope activity I have a call to a web service, which in turn invokes a stored procedure to get the value in the database.  Once the web service returns the value and focus returns to the workflow, and before I check out th ...Show All

• .NET Development Problem updating record

  Hi, I've the following code used to update a record on my Access database: con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=""C:\Programacao\Visual Basic\Inapal\ReportIt\ReportIt.mdb"";" con.Open() sSQL = "SELECT * FROM [Utilizadores] WHERE (User= '" & Utilizador & "')" da = New OleDb.OleDbDataAdapter(sSQL, con) ds.Clear() da.Fill(ds, "Utilizadores") ds.Tables(0).Rows(0).Item("Password") = NewPasswordTxtBx.Text da.Update(ds, "Utilizadores") con.Close() Me.Close() When I try to update the record I get the following error: "Update requires a valid UpdateCommand when passed DataRow collection w ...Show All

• .NET Development asp.net + ajax issue

  i made a simple website which i needs to convert in ajax using atlas Scenario::::::::::::::: my all pages are using single master page and in header of master page i have menu and sub menu bars and simple footer and ofcourse only one content place holder in between header and footer problem:::::::::::::::::: 1. i want when i need to redirect to another page i get that page on the same page means i don't wanna redirect i want to view that page on the same page now please tell me where i put script manager and where where i need to put update panels and what technique i use to load page on the same page (except iframe) and what property i set to update panel means conditional or always plz tell me in details as i m newbie ;) ...Show All

• Visual Studio Team System Understanding areas and iterations

  I have been searching for some guidance on how to use areas and iterations, how WIs tie into a particular area etc. I haven't been able to find ANYTHING that gives a decent explanation of these topics. About the MSF guidance; I'm not sure if it's just me or do other people also find this to be too high level to be of any real use The closest I came was this post by Eric Lee: http://blogs.msdn.com/ericlee/archive/2006/08/09/693849.aspx Can anyone point me to some articles/posts that shed more light on these features Thanks! Got it. Thanks for the nice comments on the earlier whitepaper stuff (and I didn't even complete it fully there is a few more scenarios I'd like to cover in the SCM whitepaper). I'll try to get to your reques ...Show All

• Visual C++ Form with an expandable area

  hi there, I am using Visual C++ in VS2005. I want to make a form with expandable & collapsible areas, say on the right hand side of the form and on the bottom of the form. Inside each area I would like to put some controls in it. For example, if you have the PowerDVD program, you can see on the right hand side there is a little arrow, and if we click that arrow an area will expand out and there are some more controls in that expanded area. I am wondering if VC++ can do something like this (any .NET component) or we must hard-code the whole expansion business relating to form area change and things like that Thank you very much in advance !!! Cheers ! hi peter, & ...Show All

• Visual Basic Problems with assembly versions!

  Hi, the program i'm developing is using a dll of a class library we did before, that library ("CM.Research.MDGraphicToProduction.dll") is working fine. But when i use a class contained in this dll, i receive a problem. Look this is where i use the class: 'MDObject is a CM.Research.MDGraphicToProduction.MDRemote ... re = CM.Base.RemoteInstance.RemoteElements.Import(MDObject) ... and the message of the error is this "Reference required to assembly 'CM.Research.MDGraphicToProduction, Version=1.1.2501.32020, Culture=neutral, PublicKeyToken=null' containing the type 'CM.Research.MDGraphicToProduction.MDRemote'. Add one to your project." The version of the DLL i have referenced is a newer one (1.1.2509.25 ...Show All