|
i don´t know how to set the columns headers name in c#, because i do it in sql.
But i bet it´s easy.
Now, are the data (to the datagridview) comming from sql database?
if right, write then there not in c#.
|
|
|
|
|
Let me more specific.
I added datagridview control to my form.
Then I edited columns through the property window in vs2005. So I added some column with names and columns header. I also defined the DataPropertyName of the column to the column which is in my
result table coming from a database table.So far so good.But I am also having the form in a different
language created with Localizable property of the form. In this second form I changed the column headers in design mode. What I expect is to see the localized column header when I change the form to
the localized version. All my other controls display their respective localized text but not gridview.
Any idea?
Thanks again
Muharrem
|
|
|
|
|
Hi all, I have a service that is supposed to show a form when starting, however it doesn't...
protected override void OnStart(string[] args)
{
runCapture();
base.OnStart(args);
}
System.IO.StreamWriter file;
public void runCapture()
{
try
{
requestCapture reqCap = new requestCapture();
reqCap.Show();
}
catch (Exception ex)
{
file = new StreamWriter(new FileStream("C:\\xampp\\htdocs\\captures\\Error_Log.log", System.IO.FileMode.Append));
this.file.WriteLine(ex.ToString());
this.file.Flush();
}
}
The thing is, it never errors either...
|
|
|
|
|
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
|
|
|
|