Gurmeet's Q&A profile

• Windows Forms Install multiple Instances of Windows/Web Service on single machine

  I am using visual studio 2005 setup project for my application deployment. I want to install multiple instance of my application on a single machine by using installer. That is each time I ran installer, a separate instance of application should be installed (with different path & name, as I giving during installation) . My application consists of windows & web service component. I want multiple windows n web service instances installed on single machine. Note: If I run my installer 2nd time (either for windows or web service), it over writes previously installed components settings... (like for web service, if I run installer 2nd time, it override previously installed web service settings, virtual directory paths etc.) Can any ...Show All

• SQL Server Buld Data load import

  HI I have a table XYZ that needs to contain a million records as operational data. XYZ has a column named SLOT_VALUE which has values 1,2,3....100,000 What is the easiset way to bulk load this information in the shortest possible time... Insert scripts/ Batch program like if..while loop takes heck lot of time.... Guess the easiest is to have t-sql script using a while loop...I thought of bcp but then I need to create a file...that would be redundant... Anyhow thnx for the post. ...Show All

• SQL Server Printing a Linked Report in Landscape

  I have a report that is setup to print landscape. I deploy to Report Manager, print it, and everything works great. If I create a linked report from the deployed report, the linked report prints portrait. Does anyone know of a workaround or am I just doing something wrong Thanks!! BobP I have posted a bug at Connect. Please vote... This is an irritating issue. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=253208 Thanks BobP ...Show All

• .NET Development ADO.NET - Trying to copy a table from one DataSet to another

  I'm currently working on a program which merges multiple data sources together before presenting them to the user. The data sources are mostly Excel workbooks, and I'm using the OLEDB pieces of ADO.NET. I can't use Excel interop, unfortunately, due to IT restrictions. I've written code to create a temporary Jet database, but I can't seem to copy data from the "source" Dataset (which is just a copy of the Excel data) to the "target" Dataset. Or rather, I can, but I can't seem to make those changes be reflected in the temporary database -- I can fill the Dataset, but I don't see a way to update the data source with that new data. I've looked through the ADO.NET documentation but can't seem to find an answer. Does anybo ...Show All

• Windows Forms How to show the changed Text while loading?

  Hi! at time-consuming processing in reading data etc, how to show a Label such as loading into the following codes, the character "Loading" cannot be seen. private void loadDailyButton_Click(object sender, EventArgs e) { titleLabel.Text = "Loading"; da.Fill(ds); titleLabel.Text = "Loaded!"; } what code do I have to insert here Look at using the BackgroundWorker class to perform time-consuming operations. 1. Add a BackgroundWorker to your Form. 2. From your Button_Click eventhandler, update your Label.Text property ("Loading"), then call the DoWork eventhandler of the BackgroundWorker. 3. In the DoWork eventhandler, call the ...Show All

