|
Start by looking in the .NET Framework SDK[^] (which is also installed locally with VS.NET by default, along with the standalone .NET Framework SDK from http://msdn.microsoft.com/netframework[^]) to see what interfaces and/or abstract classes the SqlCommandBuilder implements or extends, respectively. Read about those interfaces and/or classes.
To see how the SqlCommandBuilder works, if you know how to read IL use ildasm.exe from the SDK or download .NET Reflector[^]. This will give you insight into how it works, which should help you figure out how to change it (or, rather, derive your own) to better suit your needs.
Another approach is to create a sample project and use the designer to design all your commands (which actually uses the command builders at design time), tweak the generated source code, and copy that into your current project.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Thanks a lot, Heath!
That should be enough to get things started.
Hajo
|
|
|
|
|
Hello,
I am really sorry for this stupid quesiton.But I am very new at .NET.
I have a solution that includes two windows applications.I would like to open the second application based on the first application.How can I do this?
I want to open a windows forms belongs to second windows application.
How can I establish a relationship between these two windows applications?
PLEASE HELP
|
|
|
|
|
Not sure if you can just make a reference between 2 winforms projects (just tried and it won't let me).
What you could do is open and run the 2nd EXE using the Process object and perhaps pass in a command argument that will show the desired form instead of the main created in void Main().
Does this help?
Cheers,
Simon
sig ::
"Don't try to be like Jackie. There is only one Jackie.... Study computers instead.", Jackie Chan on career choices.
article :: animation mechanics in SVG blog:: brokenkeyboards
"Most of us are programmers, but a few use VB", Christian Graus
|
|
|
|
|
Thank you very much for your attention.
I will load the language information based on the windows application1.
At the first application I am choosing the language info and then I would like to open the second windows application by clicking the Next button of Form1(Windows Application1)..
But how?
Again thank you..
private void button1_Click(object sender, System.EventArgs e)
{
if (radioGerman.Checked || radioItalian.Checked || radioRussian.Checked)
{
MessageBox.Show("JUST ENGLISH PLEASE","ATTENTION");
}
else
{
MessageBox.Show("----------") ;
//OPEN THE SECOND WINDOWS APPLICATION FORM1
}
|
|
|
|
|
Is there a specific reason that made you create a separate windows application for both forms?
The Form1 of your first windows application doesn't do much, so I don't see the point of creating a separate windows application for it.
www.troschuetz.de
|
|
|
|
|
I agree with Stefan. If you want to develop localized applications .NET includes a much better mechanism for sharing code with different regional (locale) settings and different UI languages. Read Developing World-Ready Applications[^] in the .NET Framework for more information.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Hi,
I have made a windows service which I want to install on other machines.So far I have done the installation by using the installutil.exe. But this method is cumbersome.Is there any shortcut method to do this.
Can I install my windows service on a machine which doesn't have .net installed.
Waiting for your response,
Thanks.
|
|
|
|
|
What i do is just use a batch script.
As for the .Net, it depends on what your windows service is made in ^^
My thoughts are that if your going to use stuff dependent on the framework then yes, your going to need the framework.
Hope this helped,
|
|
|
|
|
Esmo2000 wrote:
What i do is just use a batch script.
And then you have no uninstall capabilities. There are much better tools available.
Esmo2000 wrote:
My thoughts are that if your going to use stuff dependent on the framework then yes, your going to need the framework.
It's not your thoughts - it's a requirement. .NET applications won't run without the .NET Framework, just like Java apps won't run without a JVM and the JRE, VB6 apps won't run without the VB VM, etc.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
just_starting wrote:
I have made a windows service which I want to install on other machines.So far I have done the installation by using the installutil.exe. But this method is cumbersome.Is there any shortcut method to do this.
Add a new Windows Installer project to your solution and add your EXE assembly to whatever directory you want to register for the path to the service. Click the View -> Editor -> Custom Actions menu. Right-click on the root node and select Add Custom Action. Find your DLL you added to the File System editor and compile. This will run the Installer derivative in your Windows Service assembly automatically.
just_starting wrote:
Can I install my windows service on a machine which doesn't have .net installed.
If your Windows Service is managed, then no. .NET applications require the .NET Framework, just like Java apps require a JVM and probably the JRE, MFC applications require the shared MFC library (unless you statically link and bloat your application), VB6 apps require the VB virtual machine, Perl scripts require the Perl runtime, and the list goes on and on.
To deploy the .NET Framework with your Windows Installer package - because it won't do it out of the box for you, read Creating a Single SEtup Project to Install a .NET Framework Application and Dotnetfx.exe[^].
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
I tried the method you specified but was still unable to install the service. It is still asking to install it using InstallUtil.exe.
help needed..
|
|
|
|
|
You must make sure that you have a class that derives from Installer and that it is attributed with the RunInstallerAttribute with true as the parameter.
When you add the assembly to the Custom Action view - while it should be automatic - make sure that the "InstallerClass" (or something like that) is set to True.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
I'm tring to add a row at my database .mdb but i get the follow error: "Sintax error in the INSERT INTO instruction" why? what do i wrong?
this is the schema of my database:
Nome: text 15
Domanda: text 20
Risposta: text 15
Email: text 20
this is the code:
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data source= myDatabase.mdb;";
try
{
conn.Open();
OleDbDataAdapter myAdapter = new OleDbDataAdapter("SELECT * FROM myTable", conn);
OleDbCommandBuilder myCmd = new OleDbCommandBuilder(myAdapter);
DataSet myDataSet = new DataSet("myTable");
myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
myAdapter.Fill(myDataSet, "myTable");
DataRow myRow = myDataSet.Tables["myTable"].NewRow();
myRow["Nome"] = mNuovoUtente.mName;
myRow["Domanda"] = mNuovoUtente.mQuestion;
myRow["Risposta"] = mNuovoUtente.mAnswer;
myRow["Email"] = mNuovoUtente.mEmail;
myDataSet.Tables["TabellaUtente"].Rows.Add(myRow);
myAdapter.Update(myDataSet, "myTable");
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
|
|
|
|
|
please can someone answer me?
|
|
|
|
|
Well, the first problem is that your table doesn't show a primary key. Without it, .Update() won't work. Second, you, apparently, don't have an Update command associated with the DataAdapter. Third, if the Primary Key information is missing, you set the .MissingSchemaAction, but never called .FillSchema before you called .Fill.
You last problem is coming back here demanding an answer to your problem. We do this in our spare time and don't get paid to do it. If you don't like the speed at which the developer community answers your questions, take it up with our supervisors! Oh!  Sorry, we don't have any supervisor here! We're just a bunch of volunteers... :->
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi Dave Kreskowiak, i thank you for your answer but i don't understand why you tell me that.
The only thing i tryed to do was avoid to make my thread disappear, infact right after some minutes other user with their posts have make my post jump at the second/third page and i thought the volunteer could not see it.
Sorry for that, anyway could fit my code with what i've missed?
Really thanks.
|
|
|
|
|
I fogive to tell i've set a primary key for the database it is for "Nome" column.
|
|
|
|
|
Great! You still need an SQL Update command in your DataAdapter, which your code hasn't supplied.
You have to either write this command yourself or you can check into using an OleDbCommandBuilder[^] object to do it for you.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
i use this string to connect on my database
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data source= myDatabase.mdb;";
the problem is i consider my database is in the same directory of the main .exe infact at the first time it find the database, but if i call an openDialog form to load some file it moves the current directory path at the path of the file loaded in the openDialog...
So if i try to reconnect at my database it find nomore the source .mdb .
How could i handle this bug?
|
|
|
|
|
Its not a bug, the current working directory has been changed by the file open dialog so the current working directory is no longer that of your application hence you can't see the database.
You need to give the full path to your database. You should be able to get the path of your exe, and then append the database name on to the end of it, so wherever you app is installed it will always work.
Database FAQ
|
|
|
|
|
How can i get the path of my .exe on running?
|
|
|
|
|
ApplicationDirectory.Directory Property
Mazy
"One who dives deep gets the pearls,the burning desire for realization brings the goal nearer." - Babuji
|
|
|
|
|
How can i use it i'm unable...
i've tryed with:
mPathExe = ApplicationDirectory.Directory;
but it is not correct couse i have to create a class as:
ApplicationDirectory myExe = new ApplicationDirectory(XXXXXXX);
At the place of XXXXXXX i have to give the path of the exe!!! BUT i need to know it before! 
|
|
|
|
|
Have a look at the Application.ExecutablePath property.
Database FAQ
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
