|
|
|
hi Jshell,
thanks for the reply ,
but in my case o/p is being generated dynamically number of rows or columns generated are totally unknown and most importantly my output (i.e final result ) is being generated by using pivot on n number of rows of a intermediate temp table.
ashish sharma
|
|
|
|
|
pls help am working on a system that collects data from different forms of database and i have been able to implement 4 (mysql,xml,....)out 5 using vb.net and now am on the last one which is getting data from an excel sheet but the code aint working .. please i would be grateful for any solutions
this is my code :::
Dim olecon As OleDbConnection
Dim olecomm As OleDbCommand
Try
olecon = New OleDbConnection
olecon.ConnectionString = connstring_busary
'connection_busary is a variable the stores the conection string
olecon.Open()
olecomm = New OleDbCommand(String.Format("SELECT * FROM [sheet1$]"), olecon)
Dim reading As OleDbDataReader = olecomm.ExecuteReader()
While (reading.Read)
If Not reading.IsDBNull(reading.GetOrdinal("A7")) Then
Label1.Text = reading.GetString(reading.GetOrdinal("A7"))
End If
End While
Catch ex As OleDb.OleDbException
MessageBox.Show(ex.Message)
End Try
End Sub
when ever i run this code it just runs and does not return any value to the label i used to track if any value is been returned from the excel file ... please i need help :thumbsup:
|
|
|
|
|
The label won't repaint itself until the code is out of the loop back to the message pump. Then you'll see the last item that was set in the Label control.
The reason is that you have your long running code hogging the UI (startup) thread. This means that the UI cannot get any messages to tell it to repaint controls, including your label.
The solution is to move your long running work to a background thread, BackgroundWorker, or Task. Your background thread code them has to Invoke a method on the UI thread to update the Label control as needed. There are plenty of examples all over the web. You just need to search for "VB.NET BackgroundWorker with progress".
|
|
|
|
|
hi,
I am using webbrowser control, my question is:
is possible to suppress dialog box "save as" and download file silently?
thanks erika
|
|
|
|
|
No, this would break security, and allow websites to download malicious programs such as viruses etc, without the PC owners' knowledge.
Veni, vidi, abiit domum
|
|
|
|
|
so is it not possible to workaround the problem? can I simulate the user's click sending some command?
|
|
|
|
|
No, the reason for not allowing this is to prevent malicious use. Why do you want to breach security systems that exist to protect the user?
Veni, vidi, abiit domum
|
|
|
|
|
use HttpRequest or FtpRequest instead of webbrowser control.
|
|
|
|
|
I haven't got the url of the file, it is a file dynamically created: when I click a button, the file is created and sent onfly.
|
|
|
|
|
Attempt to load Oracle client libraries threw Bad Image Format Exception.This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.
please solve this problem immediately.
abu saleh
programmer
UY system Ltd
New dohs, dhaka,bangladesh.
|
|
|
|
|
abusalehrajib wrote: please solve this problem immediately. We're volunteers. I'll look again in an hour or so.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
You have all the information you need there to solve your issue. Big hint. 64 bit app trying to use 32 bit client.
|
|
|
|
|
abusalehrajib wrote: This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. You need to compile your app as 32-bits when using the 32-bits libraries, and as 64-bit when using those libraries.
Which did you install?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Attempt to load Oracle client libraries threw Bad Image Format Exception.This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.
please solve this problem immediately.
|
|
|
|
|
how can i create a d3.js tree with the help of the database of MVC4... or how can i get a multidimension array from JSON for a tree?
Thanking You,
|
|
|
|
|
In VS 2012 Express, I created a solution called syncpro and then renamed it multisyncpro in the solution window by using F2 and renaming the solution and then the project.
I noticed however, in the folder structure
MyDocuments
multisyncpro
syncpro
etc.
that the second-level folder is still called syncpro. In a solution that has not been renamed, the two folders are the same name. If I rename that folder outside of VS the solution won't load. How can I rename this folder so it matches the new name of multisyncpro?
Thanks...
|
|
|
|
|
It is a bit of a pain to do this but can be achieved as follows:
- In Solution Explorer, remove the project.
- Close the solution, saving changes
- Go to Windows Explorer and rename the folder containing the project
- Open the solution
- In Solution Explorer, use "Add Existing" and add the project back into the solution.
Use the best guess
|
|
|
|
|
|
What?
Veni, vidi, abiit domum
|
|
|
|
|
how to write a program in which whatever the user types into program is typed into microsoft word letter by letter....like i paste the essay of 10 pages into the program n the program gives the same in ms word letter by letter......plzz help
i know i can just copy paste it or just type into ms word directly but still i need the program..
|
|
|
|
|
|
I'm developing an application for mobile devices (Windows CE 5.0, .NET compact framwork 2.0 pre-installed) using .NET compact framework 3.5 and MS Visual Studio 2008.
I'm using the built-in option for creating localized forms. This works perfectly as long as I use the debugging function of Visual Studio with the mobile device connected to my desktop computer. In this case, Visual Studio deploys my application along with .NET compact framework 3.5. After disconnecting the mobile device and having installed my application it is still working as expected.
My problem is: If I install the .NET compact framework using the CAB file provided by Microsoft and then install my application (also by using the CAB file created by Visual Studio) without having used the debugger the application works as well but without localization. So I think there must be some parts of the .NET framework which are only installed using the deployment function of Visual Studio. - Does anybody know which parts (libraries...?) these are? Since the application will be provided to users which will not use Visual Studio I've to find a solution for this.
|
|
|
|
|
Hi,
I have an windows application. On button click, I call a service called ServiceA (ServiceA is in my local machine). From ServiceA's method, I hit database and retrieve some records. After retrieved, I call another WCF service called ServiceB (ServiceB is availabled in another machine within network). I have added ServiceB's proxy files in my ServiceA's project. endpoints and bindings are added in wwwroot\web.config. When I try to consume ServiceB's method, I am getting the following error.
Could not connect to http://tde017:8080/AdapterService/AdapterService.svc. TCP error code 10013: An attempt was made to access a socket in a way forbidden by its access permissions 17.21.11.17:8080
Previously, it throws with the port number 80. I configured the another port 8080. Now error is throwing with 8080.
But, If I consume the serviceB directly from my windows application, I am getting response. If I go through another service, I am getting error.
I tried many scenarios. But, still I could not get solution. Any one help me on this....
Thanks in advance.
Regards,
Bala
Balasubramanian K.
|
|
|
|