Gilles Lafreniere's Q&A profile

• .NET Development Bulk copy data between ODBC sources

  Hi, i want to copy data from one odbc source to another ODBC data table using ado.net Here the target database may not be MS SQL Server and therefore can't use sqlbulkcopy The source and target table have the same table definition, but might be on different data sources Pseudocode: Imports System.Data.Odbc Source Table: A DataTable dtA has the result of 'select * from A' via data adapter daA Target Table: B DataAdapter B DataSet dsB has the result of 'select * from B' via data adapter daB Target table B is initially empty, so dsB is empty Now i copied all datarows from dtA to dsB: Dim dr as new DataRow For Each dr In dtA.Rows dsB.Tables(B).ImportRow(dr) Next dsB.Tables(B).Rows.Count return a valid positive number equal to the above tota ...Show All

• Visual C# problem resizing images

  I found some code on the internet to resize an image, but when i want to resize an image to lets say 300*200 i get an image that is 266*200. I even tried 350*200 but still 266*200! This is the code: public void ResizeImage(int MaxWidth,int MaxHeight, string FileName, string NewFileName) { // load up the image, figure out a "best fit" resize, // and then save that new image Bitmap OriginalBmp = (System.Drawing.Bitmap)Image.FromFile(FileName).Clone(); Size ResizedDimensions = GetDimensions(MaxWidth, MaxHeight, ref OriginalBmp); Bitmap NewBmp = new Bitmap(OriginalBmp, ResizedDimensions); //Dit gebruiken als er geen gebruik gemaakt wordt van saveFileDialog //NewFileName = Fil ...Show All

• Visual C# Importing C++ Express project to C# express?

  Hi, I am new here and I am wondering if it is possible to import C++ express project into C# express ... Best Regards, Johney Please define "import." Do you mean have a C++ project sitting along side a C# project as one can do in the higher versions of Visual Studio No... that is one of the limitations of the Express Editions... single language per IDE, even if multiple ones are installed. Do you mean port the C++ code to C# If so... be prepared for an awful big headache unless your code is managed C++ code from the start. ...Show All

• Visual C# Windows Services

  Hi. We want to install two instances of the same windows service. We have already installed the first one but when we can't install the second one. What should we change in the setup project to allow the second installation Thanks a lot. I was afraid you'd ask that question. Personally I'd recommend that you encode it in your uninstall string during installation. During installation you should create a separate Add/Remove option for each instance that you install. When the uninstall string is created you should append a value indicating which instance to uninstall. During uninstall you'll need to fetch this value. If you want to have only one Add/Remove option for all instances then you'll need to d ...Show All

• SQL Server Asp.net session has expired

  Hi I have designed reports using SQL Server Business Intelligence Development Studio tool (Sql Server reporting service). I have uploaded these reports to report manager. I am displaying list of reports in tree view control, in my application. I am viewing report in Report Viewer control as per the report selection in tree view control, in same page. I am getting Server Error in '/Application_name' Application or ASP.NET session has expired error frequently while switching between various reports. Kindly provide me solution . Regards Sagayaraj Rayappan Hi Mark, My issue was slightly different. Because of the nature of our reporting system, users may leave a report open for a long period ...Show All

• Visual Basic is it allowed to install Visual Studio 2005 non-express editions on more than 1 PC?

  At the moment I'm using VB 2005 Express. I'm considering upgrading to the standard or professional edition. However, now I'm able to use the express version on, for example, a pc at work and a laptop at home. Does this also apply to the payed versions Note: I'm the only programmer, so only one edition will be used at a time. Regards, Eric Yes, Yes and Yes. If you want to get a definitive answer - go to the source, rather than ask a general question in a public forum. I agree completely with ahmedilyas, as I too know there are many different EULA's and licensing schemes, working for Microsoft I've seen quite a few. Many different scenarios and some will be covered, others may not, depending on the pr ...Show All

• Visual Studio how can i make crystal reports without loginID & password

  when i create a crystal report on VS.2003 to view the data in table in dataset . the report will good and work without login & pass but when i do that on VS2005 and when i run the application . the application is ask me about pass & login . and i do not now what is that and from where the application is bring that option. how can i solve this problem ...Show All

• Visual C# Whats the equivalent of __LINE__ and __FILE__ in C#

  Whats the equivalent of __LINE__ and __FILE__ in C# I thought this hot-button issue would have been answered by now. But no one seems to have a good answer for this. I would love to see a solution which presents no runtime overhead. What about C# 3.0 does it address this issue They are instructions to the compiler to replace these "constants" with de line number and filename at the place where the compiler finds these constants. Sort of a compiler directive. Usefull for debugging. Personaly I don't think they have much use in c#. ...Show All

• SQL Server SQL 2005 Server DDL Trigger Errors

  Greetings! I've been working on a SQL 2005 project, and have really been excited about the new DDL triggers. I managed to implement some database-level DDL triggers successfully. However, I keep getting an error when I try to create a server-level DDL trigger. For several of the event groups, I keep getting the following error: Msg 1082, Level 15, State 1, Procedure tr_Server_Audit_Security, Line 44 "DROP_SERVER_ROLE_MEMBER" does not support synchronous trigger registration. I can't figure this one out for the life of me. Here's a sample of the trigger I'm trying to create (BTW, this code works for database triggers, with some slight mods of course): create trigger tr_Server_Audit_Security on all server  for drop_server_role ...Show All

• Microsoft ISV Community Center Forums read line from table cell for vba in ms word

  Hi, I need to read a line in ms word table cell. There are 3 line in a cell and I'd like to read line by line and put a line in a string variable. Would anyone be willing to help me here I'm so desperate with the answer since I tried everything and none are working. What I did so far: If (Mid(theTable.Cell(caseStartRow, 2).Range.Text, 1, _ Len(theTable.Cell(caseStartRow, 2).Range.Text) - 2)) = chrs$(13) Then objFile.WriteLine ("") objFile.WriteLine ("") End If Please help. Thanks so much!! Hi Navajo, You are genius, you know! It works perfectly. Thank you so much! Would you mind helping me for this problem: http://forums.microso ...Show All

• Visual C# An unhandled exception of type 'System.StackOverflowException', how to handle this problem?

  class CreateCage (simple code, not complete) // this.cButton.Location = new System.Drawing.Point(88, 168); this.cButton.Name = "cButton"; this.cButton.Size = new System.Drawing.Size(88, 23); this.cButton.TabIndex = 3; this.cButton.Text = "Create Cage"; cButton.Click += new System.EventHandler(cButton_click); fmhandler = new Form1(); private void cButton_click(Object sender, System.EventArgs e) { string temp = fmhandler.getCstring(); MessageBox.Show(temp); fmhandler.infotextBox.Text= temp; this.Hide(); } public int getNumber() { try { number = Convert.ToInt32(inputtextBox.Text); return number; } catch(FormatException) { MessageBox.Show("pls input integer"); return -1; ...Show All

• Visual Studio C# code to export to pdf using Crystal Report

  Hi all, Does any one has the code in C# to export to pdf using Crystal Report. Thanks, J. Here is code to export to disk Report.ExportToDisk(ExportFormatType. PortableDocFormat , "C:\report.pdf"); ...Show All

• .NET Development How to dynamically change connection string in generated dataset class?

  I have a project with database classes which are generated from database objects. That is I add a dataset to the project and drag and drop a database object onto it. The problem with this is that I have to give a connectionstring which is stored in the code. This is ok while developing the application. But runtime I want to use another connectionstring, both for security reasons and because each user of the application will correspond to a database user (ms sql) and shall have a corresponding connectionstring. Is there an easy way to do this without having to restore to plain all datasets and do everything myself The name of the property you named McmsConnectionString should have the same name of the connection you are using design ...Show All

• Visual Studio 2008 (Pre-release) Customize LINQ to SQL

  Is there any possibility to customize LINQ to SQL in terms of both query and sql text translation For query customization it is possible, but what about sql text translation I hope there is not only one way to do the same thing in LINQ to SQL. Due to the use of expression trees on IQueryable, you can evaluate the LINQ query expression and formulate your own implementation to meet your specific needs. I believe at least one of the popular OR/M tools developers is working on such an implementation at this point. Additionally, they are planning a provider model that you can tie into to make your own mapping implementations. This is not a small task, but it is possible. It just depends on how much time and effort you are wantin ...Show All

• Visual C# Erro from VB.net to C#... i think this is very simpler...

  Hi ! I do this in VB.net: portaSerial.Write(Chr(header) + Chr(station_n1) + Chr(station_n2) + Chr(comando) + Chr(command_type1) + Chr(command_type2) + Chr(number_blocks1) + Chr(number_blocks2) + Chr(device_lenght1) + Chr(device_lenght2) + Chr(device_name1) + Chr(dv2) + Chr(dv3) + Chr(dv4) + Chr(dv5) + Chr(dv6) + Chr(dt1) + Chr(dt2) + Chr(dt3) + Chr(dt4) + Chr(tail) + Chr(bcc1) + Chr(bcc2)) in C#: globais.portaSerial.Write((char)globais.header + (char)globais.station_n1 + (char)globais.station_n2 + (char)globais.comando + (char)globais.command_type1 + (char)globais.command_type2 + (char)globais.number_blocks1 + (char)globais.number_blocks2 + (char)globais.device_lenght1 + (char)glob ...Show All