Gérard62's Q&A profile

• Visual Studio Express Editions ADC FFT

  Hi, I have this piece of code wich plot sine and cos sinusoide in picture box. But for FFT ploting I need different math functions wich will from ADC data ( 8 and 10 bit data) plot signal on graph with FFT function. (about 50-100 samples in x time). So I need some help about this and how to implement FFT in VB2005. Some simple sample for start will be nice to see. It does not to be super fast, becouse I will pick up data with ADC and then transfer data to PC throu RS232 or USB for analysis. I have look on the net , and all samples are to complex for beginners. I know that FFT is complex but I just need some point for start... Private Sub Bt_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Bt.Click ...Show All

• SQL Server Indexing on Views

  1) We have SQL Server 2005 database on windows 2003 server. 2) What about columns in functions i.e. SUM(ABS(Col1)) OR SUM(Col2 * Col3). We create a view to select these and index on view on its computed AS column Can we directly use vw1.AScol in query in place of these function expressions Will the index be picked and how will cost improvement compare with that of index on normal columns. 3) Can statistics be used in such a situation its possible to put indexes on this columns...and it will be picked .... have a look at this link.: http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx ...Show All

• Visual C# propagation of user-type objects through a webservice

  Hello, here is my problem: I have written a webservice with several methods that shall be called by a client application and return data in the shape of a user-defined type. This type contains two string arrays and some numerical information and is defined in a dll. The problem shows up when i want to compile the client; i get the error message: Argument '1': cannot convert from 'Conformity_FTP_Client.localhost.ActualDirInfo' to 'Conformity_FTP_Tools.ActualDirInfo' Here is the critical part of the client sourcecode: When you generated the proxy for the web service it also generated the type definition for your class that you are passing through the web service (RemoteInfo). Therefore when you declare an instance of th ...Show All

• SQL Server Create N rows from 1 Row?

  Hello... I have a small question about how to realize something in SSIS.   We are rewriting an Application and we will be normalizing a table. The current Table has Data in the Format: ID - Name - Type500 - Type1000 - Type2000 1  - Test - 2 -  1 - 0 2 - Test 2 - 0 - 2 - 1   The Targets would be: ID - Name 1 - Test 2 - Test TargetID , Type_ID , Date (+ ID Field omitted here) 1 - 1 - 1.1.1900 1 - 1 - 1.1.1900 1 - 2 - 1.1.1900 2 - 2 - 1.1.1900 2 - 2 - 1.1.1900 2 - 3 - 1.1.1900   So basically we need to generate N type rows for each "Count" in the Type Fields. So whats the best aproach to convert this data in an SSIS Package Currently I am thinking a ...Show All

• Visual Studio Express Editions ActiveX problems in .net

  Few active X that used to work properly, means we can easily add them to our forms , throws error when we try them to place on our forms. Even few makes the visual studio crash. I was really shocked to see even the MS studio crashing. Is there any specific reason for the same, even some errors show that since they are working with unmanaged code for controlling ActiveX addition to forms , they are crashing. One example of such a active X control is MSVSA Button Class. Please provide some input on the way to get out of the problem. Even do we have some way by which we can check if the current activeX control is licensed or not. Hi, ActiveX Licensing solely depends on the author of the Acti ...Show All

• SQL Server sp_executesql performance

  Hi All, The following is cut from SQL profiler, database is SQL 2000 SP4. Query 1 takes almost zero time and 26 reads. Query 2 takes 16 millsecs and 2862 reads and the only difference is that Query2 has parameters. I have run the query's multiple times and in different order and the results are the same. My reading of the documentation says that Query 2 should be faster due to not having to recreate the execution plan. If the execution plan is a bad one and is cached how do I remove it. Is there anyway to force a recompile or am I know in stored procedure territory. Can anyone give me an explanation as it looks like we should be changing our code to use literal's where ever possible rather than parameter substitution. TIA SQL: ...Show All

• Windows Forms cannot get the correct value after change the selected row

  in a DataGridview, the default selected row is the 1st row (rows[0]) I use the following code to change the selected row : dataGridView1.Rows[3].Selected = true; then I use the following code to get the value : MessageBox.Show(dataGridView1.CurrentRow.Cells[0].Value.ToString()); However, it still return the value of the 1st row!!! The reason is the row header pointer won't change....why and how to solve it thanks. I'm not sure at what you are trying to accomplish. As for the difference between MouseMove and DragOver: Have you actually started a dragging operation Meaning, have you made a call to "DoDragDrop" somewhere Have you set the AllowDrop property of the DataGridVi ...Show All

