|
The ANZAC wrote: it's great when adding controls to the form by code and it lays it out automatically.
That's it. This real example that made me understand the reason that we use TableLayoutPanel and FlowLayoutPanel.
Thank you
|
|
|
|
|
Am new to VB.net, i have been reading my books very well and i swa a big difference between VB6 and .Net, i learned about ADO.net, Adapters and Datasets, and binding of Control, have Successfully done Database Application in.Net, taking Example from my Books. at my work place they use Visual Studio.Net a French version. am English, but know my way around. i have Completed my Connection to My MSSQl database and generate the dataset from Adapter as the Steps that am supposed to do. i Wrote my Code, but when i run my Program it Gives me the Following Error
"SinglePropertyApplication.exe!SinglePropertyApplication.frmSingle.frmsingle_Load(Object sender = {SinglePropertyApplication.frmSingle}, System.EventArgs e = {System.EventArgs}) Ligne 824 + 0x24 octets Basic"
"SinglePropertyApplication.exe!SinglePropertyApplication.frmSingle.Main() Ligne 3 + 0x1d octets Basic"
"Une Exception non geree du type'System.data.sqlClient.SqlException s'est produite dans system.data.dll"
i used google language tools to convert the language, but all this did not make sense.
secondly the name of my Table is Property, hence Property is a keywork in vb the system Allowed me to write it this way where am not able to but "".
and my Error point s to this line in the Form load
Private Sub frmsingle_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
<br />
Locktextboxes()'this one is Good<br />
<br />
SqlDataAdapter1.Fill(DsProperty112) 'this is the green highlighted problem<br />
<br />
End Sub<br />
like this follwoing code as i said my table is Property, here i had to put it under double qutes""
Dim intCurrentRecordNumber As Integer = Me.BindingContext(DsProperty112, "property").Position
but in this Code
Dim newRow As DataRow = DsProperty112._PROPERTY.New_PROPERTYRow
i had to Put an Underscore.
tell me is it right?, because when i use the name Property without an underscore it gives me a Problem.
Help
Vuyiswa
|
|
|
|
|
hi, have you try to declare "Imports System.Data.SqlClient" in the upper part of you code window?
Don't block the drive way of all the newbies in programming.
|
|
|
|
|
i have not.i have created an Example from a vb.NEt book, using Access as my Db, it never required this. And in this Book it Gives me steps to connect to SQl DB and choose a table from a list of them and after that i drag the table to the Form, it will create a Connection object and Adapter, and from the adapter i will generate the dataset, from there there will where i fill the dataset with the adapter, if these steps are not correct please help me.
Vuyiswa
|
|
|
|
|
Vuyiswamb wrote: have created an Example from a vb.NEt book, using Access as my Db,
Then you can NOT use any of the classes that start with "Sql" in the names. IMport the SqlClient namespace will also not do you any good. There are reserved for use with Microsoft's SQL Server and will not work with Access databases.
For Access, you have to use the classes that start with "OleDb", like OleDbConnection , OleDbCommand , ...
|
|
|
|
|
Dave is correct. because your code read the sql word. Try to declare what i post last time. try to see if the error will be change. if the error change post the error again here.
Don't block the drive way of all the newbies in programming.
|
|
|
|
|
Hi Thanks let me try it and send you the results
Vuyiswa
|
|
|
|
|
Hello
The purpose of the following is to export data from crystal report (implemented in Vb.net) to Ms access database
While working with crystal report XI (without implementing the report in vb.net application ),I could do the following :
Export to ODBC format then choose MS Access Database. and the DB is ready
but when i have implemented the report in VB.net I couldn't find the way (or the button in the toolbar) export to ODBC or to MS access
can you help me exporting the data to Ms access?
Regards
Ramy
Regards
Ramy
|
|
|
|
|
I was trying to do some modification in the VB 6.0 MSFlex Grid
For that I invoked the vb component file in the Class Library Project.
There in the class i am trying to write the following line of code in the class
Inherits System.Windows.Forms.AxMSFlexGrid1
But there ouucred an error
Type System.Windows.Forms.AxMSFlexGrid1 is not defined
I have already added the MSFlexGrid component (.ocx)in the solution
-- modified at 2:07 Wednesday 23rd May, 2007
|
|
|
|
|
You cannot do that. You cannot extend the functionality of a non-.NET Framework class like this.
MSFlexGrid?? My God man, why? The DataGridView is FAR more flexible, no pun intended.
|
|
|
|
|
How Should i change the numeric values which i am fetching from crsytal report in words . If you want i Can send snapshots and codings aslo to you .
With Regards,Preeti Khandelwal E-mail : preetniki@gmail.com
|
|
|
|
|
Hi
If you want to display numeric values from words in Crystal Report, I think there are some built-in functions like NumericText() or ToText()... I am not sure on this... Did you try these functions??
Harini
|
|
|
|
|
ToText (Sum ({waste.id}))
Is this the right syntax to get the conversion from numeric to words in crystal reports ?
|
|
|
|
|
it doesnt convert into words.. just converts it into string format..
The name is Sandeep
|
|
|
|
|
Sir, Does the crystal Reports provide the facility for conversion of numeric into English words?
|
|
|
|
|
Thanks every body i got the answer.
|
|
|
|
|
dear preeti,
plz make ur question clear.. to what format do u want to change your number?? anyways, you must try the inbuilt functions provided in crystal report. create a new formula with those functions.
The name is Sandeep
|
|
|
|
|
Actually i want to Convert my Grand Total which is a rounding off in database by the datatype float . I want to write my grand total in words such as if the grand total comes 867.36 which is in the databse comes 867 I want the in words its should be written as eight hundred sixty seven not eight hundred sixty seven and thirty six paisa
If you want to knopw about me please email me on preetniki@gmail.com
|
|
|
|
|
hi Preeti,
Use following function to change Numeric Value to word in Crystal report
Towords(NumericVariable)
Hope this Helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
see...
giving an example
UpperCase("Rupees " +
ToWords (Sum (Value))
+ " AND PAISE " + ToWords(
Sum (Value) + " only")
dis might help you
Regards Pushpa
|
|
|
|
|
in the table i have four rows having the following data
1.1
2.1
3.3
4.7
the total come 11.00
after rounding
and in words the output is eleven and
is there any way to eliminate the string and
|
|
|
|
|
your output gives 11.2
and if you want to skip "And" then dont add "AND" string
UpperCase("Rupees " +
ToWords (Sum (Value))
+ " only")
|
|
|
|
|
No , Sorry i did not mean that. Actually the addition of four values are 11.3
when i round it off the result comes 11.0
then the conversion into English Words gives me eleven and output(may be due to .0).
I am not using the and string in the formula .
It is the output that is coming with and string.
I need to eliminate and string
-- modified at 8:11 Wednesday 23rd May, 2007
|
|
|
|
|
Hi friends..!
My Problem is regarding Setup of my application which i am
facing..is.. i want to check whether the product i am
installing has been previously installed or not? i am using
Install shield express edition for creating setup of mmy VB
appplication. I am acertaining this with help of following function which is an API function defined in MSI.dll:
"MsiQueryProductState(ProductCode)"
Now when the function return me that there's an instance of the application i am installing what i want is...I want to forcefullly return the Exitcode from currently opened form.
As i have learnt that .. it is the Exitcode which is responsible
for the installer to proceed further after getting an exitcode
'0' from the exe which it fires . I can get the install state of
my application with the above function i.e. Whether it's
already installed or not.. if it is already installed then i want the exe, which calls this function, to forcefully return an Exitcode '1' so
that after getting Exitcode '1' the Parent Setup shud get
terminated immediatley without going further.
Thanx n Regards
IPS
IPS
|
|
|
|
|
try Environment.Exit(exitCode)
topcoderjax - Remember, Google is your friend.
|
|
|
|