Myron Walker's Q&A profile

• Visual C# how can i see the real table name??

  when i use DataAdapter to fill a dataset,but the real table name in original database has been changed,for ex: it will be changed as" table" ."table1"....and so forth.. can i get the real name of the table and how could you tell me Now I don't know what are you looking for. If you need to see the tables in database you can use system views for that, for example: SELECT * FROM INFORMATION_SCHEMA.TABLES If y ...Show All

• Visual Studio Tools for Office what is VB_ProcData.VB_Invoke_Func = "\n14"

  I made some changes in my VBA code (EXCEL-VBA) in my project as per the Specifications. After doing my changes i compared my code with the original one (The code before the changes were made) by opening my module(.bas file) in a Text editor. Compare result showed that the original code has the following code in each procedure Attribute Procedurename.VB_ProcData.VB_Invoke_Func = "\n14" The code which i made changes doesnt have the same.... Wh ...Show All

• Visual C# POPUP window accepting data

  I have created a popup app that I want called when another program opens it. C:\screenpop UUI: XXXXXXX How do I accept the UUI value into a search text field in my popup app upon openning the popup app Thanks Hi, I'm thinking what you want is to capture command line arguments. http://msdn.microsoft.com/library/default.asp url=/library/en-us/csref/html/vcwlkcommandlineparameterstutorial.asp Have a look at the tu ...Show All

• SQL Server SqlBulkCopy ArgumentOutOfRangeException

  Hi, i'm dumping a 1000 rows DataTable into SQL2005 table...and ocasionally receive "ArgumentOutOfRangeException" while calling "WriteToServer" method. Looks like the exception is being thrown at the first row (i have SqlRowsCopiedEventHandler set up with "NotifyAfter" property set to 1)...so i see how many rows have been copied. The function that builds up the table (that i'm dumping into sql2005) looks lik ...Show All

• SQL Server What are the settings to enable any memeber of an AD group to logon to SQL2005

  I have a group login created on the SQL server like so: CREATE LOGIN [MyDomain\MyGroup] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english] I have then created a user in the db MyDB for the login above and gave it db_owner role: use MyDB go CREATE USER myDBUser FOR LOGIN [MyDomain\MyGroup] go sp_addrolemember db_owner, MyDomain\MyGroup When I try to connect to this server using a user member of the group MyD ...Show All

• .NET Development WindowsIdentityMembers.LogonUser() No Documentation

  The subject method appears in sample code for WindowsIdentity.  I cannot find information about the method WindowsIdentityMembers.LogonUser() in Help (i.e. MSDN for Whidby).  The method is a real aid to developers who previously were required to do a P/Invoke to unmanaged code to obtain the token.  See code from sample... // Retrieve the Windows account token for the current user. IntPtr logonToken = WindowsIdentityMe ...Show All

• SQL Server Package dies after about 10000 seconds.

  I have written a package that archives off old orders over night, it appears that this package is failing after about 10000 second every time it is run. I don't think it is memory as I am running it and checking for memory leaks. Basic run down of package is EXEcute SQL task to get orders to delete If a for loop, loop each ordernumber within the for loop there are 2 dataflow dataflow 1 find related records in child tables (oldb ...Show All

• Windows Forms Neither TextBox nor RichTextBox!!

  Aim I would very much like a multi-line textbox which allows such shortcuts as: 1 control-backspace to delete the last word typed in front of cursor 2 control-delete to delete the last word typed behind cursor TextBox problem 1 This isn't implemented in the TextBox -- I end up with a strange non-readable character. 2 This deletes the whole line. RichTextBox Problem with RichTextBox -- I don't want formatted text in this application ...Show All

• Visual C# How To Send a Mail Using CDO 1.21 with C#

  Hi I try to write a console application in c# whichs sends a mail using CDO 1.21  (I can't use a smtp server). I found a good description for j++ ( http://support.microsoft.com/kb/216723/en-us ), but don't know how to write the cdo parts in c#. I could logon to my profile, but I wasn't able to create or send a message. I would be very happy for a code example which shows how to send a mail using CDO in C# (just a simple conso ...Show All

• Visual C# finally block...

  Hello, I'm confused with finally block...Let me explain it: what is the difference with --------------------------------------------------- try { /// throw an exception } catch ( Exception ex) { // do something } //rest of the program ------------------------------------------------------- and try { /// throw an exception } catch ( Exception ex) { // do something } finally{ //rest of the ...Show All

• SQL Server Computer Memmory Resources consumed after generate MAAS Cubes (SQL 2000)

  Dear All, I have created some cubes with Analysis services (sql server 2000 Personal edition)  After processed the cubes if I restart the computer seems like the memory resources are being consumed by the msmdsrv.exe and the msmdvldm.exe, it takes about 30 minutes to the system becomes available;  I would like to know how if theres a way to configure my OS and the MASA sides to have better response. SQLSERVER 2000 Personal E ...Show All

• Windows Live Developer Forums How to make custom text for pushpin (pulling from xml element)

  I am looking to create a custom pushpin, where instead of the default pushpin appearing, you see a rectangle with the name/title of the location. The trick is I want to pull that title from the same geo-coded xml file which is used to display the layer when you hover over.   Okay so below is the code I am working with currently. I have seen the custom pushpins used - but Im at a loss as to how to make those custom pushpins be ti ...Show All

• Windows Forms OpenFileDialog but no dialog

  I'm looking for a control och a way to make a control that is as the OpenFileDialog, but I whant it to not popup as an dialog. As any other controls you put on a form (textboxes, treeviews and so on). Any thoughts, ideas och urls ...Show All

• Visual Studio Express Editions Redistributing C# ISO

  Am I allowed to redistribute the Visual Studio C# express .ISO image by putting it on a Portal in my company (Intranet) Thanks, Marcus Visual Studio 2005 Express Editons are free-to-download and free-to- register , for the distributing I'm not so sure... ...Show All

• SQL Server SQL Server 2005 Stored Procedure inserting duplicate keys into table that is uniquely indexed

  I'm having a problem in SQL Server 2005 Developer Edition where I am calling a stored procedure to insert a row into a table. In the example below there is a table called "Machine" with three columns, MachineID, MachineName, MachineIPAddress defined. MachineID is the table Identity and pk. MachineName is setup as a unique index and can not be null. MachineIPAddress can be null - it can also be ignored for the sake of this example. W ...Show All