i have a stored procedure that updates TableA with data from TableB when i run it from SQL managment studio it workes, so the SP is error FREE, all i need is to execute this from a button click event.
i tryed this:
Try
Dim cnn As New SqlConnection(My.Settings.sqlCn)
Dim cmd As SqlCommand = cnn.CreateCommand
[Code]....
[Code]...
how can i get this code to return all values instead of just the first value ?
I have code I want to execute only if the EXE is not in the IDE. How can I determine when I'm running outside the IDE?
View 8 Repliesi just want to ask why this error mean?InvalidOperationException was unhandled by user code//The provider could not determine the String value. For example, the row was just created, the default for the String column was not available, and the consumer had not yet set a new String value.
View 8 RepliesI've been running the exe file ok but recently I got this error. I suspected it could be because of the windows update which the IT technical had run earlier. Anyone knows what's the cause of this error? Please see the attachment for the error.
View 1 RepliesI have a sample.cmd file that has the following code.
dir/b/p D:Satheesh > TableOfContents.txt
When I run the bathc file seperately I can able to get a text file that contains all files in the folder.
But when I execute the cmd file from VB code using Shell function, I am not getting the text file created.
I have a BindingNavigatorMoveNextItem_Click event and I want to execute btnSave_Click() event.. its asking for e args, what do I use as args?em.EventArgs) Handles BindingNavigatorMoveNextItem.Click
View 4 Replies[code]...
how Can I call privileges.vb from the btn_next_begining?
ALTER DATABASE test SET ENABLE_BROKER this is the sql query i wish to execute while program is executing.because i do not want to everytime i change computer also need open sql management tool to execute this query rath
View 3 Repliescatch statements - it works well just checking my disk drive for a file, if an error is thrown then I open the disk tray and ask them to put the disk in, click OK on the message box and it performs another check for the file, if this fails the button that starts all this is disabled on my main form (the code is shown below).
Okay, so my problem is I'd like to have the message box pop up and the have the drive open up (using an API which I have) either at the same time or in the order of: message box then drive open. I can see two ways to do this: Have the commands happen at the same time (Can you even do this?) OR Have the message box appear and then open the disk drive (but how I could achieve this I don't know as the message box waits for the user to click OK... I originally though of starting a timer just before and getting it to open the disk drive tray in the tick event,
Code:
Public Class Form1
'open cd-rom tray API
Private Declare Function mciSendString Lib "winmm.dll" Alias "mciSendStringA" (ByVal lpstrCommand As String, ByVal _
[Code].....
I created a *.bat file : osql -Usa -Paugust -SNgocThach -iMYDATABASE.SQL When it run at cmd, it ok. My database has just been setup. Now, I want to setup my database use VB.NET. How can i do
View 1 RepliesFor example I got Form1. And I want to get a jarfile inside it just like its possible for .swd and .pdf files.I thought of something like a webbrowser, going to a page with the jar file, but that Isnt really brilliant as the webbrowser might be slow, or cause problems.
View 1 Repliesfor example there is a file named abc.exe in c:
what would be the code for executing this file?
My basis of my programForm 1 has functions, which are controlled through button1 which sends an email, At the end of the send email function I have Dialog1.ShowDialog() Which opens Dialog1 to say "Email has been sent" With a button, I want this button to execute the whole program, How do I do this?
View 2 RepliesI'm trying to play a video file by executing the player file and calling the "open" method. Although it works perfectly on GOM player, it does not work in VLC player, Windows Media Player and BS player. I tried other methods instead of "open" such as "url", "play", etc. but they are useless. Below the working code is shown:
Dim PlayerPath As String = "C:Program FilesGRETECHGomPlayerGOM.exe"
Dim process As Process = New Process
process.StartInfo.FileName = PlayerPath
[code]....
about execute a program, what do I have to do in order I can make the program run on any other computer. I have a program on a floppy disk, and I have a copy on my desktop. when I run the program on my desktop it always say "File not found", when I put the floppy disk it's working fine. So, is there anything I can do, to make it run on any other desktop without saying "File not found"
View 10 RepliesI'm trying to read data from database.
If objReader.Read = True Then
If objReader("cell") IsNot DBNull.Value Then
Me.txtContact.Text = Trim(objReader("cell"))
[code]....
Problem is, no data displays if cell is empty.
How do i write in If not on vb2010??
View 1 RepliesI know this requirement may seem weired to many of you but it is one of my project requirement.Is it possible to add code in Sp and execute in .Net exe. Like on button click i call one SP that SP returns few line of code and then program execute the code.
View 4 RepliesI'm wondering, in Visual Basic 2008, how to execute an external dos command and get its output without help of an intermediate file (to speed up)?
View 1 RepliesIts something in the syntax for the command.
They provide this example in VB:
Dim MtbApp As New mtb.Application
Dim MtbProj As mtb.Project
Dim MtbCom As mtb.Command
[Code]....
what I'm expecting should happen is Minitab should open, and the command should execute. However, whats happening is that two instances of Minitab are being opened and neither are showing user interface, I have to find them in processes.
I am using ASP.NET 3.5. When the user click on say btnSubmit I want to first execute some JavaScript code and then execute some C#/VB.NET code.
Is this possible? If so how would one do it?
I am trying to run photoshop action from VB interface. can any body guide me on how should i proceed.
View 2 RepliesUsing VB.Net and C#.Net
Using 3 Tier, I was executing this query in DataAccessLayer, i want to call this query in ApplicationLayer throgh BUsinessLogicLayer.
Code.
Cmd = New SqlCommand("Exec delTable", con)
cmd.ExecuteNonQuery
I want to return this execute command like this,
In application Layer How to call this?
i hve build 1 system inventory using vb.net 2008.can i run execute file from browser...maybe like in asp.net..
View 5 RepliesI updated a VB.NET application from Visual Studio 2008 to Visual Studio 2010 and made a few changes to it. Now it works fine on my development workstation but when the user tries to run it, it fails. The error detail is below. I've searched for System.InvalidOperationException and found several suggestions but none of them have helped. There isn't any static initialization code in the application. I changed the compilation to x86 instead of AnyCpu. None of these has helped. The project is compiled for .NET 3.5 and that hasn't changed. Both environments are Windows 7 64-bit.
Does anyone have a suggestion as to how I might determine what is causing this?
[Code]...
I created an MSI for my application and i want my dll to execute during installation of this MSI. How can i add my dll to MSI. I read something on ORCA but getting error.
add my dll to msi using orca. My dll contain a message box and registry entry
I have some code that i cant work out why its happening and how to fix it. What im attempting to do is loop through the controls in a gridview and replace it with another control along with the text
Dim i As Integer
Dim row As GridViewRow
Dim rowCell As TableCellCollection = row.Cells
[Code].....
can i execute 2 or 3 timers at same time if its possible how come?
View 5 RepliesLets say i have a text box and i type picturebox.visible = false; then i press a button to execute it. and My Picturebox is not visible now.so How do i run that command since it was in a text box???
View 7 Replies