JeffLomax's Q&A profile

• SQL Server SQL reporting services 2005 with CLR

  Hi, I am trying to use reporting services 2005 with a VB SQL stored procedure that i created in visual studio using CLR. The stored procedure was created successfuly in SQL server but while linking the report to the stored procedure, i am receiving the following message "An error occurred while retrieving the parameters in the query. The stored procedure 'mysp' doesn't exist.   Thanxs in advance         A solution for me was to write a "normal" TSQL stored procedure as a wrapper. So I have SP build with CLR called "myTestClr" SP build as TSQL called "myT ...Show All

• Visual C# AxSHDocVw

  I am using .net 2005 which was upgraded from .net 2003 about 10 days ago. I did a Help.Check for Updates yesterday and now I cannot compile my project. I believe it did an upgrade of Office. In the references of the project I found that the reference to AxSHDocVw has been removed and Microsoft.Office.Core was inserted which does not have a reference to AxSHDocVw. Does anyone know a work around or where I can go to do research on this. I have searched Google and there are articles on AxSHDocVw but nothing on it being replace with something else. In the project I have the following defined private AxSHDocVw . AxWebBrowser axWebBr ...Show All

• Visual C# Send Email...

  I have been looking for a way to send email and have found many ways to do it. All of them require an SMTP server though. Is their anyway to run an SMTP server "in" my program (minimized to tray) on localhost at all times Or is their a better way, such as open smtp servers etc. Thanks. That is exactly what I said! You need a server to deliver the message. I know you don't need an email client (like eudora, outlook etc) to send the message, instead you can throw smtp commands on the server's smtp port (perhaps using telnet), after, the server will deliver the message querying (as DNS queries) for the a ...Show All

• Visual Studio 2008 (Pre-release) LINQ and SQL Server Permissions

  Hi, I have one reservation about jumping into LINQ for an enterprise application: Security. It seems (and correct me if im wrong) that to be able to use DLinq to perform insert/updates on the database, you would have to allow the database user you connect as, to have insert/update permissions on the tables in the database. This is not considered good practise at the company I work for, where we only give the user execute permissions for stored procedures (Obviously to prevent attacks like SQL Injection). I know one way around this is to override the default insert/update actions in DLinq to use stored procedures, but this takes away th ...Show All

• Windows Forms ComboxBox - DataBinding Generics

  Hi, I was wondering what is the best way to bind a generic collection to a ComboBox. The thing is that I need a key, value collection like an IDictionary rather than an IList. So binding the IList works fine but I need a ValueMember and a DataMember and I wouldn't know how to do that with an IList Before generics I used to use an ArrayList, populate it with a HashTable and bind that. However, I don't seem to get that working with generics. Anyone can help here Not the most obvious code - but the following will work: Dictionary< int , string > lookup = new Dictionary< int , string >(); ...Show All

• SQL Server data lost

  Hi, I have encountered problem in the merge replication with conflict caused by foreign key constraint. As I did some reseach that it can be avoided by increase the upload and download batch generations. My question is how can I recover the data which has been lost Thanks You can try the mscontents and the conflict tables to say if you can recover the data there if these table has not been cleaned up yet. I am more interested in how the data was lost. is there any nonconvergence between publisher and subscriber data are you using Sql2000 or SQL2005 thanks Yunwen ...Show All

• Visual Studio Add Custom wizard to context menu?

  By the time honoured method of reverse engineering the existing VC# project item wizards, I have built a custom wizard for adding a new item to an existing C# project. The custom wizard is available from the Add New Item dialog, but I was wondering if it was possible to add it to the project's context menu in the solution explorer How would this be accomplished, and is it also possible to add a sibmenu Thanks, Andrew. Hi Andrew, The easiest thing to do would be to build an addin, and programatically add a new menu/command to the Project.Add popup menu. I don't think named commands would work for you, ...Show All

