Carriat's Q&A profile

• SQL Server Flat file source not option for importing data

  I was getting the product error associated with the full version of SSIS not installed so I ran the installation again and selected the Integration Services check box. Now when attempting to import data into a database, the drop down list doesn't have a flat file option. How do I import data from a txt, csv file Thanks PatrickCrofoot@hotmail.com I have. And no.. Simply using SQL Server Manageme ...Show All

• Visual Basic How do I ADD A NEW DATA SOURCE ... it doesn't work!! Why???

  In Visual Stuidio 2005 Enterprise Edition Beta 2 allows you to ADD A NEW DATA SOURCE in one place in only one way. Unable to cast COM object of type 'System.__ComObject' to interface type 'EnvDTE.IVsExtensibility'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{3C536122-57B1-46DE-AB34-ACC524140093}' failed with HRESULT: 0x80004002 (No such interface supported (Exception from HRESULT: 0x ...Show All

• Windows Forms Listbox - where's the KeepSelection property?

  Hi I've a custom listbox control where I do the drawing for the items. I'm at the end of the project and the final thing I need to do is show the currently selected row on my custom listbox when the control has lost focus. Controls eg Trees have the KeepSelection property, where is it on the listbox   Any ideas on how to implement it or get at it would be appreciated! Thanks in advance! Scott21 Thanks for t ...Show All

• SQL Server Link server error The provider did not give any information about the error

  Hi! We have a test  server (win 2003) in which MSSQL server is installed.In my system (win XP)I  installed MYSQL server ,MY sql odbc driver.Now all I want is to create a linked server on MSSQL server so that data on Both server can be in sync.When even a new record in inserted in MYSQL it should be replicated to MSSQL srvr tabl immeditely I tried to create a linked  server but every time I got this error Error 739 ...Show All

• SQL Server Displaying huge heirarchial data in reports

  I need to display huge data around 1 million records in report. Data needs to be represented as heirarchial. So there is somewhere around 6 level of grouping of data. Can somebody suggest a solution to get the data and display the data in a faster way. Thanks in advance. SSRS Hi, I don't knw if I understand your problem but you could use the document map functionnality for every level of grouping you h ...Show All

• Windows Forms passing image as parameter

  i am having an application that allows user to select an image on one form and that being displayed on other..how do i pass image to other form. Passing the path will be overload as i am already retrieving the image on 1st form thru the path so again passing path and reading again...i guess not good. // how do i pass image to other form. I'm not sure what you're asking. If you load it from disc, you could pass the path, but remember ...Show All

• Visual Studio 2008 (Pre-release) Create Events with C#

  Is there a way to create control events with C# (other than manipulating the code manually) I saw there is a way in VB, but in C#... Thanks, Neno There is no way to create control events from the designer in this CTP.  You will have to switch to Code view and add the event handlers manually. Thankfully, the IntelliSense functionality in Visual Studio 2005 makes that really easy. ...Show All

• .NET Development "Unauthorized" when calling a Web Service from ASP.NET in the same solution.

  I've got a small project, that has in it a simple web service (with the standard "HelloWorld" method in it), and a simple ASP.NET application that calls the web service. I'm using the built-in web server, and not IIS. I'm on Windows XP SP2, running VS.NET 2005 Beta2. When I added the web reference, I added it using the "Web Services in this solution" link, and everything added correctly. When I call the web service however, I get an exception w ...Show All

• Visual C# How to read exact line from text file?

  Hello again.I have one question: (example) How I can read the 3rd line from a text file and transform the rezult to string Yes, you can do this by using the StreamReader Object. include the System.IO Namespace then StreamReader sr=new StreamReader("FilePath"); sr.readline(); // reads first line sr.readline(); // reads second line sr.readline(); // reads third line check out ...Show All

• Windows Forms mysterious menus

  In my MDI main form, i have a menu of a couple of items. when i display a form from the main menu, it displays fine. when any form is active in the mdi app, and i want to show another different form from within the main  ...Show All

• Visual Basic EXE and parameters ?

  Good morning, I can not find anywhere, books or internet, an answer to this I want to create a exe that takes in 1 parameter, a string value. How do you declare this in a VB.net app Please help, its hair pulling time here. Thanks Deasun Once you use the 2005 framework, passing the parameter is easy. In your ApplicationEvents, add a handler for the StartupNextInstance event. The below code takes the Comma ...Show All

• Visual Studio 2008 (Pre-release) Data binding to runtime properties

  I'm trying to find a way to override the data binding at the point where it retreives data from a property. I'm trying to make this work with data from our propietary quote servers. I have a class that encapsulates the data retreival and updates, but the problem is that I have to map each field to a property of the data item class. There may be properties defined after the app is compiled. What I need is a way to get WPF to call an overrided ...Show All

• .NET Development IHasXmlNode and XPathNavigator

  Reading the docs on IHasXmlNode I assumed an XPathNavigator object would always implement IHasXmlNode.  The examples always use CreateNavigator() on an XmlDocument object.  I assumed this was just an example. If I use CreateNavigator() on an XPathDocument object, that XPathNavigator object does not implement IHasXmlNode.  For example: XmlTextReader reader = new XmlTextReader(@"file.xml"); XPathDocument document = new XPathDoc ...Show All

• Windows Forms Easiest way to populate new DataGridView Row with previous row values?

  I've got a DataGridView and want to populate the new row, using the RowEnter event, with whatever data is in the previous (data just entered) row. This will allow the user to simply change one field value, rather than retyping the consistent values. Other than temporarily storing all of the field data from each row as it is exited (ugh), what's the easiest/cleanest way Thanks S. I don't think you n ...Show All

• SQL Server Is there a way around using MAX Statement on Report

  I have a report that due to being unable to find a successful solution across the web relies on me using a value in a box as shown below; =MAX(Fields!budgeted_net_rent.Value) The problem I now have is that I have another field on the report and want to a =SUM on it and it tells me that you can't do that unless it is a header or footer and something about being part of an aggregate function. How can I fool SSRS into placing the value f ...Show All