Paril Vadher's Q&A profile

• SQL Server Custom Destination Adapter

  Hi All, I have built a custom flat file destination adapter but it appears that the code is not working. When I debug the process I notice that the ProcessInput section is called multiple times. The first time it looks like everything is working, then it call it again and there is no inpout from the DTSInput90. Why would it do this Thanks Mike Data moves down the pipeline in buffers. It is not ...Show All

• SQL Server Autosize algorithm

  Hi, I'm interested to know what the Autosize functionality is supposed to do. Obviously its supposed to size objects...but based to what The reason I ask is that I'm using Autosize on my data-flow components. On some occasions after using Autosize the full name of the component is not visible. I would have thought that displaying the component name would be objective #1 of Autosize. This doesn't just happen with components with long names ...Show All

• Windows Forms How print all record/selected record in data grid?

  How print all record/selected record in data grid pls provide any codes how to use this class.. im new here.. tnx so much ...Show All

• SQL Server Email subscription failing when report is included in email.

  Hey All, I am using SQL Server RS 2000 and I am running an issue. I create a subscription to email a report to a list of users. Everything works fine if I just setup the subscription so that a link to the report is to be sent in the email. But if I tell the subscription to include the report in the email, the sending of the email fails. What am I doing wrong Is this a known issue If so, is there a patch for it Thanks, Jean ...Show All

• Visual Basic XmlWriter: what's wrong with this code? VB.NET 2005 beta 2

  Hi, I am not sure what's going on here, but when I look at the content of Buffer in the last line I find that the first three bytes represent invalid characters &HEF, &HBB, &HBF, the forth one finally is the first character of the xml document &H3C wich represents "<". Is this a bug or is it my stupidity Dim xmlW As XmlWriter = XmlWriter.Create( "C:\test.xml" ) xmlW.WriteComment( "Test Comment" ) xmlW.Close() Dim ...Show All

• Windows Forms Url Size

  I need to calculate the total size of a entered url.  I can get the size of the html but not the images and css.  Any help would be appreciated. Thanks ...Show All

• Visual Basic Totalling the hours of a column

  I am using vb.net express and fairly new to database programming. In my program, one of the columns shows the hours worked for each employee. How do I show in a datagridview control the total of all the hours in the column mentioned above. I tried using the following sql command but it doesn't work for me Select EmployeeID,LastName,FirstName,SUM(HoursWorked) AS TotalHours From Employees       ...Show All

• SQL Server CHECKDB table exclusion ?

  Hi There I have checked CHECKDB syntax in BOL, i just want to be sure. In there no way to run CHECKDB on a user database and exclude certain tables, in SS2000. I have 2 really huge tables , over a billion rows. Nightly i want to run CHECKDB on the database but i do NOT want CHECKTABLE run on these 2 tables as it takes hours. Or is my only option to instead of running CHECKDB, writing a script that loops through user tables excluding ...Show All

• Visual C++ Manifest Issue

  I just ported the project from being a Visual Studio 2003 to 2005, and for each project I do it, I lose the manifest! Manifest is enabled in the compile process and it is commented in the resource file, but the windows are UNAFFECTED. Works fine in 2003 and creating a NEW project and using the manifest works fine. What is wrong Eretria-chan wrote: I just ported the project from being a Visual Studio 200 ...Show All

• SQL Server Using reference ReportItems! in report totals

  Why can I no longer reference fields using the prefix ReportItems! when performing totals in my table footer or a matrix e.g. ReportItems!InHouse1_IL_Consumer.Value when put in a footer field in my table produces this error in SSRS 2005 report: [rsAggregateReportItemInBody] The Value expression for the textbox 'textbox13' uses an aggregate function on a report item.  Aggregate functions can be used only on report items contained in ...Show All

• Visual Studio Express Editions Help on editing a map

  Little background: I'm trying to build a azimuth and elevation calculator for antenna pointing for tracking satellites. I've built a form which performs the calculations and displays the azimuth and elevation depending on the lat/long of the satellite antenna and satellite subpoint. Everything works great. I'm trying to work on the asthetics of the form now. I want to add a map to the form. On the map, I would like crosshairs that pinpoint th ...Show All

• Windows Forms VB.NET Inheritance

  I have an OOP question that troubles me. I have a classic 3 tier application: Presentation Layer (PRES) Business Logic Layer (BLL) Data Access Layer (DAL The PRES will quite possibly become an ASP.net project but could be windows forms. Currently The PRES has  ...Show All

• Visual C++ How to initialize an independent display using CreateDC

  I am trying to initialise a second display as an independent display on my machine using:    CreateDC("\\\\.\\DISPLAY2", NULL, NULL, &demode); but I keep getting error code 0x709. The "\\\\.\\DISPLAY2" is the string returned from EnumDisplayDevices The devmode structure has been initiailised with basic information about the display (height, width, freq, color depth) which I know works with ChangeDisplaySettings if I extend ...Show All

• Visual Studio Express Editions Treeview question #4

  Hi Back again. This question is typed boolean :) I had problems when I click on the last node of a branch in treeview. This would invariably cause an 'Object reference not set to an instance of an object.' error. To solve this, I wrapped the offending code in an 'Try...Catch exception' = No more of those errors. Question: Is doing this a 'cop out' If answer = True then why I had tried a number of other 'traps' to avoid the offe ...Show All

• Visual Basic My.Settings For Multiple Users

  Is there a convention for creating seperate My.Settings XML files for different users Example: A user logs in to my app and from there recent documents are stored in a list. When another user logs in to my app, if i pull, say, My.Settings.RecentFiles, then it returns the recent file list for the previous user. I understand the architecture and why this works this way, but is there a way to fire the creation of a new xml settings file for ...Show All