|
Hi
I am currently writting a program that read a file which contains some information. I will enter a loop that will loop 10000 or even 25000 times(depending on the number of lines)to enter these information.
Now, is it a good practice to open the connection to the database and close it within the loop.So it will be opened and closed each loop.If not, what is the best solution?!
I mean, will it affect the time performance??
My database is MS Access 2003
Thanks
|
|
|
|
|
I think it would. I'd just open the connection right before you start the loop and close it afterwards.
|
|
|
|
|
Thanks I will try 
Q:Where can I find a reference that shows me when I should use the executeQueri() method and when I shold use the execute() method of the database?
regards
|
|
|
|
|
Sorry I dont know what exactly you mean. Do you refer to the different Execute functions the IDbCommand interface has? If yes then look here.
|
|
|
|
|
hi,
i want know how to work wit my mail server programmatically
like adding new mail domain,deleting a mail domain and so on?
|
|
|
|
|
It's impossible to tell you anything without knowing which mail server your using! They're not all the same you know...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
thanks,
so i have to negotiate with my administrator inorder to make my job,i thought all the servers have the same rules,if not tell me about it?
|
|
|
|
|
All POP3 and SMTP servers have to follow the same mail encoding and transfer protocol rules. Most of them do, but there are no specifications to follow when your talking about administering, or management, or a mail server. They all have different interfaces, configurations, management tools.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have been trying to Manipulate INPUT TYPE=File Value
in a web page through automation of the internet explorer using c#.Net but i don,t seem to get it write.
If any one out there has an idea on how to go about it, will be grateful
|
|
|
|
|
|
hi
see different web servers generate different format log files like IIS,W3C Extended,NCSA they all generate log files having different formats. i hav 2 make one standard format ofcourse of my own choice and then i hav 2 parse tht standardised file.the prob is i dont kno C# at all but i hav 2 do it in C#.kindly if any one can tell me tht which of related material to my work shud i study (means which classes as reading C# as whole is pretty time taking) and also do tell me some good book of C#.plz help me soon.
|
|
|
|
|
The question is a bit general. You will have to look at the System.IO namespace. The classes FileStream and TextWriter/Reader are probably important in this case. You will need many string operations and the RegEx class might also be of use (but beware: regular expressions is a science by itself  ).
|
|
|
|
|
Lets say we have an interface 'IControl'.
public interface IControl
{
ControlType Type
{
get;
}
int XPos
{
get;
set;
}
int YPos
{
get;
set;
}
}
Lets say we have a baseclass 'ControlBase : IControl'.
public abstract class ControlBase : IControl
{
int _xPos = 0;
int _yPos = 0;
public ControlBase() {}
public ControlBase(int xPos)
{
_xPos = xPos;
}
public ControlBase(int xPos, int yPos)
{
_xPos = xPos;
_yPos = yPos;
}
public int XPos
{
return _xPos;
}
public int YPos
{
return _yPos;
}
}
Lets say we have a baseclass 'ButtonBase : ControlBase'.
public abstract class ButtonBase : ControlBase
{
public override ControlType Type
{
get
{
return ControlType.Button;
}
}
}
}
The only constructor available in ButtonBase is the default constuctor:
ButtonBase button = new ButtonBase();
What I want to do is inherit the ButtonBase(x) and ButtonBase(x, y) constuctor from the ControlBase baseclass whithout writing new code. In other words I want to use ControlBase as a foundation for other classes, using the baseclass as a template.
In the end I'd like to call 'new ButtonBase(10,100)' in my source-code to create a new instance of ControlBase(10, 100) without adding new (Constuctor-) methods to ControlBase.
How can I do this?
Greetzzz miggro
|
|
|
|
|
You need to do this:
public ControlBase(int xPos, int yPos) : base()
Or if you want to select a base constructor that takes some or all of your parameters, you'd do this:
public ControlBase(int xPos, int yPos, object forBase) : base(forBase)
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I'm afraid that's not possible. You have to explicitly define a constructor in ButtonBase, even if it does nothing but call the base class's constructor.
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
I'm developing a windows service for Windows XP, and I need to be notified of every user-login happening, however, since the service runs as a System service, it will always say "NT AUTHORITY\SYSTEM" as the username. Is it possible to get such a notification for a C# service? or should I recurr to less 'orthodox' ways to do so?
Miguel
char c[13]={77,105,103,117,101,108,32,65,120,100,114,130,115}<br />
for (int i=0;i<13;i++) printf("%c",c[i]);<br />
|
|
|
|
|
I’ve an ActiveX control inserted in a C# Form. On the form there is some other controls like buttons and so on. I like to send all the keyboard inputs to the ActiveX. At this time when I for e.g. press the up-arrow the focus of all the buttons is changing, and that is not want…
_____________________________
...and justice for all
APe
|
|
|
|
|
I can recomend you 2 way:
1 create the event handlers for all controll, for the events you want to sent to teh ActiveX, and from them call ActiveX event handlers.
2 Disable all other controlls in the form, while you want to focused only teh ActiveX
|
|
|
|
|
I have an old dll created in C++ with Visual Studio 6.0 with the Win32 Dynamic link-library project. Is it possible to use that dll in a .NET, C# project?
If, How? I’ve tried to add a reference in VS 2003 to the dll but I got the error that the dll is not a .NET assembly or a COM dll…
_____________________________
...and justice for all
APe
|
|
|
|
|
|
Hi,
I've read the article about Ethernet packet sending and tested the code. All is great. I try to make the same work over windows CE. It's possible to adapt the code for my scope?
Many Thanks
Luca
|
|
|
|
|
Hi all,
I want to generate a report (a CV) with an individual Fotos (Bitmaps) on it. I am using the "pull method" and a XML-Database structure for crystal reports, but loading the report by a dataset.
Does anyone know how to do that (how to tell crystal reports that the field object is a variable bitmap)
and which format to use for on the dataset to supply the correct information ?
Thanks
Frank
|
|
|
|
|
I've got a line chart with the date displayed horizontally across the x axis and would like to display the dates vertical. Is there a way to rotate the group labels on the x axis?
|
|
|
|
|
I am wanting to setup a window in an application I am working on that behaves similar to the Find and Replace windows in Visual Studio where the modeless dialog remains above the main application's window at all times not covering other application's windows. I have tried the TopMost property, but it overlaps other application windows as well which I don't want. Is there a way to implement a topmost-like behavior that doesn't overlap other applications' windows? 
Thanks in advance. 
John 3:16: "For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life."
|
|
|
|
|
Im not 100% sure but I think setting the Owner property of the dialog to your application main form should do it.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
