all groups > vb.net data > december 2004
Need example binding UI to BL to DL
Posted by Frank Romano at 12/29/2004 10:47:57 AM
Hey, everyone. I have an application that was written in VB6 that I have to
rewrite in VB.NET 2003 and I am completely lost. I have tried finding
answers to my questions in MSDN and the newsgroups, but I'm only finding
bits and pieces that just don't add up for me because I must not be using... more >>
reading and setting location for horizontal srcoll bar
Posted by ZR at 12/28/2004 5:55:03 PM
is there a way to control (get and set) the position of a Datagrid's,
horizontal scrollbar?
I am linking the datagrid to a very large table (hundreds of thousands of
records)
i cannot connect it to all the data at once since it would require lots and
lots of memory.
so i break up the tabl... more >>
Data Adapter Configuration Wizard-Where is Connection List?
Posted by Larry Woods at 12/28/2004 5:29:25 AM
I have moved some databases off of my computer. Now, when I open the Data
Adapter Configuration Wizard the first time I have to wait about 2 minutes
for it to determine that some of the connections are no longer available.
If I knew where they kept the list of connections I could go in and delet... more >>
I need to fill a combo box from one table, but bind to another
Posted by Larry Woods at 12/28/2004 4:52:43 AM
This form is a "typical" data entry form where we might be collecting
Customer information.
I am trying to fill a combo box with a dataview that has (state,stateabbrev)
as 2-col. rows. The State name will be the DisplayMember and the State
abbreviation as the Value Member. But I want the di... more >>
Equivalent of VB5 'Seek'
Posted by Stephen Bowyer at 12/27/2004 10:13:50 AM
I'm finding the change from VB5 to VB.Net hard going!
What would be the equivalent of Seek in .Net?
I simply want to know if a particular value exists in mytable in mydataset -
I don't need to display the dataset at all.
TIA,
Steve.
... more >>
ComboBox problem??? (newby in sight)
Posted by Najm at 12/26/2004 10:51:48 PM
Hi, I have a table (in MSDE2000) called ENTITE ("entity" in english) :)
the table design is the following:
CODE_ENTITE Char(8),
NOM_ENTITE Char (50),
DIRECTION Char (50).
I have a combobox bounded to the table and that displays the 'CODE_ENTITE'.
I want to have a Label or text box at the r... more >>
How do I deploy the correct Provider for the OleDbConnection??
Posted by max at 12/24/2004 7:26:08 AM
How do I install or make sure I have the correct Provider for
OleDbDataReader. On my development machine (XP Pro, SP2, VS.net 2k3)
everything works and I have the 'VFPOLEDB.1' provider available. How do I
a) make sure this provider is provided and installed in my setup package or
b) get t... more >>
Connection Timeout
Posted by M at 12/22/2004 2:15:01 PM
there are CommandTimeout for Connection object and Command object for vb6.
If there are similar properties I can set for VB.NET when I use Dataset or
Datareader?
Thanks
Chen
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Dataset vs datatable
Posted by Microsoft at 12/21/2004 12:52:14 AM
I'm reading through MSDN vb.net and I can't quite get what a dataset is vs a
datatable
I've written a program that creates a datatable then displays it in a
datagrid control, but I also need to export it to a csv and am wondering if
I should have used a dataset.
... more >>
VB express
Posted by Gonzo at 12/19/2004 12:15:50 PM
I am having trouble getting a data connection set up. I
have no problem with the server explorer - it shows the
database, tables and allows queries without a problem.
However when I use the Data Source Configuration Wizard
and navigate to the MDF file: C:\Program Files\Microsoft
SQL Server\MSSQ... more >>
Simple Question - Access DB and VB updating Rows....
Posted by CXJ at 12/17/2004 10:11:50 AM
Hi,
Does anybody know where I can find some information on Database
access/update/delete through VB.NET
I'm creating a program with multiple forms, which needs to select,add,delete
record from an ACCESS DB.
It is my first DB project and I'm totally lost...
Any help I would greatly apprec... more >>
ADO Insert problem.
Posted by vinu at 12/17/2004 2:15:03 AM
We are having a strage problem wwhen we use recordset object for insert , it
insert 3 more extra rows..
SQL :
SET NOCOUNT ON;INSERT INTO F_BANK_STATEMENTS (STATEMENTDATE,
STARTINGBALANCE, ENDINGBALANCE)
VALUES ( '16 December 2004',3.00, 3.00);SELECT @@IDENTITY AS BANKID;SET
NOCOUNT OF... more >>
Too many Oracle Connections
Posted by Bob at 12/14/2004 1:33:05 PM
Hi,
I have a dataclass that opens a connection to an Oracle 8.1.7 database,
causes a write by executing a stored procedure then closes and disposes its
connection and command objects.
Yet when I call this procedure repeatedly eventually I get a too many
connections message.
Using an Oracle mon... more >>
VB6 Question
Posted by sam at 12/11/2004 3:27:16 AM
Where does one post a VB6 Question?
What i am tring to do is?
Get the file date from a *.txt or *.dot file
Reason is I want to compare the the date of the master file
and if the master is newer than the current local file over write the older
file
Sorry for posting here if this is the wr... more >>
oledb, Insert and retrieve record
Posted by Paul Smith at 12/9/2004 5:38:55 PM
I want to insert records into a 'company' and a 'locations' table. They are
linked. So I need to insert into company table first, then retrieve this
record to get it's index, so that I can insert into Locations.
What is the best method to retrieve the record I have just inserted when I
don't k... more >>
DataTable and DataColumn event
Posted by jcvoon_99 NO[at]SPAM yahoo.com at 12/9/2004 10:47:10 AM
Hi:
I'm from Delphi world, In Delphi TDataSet (similler to DataTable) I
can use the following event
BeforeInsert, AfterInsert :
Trigger before and after add a new record into data table, in the
BeforeInsert event i can raise an exception to stop the Add action
BeforeDelete, AfterDelete... more >>
I need to run a vb.net or aspx.net file every 10 seconds.
Posted by Steve Jacobs at 12/8/2004 5:19:14 AM
Hi,
I need to run a vb.net or aspx.net file every 10 seconds. The Task Scheduler
in Windows 2003 Server can only do it every 1 minute at the minimum, but I
need it every 10 seconds. Is it possible to write a small program in VB.NET
that would run in the background without using much resources,... more >>
newbie problems
Posted by Tym at 12/7/2004 2:53:13 PM
Hi!
Moved over from VB6 to VB.Net ADO.Net.... trying to get used a a new
way of working. (No lectures on DAO please! I knew what I was doing
with that!)
Anyway.
Trying to add a record to a "table" in my database.
I've had to use SQL INSERT instead of the "proper" way as I'm damned
if ... more >>
looking for a SQLSERVER class code generator
Posted by Andrew Baker at 12/7/2004 1:50:42 AM
I am loking for a class generator that will give me a vb.net class for
accessing a sqlserver table. Something that gives an attribute for each
column in the database, and insert and update ability.
Does anyone have one they could recomend?
TIA
Andrew
... more >>
Find the size of a DataSet
Posted by Matt at 12/6/2004 8:55:59 AM
Hello,
Is it possible to find the size of a populated DataSet?
I have an application (VB.Net) that that populates a DataSet and then
sends that DataSet to a PDA.
The application on the PDA then uses that DataSet.
The size of the DataSet makes quite a bit of difference to the transfer
time ... more >>
Combo Box Listing Category
Posted by Jeremy Dillinger at 12/3/2004 12:29:25 AM
I have a program setup to pull data from a database. My database table has
things such as (category, Item, price, etc.) In my program I want to have
multiple list boxes that will have a pull down list of different categories.
The category is stored as a number and the item is stored as a string... more >>
Is JET Support installed on Basic Windows Installation?
Posted by Daren Hawes at 12/2/2004 8:22:57 PM
This is a multi-part message in MIME format.
------=_NextPart_000_0058_01C4D8AC.D8DA0D80
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi I am making a small App that will use a Access DB to store about 30
records.
My question is what percentage of Clean... more >>
"Syntax Error or Access Violation" ???
Posted by scott.shelbourne NO[at]SPAM gmail.com at 12/1/2004 2:55:06 PM
I'm getting a "Syntax error or access violation" error when I try to
run a SQLServer stored procedure from my ASP.NET application. I can
run the same exact procedure from Query Analyzer with no problems. I
have checked the security permissions on SQLServer and have ensured
this user has db_owner... more >>
|