Groups | Blog | Home


Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
December 2007
January 2008
February 2008
March 2008
April 2008
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 >>



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 >>


DevelopmentNow Blog