|
I know noone has replied yet, but I still live in hope. Does anyone know the equivalent of getting data from an excel cell to be published via RTD. Basically I want the equivilent to DDE from VB6 (code bellow) where the windows form textbox can be linked to the cell. Since DDE is not supprted anymore, I am looking to replace the code. Any help would be greatly appreciated:
Text1.LinkMode = 0
Text1.LinkTopic = "Excel|MyBook.xls"
Text1.LinkItem = "R1C1:R2C3"
Text1.LinkMode = 1
'Poke the text in Text1 to the R1C1:R2C3 in MyBook.xls
Text1.Text = "one" & vbTab & "two" & vbTab & "three" & vbCr & _
"four" & vbTab & "five" & vbTab & "six"
Text1.LinkPoke()
'Execute commands to select cell A1 (same as R1C1) and change the font
'format
Text1.LinkExecute("[SELECT(""R1C1"")]")
Text1.LinkExecute("[FONT.PROPERTIES(""Times New Roman"",""Bold"",10)]")
'Terminate the DDE communication
Text1.LinkMode = 0
|
|
|
|
|
I have an issue with command builder
below is the code
Public Structure SearchandUpdateClaimDetail
Private cnConnection As System.Data.SqlClient.SqlConnection
Private cmdCommand As System.Data.SqlClient.SqlCommand
Private adAdapter As System.Data.SqlClient.SqlDataAdapter
Private ds As System.Data.DataTable
Sub New(ByVal ConnectionString As String)
cnConnection = New SqlClient.SqlConnection(connectionstring)
cmdCommand = New SqlClient.SqlCommand
adAdapter = New SqlClient.SqlDataAdapter
ds = New DataTable
End Sub
Public Function SearchClaimDetail(ByVal SearchQuery As String) As DataTable
ds.Clear()
cmdCommand.Connection = cnConnection
cmdCommand.CommandText = SearchQuery
adAdapter.SelectCommand = cmdCommand
adAdapter.Fill(ds)
cnConnection.Close()
Return ds
End Function
Public Function UpdateClaimDetail(ByVal DTTable As DataTable) As Boolean
Dim sqcmdb As New SqlClient.SqlCommandBuilder(adAdapter)
adAdapter.Update(dttable)
cnConnection.Close()
Return True
End Function
End Structure
this structure is in a class. i call this structure (function SearchClaimDetail) in another class (BLL) which exposes its function to GUI which binds the grid.
Now when i modify the datatable and sends it back (function UpdateClaimDetail)to update the database it goes smoothly but does not update the database nor it gives any error. There is one primary key in the table which is used in the select command.
How can i update the table. I do not want to insert the rows but to update existing rows.
|
|
|
|
|
I want to copy all embedded resource to given folder
pls give me a working sample code.
pls help me
|
|
|
|
|
It's may be helpful for u.
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(BBl));
Pic1=resources.GetObject("a");
Pic1.save("C:\ja.bmp");
Best Regard
Anubhava Dimri
mailto: anubhava.prodata@gmail.com
|
|
|
|
|
let me know is it possible to lock Netwok Connections And My Network Places as soon i start the system.if user try to to click on these .....it should not open ...until i give password or permission to it
Using VB.Net Windows Application.
Task: As soon As I run My Exe in registry or start Up ....It Should Not allow the user to enter in to the MY Network PLaces and Network Connections of Control PAnel. once user provided with credentials then they are allowed to access those Network Connections and My Network Places......
Just I want to restrict on those icons Directories not on individual Internet Connection or Wlan Connection ....just lock those things(MyNetworkPlaces, NetworkConnections) as soon as i start my System
plz let me know in what manner i have to proceed....
i tried but unable to do it......
|
|
|
|
|
|
You can use WiX[^] to make the installation packages (requires some learning). Or you can use other programs to do so, some are free and others are not.
If you want to create a bootstrapper, you can use MSBuild (included in the .net framework) or use other bootstrapper generators.
Eslam Afifi
|
|
|
|
|
you can use software to help this problem that made project to file setup .
there are alot of software but I khnow some of them such as :
InstallShield X , Seup Victory ..
lyrithyforcambodia
lyrithyforcambodia
lyrithyforcambodialyrithyforcambodia
lyrithyforcambodia
lyrithyforcambodialyrithyforcambodia
lyrithyforcambodia
lyrithyforcambodialyrithyforcambodia
lyrithyforcambodia
lyrithyforcambodialyrithyforcambodia
lyrithyforcambodia
lyrithyforcambodialyrithyforcambodia
lyrithyforcambodia
lyrithyforcambodialyrithyforcambodia
lyrithyforcambodia
lyrithyforcambodialyrithyforcambodia
lyrithyforcambodia
lyrithyforcambodialyrithyforcambodia
lyrithyforcambo.
|
|
|
|
|
Hello,
I have a UserControl that contains a tab control that has about 8 pages.
Each pages have a lot of controls and all 8 pages need to be loaded at the same time.
The UserControl is opened when a user click on a button from the main form.
I searched the entire CodeProject for splashscreens or good loaders, but I didn't find anything useful. Can someone guide me on how to load the usercontrol without hanging the application.
I don't mind if it takes 10 seconds, but I would like a loader in this time, without freezing the entire application.
Hope you can help,
Thank you
|
|
|
|
|
The problem you have is it takes so long to load the form because you have sooooo many controls. Reduce the number of controls, such as scrapping the tab page layout and moving them to seperate forms that you only load when you absolutely need to show them (you have 8 tabs remember, you can only see one tab at a time!)
You have a second problem. Since all the controls must be created on the UI thread in order to work properly, showing a "Progress Bar" (not "loader") isn't going to work very well, because it also gets drawn on the UI thread, which will be too busy creating your large number of controls, and hence, won't be able to show "progress".
|
|
|
|
|
Dave Kreskowiak wrote: second problem.
The way I handle this seems to work perfectly:
- first create the splash form, make it TopMost and show it modelessly; a simple splash appears right away and holds a progress bar, a listbox showing what is going on, and a cancel button. Plus all the aesthetics one might want to add.
- then construct the slow form and pass a reference to the splash form to it, so it can add items to the activity listbox, advance the progress, and when loaded close the splash (with a small delay so you still can read the latest listbox updates).
I have a SplashWindow class that supports this, and I tend to use a using construct for the splash so it also disappears when something goes wrong during the main forms construction.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
Try to load your tabpages one at a time;
- Divide your 8 pages over 8 usercontrols
- Put the drawing of your form on hold
- Add an usercontrol-array to the form that can hold those 8 usercontrols
- Load them one atta time. (You might use a counter, busy animation etc)
- Add the newly created usercontrol to the (controls collection of the) appropriate tabpage
Good luck
I are troll
|
|
|
|
|
I am trying to do server side office automation. I have a word template
which I am trying to populate with data from SQL server but when I try
to generate the Word document I get following error:
Unable to cast COM object of type 'Word.ApplicationClass' to interface
type 'Word._Application'. This operation failed because the
QueryInterface call on the COM component for the interface with IID
'{00020970-0000-0000-C000-000000000046}' failed due to the following
error: Library not registered. (Exception from HRESULT: 0x8002801D
(TYPE_E_LIBNOTREGISTERED)).
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.InvalidCastException: Unable to cast COM
object of type 'Word.ApplicationClass' to interface type
'Word._Application'. This operation failed because the QueryInterface
call on the COM component for the interface with IID
'{00020970-0000-0000-C000-000000000046}' failed due to the following
error: Library not registered. (Exception from HRESULT: 0x8002801D
(TYPE_E_LIBNOTREGISTERED)).
This works fine on my development machine which has Windows XP and Office 2002, but when I try to run the same
application on my production server (Office 2000) I get above error. Please help if
you have any idea.
Thanks in advance.
Savitha
|
|
|
|
|
Chances are the GUID which defines the COM interface got changed; Office XP made quite a few changes, so this is likely. You should try to compile against Office 2000. Perhaps you could use conditional compilation - in Release mode you use the 2000 GUIDs, and in Debug mode you use the Office GUIDs
|
|
|
|
|
I have recoded the whole thing using Office 2000 and tried to run the code in a machine which has Office 2000. And still I am getting the same issue when it kits WrdApp.Visible() method.
FYI
using Word = Word;
using Excel = Excel;
public class DocumentPrinter
{
public DocumentPrinter()
{
//
// TODO: Add constructor logic here
//
}
Word.Application wrdApp;
Word._Document wrdDoc;
//Sends merge to email. client must enter address
public void Printword()
{
Word.MailMerge wrdMailMerge;
Word.Selection wrdSelection;
Word.Range wrdRange;
// Create an instance of Word and make it visible.
wrdApp = new Word.Application();
wrdApp.Visible();
//When the control comes to the line wrdApp.Visible();, it throws the abpve error.
Help please
Thanks in advance
Savitha
|
|
|
|
|
|
andre12345 wrote: Does DBusSharp have any use on Windows Plateforms?
You mean besides the ones documented on the page you provided a link to? 
|
|
|
|
|
Well the second level link http://www.freedesktop.org/wiki/Software/dbus[^]
from that page reference the "D-Bus" message bus system. The "DBusSharp" reference the c# implentation.
The implementation has a "UNIX" background, but is it better that Microsoft remoting for IPC?
|
|
|
|
|
andre12345 wrote: Well the second level link http://www.freedesktop.org/wiki/Software/dbus[^]
from that page reference the "D-Bus" message bus system. The "DBusSharp" reference the c# implentation.
The implementation has a "UNIX" background, but is it better that Microsoft remoting for IPC?
I have no idea how that relates to your original question. If you wish to get support from people using internet forums you might consider posting complete cohesive information and questions.
|
|
|
|
|
After reading this article:
http://reddevnews.com/blogs/print.aspx?blog=3654
I'm wondering why MS is slowing down on the .NET functionality.
The article states:
"If they [Microsoft] were trying to kill ODBC, they would have added this functionality to their .NET provider."
Huh.
I thought ODBC was a thing of the past and only used on legacy systems now. Should I start reverting back to ODBC drivers instead of the built in .NET stuff?
Any thought?
|
|
|
|
|
Jim in Arizona wrote: I'm wondering why MS is slowing down on the .NET functionality.
How do you get that from the article?
Jim in Arizona wrote: I thought ODBC was a thing of the past and only used on legacy systems now.
Where do you get that info?
ODBC is still a perfectly valid method of data access,
and probably still the best performing cross-DBMS access
interface.
I've never seen anything from Microsoft stating ODBC is deprecated,
dead, or dying.
Mark Salsbery
Microsoft MVP - Visual C++
![Java | [Coffee]](https://www.codeproject.com/script/Forums/Images/coffee.gif)
|
|
|
|
|
WTF Mark? Things not lively enough for you in the new technology groups so you're coming back to some of the old fishing grounds? 
BTW, nice bait you used here. 
|
|
|
|
|
My opinion of ODBC not being used as much anymore (rather than depricated) is because of articles I've been reading over the last few years saying that other, newer methods are preferred due to speed (for one) and ODBC should ONLY be used for those systems that require it, such as older legacy systems.
I stopped using ODBC about four years ago in favor of ADO/ADO.NET. Looking around the net, the consensus appears to be that ODBC is old and slow compared to the others.
http://www.experts-exchange.com/Databases/Q_20985045.html
That being the case, why would they (MS) begin working on it again instead of spending that time on ADO.NET? Also, why would anyone, assuming ADO.NET is faster/better, want to design a NEW system with ODBC?
So, if ODBC is better and should be used instead of ADO.NET, then this is the first I've heard of it.
|
|
|
|
|
Cool.
I just don't see the comparison being all that valid anyway:
One can't use ADO.NET in native code.
Of course, with years of .NET marketing implying .NET is the end-all be-all of programming
frameworks and native code is dead...
And ADO.NET faster than ODBC? hmmm For all DBMSs and drivers? I'm skeptical, but I
really don't care - all the DB stuff is a bottleneck anyway.
It's the progress in the dev tools for .NET, with pretty much no progress in native tools,
that makes ADO.NET, and .NET in general, more appealing to me.
BTW, I converted all my DB code to ADO.NET from ODBC a while ago, so I'm not
an ODBC fanatic....I'm just saying it's not dead 
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
You're assuming that the technologies are mutually exclusive, whilst I'm not even sure that they are really competing technologies.
ODBC puts it priority in talking to as much databases as it can, whilst ADO puts it's coins on speed. ADO.NET is the speedy version that has been integrated in our favorite framework.
Nah, ODBC ain't dead. The BDE is dead, and I think that we should be gratefull for that
I are troll
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
