|
i suggest you start here[^] and follow through the different links, do a few exercises, etc. the basic concept is pretty easy
connection object > data adapter > dataset
if you know how to work with these data access is a breeze. there are other methods as well (of course) but get started with these and have fun
|
|
|
|
|
i create a Class that creates an excel file from a datatable. but the final sheet in the excel workbook looks awful!!? the columns of datatable are sorted alphabetically in the excel worksheet.here's my class source code:
Imports Microsoft.Office.Interop
Imports System.Globalization
Imports System.Threading
Public Class CreateXLS
Public Sub GenerateXLS(ByVal Table As DataTable, ByVal TargetXLSPath As String)
Table.WriteXml("C:\tmpxls.xml")
Dim oldCI As CultureInfo = Thread.CurrentThread.CurrentCulture
Try
'Start Excel and open the resulting file.
Dim oExcel As New Excel.Application
Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")
oExcel.Workbooks.Add()
oExcel.Workbooks.OpenXML("C:\tmpxls.xml")
oExcel.ActiveWorkbook.SaveAs(TargetXLSPath)
oExcel.Application.Quit()
Catch
Throw New ArgumentException("Error in File Saving")
Finally
My.Computer.FileSystem.DeleteFile("C:\tmpxls.xml")
Thread.CurrentThread.CurrentCulture = oldCI
End Try
End Sub
End Class
Can you help me to save target worksheet as it is on the source datatable?
thanks
-- modified at 7:24 Friday 7th July, 2006
|
|
|
|
|
You might want to just open the XML file in Excel yourself and see what it's doing. Since none of us here can see your XML file, it's about the only way you're going to see what you need to do to get in in the format you want.
Dave Kreskowiak
Microsoft MVP - Visual Basic
-- modified at 7:39 Friday 7th July, 2006
|
|
|
|
|
Hello to all
I have a computer used as PDC and File-Server. SUSE Linux 9.3 is installed on it and the files are released for the net with Samba.
MS Visual Studio 2005 is locally installed on my notebook whereas I would like to save my projects on the file server.
Now, when I open a project I always the message that the location for the projects isn’t confidential/ protected enough and that when processing the application actions could occur which need “”full reliability”.
It’s possible to ignore this warning message and to continue but when testing the programm a new message appears: “Never enter personal information or passwords unless you can check the source and rely on it”.
I’m programming an application in Visual Basic which accesses the SAP System via RFC. When giving the command Create Object(”SAP Functions”) I get an error message “Security Exception wasn’t treated”.
When saving the project locally, everything works smoothly. Does anybody has any idea for solving the problem?
Thanks a lot in advance!
|
|
|
|
|
This is because of Code Access Security[^]. Code running from an untrusted network source runs in a restricted sandbox. This is why you're getting all these errors. Move the project to a local folder and you won't get any of these errors.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I have package my application and install to another machine, if the user just click Start --> Run and then type short word after that run my application automaticial. Example as notepad
Thanks
................
|
|
|
|
|
in your deployment you will need to install a shortcut to the app in the client machine's system folder. give the icon the short word you would like to use as its name, when users type this word into the Run dialog it will call the app to run.
|
|
|
|
|
Should i install short cut application system folder 32?
Thanks
................
|
|
|
|
|
yes.
you can install to this folder in your setup project by:
1. right-click on setup project. select "View > File System"
2. on the main menu bar click on "Action > Add Special Folder > System folder".
3. create a new shortcut to your primary output in the system folder you have created and name the shortcut the short word you wish to use.
4. build and test.
hope that helps.
|
|
|
|
|
Now, just the Windows folder wtill do it.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I have make one application by using RichTextBox, user can write and read file and can change font and color also, if the user save theri as my application extension i want my application remember all such font, color, image. Please help me
Thanks
................
|
|
|
|
|
Registry.CurrentUser.OpenSubKey(path,true)
Registry.LocalMachine.OpenSubKey(path,true)
both return nothing, i do not know the reason, pls what will i do for getting result
(i am trying to get the IE properties of Header and footer)
pls help me
|
|
|
|
|
is path correct?? same path cannot be run on both LocalMachine and CurrentUser, LocalMachine is used for HKEY_LOCAL_MACHINE and CurrentUser is used for HKEY_CURRENT_USER. path should be relative to them. when wrong path is provided, these functions return nothing.
Regards
Shajeel
|
|
|
|
|
thanks for reply
path is Software\\Microsoft\\Internet Explorer\\PageSetup
Registry.CurrentUser.OpenSubKey(path,true)
"PageSetup" is in under HKEY_CURRENT_USER,
with regard
sriguru
|
|
|
|
|
thanks for reply
path is Software\\Microsoft\\Internet Explorer\\PageSetup
Registry.CurrentUser.OpenSubKey(path,true)
"PageSetup" is in under HKEY_CURRENT_USER,
Regards
sriguru
|
|
|
|
|
What's with the double slashed??? Those are only appropriate in C++ and C#. Change them to single slashes and it'll work.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
HI,
Is there a way to close/terminate another application (for example paint.exe) from my vb.net application?
Thanks
|
|
|
|
|
You can use the Process[^] class to do this.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
i have a datagrid that bind to oracle table. i want to update the table thru datagrid . how ? wen i try with dataadapter.update(dataset.tablename) then updation not working. how v can update a database thru dataset
wich is the best vb.net book i can buy from book store
-- modified at 12:27 Saturday 8th July, 2006
|
|
|
|
|
Hi all,
I facing a problem with listview now, now I have data in the listview, when I click on the header of the column1, the search key will be point to column1. Mean that user will search what ever data in column1. When user click on the column2 then the search key will point to column2 no longer in column1 at all. For example, I have 3 column in my listview, 1) Employee No, 2) First Name 3) Second Name, when user click on the header of Employee No, user only can search for employee no not for first name and second name, by the way, user click on the header of first name, the user sure only can search for first name, and no more for employee no and also not for second name. Can anyone help me on this? Thanks.
|
|
|
|
|
HI,
Is there way to have the progress bar works according the loading percentage of another application opened from my application?
Thanks.
|
|
|
|
|
No. There is no information that is returned by the system's loader at any time, let alone anything useful for a progress bar.
Your other application would have to expose something like this, but can only do so after it's loaded, started, and initializing itself.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Actually, I just need an indication that the application has loaded. If this is the case, is there any way to do it?
|
|
|
|
|
szevy_suez wrote: I just need an indication that the application has loaded.
What does that mean? If you talking about the application initializing itself, then yes you can. All you have to do update the ProgressBar in your applications initialization code.
If you're talking about a progress bar while the application is being loaded from disk, then no, you can't. The system Loader doesn't provide any feedback at all. Your ProgressBar would go from 0 to 100% in one step.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Dave Kreskowiak wrote: If you talking about the application initializing itself, then yes you can. All you have to do update the ProgressBar in your applications initialization code.
Sorry, but I don't really understand what you mean by application initializing itself.
Actually, I just want my application to know when the other application has loaded, so I can make that application the active application at that instance and use sendkeys method. So I thought can set a condition if the progressbar is 100% then I can proceed with Appactive and sendkeys methods. I don't know whether it's appropriate, please advice.
Thanks
|
|
|
|