"Another" one automation error... - C# Discussion Boards

ellllllllie5-Jan-09 23:03

5-Jan-09 23:03

hello,
i have created a setup for my application that instance a database into sql server.
when adding some features to my project i have changed some tables and some columns in my database.
My problem is that: how to update the database in my setup without overwriting the existing database and also do not losing the data.
any help is appreciated.
regards

dghdfghdfghdfghdgh

Re: SQL Merge

Wendelius5-Jan-09 23:42

Wendelius

5-Jan-09 23:42

Instead of installing a database during an upgrade setup you should create a script which adds/updated/removes the rows/columns/tables to datatabase.

The need to optimize rises from a bad design.My articles[^]

Re: SQL Merge

SeMartens5-Jan-09 23:44

SeMartens

5-Jan-09 23:44

Hi ellie,

you could try to use a sql-script that looks like this:

<br />
 IF NOT EXISTS (SELECT COLUMN_NAME FROM syscolumns WHERE COLUMN_NAME = 'MyColumn') THEN<br />
   ALTER TABLE ADD COLUMN MyColumn varchar(256) NULL;<br />
 END IF<br />

You can use this style for tables, triggers, columns etc.

During your installation you can execute this script.

Hope this helps you.

Regards
Sebastian

P.S.: Be sure to modify the sql-code above to the grammar of your sql server.

It's not a bug, it's a feature!

Me in Softwareland.

Who is coneected with My Mechine

nidheeshkayal5-Jan-09 22:52

nidheeshkayal

5-Jan-09 22:52

Hi all,

I need to create an application thru coding which will pop up when a user trying to establish a connection with my mechine.

Is there any way to do this

Language : C#.net

Thanx

Nidheesh

Re: Who is coneected with My Mechine

rah_sin5-Jan-09 23:24

rah_sin

5-Jan-09 23:24

Yes there is very easy way to do it
Step 1. Search on google.
Step 2. Start coding.
$Shucks | :-\$

rahul

Re: Who is coneected with My Mechine

nidheeshkayal5-Jan-09 23:51

nidheeshkayal

5-Jan-09 23:51

thanx Rahul...

Re: Who is coneected with My Mechine

EliottA6-Jan-09 2:01

EliottA

6-Jan-09 2:01

"Another" one automation error...

Member 28952165-Jan-09 22:29

Member 2895216

5-Jan-09 22:29

Hello all,

There is some C# 2005 component that I want to use from VB6.
C# DLL registered for COM interop.
If I run VB application as stand-alone all works fine.
If I want to debug an application from VB IDE I get an "automation error" on NEW with error code -2146233036(80131534).

All sagestions appreciated...

Re: "Another" one automation error...

Simon P Stevens5-Jan-09 23:01

Simon P Stevens

5-Jan-09 23:01

When you run in the IDE, your app's path is effectively c:\Program Files\Microsoft Visual Studio\VB98\VB6.EXE. This means it will search for the dll in the VB98 directory. Try placing your dll here. Or adding a environment variable "devpath" to point to the dlls location.

Simon

Re: "Another" one automation error...

Member 28952165-Jan-09 23:16

Member 2895216

5-Jan-09 23:16

Simon, thank you for replay!

I have solved this issue exectly as you proposed: placed all referenced assemblies in VB6's directory.
But I don't understand why it looking for them there... I checked CurDir and in debug time it's a my application EXE directory, rather than VB's directory.
So, VB6.EXE loads my application exe; looks in registry for COM interop; loads a TLB from my application directory and ....? How it comes back to VB6's directory?

Re: "Another" one automation error...

Simon P Stevens5-Jan-09 23:34

Simon P Stevens

5-Jan-09 23:34

Check the App.Path rather than the CurDir. You'll find it's set to the VB98 directory.

Don't quote me on this, but my guess is you've got your order wrong. This is my guess at what is going on.
1) VB6 loads app exe.
2) Sees requirement for external assembly reference.
3) Searches App.Path location for required assembly.
4) Assembly found, and read, TLB required so check registry.
5) TLB location read from registry.
6) TLB loaded.

In .net you can use the Fusion log viewer[^] to monitor assembly bindings and searched locations as they are loaded. I don't know if it works when the assembly is being loaded by VB6 though.

Simon

Re: "Another" one automation error...

Member 28952166-Jan-09 0:16

Member 2895216

6-Jan-09 0:16

and again thank you for fast replay Smile | :)

