Mohammad hOque's Q&A profile

• SQL Server Sql Server 2005 Reporting Services - Printing Direct

  Can You give an example of how to print a report from a Visual Studio VB winforms project using a button labeld print We would like to print the report using Sql Reporting Services without having to view it first in the report viewer. This report will need some parameters passed to it. We als need to be able to view the report with parameters passed to it automatically. Can you help with some examples See the thread called: HOW TO: Print a report directly to a printer It contains all the code you need. ...Show All

• .NET Development WebClient with Progress bar

  I am writing a small application which allows user to enter an URL then download a file on the net. In addition, I use the progress bar to show the downloading status. These code as below using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Net; namespace DowloaderProgress {     public partial class Form1 : Form     {         public Form1()         {             InitializeComponent();         }      &n ...Show All

• .NET Development How to access COM+ remotely using .NET Remoting?

  Hi All, How can we access COM+ using .NET Remoting I tried to find a reference guide on this but I did not get any. Can anyone guide me Best regards, Imesh http://msdn.microsoft.com/library/en-us/dndotnet/html/comwscheckb.asp frame=true ...Show All

• SQL Server DTS drawbacks

  I am trying to compile a case of why DTS packages need to be migrated to SSIS packages. Is there any document, whitepaper which can provide me drawbacks in DTS Thanks, Vijay. Vijay Thirugnanam wrote: I am aware of new features in SSIS like control-flow, data-flow demarcation, new transforms like SCD etc. But knowing some drawbacks in DTS like performance, scalability, support for XML can help. If there is any inputs on specific drawbacks in DTS as compared to SSIS, it will be helpful. SSIS performs and scales better than DTS by an order of magnitude. As opposed to SSIS, DTS very much relies on the staging of data in order to transform it into something suitable for populating a data ...Show All

• Windows Live Developer Forums Custom Pushpin functionality

  Is it possible to load my own detail bubble, and also choose which side of the pin the bubble will be on To the right of my map, I've got a form that I don't want the bubble to lay on top, or below in the case of select elements. Also, below my map is a list of properties that the pins correspond to. I would like an onmouseover event to fire and open a detail bubble when rolling over any of the properties in my result that is below the map. Is this possible Thanks. ...Show All

• SQL Server Read CSV file - Save Columns into rows

  I want to import CSV file and convert columns into rows depending on Customer count(2nd record in each row of CSV file) and save to SQL table --CSV file format State, Customer_Count, Name_1, Total_1,Name_2, Total_2,Name_3, Total_3..can go upto 350 GA,2,'John Doe',14.00,'Roger Smith',15.00 FL,3,'John Doe',14.00,'Roger Smith',15.00,'Sally Cox',16.00 SC,5,'John Doe',14.00,'Roger Smith',15.00,'Sally Cox',16.00,'James Brown',17.00,'Rick Davis',18.00 Data in SQL table from csv file should look like this State,Name,Total GA,John Doe,14.00 GA,Roger Smith,15.00 FL,John Doe,14.00, FL,Roger Smith,15.00 FL,Sally Cox,16.00 I have multiple CSV files with millions of records. How can i achieve this using Integration Services or Bulk Data I ...Show All

• Visual Studio Making pdf default export format in crystal reports

  Hi all we are using the crystal reports that comes with Visual studio 2005 for developing a c# windows application. we need to make the pdf the default export format for report. can anyone tell me how this can be done. Thanks You set the export options in the report setup before you submit the report for output in the format: 'crreportdocument.ExportOptions.ExportFormatType=CrystalDecisions.[Shared].ExportFormatType.PortableDocFormat 'crReportDocument.ExportToDisk(CrystalDecisions.[Shared].ExportFormatType.PortableDocFormat, "path\filename.pdf") ...Show All

• .NET Development asp.net

  HI: I just loaded vb.net ans attempted to run asp.net. I get the error that asp.net 1 is not installed, when I check, IT IS the correct version.Ran the executable in IIS, No Help Any ideas out there if you are sure asp.net is installed you may need to register it in IIS.... just run this in Visual Studio Command Prompt aspnet_regiis.exe -i Rgds Rodrigo ...Show All

• Visual Studio VSIP

  Hello, Does VSIP is providing any support for hadling clicks on windows or dialogs I want to get control of the SaveAs dialog before clicking OK on it. Can i retrieve data from fields on SaveAs dialog Kindly help me out. Regards, Ruhina Parveen Hi Carlos, I want to retrieve the file name before saving it on disk. I tried to handle File rename event in order to get the name, But it is already saved before File rename event. Actuaaly i am providing some fuctionalities while saving a file according to its location and extension.But before i can get the full path my file is already saved. Thanks , Ruhina. ...Show All

• SQL Server Working with Matrix - BGcolor & hide column

  Hello, I have a matrix in my report (rs2005). I added a "subTotal" column to the matrix (by right clicking on a column and chose "subtotal" from the popup menu). Now i want the column to be colored in blue but i can't do it. I can only select the header color (where i'm writting "TOTAL") but the rest of the rows in that column isn't blue. also, i added a subTotal Row and only the first cell is blue. How can i fix that second - i have a column on the left of :name,age,number. I want the "number" column to be hidden. I tried to use "VISIBLE=HIDDEN" but it just make it white and not invisible. ideas Thank, Roy. Hi Roy If you look closley in the top right ...Show All

• SQL Server CREATE ASSEMBLY error: could not be installed

  I ran the following: CREATE ASSEMBLY A3rdPartyDLL FROM 'C:\Program Files\3rdPartyComponents\3rdParty.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS and got the following error message: Assembly 'A3rdPartyDLL' could not be installed because existing policy would keep it from being used. How can I change the 'existing policy' Often times the problem being reported really means this: Assembly 'A3rdPartyDLL' or another binary that A3rdPartyDLL depends on or uses could not be installed because existing policy would keep it from being used. So, first check on what else 'A3rdPartyDLL' needs. It's "all or none" in terms of the GAC knowing about a set of interdependent files. good luck ...Show All

• .NET Development Creating a Search using VB.NET and SQL

  Okay, I have ran into a problem with my Search engine for my database i created in VS.NET (phonelist.mdf). I have an <asp:GridView> setup for the results. I have been trying to read up on SQL and implement my own search but here is what i am running into. I launch the program and it runs fine until it gets to MyCommand.Connection.Open() . The error is InvalidOperationException was unhandled by user , The ConnectionString property has not been initialized. Here is my code for the search. <% @ Page Language ="VB" AutoEventWireup ="false" CodeFile ="phonelist_search.aspx.vb" Inherits ="phonelist_search" %> <! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 T ...Show All

• Visual Studio Team System Data Compare - Next button grayed out

  Trying to a Data Compare. After I select my 2 data sources, I go to the next screen where I select the tables/views. I can select all tables or select individual tables, but no matter what I do the Next button is grayed out. Clicking the Finish button just closes the wizard without doing anything. What am I doing wrong I am running the initial CTP that was distributed at Tech Ed. The tables do have primary keys. I de-selected all but this 1 table (ddl below), but still can't click Next. I can click Finish, but that does nothing except close the wizard. CREATE TABLE [dbo].[tb_Year] ( [ID] [bigint] IDENTITY (1, 1) NOT NULL , [Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [ ...Show All

• Visual C# error with checkedlistbox

  Hi i put this code in event handler itemcheck for checkedlistbox but when execute there is error : An unhandled exception of type 'System.StackOverflowException' occurred in System.Windows.Forms.dll how can execute this code without error thanks if ( Control .ModifierKeys != Keys .Control) { return ; } bool shouldBeChecked; //Determine the box's current state and use to set variable to define desired state if (e.CurrentValue == CheckState .Checked) { shouldBeChecked = true ; } else { shouldBeChecked = false ; } //Prevent check change to current item from happening e.NewValue = e.CurrentValue; //Itterate through each item's index and set each item to the des ...Show All

• Visual Basic Code Compilation at Runtime?

  Is it possible to write a program that generates code at runtime, then compiles it into a DLL The property GenerateExecutable Set to FALSE will compile to a class library. The help explains a lot of the methods and functionality: play with it a bit. ...Show All