What is the difference between vb.net application and asp.net application? How can I publish an ASP.Net application with database residing in the server and user could update that through internet?
View 2 Replieshow to properly publish my application to the Internet, so that i can upload the new version, and upon opening, the application will replace the existing one with the new version?
My.Settings("Notepad") = TextBox2.Text
My.Settings("Notepad") = TextBox2.Text
When i run the application, that pops up in yellow with an error message, how do i fix it. I'm looking at creating an IRC client that's embedded in my application. If you are able to create it even, you will be given credits, and are able to do whatever you like with it (I'll be determining its size and positioning inside my App of course) You need to be able to CHOOSE your Channel.. the client will be connecting to the Swiftkit IRC server.
vs 2010, vb.net My program uses clickonce to automatically check my website for an updated publish, and then download and install if a newer version exists. I have been publishing my updates with the database excluded because if I include it, it overwrites the user's existing database with a new empty database.
My issue is that the new version of my software needs to have additional columns added to the existing database so that the user can save additional information. For example, the previous database table allowed saving client first name and last name, but the new version needs to have a new column for "address".
Is there a way for me to add a permanent database table or add a column to the user's existing database table without overwriting their current data?
Using Office automation in Word 2007, I view the Document Information Panel, showing me properties of a document that resides in a SharePoint location. Using VS 2008, I interrogate the following in the Immediate Window:
[code]...
but I don't see a corresponding change to the screen. I do however see that, on Advanced Properties/Custom Tab that a Custom Property by the name of "Process Name" has been recorded with the value "New Value"There seems to be some kind of one way mapping going on between "server" and "custom" properties, but the really strange part is:I can update SOME server properties, others I cannot.I don't know a darn thing about SharePoint, other than as a dumb user. And getting any help from a SharePoint admin in my company is probably a very long shot...I checked all of Word's Built-in Properties and Custom Properties, I decided that none of them can be used to update the "Process Name" "server" property.How can I update this stubborn property? Most of the server properties I can update, a few I cannot.I see some articles referring to using what looks like "SharePoint objects." Do I need to download an SDK just to populate these properties? So far I've used Office automation, because I am running locally on the user's PC and pre-filling documents using the Word object model. All that is left is to finish populating the last couple of server properties after I copied the doc to a Sharepoint folder.
i want to have a built in database for my project this is what i did so far, i placed the mdb file inside the project
[Code]...
how to publish an application with an access database file on vb 2005?
View 2 RepliesGot an asp.net 3.5 app - compiles fine, but when browse to page I get the error below. Searches for this all seem to indicate it is a namespace problem, but all of my pages seem to declare the proper namespace.
[Code]...
How do I publish/deploy the WinForms application including a database file via ClickOnce?
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback,
i made an application and it uses internet to connect to my private server database and send email sometimes.. and its working great until now that I noticed e bug in it When im not connected in internet and working with my application and then my application tries to send email or connect to my server database I got my application crashed so what I want to do is to make my application first detect if it has internet connectivity and then to connect to my server or send any mail to be more specific i want to make a loop to check for internet connectivity all the time and in that moment that im not connected to internet to stop trying to connect to my server...
View 14 RepliesI need to connect from my desktop app l(in VB.net) to a database (in MS Access) placed on the internet.[code]...
View 6 RepliesI have the same problem as in this thread [URL].
I am connecting to a SQL database on a hosted server and everything is ok but if I publish the application then it fails to connect which is a bummer because then I can't debug it!
I have tried turning off windows firewall and that doesn't make any difference.
I'm trying to update a data user using vb.net2008 and sql server management studio express for my backend. the error says "must declare the scalar variable "@username" here's the code .[code]...
View 14 RepliesI have an application X version 1.0 in Visual Basic 2008 and forwarded through setup installed on a user's PC. In this application was in these settings:
Imports System
Imports MySql.Data.MySqlClient
Now you have a link to webshop and uses HttpWebRequest. There fore I added the following settings :
Imports System.Net
Imports System.Text
Imports System.IO
[code]....
Now I have application X version 2.0, Build with Visual Basic 2008 My question is how can I get the application X version 2.0 application on the user PC so that these settings will be available? This application X version 1.0 is for several months in use!
I found there is something related "OnceClick"[code]...
but how to use it?? Got better solution like tray icon prompt the new version available. then prompt user permission for update~
if user accept to update, it will download from server and install and restart application.
I am using Visual Studio 2008 for creating a Winforms app. I have connected a database to it called XStats. There is one table in it called XGames and in that table 2 fields, XIndex (the primary key field) and GameNumber. Using the following code I can add records to the database, the data is taken from a text box, but once added I cannot view them unless I shut down the app and restart it.
con.ConnectionString = connectionString
con.Open()
Dim cmd As New SqlCommand
[Code]....
The existing records in the database are displayed on the form in detailed view via a binding navigator. How can I make it so that I can view all the records in the database, even those that are added during the current session. As will be obvious, this is my first attempt at creating and using a database with a win forms app,
I have built a very simple application which has buttons, and dropdowns containing links to intranet/internet sites.As I have no Idea on how to put them into a database for easy maintenance, this app will no doubt cause me pain.Nevertheless.. When I do create a new revised version of the file.. eg 1.0.0.1 how to I go about setting the application to auto check for updates ?
View 2 RepliesI have an application which need to interact with database and update it as required.Below i have 2 procedures AuthencateBufferLogin() - Used to impersonate the user (i.e., to work with other user, to perform some task
QueryDataBase() - Used to Query database i could able to copy files and create files as desired by using this Buffer login which has permissions in the destinated.
Note : permissions for other users were removed in these folders for security reasons
[Code]...
Update user input into database? Public Class Form4[code]...
View 3 RepliesI am using VB.NET 2010 and SQL Sever CE 3.5 database. I insert some data into my database (SDF file) and I can do any all manipulations with those data. But I cannot see those data in the data table using Data Source or Server Explorer in Visual Studio. Even If I check it once in Server Explorer, all data in the database will be deleted.
View 1 RepliesI'm trying to generate a query dynamically using textbox values from my Bookings form to update only those values that were entered by the user.[code]...
View 1 RepliesI am trying to update a SQL Server database Date field.When the user enters the date they enter 02 Oct 2010.When I pick up the DateTimePicker.Value it is 10/02/2010 00:00:00. I need to get the value to read 02/10/2010 00:00:00 How do I get the value to be in this format?
View 7 Repliesam i just stupid or do they have a ____ up system?the "publishing folder" is set to my ftp server.. and the upload works.. so thats Done.the installation folder is set to "Whata ____ is this?!" and i dont know if it works or not..it is supposed to update when the application starts.. it does not. and that does problobly have something to do whit the installation url to do..so how do i make it update automatically?
View 3 RepliesOurs is a transportation company. We do services/transportation/logistics for various companies.I am working on Scheduling a work order process for those companies who are registered with us.While during the process of registration, a company will specify the week number to execute a job during the contract period.So this will be a routine service which we need to perform for every number of weeks specified For Example: if any company specifies the week number as : 2. that means for every 2 weeks we need to do the service for that company during the contract period.
How to update the dates into the database server for each company for their jobs to be performed.So if my Admin wants to know all the jobs in this current week. I should be able to pick only those companies and their jobs in this week only.
In vb.net I am using password protected database with following connection stringconnetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:vaivaiDB.mdb;JetOLEDB:Database Password=secret;"Database access works fine on the development machine.
View 2 RepliesMy program connects to a Mysql Database. It allow registration and login. I Need this to update the "BankACCid" column(?) in Mysql for the current logged in user.This is the code that doesn't work
MySql Connection
Dim conn As MySqlConnection
conn = New MySqlConnection()
[code]....
My application needs to be able to be pointed at different SQL Servers and different databases and I would like to provide the end user with a nice method of selecting both the server and database (the app is for use by other IT staff).Ideally, I was thinking of allowing them to browse to the server (with possibly entering credentials or even better, using their Windows credentials as the databases in question should be accessible to the relevant people via their AD account), and then listing the databases on that server allowing them to select one to use.
I would like them to then be able to easily change the server and database whenever necessary.I imagine I would then need to build the connection strings based on what they select but at the moment I have got rather stuck in just trying to create a form with some kind of Server Browser (I've not got as far as a database browser!).Failing some kind of server/database browser options, I would change to some simple text boxes where the user can enter the name of the server and database directly with some kind of connection verification button.
Finally, is it easy to connect to multiple databases on the same SQL Server at the same time? Is it just a case of creating and referencing multiple connection strings?I am using VB 2008 Professional and SQL Server 2005 Standard.
I am using help of SqlServer.Management.Smo to rename an attached MS-SQL database.
Dim db As New Database = ActiveSQLServer.Databases(OLD_NAME)
db.ExecuteNonQuery("ALTER DATABASE " & OLD_NAME & " SET SINGLE_USER WITH ROLLBACK IMMEDIATE")
db.ExecuteNonQuery("ALTER DATABASE " & OLD_NAME & " MODIFY NAME = " & NEW_NAME)
The problem is that after renaming the database is set as a Single User.So what am i doing wrong?
Why doesn't the database seem to update when restarting an application after some changes?
remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback,
I'm working on creating a web application which is going to allow the user to upload a video file to the server. Once the file is uploaded to the server, it's going to be converted to .flv and copied to another folder in the same directory. Since I'm doing this from a web app, I don't want to tie up the app with the conversion process. That is when I figured this might be a good time to try threading the conversion process... what do you think?
Currently, my process logic is this:
1) User presses the upload button.
2) A dummy record is created in the database for the file being uploaded.
3) Folders are created on the server to house the original video file and the converted video file.
4) The original is copied to the server.
5) Once the original is finished being copied, the app converts the original to .flv and saves it in another folder.
6) Information about the conversion process is stored in a .xml file
7) The dummy record is updated with real data
8) There is a redirect to a page that lets the user view the .flv file on the web
I need to backup the sql server 2005 express database. It works fine if I make backup to specific folder"C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackup". But if I change the path to any other path . I got an error "Backup failed for Server 'server name'. "
My code is
Dim sqlBackup As New Backup()
sqlBackup.Action = BackupActionType.Database
sqlBackup.BackupSetDescription = "ArchiveDataBase:" + DateTime.Now.ToShortDateString()
sqlBackup.BackupSetName = "Archive"
sqlBackup.Database = "data"
[Code] .....