Fabio Casadei's Q&A profile
SQL Server Importing Data from Oracle 8i/9i to SQL Server 2005 using SQL Server Import and Export Wizard (AKA DTS Wizard)
Hi All, I have become frustrated and I am not finding the answers I expect. Here's the gist, we support both Oracle and SQL for our product and we would like to migrate our Clients who are willing/requesting to go from Oracle to SQL. Seems easy enough. So, I create a Database in SQL 2005, right click and select "Import Data", Source is Microsoft OLE DB Provider for Oracle and I setup my connection. so far so good. I create my Destination for SQL Native Client to the Database that I plan on importing into. Still good Next, I select "Copy data from one or more tables or views". I move on to the next screen and select all of the Objects from a Schema. These are Tables that only relate to our application or ...Show All
Visual Studio 2008 (Pre-release) PasswordBox Databind or TextBox mask
Hi all I know we can’t bind Password property of PasswordBox because security reasons But how can i Mask a databind TextBox , (llike we do with Windows forms textBox) if don’t needed this kind of security There is no PasswordChar property (like in Winforms TextBox) to mask the textbox and hence no simple way to achieve the above. You probably have to inherit from TextBox and customize it. ...Show All
Visual Studio Express Editions autogenerate primary key
hi i have a primary key column "index" in my database and i am need this key to be auto generated starting from 1 and counting upwards . I have a datagrid on one of my forms and when the users adds a new row to the data grid , i want to the primary key to be generated automatically before storing.. is this possible arun hello thank you for the reply, i turned on the Auto increment option in the Dataset...and so i let the user add all the other columns and i want the index column to be autoincremented when a new row is added.....i tried to increment the index in a rowadded event in the datagrid....but that doesnt work cause the datagrid does not accept the row ...Show All
Microsoft ISV Community Center Forums Help with a formula
I need to write a formula for Excel that calculates the amount of fuel that is in a tank. Here is what it is for. We have cylinder tanks that lay horizontaly. Each month we put a dipstick into the tank to measure how many inches of fuel is left in the tank. I need a formula that will take that and calculate it into gallons. Here is the formula I have to work with. / -1 r - h \ V = L * | [ r^2 * cos (--------)] - [sqrt(2rh - h^2) * (r - h)] | \ r / Any Help is appreciated (BTW I am not the best at math so if possible an explination of this formula would be greatly appreciated) Hey Tiger, I ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Post-Processing Woes
I've started experimenting with full-screen post-processing after using a tutorial on Ramblings of A Hazy Mind (tutorial number 8 I believe), that lets you modify many things using pixel shaders, unfortunately I'm unable to find good examples of post-processing effects that will work with this implementation. I'm not really looking for a different way of doing this, rather I'd like to port an effect I've had trouble with into something that will work with Hazy Mind's system. The main one I've had a problem with is a Blur/Glow effect that I found on the XNA5D site, unfortunately it also implements a vertex shader which I have no knowledge of (I know very little about pixel shaders also) so I don't know how to get it to work without involvin ...Show All
Gadgets Capturing data from browser
Hello, With the new browser security is it possible to grab text or URLs and put it into a gadget Maybe via a custom right-click menu or similar Thanks, Ty Hello and thanks for the quick reply. I'd like to have my gadget be aware of what pages the user is browsing and then automatically bring bits of text, URLs, etc. from the visited web pages into the gadget. With what I see of Vista's new security, this doesn't seem possible. Alternately, I could live with having a user highlight and/or right-click over text, URLs to bring them into the gadget. Possible Thanks, Ty ...Show All
Commerce Server Failed to marshall data into the commerce dictionary
I have extended the OrderAddress class (created MyOrderAddress class, changed OrderObjectMappings.xml and OrderPipelineMappings.xml as detailed here: http://blogs.msdn.com/vkumar/archive/2006/06/28/649896.aspx However, when I start up my site and get to the point where I run the basket pipeline I get the following exception: Failed to marshall data into the commerce dictionary. For more information refer to trace logs. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Microsoft.CommerceServer.Runtime.Orders.OrderFormMarshallingException: Failed to marshall data i ...Show All
Visual C# can i write to: global::Proj.Properties.Settings.Default.ConnString
Hi, I want to create a UI for changing the connection string, how can I change the connection string because it's read only when I tried to change it Error 1 Property or indexer 'Proj.Properties.Settings.ConnString' cannot be assigned to -- it is read only Thx Edit: I'm using visual studio 2005 with c# (.NET 2.0) ok the property is readonly change it to get { return (( string )( this [ " ConnString " ])); } set { this [ " ConnString " ] = value ; } ...Show All
Windows Forms Visual Studio 2005- help required linking data
Hi all I am currently creating a form using Visual Studio 2005. The problem is no doubt very simple and easy to solve, however i have only basic knowledge of the software and need help urgently.My problem is the following. I have created a Query which looks up data from two different tables and links them i.e. when the query is run a first column of data appears showing information of "car manufacturers" from Table A. The second column then produces data of the models i.e. "Mondeo" from Table B. The data which appears in this query is linked correctly between the two different tables and all manufacturers and models match up correctly. On my form I have produced a Listbox which shows all the manufacturers fr ...Show All
Visual Studio Express Editions Qns on SQL 2005 EE, use with C# 2005 EE.
Hi, got qns here regarding SQL database. Can my program with SQL database run correctly on another com using win xp home edition, with only C# 2005 EE installed Is it compulsory for every table in a database to have a primary key Can I extract a data from a specific cell in a database table(click button get data) How do I go about doing it (the simplest n straight forward method) Many Thanks in advance. ok, I'll try my best here! the executescaler wouldnt be what you may want to go for in this case but a SqlDataReader. This is a fast forward only reader that reads the data per record (while read()) and you can get the specific column result you want on the current row by giving it the index or column name to ...Show All
Windows Forms delay in launching application
Has anyone noticed (or is it just me ) it takes almost 10 to 20 seconds before launching application from click once even after the install is complete. Does any one know why is it I created a project with nothing in it except a simple text in it and it still take 10 to 15 seconds for the windows to shows up.. I believe that the first time any assembly is loaded/run, the JIT compiler has to have its way with it once in order to get it into MSIL. But it's not just you. Provided that no changes are made to the code, or any dependent assemblies, the first run is the only time you should experience that delay. If there's a way around that, I've not yet heard what it is. ...Show All
Visual Studio Team System TF30162: Task "Populate Reports" from Group "Reporting" failed
After finally getting through the install of Reporting Services and Team Foundation Server and SharePoint I am getting an error when I try and create a Test project I'm getting an error. We have installed all of the components onto a Single Server Environment on a machine called VM-Foundation1. We have also installed an SSL certificate on the box for the URL AppDev.Company.com. All through the install we had to change various configuration files and a couple of registry entries to get all of the URLs and paths to the various parts pointing correctly and we also had to disable the Loop-Back check for Reporting Services because the certificate name is different then the name of the server. All of these changes we found on different posts ...Show All
Visual Studio Express Editions Troubles!!
I just downloaded Visual Basic. I am trying to open an executable but I get an error message that I have the wrong tools and what not. Please help and guide me on how to open an executable file in Visual Basic. Thanks in Advance. you could also use a .NET Reflector to reflect the assembly (.NET developed assembly) and view the code. Search for Lutz Roeder's . NET Reflector ...Show All
Smart Device Development Windows Authentication in Windows Form
Hi, I have C# smart device application. I want to authenticate the user at the start of the application by popping up the default login window( with username,password and domain) i.e use Windows Authentication. Is it possible to consume a Windows Authentication provider from my SmartDevice application Regards, Balambikai N P ...Show All
Visual Studio Team System Build Fails from Jan 01 2007. Versioning issue!! :-(
Is it just me, or isn't the notion of versioning defaulted to by the AssemblyInfoTask http://www.gotdotnet.com/codegallery/releases/viewuploads.aspx id=93d23e13-c653-4815-9e79-16107919f93e fundamentally flawed. Assuming major.max.build.revision. Everyone using this task, including Microsoft, seems to be using the strategy that the build number is specified to be DateString with a format of yymmdd, you get something like 061117 on the day of this post or the following if we accept the defaults: 1.0.061117.00 First of all, the actual number (since it gets converted to an integer) becomes 1.0.61117.0 when it gets compiled. Most importantly, if this was next year (2007) at this time, you get assemblyinfo files u ...Show All
