I am trying to migrate from Access Database to SQL server database. Do I need to make changes (for saving, reading, deleting etc. data) to my code as well?
I understand I need to change connection but what about code?
First, I would like to add a text box search field to this form (because navigating through several thousand users with arrows isn't going to work). When the search button is pressed, I want the username to be looked for. If found, the form (and each textbox, option button, etc.) is updated with that user. I can then modify the user's information and press save.
Second, how do I access and change information in a database with only code? For example, if I periodically want to check every user in the database to see if they have over "100 points" and if they do, I subtract 10 points from that user.
I have made several changes to the columns in an Access db, such as additional columns, column type changes, etc. how do I now incorporate those changes into my datasource? Do I need to delete the datasource and create it from scratch?
View 1 RepliesI am developing a vb.net application in SQL server 2005 ,now i would like to import MS access database tables from a network into sql server 2005 database, using stored procedure or vb.net code without using SQL server 2005 Wizard .
View 1 RepliesI'm basically trying to implement the functionality of the example here ax/grid/examples/dataediting/editondblclick/defaultvb.aspx) on my own site, but instead of using a data source control located in the page markup (like in the example: essionDataSource), I'm using a dataset that I get from some server code-behind. I am able to successfully get my double-clicked row into edit mode with my dropdowns successfully
View 2 Replieswhen i will enter form no. in the text box this should check the on the lost focus event either this form no. is already exsist or not.if exist show msgbox?
View 1 RepliesI use this code to populate info from Access DB to txtBox[code]...
View 1 RepliesI'm getting familiar now with using the Dataset Designer and how it makes for quick and easy updates and query of tables. I use to use the OleDB commands and leave the Connection String as a Global Constant so I can easily change it if the server name changes, or if we have to re-direct the .NET to another instance of the database.
But now that I use the Dataset designer I'm concerned that I maintain flexibility and support in the long run. how the Dataset designer works and where it stores it's connection string info? And how difficult that would be to update. It looks like I modify the App.config file, but I'm unfamiliar with this.
What am I getting myself into? It looks like a standard XML file. Is that it?
I have a code in VB that looks like this:'Server.Transfer(txtUser.Text + "_page.aspx")which is taking a forms authenticated user to their page. For example if John logs in, it will take him to john_page.aspx.How will I be able to integrate this in a PHP login script?I'm trying something like:header("location: $member ._page.php");but I don't think I'm doing this correctly.
View 1 RepliesHow do I create a Login Verification routine (Login Form) in vb.net . i have an windows application with login form contain user name , password , ok button and cancel button .
as this one:
Imports System.Data.OleDb
Public Class LoginForm1
' OK button
[Code].....
but i want to run my application from desktop and will get confirmation if the user name and password correct by checking them in MS Access Database in the server.
so the the application in the desktop and the tabel of user name and password in the server.
I got a DATASource connected, changed the table to details and draged it on to my form, but then it shows me the bindingnavigator at to of my form.
q1. how do i make it so every time this form opens it is like add new?
q2. how do make my own save button (don't want the binding navigator at top)
q3. in my form all my collums aper as textboxes how can i change it so there is a drop down menue that has forexaple 3 pre defined items that the user has to select on of.
I have a website that currently uses a MS Access database, but I have been asked to change it to an SQL Server DB. I used the upsizing wizard and have changed the association in the web site from c3.mdb to c3.adp but I get the error "unrecognized database format. I tried using the .mdf file
Code:
Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
' Fires when the application is started
[code].....
I have 10 Comboboxes in a form. All these combo boxes have databound items which come from the same column in a table in the database (access 07) (Am designing a billing software, and these comboboxes show the items (10 lines of them).All these combos reside in one Groupbox.Now for the strange (scary/funny) part, whenever I change a value of 1 combo, all the other combos change automatically and show the same value as the one that was changed. (strange!).
View 6 RepliesI have developed some software(vb.net) that records fees paid by the students. The purpose is that the database should be stored in a server, which can be accessed from any stations linked with it.This is working fine with a network of 10 computers. I need to publish it over the net so people could do this job logging in over internet. Database (access database) should be stored on a web based server.
View 1 RepliesI have a similar problem posted in the forum similar to this : started learning VB. I am not able to get my example code to work to access an Access database through automation. The author of my book suggested that I might not have the correct Jet 4.0 engine. The specs I have are: MSJet40.dll, Dated 7/14/2009, Prod Ver 4.00.9756.0.
View 3 RepliesI am trying to migrate from Access Database to SQL server database. Do I need to make changes (for saving, reading, deleting etc. data) to my code as well?
I understand I need to change connection but what about code?
Is there a way to include in my solution a copy of my dataset in my solution , so I can use it in another environment without access access to my SQL server database?
View 3 RepliesHow to access sql server database through LAN? I ask this for my client server progrmming because im a beginner.
View 1 RepliesI just want to ask how many user can access with microsoft access database simultaneously?I am planning to make an application using microsoft access. My client want to connect at least 5 pc/user with this database.
View 2 RepliesHow to change read_only to read_write in vb.net SQL Server database connection? Error message:
Failed to update databse because the database is read_only
I know there are the 'Wizards' to help me, but I need the code to access the Table Manager, the data set and so on, create them in my project and access the tables or stored procedures
View 2 Repliesi want to know how to export sql server 2005 database to access through vb.net coding..no need to select n insert table one by one,just save package...
View 8 RepliesI'm making a VB.NET application with an SQL Server 2005 in the background. Naturally the user can not edit the database directly but will use a number of UI features to be able to add and modify the data.However, there are a few tables that should be easily accessible from the admin interface such as specific information about a vendor. What's the easiest way to let the user edit this data freely? One way would be to use a DataGridView but this could appear complicated to the user, plus I'm not sure exactly when to save the edited data back to the database.
The best way that I can think of is to create custom dialog boxes for adding, deleting and changing the information, but this seems like too much work for such a small feature.
i used V S 2010, and Sql server 2005, now i want to know how i can set passord for access my database in sql server, and how can i make a connection of it.
View 1 RepliesFirst off this isn't a homework assignment I am doing, I'm making a customer database program for my husband.The problem I am having is that I need to be able to access a database without the need of an sql server.
[Code]...
it is a GUI application, and the only book i have on the subject deals mostly with console applications. I also added the data source to the project in visual studio. please tell me what I am doing wrong and how to correct it?
I just started learning VB 2010 through a book. I'm learning vb to design a program which can manage customers of a small company as a homework. It'll store data (Company Name, Phone N. and Adress) at an Access Database. (I'm using Access 2007)
I have a little background with programming but none with databases. According to the book there is no way I can delete, add or update a data from an Access Database without installing SQL Server or Express. But this program should work at a computer which may or may not have SQL server or MS Access (Any computer with Windows OS).
After a little digging only thing I could find was Walkthrough: Saving Data to a Database (Multiple Tables) from MSDN and did every step and at the end, I can delete or add rows and change values of the cells but cannot save them (when I click save, close the program and re-open it, changes are gone).
I don't get that how can I view all the data from database without SQL server but can't save changes to the database file without SQL Server.
Is there a way to do this without SQL Server? If so, can you give the right code for the MSDN Walkthrough's Save button? Or point me to a page where can i learn the right code?
I'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.
Here's my code:
<%@Page language="vb" explicit="true" debug="true"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
[CODE]...
im currently working in a project and i already made a code for the login, the only thing is that i dont know how to update the records(Username/Password) in access using VB 2010. well i can update by manually changing the content of my table but i like to have it change using an interface in my vb named Manage account
View 9 RepliesOk, so I've got this Visual Studio 2008 Project I was working with about a year ago perhaps. And this project had a datagrid that was linked to an external database running on a server off the internet. Now, this databinding was all done using Visual Studio 2008's built in features. But how can I now change the binding to a different server, without destroying the project? I've noticed that a lot of the code that Visual Studio creates makes a mess. So manually trying to change the datasource has allways f*cked up the whole project for me.
I'm not all that good with this stuff, that's why I used the built in features of Visual Studio. But I noticed that several things appear, like a binding source, and a dataset. Is it possible to do this? Perhaps even better, making these settings be controlled after the program has been compiled. The way it is now, it's all hard coded after compiling, and that kinda sucks. I remember trying to do this about a year ago, trying to bind these settings to variables stored in settings. But I never got that to work. Just throwing around ideas here
I want it to take the text from the text box and use that to search the badge column from the db and tell me if it exists or not.[code]...
View 3 Replies