pixelord's Q&A profile

• SQL Server Set NULL to datetime parameter

  Hi All, I have a problem while trying to set "NULL" value to my datetime parameters. I have two datetime parameters (AllowNull=True) on my report. (BeginDate and EndDate) it works fine in preview mode in reporting design. The problem occurs, if I try to set an emtpy value to these parameters in my asp.net application. The code looks like; Dim repParams(1) As ReportParameter repParams(0) = New ReportParameter( "BeginDate" , String.Empty) repParams(1) = New ReportParameter( "EndDate" , String.Empty) ----- ReportParameter method requires String parameters. If user set any datetime value, I am sending "String.Empty" value to my paramaters in order to set them as NUL ...Show All

• .NET Development Asynchronous Receive Method and Threads

  Hello All, I have Asynchronous method to read bytes from the network stream. I wrote below code 2 months ago, now when I come back, I wonder why I used "while(true)" for backgroundWorker. Are there any alternative method to use asynchronous read method with backgorundworker Or the method written below is OK receiveBackgroundWorker.DoWork += new DoWorkEventHandler(Receive); private void Receive(object sender, DoWorkEventArgs e) { while (true) { dataTransfer.Reset(); clientStream.BeginRead(receiveBuffer = new byte[socket.Available], 0, socket.Available, new AsyncCallback (AsyncReceiveDataCallback), clientStream); dataTransfer.WaitOne(); } } private void AsyncReceiveDataCallback ...Show All

