I have to insert/update shipper information and I wrote a stored procedure like this:
IF EXISTS (SELECT * FROM sysobjects WHERE name='usp_Nucleus_LSS_AddShipperInfo' AND type='P')
DROP PROCEDURE usp_Nucleus_LSS_AddShipperInfo
GO
CREATE PROCEDURE dbo.usp_Nucleus_LSS_AddShipperInfo
[code]....
I am using VB.Net 2.0 and SQL Server Enterprise edition.
I want to know how can i update my visual basic 6.0 MSDN library.
View 1 Replieslooking at the code below I have a form that is inserting data from text boxes and a datetimepicker into my database.If Date.text and Shift.text already exist in a row then UPDATE instead of INSERT a new row?
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database.mdb;"
da.SelectCommand = New OleDbCommand("SELECT ID, idate, icomment, ishift FROM table")
da.SelectCommand.Connection = conn
[code]....
This is a Visual Studio forum but can you help me regarding Visual Basic 6.0 Enterprise Edition? I cannot find the CRYSTL32.exe in Visual basic 6.0 Enterpise Edition installation cd. I already some articles and it says that i can find it through this path CommonToolsVBCrysReptCrystl32.exe I alre cd.I saw in my installation cd this path (when I open the cd) Common/Tools... and there is no VBCrysReptCrystl32.exe VBCrysRept so that i can run the Crystl32.exe? I'll be needing it for my programming project which has Official Receipt issuance and somebody told me that i can use crystal report for pie Chart. Is that true that I can use Crystal report for pie Chart? Please also help me to find tutorial regarding crystal report. I am using Visual basic 6.0.
View 1 RepliesWe are using VB.NET 2008. This program must run on a 32 bit operating system.
The machine where the program is running at is a 24 core machine which has 16 Gig of RAM.
It has a Win Server 2003, Enterprise Edition SP2, x86 based PC.
When the VB.NET program VM Size reaches about 1.3 Gig, it says "Exception of type 'System.OutOfMemoryException' was thrown."
When I go to Task Manager and check the Processes, "Mem Usage" for this program is about 300 Meg and "VM Size" is 1,341,300.
These are the information from Accessories - System Tools - System
Information:
Total Physical Memory is 16.37 Gb.
Available physical memory is 14.46 Gb.
Total virtual memory is 17.74 Gb.
Available virtual memory is 15.73 Gb.
Can my VB.NET 32 bit program access more than 1.3 Gig of VM in Win 2003 SP2 Enterprise edition ? How can it do that ?
According to [URL] the memory limit on this kind of machine with x86 is 64 Gig.
What is the difference between professional vs enterprise edition of visual studio.
View 2 RepliesWhenever the code invokes the open dialogue box statement of the VB6.0 code, the application gets terminated.It is expected to open the dialogue box to provide the file path. I'm also having MS Office 2007 enterprise edition. If I do not have MS office 2007 enterprise edition installed, then it is working fine without any problem. So any suggestion/remarks to work on MS office 2007 enterprise edition?
View 1 RepliesIf you try to access a password protected page it does a security check and redirects you if you are not logged in, retaining the URL (ie. Members/MemberLogin.aspx?oc=/PodCast/Default.aspx)The vb script places the "/PodCast/Default.aspx" in a variable and holds it until the login process is complete.Once the user types in their username and password it is suppose to do a Response.Redirect(strRedirectURL) and go to the "/PodCast/Default.aspx" but instead it goes to the default.aspx page for logging in successfully
View 1 RepliesI'm not sure what to use to insert a file that's located on the server into the sql database. I've read a bunch of articles but none of them show how to just grab a file without using fileupload.
[code]...
I am having trouble while installing Visual Basic 6.0 . Setup gives message
View 5 RepliesI am trying to do simple insert, update, delete, select statements within VB .NET to access a MS Access database. I have tried all kinds of solutions offered on the web and while the code seems to work, no rows are inserted. Also, I have tried, unsuccessfully, to use the Try/Catch to see if there's an error with no success. I have attached the versions of VB .Net and MS Access I am using: Here's the code:
[Code]...
how to insert and update data into cache database which is setup as a linked server on sql server 2005.I mean to say insert / update query statement.
View 2 RepliesI am using VB.NET 2010 and SQL Sever CE 3.5 database. I insert some data into my database (SDF file) and I can do any all manipulations with those data. But I cannot see those data in the data table using Data Source or Server Explorer in Visual Studio. Even If I check it once in Server Explorer, all data in the database will be deleted.
View 1 RepliesWell after lots of research i have managed to get a working Shoutcast Server that will allow you to run and stream music to winamp locally or over the net. [URL]is the free source offered by some people over at spesoft using the BASS.dll and BASSenc.dll I'm having problems with Re-sending the original header to winamp when the song changes to update the title of current song playing.this is very straight forward source. however i can't seem to figure this out.
Private Function SendHeader(ByVal sHttpVersion As String, ByVal sMIMEHeader As String, ByVal iTotBytes As Integer, ByVal sStatusCode As String) As Boolean
Dim sBuffer As String = ""
sBuffer = sBuffer & sHttpVersion & " 200" & vbNewLine
[code]....
I am trying to connect to SQL SERVER 2008 from vb.net but failed with Error 40. If I try to connecton to serversqlexpress, error 26 is raised.
View 1 Repliesi have 2 queries in vb.net with an if clause -
if x=0 then
insert into table1
else
update table1
both queries have 5 fields. now what i want to do is after this insert or update takes place, i need to look at this inserted/updated record and compare it with another table (table2). Especially for update, i have 5 fields in both tables. if any of the 5 fields dont match with table2, then i insert a new record in table 2 which is the updated record in table 1.
I'm trying to make a program of mine into a multithreaded application, but I've hit a pair of snags that I documented in the following code. I can expand this stub into a more efficient version of my existing application.
[Code]...
I am trying to re write a VB6 program using MS Access, many years ago, using VB 2010 express and SQL server 2008 R2 Express. I have a database with several tables, which I created using the designer. I am able to connect to the database and select data and display it in textboxes etc in vb code. What I have not been able to in code is to INSERT rows DELETE rows or UPDATE any data in the tables. I can do any of these operations using the Query Designer, but I want to do it in code. I can post some code if necessiary, but I thought it might just be some property that I had not set in the designer.
[Code]...
In my word processor I have an 'Open' option on a menu strip. Here is the code for it:
Private Sub OpenToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OpenToolStripMenuItem.Click
With ofdFile
.Title = "Select a file to open"[code]....
For some reason when I press the 'Open' item and open the ofdFile dialog box .txt files do not appear even when I have the 'Text Files' filter selected However, when I use the 'All Files' filter they appear. And the 'HTML Files filter is also working properly.Why are the .txt files not appearing when I use the Text Files filter?
I don't even know where to begin describing this. I have a project, that uses settings, for some paths, settings that I retrieve with the My.Settings. function.In my laptop, when I change the .exe.config file, the settings are updated accordingly, but when I try that on the production server, it just shows the default value used while compiling.
I tried changing the solution configurations to debug and other custom configs with no effect.Tried to use the same folder copied and pasted without version control, still the same result.Tried a co-workers laptop, by using the last svn revision, it works there too. But on neither of the servers works.
I cannot figure out why my calculation is not working. I am doing for 1 to 12 and it gives me 12 inputs but counts my entries as 13? What am I missing. If I change it to 0 to 11 same thing. I am not sure what the issue is, but I cannot see it, and am not sure where to look.I need to end up with 12 cycles through and intEntries to be 12.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'initialize accumulator
Dim decEntries As Decimal[code].......
dim testpanel as new panel
dim test as CType(testpanel, Control))
msgbox(typename(test)) ' it gives me "panel"
'i dun get it, how can typename of test give me Panel when i explicitly call it to be converted to a Control type?
So I opened 2 forms, Form2.vb and Form3.vbNow I put this:
Private Sub Form1_PreviewKeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.PreviewKeyDownEventArgs) Handles Me.PreviewKeyDown
If e.KeyCode = Keys.F8 Then
[code].....
i am making a simultaneous equations program and cant figure how to get passedtext properly working, as i declare the amount questions the user wants to answer in the settings form, it then passes this over to the simultaneous equations form and i cant get it to keep spawning questions until the number is reached.
Public Class simultaneousequations
Dim Random As New Random
Dim typeofquestion As String = Random.Next(1, 3)
[code].....
I have some System.Collections.Specialized.StringCollection 's in my.settings and the won't do anything: I have tried adding things to them and I get a null reference, now I have used these before and they worked fine I have tried reading from them, like I have in the past, and it dosen't read anything; the strings come out emtey as in one emtey string when there is three full strings
[Code]....
I have 6 textboxes (named textbox7, 2, 3 , 5 and 6) and i want to switch the values put in them (7 in 6, 6 in 5, 5 in 4, 4 in 3, 3 in 2, 2 in 7) by clicking a button.Actually this should be a volley formation scheme :Pi wrote this
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
TextBox7.Text = Replace(TextBox7.Text, TextBox7.Text, TextBox2.Text)
[code].....
Using VB.Net
i am using controls (textbox, combobox, checkbox, etc) with Groupbox and without groupbox in the form
Tab function key is not going to the Groupbox Controls
For Example
Form1
{
Textbox1
[Code]....
Once form1 loaded, textbox1 will be focus, then i click the tab it's going to textbox2, combobox1 and save button. The Tab is not going to Group box (textbox3, checkbox)
So I created a store procedure on my Sql Server 2008.
View 10 RepliesI have records from server that I want to copy, so I used datareader to select all, during selection the insert also process. [Code] What is the exact sql statement to insert only if record doesn't exist in my current table? I used some of this code, but a filter was defined: like x. What if I just want to insert records that doesn't exist in the table I want. [Code]
View 1 RepliesI've defined a public property in a mdiParent form
Public Property StatusBar_LastChecked() As String
Get
Return Me.Statusbar1_LastChecked.Text[code]....
Now when I run the code, the msgbox shows the current text and then the new text. BUT the actual text in the StatusBar remains unchanged.