readme55555's Q&A profile

• Visual C# Converting System.Type to OleDbType

  I can`t find class and methods that convert System.Type to any of dbtypes(OleDbType or SQLType). I know for the mapping tables, but I need conversion methods for all data providers(OleDb, SqlClient, ODBC) . It is not difficult to write that by your own, but I can`t belive that it is not alredy written by Microsoft. missa wrote: I can`t belive that it is not alredy written by Microsoft. Yes, indeed, Ms has provided data readers with methods like follows: Use reader.GetInt32, reader.GetBoolean, reader.GetDecimal, etc. ...Show All

• SQL Server Can I create table with constrains in SMO?

  Hello Guys, I m new to SMO thing. Just wonder if we can define data constrains in SMO for tables Cheers, Elton I wrote a tutorial on how to create a table in SQL Server using SMO . This may get you started: Create Table in SQL Server 2005 Using C# and SQL Server Management Objects (SMO) - Code Generation Regards, Dave ...Show All

• Visual Studio Tools for Office Disable save alert in Excel

  When the user exits my VSTO workbook, I want to disable the save alert "Do you want to save the changes you made to xxxx ". Is there a way to do that I don't want to disable all alerts, just this one. Thanks! I set the Saved property to true in the event handler for BeforeClose, and that did the trick! ...Show All

• Windows Forms how do you pass a text string to a windows form text property

  ok here goes i have a form text property =form1 i have a control on the form textbox as i enter text into the control i want it to display on the from title ie the text property of the form how do you do that c# visual studio 2005 neewbie All you need to do is to handle the TextChanged event of the TextBox object and set the Text property of the TextBox to the Text property of the Form object. public partial class Form1 : Form { public Form1() { InitializeComponent(); this .textBox1.TextChanged += new System. EventHandler ( this .textBox1_TextChanged); } private void textBox1_TextChanged( object sender, EventArgs e) ...Show All

• Visual Basic Encryption - Storing Private keys

  Hi, I'm building an application to handle licensing some software i'm writing. I'm using the RijndaelManaged cryptography objects to encrypt an decrypt the license codes and database login info etc. At present i have the Key and Initialisation vector values stored as byte arrays private to my cryptography class. The code works fine. The problem is that when i use a decompiler on my dll the Key value byte array is fully visible, along with my Encryption and Decryption methods, thus rendering the security useless. My question is how do people actually store the Key value so that no one has access to it. I can't find any mention of how people actually do this, only how to use crytography once you have the key. I'm almost tempted to g ...Show All

• .NET Development strange problem with loading an assembly using custom AppDomain

  I'm trying to load assembly files using a custom class, which was created through a custom AppDomain. Here's my Main code block: AppDomainSetup setup = new AppDomainSetup(); setup.ApplicationBase = @"C:\test"; setup.ApplicationName = "test"; setup.PrivateBinPath = "bin;plugins"; AppDomain domain = AppDomain.CreateDomain("MyDomain", null, setup); General.Loader load = (General.Loader)domain.CreateInstanceFromAndUnwrap("Loader.dll", "General.Loader"); Type[] types = load.LoadAssembly("TestObject"); All this does is setup an AppDomain and point it to "c:\test" and then I set the assembly folders it should look for when loading an assembly. The General.Loader cla ...Show All

• Visual Studio Team System Changeset for files from different folders

  Hello! I have a .net 2.0 developer who has checked out about 25 files from different folder locations within one Team Project in TFS. He has another situation where working on one project file in the solution creates many html files, etc (Not in source control). Now, when he checks in his changes, the pending checkin window lists all the files he checked out plus all the additional files he has created - all this add upto more than 50 files. Now, he has to go through the entire list to select a couple of files he wants to checkin as a change set. Instead, is there a way where he can selectively pick the files from different folders from the source control explorer window (Like holding down a cntrl key) so he can get them in as ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Managed Direct3D 10

  Since XNA only supports DirectX 9.0 Where is Managed Direct3D 10 I hope there will be Managed wrapper for Direct3D 10 thanks XNA only lets you use an entire window for the graphicscomponent. This is not much use to people like me that make business apps with 3D elements in them, for us being able to create a device in a control within a Windows Form is essential. Our applications are never going to hit the XBox so we would end up moving away to OpenGL libraries rather than use C++ which is too much of an overhead in a RAD environment. ...Show All

• Visual FoxPro listbox?

  How do i populate a listbox with some records (sql query used) from a table . thanx for the help in advance You need to set (in properties): RowSourceType=6 RowSource=<table name> for tables. You may also insert a sql query if you select RowSourceType=3 (SQL statement). ...Show All

• .NET Development How to know the path of the programfiles directory

  What is the procedure to know the path of the program files directory in C#. In VB the syntax is as follows Dim pathprogramfiles As String = My.Computer.FileSystem.SpecialDirectories.ProgramFiles i have added the reference Microsoft.VisualBasic dll also but that couldn't help me. Is there any other way Application .ExecutablePath; // your path with your executable Environment .CurrentDirectory; // your path   Regards. Edit: Ops! i'm sorry, i uderstand bad the answer :P ...Show All

• Visual C# Using OleDbConnection to populate DataGridView

  I'm a bit new to this, so pardon my ignorance if this is well-known. I've been searching the net, but no luck yet. I have an established OleDbConnection that I want to use to populate a DataGridView. I can run SQL queries on the connection and see data sets, but I would like to present a view of that data in my grid. Also, I'd like to be able to only show a fouple of the columsn, but hold on to the full data set for later use. Any pointers would be appreciated... Thanks. I'm still getting this exception: System.InvalidOperationExcception: "Update unable to find TableMapping['Table'] or DataTable 'Table'." I haven't changed the data set (knowingly) between these two function calls. If it is easier, I could send my full proje ...Show All

• Visual Basic How to read specified block of bytes from a file?

  I want to read only bytes from (startindex) to (length) from A LARGE FILE ie: I don't want load all bytes to memory but only bytes I need, and those bytes may start from the middle of the file and end before the end of the file . eg: Suppose mydata.bin as binary file that has more than 100000 bytes how to read from byte 24000 to byte 30000 only. thank you!!!! you may wish to take a look at the FileStream class as you can seek to a certain part of the file and/or read bytes from a specific offset to a specific point in the file. http://msdn2.microsoft.com/en-us/library/system.io.filestream.aspx ...Show All

• SQL Server can pocpet pc direct connect to sql server 2005?

  i plan to upgrade sql express to sql 2005 enterprise. if i upgrade to enterprise can i direct connect to sql server 2005, is it need to install other software on pocket pc or on my server thank you if you are creating a .NET Compact Framework application for your mobile device, then yes, you can use the System.Data.SqlClient namespace to execute queries directly against SQL Server 2005 Enterprise. Darren ...Show All

• .NET Development Smartclient - Bind result: hr = 0x8007000b. An attempt was made to load a program with an incorrect format.

  Hello, When I run an exe hosted through IIS (as a smartclient) on 64-bit machine it fails with: (From fusion Log) Bind result: hr = 0x8007000b. An attempt was made to load a program with an incorrect format. ERR: Setup failed with hr = 0x8007000b. ERR: Failed to complete setup of assembly (hr = 0x8007000b). Probing terminated. The exe WORKS when loading the exe normally (Double clicking on it) It WORK through the Url when hosted on a 32-bit machine. I have tryed marking the exe x86 in VS. What is problem here It seems related to 64 bit AND smartclients Thanks Tom I assume a soulution was found for this! For others who may look here I solved this by changing the Target CPU to "AnyCPU" ...Show All

• Visual Studio Team System programmatically merge branches in source control

  how do i programmatically merge branches in source control. Regards, Guru Start here: http://blogs.msdn.com/buckh/archive/2006/08/12/tfs_api_links.aspx The parameters for the Merge method are documented in the SDK. They're almost identical to the command-line 'tf merge' syntax, if that helps. ...Show All