Lucas Pasquali's Q&A profile

• Windows Forms how to call functions from a dll in C#

  Hi, How can I call the API functions in the dll written in C from C#.I have tried searching for information about the same but with not much luck. Can someone please advise me regarding the same. Thanks! Provided you know the function name and it's arguments (as well as it properly being exported) you should be able to use the Pinvoke functionality of the .NET Framework to call it. Take a look at this brief tutorial on the subject for more info. ...Show All

• Visual Studio Supress/Hide - UnSupress/Hide via VB/ASP

  I've got a ASP Page that give symarised sales data that went through a till. In crystal i have supressed the details leaving just a summary of qtys sold. What i want to do is have a tick box on the webpage that will unsupress/unhide the details section and display the full report showing all transactions with there ID numbers. Is this possible easiest way to do this is create a parameter for each section and pass the value of the checkbox to the report. Then do a conditional supress of the section dependant on the parameter value. ...Show All

• SQL Server difference between inner join and intersection

  Hi Can anybody explain me what is the difference between inner join and intersection I prepare a query but it shows the same results then why we need two functions like this to perform same operation Thanx-Nagu hi, we are here dealing in both cases with semi joins, where the rows from one (or both sides of the join operation, depending on the left/right/inner join proprosition) table are returned base on the evidence of existing related rows in the correlated table.. semi joins can be performed both via standard INNER JOIN, and via EXISTS clauses.. the inner join proposition requires for this the distinct clause as well like SELECT DISTINCT s.Id, s.Name FROM dbo.Students s [INNER] JOIN ...Show All

• SQL Server metadata update

  hi, I try to post a new question about metadata refresh...even if i see other thread that work on a similar problem. I have a ssis package that import an xml huge file (500 mb); These are the main step: 1) generate a XSD file against xml using xsd.exe utility 2) using xml task, make a diff between the old xsd and the new 3) if there are no difference, I start the data flow task that import xml in sql server; otherwise I stop all the task, edit the data flow task, change the xsd reference in advanced editor and then make many "double clik / OK" on every single flow.... The underling idea is that xml file change because some columns are added but these columns are not interesting for my elaboration, so i can ignore t ...Show All

• Visual Studio Team System WorkItem Attachments - programmatically

  Hello! I have my own team system website. Now I want to attach a file to a work item but I get following exception. TF26003: Team Foundation could not find the file. Check the file name and path and try again. workItem.Attachments.Add(new Attachment(fileUploader.PostedFile.FileName, txtFileComment.Text)); Regards Simon We throw that error when this returns false: System.IO.File.Exists(path) where path is the first param you send. You can check to see if that path does exist in disk, and find out why System.IO.File.Exists returns false for that parameter. ...Show All

• SQL Server Process task hangs running bcp

  We are attempting to use Microsoft SQL Server Integration Services Designer Version 9.00.2047.00 to run a BCP command from a Process task. We are able to do so without a problem when running it interactively, but when run as a SQL Server Agent job the bcp process never completes and the job hangs indefinitely. We also tried using a Script task for this, with the same result. Has anyone else run into this problem Thanks, Ron We stumbled upon the solution for this, but it does seem that a glitch in SSIS may be the root cause. When running BCP in a Process task, the path to the BCP executable must be provided. When running a package interactively a UNC path name to bcp.exe works fine, ...Show All

• Windows Forms DataGridView - dragging multiple items with left mouse button

  I'm probably opening a can of worms, but I would really like to be able to do this. Currently, I can easily drag items between DGV's. If I select multiple items by holding the CTRL button while I click, and on the last item, I initiate the drag without letting up the mouse, I am able to drag multiple items. However, if I select the last item, let up the mouse button, and then put it back down again to grab the items and drag them, the DGV selects the item that was under the mouse click. I realize this is the expected behavior; does anyone know a way to override it so that my items remain selected Now, I have a workaround that involves keeping track of the selected items myself, and if the mouse goes up and backdown and a drag begins, to r ...Show All

• SQL Server A comment about event propagation.

  Hi there! After a day of testing and playing with events in SSIS, I thought that my findings may be useful for someone. I don't remember where I read it (a blog, a book) where author claimed that SSIS event will always propagate from a child package to a parent. I also found that even if my parent had error handler, the error was propagated to SQL Agent and effectively a whole task failed when a child package failed. It was not desired behaviour. Now, I know that the author was wrong and we can have more control on event propagation. After some digging I found following pretty-well hidden variable: "System::Propagate". To be able to see it, one has to create error handler (in Visual Studio - third tab called Event Handlers ...Show All

