473,378 Members | 1,417 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Casting?

Hello: I am confused about casting...

Option Strict = ON

Example1:
---------------
When I say something like this...

Dim lo_Foo = New Foo
Dim lo_Obj as Object = lo_Foo

Works Fine!
Example2:
---------------
When I say something like this...

Dim lo_Foo = New Foo

OutPutObj(lo_Foo)

Public Sub OutPutObj(ao_Obj as Object)
...
End Sub

Compile Error: "Option Strict ON disallows implicit conversion from
System.Object to type Foo"

Isn't there an implicit conversion in the first example when the variable of
type object is set to the instance of Foo???

Thank you,
Shannon Richards
BBA, AIT, MCP
Nov 21 '05 #1
14 1623
"Shannon Richards" <sr**********@hotmail.com> schrieb:
Hello: I am confused about casting...

Option Strict = ON

Example1:
---------------
When I say something like this...

Dim lo_Foo = New Foo
Dim lo_Obj as Object = lo_Foo

Works Fine!
Example2:
---------------
When I say something like this...

Dim lo_Foo = New Foo

OutPutObj(lo_Foo)

Public Sub OutPutObj(ao_Obj as Object)
...
End Sub

Compile Error: "Option Strict ON disallows implicit conversion from
System.Object to type Foo"


Where does it say that? It doesn't say that for the code you posted.

The message will be shown when casting from a base type to one of its
derived type, but not when "casting" from the derived type to the base type.
That's why the cast to 'Object' will always work.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

Nov 21 '05 #2
All types of sedan automobiles are cars, but not all cars are sedan
automobiles.

You can cast a sedan as a car, but you can't cast a car as a sedan.

Get it?

"Shannon Richards" <sr**********@hotmail.com> wrote in message
news:uU*************@TK2MSFTNGP10.phx.gbl...
Hello: I am confused about casting...

Option Strict = ON

Example1:
---------------
When I say something like this...

Dim lo_Foo = New Foo
Dim lo_Obj as Object = lo_Foo

Works Fine!
Example2:
---------------
When I say something like this...

Dim lo_Foo = New Foo

OutPutObj(lo_Foo)

Public Sub OutPutObj(ao_Obj as Object)
...
End Sub

Compile Error: "Option Strict ON disallows implicit conversion from
System.Object to type Foo"

Isn't there an implicit conversion in the first example when the variable
of type object is set to the instance of Foo???

Thank you,
Shannon Richards
BBA, AIT, MCP

Nov 21 '05 #3
Hi Shannon,

Option Strict On doesn't allow late-binding. For some reason I believe the
compiler considers your first example either early-binding or allowed
late-binding and your second example illegal late-binding with Option Strict
On. I think that is what is going on but I'm not totally positive. My
point is that maybe this isn't a casting problem but a binding problem.
Some research on binding could give you a definitive answer. Good luck!
Ken.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and need help, email me.

"Shannon Richards" <sr**********@hotmail.com> wrote in message
news:uU*************@TK2MSFTNGP10.phx.gbl...
Hello: I am confused about casting...

Option Strict = ON

Example1:
---------------
When I say something like this...

Dim lo_Foo = New Foo
Dim lo_Obj as Object = lo_Foo

Works Fine!
Example2:
---------------
When I say something like this...

Dim lo_Foo = New Foo

OutPutObj(lo_Foo)

Public Sub OutPutObj(ao_Obj as Object)
...
End Sub

Compile Error: "Option Strict ON disallows implicit conversion from
System.Object to type Foo"

Isn't there an implicit conversion in the first example when the variable of type object is set to the instance of Foo???

Thank you,
Shannon Richards
BBA, AIT, MCP

Nov 21 '05 #4
Hi Shannon,

Option Strict On doesn't allow late-binding. For some reason I believe the
compiler considers your first example either early-binding or allowed
late-binding and your second example illegal late-binding with Option Strict
On. I think that is what is going on but I'm not totally positive. My
point is that maybe this isn't a casting problem but a binding problem.
Some research on binding could give you a definitive answer. Good luck!
Ken.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and need help, email me.

