|
You can find this information from sysobjects table. All the user defined table having the type 'U'
So writing a query like this will give u number of tables in a database
select count(*) from sysobjects where type = 'U'
NOTE :- Check for the table named "dtProperties", it is a system defined table but type is "U" only (so whatever the count comes COUNT-1 will give u exact number), no idea why, if anyone know about this then please clear my doubt regarding this table. 
|
|
|
|
|
thanks this will help... ill try this one....
thank you again...
|
|
|
|
|
 I don't know how to wirte Boostrapper in vb.net check DotNetFramework is installed in Client machine
................
-- modified at 4:01 Monday 3rd July, 2006
|
|
|
|
|
Bootstrapper?? For what? What is this app supposed to be doing?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Bootstrapper for dot net framework? I 1 2 check machine is installed it or not, if not install
................
|
|
|
|
|
Socheat.Net wrote: I 1 2 check machine
Enough with the SMS speak. You have a full keyboard in front of you - use it!
I take it you're looking to see if the .NET Framework is installed before your .MSI is launched for installation. You can't write this in VB.NET, or C#, or any other Managed Language. If the .NET Framework isn't installed, how is your code to check for the presence of it going to execute??
There are a bunch of examples out there on how to do this, in unmanaged languages - even prewritten packages. All you have to do is either search the articles here for "bootstrap" or Google for ".NET Framework install bootstrap".
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave Kreskowiak wrote: the articles here for "bootstrap" or Google for ".NET Framework install bootstrap".
Where?
|
|
|
|
|
Roath Kanel wrote: Where?
You're joking, right?
You've never seen the search box directly under Bob? The little green CP alien at the top of the screen?
And don't you dare tell me you don't know what Google is!
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave Kreskowiak wrote: You're joking, right?
No I'm not.
Dave Kreskowiak wrote: You've never seen the search box directly under Bob?
No I haven't.
Dave Kreskowiak wrote: The little green CP alien at the top of the screen?
Where?
Dave Kreskowiak wrote: And don't you dare tell me you don't know what Google is!
Yes I know google.
|
|
|
|
|
Roath Kanel wrote: Dave Kreskowiak wrote:
The little green CP alien at the top of the screen?
Where?
Directly under the little green alien at the top of The CodeProject web page!!
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Ok, I see what you mean now. You mean the search text box under the code project title. We are in the problem of miss cummunication.
|
|
|
|
|
Socheat, you do not need to write your donw bootstrapper. Try to check Microsoft Download Center[^] then download it. But work only for vs.net 2003.
|
|
|
|
|
Hi,
I am developing crystal report in VB.NET. While i printing the report directly "Logon failed" Occurs. How to over come this.
Below the code i used in the project.
Dim Reportviewer As New frmReportviewer
Dim PrinttoKitchen As New crptPrinttokitchen
Str_Query = "{View_HeaderFooterRecord.fd_bill_id} = " & Int_OrderBillID
PrinttoKitchen.RecordSelectionFormula = Str_Query
Reportviewer.repnam = PrinttoKitchen
'Reportviewer.Show()
PrinttoKitchen.PrintOptions.PrinterName = PrinterName
PrinttoKitchen.PrintToPrinter(1, False, 0, 0)
Thank's in advance,
Senthil V.
|
|
|
|
|
hi,
how to update the table and dataset which has no primarykey.my table is in Informix.and use the ODBC connection.
|
|
|
|
|
Using the DataAdapter and TableAdapers, you can't. They require keys on the tables you use them with.
Either you'll have to add keys to your tables, which is highly recommended, or you'll have to write your own procedures for udating records using fields that can uniquely identify each record.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi! All
I have a problem when I tried to upload file by using system.IO Inputsteam my code is following
Dim UploadedFile As HttpPostedFile = FileUpload1.PostedFile
Dim binFileData As Byte()
ReDim binFileData(UploadedFile.ContentLength)
UploadedFile.InputStream.Read(binFileData, 0, UploadedFile.ContentLength)
Dim strConn As String = "Server=[servername];Database=[dbname];UID=sa;PWD=sa;"
Dim connection As SqlConnection = New SqlConnection(strConn)
Dim str1 As String = "Update DocumentImage set DocImage = @CVData where DocumentID=122"
Dim command As SqlCommand = New SqlCommand(str1, connection)
Dim param1 As SqlParameter = New SqlParameter("@CVData", SqlDbType.Image)
param1.Value = binData
command.Parameters.Add(param1)
connection.Open()
Dim numRowsAffected As Integer = command.ExecuteNonQuery()
connection.Close()
It said Cannot access a closed file. on codeline
UploadedFile.InputStream.Read(binFileData, 0, UploadedFile.ContentLength)
The contentLength was 292836 and the ContentType was "application/pdf"
and I have already put the config into web.config
<httpruntime
="" executiontimeout="1200" maxrequestlength="1000000" usefullyqualifiedredirecturl="false" minfreethreads="8" minlocalrequestfreethreads="4" apprequestqueuelimit="100">
But it didn't work fine
Is there somebody who know how to solve the problem this?
thank you in advance
Jibcht
-- modified at 23:23 Sunday 2nd July, 2006
|
|
|
|
|
I'm receiving an error when attempting to use an Oracle stored procedure in a VB .NET 2005 application; the database is Oracle 9.2. The error is ORA-06550 wrong number or types of arguments in call to <sproc name="">. I'm making the call with an Oracle DataReader. The sproc is pretty simple - selecting two columns from a database table, it doesn't even have a WHERE clause.
I've Googled the error and seen that other people have come across the error but I haven't seen any solutions to the problem.
Any help / suggestions would be appreciated.
|
|
|
|
|
|
This may help, download the pdf
Taken from http://www.oracle.com/technology/sample_code/tutorials/jdbc10g/namedparameters/files/NamedParams.pdf[^]
Handling Errors
As with the Statement and PreparedStatement objects we have already covered,
if there is something wrong with your stored procedure, callable-statement
syntax, the call to your Connection object's prepareStatement() method will
throw a SQLException. The most common SQLException occurs when a
procedure or function does not exist:
SQL Error: ORA-06550: line 1, column 13:
PLS-00201: identifier 'TONUMBERFUN' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
This error may come about because the procedure or function does not actually exist in
the database, or it could be that the username you are using when you call the stored
procedure does not have EXECUTE rights on the procedure.
After you create a CallableStatement object, you need to register any OUT
parameters before executing the statement. Next, let's see how you do that.
modified 1-Aug-19 21:02pm.
|
|
|
|
|
dear friend...
if i have a form in vb.net such as (A) and another application in c language such as (B) how can i control the application (B) from the buttons based on form (A) and i mean of control :
1-run application B
2-minimize and mazimize form B
3-close form B
4- the most thing is make the form A always active that mean you cant use the appliation B except throught the form (A)
thanx all
kilany
kilany
kilany
|
|
|
|
|
First, you can NOT make another application a modal child of your own. Once launched, there is nothing you can do to reliably stop a user from switching over to the other application and using it without your interface.
It's very easy to launch the other app (point 1 in your post).
Point 2 is also pretty easy. All you need to do is get the Window handle of the launched app and call the Win32 function ShowWindow with the appropriate parameters.
Point 3 is a bit more complicated, despite it's seeming ease. You can easily tell the application to exit, but if it wants to show some window that wants comfirmation of exit or saving changes, then you've got a problem. You have to find those windows, if they exist, then send the appropriate commands to those windows.
Point 4 - Not practically possible. There is nothing you can do to prevent the user from skipping your app, or shutting it down, and just using the app your trying to control.
Point 5 (you didn't put this) - How do you intend to control the other application?? The only way to do it is not reliable and is far more complex than the benefits your going to get from implementing it.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hello,
How do you delete a row in vb.net where there is blank data?
I've tried the following, and all do not work...
strSQL = DELETE FROM tblProducts WHERE prodID = & " "
strSQL = DELETE FROM tblProducts WHERE prodID = & Nothing
Thanks in advance.
|
|
|
|
|
Rashar wrote: strSQL = DELETE FROM tblProducts WHERE prodID = & " "
Aren't your quotes in the wrong place?
Rashar wrote: How do you delete a row in vb.net where there is blank data?
What do you mean by "blank data"? From the two examples you gave you appear to be trying to check whether prodID is an empty string (or is that a string with one space), or possibly if it is NULL.
strSQL = "DELETE FROM tblProducts WHERE prodID IS NULL" or
strSQL = "DELETE FROM tblProducts WHERE prodID = ''" The first checks for a null (i.e. the absense of any value), the second checks to see if the value is an empty string.
One of these is likely what you want - but you'll have to be more definite about what consitutes "blank data" in your vocabulary.
Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog
|
|
|
|
|
Colin Angus Mackay wrote: What do you mean by "blank data"? From the two examples you gave you appear to be trying to check whether prodID is an empty string (or is that a string with one space), or possibly if it is NULL.
Yes. I'm looking to delete the record where prodID is a null field.
I will try the first option.
Thanks
|
|
|
|
|
ProgID sounds like it should be a Primary key. If that's the case, why would it ever be NULL?? If this is the case, you've got much bigger issues that just finding and delete "empty" records. In a properly designed database, this procedure your trying to put together should never be necessary.
Dave Kreskowiak
Microsoft MVP - Visual Basic
-- modified at 8:07 Monday 3rd July, 2006
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
