William Lowers's Q&A profile

• SQL Server Keeping state between calls to a UDF

  Hi, I'd like to keep state between calls to a UDF (mainly for caching purposes). I can shove an object into the appdomain using SetData and read it using GetData, but that requires the assembly to be set to UNSAFE. I'm confident I can secure the DB and the assembly fairly well, but I like defense in depth, and if there's another way to save state between calls to a UDF, I would prefer those. Is there another way to store state between calls to a UDF, without putting data into DB tables or using things that will require the assembly to have such a wide permission set Thanks, Alex NOTE: following suggestions are not supported by Microsoft. You have two options: first is to declare the class wi ...Show All

• SQL Server Displaying the dates in a column.

  Can someone help me with this. I've been trying to produce it this way but still unsuccessful. I'd like my table to look like this: Month: January Day wkDay ------------- 1     Mon 2     Tues 3     Wed 4     Thurs 5     Fri 6     Sat .     . .     . 31    Wed I want to display the whole month.. Please help.. Thanks.. select datepart ( d , getdate ()) ' Day ' , case datepart ( dw , getdate ()) when 1 then 'Sun' when 2 then 'Mon' when 3 then 'Tue' when 4 then 'Wed' when 5 then 'Thu' when 6 th ...Show All

• SQL Server Report Viewer in ASPX page- Getting an Error "The request failed with HTTP status 401: Unauthorized"

  I used the following reference code while creating this simple ASPX page with reportviewer control using VS 2005 http://www.tutorialsall.com/REPORTINGSVCS/WebFormsReportViewer-ReportServerCredentials/ ReportViewer is having following properties ProcessingMode = "Remote", ReportServerUrl = "/foldername/myreport ReportPath = " http://report.mydomain.com/reports " Even after using admin user we got the same problem Please help Hello, I am receiving precisely the same message for an intranet web application that is working fine on a different pair of servers. The report server is SQL 2005 in all cases. In Production it works fine, the re ...Show All

• Visual Studio Express Editions app control

  After I have found the handle of a button i want to control from my aplication with spy++then what do i do with that number or i will have to just fake a mouse click at x position like this person did... I have found the eqivelent to what i am trying to do accept it is in visual basic 6.0 code so i dont know how to do a conversion. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=144808&SiteID=1 tell me if you have any ideas... Average Joe Reneec code looks like VB.Net code to the unmanaged API's - she quite explicitly states its VB.NET code and has been tested and I have no reason to doubt her as she is a moderator with lots of .NET experience. http://www.pinvoke.net is an extrem ...Show All

• Visual Studio 2008 (Pre-release) LINQ to SQL ( Everywhere ? )

  Hello guys, I am researching LINQ and I would like to know what is timeline for this project. when we could expect Beta, RC.. (I realize it is too early to ask this but still ) AFAIK LINQ for SQL works with SQL Server only. Any plans to include SQL Server Everywhere If yes when we could expect first release Before I forget - congrats for good job on LINQ project ;) Thanks in advance We are looking into SQL Everywhere support for V1 but haven't made a decision yet. If we decide to build, this would be in addition to the provider model that we are working on. Of course, provider model would enable someone else to write it as well. A related point - SQL Ev does not require Compact Framework - it can run with desktop frame ...Show All

• Windows Forms I have a Question on the Limits on numericUpDown (Help Please)

  Is it posssible to get a numericrUpDown to write Text to TextBox Example: 1,2,3,4,5 in the numericUpDown would write this to a TextBox: "border:1px; border:2px; border:3px; border:4px; etc " and follow the format .. if so can some give me an example of it would be done,cause i'm not sure how to get it to do what i need...lol Thxs for the Help in Advance!! if I pasted my code right it would work : using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace MyApp { public partial class Form1 : Form { public Form1() { InitializeCompo ...Show All

• Internet Explorer Development Writing a BHO in Java / JavaScript / C++

  Hi everyone. It's pretty clear that a BHO (Browser Helper Object) can be written using C++/ATL, but I was wondering: 1) Can a BHO be written entirely in Javascript (if yes, can you recommend links to examples or docs ) 2) Can a BHO be written (mostly) in Java What I mean is, even if a little C++/ATL "glue" is required, could most of a BHO be written in Java The MSDN docs are focused on languages that Microsoft prefers, and I cannot find any references to extensions / plug-ins / add-ons / add-ins / BHOs written in Java. Note that I am specifically interested in a BHO, meaning code which the user installs into the browser as an Add-On/Extension, and which can run as each web page is loaded. I'm not talking about an ActiveX ...Show All

