|
Hi All,
I accedentailly deleted a Sql Table .Can you give me an Idea how to recover it?
Thanks
|
|
|
|
|
Wrong forum.
Restore the back up if you have taken it.
|
|
|
|
|
I am not good in Sql ? Can you please get me a little bit of hint?
|
|
|
|
|
All i have is a Database.dat file ? is it the one i have to pick up.
|
|
|
|
|
|
How can i restore a database from a *.dat file?
|
|
|
|
|
When you reply to yourself do you get an email saying you have sent yourself a message?
Life goes very fast. Tomorrow, today is already yesterday.
modified on Friday, September 25, 2009 5:14 AM
|
|
|
|
|
Only if you checked the "Send me an e-mail if someone replies to this message" checkbox. You should know that by now. 
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Huh, I don't think I have ever looked at those option before 
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
If a reply falls in a forest do we, existentially, care?
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
kibromg wrote: Can you please get me a little bit of hint?
WRONG FORUM this is C# not SQL
How's that for small hint?
only two letters away from being an asset
|
|
|
|
|
In this windows service, I have a log configured to record the Windows Service Start and Stop state and the process triggered by a timer. The process is sending an email notification once a day.
Currently, the Windows Service Start and Stop state is recoding successfully in the log. The email notification process triggered by the timer however is not doing anything. Any help is much appreciated.
See my script below:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.ServiceProcess;
using System.Text;
using System.IO;
using System.Timers;
namespace IRISEmailNotifier
{
public partial class IRISEmailNotifier : ServiceBase
{
public IRISEmailNotifier()
{
InitializeComponent();
}
protected override void OnStart(string[] args)
{
try
{
LogEntry le = new LogEntry("Start - " + DateTime.Now.ToString() + "\n");
this.timer1.Interval = 10000;
this.timer1.Enabled = true;
this.timer1.Tick += new EventHandler(timer1_Tick);
}
catch (Exception ex)
{
LogEntry le = new LogEntry(ex.ToString());
}
}
void timer1_Tick(object sender, EventArgs e)
{
try
{
LogEntry le = new LogEntry("Send Email - " + DateTime.Now.ToString() + "\n");
}
catch (Exception ex)
{
LogEntry le = new LogEntry(ex.ToString());
}
}
protected override void OnStop()
{
try
{
LogEntry le = new LogEntry("Stop - " + DateTime.Now.ToString() + "\n");
this.timer1.Enabled = false;
}
catch (Exception ex)
{
LogEntry le = new LogEntry(ex.ToString());
}
}
private void SendEmailNotification()
{
try
{
LogEntry le = new LogEntry("Send Email - " + DateTime.Now.ToString() + "\n");
}
catch (Exception ex)
{
LogEntry le = new LogEntry(ex.ToString());
}
}
}
}
Thanks, Steve C.
Steve C.
kstv@netzero.net
|
|
|
|
|
Are you using a Windows Form timer? IIRC, System.Timers.Timer has an elapsed event, not a tick event but I could be wrong.
|
|
|
|
|
I am. I picked it from the toolbox and dropped in the design page. Am I using the wrong timer? If so, please advice.
Steve C.
kstv@netzero.net
|
|
|
|
|
Well, I'm guessing your windows service doesn't have a form so I'm not sure Windows.Forms.Timer would work, if I were you I'd try using System.Timers.Timer, it might not solve your problem but you never know...
|
|
|
|
|
Thank you for the help. The timer is now working.
Steve C.
kstv@netzero.net
|
|
|
|
|
astv wrote: Am I using the wrong timer?
yes you are. A Forms Timer is great for WinForm apps as it ticks on the GUI thread.
Without a Form, do you have a message pump at all?
Try using a Threading.Timer or a Timers.Timer (not sure which would work/work best for you; they invented that great "documentation" thingy for such purposes).
and make sure your Elapsed handler does call the email code.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Thank you for the help. The timer is working and I am inserting the send email process.
Steve C.
kstv@netzero.net
|
|
|
|
|
Try using the timer from the System.Timers namespace.
private System.Timers.Timer timer = new System.Timers.Timer();
timer.Interval = 60000;
timer.Elapsed += new ElapsedEventHandler(onTimer_Elapsed);
timer.Start();
private void onTimer_Elapsed(object sender, ElapsedEventArgs e)
{
}
|
|
|
|
|
Thank you for the help. The timer object instantiation was very helpful. I'll remember not to use the form timer next time.
Steve C.
kstv@netzero.net
|
|
|
|
|
Use Timer from System.Timers namespace. And call SendEmailNotification method in the elapsed event.
|
|
|
|
|
I'm trying to make a helpdesk application that processes incoming emails for a specific account. I'm having trouble with the Itemadd event. It will quit after receiving around 17-28 emails and I have to restart the program. I have not found much online about this issue besides it's probably a scope problem and the GC is killing the event. I did make a stripped down version of the program which seems to work fine but I dont know why it works when this one doesn't.
In the load function of the form im using this for getting the namespace and the correct store. All variables not initialized in the code are private.
If I comment out treeview1_add function it'll work up to 30 emails which probably means it's working. However I do not know why commenting out that function will make it work and I need that function.
thank you for any help you can give me.
<code>
void form_load()
{
mapi = outlookapp.GetNamespace("MAPI");
int helpdeskcount = 1;
int count = 1;
while (count <= mapi.Stores.Count)
{
if (mapi.Stores[count].DisplayName.Contains("Storename"))
{
helpdeskcount = count;
count = mapi.Stores.Count;
}
count++;
}
oinbox = mapi.Folders[helpdeskcount];
helpdesk = oinbox.Folders["Inbox"];
helpdesk.Items.ItemAdd += new ItemsEvents_ItemAddEventHandler(Items_ItemAdd);
}
void Items_ItemAdd(object Item)
{
load_unassigned();
counter();
}
void counter()
{
if (this.InvokeRequired)
{
this.Invoke(new Invoker_no_strings(this.counter));
}
else
{
int count = int.Parse(label1.Text);
count++;
label1.Text = count.ToString();
}
}
public void load_unassigned()
{
tree_node_clear(treeView1);
incident_load = new tbl_incidents_BLL();
tempnode = null;
arrtemp = incident_load.loadallunassigned();
int length = arrtemp.GetLength(0);
int count = 0;
while (count < length)
{
treeview1_add(arrtemp[count, 0], arrtemp[count, 1] + ": " + arrtemp[count, 3]);
count++;
}
}
public void tree_node_clear(TreeView temp)
{
if (this.InvokeRequired)
{
this.Invoke(new tree_clear(this.tree_node_clear), temp);
}
else
{
temp.Nodes.Clear();
}
}
public void treeview1_add(string id, string value)
{
if (this.InvokeRequired)
{
this.Invoke(new treeview1_add_delegate(this.treeview1_add), id, value);
}
else
{
treeView1.Nodes.Add(id, value);
}
}
}</code>
ghoster
modified on Wednesday, July 15, 2009 12:04 PM
|
|
|
|
|
Hi,
so you suspect the ItemAdd event, however you did not show the relevant code, i.e. the declaration of the event, and the code that causes it to execute.
Besides the event getting collected, I have two usual suspects for you:
1.
maybe you execute the event on a thread other than the main/GUI thread, so the delegates would not be allowed to touch any Control. You are correctly using the InvokeRequired pattern on some operations, how about the tbl_incidents_BLL constructor and incident_load.loadallunassigned?
BTW: I would consider moving the InvokeRequired pattern upstream, so it serves all the subactions in Items_ItemAdd.
2.
maybe you are getting an exception somewhere, which you don't handle at all. Or worse, you have an empty catch block. Check your code, make sure to put the top-level method of each thread inside a single potentially huge try-catch where the catch block logs and shows Exception.ToString
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Hello,
Declaration of the objects to the itemAdd event are
private Microsoft.Office.Interop.Outlook.Application outlookapp = new Microsoft.Office.Interop.Outlook.Application();
private Microsoft.Office.Interop.Outlook.MAPIFolder oinbox = null;
private Microsoft.Office.Interop.Outlook.MAPIFolder helpdesk = null;
private Microsoft.Office.Interop.Outlook.MAPIFolder omessages = null;
For the code that causes it to execute, correct me if im wrong, the ItemAddEventHander that executes the Items_ItemAdd function
oinbox = mapi.Folders[helpdeskcount];
helpdesk = oinbox.Folders["Inbox"];
helpdesk.Items.ItemAdd += new ItemsEvents_ItemAddEventHandler(Items_ItemAdd);
1.
You're right I'm not using the invoke for the tbl_incidents_BLL constructor or the loadallunassigned. Ill have to try adding that in the loadunassigned function. Also I did add InvokeRequired pattern to Items_ItemAdd function so all subactions are served.
2.
Heh yeah i've been trying add try-catches everywhere but haven't gotten any yet. Also the form that im having trouble on isn't the main form. It's called when an administrator opens it. I should have said about that earlier. I just added the try-catch and ran the program. Same problem and no error, but im weak on try-catch scope, if there's an error anywhere on the administrator_form would this try-catch show it or not b/c of threading?
public partial class Form1 : Form<br />
{<br />
public tbl_administrators_BLL logged_in_admin = null;<br />
private Form administrator_form = null;<br />
public Form1()<br />
{<br />
InitializeComponent();<br />
}<br />
<br />
private void Form1_Load(object sender, EventArgs e)<br />
{<br />
try<br />
{<br />
logged_in_admin = new tbl_administrators_BLL();<br />
logged_in_admin.loadtoclass(System.Environment.UserName);<br />
if (logged_in_admin.getid() == -1)<br />
{<br />
this.WindowState = FormWindowState.Minimized;<br />
Form user_form = new User();<br />
user_form.Show();<br />
}<br />
else<br />
{<br />
<br />
this.WindowState = FormWindowState.Minimized;<br />
administrator_form = new Administrator();<br />
administrator_form.Show();<br />
}<br />
this.Hide();<br />
this.Visible = false;<br />
}<br />
catch (System.Exception ex)<br />
{<br />
MessageBox.Show(ex.ToString());<br />
}<br />
}<br />
}
thanks
|
|
|
|
|
OK, my advice is:
1.
to have one big try-catch on every thread, so basically the first thing a thread does is enter its try block. For the main thread that would be the static Main() method, for any other thread/ThreadPoolWorkItem/BackgroundWorker that would be the method you pass them; for asynchronous callbacks (Timers/SerialPorts/other input-output) that would be the handlers you provide.
All the above are safety nets, they don't solve any problem your app may encounter, but at least they would inform you, the developer.
2.
add lots of logging, either to a file or to a Console (not to EventViewer, not to the GUI); have each line include current time (up to the millisecond if relevant) the ManagedThreadId, one text message, and some relevant data (such as mail count).
If logging to file, I tend to use File.AppendText, so basically the file is closed all the time, and a crash does not keep me from reading the most recent messages.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
