savage1965's Q&A profile

• Visual Basic Datagridview - Lookup values of foreign-key field in another table

  What's the easiest way to setup a Datagridview control with data from a database, looking up the value of forien-key fields I've gone through "Walkthrough: Creating a Lookup Table" I've tried using the dataset designer and the build query wizard to add items from the lookup table to add an FillBy query but the wizard returns a warning message of " The new command text returns data with schema different from the schema of the main query. " Any ideas Finally worked out that I can add a "unbound column" of type "DataGridViewComboBoxColumn&qu ...Show All

• SQL Server Retrieving the SQL Server error message in Error output

  Hello, I've read http://blogs.conchango.com/jamiethomson/archive/2005/08/08/1969.aspx that explains how to use scripting and ComponentMetaData.GetErrorDescription() to get the SSIS error descriptions. But this is not always sufficient. What should I do to retrieve the original SQL Server error messages TIA. -- Jerome I assume you are inserting into a SQL Server table when the error occurs. If this is not the case please advise. If it IS the case, the error message will be captured in whatever method you are using for logging. Have you configured a logging provider Regards Jamie ...Show All

• SQL Server Job generates login error

  I have a package which will run in Management Studio.  The package is saved in MSDB.  When I try to set up a job, the step errors out with what appears to be a login error.  I am specifying windows authentication in the job and also used that when creating the package. the package was recreated - I changed the encription option to 'Rely on server . . .' and changed the source path from X:\Directory\FileName to \\HostServerName\Directory\FileName . problem is solved. ...Show All

• SQL Server how to do equivalent of an outer join

  In the db, I have two tables - testcases and testresults. Test results have a field called testcaseid that corresponds to the id field in the testcases table. Not all test cases have results in the testresults table. Tests results have a field called "resultvalue" that can be "pass" or "fail". Test cases have a field called "area" that categories the feature the case belongs to. I want a pivot that shows, per area, per test case, how many failing results, how many passing results, or if the case does not have any results. I am used to doing this with an outer join in SQL. I cannot figure out how ...Show All