• .NET Development problem with WCF and APP.config

  Hello, I have a problem with WCF: I used the classic example from the VS 2005 Template: the solution with 2 projects 1. WCFServiceLibrary project for the service, which contains [ServiceContract()] public interface IService1 ... and public class service1 : IService1 { ... 2. my Host (console application) If I do not use an App.config file everything works fine: [CODE] static void Main(string[] args) { Uri adresse = new Uri("http://localhost:6666/demo"); ServiceHost sh = new ServiceHost(typeof(WCFServiceLibrary.service1), adresse); sh.AddServiceEndpoint(typeof(WCFServiceLibrary.IService1), new BasicHttpBinding(), adresse); sh.Open(); Console.WriteLine("press Return..."); Console.ReadLine(); sh.Close(); } [/CODE ...Show All

• SQL Server Invalid Character in Flat File or Turncate problem

  My source is a csv flat file. Currently I use that same flat file on SQL 2000 and SQL 2005. On SQL 2000 it runs fine and it inserts that character as part of the string (varchar), however, it gives me truncate error on sql 2005. I already use the "Suggest Types...." and my Output columns have the correct lenght (specially that lehght of that column is only 30 char which is less than the default anyways). If I remove that character it runs fine for that column..... This is the values that I get in my flat file for the trouble coulmn is "ATTN: JON OLSEN a€“ CTRL8 " And the error that I get when running the SSIS is [Flat File Source OrderDetail [1]] Error: Data conversion failed. The data conversion for ...Show All

• .NET Development Save loaded assemblies in AppDomain to file

  Hi, I was wondering if the following is somehow possible: I'd like to get certain assemblies in an AppDomain and write them to file, so they can later on be examined with reflector or similar Thanks, Tom Hi, no this is not what I'm asking. The assembly that I'm loading is not loaded from file (well, it is but via a native wrapper from an encrypted binary). So, what I need is to dump the whole memory loaded assembly to file. Thanks, Tom ...Show All

• Smart Device Development "The remote server returned an error: (500) Internal Server Error."

  Hi, I am trying to yahoo.com a website using c# from my pocket pc device. when I ping the intranet site, I gets the response, but when I pings any external (public ) site I gets "The remote server returned an error: (500) Internal Server Error." error message . Here is my code sub main() { IsNetworkPathAvailable("http://YAHOO.COM"); } public bool IsNetworkPathAvailable(string destinationAddress) { bool connected = false; HttpWebRequest request = null; HttpWebResponse response = null; try { request = (HttpWebRequest)WebRequest.Create(destinationAddress); request.Proxy = new WebProxy("proxyservername", true); request.Credentials = CredentialCache. ...Show All

• Windows Forms DataGridView Control replacing certain values with a string

  I have a datagridview control which uses an array of class objects as its data source. Is it someway possible to set it up so that certain values in the data are shown differenty in the control. What I actually want to do is when the value is -1 show either nothing or a dash. Cheers, Gareth Hi Gareth, you could use the CellFormatting event for formatting your original data, something in a way of: private void dataGridView1_CellFormatting( object sender, DataGridViewCellFormattingEventArgs e) { // You can adjust the column/type/value checking here, according to your needs if (e.ColumnIndex == 1 && e.Value != null && e.Value.ToString() == "-1&q ...Show All

• SQL Server Reportingservice2005 is not defined, Please how to webreference it

  I have rs2005 on my machine, how can i do the webreference to Reportingservice2005.asmx Dim rs As New ReportingService2005 I am getting an error when i am using the above dim statement, it says reportingservice2005 is not defined. Please help thank you very much. Where are you calling the web service from If it's from a VS solution (Web or forms) then you need to add the web reference there so it can create the proxy file. ...Show All

• Visual C++ re help!

  i have this error lnk 2019 how to fix it Linker error 2019 indicates that you are trying to access a method which can't be found in any of the libraries the linker has been notified of. This is generally a method you have declared yourself, but forgot to define, or an import from e.g. the win32 api, whose implementation library has not been referenced. If you could paste the actual linker error, it would be easier to pinpoint what your actual problem is. ...Show All

• SQL Server Activation not working

  Hi There Everything works 100% until i activate my sp. I specify to execute as 'dbo' in the alter queue statement. I also define the activated sp to execute as 'dbo'. But i keep getting permission errors from my activated sp. i have tried to excute as 'sa' , i have even tried to write a job that excutes to stored procedure but it also get weird errors. Bottom line if i exceute the sp in management studio logged in as sa it works , but thorugh activation or a job nothing works, as 'dbo' or 'sa'. Thanx Hi Remus Lastly, it also mentions in Roger Wolters book that if you do not stipulate execute as for your activated sp it will execute in the backgrouond as a sysadmin. However if i do ...Show All

• SQL Server Tricky Query

  I have a data table like this: MachineID Product Sales ------------------------------- 1 Magazine $20.00 1 Drink $30.00 2 Drink $30.00 3 Magazine $30.00 3 Drink $40.00 4 Magazine $30.00 5 Food $40.00 5 Drink $30.00 6 Drink $40.00 One of the reports the user needs to see looks like this: Product Number of Machines Total Sales Magazine/Drink 2 $120.00 Drink 2 $70.00 Magazine 1 $30.00 Food/Drink 1 $70.00 To clarify: There are two magazine/drink machines (ID 1 and 3) There are two drink only machines (ID 2 and 6) There is one magazine only machine (ID 4) There is one food and drink machine (ID 5) How do I do this quer ...Show All

• Microsoft ISV Community Center Forums use inputbox to choose cells for plots in excel

  Hi all, The below code would I like to change so I can use the inputbox arrays 'usr_choice_x' and 'usr_choice_y' (instead of the range "A68:B89" as it is now) for the plot. How do I do that Grateful for ideas usr_choice_x = Application.InputBox(Prompt:="Select x cells ", Type:=64) usr_choice_y = Application.InputBox(Prompt:="Select y cells ", Type:=64) Charts.Add ActiveChart.ChartType = xlXYScatterSmoothNoMarkers ActiveChart.SetSourceData Source:=Sheets("MDO_061013_LHS_HP").Range( _ "A68:B89"), PlotBy:=xlColumns ActiveChart.Location Where:=xlLocationAsObject, Name:= _ "MDO_061013_LHS_HP" With ActiveChart .HasTitle = False .Axes(xlCategory, xlP ...Show All