london257's Q&A profile

• Visual Studio Express Editions TableAdapter and SelectCommand

  I'm trying to change my select command at runtime to add a where condition.  I'm trying to use this, but it says that selectcommand is not a member of ComputersListTableAdapter, but it does have things like update, fill, etc.  Does 2005 have a different way of changing the select command This is what I have: frmComputers.ComputersListTableAdapter.selectcommand.commandtext &= " " & WhereCondition In 2003, I was able to use this : OleDbDataAdapter1.SelectCommand.CommandText &= " " & WhereCondition Help please... You can create additional ...Show All

• Visual Studio Express Editions Resource file

  Hi all, i have a question regarding resource file. What i want is to keep my connection string at .resources file. There will be multiple connection string. An example application of this is like any mySQL front end where we can change the connection string (server name / IP address, database name, etc) and also we can make a new connection with a different name but the previous connection string still exist. Does anyone know how to do this using .NET i had read about resource file and also i had able to make one but i can't acces it until i embed it with external command (csc /t:exe /resource:..............) from the command prompt. A ...Show All

• Visual Studio Problem with SS and VS Database Projects

  Hi, we have a problem with Source Safe binding and database projects in Visual Studio. To reproduce the issue do the following: person A adds a script and checks out the project file person B adds a script too but gets the "already checked out by another user" message person B tries to add a script again and it works!!!! Without error message or something like that. The file is in Source safe but not in the project file. How can we solve this What type of project are you using Which version of VSS are you using It appears that the script is added to your ...Show All

• Visual Basic Unitized form constructor/activator

  I'm going to define a sub executing creation or activation (if already opened) of MDI children. The sample of such sub follows. Returns error if called CreateForm(AuthorForm) ' Author form is class based on Form Is there a way to make a call to construct or activate any form the way it's done in ObjectPascal using class references Thanks! Private Sub CreateForm(ByVal FormType As System.Type) Dim Child As Form For Each Child In Me.MdiChildren If FormType Is Child Then Child.Activate() Exit Sub End If Next FormType.TypeInitializer.Invoke(Nothing) End Sub ...Show All

• Visual C++ need help with wchar_t and chars

  UnregisterClass( "D3D Tutorial" , wc.hInstance ); I get the following error: .\Main.cpp(140) : error C2664: 'UnregisterClassW' : cannot convert parameter 1 from 'const char [13]' to 'LPCWSTR' Types pointed to are unrelated; conversion requires reinterpret_cast, C-style cast or function-style cast How Should i fix this Define it as a unicode code string. Prefix with L UnregisterClass( L "D3D Tutorial" , wc.hInstance ); Read more about MBCS and UNICODE and try to understand the difference. Read http://msdn2.microsoft.com/en-us/library/c426s321(en-us,VS.80).aspx ...Show All

• SQL Server Problem with Large data amounts

  I have a dataset with 300,000 records and I'm getting the following error with MS Reporting Services.  "An error has occurred during report processing.  Exception of type System.OutOfMemoryException was thrown.  any help with this would be highly appreciated. Again. Brian Wleker told me last year it would be "fixed in the next update". I haven't tried SQL 2008 yet. ...Show All

• SQL Server BUG REPORT: ReadWriteVariables different between Script Task and Script Component

    I have just spent two hours banging my head off the wall to figure this one out... wondering if I had a problem with variable scope or something... I had a Script Task which was taking a few package level variables to use in the script. So I put the list of variables in the ReadWriteVariables property. Specified them like this: " User::FileBeingProcessed, User::FileSource" And all was well.... Then later on decided to use the same set of variables in a Script Component contained in a Data Flow. And kept kept getting a "..variable not found.." error dialog when I clicked on Design Script. Finally the sol ...Show All

• .NET Development Should the SmtpMail class have a port property?

  We are using the SmtpMail class to send email.  There is a property named SmtpServer.  Should there not also be a property to allow setting the port number   The default of 25 works ok, but in situations where a non-standard port number is used, the SmtpMail class will not support it.  Using a non-standard port is a good means of increasing security so that viruses, worms, etc. will not be able to find a SMTP server to use just by scanning for port 25.  Is there a reason this is not included as a property in the SmtpMail class   Will this be the same in version 2.0 I did find how to make it work using the MailM ...Show All

