|
Where is it sending a message? Is it connecting to a server socket and sending a message or what?
|
|
|
|
|
actually it is sending a e-mail message to wish happy birthday
by taking the dob from the database
|
|
|
|
|
Then it is probably sending the e-mail and failing but it is not notifying you that it failed.
Try running the code in a normal application and see if the e-mail is sent.
What account are you running the service under?
|
|
|
|
|
actually i m using single database in both application as well as service. but sql server is not allowing to access the database which is already in use, it is generating a error which says .mdf file is already in use, i m running service under local system
thanks for ur response
|
|
|
|
|
If it is giving the error that the mdf file is already in use then it is probably a MS Access database and you probably have the database open in access or you did not close the connection properly and the database is still locked. Is there an ldb file in the same directory?
|
|
|
|
|
ok let me explain
i m creating a application in which i want a functionality of wishing happy birthday automatically to the customers by sending email by taking there dob from the customer table which is in sql server 2005 database, so i added a windows service project in same solution and done all the coading in onstart(), i also created a setup which install both application and service on the local system, after installing when i try to start the service then problem occurs, i provided connection string for the database also, can we use single database in different projects in same solution, i think now the problem is clear to you.
waiting for ur response
thanks
|
|
|
|
|
If it is an MS Access database you could have problems accessing it from multiple projects simultaneously depending on how you connect to the database.
I think that instead of using a Windows service you should just build a simple console application that runs once a day from task scheduler.
|
|
|
|
|
hey scott
thanks for ur all replys, now i have added this functionality in application itself, with the help of functions, which checks the date from database and send mail automatically to the contact.
thanks for ur responses
regards
narendra singh
|
|
|
|
|
NarendraSinghJTV wrote: done all the coading in onstart(),
Well don't. OnStart is just for that. Move your code and try debugging by connecting to your service from the ide - and you cannot debug the OnStart code. Also try logging errors soemwhere (say a file) so you can see whats going wrong.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
thanks bob for ur valuable response
thanks for all the responses
regards
narendra singh
|
|
|
|
|
Debug your services. It throwing some exception at runtime !  That's why you are getting this message.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
yes abhijit u r absolutely right it is throwing an exception
actually i m using single database in both application as well as service. but sql server is not allowing to access the database which is already in use, it is generating a error which says .mdf file is already in use
thanks for ur response
|
|
|
|
|
Hi,
I would like to know, when I click a button, whcih other events are called before button click event is called.
thank you,
|
|
|
|
|
You can write a small program which subscribes to button events and shows an event on the screen
|
|
|
|
|
Are you talking about Windows Form or Web Form ?
|
|
|
|
|
I cannot figure this out! It is driving me nuts!
Ok so I can do a IndexOfKey and get the index (which in my case is 24), but when I try to get the text it gives an error:
int index = 0;
index = lstImport.Columns.IndexOfKey("Category");
MessageBox.Show(index.ToString());
if (index == -1) cmd.Parameters.AddWithValue("@Category", "");
else cmd.Parameters.AddWithValue("@Category", lstImport.Items[i].SubItems[index].Text);
ERROR:
System.ArgumentOutOfRangeException was unhandled
Message="InvalidArgument=Value of '24' is not valid for 'index'.\r\nParameter name: index"
Source="System.Windows.Forms"
ParamName="index"
StackTrace:
at System.Windows.Forms.ListViewItem.ListViewSubItemCollection.get_Item(Int32 index)
at Grant_Inventory_Import.frmMain.ImportData() in C:\Users\jdixon\Documents\Visual Studio 2008\Projects\Grant Inventory Import\Grant Inventory Import\frmMain.cs:line 560
at Grant_Inventory_Import.frmMain.btnImport_Click(Object sender, EventArgs e) in C:\Users\jdixon\Documents\Visual Studio 2008\Projects\Grant Inventory Import\Grant Inventory Import\frmMain.cs:line 221
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at Grant_Inventory_Import.Program.Main() in C:\Users\jdixon\Documents\Visual Studio 2008\Projects\Grant Inventory Import\Grant Inventory Import\Program.cs:line 18
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:
|
|
|
|
|
And your row really has 25 columns in it ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I actually did a lstImport.Columns.Count right after showing the MessageBox that gives 24 and the count comes to 29.
I'm taking data from an excel sheet and trying to import it into the database.
|
|
|
|
|
Ok I did this:
index = lstImport.Columns.IndexOfKey("Category");
MessageBox.Show(index.ToString());
MessageBox.Show(lstImport.Columns.Count.ToString());
MessageBox.Show(lstImport.Items[i].SubItems.Count.ToString());
So the subitems only have 23, the columns is 29, and the index of category is 24. Now if I add this Category column AFTER importing the excel sheet into the listview does the item's not add those columns to the subitems? The values are blank.. but they should still see the new columsn right but just have no value?
|
|
|
|
|
I just went to a Datagridview.. thanks
|
|
|
|
|
And I bet there are some blank columns on the right of your data which probably failed when loading into the listview because they are null
|
|
|
|
|
Well what I did is loaded the list view with data from the excel sheet, and then looked to see if that excel sheet was missing certain columns. If it WAS missing the columns (I.E. not in the list view columns after being loaded), then I would add them at runtime. Like you mention, the problem was is that the ITEMS were added to the list view before adding the new columns. So the ListView itself sees the columns but the items in it don't. I guess I could of stored that information somewhere else that the columns were missing and at import added blank values to those sql parameters for the ones missing. Problem with that is when the user looks at it, the columns are still missing.
So the listview had the correct amount of columns, but the items didn't. Strange, I figured after adding the columns to the listview it would of appended the columns to the end of the items. To fix it I bet I could of looped through each item and added blank subitems to each one of them after adding each column..
But I ended up using a datagridview instead and I was able to make all that work.
|
|
|
|
|
There are only 23 SubItems in the collection (indexed 1 to 23) and you are trying to access index 24, which is causing this error. Try using index-1 instead. I believe IndexOfKey takes into account the first column also (which is not included in the SubItems collection).
|
|
|
|
|
Yes.. the problem was that the items only had 23 subitems, but the listview had 29 columns since the columsn were added after the items. I would of figured adding columns would of appended it to each item. I posted more of an explanation above ^^^
Thanks!
|
|
|
|
|
In ListView, everything except the first column is in SubItems collection. You cannot have anything "after" that. So, if your ListView really has 29 columns, it should have 28 subitems, and conversely, if there are only 23 subitems, it means the ListView has only 24 columns.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
