|
I had the same question a while ago... it's verry simple
you take a command object for example :
OleDbCommand createTable = new OleDbCommand();
createTable.Connection = aValidConnectionObject;
createTable.CommandText = "CREATE TABLE TableName
{
obj varchar(0),
}
";
I'm not sure on the sql part... but that is the main idea.
I have an example written at school .. have to look into it!
Lazar Mihai
Highschool student
|
|
|
|
|
Hi all,
Can anybody provide me the code for zipping a folder and all its subfolder in a zip file and other utility to unzip any zipped file.
|
|
|
|
|
|
referring to this thread [^] :
i use access 2003 and i'm creating a software that uses Access Database (.mdb) jointly the .exe to archive some information.
I don't want to use SQL server or MySQL couse i've not the license and i don't want the user forced to buy one.
So i use Microsoft Access Database that is more elastic and easy.
Now when i got intallation of Access 2003 i don't saw the option JET or Other... so how can decide to install the one more performant Access?
If i decide to use JET with Access 2003, how do i create store procedure within?
Referring to crypted password within webconfig, can you show me some web pages that talk about that?
Vary vary thanks
|
|
|
|
|
Hi everybody, I have a problem marshalling char**. It's supposed to be an array of strings, returned by C++ dll function. The function returns structure, which contains several members, and some of them are char**. How to marshall them? Pls. help me with the problem, I'm stuck on it for ages...
Ceno
|
|
|
|
|
Is there possible to customize the text shown into the dialog that displays the page that is beeing printed onto a printPreviewDialog?
protected internal static readonly ... and I wish the list could continue ...
|
|
|
|
|
Hi folks, anyone know how to access files using a unc name and a fileStream? The user will have to provide the correct login details on a form i have created but i don't know how to create the connection to get at the files.
Cheers
Kev
|
|
|
|
|
how to impove efficiency by using BULK INSERT statement?
-----------------------------------------------------------------
hi, all
the flow we used.
A.txt ---format by row--->B.txt---using BULK INSERT statement---> SQL Server (tableC).
after import data to tableC, we need create indexes on tableC.
Now, we have many clients have files which rather than 2GB. so we need impove efficiency to import data to SQL server.
Any assistance would be really appreciated.
|
|
|
|
|
|
I have a simple class in which I will be making several objects from. Similar to WinForm controls I want to utilize some form of String attribute called Name to identify each object uniquely. Is there an easy way to have the maintaining of the list of names automatically handled?
If there isn’t, I’m thinking of building a name manager system. Essentially just a factory pattern which accepts names (a String) and returns objects based on this. If the user tries to set the name to an object already in use, the factory wouldn’t return null, therefore the system disallows it. I’m curious to know if and how generics can play a part in making this work better. In other words, with generics would it be possible to build the factory to know that the name attribute was used on class ABC and therefore always return type ABC?
-Mike.
|
|
|
|
|
You can use a static HashTable in the class to keep track of the objects. In the constructor, add a reference to the object itself to the list. Create a static method that checks the list for an object by name.
A factory to create the instances might be a good idea. Just make a static method in the class to create an instance, and make the constructor private so it can only be used by the factory method.
---
b { font-weight: normal; }
-- modified at 3:48 Friday 13th January, 2006
|
|
|
|
|
Dear friends...i'm developing windows base c# application by using Janus controls.
In my application i'm use XSD to populate data to various controls.
e.g: In my XSD there r 3 tables.
1.tblSales : populate sales person combo
2.tblcustomer : populate customer combo
3.tblItems : Populate items grid
when i load particular windows form it takes 1 to 2 minute load.i think this is problem with data binding to controls.
therefore does any one know how to reduse this loading time.
-- modified at 21:58 Sunday 15th January, 2006
|
|
|
|
|
I have a VB exe that invokes a remote web service via CCW (COM Callable Wrapper). The CCW serialises the input passed by the VB app, then invoke the web service. I am getting the following error message at one of the installation sites.
Unable to generate a temporary class
(result=-1073741819).|error CS0647: Error emitting
'System.Security.Permissions.PermissionSetAttribute' attribute --
'Unspecified error '|error CS0647: Error emitting .......
and it repeats this last part (about PermissionSetAttribute) many times...
Any ideas what might be happening here?
Thanks!
Lee
|
|
|
|
|
hi all,
so I know what the constructor does. Is there also a destructor for
C# classes?
and is it invoked when I do a
set myobject = nothing
?
also, if Im creating one of those classes that you DONT have to
instantiate (what are they called again?), how does the constructor
and destructor get called?
and is it a good idea to put stuff in the constructor and destructor
in those type of classes?
thanks
Moazzam
|
|
|
|
|
moazzamahmed wrote: Is there also a destructor for
C# classes?
Yes, it's called Finalize.
moazzamahmed wrote: and is it invoked when I do a
set myobject = nothing
No. It's invoked when the garbage collector is about to remove the object.
If you need to do any cleanup in your object, you should inherit the IDisposable interface and implement the Dispose method.
moazzamahmed wrote: also, if Im creating one of those classes that you DONT have to
instantiate (what are they called again?), how does the constructor
and destructor get called?
Do you mean a static class? As you don't instantiate it, the constructor or destructor aren't used. Actually, you should declare a private constructor so that noone can create an instance of the class. However, you can also declare a static constructor for the class, that will be called once when the library is loaded.
---
b { font-weight: normal; }
|
|
|
|
|
fabulous! thanks Guffa.
so whats the use of static classes over non-static? which ones should
we use for what TYPE of object? whats better for speed and performance?
I was thinking, if a class is basically just utilities, it should be static.
But if its something that has properties etc. e.g., a "contact", its should
be instantiated.
Am I on the right track?
thanks again.
|
|
|
|
|
moazzamahmed wrote: Am I on the right track?
basically yes. The other thing I'd do statically would be anything that a single copy of is needed app wide. I've got static classes for configuration parameters, and my data wrapper.
|
|
|
|
|
moazzamahmed wrote: so whats the use of static classes over non-static? which ones should
we use for what TYPE of object?
Use a static class when you don't need to create objects from the class. Generally static classes don't contain any data at all, or if they do, it's data that is common to the entire application.
moazzamahmed wrote: whats better for speed and performance?
Calling a static method means that a reference to the object isn't included in the call, saving one instruction. This difference is hardly ever anything that you have to be concerned about, though. Concentrate on what gives the best structure to the code, and start thinking about optimizing when you run into performance problems. But even then, there are a lot of other things that are likely to boost performance a lot more than using static methods instead of non-static.
---
b { font-weight: normal; }
|
|
|
|
|
Hi
Does anybody know answer to following problem.
Problem : I am creating deployment for C# apllication using dot net deployment & setup project.
I have created registry entries ( Ex. Server Name)and one edit dialog box for user input(Ex. IBM0505d-040). Now I want to write user input ( Ex.IBM0505d-040) as value of Server name registry entry at the time of installation.
Pls reply
Jitendra C.
Jitendra C.
|
|
|
|
|
HI!
You'll have to create a custom action to do this.
Regards,
mav
|
|
|
|
|
Hi,
Thanks for reply,
Can you please answer me little more detail if possible for you.
Thanks again.
Jitendra C.
|
|
|
|
|
Is it possible to show the menu in a windows form from a form which is not its MDI parent?
Thanks,
Sandeep
+919891027854
|
|
|
|
|
It should be possible. Have you added a MainMenu (.NET 1.x) or MenuStrip (.NET 2.0) to your MDI child window?
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005
|
|
|
|
|
I have added MainMenu on ur suggestion into MDI child window but the click event of the original menu does not work in the child window...
plz give some advice...
Thanks,
Sandeep
+919891027854
|
|
|
|
|
Well, no. You'll get the Click events for the top-level menu in the parent form, and for the child's menu in the child window.
Basically the top-level menu should contain items related to the application as a whole, while child menu items should apply to the particular child window (or document.)
There's also menu merging, in which child menu items merge into the toplevel menu. This way, the toplevel menu displays application-wide menu items *and* commands for the current child window. You can see this in Visual Studio, where the menu bar changes according to the type of window (code window, form designer, and so on).
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