• Visual C++ [possebly bug] my built app is Not Responfig

  ok there is no compiler error shown and no debugger exeption either here is the code private : System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) { int r; int n; array <System::String^> ^msg={ "lol" ,name1->Text,name2->Text,name3->Text,name4->Text,name5->Text,name6->Text,name7->Text,name8->Text}; System::Random rand; n=1; out->Text= "" ; while (n!=9) { System::Threading::Thread::Sleep(100); r=rand.Next(1,9); if (out->Text->Contains(msg )== false &&out->Text->Contains(msg[r])== false ) { out- ...Show All

• Windows Forms Optimizing simple stuff

  I have made a testanimation of the good ol`bouncing ball. Its background is a solid color. Its placed on a pbox. Question: Is it any point in optimizing the painting of this setup Does it matter whether the background is filled with a single color or with something else like a gradient or pattern Does the effect of optimization vary according to what is p ...Show All

• .NET Development configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

  Hi everybody i'v try to run asimple GridView in web developer 2005 and i recive the following message: Line 10: <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"> another problem is: i can not edit users using asp.net configuration tool. thanks in advenced Ronen Y I never got an answer from anyone on this forum but found something on another forum--unfortunately I don't remember its name. The xmlns piece was apparently required at one time but no longer is. You can delete the attribute in the <configuration> tag and all will be well--except that the next time you run ASP.Net Configuration t ...Show All

• SQL Server SQL Server 2005 June CTP available ?

  Is the June CTP out, and if yes why can't I see it on MSDN Subscriber Downloads ( http://www.microsoft.com/sql/2005/productinfo/ctp.mspx ) Thank you Correct, this should work, it might also work if you just uninstall .Net and then try and install SQL Server June CTP. But uninstall both is best bet. ...Show All

• Smart Device Development can we connect internet via ActiveSync 4.0?

  Dear all, Can you show me how to configure PocketPC 2003 so it can connect internet via Activesync 4.0 with cable USB. I am using XDA IIs. Thank for your help. JT Your Internet Provider is most likely filtering traffic to Port 7 (used for Ping). Many providers only pass the important ports (like 80, of course) and     restrict the others that are often used for Security Attacks. For instance, I can't ping Google.com on my Desktop, where I have a collegue    with a different service provider has no problem pinging it. - John ...Show All

• Visual C# How to program a decision tree in C#

  please How to program a decision tree in C# and what is the easy technique thaht i'll use it to program the decision tree and calculat the weight for each node Google results ...Show All

• Visual Basic InternalsVisibleTo and VB

  High, I try to use the new attribute InternalsVisibleTo in a .net 2.0 VB project but the internal types of the "friend" assembly are not visible to the client assembly. The first assemblyInfo file contains : Imports System.Runtime.CompilerServices ... <Assembly: InternalsVisibleTo("Client, PublicKeyToken=b8adc5e85fbc953f")> where Client is the name of the assembly which needs to access the internal types of the first one. Both assemblies are signed with te same file. I've downloaded an example of a C# solution which demonstrates how to use this new feature (http://www.idesign.net/idesign/DesktopDefault.aspx tabindex=5&tabid= ...Show All

• SQL Server Importing an XML file with hirarchial data

  Hello, I would like to import an XML file containing hierarchial data into a table in SQLserver. I guess that I am supposed to use the XML source editor and connect it to the xml file containing the following: < xml version="1.0" > <VariantFamilies> <VariantFamily FamilyID="XXX"> <FamilyDescription Language="en-GB">Variant Family Description in English</FamilyDescription> <FamilyDescription Language="sv-SE">Variantfamiljsbeskrivning pa svenska</FamilyDescription> <Variants> <Variant VariantID="1XX"> <VariantDescription Language="en-GB">Variant Description 1 in English</VariantDes ...Show All

• Visual Studio Tools for Office Addin(with VSTO 2005 developed) doesn't work on Client Outlook!

  Hi all, I have developed an Addin for Outlook with VSTO 2005. It works on my development maschine without any problem. I have created a setup file from standard setup project of VSTO. I have installed the addin on other maschine ( Windows 2000 , Office 2000, Outlook 2003 SP2) . I can see the addin under options as deselected if I select it I see an error, which "AddinLoader.dll is not found c:\...\VSTO\8.0\AdinLoader.dll". Then I have copied the dll on the right location and registered it. But Addin doesn't work. What is my mistake with the setup creation Should I use an other setup program Thanks in ...Show All

• Windows Forms DataBound ComboBox Items BackColor Question

  Hi I originally posted this question in the wrong forum so am reposting here. I have a Windows.Forms.ComboBox which is databound to a generic collection, see code below: cboCertificate.ValueMember = "ID" ; cboCertificate.DisplayMember = "Description" ; ExamPreps.Win.UI.BLL. GenericCollection <ExamPreps.Win.UI.BLL. Certificate > obj = new ExamPreps.Win.UI.BLL. GenericCollection <ExamPreps.Win.UI.BLL. Certificate >(); obj.Add( new ExamPreps.Win.UI.BLL. Certificate (0, "** Please Select **" )); IDataReader Dr = ExamPreps.Win.UI.DAL. GenericDataAccess .GetReader( ...Show All

• Windows Forms Add Computed Column to a DataTable

  Hi Folks. I'm trying out the new table-adapter gizmo's and attempting to extend a dataset by adding a new property in a partial class. ************************************* Partial Public Class TipperRoundResults Partial Public Class stp_GetViewTipsDataTable Public ReadOnly Property SomeNewField() As String Get Return "Yipee!" End Get End Property End Class End Class *************************************** This seems to work fine, and when I compile it and view it in the class viewer the property exists. However I am having trouble bi ...Show All