|
There are security issues with allowing services UI permissions like displaying forms. However, if this does not concern you and you have not done so already, you may be able to view the form via the service if you ensure you are using a local system account to start your service, and check the 'Allow Service to interact with desktop' check box in the log on properties of the service.
I think a better idea would be to have the UI separate from the service, and have the service communicate with the UI via a named pipe or...whatever...
|
|
|
|
|
|
|
Do you want to get data from a database and display in your application datagridview?
// this is a routine i wrote
public static void SP_WITH_DATAGRIDVIEW(string SP, DataGridView DATAGRIDVIEW_X, string PARAMETER_NAME1, SqlDbType SQLDBTYPE1, object OBJECT1, string PARAMETER_NAME2, SqlDbType SQLDBTYPE2, object OBJECT2)
{
SqlConnection conn = new SqlConnection(your_connection_string);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = SP;
cmd.CommandType = CommandType.StoredProcedure;
// how many parameters to you have? here is 2, and of what kind?
cmd.Parameters.Add(PARAMETER_NAME1, SQLDBTYPE1).Value = OBJECT1;
cmd.Parameters.Add(PARAMETER_NAME2, SQLDBTYPE2).Value = OBJECT2;
conn.Open();
SqlDataAdapter sql_da = new SqlDataAdapter();
sql_da.SelectCommand = cmd;
DataTable dt = new DataTable();
sql_da.Fill(dt);
conn.Close();
DATAGRIDVIEW_X.DataSource = dt;
}
Good luck!!!
|
|
|
|
|
Hi,
I create this template but I have some problems compiling it
public class CuponsFormas<t> : CollectionBase
{
#region Add/Remove Methods
public int Add(T item)
{
return List.Add(item);
}
public void Remove(T item)
{
List.Remove(item);
}
#endregion
#region Load/Save Methods
public void LoadItens(XmlElement el)
{
XmlElement elAliqs = XmlConfigLoader.GetElement(el, "Aliquotas");
if (elAliqs != null)
{
XmlNodeList lista = elAliqs.GetElementsByTagName("Aliquota");
foreach (XmlNode node in lista)
{
Add((T)XmlConfigLoader.createXmlItem(
typeof(T), node as XmlElement));
}
}
}
public void SaveItens(XmlElement el)
{
if (List.Count > 0)
{
XmlElement items = el.OwnerDocument.CreateElement("Aliquotas");
foreach (T item in List)
XmlConfigLoader.createXmlEl(item, items);
el.AppendChild(items);
}
}
#endregion
}
</t>
createXmlItem return a IXmlItem derivated class (I made them up)
createXmlEl requires a IXmlItem derivated class
So, the compiler says cannot convert IXmlItem to T and connot convert T to IXmlItem
My question is: Is there any way to tell the compiler I'm sure T is a IXmlItem derivated?
Thanks,
Dirso.
|
|
|
|
|
public class CuponsFormas<T> : CollectionBase where T : IXmlItem
|
|
|
|
|
Hi All,
I have written a class that creates a dynamic SSIS package using C#, all is fine and dandy with this, it correctly creates and executes the package and the data plops into the SQL database as expected.
The problem is that I now need to 'tag on' another static package to be executed at the end of this dynamic package. If you were writing the SSIS package you would do this with an 'Execute Package Task' in the BIDS UI but I need to do this in a web service using C# code.
I can't actually find anything on Google or Code Project that deals with this scenario, any links or ideas would be great.
Thanks,
|
|
|
|
|
Just thought I'd answer this since I've fingured it out now.
I ended up adding a ExecuteProcess task instead.
1. Add a reference to Microsoft.SqlServer.ExecProcTask
2. Add in code:
MyTask2 = package.Executables.Add("STOCK:ExecuteProcessTask");
TaskHost th = MyTask2 as TaskHost;
th.Properties["Description"].SetValue(th, "<PackageName>");
th.Properties["Executable"].SetValue(th,"DTEXEC.exe");
th.Properties["Arguments"].SetValue(th, "<Your Arguments>");
PrecedenceConstraint pcFileTasks = package.PrecedenceConstraints.Add((Executable)MyTask1, (Executable)MyTask2);
pcFileTasks.Value = DTSExecResult.Success;
|
|
|
|
|
Hi all..
I have created a dll in c# for crawling the documents from sharepoint and to get the modified date,created Date..etc..
When i run it from server where sharepoint is installed its getting the created date and modified Date....
But when i run it from client pc...It is giving Debug Error....
when i comment this code....which i used for getting created date and modified date...
the code is
using (SPSite RootSite = new SPSite(listPath))
{
Console.WriteLine("1Entered SPSIte path");
using (SPWeb SiteCollection = RootSite.OpenWeb())
{
string path = listPath;
SPFile file = SiteCollection.GetFile(path);
string TimeCreated = file.TimeCreated.ToLongDateString();
Console.WriteLine("1.1: Created Date is :" + TimeCreated);
}
}
when i comment this code it works fine....is there any problem in it...but the same code works fine in server pc...I am totally confused..please give some idea......I am totally new to sharepoint and c#
manju
Hi..
I am Mnaju.I have Completed my B.E Computers Science.Lokking for a job.I am interested in VC++
manju
|
|
|
|
|
I want to show the SQL code of an SP in my program. Can I call any sys.procedure to get the code from a SP-name?
_____________________________
...and justice for all
|
|
|
|
|
This should do the trick:
EXEC sp_helptext '<stored procedure>'
Regards,
Rob Philpott.
|
|
|
|
|
Rob Philpott wrote: should do the trick
Yes, it should.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Following Query will give you the result in a single string
SELECT [text] FROM sysobjects so INNER JOIN syscomments sc ON so.id = sc.id
WHERE [name] = '<sp name="">'
|
|
|
|
|
Hi,
I have set the timer1.enabled = true
and timer1.interval = 10000 --> represents 10 seconds
It seems the timer tick event does not get fired in windows service.
I have tried placing other timers and they seem to have the same issue.
When I use the timers on a form, they seem to work fine.
Question:
Is there anything I should do inside the windows service so that the tick event of the timer is fired?
Thanks
|
|
|
|
|
It works for me:
using System;
using System.Timers;
namespace ConsoleApplication2
{
internal class Program
{
private static void Main(string[] args)
{
Timer timer = new Timer();
timer.Interval = 10000;
timer.Elapsed += new ElapsedEventHandler(timer_Elapsed);
timer.Enabled = true;
Console.Read();
}
private static void timer_Elapsed(object sender, ElapsedEventArgs e)
{
Console.WriteLine("Tick...!!!");
}
}
}
|
|
|
|
|
Do you use this in a windows service?
|
|
|
|
|
I am using a timer inside a Windows Service with no problem. I do use the Timer Start() and Stop() methods, but I would expect that enabling and disabling would work just fine. Have you checked the event viewer to ensure there are no errors being generated by the service that might explain this problem?
|
|
|
|
|
|
When I run the following code in Release mode, it tells me line 11, which is one too high. When I run it in Debug mode, I get the correct line number 10. Why?
using System;
using System.Diagnostics;
namespace Debugging
{
class Program
{
static void Main(string[] args)
{
ShowDebugInfo();
Console.ReadKey();
}
private static void ShowDebugInfo()
{
StackFrame here = new StackFrame(1, true);
Console.WriteLine(here.GetMethod().Name);
Console.WriteLine(here.GetFileLineNumber().ToString());
}
}
}
|
|
|
|
|
No, I don't have a clue why it does that. According to the documentation info like line numbers should only be available in debug builds so maybe its just random nonsense.
Regards,
Rob Philpott.
|
|
|
|
|
It's by design, your code was optimized in Release build. Turn off optimization in Release, and it will work. (but then you pretty much have the same as Debug).
|
|
|
|
|
Hi all,
Any one please tell what is the use and advantage of DTO also give me some URL where i can learn how to use DTO, Connecting DTO with my table
Thanks in advance
Know is Drop, Unknown is Ocean
|
|
|
|
|
What does this have to do with C#?
Please post your specific C# issue.
|
|
|
|
|
I want to get conditional formatting range if an excel sheet
for eg, if conditional formatting are set in an excel sheet in
cell range
a1 - b10
and
b25- c99
then , i want to get both this range and their corresponding conditional formatting condition , how can i get that
please help me
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
