Pete Orologas's Q&A profile

• Visual Basic Stupid question....How do I instantiate a form from another form?

  I'm very new to vb.net. Just wondering how I can start up another form from another form's button. Thanks, and sorry for the newbie quiestion. You just must declare a new form variable and call to the .Show() method ;) Form2 MyNewForm = new Form2(); MyNewForm.Show();   Regards. PD: I'm sorry, i don't seen that this is a VB.NET forum, but i think that you understand the replie :) ...Show All

• .NET Development Export/upload Data from excel to access 2003

  Haiii... How the method Upload/export Data From Excel to Access 2003 use VB.Net Please anybody help me.... Thanks Jebat I've try your idea but when i run the program, and then show message error like that "Unrecognized database format 'C:\jun\My Data\JMb\Bin\contoh.xls' Can you give me the method for view data from excel to datagrid Thanks Jebat ...Show All

• Visual Basic DateTime and TimeSpan values

  hi, any idea on how to define a variable as DateTime and then initialize that value as zero, none or null same goes for TimeSpan. i'm currently working on some code calculating date differences and timespans so i'd appreciate the info. thanks dave Hi Dave, You can use Nullable Types. These types represent all the values of the underlying type (like DateTime), and an additional null value. Reference: http://msdn2.microsoft.com/en-us/library/2cf62fcy.aspx Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• Visual Studio Express Editions VS Hanging

  Whenever i try to debug my application, Visual Studio Express passes after the compilation, and then nothing happens. After a shrot while a message appears telling me to wait, and if VS is waiting on another program, would i like to go to it. This has me perplexed, as i have no idea what is going on. I was not doing this constantly though so i continues with my coding, but toaday when i went to compile it, it complained of managed code trying to be executed in an OSLoader lock. I now I did not muck up my code, as all I removed was a single COnsole.Write Line command.The code generating this was in one of the files VS had generated for me. Any help in fixing this much appreciated, Mike It was the automatica ...Show All

• SQL Server Properties of a Report Error when selecting Execution

  When I select execution I get the following: "Everything is fine in my dev enviroment in the production is where I get the error." An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors Details Event ID: rsInternalError Source: Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings We're sorry There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base data ...Show All