• Visual Basic Changing System Environment variables from VB6

  Hi All, Does anyone know of a way to change a system environment variable from within a VB6 program I have tried Environ() and SetEnviromentVariable - they only set/change environment variable that are visible to the application NOT the system. The reason I need to change them is that their is inventory info stored as environment variables on the PC - when the PC is moved to a new location the Inventory info needs to change. Any help offered will be greatfully received! Thanks in anticipation. Ed These forums are for questions regarding .NET programming. VB6 is not supported here. Please see the following links for help: Useful Links Visual Basic 6.0 on MSDN Library ...Show All

• Visual Studio Express Editions LNK1104: cannot open file 'uuid.lib'

  Hi everybody, I wanted to try the rakkarsoft network library and I was following this tutorial. When I add lines of code similar to: rakClientInterface=RakNetworkFactory::GetRakClientInterface(); I get a linker error when compiling: LINK : fatal error LNK1104: cannot open file 'uuid.lib' I don't understand what I have to do. I searched on the web but couldn't find anything. Please help me if you can. PS: as you can imagine I use Visial C++ 2005 Express Edition. I also installed Microsoft Platform SDK (R2) --Actually the problem shouldn't be related to raknet because I got it also when compiling another OpenGL-based project Actually the file isn't there. Anyway it is included ...Show All

• Smart Device Development Can i create a user control for pda?

  Because i have made an userControl for pda in C# but when I deploy my project I have this error: Error 1 Deployment and/or registration failed with error: 0x8973190e. Error writing file '%csidl_program_files%\MyPrincipalProyect\system.windows.forms.dll'. Deployment and/or registration failed with error: 0x80070070. There is not enough space on the disk. Device Connectivity Component If i take off Using system.windows.forms; i can't deploy You run out of space on device. That usually happens if you have a reference to some desktop DLL by mistake so VS deploys 15-20 MB of desktop assemblies. If that’s not the case you might be truly out of space on device. ...Show All

• Visual Studio 2008 (Pre-release) Feedback please: WPF for LOB applications (Data entry/Data Viz/etc...)

  Feedback please: WPF for LOB applications (Data entry/Data Viz/etc...) Are you using or considering WPF for Line-of-Business applications What has you excited about WPF for LOB We are missing some things that would help LOB scenarios...are you waiting or doing without What is your advice for the Microsoft here What would you prioritize Please comment in the forum and/or on my original blog post ... Thanks, Rob Has Microsoft's DataGridView for WPF been released yet Is there a rough idea of when it can be expected (A MS post said a control was "being developed" back in 2006.) Thanks. ...Show All

• SQL Server Do you need 1 or 2 SQL licenses to install RS on separate web server?

  Plese help with this issue by reading and responding!!! If you install Reporting Services 2005 on a separate web server from the database engine do you need 1 or 2 SQL licenses It's a more complex issue than it initially appears to be. Please go to the following thread and read the bottom of page 1 and page 2. Please help verify this! Page 2 contains a post with 5 steps that you can perform to verify that only 1 license is actually need! http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=198900&SiteID=1 Note: Unfortunately this discussion got started in a off topic thread in the wrong category. I wrote this thread so that interested people could find it. ...Show All

• Windows Live Developer Forums a href link in Bot activity window

  Hi We have a provisioned BOT on MSN and now notice that any href link in the activity window with a target of "_blank" (i.e. outside of the activity window), does not work. Is this a limitation of our provisioning Thanks Riaan London You will need to have the "Windows" property to be true. Read the documentation for more info about the XML parameters. ...Show All

• Windows Forms Insert by Data-Adapter...

  Hello All, I'm facing some problem when i insert any data to a table by using data-adapter. I've a table named "Campus" and it has three colums those are - CampusNo - Location - PhoneNo now i want to insert one row into that table...thats why i wrote.. RMSDataSetTableAdapters. CampusTableAdapter camAdap = new RMS.RMSDataSetTableAdapters. CampusTableAdapter (); try { camAdap.Insert(3, "Temp" , 123); } catch ( Exception ee) { MessageBox .Show(ee.ToString()); } but unfortunately this code is not working. even i didnt get any exception. then i did the same things with another table, but same things are continued someone please help me to find out my mista ...Show All