Reusing The Same Varible For A New SQL Command?
Apr 13, 2009In the code below can I use the cmd for another sql command or do I have to create a new sql command like shown below?
View 2 Replies
ADVERTISEMENT
How To Use A Same Varible Twice
May 1, 2009Im trying to do a loop between to timers. Im a complete beginer so there is probably better ways to do this so feel free to tell me so.when i click a button (text h is a hidden text box as i dont no how to use a the same varible twice so i store the number in a text box) laugh yes. [code]
View 1 RepliesWriting A Varible To Hex
Apr 13, 2012i have made a program that converts a number you put into a text field into hex What i now want to is to be able to write that variable into the file as hex still [code]if that worked that is what i want to do but it doesn't can you help me
View 12 RepliesWill Each Class Have It's Own Copy Of Each Varible
Apr 8, 2009If I have the Following Class Defitions [code] Will each Class Have it's Own Copy of Each Varible?
View 1 RepliesUsing Value Of A Varible Of One Form In Another Forrn?
Feb 22, 2011i declared a class and i initialized the values of the class in FORM6. now i want to use the values of the variables in form6 into form3 how can i do this?
View 3 RepliesVB 2008 Using Image As Varible (generating Images Randomly)
Oct 11, 2009I am using Visual Basic 2008.I am trying to code a simple "show and hide" game where pictures are generated behind a buttonThese pictures need to be generated randomly from my resources. i have got as far as declaring the random number, but am having problems with using a image as avairible which can then be used in a picture box. i have tried "image" but i am having no luck!
View 4 RepliesC# - Reusing A Menu With Mvvm And Wpf?
Jun 7, 2011I was wondering what the best approach is for sharing a menu across all wpf windows/views. My Application doesnt really fit the navigation model, so will probably use a Ribbon control. I am leaning towards creating a user control for the menu and dropping it on each view, but have also seen Josh Smith's msdn article, where he loads user controls.
View 2 RepliesReusing A Datarow In A Datatable
Jun 7, 2009I am working in vb2008. Is there a simple way to clone the contents of a datarow in a datatable into a new datarow instance that can be added elsewhere in the table. Can I create a new instance of a datarow and set it equal to an existing datarow?
View 5 RepliesReusing MySqlConnection.serverString?
Jun 20, 2012Say I have a connection to a database. After reading some stuff I want to connect to the same database. So I naturally use the first database mysqlconnection.serverstring the password and username is not included in connect1.ConnectionString. So how can I do so? Is this by design?
[Code]...
Unique ID Reusing Gaps?
Nov 1, 2011I am upgrading a system that has a Product Table with a Product No Field.This is a string field but most of the existing product Nos are numeric but all over the place.I want to provide a default numeric Product No when the Users are creating a new product record.All I can think of is to use the Identity Field [ProductID] and test to see if it has been used and if so keep incrementing to find the next free numerical, available No.A better solution would be to start at 1 and increment to find the first available but it looks to be several hundred records into the Table. how to find the first available number?
View 9 RepliesReusing Processes And Disposed Not Firing?
Oct 8, 2010I'm attempting to run different tasks in there own processes, waiting until each is done while keeping the UI responsive. So far it works exactly how I want it until I try to reuse some of those processes....here is a sample of the
Private WithEvents TaskOneProcess As Process
Private WithEvents TaskTwoProcess As Process
Private WithEvents TaskThreeProcess As Process
[code]....
This is a over simplification of what's going on but it gets the point across. So it works exactly as expected, a button is pressed and the sequence starts. As each task gets disposed it recalls the StartFixing statement which then calls the next one in order until they are all done. BUT when I go to do it a second time the Disposed never fires assuming since it's already disposed. How do I recreate the same named process so it can be reused and still have it fire the disposed event?
Reusing Same Controls On Multiple Forms
Mar 22, 2012I have a set of controls and code behind them that I'd like to reuse on multiple forms. How can I do this? I know of reusing code via modules, but I'm not sure how I can add the same controls and their underlying code. If I achieve this, will changing data on one form affect the values of another form when they're both open? For example...
Cbox1's selected item affects the choices within Cbox2, and Cbox2's selected item affects the choices within Cbox3 (and so on).
So if I do something on Form1's Cbox1 and it changes Form1's Cbox2, will it NOT change Form2's Cbox2?
Reusing And Cleaning Up User.config Files?
Nov 11, 2010Not sure if this has been asked before (couldn't find an answer), but is there a way to reuse a user.config file from a previous version of the application? For example a user.config file is stored in:
C:UsersJohnnyAppDataLocalCompanyApplicationName.exe_Url_wxcnyrmstqy3oj1qwckdjq3gjqkq4fel1.0.0.0user.config After a new version is installed it gets stored in:
C:UsersJohnnyAppDataLocalCompanyApplicationName.exe_Url_wglmejvw01nagu5t1y5yl12chynjomny1.0.0.1user.config The user then has to enter all settings again, even if the new version does not save more settings. An other problem is that although the user.config file is very small, it does get messy after a while when newer versions of the application get installed. Is there a way to clean up the unused user.config files and their folders?
It's the same problem with System.Windows.Forms.Application.LocalUserAppDataPath, that I'd like to use to save other files (containing Listview data), which points to:
C:UsersJohnnyAppDataLocalCompanyApplication1.0.0.0 The Listview data and other files created by the app can't be used anymore.This can be solved by getting the user's appdata folder with Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) and creating a new folder there with the name of the application. But this means there's one folder where the application is installed (user can choose this folder in the installer), one folder to save my own files to and one folder where VB stores the user.config file.
Can something be done about this "mess" or is this just something I have to live with?
VS 2008 Saving And Reusing The Size Of A Form
Mar 30, 2010I save the size of a form to a variable (One Size or two Integer variables--doesn't matter), and then I close the form. Before reopening the form, I set the form size to the size I saved before--which by all accounts of logic and reason should exactly the same. Except, no, it's not. On one system the form "grows" horizontally and vertically by 15 or 16 pixels. On another system the form grows only vertically 15 or 16 pixels. I'd love for someone to explain this perfectly insane, yet MS typical, behavior to me.
[Code]...
Reusing A Menu Strip On Another Form Inside Project?
Mar 26, 2010created a menustrip (MenuStrip1) by dragging the tool onto my form (form1.vb). And designed the headings/items etcI have now created another form (form2.vb) within the same project.I would like to use MenuStrip1 that i designed for form1.vb in my new form2.vb.
View 6 RepliesReusing Code (functions, Subroutines, Etc.) In Multiple Pages
Dec 28, 2010I am very familiar with modules from my time with VB and my other programming, but what is the most commonly used practice and the best way to go about this for a website application with ASP.NET? Say I have multiple pages (in multiple directories; some in the root directory, some in child directories from the root) that will call the same set of functions and subroutines, how do I go about putting this reusable code in a place where the pages and their respective classes can call the functions/subroutines?
View 3 RepliesVS 2010 Reusing A Very Specific Project For Multiple Solutions?
Aug 1, 2011First of all, I wasn't sure whether this was VB.NET or General Developer content... It's not technically about VB.NET code, but it's not very general either since it is specifically about Visual Studio. Feel free to move it if required.A while back I realized that all of my database connection code was getting very biolerplate. had 'developed' my own method of connecting to an Access database and storing the results. Basically, for each table I create one 'Manager' class and one 'Entity' class. The Entity class represents a single record in the database and has properties for each field.
View 9 RepliesSend A Command To A Command Line And Then Submit The Command?
Apr 30, 2010First let me say that I am not sure whether or not this should go in this section or the API section, and if it needs to be moved I apologize. My issue is fairly straight forward, but for some reason I cannot get it to work.
I am trying to send a command to a command line and then submit the command. I have been trying without success to get this to work in v2008 Express and v2010 Express, Here is the code I am trying to us:
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String _
[Code].....
Open Excel File And Reusing Existing Excel Instance?
Jul 13, 2010I have an application the contains several excel files bundled with it. I'm not opening the files and processing them within my application. These files contain a data-connection to reload all of the pivot-tables within each excel file. I have a 'link' on my form, that when clicked, it determines which file to open and calls a sub using filename and executing Process.Start(filename) for any excel file I want to open. I have no problems opening any one of the files and then exiting excel.
The problem is when I 'close' a file, but don't exit Excel; then try to open another file(clicking link on form)... it creates a new instance of Excel.
I know from experimenting that the fileopendialog form will 'reuse' an existing Excel instance, IF it does not already have a file open.
How can I do the same thing without using the fileopendialog?
I don't want the end-user to have access to the folders where these files live. That's why I have multiple 'links' on my form, one for each xls that already exists. I just want them to be able to click on a link and the xls file opens AND if they choose to merely 'close' a file and not exit... Don't create a new instance of Excel, but re-use the existing one.
Using Psexec.exe From PsTools To Send A Command To A Remote System To Fire A Command
Mar 17, 2010I am currently using psexec.exe from PsTools to send a command to a remote system to fire a command through a command prompt however I am finding that the shell I am doing does not seem to like the spaces in the path.
[Code]...
ExecuteReader Requires Command To Have Transaction When Connection Assigned To Command Is In Pending Local Trans?
Nov 8, 2007Any ideas on how I handle the following error thrown in the SqlDataAdapter.Fill as a result of the BeginTrans in the callee?
System.InvalidOperationException = {"ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction.The Transaction property of the command has not been initialized."}
[code].....
IDE :: ExecuteReader Requires Command To Have Transaction When Connection Assigned To Command Is In Pending Local Trans?
Jun 30, 2010Public Sub ExecuteTransaction(ByVal connectionString As String) Using connection As New OleDbConnection(connectionString)
Dim command
As New OleDbCommand()
Dim transaction
As OleDbTransaction
[Code]...
Command Line Switches - Keeping Command Window Open?
Feb 24, 2010I am using the following code to run defrag and to analyze if the C: drive requires defragmentation:
Dim analyze As Process = System.Diagnostics.Process.Start("C:WindowsSystem32defrag.exe", "C: /a /h /u /v")
This process runs through analyzing, runs it in normal mode & prints the progress to the command window.
My problem is that as soon as the process is complete the command window closes. I need it to stay open so that I can read the results.
Send Command To Command Line From Windows Form Application?
Mar 11, 2010I am trying to send a command to the external command line (cmd.exe) from the Windows form application that I'm writing in VB.NET (using VS2008).
I can only access the external program thru the command line (its not my program) and I must do so from a form app.
I am trying to use the following code. I am able to call a cmd.exe window, but I can't pass the command line my command.
Using mp As New Process
With mp.StartInfo
.FileName = "cmd.exe"
[Code].....
Add New Sql Command To DataSet's Command Collection And Fill DataTable?
Jan 16, 2010I want to add a new select command to my dataset. To do that, I have added a new partial class to my project. Because we have to use partial class if we want to extend generated dataset codes. [code]...
View 3 RepliesCommand Line Program To End Before Moving Onto The Next Command In Loop?
Feb 4, 2011I am using a CheckedListBox that is populated with Filenames (full path, i.e. C:TestTest.jpg)When I have the files that I want in the CheckedListBox I wish to click a Start Button which will process the list one at a time using an exe program that runs on the Command Line. There are arguments that need to pass to the command line as well as the file location in order for the program to process.I currently have it working but the issue is the loop finishes quickly and it is left up to the CMD.exe to finish the process. What I would like is for the LOOP to wait until each file completes processing before passing the command for the next file in the CheckedListBox.There some reasons I wish for it to work this way.
1) I would like to have a button that can Pause/Restart the Loop.
2) I would like to have a button that can Stop the Loop so the whole process can end.
3) I would like to have the Loop remove each file one by one from the CheckedListBox after it has been processed.
4) I would like to display a Message once all the files have been processed.
5) And if it were possible I would like to report the status either by text or a progress bar showing where it is at in the process.
6) And the ability to add some error handling if possible.
Since the Loop finishes so quickly as it just passes the command to the command line using the & as a seperator it is the command line that is handling the rest of the process. Because of this there is not control over it in the GUI.The code I am using allows the Command Line text to display in the Form so it won't open up a seperate window to run CMD.exe. This is the desired affect as I would like everything to appear to run from within the Form itself.
[Code]...
Insert Command Not Functional After Clear Command In Vb Report
Aug 21, 2011User need to select their prefferable data to show in report. What i did is i have a clear command first to delete the temporary table. The temporary table is basically a table to stored user selection parameter data. After the clear command, i have
a insert command to insert user selection data into the temporary table. What happened now is when i run the program exe, first run of the report is work fined, but not the second and the following times of execution. It will return null or blank report. The weird thing is when i execute it from development environment, it seem like the report is able to pick up user selection parameter and run the report for the first times and the subsequent execution.
Preset A Command And Have The Command Called On Different Option Clicks?
May 18, 2009i have seen this in many codes, just not sure where to start and how to call the command. what i'm talking about is having code as such (this is for save file dialog):
[Code]...
Command Prompt 'Copy' Command Equivalent
Apr 24, 2011In the Windows Shell, there is a command that looks like this: copy /b fileA.zip + fileB.jpg fileC.jpg..Is there any equivalent function in VB.NET? I already know this works: [code] But I would much rather have a built-in function to work with. Here is what I am trying to do: url...Also, this doesn't just work for pictures. It works for any binary file. Is there any way in VB.NET to tell if a file is binary or text?
View 3 RepliesHide Characters In SET Command On Command Prompt?
Feb 6, 2011Is there a way to hide the characters of a "set /p password=Enter Password:" command? Or any new strand not using the SET command i could use instead?
View 2 Replies