Visual Basic

FirstPrevNext

Create an Update for my project.... CCG331-Jul-07 8:32 CCG3 31-Jul-07 8:32  Hello all, I am working with VB.Net and I currently have a Setup Project that I do a Build on and install my program to different PCs. This works fine, but my question now is how can I create an 'update' to send my users instead of a full install. I also want to make sure that I don't send them the original MDB file again and overwrite the one they currently have on their machine. Does anyone have any suggestions or know of any links explaining how to do this? I tried the Publish but it tried to install the original MDB, which would be a very bad thing. Thanks for any advice you can offer! Re: Create an Update for my project.... Naji El Kotob31-Jul-07 9:06 Naji El Kotob 31-Jul-07 9:06  Hi, Try the ClickOnce deployment technique, start with this article http://msdn.microsoft.com/msdnmag/issues/04/05/ClickOnce/[^] hope this helps NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice... Re: Create an Update for my project.... [modified] CCG331-Jul-07 9:48 CCG3 31-Jul-07 9:48  It looks like with ClickOnce, you have to install with a ClickOnce project, and I don't have that. I added a Setup Project to my program and I am installing using the output of Build of that Setup. So I don't think that ClickOnce is a option for me. Does anyone know of anything else I can use? Re: Create an Update for my project.... CCG331-Jul-07 11:42 CCG3 31-Jul-07 11:42  What I have right now is the flag set to RemovePreviousVersion, and I set my MDB's Permanent property to true. And anytime I do an updated build, I have to change the Version. Then when they install, it will see the other version, un-install it, but leave the MDB alone, and then reinstall. Does anyone else know of a better solution for updates using the Setup Project feature? Creating database through vb.net Kashif Sabir31-Jul-07 7:19 Kashif Sabir 31-Jul-07 7:19  i have created database in sqlserver through vb it was created successfully but when i go in enterprise manager for making query the table which were created are showing no columns i.e only All columns selection check box is there what is wrong with database? When i execute select query the result pane showing all columns but no columns in the table structure above MKS Re: Creating database through vb.net Dave Kreskowiak31-Jul-07 10:07 Dave Kreskowiak 31-Jul-07 10:07  We'd need to see the code that created the table. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Creating database through vb.net Kashif Sabir31-Aug-07 0:34 Kashif Sabir 31-Aug-07 0:34  Sorry for replying late Following is the code for creating database please reply. This is how i create the data base and table. Public Function Create_UserDB(strDBFolder As String, strDBName As String, isDoubleAccounting As Boolean, isGLInclude As Boolean) As Boolean Dim strQuery As String Create_UserDB = False strQuery = "CREATE DATABASE [" & strDBName & "] " strQuery = strQuery & " ON (NAME = N'RWSDB_Data', FILENAME = N'" & strDBFolder & "\" & strDBName & ".mdf' " strQuery = strQuery & " , SIZE = 3, FILEGROWTH = 10%) LOG " strQuery = strQuery & " ON (NAME = N'RWSDB_Log', FILENAME = N'" & strDBFolder & "\" & strDBName & ".ldf' " strQuery = strQuery & " , SIZE = 1, FILEGROWTH = 10%)" ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'autoclose', N'false'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'bulkcopy', N'false'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'trunc. log', N'true'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'torn page detection', N'true'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'read only', N'false'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'dbo use', N'false'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'single', N'false'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'autoshrink', N'true'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'ANSI null default', N'false'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'recursive triggers', N'false'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'ANSI nulls', N'false'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'concat null yields null', N'false'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'cursor close on commit', N'false'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'default to local cursor', N'false'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'quoted identifier', N'false'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'ANSI warnings', N'false'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'auto create statistics', N'true'": ExecuteQuery strQuery strQuery = "exec sp_dboption N'" & strDBName & "', N'auto update statistics', N'true'": ExecuteQuery strQuery strQuery = "CREATE TABLE [" & strDBName & "].[dbo].[Calendar] (" strQuery = strQuery & " [Code] [nvarchar] (2) NOT NULL ," strQuery = strQuery & " [Original] [nvarchar] (4) NOT NULL ," strQuery = strQuery & " [Type] [nvarchar] (1) NOT NULL" strQuery = strQuery & " ) ON [PRIMARY]" ExecuteQuery strQuery strQuery = "CREATE TABLE [" & strDBName & "].[dbo].[CompanyPersonalInformation] (" strQuery = strQuery & " [Code] [nvarchar] (5) NOT NULL ," strQuery = strQuery & " [Ucode] [nvarchar] (5) NOT NULL ," strQuery = strQuery & " [GKey] [nvarchar] (100) NOT NULL ," strQuery = strQuery & " [CompanyName] [nvarchar] (100) NOT NULL ," strQuery = strQuery & " [Address] [nvarchar] (200) NOT NULL ," strQuery = strQuery & " [City] [nvarchar] (50) NOT NULL ," strQuery = strQuery & " [Country] [nvarchar] (50) NOT NULL ," strQuery = strQuery & " [Province] [nvarchar] (50) NOT NULL ," strQuery = strQuery & " [ZipCode] [nvarchar] (50) NOT NULL ," strQuery = strQuery & " [PhNo] [nvarchar] (50) NOT NULL ," strQuery = strQuery & " [FaxNo] [nvarchar] (50) NOT NULL ," strQuery = strQuery & " [EMail] [nvarchar] (50) NOT NULL ," strQuery = strQuery & " [WebAddrs] [nvarchar] (50) NOT NULL ," strQuery = strQuery & " [NTax] [nvarchar] (50) NOT NULL ," strQuery = strQuery & " [STax] [nvarchar] (50) NOT NULL ," strQuery = strQuery & " [FromDate] [nvarchar] (10) NOT NULL ," strQuery = strQuery & " [ToDate] [nvarchar] (10) NOT NULL ," strQuery = strQuery & " [CompanyName4Printing] [nvarchar] (100) NOT NULL ," strQuery = strQuery & " [STaxRate] [nvarchar] (50) NOT NULL ," strQuery = strQuery & " [IncomeTaxRate] [nvarchar] (50) NOT NULL ," strQuery = strQuery & " [MonthClosing] [nvarchar] (10) NOT NULL ," strQuery = strQuery & " [InstallationDate] [nvarchar] (10) NOT NULL ," strQuery = strQuery & " [ExpiryDate] [nvarchar] (10) NOT NULL ," strQuery = strQuery & " [Logo] [image] NOT NULL ," strQuery = strQuery & " [PictureSize] [numeric](18, 0) NOT NULL ," strQuery = strQuery & " [CreatedBy] [int] NOT NULL ," strQuery = strQuery & " [CreatedOn] [smalldatetime] NOT NULL ," strQuery = strQuery & " [UpdatedBy] [int] NOT NULL ," strQuery = strQuery & " [UpdatedOn] [smalldatetime]" strQuery = strQuery & " ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]" ExecuteQuery strQuery Public Sub ExecuteQuery(Squery As String, Optional Action As String) On Error GoTo errhandle G_cn_ConnectionToMainDB.Execute Squery 'Connection to Master Database Exit Sub errhandle: DisplayErrMsg (Err.Description) ' With frmStop ' .InitForm "Error Message", Err.Description, True ' .Show vbModal ' End With End Sub Kashif Sabir Re: Creating database through vb.net Paul Conrad31-Jul-07 13:15 Paul Conrad 31-Jul-07 13:15  Show the code like Dave recommended. "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon Creating a help file dptalt31-Jul-07 6:47 dptalt 31-Jul-07 6:47  I have a Word document I would like to use as an about screen in my application. How can I show this document, while keeping all the formatting, inside my application? Re: Creating a help file Dave Kreskowiak31-Jul-07 7:52 Dave Kreskowiak 31-Jul-07 7:52  A Word document is way too heavy for an About box and would require that every use who uses your app have Word installed just to see your About box. A lighter, though still pretty heavy IMHO, alternative is to export the document as an HTML file and use the WebBrowser component in the Toolbox to display it. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Creating a help file dptalt31-Jul-07 9:21 dptalt 31-Jul-07 9:21  I tried using the WebBrowser component but it seems I have to hard code the entire physical path to the html file. This does not work well when installing on another computer. Do you have any good examples for this component? Thanks. Re: Creating a help file Dave Kreskowiak31-Jul-07 9:32 Dave Kreskowiak 31-Jul-07 9:32  dptalt wrote: I have to hard code the entire physical path to the html file. No, you don't. Lookup Application.StartupPath. Dim fullPath As String = Path.Combine(Application.StartupPath, "help.html") A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Creating a help file dptalt31-Jul-07 10:45 dptalt 31-Jul-07 10:45  Thanks Dave, I will try it. is there any flex grid in vb.net SamRST31-Jul-07 4:21 SamRST 31-Jul-07 4:21  hi my frnds, i'm doing a vb.net windows application. here i hve a multiple entry form. is there any flex grid like vb in vb.net. how can i use it. i really fedup by searching the same.. please... please.. please.... Re: is there any flex grid in vb.net nlarson1131-Jul-07 4:25 nlarson11 31-Jul-07 4:25  if you would rather deal with flex grid you can put the grid in the vb.net project (interopt). otherwise the dategrid is the one that vb.net offers...(doesn't offer same features out of the box). Re: is there any flex grid in vb.net SamRST31-Jul-07 4:28 SamRST 31-Jul-07 4:28  can i use tat for the multiple entry Re: is there any flex grid in vb.net SamRST31-Jul-07 4:28 SamRST 31-Jul-07 4:28  can i use te datagrid for the multiple entry Re: is there any flex grid in vb.net nlarson1131-Jul-07 4:32 nlarson11 31-Jul-07 4:32  forgive but - 'multiple entry' means what? multiple tables in the same grid? - i don't know...never tried. how to add all fonts in a combo eyes200731-Jul-07 4:21 eyes2007 31-Jul-07 4:21  hi all how can i add all fonts in a combobox i have tried combobox1.items.addrange(fontfamily.families) but it fills the combo with FontFamily : Name=Arial and so on .... Re: how to add all fonts in a combo swapnil_zarbade31-Jul-07 5:34 swapnil_zarbade 31-Jul-07 5:34  System.font & add loop..... Do this & reply me dear..... TO develop project in C,C++ , VB6,vb.net..... Re: how to add all fonts in a combo eyes200731-Jul-07 5:51 eyes2007 31-Jul-07 5:51  hi i need to load all font size in the combo thnx Re: how to add all fonts in a combo Luc Pattyn31-Jul-07 6:14 Luc Pattyn 31-Jul-07 6:14  Hi, FontFamily.GetFamilies() returns an array of type FontFamily that class has a Name property. it also has a ToString() method but that is not guaranteed to return the name that you want ! Luc Pattyn try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] } catch { [Google] } Re: how to add all fonts in a combo Dave Kreskowiak31-Jul-07 6:59 Dave Kreskowiak 31-Jul-07 6:59  You'll have to wait for the user to pick the font, then repopulate a size combobox depending on the font. Not all fonts are the same. Some are bitmap fonts that have various sizes built into the file they come from, others are like TrueType fonts that are outline fonts and are only stored in the font file in one or two sizes. Those outlines are then scaled to any size the user wishes. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: how to add all fonts in a combo The Man from U.N.C.L.E.31-Jul-07 8:05 The Man from U.N.C.L.E. 31-Jul-07 8:05  Alternativly just use the FontDialog provided in the System.Windows.Forms namespace to let the user select the font, size, style and everything. That way all the hard work is done for you by Microsoft. If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) Re: how to add all fonts in a combo eyes200731-Jul-07 19:51 eyes2007 31-Jul-07 19:51  i already try it but the requirments are little bit different i must fill the combo with fontname, other combo with fontsize, other combo with fontstyle and these combo are on a toolstrip. thnx

Last Visit: 31-Dec-99 18:00     Last Update: 11-Jun-24 12:03 Refresh ᐊ Prev1...2286228722882289229022912292229322942295 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.