|
If the VB 6 app reads data stored in excel format then save the data from the web form with an excel format. Then the VB6 app can show the data given the file.
If I see ur problem correctly
|
|
|
|
|
I am sorry for not being clear. I will explain it once again.
I have a VB6 application which has Excel embedded in its Form. Now there is an ASP.NEt application which has a web page with a Save button.
When the user enters data on the Web Page and hits on Save button, 2 Actions has to happen.
1) The data will be saved in Oracle DB
2) The same data needs to be loaded in the Excel present in the VB application.
Action (1) is easy with no problems
Action (2) is my problem as I am not getting the reference of the VB application from C# (2.0)
Please let me know if there is some way to do it.
Vinay
|
|
|
|
|
I am unsure if I understand what you are trying to do. You have a VB6 application which holds the excel stuff. Are you trying to save the data from your ASP application, and then send a message to the VB6 app to read the file after it has been saved? Or are you just saving it, and then letting the user load the data whenever?
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
I am sorry for not being clear. I will explain it once again.
I have a VB6 application which has Excel embedded in its Form. Now there is an ASP.NEt application which has a web page with a Save button.
When the user enters data on the Web Page and hits on Save button, 2 Actions has to happen.
1) The data will be saved in Oracle DB
2) The same data needs to be loaded in the Excel present in the VB application.
Action (1) is easy with no problems
Action (2) is my problem as I am not getting the reference of the VB application from C# (2.0)
Please let me know if there is some way to do it.
Vinay
|
|
|
|
|
Hi.
How do you start synchronously an external application?
My program must suspend execution and wait for the external app to close itself and only then resume execution.
Thanks.
|
|
|
|
|
Take a look at the Process class.
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
Yes, I know how to start it using the Process class.
But by default, that starts the external application asynchronously, which is not what I want.
|
|
|
|
|
Hello,
Have you had a look at the "WaitForExit()" method of the process class?
Or do you mean something completely different?
All the best,
Martin
|
|
|
|
|
blackjack2150 wrote: But by default, that starts the external application asynchronously, which is not what I want.
As Martin# stated below, I was thinking you could WaitForExit() from the Process class. I didn't notice you wanted to run the process synchronously, despite being in bold  I am unsure if the process can be ran synchronously.
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
|
this question is for C#. I dont know how to put a value into a label my select statement works because Ive tried it on a listbox heres the code
select sum() from table where id = id
then: label.text = ?;
I tried dataset.tables[0].rows
but Im not to shure about that please help me.
|
|
|
|
|
dataset.tables[0].rows[0], I reckon.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I did but it just shows System.data...
in my select statement I have select sum() as total from
dont I have to put that total in somewhere?
|
|
|
|
|
lourensG wrote: dont I have to put that total in somewhere?
That's what the select did. I thnk you need to add .Value or something like that.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Christian Graus wrote: dataset.tables[0].rows[0], I reckon.
I think it has to be dataset.tables[0].rows[0].ToString();
Also, not more than 4 threads down you have the EXACT same thread, with answeres in it for you. Why did you start a new one, people can still see that. It just makes you look impatient and rude. Read the forum rules
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
try this .....
dataset.Tables[0].Rows[0][0].ToString();
surely work......
|
|
|
|
|
thanks that works perfectly but how does Rows[0][0] work
|
|
|
|
|
lourensG wrote: thanks that works perfectly but how does Rows[0][0] work
Rows is the collection of all rows in your datatable. The first [0] is the row specifier. So lets say you have
Justin Perez
Lourens G
Titus Perez
Rows[0] Will return the first Row, containing Justin Perez. The second specifier is for which column you would like to retrieve. So Rows[0][1] Will return Perez. First row, Second column.
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
Hi,
I have this simple board game, has a form object which holds all other objects in it, the board being one of the objects added as a control to the form. Now I want to let the form know when something specific happens on the board (to adjust the score label which is on the form as a control as well).
Thanx
|
|
|
|
|
|
Worked like a charm!! Thanx a lot for the short yet comprehensive article 
|
|
|
|
|
hello
I am debutant in C #, and I would like create a Windows application which makes it possible to manage a data base.
charge information in textBoxs, button first , previous, last, and allow the modification, the suppression.
thanks for help
|
|
|
|
|
almora007 wrote: thanks for help
Since you didn't actually ask a question, I'm curious about what help you expect.
Going by your description you have given an overview of the application you are planning to build. You haven't identified any specific problem areas. What would you like help with?
-- Always write code as if the maintenance programmer were an axe murderer who knows where you live.
Upcoming FREE developer events:
* Glasgow: Agile in the Enterprise Vs. ISVs, Mock Objects, SQL Server CLR Integration, Reporting Services, db4o ...
* Reading: SQL Bits
My website
|
|
|
|
|
thank for your response
i see your point.
i explaine my probleme,
i have my database table and i dont now how to bind button te permet the user of the application traversing the table.
|
|
|
|
|
almora007 wrote: i have my database table and i dont now how to bind button te permet the user of the application traversing the table.
You can't bind a button to do that. You have to create an event handler for the button and then write the code to traverse the database.
To create an event handler: Double click the button in the designer. Visual Studio will create an event handler if one does not already exist and take you to that code. You then have to fill in the code yourself.
It is up to you how you want to traverse the data. I'm guessing you have a DataSet somewhere with a populated DataTable in it. You need to store a index to the row in the table somewhere and when the button is pressed the index is updated, you can then get the data from the row at the new index and populate your texts boxes and other controls.
-- Always write code as if the maintenance programmer were an axe murderer who knows where you live.
Upcoming FREE developer events:
* Glasgow: Agile in the Enterprise Vs. ISVs, Mock Objects, SQL Server CLR Integration, Reporting Services, db4o ...
* Reading: SQL Bits
My website
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