• Visual C++ XP-style CPropertySheet/CPropertyPage weirdness

  XP-style property sheets/pages have a graduated tint to their background, the shading going from lighter at the top to darker at the bottom. If I have a property page more than ~600 pixels high then ~600 pixels down it the shading resets to the lightest colour (and continues in that colour to the bottom of the page). Is there a fix or workaround for this Mike Hello Re: XP-style CPropertySheet/CPropertyPage weirdness Such questions are outside the scope of this forum - for the scope of the Visual C++ General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 The more appropriate place for your question is probably the MFC ...Show All

• Visual Studio Visual Studio 2005 - Installation doubt

  I've installed SQL Server 2005 Client that have installed "Microsoft Visual Studio 2005 Premier Partner Edition - ENU" with only sql server related project avaiable. Now I wanna install "Microsoft Visual Studio 2005 Professional Edition" for VB and C# projects. Is it possible or I have to uninstall the other version of Visual Studio All software comes from company's MSDN subscription. You shouldn't have any issues. They all use the same version of Visual Studio 2005. The only thing being added is new tools to the tools provided by the IDE. I have done the exact install you are talking about SQL server then VS 2005 many times and never had issue. Hope this helps. ...Show All

• .NET Development line ending problem

  Hi, I get data from an oracle database (8i) by filling a dataset. <ds.fill>. When I check the data in Oracle, the lines ends with "0D 0A"(CR/LF). When I check the data received in the dataset, the lines ends with "0D" (CR). This might be the cause of a problem I'am having right now. Does anybody know about why it appens and what can I do to keep "0D 0A" Thanks, Sylvain How did you get the result into Ultra Edit-32 I.e. how did you get it from the .NET string If you are outputting it to a file and then viewing the file, we don't know if the character is getting truncated during the file write, or if it's incorrect in the DataSet/DataReader itself. In your original post, you m ...Show All

• Visual Studio 2008 (Pre-release) mesh limitations

  Hi, just read a really interesting post here . It got me thinking about the limitations around net.P2P. That discussion was centred around a high number of messages in a network with few peers in the mesh. What kind of limitations are there in the number of nodes in a mesh Also, is there much difference in scale when using PNRP v a custom resolver regards, steven http://stevenR2.com Hi Steven, PNRP is not involved in message delivery. It is a discovery protocol. PeerChannel uses PNRP to discover other peers and establishes direct connections. These connections are used to exchange messages. >>>>>>> In my mesh i expect to have around 1000 users around the Intern ...Show All

• SQL Server Reporting Services: Subsciption E-mail Not Sending

  After setting up a subscription in reporting services you send an email and it reports that it sent it successfully, but no email is sent. It will send to a file share. Any suggestions The report is embeded in the body if you choose Web Archive format, otherwise it is attached. The format for the body is UTF-8 (I believe, going off memory here). We generally suggesting using a local SMTP to relay the messages and having RS drop the files to the SMTP Servers pickup directory. More info on configuring the email extension can be found here: http://msdn2.microsoft.com/en-us/library/ms159155.aspx ...Show All

• .NET Development to speed up database access from SQL SERVER 2005 using C#

  we have an application where while opening the application in the form load event i am creating the tabs and all the controls dynamically based on the values stored in the sql database , can anybody help me out on to speed up the data access from sql server, right now my application takes time to start up atleast 15 secs ... Like I said, unless the query is fairly complicated, then if you pre-compile the store-procedure (actually pre-compile the T-SQL in the store-procedure), then you may see the difference. But for the simple select statement, you won't be able to notice the difference of the compiled and uncompiled query. ...Show All

• Visual Basic Data conversion problem

  Hi all, I encountered some problem regarding the following conversions statements: CDbl(strInputAmt) <> (numCalculatedAmt * 100) strInputAmt <> CStr(numCalculatedAmt * 100) I wonder what's the difference between the above two statements Please advise. Thanks! TM Well you are not to discriptive of the problem you are having so I'll take some pot shots... FIrst I can only assume the following: that you are doing a comparision since you are using the inequality operator...something like If CDbl(strInputAmt) <> (numCalculatedAmt * 100) then dosomething... and that strInputAmt is user input form a textbox or other means...if this string can not b ...Show All

• .NET Development Using System.Net.Mail class to send mail.

  Hi, I was coding a class to send mail via SMTP, but I found that in Framework 2.0 you have System.Net.Mail to do that task. The classes works fine to send mail on a server that does not require authentication. Unfortunatelly, I can't get it to work on a base64 encrypted server. The process of logging in that type of server is easy, so I expect an bool attribute, let's say, "IsAuthRequired", but it does not exists. From what I've read on MSDN documentation, the way to do that is to have UseDefaultCredentials to false, and Credentials must not be null. The problem is that my code do have both these requeriments, but I still can't run it on SMTP auth servers. I've sniffed the packets sent from my app, and t didn't try to au ...Show All