Dean Curtin's Q&A profile
SQL Server Simple error question?
Hello all! Working with SQL 2000. If I create a rollback trigger for a value that can not be less 0. After it rolls back, can I throw a custom error message in my .net application from SQL Thanks! When you say rollback trigger, I assume you mean doing a rollback in a trigger when the invalid data is found You can, just use raiserror AFTER you execute the rollback: --make sure to take care of case where > 1 rows are modified if exists (select * from inserted where value < 0) begin rollback transaction --because some apps will stop after the error raiserror ('No value < 0, eh ',16,1) return end However, personally I would suggest you use a c ...Show All
Software Development for Windows Vista "callexternalmethod", when does it mostly help
hello all, i want to ask about he usage of "callexternalmethod", when does it mostly help. thanks, Abssi - Miguel is right, if you want your workflow to send data to the host application it should use CallExternalMethod to send the data through Local Data Exchange service in the workflow runtime. The call is synchronous. Vignesh ...Show All
Visual Studio Express Editions How could I turn, String __gc* ,to BSTR in managed C++?
Dear everyone, I am writing a managed C++ program. I get string from a text file. The StreamReader return String __gc* data type. I need to convert the "String __gc*" to BSTR before I could put into the function "hr = pDet->put_Filename". How could I turn "String __gc*" to BSTR Thank you. CComPtr<IMediaDet> pDet; CoInitialize(NULL); hr = CoCreateInstance( CLSID_MediaDet, NULL, CLSCTX_INPROC_SERVER, IID_IMediaDet, (void**) &pDet ); IntPtr ptr; String __gc* str; if(System::IO::File::Exists("directory.txt")){ printf("The file exist\n"); System::IO::StreamReader* strd = new System::IO::StreamReader("directory.txt"); str = strd->ReadLine(); //this->dir ...Show All
SQL Server Invalid object name
The following T-SQL code generates the error "Invalid object name 'tf_1.dbo.ADX_1'". The database is attached; I can view the table in SSMS and using VB8 code but can't get this statement to run without error. What am I doing wrong SELECT t1 .* FROM tf_1 . dbo . ADX_1 AS t1 , tf_2 . dbo . ALN_1 AS t2 WHERE t1 . [DateTime] BETWEEN '2004-01-01T09:30:00' AND '2004-02-01T16: 00:00 ' AND t2 . [DateTime] BETWEEN '2004-01-01T09:30:00' AND '2004-02-01T16: 00:00 ' AND t1 . [DateTime] = t2 . [DateTime] ORDER BY [DateTime] I've actually deleted all the databases, created one central database and am using different schemas to differentiate the tables. I suspect it has ...Show All
SQL Server Pass parameter by url
Hi All: I have create a report withone parameter. Now what i am trying to do is that at a web page i have a button call report . i want to click this button then jump to the report . at moment i just simply write response.redirection("report url") can anyone tell me how to pass the parameter by using this way Cheers Nick THis would be as simple as: http://<pathtothereport>&ParameterName=SomeValue HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All
Visual C# how to disable the event of index_change of ComboBox
There are two ComboBoxes in my application with the same items and should be changed synchronized. However, whenever there is a change to the index, the programe should write data to the Serial Port...So the problem now is, when I change the index of one ComboBox, the other one will also change, however the data will be written to the Serial Port twice... private void cbFreq _SelectedIndexChanged(object sender, EventArgs e) { comboFrequency .Text = cbFreq .Text; decimal freq = Convert.ToDecimal( cbFreq .Text); if(registers.GetFrequency().ToString()!= cbFreq .Text) registers.SetFrequency(freq); } private void comboFrequency_SelectedIndexChanged(object sender, EventArgs e) { cbFreq .Text = ...Show All
Windows Live Developer Forums Newbie!
Glad to see there is an adcenter API. Looking forward to getting my teeth stuck into this. Is there a developer key required Any newbie docs that get my head around. Anything at all to get started Oh, and does this work for the UK adcenter Any help would be well received! You will need to work with your local Microsoft rep to have this discussion, as unfortunately we are still not ready for general public access to adCenter API, and therefore consider these requests on a per-customer basis. Thanks, Shai ...Show All
Visual Basic Panning more quickly
I am making a program that displays complex graphs in a PictureBox that take a long time to render. Currently I draw the graph in PictureBox_Paint. When the user is panning the view, I want to stop drawing the graphs and instead display a previous 'Screenshot' of what the graphs looked like when the user started panning. So far I've done this: Private Sub PictureBox1_MouseDown( ByVal sender As Object , ByVal e As System.Windows.Forms.MouseEventArgs) Handles PictureBox1.MouseDown Moving = True MovingImage = PictureBox1.Image End Sub Private Sub PictureBox1_Paint( ByVal sender As Object , ByVal e As System.Windows.Forms.PaintEventArgs) Handles PictureBox1.Paint Dim g As Graphics ...Show All
Visual Studio 2008 (Pre-release) Association without EntitySet/EntityRef
Hi, is it possible to implement associations between objects without using the EntitySet/EntityRef types I would like to model my business domain objects without any reference to ORM, LINQ, databases and the like. So if I have a customer objects with a list of orders I would like to have an IList<Order> property on my customer and map that as an association. Is that possible with LINQ to SQL Is it possible with LINQ to Entities Sincerely, Stefan It is possible to have a public property declared as IList<Order> that has a private storage property that is EntitySet<Order>. Use of EntitySet is required for deferred loading. ...Show All
Visual C# User can Cirumvent security
Hello all, I am working on a website which is using Forms Authentication. For example we have different Roles as Admin and LocalUsers. LocalUser cannot view the Admin Menu Items and cannot access the Admin Pages. But if the User Copies and Pastes the URL for Admin Page, while he is logged on as a LocalUser, he can see the Admin Page even though he do not have permissions to view that page. I know that we can check the Roles in the PageLoad before giving access to the Page by User.ISINRole("Admin") and if does not have that role, I can Redirect him to the Login Page. But is there any centralized way where we can do this. Or do we need to check the Roles in each and Every page. Thanks In Advance Swetha ...Show All
Windows Forms Bindingnavigator control can't add or delete the items.
Hi, I have a binding navigator control with a form. The only problem is that i can't add or delete any data. What i don't understand is that it showed when i click the + button that it is adding the row as I can see the auto increment for the id field but once i input everything it can't be saved. I re run the application or look into the database and its not there. I have tried to use sever methods like Me .BindingContext(PamsDataSet.tbl_rsl).EndCurrentEdit() but no luck. I have also tried to put the addnew property of Navigator to none and then addnew from the code like this : Me .TblrslBindingSource.AddNew() but still no luck. Infact the new MSDN library for 2005 is no help at all. When i search something it brings ...Show All
Windows Forms Leftover pixels From DrawReversibleLine
I am creating a drawing program... When I draw a line I am capturing the mouse, and drawing a reversible line, which I store and redraw (to erase the line) if the mouse moves to another point. The last line will be the the one I capture on mouse up. This works, except there are a few remaining jagged edges created during the process. They all disappear after mouse up, but they are anoying anyway. Does anyone know how to fix this When I have done this in the past against the Win32 API, it was very clean, and I am looking for that cleanliness. Do I have to use the API calls Thanks, Bob Looking at DrawReversibleLine with Reflector, I see this: SetROP2(color.brightness ...Show All
Visual Studio 2008 (Pre-release) x:Subclass
Hi, I have a user control and want it to subclass a my base class instead of System.Windows.Controls.UserControl. I figured I could use x:Subclass as follows: < UserControl x:Class = " MyClass " x:Subclass = " MyBaseClass " xmlns = http://schemas.microsoft.com/winfx/2006/xaml/presentation xmlns:x = http://schemas.microsoft.com/winfx/2006/xaml > Unfortunately, this does not work. The generated code still subclasses UserControl and (for some reason) the partial modifier is removed in the generated code. Any ideas Thanks, Kent Boogaart x:Subclass is interesting, I hadn't noticed it before. But the documentation basically states that by using it th ...Show All
SQL Server Don't Understand
I am having a problem reinstall SQL Express 2005. I had it installed, but then I unistalled it. I have tried installing it again, but everytime I do it says that the product is already installed. There is no instance of it in my Add/Remove Programs. I have read the threads that relate to this topic, but they haven't helped. I have looked at my logs of the installs, but they don't make sense neither. I just want the program installed again, or a way to get it so that I can use it. When I try to manually uninstall using msiexec.exe /x <processid> I get an error saying that the package could not be opened. This happens with all the process ids I use that I get from the log files (I have ...Show All
Visual Studio Tools for Office Handling mail item
hi all I am new to outlook programming, and i hope you bare with me. My goal is to get a copy of currently selected Email and pass it to my database When the user will opens the mail window . a dropdown should be there in the Standard toolbar . this dropdown will be populated with a list of categories from the database when user select any category. press enter. the a copy of the current mail should get transfered to my database. please let me know if it is possible , and provide ur suggestions and any code snippet of how to create a drop down in the toolbar of the mail window and handle its click event i am using c# or Vb.net in VS2005 with VSTO SE i shall be highly grateful Thanks Zubair What you are trying to do is ce ...Show All