|
You might like to first add the reference of Excel component to your project.
- ashish
|
|
|
|
|
I am trying to insert data into a database, but it's not working. Before I put the try...catch in I was getting a "it must be an updatable query".
So what I'm thinking is that if it isn't my code, or SQL statement. Then it must be that it doesn't have access to the database. Could someone tell me how I go about giving it access?
Here is my code, just in case its a problem with any of my code.
sConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
sConn += "Data Source=C:\Inetpub\wwwroot\webapplication5\football.mdb;"
Dim sqlStr As String = "INSERT INTO Fixtures(Fixtures.HomeTeam, Fixtures.AwayTeam) Values (?,?);"
oConn = New OleDbConnection(sConn)
Try
oConn.Open()
Dim dbComm As New OleDbCommand(sqlStr, oConn)
dbComm.Parameters.Add("HomeTeam", OleDbType.VarChar, 50, "HomeTeam")
dbComm.Parameters.Add("AwayTeam", OleDbType.VarChar, 50, "AwayTeam")
dbComm.Parameters("HomeTeam").Value = HT
dbComm.Parameters("AwayTeam").Value = AT
dbComm.ExecuteNonQuery()
Catch ex As Exception
If oConn.State = ConnectionState.Open Then oConn.Close()
End Try
|
|
|
|
|
Surely you should be closing the connection on a valid query as well as one that throws an exception? If so, then you should consider moving that code to a Finally block. Other than that, your catch block does nothing other than swallow the exception (which is bad practice - if you have a catch you must do something with it otherwise it just hides potential bugs) so you should consider removing the Catch block.
I have to admit that I don't know much about Access databases these days, but a comment I saw in the last couple of weeks would suggest that you might want to look at the permissions of your webapplication directory. Access needs to have writable permission on the folder the database is in because it needs to create a file.
If you are going to give write access to the database through your web application you should consider putting the database in the subfolder of its own so that the web application does not have write access on its root folder - as this is a potential security risk.
Don't know if it will help, but it is possibly worth a go.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
The path C:\Inetpub\wwwroot\webapplication5 must have write/modify permissions otherwise you restrict the database to readonly. Access throws this error as if it were related to the sql. a bit odd but thats Microsoft.
|
|
|
|
|
the application was running well in one of the PC .. I uninstalled it cuz the connecting string and DB security need to be added, after installing it i got this error when i try to run an imbeded report
System.TypeInitializationException: The type initializer for "CrystalDecisions.CrystalReports.Engine.ReportDocument" threw an exception. ---> System.Runtime.InteropServices.COMException (0x80040154): COM object with CLSID {CF76A644-314B-404D-8D45-F08B51FF990B} is either not valid or not registered.
the application is working fine in one of the pc's, it was installed more than 2 months ago. But now when trying to install it in other PCs i get this error?
Please note that i have included the merge modules for CR10...so what could be missing?
|
|
|
|
|
Hi all,
Please tell me what is the best 3rd party control in vb.net. i want to use it for best appearence.
bye!!
|
|
|
|
|
WOW! You've won the award for the most vague question ever!
What type of 3rd party control? What exectly do you want this control to do? What do you mean by "best appearance"?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I need 3rd Party Tools for Develop a .Net application, that means that tool will have all the controls are used in vb.net with best appearance and additional functions.
It is clear noW !!!
Like Component One C1FlexGrid, C1ToolBar, c1TextBox, c1Picture Box like that.
Ok
Bye
V.Gopi.
Easy Design Systems
Coimbatore
India
|
|
|
|
|
I had looked at SandBar, SandDock..... controls, looks good to me. You might like to have a look at those.
- ashish
|
|
|
|
|
I have an application in which if an error occurs then it should go to database and get the exception message.
Now the problem how can i identify types of exceptions. I know that there
exception types defined. But like in VB if there was exception number then it would have been easier to refer it from the database.
Cause one ExceptionType can have different exception messages i mean SqlException can be like conncetion not open or invalid insert statement but it will show only sqlexception.
Does anyone have any idea how to solve this.
|
|
|
|
|
nitin_ion wrote:
I have an application in which if an error occurs then it should go to database and get the exception message
But, the exception has an exception message already. It is in a propery called Message.
I think I understand what you want to do. I just don't understand why.
If you were going the other way and logging exceptions into the database then I could understand things. But, what advantage or benefit do you get with pulling a message out of a database when the exception already has one.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
YOu are right there is no reason why i should go to database and fetch message from it when there is already one.
The reason is there are times when we general user might not understand the message, it might make sense to a developer but not to an ordinary user.
Also i am logging error, that is not a problem. The problem is how to distuinguish between exception as SQLException can be "connection not established" or "Syntax error in statement".
|
|
|
|
|
In the case of SqlExceptions you do have a Number in the exception (and the SqlException can contain many Errors) the number corresponds to the value of the error column in the master..sysmessages table.
Does this help?
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
Yes, SQL does have a number but that just solves the sql exception not other like XML or IO which doesn't have a number.
I was hoping for a fit for all situation(or almost everyone).
|
|
|
|
|
I might have found the solution. I tried "ex.TargetSite.Attributes" and it gave me a unique number for the exception.
I haven't fully tested it but i hope this might work.
If you know anything about this share it with me.
|
|
|
|
|
I have this code in VB6 but I don't know how to change into VB.NET ?
Private Declare Function GetFocus Lib "user32" () As Long
Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Integer, ByVal lParam As Integer) As Long
Private Declare Function GetActiveWindow Lib "user32" () As Long
Private Declare Function GetWindowText Lib "user32" Alias "GetWindowTextA" (ByVal hwnd As Long, ByVal lpString As String, ByVal cch As Long) As Long
Private Declare Function FindWindowEx Lib "user32.dll" Alias "FindWindowExA" (ByVal hWnd1 As Long, ByVal hWnd2 As Long, ByVal lpsz1 As String, ByVal lpsz2 As String) As Long
Private Const WM_CHAR As Long = &H102
Private Const CH_A As Byte = 65
Private Sub Command1_Click()
Dim handleactive As Long
Dim recString As String
Dim handle As Long
handleactive = GetFocus()
'Call Shell("c:\windows\system32\cmd.exe", vbMaximizedFocus)
'handleactive = GetActiveWindow()
handle = FindWindowEx(0, 0, "ConsoleWindowClass", "C:\WINDOWS\system32\cmd.exe")
DoEvents
SendMessage handle, WM_CHAR, vbKeyC, 0
SendMessage handle, WM_CHAR, vbKeyD, 0
SendMessage handle, WM_CHAR, vbKeyReturn, 0
recString = String(100, Chr$(0))
GetWindowText handleactive, recString, 50
Text1 = recString
End Sub
Thanks for your helping!
Hung
|
|
|
|
|
I have a Panel Control containing a PictureBox in it
If I set a picture for PictureBox and the size of the PictureBox is large enough to show the ScrollBars of the Panel control
Infact I am trying to add the scrolling functionality to My PictureBox and scroll it programmatically
How do I programmatically set the values of the ScrollBars of the Panel control such that the center of the PictureBox is in the Center of the Panel control.
I have used the AutoScrollPosition property of the Panel control, but, can't find the solution to my problem (how to scroll to the center)
I hope you understand my problem
Hoping for a quick reply
Thank You
-- modified at 13:40 Friday 16th September, 2005
|
|
|
|
|
You might like to set scrolling position of scrollbar at some event.
E.g.
you can set X and Y positions.
- ashish
|
|
|
|
|
I want this functionality by using the panel control only (as I stated)
Thank You
|
|
|
|
|
I talked about Panel control only.
- ashish
|
|
|
|
|
Hello
How do I determine the values of X and Y, since, I don't know how the values of X and Y work
Thank You
|
|
|
|
|
I am developing an application that needs to figure out how many monitors are available and it will populate a listbox with the monitor options. When one of the monitors is chosen e.g. Monitor 2, it should move a form to that window.
Could someone please tell me how to do this in VB.NET? Or are there any examples out there where something similar to this is done in VB.NET?
Thanks for all your help.
Yemi
|
|
|
|
|
You can find some information in the following class...
System.Windows.Forms.SystemInformation
Including getting the monitor count and the primary dispaly...
System.Windows.Forms.SystemInformation.MonitorCount
But I'm afraid that's as much as I know.
|
|
|
|
|
Hi all..
I'm trying to replace a item in a Listbox, but for some reason it does'nt work... ;(
ListBox1.SelectedItem = "Some|Text|Text|Text"
For some reason my "ListBox1_SelectedIndexChanged" will brake..
Dim ConfigData As New ArrayList(Strings.Split(ListBox1.SelectedItem, "|"))<br />
ProjectName.Text = ConfigData(0)<br />
SourcePath.Text = ConfigData(1)<br />
ServerPrjPath.Text = ConfigData(3)<br />
LocalPrjPath.Text = ConfigData(2)
shame ,Gerrit
-- modified at 12:29 Friday 16th September, 2005
|
|
|
|
|
I haven't properly understood what's the matter here.
You have a problem in "replacing" an item in the listbox as you state in your first line or with the SelectedIndex changed (not affected by changing an item) or something else?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