• SQL Server How to configure Smo.Scripter to get desired sprocs

  Hi, I've developed a sproc generator using SMO types and all works fine except when I want to generate sprocs prefaced by a drop statement. To do this I create an instance of the Scripter object and set it's options.ScriptDrops property to true ( instance.options.ScriptDrops = true). When options.ScriptDrops = true the output omits the actual stored procedure from the scriopt. When I comment out scriptDrops = true it works correctly. How do i get it working correctly WITH drop statements Example:  private void CreateScripter() {             if( this._SprocSscripter == null ) {             ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. user clip planes

  Hi all-- I posted this small question in the XNA framework forum, but got no response so I'm trying my luck here ;) I'm trying to add a clip plane to my scene, but this needs to be unprojected to world space first. This used to be done with the Plane.Transform method, which seems to be missing. Has anyone found a way to use clip planes in a 3D scene I could settle with a VS clipping all points on one side of a plane to their projected position on the plane, but this will give texture stretching artifacts, and simply feels bad. In the meantime, this post might be some help. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1003113&SiteID=1 ...Show All

• Visual C# How can I call C function in VC#2005? Please do me a favour, for example

  I will call MyLogin() in my C#, how to deal with LPTSTR, pointer, and Struct. TOKEN_CONTEXT is a struct which was pass to MyLogin(). Thanks. --------------------------------------------------------------------------------------------------------------------------- unsigned int __declspec ( dllexport ) MyLogin ( unsigned long int * pSlotID, LPTSTR pName, // file name or for boot code: the data unsigned char * pData, // The data (if applicable) int dataLen, // dataLen (if applicable) unsigned long int userType, LPTSTR pPin, unsigned long int ulPinLen, unsigned long int sessionFlags, // we may need RW_SESSION flag here.. unsigned long int * pSession, TOKEN_ ...Show All

• Visual Basic adding handler to a button generated at runtime

  everytime I try to add this code: AddHandler btnLogin.Click, AddressOf mybutton_click it gives me the following error: name 'mybuttom_click' is not declared. Here is the code that I am using to create the button: Imports System.Drawing Module formsLogin Public Function loginForm() Dim btnLogin As New Button With btnLogin .Location = New Point(55, 75) .Text = "Login" .TabIndex = 3 End With Dim btnCancel As New Button With btnCancel .Location = New Point(175, 75) .Text = "Cancel" .TabIndex = 4 End With D ...Show All

• Visual FoxPro Deleted -SQL HELP

  I am having trouble with a form i created. It is a form with a grid of an email address book - table. I want to the user an option of deleting names from the grid/table and it works fine when i "Set Delete On" and test it. But when I implement it into the program and call the form from a main program it gives me an error that says "Deleted variable not found". any suggestions this is the code for the command button that deleted the record: select emailaddressbook DELETE FROM emailaddressbook where idemail = temp thisform.grd_Email.Refresh like i said, it works stand-alone Hmm, I am not sure where it is coming from, but I would start over with a fresh form and copy and paste from the ...Show All

• Visual Studio The symbol file assembly.pdb does not match the module

  Hi all, I'm having a problem with debugging -- symbols for my assembly are not being loaded. Long story short, I'm writing a WSS 3.0 workflow and deploying it on a remote SharePoint server. So far everything is OK, and the workflow runs. To debug the workflow, in theory, what I need to do is to attach to the ASP.NET process on the server (w3wp.exe). From there, I should be able to debug the workflow code. In practice, what happens is that VS complains about symbols not being loaded, and I'm not able to debug. My workflow assembly is being loaded -- I can see it in the modules window. However, for symbol status, I get `Cannot find or open the PDB file'. If I go through the symbol load information, I get this: C:\WINDOWS\assembly\GAC_MSIL\S ...Show All

• Windows Forms DataGridView CurrentCell jumps to wrong row

  Hi I have a datagridview (unbound) in my application which is used to display information about a certain part. The datagridviewcell containts the following columns: PartNo Family Description Quantity Price Total Price. The datagridview has allowuserstoaddrows set tot true. Only the PartNo and Quantity columns are editable. As soon as the customer has filled in a partno the application fills the other cells with the data of the partno (this is happening in the endedit event). When the cells are filled the currentcell should jump to Quantity. This is where the problem occurs. The datagridview jumps to the right column but in the empty row at the end of te datagridview. There is no problem with loops or anything ...Show All

• Visual C++ Capture virtural keys in textboxes

  Question: How to capture virtural keys like VK_F1 or VK_F3 in a textbox that has keyboard input focus. Thanks...     JamesSexton wrote: Thank you Axe22, but I have already tried your proposed solutions and they failed to work. In the meantime I found a possible solution in the GetMessage(&msg) loop before it goes to TranslateMessage(&msg); and DispatchMessage(&msg); There you can capture a WM_KEYDOWN message before it goes to a TextBox no matter what key the user entered. The only problem is knowing which or what TextBox the messsage was sent to. In the case below there are 2 global windows, 1) the global parent window called "ghWnd" and 2) its child textbox window called "ghActive ...Show All

• SQL Server mysql limit equivalent

  Hi, I need the equivalent for below mysql query : select *from test limit 5, 20 I know that the below is possible in SQL Server : select top 20 * from test where column1 not in (select top 5 column1 from test). But my problem is I want a generic solution wherein I will not be aware of the columns available within the table. i.e I need a equivalent query without using any of the column names Please advice on the sql server 2k syntax, if an identity is already part of the return columns in t, then you cannot introduct another identity into the table. How do you work it in that case then ...Show All

• SQL Server Where to use SQLCLR ? Data access is not recommended?

  Just wondering which scenarios is suitable to use SQLCLR. Any kind of data access is not recommended I guess. Only things that cannot be easily done in TSQL should be done in SQLCLR but why Can't those things be done in app layer itself Scenarios recommended for SQL CLR: - External data access like filesystem, registry etc - Complex calculation - Recursion without data access (this can be implemented with CTE for data access) If data access with SQL CLR is not recommended why should CLR should be even used and logic reside in database layer.. it makes no sense to me. Any thoughts Whoa!!!  No!!   Sorry for the violent reaction, but I needed to get your attention!&nb ...Show All