"Shannon Richards" <sr**********@hotmail.com> wrote in message
news:uU*************@TK2MSFTNGP10.phx.gbl...
Hello: I am confused about casting...

Option Strict = ON

Example1:
---------------
When I say something like this...

Dim lo_Foo = New Foo
Dim lo_Obj as Object = lo_Foo

Works Fine!
Example2:
---------------
When I say something like this...

Dim lo_Foo = New Foo

OutPutObj(lo_Foo)

Public Sub OutPutObj(ao_Obj as Object)
...
End Sub

Compile Error: "Option Strict ON disallows implicit conversion from
System.Object to type Foo"

Isn't there an implicit conversion in the first example when the variable of type object is set to the instance of Foo???

Thank you,
Shannon Richards
BBA, AIT, MCP

Nov 21 '05 #5
Shannon,

What is IncomeGateway? A Collection or ArrayList, or? Is it strongly type to only contain Income objects?

Same question for List?
--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com
"Shannon Richards" <sr**********@hotmail.com> wrote in message news:OS**************@TK2MSFTNGP11.phx.gbl...
Here's what's really happening:

lo_Gateway.Insert(ByRef ao_Object As Object) - takes an argument of type object.

Since all reference types derive from object in .Net why is the compiler giving this error? Income is an Object...


Nov 21 '05 #6
Shannon,

What is IncomeGateway? A Collection or ArrayList, or? Is it strongly type to only contain Income objects?

Same question for List?
--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com
"Shannon Richards" <sr**********@hotmail.com> wrote in message news:OS**************@TK2MSFTNGP11.phx.gbl...
Here's what's really happening:

lo_Gateway.Insert(ByRef ao_Object As Object) - takes an argument of type object.

Since all reference types derive from object in .Net why is the compiler giving this error? Income is an Object...


