Re: Threaded Form - C# Discussion Boards

29-Aug-07 19:53

What about using FileStream.Seek?

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

Threaded Form

xfitr229-Aug-07 16:30

29-Aug-07 16:30

I am having trouble with closing a form created in a seperate thread. This is what I am trying to accomplish: I have a program that runs in the taskbar. When a user double-clicks a key, a form is created in a new thread and is shown on top of all other forms. When the user clicks anywhere outside the form, the thread will close, but the program will continue to run in the background. This is similar to the Google Desktop functionality. The code works the first time the form is created in a new thread, but if the form has been closed once, you have to click on the form to make it active and then click outside of it before it will close. I have tried using the Deactivate and LostFocus events, but they both only work the first time the form is shown. Any suggestions would be greatful. I have included a snippet of code below.

<br />
public class MyClass {<br />
    private Thread _thread;<br />
    private FMain _fmain;<br />
    private UserActivityHook _keyhook;<br />
<br />
    public MyClass() {<br />
        _keyhook = new UserActivityHook(false, true);<br />
        _keyhook += new KeyEventHandler(KeyDoubleClick);<br />
    }<br />
<br />
    private void KeyDoubleClick(object sender, KeyEventArgs e) {<br />
        if (e.KeyValue == 163) {<br />
            _thread = new Thread(new ThreadStart(OpenForm));<br />
            _thread.Start();<br />
        }<br />
    }<br />
<br />
    private void OpenForm() {<br />
        _fmain = new FMain();<br />
        _fmain.Deactivate += new EventHandler(form_Close);<br />
        _fmain.LostFocus += new EventHandler(form_Close);<br />
        _fmain.ShowDialog();<br />
    }<br />
<br />
    private void form_Close(object sender, EventArgs e) {<br />
        _thread.Abort();<br />
    }<br />
}<br />

References: The UserActivityHook was fortunately posted by George Mamaladze; http://www.codeproject.com/csharp/globalhook.asp[^]

Michael Sync29-Aug-07 17:22

29-Aug-07 17:22

I don't think you need to close the form. Why don't you just hide the form when it is deactivated and show the form when it is activated?

xfitr229-Aug-07 17:35

29-Aug-07 17:35

Thank you for the suggestion. My problem though is trying to get the form to Hide/Close once the user clicks/types outside the form. Is there an event fired when this happens that I am not aware of or do I need to use a global hook? If I was to use a hook, how do I know that the source of the hook was not within the form?

Michael Sync29-Aug-07 18:05

29-Aug-07 18:05

What about Deactivate event of form?

private void Form1_Deactivate(object sender, EventArgs e)<br />
        {<br />
            this.Hide (); <br />
        }

I think that this "Deactivate" event is good enough. I dont think you need to use Window Hooking.

how to backup sql database from c#2005

Spacix One30-Aug-07 3:51

Spacix One

30-Aug-07 3:51

you might be able to use .ActiveForm.Close() if you call it from the same thread which generated(showed) the form, else you'll get a "cross-thread exception"

Is this form some type of information "pop-up" ? if so you could just call .Show() and then set a timer to call the .ActiveFrom.Close() on it. Also keep your current if you click on it and then click away it closes.
This would be a better user experience, as they don't have to keep clicking away close the dialog.

another problem is that you are calling abort() to your thread and not allowing it to exit cleanly

All threads should include a method to stop their execution loop, .abort() is to throw an exception on a soft-locked thread. A situation where you know that it should have quit already but it is stuck in some loop.

The exception doesn't allow the thread to finish its task. Think what will happen if a thread was in the middle of saving some file that was only 1/2 written when it was aborted.

-Spacix
All your skynet questions[^] belong to solved

tech-progg29-Aug-07 16:30

tech-progg

29-Aug-07 16:30

m working on the student management software on c#2005 and sql 2005 , i need to take backup of database " any session" from my application and also save it to the cd. i made differnt database for all session( for Example session07-08, session08-09) so if i want to take backup of sessiono7-08 from my c# application than

<<tech-prog>>

Re: how to backup sql database from c#2005

\laddie31-Aug-07 1:05

\laddie

31-Aug-07 1:05

The below quick function will back up a database