!
and for VERY helpfull tool (yep, seems it's monitoring entire CLR activity, so an interop activity as well).

XML attribute issue during desrialize

George_George5-Jan-09 21:55

George_George

5-Jan-09 21:55

Hello everyone,

I am using xsd to generate a C# class from an XML file. I noticed there are a couple of fields of the generated classes are marked with various XML attribute, like XML attribute and XML element.

Now I want to add more restrictions to the input XML file during deserialization,

- Make some fields in the C# class not nullable during serialization;

- Make some fields to accept only numbers (currently the automatic generated C# file is using string type other than number type to represent the fields).

Any ideas about how to decorate the generated C# class file to achieve the goal?

thanks in advance,
George

How to create a Web site in which user can create his mail account

rahuladya5-Jan-09 20:14

rahuladya

5-Jan-09 20:14

Hello Forum

I am new for this concept.
I want to create a web site in Asp.Net using c#.Net in which user can create his mail account like in code project,yahoo or gmail etc...like

abc@gmai.com

Do i need my own server?or the domain space will be sufficient on any server?

Any Basic Technology required?

Can any bdy tell me some steps to follow in the creation of that Web site

My basic Confusion is how and where to store the Mails and their format...?

Thanx n Regards
Rahul

Re: How to create a Web site in which user can create his mail account

Lev Danielyan5-Jan-09 20:39

Lev Danielyan

5-Jan-09 20:39

The domain name is not sufficient for hosting a mail server.
The hard way will be to create a Mail Server web application, but actually there are a lot of ready solutions, so you can go the easy way, i.e. register a domain name and tie it with Google Apps[^], it's free and setup takes minutes.

But, if you really want to go for your own mail server, start by reading the following RFCs:
RFC 821 - SMTP[^]
RFC 1939 - POP3[^]
RFC 3501 - IMAP4rev1[^]

PS. RFC - Request for comments, this is basically the description of protocols. SMPT/POP3 - are protocols for sending/receiving e-mail, IMAP4 - is also a mail protocol, but a very sophisticated one.

Regards,
Lev

Re: How to create a Web site in which user can create his mail account

rahuladya6-Jan-09 1:51

rahuladya

6-Jan-09 1:51

Hello Lev,

Thanx for ur reply and sorry for cross posting.

Lev can u send me any link or help regarding tying my domain name with google apps...I am not able to getting u exactly..

Thanx again Lev.

Re: How to create a Web site in which user can create his mail account

EliottA6-Jan-09 2:03

EliottA

6-Jan-09 2:03

Register a domain with a registrar like godaddy[^] and then purchase some hosting. Shouldn't be more then 10$ a month. You can pay some extra $ for 100 extra emails. The you are free to create as many whateveryoulike@yourdomains.com as you wish.

Re: How to create a Web site in which user can create his mail account

Lev Danielyan6-Jan-09 2:26

Lev Danielyan

6-Jan-09 2:26

Just like Eliot said Smile | :)

But with Google Apps you won't need to purchase a hosting and pay for e-mail addresses, just a domain name is enough. I've already given you the link, but here it goes again Google Apps[^]. Read their tutorials and you'll have everything straightened out.

PS. I switched to google apps a couple of months ago, and it's really cool for a free product (they do actually have a commercial version with more options, but you decide what you need Wink | ;)

)

Regards,
Lev

How add delay in Displaying ToolTip Text

himuskanhere5-Jan-09 19:19

himuskanhere

5-Jan-09 19:19

Hello friends
I have a combo box, on ComboBox dropDown i have to show tooltip for combo box item.But tooltip should dislay after some time delay.
I have used toolTip.Show(...) which shows toolTip text immediatly.

Thanks in advance Blush | :O

Re: How add delay in Displaying ToolTip Text

dan!sh 5-Jan-09 19:29

dan!sh

5-Jan-09 19:29

Use InitialDelay property.

The word "politics" describes the process so well: "Poli" in Latin meaning "many" and "tics" meaning "bloodsucking creatures."

Re: How add delay in Displaying ToolTip Text

himuskanhere5-Jan-09 20:07

himuskanhere

5-Jan-09 20:07

i already had used InitialDelay = 1000 but it isnt work.

Re: How add delay in Displaying ToolTip Text

N a v a n e e t h5-Jan-09 21:08

N a v a n e e t h

5-Jan-09 21:08

himuskanhere wrote:
i already had used InitialDelay = 1000 but it isnt work.

Read the documentation[^] and it clearly says

The period of time, in milliseconds, that the pointer must remain stationary on a control before the ToolTip window is displayed.

1000 millisecond is 1 second. So you will not feel the difference. Consider putting some big value and test it.

Navaneeth

How to use google | Ask smart questions

Re: How add delay in Displaying ToolTip Text

dan!sh 5-Jan-09 21:09

dan!sh

5-Jan-09 21:09

Can you show the code block you are using?

The word "politics" describes the process so well: "Poli" in Latin meaning "many" and "tics" meaning "bloodsucking creatures."

Re: How add delay in Displaying ToolTip Text

Dragonfly_Lee5-Jan-09 21:14

Dragonfly_Lee

5-Jan-09 21:14

himuskanhere wrote:
i already had used InitialDelay = 1000 but it isnt work.

What about InitialDelay = 10000? It must be easy for us to tell the difference. Smile | :)

Tan Li

I Love KongFu~

Passing Override Method into Deligates

satsumatable5-Jan-09 17:38

satsumatable

5-Jan-09 17:38

Hi,

I've 2 classes Parent and Child, Parent has some Virtual Methods those are basically override in child class. I'm trying to call those override methods through delegate, unfortunately it always refers base class not child class method (that is override). What might be the wrong?

Thanks in advance

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.