|
having problems with adding to the database.
the code i have should work, but nothing is getting added to my database. below is the code i have. can anyone pinpoint my broblem and rectify it for me?, thanks
Imports System.Data.OleDb
Public Class cust
Public conn As OleDbConnection
Public comm As OleDbCommand
Public dr As OleDbDataReader
Public da As OleDbDataAdapter
Dim icount As Integer
Dim str As String
Private Sub cust_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
conn = New OleDbConnection 'establishes that conn is a new connection
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\PCbank.mdb" 'the name of the connection (name of the database on the end)
conn.Open() 'opens the connection
comm = New OleDbCommand 'establishes that comm is a new command
comm.Connection = conn 'the connection for the command is the connection specified
comm.CommandType = CommandType.Text 'the commands are in text
End Sub
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
Try
conn = New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=PCbank")
conn.Open()
comm = New OleDbCommand("insert into customers(CustomerID,CustomerSurname,CustomerForename) values('" & (tbID.Text) & "','" & (tbSur.Text) & "','" & (tbFor.Text) & ")", conn)
icount = comm.ExecuteNonQuery()
MsgBox("record inserted")
Catch ex As Exception
End Try
conn.Close()
End Sub
End Class
|
|
|
|
|
You appear to be using the Try/Catch/Ignore anti-pattern. Don't! You will lose vital diagnostic information doing that. The application may be screaming out the reason for the failure and you are just ignoring it.
|
|
|
|
|
Try to write MsgBox(ex.Message) in you Catch statement.
This can tell you a lot about the problem.
I haven't looked your code over in detail.
But one thing that was differen from my code was this:
OledBCommand oCommand = oCon.CreateCommand()
Let your command be created by your connection.
And don't just comm.Connection = conn
But I doubt that this will solve all your problems.
If you get some interesting errors from the Catch, post it again
Programming code is like magic, just use the right code (magic words) to make happen what you want..
|
|
|
|
|
Your problem, or at least one of them, is in this line of code:
comm = New OleDbCommand("insert into customers(CustomerID,CustomerSurname,CustomerForename) values('" & (tbID.Text) & "','" & (tbSur.Text) & "','" & (tbFor.Text) & ")", conn)
There should be a single quote after (tbFor.Text) & ". The line should look like this:
comm = New OleDbCommand("insert into customers(CustomerID,CustomerSurname,CustomerForename) values('" & (tbID.Text) & "','" & (tbSur.Text) & "','" & (tbFor.Text) & "')", conn)
|
|
|
|
|
|
I am a beginner in VB.NET.Suggest me how to get started to VB.NET ,What are the books to be followed which makes helpful to the classes learnt?List also the famous websited related to this?
|
|
|
|
|
satyakala wrote: I am a beginner in VB.NET.Suggest me how to get started to VB.NET ,What are the books to be followed which makes helpful to the classes learnt?
Buy a beginners book. Something with "Beginning" in the name or something like "... in 21 days" or "Step-by-step..." or "... for Dummies". It isn't difficult to find the information you need. Also, it depends on how you learn - we are all different. So, go to the book store, find the books with names matching the pattern above and flick through them. See which one works for you and buy it.
satyakala wrote: List also the famous websited related to this?
http://msdn.microsoft.com[^]
http://www.codeproject.com[^]
|
|
|
|
|
i need a coding that set\change the open with program with mine application
eg.
for text files(*.txt) notepad is default
but when i click on my application`s button then it should change notepad to my application
hope for best reply
|
|
|
|
|
First let me suggest that you NEED to give the user the option to change this or not, dont just take over all associations.
http://www.codeproject.com/dotnet/System_File_Association.asp[^]
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
man no option to user ,just click and change
|
|
|
|
|
xmen_xwk wrote: man no option to user ,just click and change
It is very bad practice to change people's settings without warning and receiving an affirmative answer from the user. You can do whatever you want but if I ever use software that just up and changes some standard file association to a non-standard program without asking me or warning me I will most likely stop using that software.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
yeah i agree with you but the text/caption of button will have the warning text
and about coding this will not change if you take permission or not from user,it will just need messagebox
now may i get the coding....????
|
|
|
|
|
I posted a link in my first reply to you that has code and examples from right here on Code Project.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
yeah but that article is useless for me
|
|
|
|
|
i wrote a program which draws lines on a picturebox when user clickes on it.
theres no picture iniside the picture box and i intend to know the color of these pixels programitically.
A.E.K
|
|
|
|
|
So what's the question? What part of this are you having a problem with?
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
getpixel needs a bitmap.
but my picture box has no bitmap.i draw on it from paint event of the picture box.
how can i make a bitmap from such picture box?
A.E.K
|
|
|
|
|
You don't. Draw on a bitmap, then show it using the picturebox. You can use the picturebox to give you the mouse events, then do all your drawing on the bitmap.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
|
Hi I am writing a service which needs to monitor multiple programs/files etc on a system. The Service is being designed so that it will call standard methods against a range of Standardised dll's.
Application1.GetLastEvent 'Where Application1 is an dll written purely to talk to Application1
Application2.GetlastEvent 'Where Application2 is another dll written purely to talk to Application2
Each dll is being written to get the relevent details from a particular application. Now I could compile the application with all the dll's and just have a setting to only make the request if the application is installed but this would mean rebuilding and and redeploying the service if we wanted to add and check application 3. Im sure this must be possible at runtime.
What I want to achieve is have a runtime list of dll's for the installed applications and make the standard calls against each in turn. The Application should not need to know anything about these apart from the methods which are standard across all of the them.
Thanks in advance, I dont really need a full code listing on this one just a nudge in the right direction as cant seem to find the correct terms to find anything on the WWW.
James
First learn how to speak ~ Then you figure out what Language to speak
|
|
|
|
|
TheFarsider wrote: The Service is being designed so that it will call standard methods against a range of Standardised dll's.
Are these .DLL's being written so that each one is programmed to interact with a specific application??
I think you're talking about "plugin" support for your service app. Your service app would look for these plugins in a specific folder and load them one by one. Each .DLL would have to implement an interface that the service expects them to have so the service can communicate with each plugin.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
Dave Thanks for the reply.
The Plugin Method is one I did look at but I have managed to find the solution and once I got to the route of it, was really quite simple although admitadly I dont fully understand the solution myself yet.
Thanks to Peter Huang and Terry for hitting a similar problem and providing me the vital clues
Below is my proof of concept code
'#### Application Code ###
Dim ModulePath As String = ".\Modules\"
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim di As New IO.DirectoryInfo(ModulePath)
Dim aryFi As IO.FileInfo() = di.GetFiles("*.dll")
Dim fi As IO.FileInfo
For Each fi In aryFi
dllName = "James"
GetCopyrights(fi.FullName, dllName)
Next
End Sub
Sub GetCopyrights(ByVal dllPath As String, ByVal dllName as String)
Dim oRMS As Object = Nothing
Try
oRMS = Activator.CreateInstanceFrom(dllPath, dllName & ".RMS.Controller").Unwrap()
Catch ex As Exception
Console.WriteLine(ex.ToString())
End Try
If oRMS IsNot Nothing Then
Console.WriteLine (oRMS.Copyright())
End If
oRMS = Nothing
End Sub
'### Sample DLL Code ###
Namespace RMS
Public Interface iController
Function Copyright() As String
End Interface
Public Class Controller
Implements iController
Function Copyright() As String Implements iController.Copyright
Return "James Tutton 2007"
End Function
End Class
End Namespace
The only thing id still like to do is make sure the interfaces are common for both the dll and oRMS . The Overall purpose is building a service that uses a common interface for performing common activities. Sorry for the vagueness of my explanations but I am working under some strict NDA's on the specifics of the project.
--How do you quote on this site??? anyhow
Are these .DLL's being written so that each one is programmed to interact with a specific application??
Yes, the idea is that we build a dll to interact with each third party application we need to intereact with but all the calls and return values are normalised across them by the dlls.
|
|
|
|
|
Hi i am using frameset in my page...,
In that frame set,one side i'm showing links,
if i click that links, in another html page my aspx page will be display...,
In that aspx page want to be adjust based on user property...,
It means,now i am using in that aspx page scroll tab...,
But with out scroll tab if i try to show some of the information on that page will be hide..,
But i want to show all information with out using scroll tab...,
How its possible plz help me...,
Magi
|
|
|
|
|
This question belongs in the ASP.NET Forum, which I see you've already post it there too. Please don't cross post in multiple forums. It makes it very difficult for multiple people to collaborate on an answer for you.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007
|
|
|
|
|
hello all,
am a begginer in vb. am creating one small project using vb6.0 and msacess 2003. my problem is i have set one field as a Primary key in that if the no entered is alredy there in databse it was return some error msg, but in my project instead of that error msg i want to create some msgbox that told the no u typed is already there pease choose another. please give me any syntax for that coding? below code is return by me in the insert click. Please give me suggesstion it is very urgent.
<br />
Private Sub cmdverify_Click()<br />
If (Text1.Text = "") Then<br />
MsgBox ("Please Scan Properly")<br />
Else<br />
rs.Open "select * from barcode", con, adOpenDynamic, adLockOptimistic<br />
rs.AddNew<br />
rs!barcode = Text1.Text<br />
rs.Update<br />
Text1.Text = ""<br />
Text1.SetFocus<br />
rs.Close<br />
End If<br />
End Sub<br />
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
