column name = CustomerName
SQL server database name = SQLDEV6.
I have been given a task to create a application in vb that is supose to load data from a table named tblCustomers from a DataBase.
I am trying to load CustomerName and PrintStreamACNO from tblCustomers to my dropdownlist. I am not getting the correct syntax on the binding and displaying.
Imports System
Imports System.IO
Imports System.Reflection
Imports PSXSTL.Data
Imports PSXSTL.Data.DataAccess
[Code]...
how i can connect to an access database and fill a combox with data of a column?
View 1 Replies'm just a beginner who want to learn on manipulating SQL Server data using vb.net. I have already experienced manipulating data in ms access. So I just recycled the code that I used in here. But unfortunately I got this error:Object reference not set to an instance of an object.And another problem is that, I'm not really sure if what I have inputted in the SqlConnection matches what is in SQL Server. Here is a screen shot of sql server management studio express:
Imorts system.data.sqlclient
'declarations
Dim idnum As String
[code].....
We are thinking about changing our current database system, MS Access 2007 front end and MS SQL Server 2005 backend to using a higher level language such as Visual Basic .Net. I wonder if this is the BEST solution for data management? Currently, among others, we have two big database programs that handle more than two hundred users and it's crashed often. That's the reason we think about changing to something that can handle these database programs effectively preferably using MS technology such as .Net.
View 12 RepliesI am trying to retrieve data row by row from my SQL Server and load them into my respective textboxes, I was doing the below code but of course it doesn't work as the For Each loop will load every single textboxes with each data retrieved,
[Code]...
I've got a database that's 13,000 lines long and I'm trying to load this into a string array when the program loads but it takes approx 5-6 minutes for it to load it.I've got a MS Access database or an Excel file that I can load this information from, each has two rows: SVONo, Description This is my current MS Access
[code]...
Does anyone have any idea of how to make it faster? Or does anyone have a better way?I did have the idea of loading it by letting the user select the first letter and then only loading the ones that begin with that letter but I've got 4000-5000 'S' ones and it still takes about 2-3 minutes to load it All I want is to load the data from the database or the excel file and then put the products into 'cboProducts' and the 'cboProducts AutoCompleSourceList' and the descriptions into the 'txtDescriptions' AutoCompleteSourceList and a string array.Then when the user selects a product using 'cboProducts' the description will automatically be put into 'txtDescription'.
I am trying to retrieve data row by row from my SQL Server and load them into my respective textboxes, I was doing the below code but of course it doesn't work as the For Each loop will load every single textboxes with each data retrieved, ran out of ideas.
Private Sub retrieve_Data()
Dim con As New SqlConnection
Dim cmd As New SqlCommand
[Code]....
My question: i have a combobox which i would like to populate with data from a database. The table looks like this: pkIntCompany (the pk) & chrCompanyName You see nothing special.
I would like all the records in a combobox. When a user selects one of the value, i would like to show the pk and the combobox in a textbox (seperate). Is there someone who has some example code?
I have been given the below form but here i cant understand the use of this checkbox named LoanCredit card number.I am told that when user checks it then all master data will be displayed. does it mean that when i am entering some data in the database then the data will not not appear in the dropdownlist of the creditcard no. combobox automatically,on checking the checkbox the creditcard no. which is saved in the database will be added in its dropdown list? again when i uncheck it then again the dropdownlist of the combobox will become empty?
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 problem loading data to a tree view control using SQL SERVER db as my backend...i just found out that sqlserver dont accept multiple SQLDATAREADER
The code below works in SQLCOMPACT EDITION..
CODE:
I have use this code in my applications using SQLCE as my backend, but when i transfered to sqlserver it doesnt work because of the datareader..
Output is like this
Quote2011[January][February]
2010[January][February]
something like that
If i put it in a single query(sqlYear & sqlMonth), the ouput will be like this
Quote2011[february]
2011[january]
i have a listview and everytime I load a 10,000 data my listview hang up. Is there any alternative on how to load data to listview that will not hang up.
View 10 Repliesam trying to load data from an excel worksheet & its really giving me headache. A particular column contains both string and numeric data. its picking only the numeric data & loading the string data as blank entries. I tried checking what may be wrong, i think i saw a documentation that says Excel scans the first 8 rows of a column & determines it data type.plz, how can i load everything on the sheet (i can get everything as string, but i dont want to lose any entry)
View 3 RepliesI keep getting an IOException, because the file is apparently already in use. I'm pretty sure I closed every handle, and I don't know what to do.
High-Score
If haswon Then
Dim strFormat As New StringFormat()
[code]....
How can I write a connection string? I has four different computer that can be connect via ethernet.How can I maintain a inserting data if to computer insert on same table at a single time..??
View 1 Repliesthis is a reference to the thread:he problem I was having while loading data into a datagrid from Excel is solved when I have changed the connection string property IMEX to 1 in:
HTML
con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filename & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1;""")
[code].....
I am tring to make the below application work with SQL Server 2005 Database Currently it works for test.mdb, which is in the same folder with the application. How shoud I modify the MapPath to work with SQL Server.
[Code]...
I have a vb.net form to add, modify or delete the product list..i have a datagridview in which i m loading data from sql server datatable...now i have a text box which accepts code for the product..i want that when i press a key, all data starting with that key should be highlighted in datagridview.....
eg
i have product codes
A001
A002
A003
C001
D001,, etc..
Now i press A in text box...in datagridview all data with A should be highlighted
How can i search my database using a combobox were he will suggest list of names in the combobox list . It will search all fields in my database. My DB is created in access.ex. i type Kev then the combobox list will have Kevin then Kevlan on its list knowing that Kevin and Kevlan are in my database .
View 11 Repliesi have access database connected to application.. i have a table in database called "clanovi" (members) and first column items loaded to combobox their name and surname..now..when i select one of them from combo box i need all their other info loaded into several text boxes..adress,email etc..all of that info is in the same table ..i need some example code too .
View 6 RepliesCode:
Sub laad_leden()
Dim myConnection As New connectdb
Dim tabel As New DataTable
[CODE]...
While loading the data to the program the window freezes. It shows the progressbar but the progressbar is also freezing. How can i let the progressbar marquee while loading / freezing.
an application i developed using vb 2008 express, to fill a web form with data from an access database, one after another when a button is clicked hasn't given me what i expected. the loop was suposed to stop after filling web form with the first data on clicking a button and continue to fill the webform with the next(2nd) data from the database on clicking the button again. Below is the code i wrote
Private
Sub STARTButton_Click(ByVal
sender As System.Object,
ByVal e
[Code]....
Sub laad_leden()
Dim myConnection As New connectdb
Dim tabel As New DataTable[code]....
While loading the data to the program the window freezes. It shows the progressbar but the progressbar is also freezing.How can i let the progressbar marquee while loading / freezing.
I am using following code to get data from database and load to picture box
Dim vrPicFromDB = IO.File.ReadAllBytes(DsPic.tblPicTest.Item("Picture"))
Dim ms As New MemoryStream(vrPicFromDB)
PictureBox1.Image = Image.FromStream(ms)
It gives error on DsPic.tblPicTest.Item("Picture")) portion of the statement.
I also tried
CByte(DsPic.tblPicTest.Item("Picture")))
but it gives the same error.
I recently upgraded the MS SQL Server installed on my personal computer from 2005 Express to 2008 Express. Problem is when I try to add an SQL database file to a project using VS 2005 I get an error message saying that the version of my database server is not supported, I must have SQL Server 2005 Beta 2 or later installed. I didn't do it yet but I'm pretty sure that when I open the other projects that I included a database file to it, I'm going to get the same error.
My question is it possible to have two SQL Servers installed on my machine? If so, is it a good idea to have two DB servers in the same machine?
Ive created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
before re-inventing the wheel, i want to ask you how i can do this best: I have a VB.Net application that uses a database connection to MS SQL Server 2005 (express version). There are users that input data with the application into the database lets say once to 2x an hour to once a minute. I want to do backups like this: Once a day or once a week (in the evening) a full backup, and whenever the program/user is idle for lets say 10 Minutes, i want to do an incremental backup (so that it does not take so long until he can work on after the backup).
There are no big security issues, just copying the backup data files to a network share / a different computer or server would be fine. i guess the average db size may be 300MB, but the daily increments about 1MB.
[Code]...
I had made a project in VB.NET 2005 with SQL SERVER 2005 used as database. Now i want to make a setup of this project but i am unable to integrate sqldatabase and .net framework in this setup project. Is there any way to do this. Because it is assumed that the client does not have .NET Framework installed nor he has SQL Server on his system and the worst condition would be he does not have even internet connection from where these two setups can be downloaded if we give the condition for downloading these programs from the net if the client does not have these programs installed on his machine.
View 2 RepliesI am using a Class_SQL that gets the table, creates the DataAdapter and DataTable.I have a combobox named cboFullname. I can fill the combobox with data from the database, ie: Dim sqlcmdtext As String = "SELECT *, Firstname + ' ' + Surname AS Fullname From Contacts". I can display full records in a datagridview.
I would like to be able to select a name from the combobox and have the record text boxes display the data and be changed with the cbofullname index changed subroutine. Here is my current code to date:
Public Class frmMain Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...