all groups > dotnet datatools > january 2006
Visual Basic.NET - Picture Box Display
Posted by briansignal at 1/29/2006 1:17:27 PM
A friend of mine has writen a program using Visual Basic.Net to enable users
to design their own Model Railway Layout control system.
The problem is in the Option Forms that display a Picture Box above Radio
Buttons. The Picture Box displays correctly on a normal PC screen (4x3 ratio)
but n... more >>
Get a specific record's data
Posted by Erez Mor at 1/29/2006 12:57:27 PM
helo all
i'm quite new to vb.net
i'm trying to use the online help suggestion that's supposed to load a
specific table row into a variable:
Dim Lnrow As paraohDataSet.LoansRow
Lnrow = ParaohDataSet.Loans.FindBylID(5)
trying to use it to reach any value, like using this line:
LID.Text = L... more >>
Connection object
Posted by mortb at 1/25/2006 12:00:00 AM
I've understood that connection objects are an expensive rescource that
should be dropped when finnished using them. Is this true for closed
connections or just for open ones?
I've implemented a background jobs queue that will run jobs one after one in
their own threads on my webserver. Each ... more >>
Using COUNT() in .Net
Posted by Andrew Chalk at 1/23/2006 8:39:23 PM
How do I get the results back from an SQL COUNT() operation in .Net. For
example a query formulated something like this:
SELECT COUNT(*) AS Expr1
FROM ChannelConfiguration AS X
Many thanks.
... more >>
Navigation in grids
Posted by Rafael at 1/21/2006 1:01:02 PM
Please, can anyone tell me how can I know which table is currently being
showed in a DataGrid, after the user has navigated?
The DataSource points to the main table, but when it has foreign keys
constraints (and AllowNavigation is tru of course), and the parent table also
has relationships ... more >>
Need fast access to remote SQL Server
Posted by James at 1/18/2006 10:02:12 AM
Hi,
We have implemented a vb.net frontend that access a SQL-Server via VNP.
Actully the frontend retrieve several dataset and show them to the user. The
problem is that some of those dataset have more than 25.000 rows so it
slowdown the program. My question is:
1) Is there a faster way t... more >>
Selecting rows with Strong Data Types DataSets
Posted by Rafael at 1/17/2006 5:28:02 PM
I’m using Strong Data Types DataSets. Using it is great for several reasons,
one of them is creating new rows using NewTableRow, this row is not a simple
DataRow, but a complex DataRow with table fields as properties,
xmlSchemaWriting, etc..
But when you perform table.Select it returns a ... more >>
Applications that create databases
Posted by Rafael at 1/11/2006 2:56:04 PM
I'm developing an application that lets the user to create a database and use
it.
I use the ADOX function NewCatalog, and it works fine.
But I'd like to design databases with the graphic interface of VS (schemas,
xsd, and so forth) and also datasets with strong types (to have all fields o... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Saving objects in a Jet 4.0 database
Posted by Rafael at 1/11/2006 2:38:04 PM
I need to know how to save an object (say a class, a picture, etc) in a field
of an Access database.
Could anybody help with this?
--
Thanks in advance
Rafael... more >>
VS.Net 2005 can't connect to remote SQL Server instance
Posted by chris at 1/11/2006 6:59:02 AM
I'm having an issue with VS.Net 2005. I just installed it and can't
connect any remote SQL instance from the IDE. My project is set up to
reference a remote SQL 2000 DB. I can connect to the SQL DB from Enterprise
Manager and VS.Net 2003. Anyone else have this problem? Just another
note... more >>
Using Objects as Data Sources
Posted by Otis Mukinfus at 1/7/2006 12:04:02 PM
VS 2005 has the option of using objects as datasources.
I'm able to add a an object to my project as a datasource by using the
Data Source Configuration Wizard, but can't seem to make it do
anything. For example when I bind a list<> object to a DataGridView
control a BindingSource and Binding... more >>
Database Diagrams folder
Posted by kh at 1/6/2006 4:03:02 AM
Hi. I have created a connection to a SQL Server 2000 database from VS05 using
the dbo account and I cannot see the Database Diagrams folder. What are the
requirements for being able to create database diagrams from VS05?
Many thanks
kh
... more >>
Database project useful?
Posted by davem at 1/5/2006 8:01:04 AM
I'm experimenting with a Database Project in Visual Studio 2003. It looks
like SQL Enterprise Manager, more or less. Does VS add anything that I can't
do in Enterprise Manager (version control of DDL, for example)?
Dave
... more >>
working with relationships
Posted by papalazarou at 1/5/2006 3:22:04 AM
Hi,
I am working on an SQL Server client for .NET and I have created a simple
recordlist class that accepts a table or row-returning sql command on
construction and provides a list view of the resultant query.
It would be good if i could create a relationship-aware version of the
recordl... more >>
Writing to Access Database Problem
Posted by McMogul at 1/3/2006 9:12:05 AM
Hi,
I am updating an Access Database (4.0 all service packs up to date) with a
vb.net web application. The data adapter and update commands are all formed
with the wizard. When I update a field that is defined as 'Date/Time' with a
'General' format in the database with the system variable '... more >>
|