• Windows Forms OnPaintEvent Issue(help please)

  Ok,i'v just started messing around with the OnPaint Event i normally just make most of my Graphics in Adobe Photoshop.But want to start using the the OnPaint in my Forms.. The problem i'm coming across is moving my Straight Line Down the Form,As of right now it goes Horizontal but in the middle of my Form..here is the code i have so Far.. Now i'm not sure about the p3, p4 i know it can take up to 4 Arguments but when i use the p3, p4 i get an Compile Time Error in my g.DrawGraphics(MyPen, p1, p2); Looking to move the DrawLine further down my Form Thxs in Advance for the Help protected override void OnPaint( PaintEventArgs pe) { Graphics g = pe.Graphics; Pen MyPen = new Pen ( Color .CadetBlue); Poin ...Show All

• .NET Development Socket.Select ignores timeout and returns immediately.

  I'm writing an application that I want to listen on a UDP socket and to wake up every time a message is received so it can process it, and to also wake up after if a certain time out has expired so it can do some book keeping and various other tasks, and then loop round again. Below is quick sample to show the problem. From what I've always understood of Select, and what the documentation says, it should sleep for up to the time out (5s here) waiting for data, but it doesn't. It just returns immediately whether there's data or not - though the collection is empty when there's no data so that part of it is correct. The end result is this is a constant loop, CPU usage goes to 100% and is just generally bad. I could put in a Sleep, but that w ...Show All

• .NET Development How do set "minOccurs" / "maxOccurs" of DataColumn?

  Hi I've created a DataTable: DataTable table = new DataTable ( "MyTable" ); table.Columns.Add( "ID" , typeof (int)); table.Columns.Add( "Name" , typeof (string)); table.Columns.Add( "Age" , typeof (int)); ... Then I save it to a XML-file: table.WriteXml( "MyTable.xml" ); How do I specify "minOccurs" / "maxOccurs" etc of the columns added Now they automatically have "minOccurs = 0". Kind Regards The only thing you can do is make minOccurs=1 using the following: DataColumn c = table.Columns.Add( "ID" , typeof ( int )); c.AllowDBNull = false ; If you have maxOccurs > 1 on any field then the Data ...Show All

• Visual C# Using Client Certificates

  I need to authenticate user credentials (on a button click). I need to read the certificate subject present in the user's browser. I am using the "HttpClientCertificate" class. I have installed the client certificate in my browser (I can see it in the "Personal" folder). When I make a request to the login page, first the server certificate pops up, then a dialog pops up asking me to choose from a list of client certificates, but the list is empty (I cannot see the certificate I have installed). I observe that "certificate.IsPresent" returns false. protected void btnLogin_Click(object sender, EventArgs e) { HttpClientCertificate certificate = HttpContext.Current.Request.ClientCertificate; if ...Show All

• Windows Forms Task Vision Documentation and Problem

  Hi all, Currently wrtting an app for our bussiness which will look after our customers, it's kinda of a mini-crm application. I've not done much development, but feel I can get this working to a good level and learn more as I go. Is there any documentation which walks you through task vision on how it's designed Also In VB Express 2005, when I try and view a form I get the following error: One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. The name PriorityText is already in use by another component. Hide at System.ComponentModel.ReflectPropertyDescriptor.Se ...Show All

• Visual C++ OpenFileDialog and SaveFileDialog crashes windows application

  I built a simple windows application in C++ with the .NET framework (using Visual Studio .NET 2005). The application used to run fine (it opens the OpenFileDialog and SaveFileDialog properly), but after I added more (unrelated) features, when the application tries to display an OpenFileDialog or a SaveFileDialog, the application closes abruptly on another computer with no warning message , not even that annoying warning beep sound. However, the application "sometimes" ran properly for the computer on which the application was compiled. By "sometimes" I mean for some builds of the application. Builds of my application that crashes does so consistently.   Some more description: In earlier builds of my program, disp ...Show All

• Architecture Live Communications Server (LCS) & IM

  I am trying to understand the model of an IM system. I understand that LCS provides Initiation, Control and Termination of IM sessions (including security). What I do not understand is the message path once the session is initiated. Do messages flow thru the server or is a peer-to-peer connection established between the session parties Any other descriptions or information sources for the IM model are requested. The info that I have found on the MS site relates more to deployment than the model. Thanks I'm not sure about how large suppliers like MS do this, but I've build one once and decided that I didn't want all the messages running through the server, simply cause this wont scale very wel ...Show All

• Visual Studio 2008 (Pre-release) System.ServiceModel not showing up in the GAC

  Hi All! When I try to add the System.ServiceModel as a reference, it is not visible in the ".NET" tab of the "Add Reference" dialog. I have tried reinstalling WCF (by running install and repair of the install.exe in the WCF directory and the setup.exe in the v3.0 directory I can add the assemblies by browsing to the WCF directories and chosing them from the "Browse" tab. Any idea why this would be I believe this is causing other issues such as "Could not find schema information" for several elements. Help! thanks, Jas Hi Jas, Do you have the Orcas extensions for VS installed by chance http://www.microsoft.com/downloads/details.aspx FamilyId=935AABF9-D1D0-4FC9-B443-877D8EA6EAB8 ...Show All