Andrew J's Q&A profile

• SQL Server Temp Table Problem

  I'm having a problem using temp tables in an OLE DB Source. Here's a simple example using an OLE DB Source on my Data Flow Task: CREATE TABLE #report ( report_id INT ) insert into #report select 1 select * from #report drop table #report I had to enter the SQL via the SqlCommand property b/c the component editor tries to validate the existence of the #report table, and throws an error since it doesn't exist. I also set ValidateExternalMetadata to false, set the task's DelayValidation property to false, and set the connection manager component's RetainSameConnection to true (though I don't think that would be necessary since the temp table does not need to persist outside of the OLE DB Source component). When I execute ...Show All

• Visual Studio 2008 (Pre-release) Entity Web Service: Returning Category.

  Hey there, I'm a bit of a newbie to web services, and I'm trying out the Products WebService in the WebAppSample from the August CTP. I noticed that when I call GetDiscontinuedProducts, it returns a Products.DiscontinuedProduct object, but it doesn't have a Category property. Is there a way to get this property to be returned in the result set Thanks for any help anyone can provide. :) Mike The problem here is that serialization of graphs of objects through a web service is something for which interoperable standards do not yet exist (can you believe it ). It is possible to serialize trees of objects as long as they are strictly trees not graphs, but in the case of entity relationships they are always bi-directional which ...Show All

• Windows Forms Thread to create winform instance

  I am creating a form(FORM1) in c#  that has multiple hyperlink. On Click of each hyperlink another form (FORM2) should be opened up and update picturebox value after every 100 ms. Now i want to create multiple instances of form2 at runtime for each hyperlink click and they should be running simaltaneously. Should i use threads. Or is there any other method to do that. If i need to implement it through thread. How that will be done regards     You can't use threads to start forms. Just let the LinkLabel.Click event create the form like this: namespace csforms { public partial class Form1 : Form { private Form2 frm2; public Form1() { InitializeComponent(); } ...Show All

• Visual Studio Aggregate Error

  I have a WinForms report that uses one dataset with multiple tables. The report has one table control on it. When I drag a field onto the detail section of the table I get the following expression: =First(Fields!DESCRIPTION.Value, "usmDataSet_rptPaintSpec_qRptPaintSpec2" ) I do not want to show just the "First" data value. I want to show all values for that field. But if I remove the "First" from the expression then I get the following error for the table/textbox field for this expression: Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. What am I missing here Do I need to do some type of grouping somewher ...Show All

• Architecture Architectural Considerations for Auditing

  We are building an application which connects to two kinds of database viz. one is a local database store and other is located at a central server. Now to perform auditing for every transaction I am of the opinion to do auditing at the database level. Implement it as part of trigger insertion into an audit table. Reason being its simple to implement and maintain. My Database Architect is against the idea and wants me to handle auditing at the application level. Would appreciate your viewpoints and guidance on this. Thanks Sai Hi, Basically if you see the issue from a database architects perspective , he might be correct when he does not want to use triggers for auditing. Execution of triggers ca ...Show All

• Visual Studio Express Editions How to count the number of CheckBoxes Checked

  Is there a way to count the number checkboxes that have been checked on a form and when a certain number as been reached disable any remaining checkboxes Regards LVB Yes man you can count no. of checked checkboxes... Here is the code to do it..... CODE: Dim i,count As Integer For i = 0 To Form1.Controls.Count - 1 If TypeOf Form1.control Is System.Web.UI.WebControls.Checkbox Then count++ if(count>defined_limit) ExitSub End If End If Next i With this code you can find Number of Checkboxes on your Form. ...Show All

• .NET Development Help for Storing Data From XML to Database

  I have written the following Stored Procedure for Saving data from XML file to Database where the Database is SQL 2000 select Sp_CoCode, Sp_Year, Sp_DocType, Sp_DocNo, Sp_Prefix, Sp_PkNo, Sp_Location, Sp_AdNo, Sp_DocDate From Trn_SalePur order by Sp_pkno desc Update Trn_SalePur SET XmlCol =( SELECT * FROM OPENROWSET( BULK 'C:\Test25102006.Xml', SINGLE_BLOB ) AS x ) WHERE IntCol = 1 GO I am Gettting Error As while I am trying to execute the code: Server: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'BULK'. Where My XML File contains following details: <Trn_SalePur> <Trn_SalePur Sp_CoCode="C05" Sp_Year="Y004" Sp_DocType="PU" Sp_DocNo="1418" Sp_Prefix ...Show All

