I m working on an school management application, i design the database in access2003 and forms in vb.net2005. but i dont have any idea about the database conectivity. with the help of a book to connect with the db but i cannot save the data in the mdb file. in my application 1 add the followin buttons add new record modify record delete search using id or enrolment no.
View 1 RepliesCode for database connectivity using vb.net
View 1 RepliesI was maked a application in visual studio 2008 using language vb & now i want to connect with database so plz mail the steps required for database connectivity using ms access or sql server.
View 1 Repliesi used the below coding to add the data in my database but its not getting updated,its just showing updated in data grid view but not in database
Dim newaddRow As teleDataSet.addRow
newaddRow = Me.TeleDataSet.add.NewaddRow()
newaddRow.name = "kumar"
[code].....
how i connect vb 2010 to ms access
View 1 Repliesi want database connectivity to access or sql
View 3 RepliesI want to connect my Desktop application (VB.Net) to my Database (SQL server 2005). The problem is my Database is in the other country.In my local network my application works fine.I am using IP address for connect database. for example : my IP addrees is 222.22.22.22.
View 1 RepliesI am using the following code to establish a database connection to my datagridview and Access database. Here I am giving my file path name to the connection. This code works fine only on my computer. To make this code run on another computer I need to change the database pathname in the code. Is there anyway I can make this connection dynamic so that I can make this program run on any computer
Dim Data1 As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=C:\Users\Desktop\Work\Visual basic\alldata.mdb")
Dim Case1 As OleDbCommand = New OleDbCommand("SELECT * FROM case1", Data1)
[code]......
give me the source code to add database connectivity in VB2010 express through ADO.Net. Including all the commands to add, update, delete, retrieve and modify the database fields. It would be really helpful if anyone can provide me with a small prototype working model with the source code.
View 1 Repliesi just want to know how i can connect to database in visual basic 2008 with ms access plz give me code for database connectivity.
View 3 Replies2 insert d code to move 2 d next record of the database in a table that has one CHECKBOX? i tried using the regular method of heckbox1=.Item("BookingStatus").ToString
View 1 RepliesI'm studying Visual Basic (using Visual Studio 2008) as part of an all-round IT foundation degree...I must confess that programming is becoming my weak spot! Unlike the C++ I was taught last year, I'm not finding VB too easy...probably becasue I've never programmed this way before and I've missed a couple of lessons.
View 2 RepliesSend me code for ms access database connectivity using oledb and adodb using vb.net
View 5 RepliesI want to know how connect ms access 2007 with vb.net? and what is code for it?
View 4 RepliesPublic Class Form1
Inherits System.Windows.Forms.Form
Dim con As New OleDb.OleDbConnection
[CODE]...
ABOVE CODE GIVES THE FOLLOWING ERROR WHEN I RUN IT.....:-"An unhandled exception of type 'System.Reflection.TargetInvocationException' occurred in mscorlib.dll
Additional information: Exception has been thrown by the target of an invocation."
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 have written this code to inser data in my database table "member "through the form but it is not working if i start debugging the code it gives no error but when i open my database table to see the inserted data it is not working.
Imports System.Data.SqlClient
Public Class Form3
Dim con As New SqlConnection("Data
[code].....
I am using Visual Studio 2010. I want to do database connectivity using VB.Net and MS SQL Server 2005. I know 1 way of doing this. Following are the steps...
1. Create a new Data Source Using Data Sources Window.
2. Select the appropriate view like details view/ data grid view for that data source
3. Drag that data source on your form and connectivity is done. Also all the controls are created by the visual studio.
This feature is really cool but I want to learn database connectivity by pure coding without using such advanced features. Also is it possible to do connectivity from a class library ?
Need a procedure in SQL for translate a datatable in English to Arabic .I am having English table which is having category ID ,Code etc upto 25 columns in the SQL Database.We want to translate this table to arabic when user opts for Arabic .So need a procedure to convert this English table to Arabic.Do i want to use google translator for this case . Then how will it is linked with database .
View 1 RepliesThe main purpose of the my app that I need your help with is, to deliver an always (or close to) up to date a list of files for the user to choose from for a variety of common purposes. For instance, opening the selected file in its native client editor application so the user can make changes. Another purposes would be to print the file, and I have others.
If nothing else (meaning recommendations for a better design that still keep my desired in mind) I'd like ideas on how to update my complex DataSet (background processing options, what's the most efficeient/quickest way to update my DataSet) as the list of files changes while my app is running and my app is designed to never close due to the long amount of time it take to load it initially.
The list must be always kept up to date while my app is running because not only the intial loading of data takes a lot of time but updates (new/modified/deleted) could potentially take too long depending on not only how much data to update/add (new files) but how efficeient my code is in updating the list. To be perfectly clear: If a new file is created then it need to be somehow (automatically preferably or manually i.e. button code) add to the list. If a file is deleted then it needs to bet removed from the list. And if the file has changed, perhaps some of it metadata or thumbnail image have changes so update the file's data in the list. All of which (new/modified/deleted) need to be as real-time as possble without degrading the server too much and without the user waiting more than a handful of seconds.
Listing all the files as quick as possible whether that be with or without metadata initially is very important because most of the time the user is going to filter (or scroll the list by typing) for a partial file name. Once the user filters/scrolls to the desired file there's a very good chance that he/she isn't even interested in the metadata, most of the time the user wants my app to open the selected file in its native client editor application so he/she can view or modify the file. The initial
load time of the data doesn't concern me as much as updates because the user can possibly do other things while it initially loads all the data as long as it not too long (more than a few minutes). From there the updates will either be automatic if possible (most desirable from a users standpoint) or the user initiated (e.g. button). Plus I'm thinking the updates might need to be done with a few different background processes (multiple threads) because I think I need one for periodic updates (e.g. every
15 minutes) and one background process for page updates meaning whatever the user has either scrolled to or filtered for, more accurately all files currently display to the user will be systematically update in the background so the user can still operate my app.
I'm currently using SqlDataAdapter.Fill to fill a DataSet object variable (which is bound [BindingSource] to a DataGridview control) to first populate the DataSet from the SQL query and then prorgammatically adds records (DataRow) for local files but please make recommendations. I don't mind big changes or starting over if necessary, I just want the best app possible based on the aforementioned criteria. I'm not sure if it complicates matters but I've also added custom columns in the DataSet for some special needs (thumbnail of files, booleans for tracking custom statuses). For the local files I'm currently populating the DataSet prorammatically (iterating a path/file string collect made by System.IO.Directory.GetFiles) since the list is first (and very quickly) populated with Vault files (which is always a far larger list than the local files) so . Again, I don't have to take this direction, make recommendations.
i try using both detail view and form view but they are not flexible enough to place my picture where i want it
View 1 RepliesI've been studying design patterns off-and-on now for a project I've recently been working on. I've been fortunate with this last one not to have to work with databases, but will soon have an opportunity.
View 8 RepliesI am developing an "AddressBook" like project in VB.NET. While developing database in SQL Server2005, i want to follow the principals of normalization and keep its degree of normalization as high as possible. Fields i am using are these.
Create table AddressBook_Contact
(
Contact_ID int Primary Key,FirstName varchar(15),MiddleName varchar(15),LastName
[code]......
I was hoping that I could get some guidance from some of you guys on Object Design with Database back ends. I am trying to build what could be considered to be my first full scale application, which is a student tracker (simplification). While I have a reasonable idea of how I would go about designing the classes for the system, the bit that I don't know how to do is, how I would go about getting the data to and from the database.
For example with my other applications, I have done a couple of things;
1) Gathered all the data when the application started up, creating the objects then. Then when the application closed sending the data back to the database.
2) Have the code which deals with getting the data in the specific class, so the student class for example would take only one constructor argument which would be the studentID, then the class code would connect to the database and populate the object fields as appropriate.
3) Variations of the above. I have also looked into LINQ, which seems like it would be very useful if you don't expect your classes to deal with any business logic and just data, but I suppose it would be possible to create a wrapper class that would include the business logic.
[Code]....
I was hoping that I could get some guidance from some of you guys on Object Design with Database back ends.I am trying to build what could be considered to be my first full scale application, which is a student tracker (simplification). While I have a reasonable idea of how I would go about designing the classes for the system, the bit that I don't know how to do is, how I would go about getting the data to and from the database
View 3 RepliesI am trying to verify connectivity from my application to various servers - For now I am only concerned with mail servers... (later SQL etc)Before anyone gets all upset and thinking this is for SPAM - wrong - these are to confirm connectivity from the application for sending logs OR to ensure the SQL conneciton is working appropriately - Those that want to SPAM can do this simply by getting LINUX and doing it for free with ANY mail client (I add this ONLY because MOST SMTP threads go unanswered... which is silly... there are MANY good reasons to work with mail within an application.....)So what I have tried is opening a telnet session, grabbing the output, and going from there...But it is not working.... the output contains nothing specific to the telnet session I initiate - and.... of course from the command prompt manually i DO get the proper responses
[code]...
I get the command prompt header, I see the commands... I see the prompts... but after the telnet command there is nothing I am assuming there is an issue redirecting telnet info and the telnet session terminates the second I try to read the data
I am designing a database using access 2010 and I ve been asked to design the user interface with Visual basic.I actually have designed tables and their relationship and did some queries according to the requirements. how do I create user interface in VB from this point knowing I don't have any form and report designed in access?
View 6 RepliesThere exists a database that holds information on each planet in the solar system. The database has multiple tables.The program intends to access this data to display it to the user in a variety of manners. The program does not intend to manipulate the data at its source, though calculations on two fields may be performed to determine certain display characteristics.What is the optimal method for accessing the data?My initial approach, (read: gut feeling, no research) was to take each related row of data from the database and create an object of a custom class based on the data. So you might wind up with:[code]Then use these objects to perform whatever actions the program needed to. I ran into a lot of problems trying to implement this, so that I believe my design approach is fundamentally flawed.
View 1 RepliesI am looping through a database with pdf locations. The application is button click event driven. The problem I am having is that I display a pdf. If the user clicks on the button then the pdf information is inserted into a database and the loop should be taking me to the next pdf. However, this loop does not seem to give what I need. What ends up happening is the first pdf gets displayed twice. I think mainly because I display the first pdf onload, but when I click the button it agrees and grabs the first item from the database. And it ends up falling behind because its restarting the query and I cant quite figure out how to get the button to catch the first displayed pdf, or skip it entirely since I am using a welcome pdf. So on the welcome pdf that is supposed to be displayed initially the user clicks agree and it agrees to the welcome pdf instead of just skipping it. I am not quite sure how to just move past the pdf.
public sub onload()
display the welcome pdf
end sub
[CODE]...
Now if I run the code without the loop it works fine. I just end up having to run the app however many pdfs I have in my database.
query data
display data
insert data
Windows.Forms.Application.Exit()
To display pdfs I imported the com control for adobe so pdfs get displayed like this:
axacropdf1.src = my.mysettings.default.readpath & pdflocation
pdflocation is passed from a query fill.
I think I have an underlying design issue which probably precedes the loop.
I am using visual studio 2008 professional edition, and i need some help in my assignment project.below are my screen interface and my database design view, relationship view, and coding and this is my coding Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
[Code]...