Re: how to add button click events(C#.net) to database(SQL2005) - C# Discussion Boards

Re: how to find latest table created from database.

8-May-09 0:06

That depends on the database.. but most have a master db where you can query that type of information (Mysql, MS SQL)

You should look at the vendors site how to query the master db/table and you should be there

Do Or Don't, there is no "try catch ex as exception end try"

Mycroft Holmes8-May-09 1:29

Mycroft Holmes

8-May-09 1:29

Look into the system information/schema views in sql 2005+ and sysobject in earlier versions.

Never underestimate the power of human stupidity
RAH

Re: how to find latest table created from database.

J4amieC8-May-09 1:30

J4amieC

8-May-09 1:30

See my answer above, you have this whole database thing wrong- you dont create new tables for entities - you create new rows within a table. If you add a timestamp to every row, its pretty darn easy to find the most recently created row.

Re: how to find latest table created from database.

Rajesh Anuhya8-May-09 3:16

Rajesh Anuhya

8-May-09 3:16

if u r using oracle

go through this

SQL> desc dba_objects;
Name
--------------------------------
OWNER
OBJECT_NAME
SUBOBJECT_NAME
OBJECT_ID
DATA_OBJECT_ID
OBJECT_TYPE
CREATED
LAST_DDL_TIME
TIMESTAMP
STATUS
TEMPORARY
GENERATED
SECONDARY

dba_objects has every objects create datestamp..

i think this may help u

Rajesh B --> A Poor Workman Blames His Tools <--

[Message Deleted]

Mads1157-May-09 23:36

Mads115

7-May-09 23:36

[Message Deleted]

Re: how to add button click events(C#.net) to database(SQL2005)

Noctris8-May-09 0:00

Re: how to add button click events(C#.net) to database(SQL2005)

8-May-09 0:00

I would actually use a checkbox for this.

Change the appearence property from "normal" to "Button"

then just say that "checked" = "A"
unchecked = "a"

Do Or Don't, there is no "try catch ex as exception end try"

WinSolution8-May-09 1:08

WinSolution

8-May-09 1:08

here is the logic . convert it to C# code.

Button Button1; // by default button text will be On
bool btn_status = true;

public void Button1_Click()
if(btn_status)
{
//put query here to write A
Button1.Text = "Off";
btn_status = !btn_status; //! Operator will alter boolean value of btn_status
}
else
{
//put query here to write a
Button1.Text = "On";
btn_status = !btn_status;
}

Re: how to add button click events(C#.net) to database(SQL2005)

musefan8-May-09 2:21

musefan

8-May-09 2:21

Hi,

And its not evening here yet/anymore...

you have been trying to do this for over a week now and all you CP posts have been related to this.

I strongly suggest you start from the basics and get yourself a good beginners book on C#.Net, as this is a fairly straight forward task and you don't seem to be able to do it, despite the help given in your previous posts.

But I'll give you another go...

Do you have any database code at the moment? If so, does it work?
When are you wanting to write to the database? On a button click?
Have you actually got your button to work? i.e. changes when clicked, and you are able to retrieve a value to state if it is On or Off when needed?

Answer these and then we can progress.... Hopefully

Life goes very fast. Tomorrow, today is already yesterday.

inserting Hyperlink inside windows form

shabya7-May-09 23:23

7-May-09 23:23

Hello,
i want to add a hyperlink of a webpage to my form
is there a way to do it?

i am using the System.Diagnostics.Process.Start... with a file with 'html' extention but this lacks the posibility to open a browser's window in a new page. it runs over existing pages.

tnx,

avi

OriginalGriff7-May-09 23:31

OriginalGriff

7-May-09 23:31

If you are IE, then : http://www.ieinfosite.co.uk/tip_view.asp?id=36[^]
"/new" is what you want. Chances are Firefox et al. support this also.

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

shabya8-May-09 1:26

8-May-09 1:26

nope.. its still running over existing pages..
looks like the 'new' code is valid only if i specify :

iexplore.exe www.xyz.com -new

but i dont know which browser my client has..

MickCurley8-May-09 0:00

MickCurley

8-May-09 0:00

Hello

What about using a LinkLabel.

Bye

shabya8-May-09 1:28

8-May-09 1:28

yes , i did it but my problem is the new link overruns existing pages.
like here i am in this page writing a comment, if i click the link it will be instead of this page and not open a new one.
i want to use the target="..." thing..

MumbleB8-May-09 0:48

MumbleB

8-May-09 0:48

Have a look at this post[^]

Excellence is doing ordinary things extraordinarily well.

shabya8-May-09 1:26

Global ( sort of) event ?

8-May-09 1:26

nope, it still overruns existing pages...

Noctris7-May-09 23:19

Re: Global ( sort of) event ?

7-May-09 23:19

Hi,

I have a class library, which actuall is a little application itself. It does communication with our server, starts a download queue and autodownloader and does some background processing.

This to provide data and files for the different host app's that are using this class library ( see it as a communications client)

now in the library, i have some events that need to be received by the host app like for example:

FileCountChanged. the problems is, this can be triggered from The AutoDownloader because it finished a download, from the TCP Client cause the server told him to delete a file etc etc..

Now my question is: is there a way to raise a global event from different classes ?

The more or less same question applies to variables ( objects). Can i change the variable of my main class from its sub classes ?

Something like for example:

<br />
<br />
public delegate void FileCountChangedEventHandler(FileType filetype,int count);<br />
public class MyClient<br />
{<br />
<br />
// Should be raised if:<br />
// File get's deleted, File is added, <br />
// This can be initiated from many different classes...<br />
// How do <br />
public event FilecountChanged(FileType filetype,int count);<br />
private DownloadQueue _dlqueue = new _dlqueue();<br />
<br />
// I should be able to add and remove downloads in this queue from anywhere HOWEVER.. it must be this queue. Do i have to pass this to <br />
// all the classes that need to use it ? And do i use ref or just normal ?<br />
private AutoDownloader dl = null;<br />
public Myclient()<br />
{<br />
dl = new AutoDownloader(_dlqueue);<br />
dl.start();<br />
dl.DownloadCompleted += new eventhandler(ondownloadcompleted);<br />
}<br />
<br />
<br />
<br />
}<br />
<br />

Thanks !

Do Or Don't, there is no "try catch ex as exception end try"

Jimmanuel8-May-09 1:08

Jimmanuel

8-May-09 1:08

Classes shouldn't be raising events that are defined in other classes. If a class MyClient contains some event then it should be up to that MyClient object to determine when to fire it.

If other classes need to manipulate the internal members of the MyClient then there should be some methods to allow controlled access to them. Some of those methods could in turn cause the internal events to be fired.

If you want child classes to be able to add/remove/etc stuff from MyClients Q, the first job is to make the MyClient accessible by whatever objects need it, either by passing around a reference to it, making a static singleton, or by some other method. Then you can add methods to the MyClient like this:

class MyClient
{
  public void AddToQueue(object thingToQ)
  {
    // do whatever you need to add the item to the Q

    if (FilecountChanged != null)
    {
      // fire the event to notify other clients
    }
  }
}

P.S. code tags make text red, pre tags preserve formatting so they're better for code snippets

Re: Global ( sort of) event ?

Noctris9-May-09 8:10

Re: Global ( sort of) event ?

9-May-09 8:10

Hi,

Thanks for the reply.

If i understand correctly, making a class a static singleton( have never done that before :s) would make it availble for calling in the Child class, but the instance of the singleton class that the child gets, would be the same instance as the one the host app would have right ?

I'm a VB.net converty ANd relativly new to development so i am still discovering some of the (c#) syntax and possibilities...

Do Or Don't, there is no "try catch ex as exception end try"

Jimmanuel9-May-09 10:08

Jimmanuel

9-May-09 10:08

Correct. Your most basic static singleton looks like this:

public class MyClass
{
	private static MyClass instance = new MyClass();
	public static MyClass Instance
	{
		get { return instance; }
	}

	public void DoSomething()
	{
		Console.WriteLine("Something");
	}
}

and then all of the objects in your program can access it like this:

MyClass.Instance.DoSomething();

If you have lots of multi-threading in your program then here are some tricks to handle thread-safety with the static object, but in simple programs the basic stuff should suffice.

how to include Sql Server 2000 database in a setup project?

lockepeak7-May-09 22:44

lockepeak

7-May-09 22:44

I am using visual studio 2005.(Frame work 2.0). I have the database with my application.what i want is while making the setup,i want to include the database too.(so that while installing the setup,I need not to install database seperately)...any idea?? thank you for help me!

I anxiouse for the help. By the way,Give me a example more better
lockepeak

Re: how to include Sql Server 2000 database in a setup project?

Noctris8-May-09 0:00