• Visual C# How to create a base class windows Form?

  Hi All, I wanted to created a windows form with functions that are reusable.  For example, creating a function to connect to the SQL server and validate user's name and password or insert record to SQL Server just by calling the AddRecord function. TIA For example, try this: public class BaseForm : Form {     public void MyMethod()    {       MessageBox.Show("Hello");    } } public class DerivedForm : BaseForm {     public DerivedForm()    {       MyMethod();    } } &nb ...Show All

• Visual Studio Express Editions Numbers only in a TextBox

  Hi All I drew a TextBox from the tool box but don't know how to make the TextBox accept numbers only. Any help is appreciated. private void searchText_KeyPress(object sender, KeyPressEventArgs e) {  if (e.KeyChar != 8)  {   if (char.IsNumber(e.KeyChar) == false)   {    e.Handled = true; } } I allow the backspace keypress by checking for character 8. You can easily modify this code to suit your needs. ...Show All

• Visual Studio Signing Assemblies with InternalsVisibleTo

  I have a number of assemblies that use the InternalsVisibleTo attribute. For example: MyProject\AssemblyInfo.cs [assembly: InternalsVisibleTo("MyServices")] When I try to sign the MyProject assembly, I get an error: error CS1726: Friend assembly reference MyServices' is invalid. Strong-name signed assemblies must specify a public key token in their InternalsVisibleTo declarations." So, I add the PublicKeyToken value to the assembly name: MyProject\AssemblyInfo.cs [assembly: InternalsVisibleTo("MyServices, PublicKeyToken=aaabbbcccdddeee")] This allows MyP ...Show All

• Visual Basic I am STUMPED....

  If xpos(C) < PrintWidth Then Xpos(c) is an array of column widths.... Printwidth is the width of the document that was chosen from pagesetupdialog. The above line does not work.....I have watched the Xpos(c) increment up with the counter so for example it goes with C=1 =1.32, then C=2 = 2.41......etc. Printwidth is derived from the following: PrintWidth = (e.PageSettings.Bounds.Right / 100) - (XposR + TapeBounds.Width) They are both declared as single so now when I watch the program run with a breakpoint......Xpos(c) becomes 7.35 and Printwidth is 6.5 and it just keeps on passing as if it was doing the if statement ...Show All

• Visual Studio Express Editions New to VB 2005 - Getting a file...

  I had previously been teaching myself VB 5, and written a good number of programs, one, a very LARGE program to track lottery numbers, wheeling, printing reports and everything. I pretty much knew what I was doing then, and had many books to back me up in the evnt I got stuck. But that was then. All my hard work from back then is useless in VB 2005. Now, I'm trying to learn VB2005 all over again, and it ain't pretty, as they say. I am only a hobbyist, but I used to enjoy programming immensly. Anyway, as I have done with several previous versions of VB, I read so much, then try on my own. I did buy 2 books - the WROX Beginning VB 200 ...Show All

• Visual C# C# ADOX and ReadXMl

  Hey guys, I Have created a database access file using ADOX. Now i want to fill that database with (tables) by getting the information from an XML file using the ReadXml(); All that i've done right now is Create the database file Create the tables create the columns for each table but i dont know how to fill the columns with data. The code im using is this ofdXml.Filter = "Xml files (*.xml)|*.xml"; ofdXml.ShowDialog(); if(ofdXml.FileName.Length > 0) { xmlPath = ofdXml.FileName; } if(xmlPath != null) { //Load dataset with the received database dbDataset = new DataSet("Xml converter"); db ...Show All

• Visual Studio Express Editions 64 bit Compile for web application at Visual Studio Web Developer Express 2005

  Hi, How can I compile a managed web application at 64 bit. Is there any adjustment or configuration at Visual Studio Express Web Developer Edition or does it directly compile at 64 bit. I need urgent help please Best Wishes, Well, now I'm just guessing, but I'd say yes, since I saw different performance statistics for the various combinations of optimisation and platform. So the code would be optimised for a 32-bit system and would run in emulated 64-bit mode which, assuming you have an Athlon-64, is no slower than running in 64-bit mode.  And in fact the statistics I saw (I wish I had the ...Show All