• Windows Forms Error installing .Net Framework 2.0 from bootstrap

  Hello, This is my first post, so be gentle with me. I have created my first VB VS 2005 project. I have successfully published and can run the project on my machine. I am using ClickOnce FullTrust with .Net Framework 2.0. I have the project signed and the prerequiste of the .Net Framework 2.0 to be installed from the vendor's website. However, when I try to run the setup.exe to install the project on another machine I get the following error in the install.log: The following properties have been set: Property: [AdminUser] = true {boolean} Property: [ProcessorArchitecture] = Intel {string} Property: [VersionNT] = 5.0.4 {version} Running checks for package '.NET Framework 2.0', phase BuildList Error: Unable to locate file 'd' require ...Show All

• Windows Forms DataGridView column filled from lookup table column

  I have two tables Company and Status. Company has a foreign key into Status – Status is the lookup table with two columns: ID and StatusName. I need to build a DGV that will provide a read-only list of what is the Company table, plus the StatusName for each record. All DGV columns are read-only textboxes. The Dataset already holds both tables, but not the relationship between them. The DGV columns are already set up to show records of the Company table but the Status column only shows the numeric foreign key value. Any chance I can do this without a database View or a stored procedure Here’s a bit of code. bindingSource1->DataSource=dataSet1->Tables-> default ...Show All

• Visual C++ COM PORTS

  How do I get avaliable Com ports in my computer for example com1 com2 com3 or /dev/ttyS0,/dev/ttyS1 ..... (linux/windows version) Thank you for helping Hello Re: COM PORTS Such questions are outside the scope of this forum - for the scope of the VC Language forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=789657&SiteID=1 For such issues please use the newsgroups at http://msdn.microsoft.com/newsgroups . OTP Thanks Damien ...Show All

• Visual Basic Send Message Api

  I need help using the SendMessage(a) API What I need to do is send a mouse click to a windows (hWnd) that I have the handle to and the mouse click needs to be at an X and Y that I specify. I would like to use this API Declare Function SendMessageA Lib "user32.dll" ( ByVal hWnd As IntPtr, ByVal Msg As Integer , ByVal wParam As UIntPtr, ByVal lParam As IntPtr) As IntPtr but I am unclear on exactly how to fill the perameters I believe the 2nd perameter I put in a constant, WM_LBUTTONDOWN or WM_LBUTTONUP both of which I am unclear of the value for, and then 4th perameter is what will determine the x and y of the click. I am not 100% sure though. For this particular scenario, it's better ...Show All

• Visual Studio Express Editions i want to bind a dll file withe my project how?

  how can i add a dll file with my project so i dont have to put this dll beside my .exe file when i use it If you can't add reference to a dll then this means that file has nothing to do with your project and you can't use it. I think it can also mean that the DLL is not registered. ...Show All

• .NET Development Validatiom email

  Someone know where hava a example og validation of email. Thank you! This is the regex for email addresses in expresso: ([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3}) So something like if (Regex.IsMatch(string, @"([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})")) will return true if string is an email address Don't forget to put using System.Text.RegularExpressions; ...Show All

• Visual Studio Express Editions HELP WITH RTF

  How can i get my programm to add diffrent fontstyles and read the selection font out of the Font combobox en the Size combobox I need help fastt Your question isn't very clear; but the FontDialog was designed to let the user select a font or style at runtime. Drop an RTB, button and FontDialog on a form, then add this code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If FontDialog1.ShowDialog = Windows.Forms.DialogResult.OK Then RichTextBox1.SelectAll() RichTextBox1.SelectionFont = FontDialog1.Font End If End Sub ...Show All

• Windows Forms Uninstall Problem?

  Dear all, I created a msi setup in vb.net, after i have installed the application. I tried to uninstall the application. However, after the uninstallation, some of the files cannot be removed by the uninstallation. Is there any ways to remove all the files Thanks Regards George That's the default behaviour and I think it makes sense. However you can add rows to the RemoveFile table to uninstall additional files that your application creates at runtime (if you know the file names). However that table is not accessible in Visual Studio. As a workaround you could install 1-byte dummy files (again, only if you know the file name beforehand, like a log file) ...Show All