Hi, Actually, Excel and RTF (RichTextFile) use different structure!Actually, you can use the Excel Object Library to access and manage your excel files (check this article Opening and Navigating Excel with C#[^] hope it helps. Do you want to open it as read-only or for editing? good luck and happy new year.
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice... http://www.facebook.com/group.php?gid=5932660937[^]
Hi, You don't need a complicated algo. here, RDLC is more than enough. good luck,
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice... http://www.facebook.com/group.php?gid=5932660937[^]
Hi, Actually, you don't need to think about locations and positions, just design your reports, you can use the preprinted form as a background (temporary) for alignments, and the printer will take care about the rest. Hope this will help. best regards,
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice... http://www.facebook.com/group.php?gid=5932660937[^]
Hi, If I understood you right, you are working on multi-language website, and you need to save the lang of user based on his/her selection. To use cookie, simply go to this website http://msdn.microsoft.com/en-us/library/system.web.httpcookie.aspx[^] but to work effectively you need to load the value from a cookie e.g. en-US at session startup (use global.asax) if there is no cookie, assign a default value, and use session and "overrides sub InitializeCulture" event to assign lang to Thread.CurrentThread.CurrentUICulture/CurrentCulture if session expired, reload the value from cookie again... hope this will help you and others. regards, NajiCo
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice... http://www.facebook.com/group.php?gid=5932660937[^]
Hi, Great :) ... on the other hand, check Dave's comment regarding the location of database! best regards,
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice... http://www.facebook.com/group.php?gid=5932660937[^]
Hi Dave, Actualy, using "|DataDirectory|" is very helpful to locate a database in the app's folder, it's not restricted to ClickOnce, just give it a try! best regards, NajiCo
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice... http://www.facebook.com/group.php?gid=5932660937[^]
Hi, Try "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\db1.mdb" good luck :) NajiCo
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice... http://www.facebook.com/group.php?gid=5932660937[^]
Hi, This is a threading issue. Try to move your code from DoWork to a new sub e.g. 1. Private Sub CreateNewForm() Dim f As New System.Windows.Forms.Form Dim label1 As New System.Windows.Forms.TextBox f.Size = New System.Drawing.Size(487, 416) f.Name = "Form6" f.Text = "Form6" f.Location = New System.Drawing.Point(0, 0) label1.Name = "text1" label1.Size = New System.Drawing.Size(100, 20) label1.Location = New System.Drawing.Point(54, 37) f.BackColor = Color.Gray f.Activate() f.Controls.Add(label1) f.Show() End Sub 2. At the member level add: Private Delegate Sub delCreateNewForm() 3. In the DoWork sub invoke the CreateNewForm sub: Private Sub DoJob(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Dim d As New delCreateNewForm(AddressOf CreateNewForm) Me.Invoke(d) End Sub Hope this helps :)
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice... http://www.facebook.com/group.php?gid=5932660937[^]
Hi, I am not sure if I got you right, but to bind an array to a listbox you can do the following: Dim arr() as string = {"A", "B", "C"} Listbox1.Datasource = arr ' -> A, B, and C will be displayed in three items Hope this helps :)
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice... http://www.facebook.com/group.php?gid=5932660937[^]
Hi, I think you must try the settings file, it's a new technique simple and beautiful. I'll show you a way to use it, go to project > new item > settings file (name it e.g. testsettings.settings) > add a new record (use the user scope). in your form: 'Read Dim s As New TestSettings MsgBox(s.FieldName) 'Update s.FieldName = NewValue s.Save() hope this helps NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice... http://www.facebook.com/group.php?gid=5932660937[^]
Hi, No, TableAdapters will manage this for you! regards,
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...
Hi, This is a simple start http://community.sharpdevelop.net/blogs/mattward/articles/YourFirstVBNetProjectHelloWorld.aspx[^] Hope this helps :)
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...
Hi, Do you host your textboxes into sub-containers (e.g. Groupbox, Panel, ...) If yes, then you must iterate over the controls of sub-containers. Hope this helps :)
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...
Hi John, This will answer your needs http://msdn2.microsoft.com/en-us/library/ms252073(VS.80).aspx[^] Good Luck :)
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...
Hi, Dim CurrentChild As Form = Me.ActiveMDIChild hope this helps :)
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...
Hi, RDL technology (Report Definition Language) http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx[^] has a built-in functionalies for linking with DataSet/MSSQL and exporting pdf/xls/... documents. Actually, I like RDL more than CR ;) Hope this helps :)
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...
Hi, Dim cfgMap As New ExeConfigurationFileMap cfgMap.ExeConfigFilename = "MyConfigFile.exe.config" cfg = ConfigurationManager.OpenMappedExeConfiguration(cfgMap, ConfigurationUserLevel.None) For i As Integer = 0 To cfg.ConnectionStrings.ConnectionStrings.Count - 1 MsgBox(cfg.ConnectionStrings.ConnectionStrings(i).ConnectionString) Next Note: The type of extra applications in your solution is dll or exe? Hope this helps :)
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...
Hi, Dim sql as String = "SELECT ID FROM TABLENAME WHERE C = 'X'" Dim cmd as New SQLCommand(sql, connectionstring) ... open connection... Dim idx as integer = CInt(cmd.ExecuteScalar) Msgbox idx.ToString hope this helps :)
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...
Hi, ActiveX has a lifecycle, please check the following article http://www.developerfusion.co.uk/show/1661/4/[^] Hope it helps :)
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...
Hi, I am not sure if I understand your request clearly, but I think you need a query notification, did you try the SQLDependency class, it helps in refreshing the cached data when the original database changed. for more details please check this url http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqldependency.aspx[^] hope this helps :)
NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...