Nov 21 '05 #7
Shannon,
In addition to the other comments (especially Nick's):

Insert is using ByRef, Do you really need ByRef here? Probably not.

ByVal & ByRef Parameters are independent of Reference & Value Types. All
parameters in VB.NET by default are passed ByVal, you should only pass a
parameter ByRef when you have to, which is when you need to modify the
callers variable.

A Reference Type is an object that exists on the heap. If I have a variable
that is a reference type and assign the variable to another variable. Both
variables will be pointing to the same object on the heap.

Dim x As Person
x = New Person()
Dim y As Person
y = x

Both x & y are the exact same Person object on the heap.

A Value Type does not live on the Heap. If I have a value type variable and
I assign it to another variable, a copy of the value is made.

Dim x As Integer
x = 100
Dim y As Integer
y = x

Although both x & y have the value 100, they are physically different values
as a copy was made.

Now when you pass a variable to a ByVal parameter a copy of the variable is
made. So for a Reference Type a copy of the reference is made, which means
there is still only one object on the heap & two references to that object.
For a Value Type a copy of the value is made.

When you pass a variable to a ByRef parameter a reference to that variable
is made. So for a Reference Type you have a reference to a reference to the
object, for a Value Type you have a reference to the value.

Remember ByVal & ByRef are how parameters are passed. Reference & Value
Types are how quantities are stored.

The following site also does a good job of explaining Reference & Value
types & ByRef & ByVal parameters.

http://www.yoda.arachsys.com/csharp/parameters.html
Hope this helps
Jay

"Shannon Richards" <sr**********@hotmail.com> wrote in message
news:OS**************@TK2MSFTNGP11.phx.gbl...
Here's what's really happening:

lo_Gateway.Insert(ByRef ao_Object As Object) - takes an argument of type
object.

Since all reference types derive from object in .Net why is the compiler
giving this error? Income is an Object...



Nov 21 '05 #8
Shannon,
In addition to the other comments (especially Nick's):

Insert is using ByRef, Do you really need ByRef here? Probably not.

ByVal & ByRef Parameters are independent of Reference & Value Types. All
parameters in VB.NET by default are passed ByVal, you should only pass a
parameter ByRef when you have to, which is when you need to modify the
callers variable.

A Reference Type is an object that exists on the heap. If I have a variable
that is a reference type and assign the variable to another variable. Both
variables will be pointing to the same object on the heap.

Dim x As Person
x = New Person()
Dim y As Person
y = x

Both x & y are the exact same Person object on the heap.

A Value Type does not live on the Heap. If I have a value type variable and
I assign it to another variable, a copy of the value is made.

Dim x As Integer
x = 100
Dim y As Integer
y = x

Although both x & y have the value 100, they are physically different values
as a copy was made.

Now when you pass a variable to a ByVal parameter a copy of the variable is
made. So for a Reference Type a copy of the reference is made, which means
there is still only one object on the heap & two references to that object.
For a Value Type a copy of the value is made.

When you pass a variable to a ByRef parameter a reference to that variable
is made. So for a Reference Type you have a reference to a reference to the
object, for a Value Type you have a reference to the value.

Remember ByVal & ByRef are how parameters are passed. Reference & Value
Types are how quantities are stored.

The following site also does a good job of explaining Reference & Value
types & ByRef & ByVal parameters.

http://www.yoda.arachsys.com/csharp/parameters.html
Hope this helps
Jay

"Shannon Richards" <sr**********@hotmail.com> wrote in message
news:OS**************@TK2MSFTNGP11.phx.gbl...
Here's what's really happening:

lo_Gateway.Insert(ByRef ao_Object As Object) - takes an argument of type
object.

Since all reference types derive from object in .Net why is the compiler
giving this error? Income is an Object...



Nov 21 '05 #9
Hello: Thank you all for your fantastic comments. I understand more about
the issue now.

One additional question...
When dealing with reference types as parameters. Is it more efficient to
code the parameter as ByRef since ByVal will end up creating another pointer
to the reference type being passed into the method?

Thank you,
Shannon
"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:eE**************@tk2msftngp13.phx.gbl...
Shannon,
In addition to the other comments (especially Nick's):

Insert is using ByRef, Do you really need ByRef here? Probably not.

ByVal & ByRef Parameters are independent of Reference & Value Types. All
parameters in VB.NET by default are passed ByVal, you should only pass a
parameter ByRef when you have to, which is when you need to modify the
callers variable.

A Reference Type is an object that exists on the heap. If I have a
variable
that is a reference type and assign the variable to another variable. Both
variables will be pointing to the same object on the heap.

Dim x As Person
x = New Person()
Dim y As Person
y = x

Both x & y are the exact same Person object on the heap.

A Value Type does not live on the Heap. If I have a value type variable
and
I assign it to another variable, a copy of the value is made.

Dim x As Integer
x = 100
Dim y As Integer
y = x

Although both x & y have the value 100, they are physically different
values
as a copy was made.

Now when you pass a variable to a ByVal parameter a copy of the variable
is
made. So for a Reference Type a copy of the reference is made, which means
there is still only one object on the heap & two references to that
object.
For a Value Type a copy of the value is made.

When you pass a variable to a ByRef parameter a reference to that variable
is made. So for a Reference Type you have a reference to a reference to
the
object, for a Value Type you have a reference to the value.

Remember ByVal & ByRef are how parameters are passed. Reference & Value
Types are how quantities are stored.

The following site also does a good job of explaining Reference & Value
types & ByRef & ByVal parameters.

http://www.yoda.arachsys.com/csharp/parameters.html
Hope this helps
Jay

"Shannon Richards" <sr**********@hotmail.com> wrote in message
news:OS**************@TK2MSFTNGP11.phx.gbl...
Here's what's really happening:

lo_Gateway.Insert(ByRef ao_Object As Object) - takes an argument of type
object.

Since all reference types derive from object in .Net why is the compiler
giving this error? Income is an Object...


Nov 21 '05 #10
Hello: Thank you all for your fantastic comments. I understand more about
the issue now.

One additional question...
When dealing with reference types as parameters. Is it more efficient to
code the parameter as ByRef since ByVal will end up creating another pointer
to the reference type being passed into the method?

Thank you,
Shannon
"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:eE**************@tk2msftngp13.phx.gbl...
Shannon,
In addition to the other comments (especially Nick's):

Insert is using ByRef, Do you really need ByRef here? Probably not.

ByVal & ByRef Parameters are independent of Reference & Value Types. All
parameters in VB.NET by default are passed ByVal, you should only pass a
parameter ByRef when you have to, which is when you need to modify the
callers variable.

A Reference Type is an object that exists on the heap. If I have a
variable
that is a reference type and assign the variable to another variable. Both
variables will be pointing to the same object on the heap.

Dim x As Person
x = New Person()
Dim y As Person
y = x

Both x & y are the exact same Person object on the heap.

A Value Type does not live on the Heap. If I have a value type variable
and
I assign it to another variable, a copy of the value is made.

Dim x As Integer
x = 100
Dim y As Integer
y = x

Although both x & y have the value 100, they are physically different
values
as a copy was made.

Now when you pass a variable to a ByVal parameter a copy of the variable
is
made. So for a Reference Type a copy of the reference is made, which means
there is still only one object on the heap & two references to that
object.
For a Value Type a copy of the value is made.

When you pass a variable to a ByRef parameter a reference to that variable
is made. So for a Reference Type you have a reference to a reference to
the
object, for a Value Type you have a reference to the value.

Remember ByVal & ByRef are how parameters are passed. Reference & Value
Types are how quantities are stored.

The following site also does a good job of explaining Reference & Value
types & ByRef & ByVal parameters.

http://www.yoda.arachsys.com/csharp/parameters.html
Hope this helps
Jay

"Shannon Richards" <sr**********@hotmail.com> wrote in message
news:OS**************@TK2MSFTNGP11.phx.gbl...
Here's what's really happening:

lo_Gateway.Insert(ByRef ao_Object As Object) - takes an argument of type
object.

Since all reference types derive from object in .Net why is the compiler
giving this error? Income is an Object...


Nov 21 '05 #11
Shannon,
It is more correct to use ByVal, as ByVal indicates the intent of your code!

ByVal indicates that you do not intend on modifying the caller's variable.

ByRef indicates that you intend on modifying the caller's variable.
I would not worry about "more efficient" unless the routine was profiled &
proven to have a efficiency problem. (see 80/20 below)
I have not profiled the effect of ByVal verses ByRef, however I would expect
ByRef to be a fraction of a nanosecond slower, as you are dereferencing two
references (you dereference the parameter, then you dereference the
variable). Where as ByVal you do a single dereference (you dereference the
parameter). In both cases a value needs to be placed on the stack. Also the
compiler & JIT compiler can & will optimize the code, if I attempt to use
ByRef to "optimize" the code & second guess the optimizer, I may wind up
hurting the compiler's or JIT's optimizations...

So I use ByVal & ByRef to indicate intent of the code.
Just Remember the 80/20 rule. That is 80% of the execution time of your
program is spent in 20% of your code. I will optimize (worry about
performance, memory consumption) the 20% once that 20% has been identified &
proven to be a performance problem via profiling (CLR Profiler is one
profiling tool).

For info on the 80/20 rule & optimizing only the 20% see Martin Fowler's
article "Yet Another Optimization Article" at
http://martinfowler.com/ieeeSoftware...timization.pdf

Info on the CLR Profiler:
http://msdn.microsoft.com/library/de...nethowto13.asp

http://msdn.microsoft.com/library/de...anagedapps.asp

Hope this helps
Jay

"Shannon Richards" <sr**********@hotmail.com> wrote in message
news:eM**************@TK2MSFTNGP14.phx.gbl...
Hello: Thank you all for your fantastic comments. I understand more
about the issue now.

One additional question...
When dealing with reference types as parameters. Is it more efficient to
code the parameter as ByRef since ByVal will end up creating another
pointer to the reference type being passed into the method?

Thank you,
Shannon
"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:eE**************@tk2msftngp13.phx.gbl...
Shannon,
In addition to the other comments (especially Nick's):

Insert is using ByRef, Do you really need ByRef here? Probably not.

ByVal & ByRef Parameters are independent of Reference & Value Types. All
parameters in VB.NET by default are passed ByVal, you should only pass a
parameter ByRef when you have to, which is when you need to modify the
callers variable.

A Reference Type is an object that exists on the heap. If I have a
variable
that is a reference type and assign the variable to another variable.
Both
variables will be pointing to the same object on the heap.

Dim x As Person
x = New Person()
Dim y As Person
y = x

Both x & y are the exact same Person object on the heap.

A Value Type does not live on the Heap. If I have a value type variable
and
I assign it to another variable, a copy of the value is made.

Dim x As Integer
x = 100
Dim y As Integer
y = x

Although both x & y have the value 100, they are physically different
values
as a copy was made.

Now when you pass a variable to a ByVal parameter a copy of the variable
is
made. So for a Reference Type a copy of the reference is made, which
means
there is still only one object on the heap & two references to that
object.
For a Value Type a copy of the value is made.

When you pass a variable to a ByRef parameter a reference to that
variable
is made. So for a Reference Type you have a reference to a reference to
the
object, for a Value Type you have a reference to the value.

Remember ByVal & ByRef are how parameters are passed. Reference & Value
Types are how quantities are stored.

The following site also does a good job of explaining Reference & Value
types & ByRef & ByVal parameters.

http://www.yoda.arachsys.com/csharp/parameters.html
Hope this helps
Jay

"Shannon Richards" <sr**********@hotmail.com> wrote in message
news:OS**************@TK2MSFTNGP11.phx.gbl...
Here's what's really happening:

lo_Gateway.Insert(ByRef ao_Object As Object) - takes an argument of type
object.

Since all reference types derive from object in .Net why is the compiler
giving this error? Income is an Object...



Nov 21 '05 #12
Shannon,
It is more correct to use ByVal, as ByVal indicates the intent of your code!

ByVal indicates that you do not intend on modifying the caller's variable.

ByRef indicates that you intend on modifying the caller's variable.
I would not worry about "more efficient" unless the routine was profiled &
proven to have a efficiency problem. (see 80/20 below)
I have not profiled the effect of ByVal verses ByRef, however I would expect
ByRef to be a fraction of a nanosecond slower, as you are dereferencing two
references (you dereference the parameter, then you dereference the
variable). Where as ByVal you do a single dereference (you dereference the
parameter). In both cases a value needs to be placed on the stack. Also the
compiler & JIT compiler can & will optimize the code, if I attempt to use
ByRef to "optimize" the code & second guess the optimizer, I may wind up
hurting the compiler's or JIT's optimizations...

So I use ByVal & ByRef to indicate intent of the code.
Just Remember the 80/20 rule. That is 80% of the execution time of your
program is spent in 20% of your code. I will optimize (worry about
performance, memory consumption) the 20% once that 20% has been identified &
proven to be a performance problem via profiling (CLR Profiler is one
profiling tool).

For info on the 80/20 rule & optimizing only the 20% see Martin Fowler's
article "Yet Another Optimization Article" at
http://martinfowler.com/ieeeSoftware...timization.pdf

Info on the CLR Profiler:
http://msdn.microsoft.com/library/de...nethowto13.asp

http://msdn.microsoft.com/library/de...anagedapps.asp

Hope this helps
Jay

"Shannon Richards" <sr**********@hotmail.com> wrote in message
news:eM**************@TK2MSFTNGP14.phx.gbl...
Hello: Thank you all for your fantastic comments. I understand more
about the issue now.

One additional question...
When dealing with reference types as parameters. Is it more efficient to
code the parameter as ByRef since ByVal will end up creating another
pointer to the reference type being passed into the method?

Thank you,
Shannon
"Jay B. Harlow [MVP - Outlook]" <Ja************@msn.com> wrote in message
news:eE**************@tk2msftngp13.phx.gbl...
Shannon,
In addition to the other comments (especially Nick's):

Insert is using ByRef, Do you really need ByRef here? Probably not.

ByVal & ByRef Parameters are independent of Reference & Value Types. All
parameters in VB.NET by default are passed ByVal, you should only pass a
parameter ByRef when you have to, which is when you need to modify the
callers variable.

A Reference Type is an object that exists on the heap. If I have a
variable
that is a reference type and assign the variable to another variable.
Both
variables will be pointing to the same object on the heap.

Dim x As Person
x = New Person()
Dim y As Person
y = x

Both x & y are the exact same Person object on the heap.

A Value Type does not live on the Heap. If I have a value type variable
and
I assign it to another variable, a copy of the value is made.

Dim x As Integer
x = 100
Dim y As Integer
y = x

Although both x & y have the value 100, they are physically different
values
as a copy was made.

Now when you pass a variable to a ByVal parameter a copy of the variable
is
made. So for a Reference Type a copy of the reference is made, which
means
there is still only one object on the heap & two references to that
object.
For a Value Type a copy of the value is made.

When you pass a variable to a ByRef parameter a reference to that
variable
is made. So for a Reference Type you have a reference to a reference to
the
object, for a Value Type you have a reference to the value.

Remember ByVal & ByRef are how parameters are passed. Reference & Value
Types are how quantities are stored.

The following site also does a good job of explaining Reference & Value
types & ByRef & ByVal parameters.

http://www.yoda.arachsys.com/csharp/parameters.html
Hope this helps
Jay

"Shannon Richards" <sr**********@hotmail.com> wrote in message
news:OS**************@TK2MSFTNGP11.phx.gbl...
Here's what's really happening:

lo_Gateway.Insert(ByRef ao_Object As Object) - takes an argument of type
object.

Since all reference types derive from object in .Net why is the compiler
giving this error? Income is an Object...



Nov 21 '05 #13
Shanon,
One additional question...
When dealing with reference types as parameters. Is it more efficient to
code the parameter as ByRef since ByVal will end up creating another
pointer to the reference type being passed into the method?

In my idea it was just the oposite.

However see this message in this newsgroup

http://groups.google.com/groups?selm...tngp13.phx.gbl

Cor
Nov 21 '05 #14
Shanon,
One additional question...
When dealing with reference types as parameters. Is it more efficient to
code the parameter as ByRef since ByVal will end up creating another
pointer to the reference type being passed into the method?

In my idea it was just the oposite.

However see this message in this newsgroup

http://groups.google.com/groups?selm...tngp13.phx.gbl

Cor
Nov 21 '05 #15

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Jacob Jensen | last post by:
This question has probably been asked a million time, but here it comes again. I want to learn the difference between the three type cast operators: static_cast, reinterpret_cast, dynamic_cast. A...
231
by: Brian Blais | last post by:
Hello, I saw on a couple of recent posts people saying that casting the return value of malloc is bad, like: d=(double *) malloc(50*sizeof(double)); why is this bad? I had always thought...
35
by: ytrama | last post by:
Hi, I have read in one of old posting that don't cast of pointer which is returned by the malloc. I would like to know the reason. Thanks in advance, YTR
7
by: yufufi | last post by:
lets say we have a 'shape' class which doesn't implement IComparable interface.. compiler doesn't give you error for the lines below.. shape b= new shape(); IComparable h; h=(IComparable)b;...
7
by: Jim Bancroft | last post by:
Hi everyone, A basic one here, I think. I haven't found the pattern yet, but sometimes when I cast a variable to another type using the "C" style cast operator the compiler refuses to play...
2
by: Enrique Bustamante | last post by:
Casting arrays that works on watch and command window but not in code. My application is casting arrays in a way it should work. To test if I was doing something invalid, I wrote a test code that...
7
by: S. Lorétan | last post by:
Hi guys, Sorry for this stupid question, but I don't know why it isn't working. Here is my (example) code: namespace Test { class A { public string Label1; }
17
by: sophia.agnes | last post by:
Hi , I was going through peter van der linden's book Expert C programming, in this book there is a section named "How and why to cast" the author then says as follows (float) 3 - it's a...
9
by: Taras_96 | last post by:
Hi everyone, I was experimenting with static_cast and reinterpret cast #include <iostream> struct A1 { int a; }; struct A2 { double d; }; struct B : public A1, A2
101
by: Tinkertim | last post by:
Hi, I have often wondered if casting the return value of malloc() (or friends) actually helps anything, recent threads here suggest that it does not .. so I hope to find out. For instance : ...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.