Windows App Using Data From SQLserver Over The Net?
Mar 4, 2009
I'm working on a little program - an issue tracker - that I thought I'd put on the web. Now I'm getting really annoyed with Visual Web Developer EE because I find it hard to work with in order to do stuff that's easy in VB. So I got a new idea. Why don't I make a windows app in VB.NET that connects to my database over the net?
Problem is that I wonder how to do this in a sequre way and I have no idea... I figure that the win app would really only be a user interface to the business logic and data that runs at my server...
I need to be able to export data from an sqlserver to an xml file (just a flat data dump) using visual basic coding - using just your basic select statement.
I would like to retrieve data from db whenever i click on a button. I have a table for questions and another table for options. I select questions randomly and trying to get the corresponding options but my code below only returns options one time and stays there even though the random number changes. As an example, if random number is 1 i have options a,b,c,d for question 1 and if random number is 2 i have options e,f,g,h for question 2, etc...
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Label1.Text = "" Label2.Text = ""
I have a web site that connects to a remote SQLServer, and is running just fine.I have some pretty simple 'batch' type tasks that I want to run (as a Windows application) on a scheduler (I'm more comfortable with VB so I prefer that).
Looks like VB Express won't allow me to access the remote data. Everything seems to be pointing to having to buy VS Professional for $545 (I don't have an original one to upgrade). Is there a more economical VB option?
im trying to access sqlserver management studio database using forms in vb.net...m using a button and i want to get access to the database when i click on that button....the code is given below....wen i tried the same code without using forms,this is working fine but it is not working when i use forms....
Imports System.Data.SqlClient Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strcon As String = "Data Source=.\sqlexpress;Initial Catalog=employee;Integrated Security=True"
I have been developing a VB 2008 application which has been using Access as its database. The app is very far a long with about 30 forms and 45 DataSets I now must change the application to use SQLServer. Unfortunately all of the Table & Attributes names have changed in the new DB. Almost all of the data model has stay the same.
I have a few questions on the conversion.
The ConnectionString is currently pointing to the Access DB. I have entered the new ConnectionString into the Setting tab. What is the best approach to make the change?
I have done some testing to change the Table & Attributes names by using Quick Replace. It seams that sometime when I would do the rename I would lose the TableAdepter on some screens.
What is the best approach to performing the renaming task?
i am working on an application and i want to connect it with mssql database , i dont know about the version of installed mssql server at the pc , how can i get the version of installed mssql server so that i can connect my application with that .(is it possible to check the version of installed mssql server with out connecting it with my application.)
I have a database in sql server 2005 named as Addressbook and table Persons with PersonID as PK.I have created 4 textbox on form for FirstName, LastName, Address, CityID and an ADD button. When I input data to text boxes and press F5 then it show some error message. I hv tried eerything but failed.My code is as following and error messae is (The SqlParameterCollection only accepts non-null SqlParameter type objects, not Boolean objects.)[code]
I have made a form to connect to a SqlServer but i have hit a dead end as the PHPMyAdmin password table is encrypted so the Login only works when you enter the encrypted password in. Is they anyway to decode the password so the password can be read?
I tried to run this on a local instance of sql-server and sadly it worked!!!now I know that the code is right and there is some kind of DBA restriction I need to find (and ask the DBA to remove)
using System; using System.Collections.Generic; using System.Text;
What is the preferred method of adding the current date/time into an SQL Server table with INSERT Command and executenonquery? I'm expecting something like ...
I've created some functions / procedures with VB.NET and want to deploy them to a SQLServer. Within Visual Studio you can click right and select "deploy". An assembly will be created on the server and a lot of functions and procedures. It's really easy.Now I want to script the whole deployment process. What is Visual Studio doing when I make a deployment? Can Visual Studio autoscript all the deployment steps for me? Can I save it to a file and execute it manually?
If the field type in the SQLServer db is 'nvarchar 10', what would be / is the field type in a DataTable filled by rows from this SQLServer table? String?
I am a beginning programmer and am tying to add a database to my visual basic 2005 express program. I have a nice working window but now a database needs to be attached. Following the add items and selecting the sqldatabase icon (and change the name) I get the following message: "Generating user instances in SQLServer is disabled. Use sp-configure 'user instances enabled' to generate user instances". I am trying for 2 days to find out what to do.
Aparently, all the solutions on the internet are for wizards but not for apprentences. I hope to become a computer wizzard but are far from it now. I scanned my computer for the file sp-configure but it does not exist. I tried sp_configure as a DOS command, checked all VB menu options to find etc. On the internet the language is out of my league and jumps too quickly.
How to store time from DTPicker in SQLServer 2000 when the front end is in VB2005. I am using the following. In the add form:- Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click Dim dsNewCustomer As DataSet = DataAccess.AuthorData.DataModule.GetNewAuthor Dim frm As New frmAuthor frm.MainForm = Me frm.LoadData(dsNewCustomer) [Code] ..... Time is not getting stored in SQLServer2000 database.
I have the same table in SQLServer and MSAccess database named "KHang" with fields : ID int identity(1,1) primary keys , MaKH char(4),TenKH varchar(50)
I connect to MsAccess database using oledb in vb.net and fill data to DataSet1. So I want to update it to SQLServer database. I mean, the result will be like this:
I'm trying to populate a datagridview with rows in the sqlserver 2005.how to use DataAdapters too well so I go back and forth between hard code and controls.I used the Datagridview control and added columns to it this way. 2 combo boxes, a check box, and 2 text boxes.The 2 combo boxes are populated with values that are already in sql Server for users to pick from. The task is displaying the description while the value is the task_ID. Here is my form on load:
Private Sub frmTimeSheet_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load currentDate = Date.Now.ToShortDateString lblDate.Text = currentDate
now the remaining things are done-able but im stuck in new requirement posted by Client which he needs to upload all images from Sql Server to Oracle Database now since old application stores images Path it is kind of new story now ?(:
i tried to build sample application since am not familiar with kind of above requested modification here is my code so far to upload images
'' Sql connection is over Dim fs as new fileStream (imgPath , io.fileMod.Open , Io.FileAccess.Read) Dim imgByte (fs.length -1 ) as byte
Is there a relatively simple way that my VB.NET application can be notified of the fact that a new value has been written to a table in SQL Server Express 2008? Polling is not an option since I'd need to do that every 10 seconds nonstop.