public void BackupDataBase(string databaseName,string Path)
{

string backUpQuery = "USE MASTER"+
"EXEC sp_addumpdevice 'disk', 'MyTestDatabase',"+ path+databaseName+".bak"+
"BACKUP DATABASE "+ databaseName +"TO MyTestDatabase";

SqlConnection con = new SqlConenction(connectionString);
con.Open();

SqlCommand cmd=new SqlCommand(backUpQuery,con);
cmd.ExecuteNonQuery();

}

Please modify the same as required.

laddie

Re: how to backup sql database from c#2005

tech-progg2-Sep-07 16:30

tech-progg

2-Sep-07 16:30

thanks
but cud you plz tell waht i write instead of 'disk' and MyTestDatabase'

<<tech-prog>>

Insert statment for multiple tables

falles0129-Aug-07 15:49

29-Aug-07 15:49

Could someone possibly please show me an example, even if it's a parametized query how I can insert into multiple tables.
I have a new employees form with name, role, manager, division, skills, applications. The employee table only has the employeeID primary key, firstname, lastname and then all the foreign key id's for the other tables. The other tables have the other info like description etc.

If I'm creating a new employee, I obviously want them all to update based on the same employee and then the ID's to automatically insert based on the pf fk relationship.

I have searched on google but I can only find examples where you insert one at a time, which works but its not related to the employeei have entered.

Thank you so much

tech-progg29-Aug-07 16:33

tech-progg

29-Aug-07 16:33

betetr you use trigers (insert) to insert data in all table based on the employee table

<<tech-prog>>

falles0129-Aug-07 16:40

29-Aug-07 16:40

Thanks. I'm after any example you can give me. Could you possibly give me an example. I tried the following but the whole injection attack thing. I think the ands could be wrog. Please feel free to

string sql = "INSERT INTO employees(Firstname,Lastname) Values ('" + FirsttextBox.Text.ToString() + "' , '" + LasttextBox.Text.ToString() + "' and Insert into Role (Role) Values ('" + RolecomboBox1.Text.ToString() + "')Insert into Manager (MFirstname) Values ('" + ManagercomboBox1.Text.ToString() + "') Insert into Division (DivisionName) Values ('" + DivisioncomboBox1.Text.ToString() + "')";

Confused | :confused:

Not Active29-Aug-07 17:35

Not Active

29-Aug-07 17:35

A trigger may not always be the best solution. You have to look at performance and other aspects also.

only two letters away from being an asset

xfitr229-Aug-07 16:38

29-Aug-07 16:38

Your best solution would be to create a stored procedure and call it within your code "ExecuteNonQuery." The stored procedure will do all the work of inserting the records into the proper tables. As far as I know, there is not a way, with SQL Server, to insert into multiple tables with one INSERT statement. This also gives you the ability to do error checking on the back-end.

falles0129-Aug-07 16:42

29-Aug-07 16:42

Thanks, I do have the statement in the nonexecutequery block already.

Is it possible to give me a little exampypoos???;)

xfitr229-Aug-07 17:02

29-Aug-07 17:02

CREATE PROCEDURE sp_InsertEmployee
@Firstname nvarchar(50),
@Lastname nvarchar(50),
@Role nvarchar(50),
@Manager nvarchar(50),
@Division nvarchar(50)
AS
BEGIN
SET NOCOUNT ON;

INSERT INTO EMPLOYEES (FIRSTNAME, LASTNAME) VALUES (@FIRSTNAME, @LASTNAME)
INSERT INTO [ROLE] ([ROLE]) VALUES (@ROLE)
INSERT INTO MANAGER (MFIRSTNAME) VALUES (@MANAGER)
INSERT INTO DIVISION (DIVISIONNAME) VALUES (@DIVISION)
END
GO

falles0129-Aug-07 17:10

29-Aug-07 17:10

Thanks so much. Is this case sensitive. You have all the names correct so I copied and pasted this before my executenonquery statment and there are red lines all over it. Okay I feel really dumb about now. It came up with ; errors so I'm guessing that I don't just copy exactly what you have done?

Oh god. I'm waiting to be told off. Wink | ;)

xfitr229-Aug-07 17:14

29-Aug-07 17:14

That was a SQL statement for creating a stored procedure in SQL Server. Once you create it in SQL Server, you can then call it using a class like SqlDataReader and use the method ExecuteNonQuery. Don't forget to add your parameters!

Michael Sync29-Aug-07 17:24

29-Aug-07 17:24

Don't forget to use "Transaction" when you are trying to manipulate data from more than one table...