|
I try to run SQL statement in by OleDbCommand , the database is Oracle 9i.
However, some error occurs(ORA-00911).
Here is the sourcecode:
Dim ConnString As String
ConnString = "Provider=msdaora;Data Source =" + Server + ";User ID=" + User + ";Password=" + Password + ";"
Dim oCn As New OleDbConnection
Try
oCn.ConnectionString = ConnString
oCn.Open()
If oCn.State = Data.ConnectionState.Open Then
Dim oCmd As New OleDbCommand
oCmd.Connection = oCn
'CreateProgramManager(oCmd)
strSQL = "CREATE USER ""PRGM_MNGR"" " + _
"PROFILE ""DEFAULT"" " + _
"IDENTIFIED BY ""xxxx"" " + _
"DEFAULT TABLESPACE ""PROGRAM"" " + _
"TEMPORARY TABLESPACE ""TEMP"" " + _
"ACCOUNT UNLOCK; "
strSQL = LTrim(strSQL)
'MsgBox(strSQL)
oCmd.CommandText = strSQL
oCmd.ExecuteNonQuery()
|
|
|
|
|
|
|
Now I want to create a toolbar or menubar likes office2003's,and I have done parts of it,but parts of it I couldn't do.
Anyone has the sourcecode of it or can do it,please post it to my E-Mail or tell me how to do it .Thank you!
|
|
|
|
|
Noone is just going to give you the source code for an entire toolbar or menubar. We will help you with YOUR code, but you haven't asked us any questions about any problems your having.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
The problem of me is that I couldn't redraw the menubar,because the mainmenu is made up of menuitems,I couldn'd measure the size of the top rectangle the mainmenu located at, so I cann't draw the office2003 menubar color on the top of the form.
|
|
|
|
|
dyh2222 wrote:
because the mainmenu is made up of menuitems
You expected something different?
dyh2222 wrote:
I couldn'd measure the size of the top rectangle the mainmenu located at
Why would you want to?
dyh2222 wrote:
so I cann't draw the office2003 menubar color on the top of the form
I take it your trying to ownerdraw the entire Office 2003 menu bar?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Structures support event handlings ?
|
|
|
|
|
How to create Shared Procedures, Static procedures, Shared Properties, Shared events. An example will be very much appreciated
|
|
|
|
|
Public Shared Sub SubNameHere
End Sub
Public Shared Function FuncNameHere
End Function
Public Shared Event EventNameHere()
Public Property NameOfProp()
Get
End Get
Set(ByVal Value)
End Set
End Property
Public Structure StructureName
Dim TestStructure As String
End Structure
Not sure on the static
hope that is what you meant
"If i was king cigarettes would be free."
|
|
|
|
|
How to work on multiple columns in a listbox? Let say, I want two columns, Name and Roll should be displayed two columns in the listbox, values are stored in the database "student".
|
|
|
|
|
Apparently, I read recently that .NET does not support multiple columns in a listbox.  I was trying to accomplish the same thing when I read about the this.
|
|
|
|
|
But there is a property Multicolumn with Listbox.
What is this ??
|
|
|
|
|
Sorry, my mistake. I was thinking of the combobox.
|
|
|
|
|
Suppose a Base Class C1, another class C2 inhriting C1, an other class C3 inheriting Class C2. I want to call instance constructor of class C1 into constructor of class C3
|
|
|
|
|
How can we reflect a dataset after altering the table. The generation of a new dataset is not working.
(I tried with MSAccess database)
|
|
|
|
|
How to change the column name of Datagrid from the default column name of the database to any other. Let say, the column name in the database in "Emp_name", and I want to change it
on the datagrid to show as "Employee Name"
Suman Singh
|
|
|
|
|
You will need to instantiate a DataGridTableStyle. DataGridTableStyle supports properties such column width, name....
|
|
|
|
|
Hello all,
I need to render multiple Reporting Services reports into a single PDF for output. Each report will retain its own headers and footers.
Current: (3 PDFs)
---------------------------------
Cover Sheet (1 page)
Sales Report (2 pages)
Accounting Report (2 pages)
Needed: (one PDF)
---------------------------------
Cover Sheet - Page 1
Sales Report - Pages 2 and 3
Accounting Report - Pages 4 and 5
Currently, I am using SOAP to render each individual report to PDF. My application allows users to choose which RS reports they want to output. Obviously, since there is no way of knowing which they will choose, I cannot solve this using RS.
3rd Party tools that require purchase ($) are totally out of the question for me, due to budget constraints. Anything free is good.
Please help!
Thanks very much.
|
|
|
|
|
I am making my own browser using Mozilla's ActiveX controls and I am having some trouble figuring out how to let someone set a homepage. i don't know how to work with writing to files and reading from them. someone please help me.(i'm using VB.NET)
OH! I would also appreciate any help on the URL textbox. Here is a situation:
While using my browser, i type in "www.google.com" and hit "go". I click on "news". i would like the address in the textbox to change automatically to "http://news.google.com/nwshp?hl=en&gl=us" instead of staying "www.google.com" how the heck do i do this?
Thanks
Blah
|
|
|
|
|
ok, i found out how to set the homepage through a file. so all i need help with now is the url thing.
Blah
|
|
|
|
|
So do you still need some help with file I/O?
|
|
|
|
|
I have a loop for a datagrid that shows all the amount rows added together in the caption.text of the datagrid. now i am going to change the loop because i dont need to add the rows, i need to subtract them. i know how to do that, but my question is that i have a textbox(textbox6) for which the user will need to enter a balance to show in the caption.text before the loop can subtract anything. any tips will be greatly appreciated.
this is what i have.
<br />
Dim t6 As Object<br />
<br />
t6 = TextBox6.Text<br />
For Each t As String In TextBox6.Text<br />
Amount += t<br />
Next<br />
<br />
Me.DataGrid1.CaptionText = "Current balance $" & t6.ToString()<br />
it is acting wierd. if i input 7 in the textbox then the data grid recieves only an addition of 1. if i input 9 it gets an addition of 4.why
Makniteasy
|
|
|
|
|
Sorry, but I dont get what you are trying to do...
You assign the Text of the textbox to the object variable t6 and print it out at the end. But in the loop you are only adding (I thought you want to substract something) values to the variable Amount.
And what is For Each t As String In TextBox6.Text supposed to do in your opinion? I dont think thats what you are really trying to perform...
|
|
|
|
|
I have an application where I first load a vb.net app that is going to run in the background. That app then starts another vb.net app that is the user interface (UI). Is there anyway I can send a message (or something) from my UI app to my background app so it can then start a process?
If so, how would that be done?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
