I have a database (Seeds1) that is connected to my project. I have gone in manually and entered data in to my database which is an Access. How do I retrieve information from my database into my program.
View 2 RepliesI start my project in vb.net backend is sql server i have completed my design now i start my coding but i am confused for connectivity code whether i used dataset or datable which is good? please give me best connection code for retriving,updating and deleting data from database..
View 1 RepliesIm taking over a project that pulls information from a database.Currently I have everything I need except the username.The person who setup the project did it as a web project so he used the MemberShip class to create unique user keys based on the person's username.
The username is not stored anywhere in the database only these userID keys.
The client wants a desktop app that mimics the website behavior of writing to the database.
Problem:I ask the user to enter in a username at the login. The username connects to the database on the server.I have no way of grabbing any user info after this point as the primary key(USERID) is a unique key and not a username. Is there a way to convert a MemberShip ProviderUserkey into a string Username or am I screwed?
i am working with the XML.i created a new winapp,added a label to my form.then i added xml file by : Add - > New Item-> XMLFile1.xml.[code]all i want to do is to display the message present in the body part in the label present in the form1.
View 1 Repliescan anyone teach me how to save data in microsoft access database and retrieving it back from database?[code]so, how do i save it in that and how do i load their data by typing their ic no only..
View 5 RepliesI am using two textboxes, one for roll number and the other for the corresponding roll number.
And I am using 4 command Buttons
Move First
Move Previous
Move Next
[Code].....
I have only just started on .Net (C#, VB) programming. Does anyone know how to retrieve live currency exchange rates data for example SGX stock market exchange rates. I am supposed to do a program which retrieves live currency exchange rates and then make use of the data on a currency converter.
View 1 Repliesi am working on a module in vb 10..i have to retrive data from the database between two dates...i have used the following code but not able to get ny output,,nt even an error
Imports System.Data.OleDb
Public Class Form4
Dim con As OleDbConnection
[Code].....
I am creating an ordering form. I have created an access database and linked it to VB2008. I am struggling to retrieve records from this database into labels. I am using a combo box to select records from the access db table, but I cant display them.Both my source and target tables have 6 columns and I want to display all columns after selecting record from the combo box.
View 6 Repliesmy project name is book bank management system i need to give my author's name,book name and number of book's needed in my front end according to tht i want to know whether my book is available or not if available means return the number of books in the database
i am using sql server 2005 as back end and visual studio 2008 as front end
I am trying to build a front end for an access database I created I can connect to the database but when I try to pull data into a data grid view I get no results Here is the code what did I do wrong(I'm also new to vb)
search
Private Sub searchbtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles searchbtn.Click
Dim srval As String
Dim type As String
[code]....
I have a ListView setup in details mode that looks like this: When the user presses the delete button, I need to go ahead and delete their record from the database. This I can do fine, but I'm stuck on how I retrieve the data that is highlighted in the ListView control. I've tried using Google but all the examples I found have failed to work.
View 1 RepliesI have a ListView control set up in details mode with 5 columns. It is populated by code using the following subroutine:
For j = 0 To 14
cmd = New OleDbCommand("SELECT TeacherName, ClassSubject, BookingDate, BookingPeriod FROM " & SchemaTable.Rows(i)!TABLE_NAME.ToString() & " WHERE (((BookingDate)=" & Chr(34) &
[code]....
Between ODBC and OLEDB providers, which one is more flexible at both the application level, and at the report level using crystal report?
View 1 Replieshow to code for database connection in vb.net 2005?
View 3 Replieshow to code for database connection in vb.net 2005?
View 1 Repliesi have visual studio 2005 installed in my pc.i have sql server 2000 as database.i have expertise in client server software written in vb6.now im trying to do the same in vb.net.i dont know how to establish a global connection in vb.net.how to do that in vb.net?in vb6 i would just write a public function in a module and it remains throughout my application.so how can i achieve the same thing in vb.net.
View 4 RepliesI am working on designing a SQL Server database connection class in VB.net 2005. The idea behind doing this will be so a developer can can call the class, pass it a stored procedure name along with the parameters, and get return values back (if any).
View 1 RepliesI want to know how to connect sql server 2005 to vb.net windows application
1)is there any connection string ?
2)if so i am using windows authendication in sql server 2005 management studio so am not entering any user id and
password to enter in sql server
3)so what should be the userid and password for the connection string can any one send me a sample code that i can refar
Dim SQLData = System.Configuration.ConfigurationManager.AppSettings("FixedLineProvisioningConnectionString")
[code].....
I am trying to connect a VB.NET 2003 Oledbdataadapter through the wizard to a SQL Server 2005 Database, but i get an error message during the wizard.These are my steps:New Connection, Select provider (Microsoft OLE DB Provider for SQL Server), Select Connection:server name, log on: use windows NT integrated security, select database. I do all these steps then click "test connection" and it is fine, but when I click "ok" and error message pops up."Unable to connect to database. It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access Databases with this version of visual studio."
View 3 RepliesI would like to enable my app to run from a central database, but I dont want to recompile should the DB server change. Are my only two options saving the connection string to an XML file or the registry?
If so I think the XML file will probably be the way I go at least for me. I dont really want to mess with the registry. I just wanted to check what my options are.
I have a program that reads a database file(.csv or.Txt) then allows user to select data from 6 different comboxes and taext boxes are then populated based on the selection made from combobox
I would like to be able to give the user the option to save their settings so next time the program is open it will connect to the same database as the last connection and also have comboboxes go to the last selection Do I have to create a save setting value for each combobox? and the connection string?
is there a simple way to just save everything? so when the program is open it goes back to the last time it was open.
Is it possible to use a file browser to load a connection string when the start form is loaded?
Using ofb As New OpenFileDialog
If ofb.ShowDialog = Windows.Forms.DialogResult.OK Then
Dim cConnectionString As String = ofb.FileName
[Code]....
I'm creating a VB.NET 2010 application which is connected to an Access 2010 database. I've set up a connection using the inbuilt connection wizard. I want to pull data from the tables using ADO.NET objects such as the data adapter to create datasets. The data adapter in ADO needs the connection object. Can I pull this from app.config? Should I junk the inbuilt connection and create a new one with code alone? Help.Scott M Brush
View 1 RepliesI am getting the error "Object reference not set to an instance of the object" Debugger is suggesting to use the "New" keyword to create an object instance, or to Check to determine if the object is null before calling the method. Error is occurring on line 27: "sReturn = ConfigurationManager.ConnectionStrings(strConnection).ConnectionString" I;m not sure where to go from here.
First, my appconfig connstrings:
<connectionStrings>
<add name="con1"
connectionString="Data Source=VMXP/SQLEXPRESS;Initial Catalog=Interview;Integrated
[Code]....
How can I call the connection string by name from an app.config file in my vb.net program?
View 1 RepliesI verified data types that are being inserted to insure that this is my problem. I dont see any exception errors.Am i missing a veriable or something that is related to my connection.
Imports System.Reflection
Imports System.Data.SqlClient
Imports PSXSTL.Data.DataAccess
[code].....
how to normalize data in database during connection
View 1 RepliesI am looking to make a data connection with a network server(sql server 2005). When I run the data source configuration wizard, it allows me only to pick a local database file. I want to use a connection string like this "Data Source=SQLSERVER;Initial Catalog=mydb;User Id=username;Password=password;" I know I can do that programmatically. But I would like to know whether I can do that using the data source wizard so that I will be able to use Bindingsources and tableadapters.
View 4 Replies