• Visual Studio Macros don't work in VS 2005

  Hello, The macros aren't working in VS 2005. I don't see a "macros" under the tools menu. I don't see anything happen when I click on Ctrl-Shift-R. I also have VS.NET 2003 on the same machine and it works fine. Any idea what's wrong The version information that I have is: Microsoft Visual Studio 2005 Version 8.0.50727.42 (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 -Eric Mine looks like: 07/31/2006 03:58 PM <DIR> 1033 05/24/2006 05:06 PM <DIR> HTML 07/31/2006 03:56 PM <DIR> Packages 07/31/2006 03:56 PM <DIR> SolutionTemplates 05/25/2006 11:00 AM <DIR> VS SCC 09/23/2005 02:53 AM 27,648 cmddef.dll 09/23/2 ...Show All

• Visual Studio Express Editions simulate keyboard, mouse events

  I am needing to come up with a way to program simulate ctrl v, and a mouse click. msdn states the best way is using hooks. other places say use sendinput, still others different ways. I have tried doing them all and as yet have no success. I am toying with having data on the clipboard. then with any of an assorted textboxs open , a mouse click will target whatever box its over. then i can paste using the ctrl v code. I can find no sample code at all. most microsoft links are dead even dealing with it. any ideas on best way to simulate ctrl v and a mouse click   Charlie,   I love this solution. It's very flexible. You should be able a create ...Show All

• Visual C# Memory Usage

  Why is it when you click on a forum with just one button that does nothing, the memory usage keeps adding up. Any program in c# so far I seen keeps adding o the memory usage. Ctrl alt del to see the mem usage of any program. I am making a game and if it keeps increasing like that it will eventually make the computer not be able to handle that much usage. Any ideas I dont think it is memory leaks in my programming because it does the same on a basic applacation with a single button on the form. In C# memory usage is cleaned up by the Garbage Collector, this will only execute when it thinks it is necessary i.e. when there is some kind of memory pressure to use more memory and unused memory needs to ...Show All

• SQL Server Access a database from a client application

  Hi all... I am writing a Windows Application which will be used by about 100 clients. (NT Authenticated) The application is going to be used in a LAN enviroment. User who have access will download a VB.NET application from a web site. Of course, I want to prevent any of the 100 users from using a tool such as Query Analysis or ODBC to connect directly to the database and modify data. So, it appears the way to go is to the "Application Roles". For this to work, the application roll password has to be saved in the application to execute the sp_setapprole procedure. Is there a way to secure this password I am worried about a user somehow extracting the password from the application and connecting directly. Am I on ...Show All

• Commerce Server still having an issue trying to do a PurchaseOrder.Save()

  Hello, A while back I posted this thread, which describes my problem pretty thoroughly, but I'll do it again as I'm kinda running out of ideas on how to fix it. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1068432&SiteID=1 I have a view order page which can show a customer their order. This page uses the viewstate to get the order information (from commerce server) on first page load and store the OrderGroup class (could be purchase order or basket) in viewstate, modifying it over time and allowing the user to commit all changes when the update button is pressed. This works fine in all cases for baskets, but when the order is in the purchase order state, I attempt to change the status of a line item and when the save ...Show All

• SQL Server Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server

  Okay, this is what's happening. My drive: H Webserver: W Access Database: G Created a linked server on W, which points to the Access DB on G. Can run queries from W to see the data, no problem. Trying to run a simple select statement from an asp page, the error: Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "blah". What is that all about I see this error everywhere on the 'net, but there doesn't seem to be a solution that works! Now get this - if I move the DB to W, create another Linked Server pointing to it (the same box as SQLExpress), it displays the data, no problem. What is that Thanks to whomever can help! Here is the solution, aft ...Show All

• Visual Studio Express Editions Mathamaticians please !

  I want to resize an image using a NumberUpDown control, Here's what I have, Dim pcent As Integer pcent = 100 / nudPercent.Value pbxResize.Width = pbxResize.Image.Width / pcent pbxResize.Height = pbxResize.Image.Height / pcent If I enter 50 then 100 / 50 = 2 so the image width and height is divided by 2 = 50% If I enter 25 then 100 / 25 = 4 so the image width and height is divided by 4 = 25% you can see that this does not work for 76% for example 100 / 76 returns 1 which gives 100% so how do I resize the picture by the number in the NumberUpDown box. Ok Dave, Did what you suggested and according to me the answers should read as follows; 3.75 6.25 8.75 When I ran the program the answers ca ...Show All

• SQL Server problem connecting to database server with distributed SRS install

  Hi, I have a sql server 2005 database server that is remote to my SRS intall (SRS is installed on a separate IIS server). The install goes fine, the SRS config all shows green - but when trying to connect via IE ( http://servername/reports ) I get an error that it cannot make a connection to the database: The weird thing is that it is showing the computer account as having login failed instead of my user account (which it just asked prompted me for). I have changed nothing on the IIS server, but the dba's have changed some stuff on the sql install i'm pretty sure. Can anyone tell me what needs to be enabled for this default SRS install to work What could they have changed on the sql server to make it do this or...How can I stop ...Show All

• SQL Server I-Mate JasJar And compact framework installation Problem ?

  Hi everyone here   i have a little problem : i tried to install the compact framework onto my pocket pc with windows mobile 5.0 but the installation fiailed and gave me an error . the error message said that :  the version of installation is not specified for this version of  operating   system   .. so what can i do to install compact framework on the device   please help ! Hi Which version of the Compact Framework NetCF 2.0 How exactly have you tried to install it i have copied the files : X:\Program Files\Microsoft.NET\SDK\CompactFramework\v2.0\WindowsCE\wce500\armv4i\NETCFv2.wm.armv4i.cab and run it . Is this mess ...Show All

• SQL Server Performance degradation in December CTP of AS 2005 SP2

  Has anyone had any similar experience with the December CTP of SQL Server 2005 and Analysis Services SP2 We have a simple MDX query which returns 245 rows and 15 columns of data. When running this query through management studio under SP1 it takes 1 second, and when run through an XMLA query it takes 2 seconds. We have now installed the december CTP of SP2 on an identical server and re-deployed / re-processed the identical cubes to this server. When running this first test query it takes consistently 6 seconds and 20 seconds when run through an XMLA query. Does anyone have any hints on what could be different in the new CTP that could be behind this One thing that I have noticed is that running the MDX as an XMLA query produces t ...Show All

• Visual Studio 2008 (Pre-release) Rich class object on Service and Client side?

  Hey! When setting up a WCF communictionen between a host and a client we generate the proxy classes for the client. All the classes that are used on the host and are known the the service are regenerated on the client side but in a special proxy version. I need to let the client know of the real classes, and not just the proxy clases, this could be manage by reference to a class library(dll(same as the one the service are using)). Now to the question, will i have to build my own Proxy object to orginal object converter my self(that fill the object fom the class librare with the data in the proxy object) or is there anyway to let the client use the real objects instead of the proxy objects like it does with the built in type(Dataset, Strin ...Show All

• SQL Server How do I call a stored procedure in vb2005

  I have a sql2005 express database I am using in a vb2005 application. I have read a bunch and can't seem to find a clear (to me) example of how to call a stored procedure. I have a procedure that runs ok in the query builder, but don't have a clue about how to call it now that it is written. SO. call the database MYdatabase call the Stored procedure MYStoredproc. Any help Dave PS: it dosen't require and values passed to it, its very simple. Maybe this snippet can help: Dim MyCmd As New OleDbCommand () Dim Cnxn As New OleDbConnection ( "ConnectionString" ) With MyCmd . Connection = Cnxn . CommandType = Data . CommandType . StoredProcedure . CommandTex ...Show All

• Visual Studio Team System New Work Item Field Type ?

  hi, i want to add a new field type other than the default ones (eg, String, double, and etc). The result i want is something like this: <FIELD name="Effort" refname="MyCompany.Effort" type="MenDay"> <HELPTEXT>The effort to finish a task</HELPTEXT> <REQUIRED/> </FIELD> right now i have a approach, which is to specify the unit in the lable or in the helptext: for example, <FIELD name="Effort" refname="MyCompany.Effrt" type="Double"> <HELPTEXT>The effort to finish a task in ( Man Day )</HELPTEXT> <REQUIRED/> </FIELD> ..... <Control Type="FieldControl" FieldName="MyCompa ...Show All