• Windows Forms HTML Editor Control

  Hi, I want to give an HTML editor in my Windows Form application so the user can compose and format HTML text message (same as message editor in this forum when we compose a message) . In web application, there are many controls can do that like FCKEditor, RichTextBox, etc. Can someone point me out how to do that in Windows Form Any Free/OpenSource 3rd party controls is ok. Thanks in advance, Melinjo Hi, Lutz Roeder has one, Writer for .NET (has Writer.Html.HtmlControl inside it), you can download from his website: http://www.aisto.com/roeder/dotnet/ Here's how you can get the control to yo ...Show All

• Software Development for Windows Vista Deploying WWF Beta 2...

  Hi, I've got a problem - my workflows work on the development pc but not on the production server. I'm using WWF Beta 2, both machines are in a very similar hardware configuration. The error message that i'm getting is: "Cannot create more than one WorkflowRuntime per AppDomain". The way that i'm creating WorkflowRuntime object is as follows: public WorkflowRuntime WFRuntime { get { if (_runtime == null ) { try { _runtime = WorkflowWebRequestContext .Current.WorkflowRuntime; } catch ( Exception ) { _runtime = new WorkflowRuntime (); } } return _runtime; ...Show All

• Visual Basic System.InvalidProgramException was unhandled ???

  Can anyone help me figure out this exception I have a program that calculates some stuff, I have no errors or warnings in my program but if I click on the button to open a file on which the calculation is performed I am getting this exception. System.InvalidProgramException was unhandled Message="Common Language Runtime detected an invalid program." Source="Converter" StackTrace: at Converter.Form5.btnForcastFile_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Direct3D Screenshot?

  Does anyone know what Direct3D functions I should look at if I wish to be able to take a screenshot of the desktop. I don't really care to get the contents of my application but rather the entire desktop as it is presented to the user. I think the real question is how to get a handle to the surface that vista is drawing to. D3D itself won't have a function for that since its something that was created by vista. If you can get that handle then I suspect you can use the functions you already know to get the bitmap etc. Or maybe Vista has a whole new API for getting the screen shot. ...Show All

• Smart Device Development Where is the Blue Tooth Support?

  Is there no way to emulate the use of Blue Tooth on the Pocket PC 2003 emulator Seems the ROM simply doesn't have this capability built in at all. Was a little surprised by this. Has 2005's emulator been beefed up to allow emulation of this service I see the thread was broken 2005 and I don't know if this is the right place for my problem. I have a new HP Pav, that uses windows vista home Premium. I lost my bluetooth installed software that which I used to connect with my mobile phone for internet. I can't find a link that will download this for me. I don't know how to get it back. I am ...Show All

• Windows Forms Limit code access to certain assemblies

  How could you create a class so that some properties are publicly available to all calling assemblies and some properties are only available to certain trusted assemblies You'll need to put a LinkDemand check on your methods that you want secured. See the comments in this post for more information: http://blogs.msdn.com/tims/archive/2003/12/03/57463.aspx HTH, -Paul ...Show All

• Visual Basic I just want to learn Visual Basic.... Can't find "Windows Application' Template

  Hello all,  I am trying to re-learn programming after a long hiatus, so I decided to start with the newest version of Visual Basic(VisualBasic 2005). I am trying the 'Create Your First Application' Tutorial, and it tells me to go to File>New Project and choose 'Windows Application'. This isn't an available choice... My choices are: 'Class Library', 'My Movie Collection Starter Kit', 'Screen Saver Starter Kit', and 'Search Templates'. Am I supposed to download the 'Windopws Application' template from somewhere('Search Templates' turned up no results.) Is this my first test to see if I am worthy of using a Microsoft product Or am ...Show All

• SQL Server Help needed: Scheduling of package fails

  Hi there, I have followed the steps in BOL (not too complex really) to schedule a package in SQL Server Agent. My package reads out Data from the SQL Server and writes some log into a file. It is encrypted by a password and is stored to the filesystem. Executing the pkg via dtexec works fine. Then I've created a new job with one step via SQL Server Management Studio, added the package and password when prompted. I took the command line params and used them with dtexec: It woked. I started the job manually from SQL Server Management Studio by selecting "start job" from the context menu. But when I try to schedule the job nothing happens. The ...Show All