|
|
|
February 2004 March 2004 April 2004 May 2004 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 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Are the Dispose and Close methods necessary? Posted by Steve Lynch at 2/28/2006 3:12:14 PM
I'm just learning about the DataAdapter, SqlConnection/OracleConnection,
OracleCommand/SqlCommand. I'm just curious if the Dispose() and Close() methods
are necessary, or if they're called automatically when the variable goes out of
scope. For example, in this code I don't think they are r...more >>
Save DataReader and then close server connection Posted by Steve Lynch at 2/27/2006 4:42:46 PM
Is it possible to fill a DataReader (like SqlDataReader or OracleDataReader) and
then assign this object to a another, sort of like clone it? What I'd like to
do is connect to Oracle or SQLServer, retrieve all of the records (rows) and
then close the connection to the server. But still hav...more >>
101VB Samples Posted by Jerome at 2/26/2006 5:58:54 PM Hi,
Has anyone ever been able to get the samples from Microsoft (101 VB samples)
to work?
I wanted to try the "CreatingMasterDetails" and this is what i get from the
start:
Invalid column name 'DepartmentID'.
Invalid column name 'BaseRate'.
PLUS....
My AdventureWorks database is corrup...more >>
VS2005 DataGridView Selecting Cell Contents Posted by Kimbo at 2/25/2006 12:00:00 AM Hi
I have a small program with a DataGridView that displays two columns
of data, I want to be able to double click on any row and get the data
that is in the first column position of the current selected row. I
could do this quite easily in Vs2003 with a Datagrid but cannot work
it out for a ...more >>
Connection string question Posted by Mark Clark at 2/23/2006 1:42:05 PM I'm new to VB.NET and VS 2005, and I need some help with connection
strings.
I want to be able to modify a connection string at runtime. The way
I've been trying to set up a project is to add a new data source via the
'Data' menu, which creates a connection string in the App.Config fil...more >>
How to read Access Data Access Pages with vb .net Posted by Paul M at 2/21/2006 12:00:00 AM Hello,
I want to to be able to read line by line the contents (ie the html)
inside some Data Access Pages I have in a Microsoft Access database.
There doesnt seem to be a call I can use in the Access library within VB
..net to allow me to read lines (there is for modules).
On option I tho...more >>
OleDBProNet 1.5.0.1 released for managing large rowset of records Posted by Yuancai (Charlie) Ye at 2/20/2006 10:00:05 AM Hi, All:
OleDBProNet version 1.5.0.1 is released at www.udaparts.com.
OleDBProNet is integrated with DataGridView with OleDBProNet. Binding
OleDBProNet with a DataGridView control becomes extremely easy. This is
great for navigating a large rowset using server cursor, and is much faste...more >>
Type 'ADODB.Connection' is not defined. Posted by Joe Befumo at 2/19/2006 10:06:05 AM I'm getting the following error in my application:
Compiler Error Message: BC30002: Type 'ADODB.Connection' is not defined.
Source Error:
Line 112: if(Request.Form("HdnQuestionCount") = 0) thenLine 113:Line 114:
Dim objDataConn as ADODB.ConnectionLine 115: Dim objRSList as
ADO...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Data not saved in database Posted by Georg Hickel at 2/18/2006 6:20:05 PM Hi,
i just try the Walkthrough: "Displaying Data on a form in a window app"
everything works fine (data is visible and navigation works) but
When i change data in a record the changes are not saved in the northwind
database (after clicking save button in the binding navigator). but the
ch...more >>
Simple but difficult to find solution for loading HTML into object Posted by Joe at 2/8/2006 2:50:12 PM Hi, I have a simple thing I need to do but just doesn't work in VB.NET.
I have a string with HTML code and I want to load it into a HTMLDocument
object or something similiar to it so I can access the the tags and tags
value (<td> <table>, etc) by code.
But it just doesn't work in VB.NET...more >>
Null in Date field Posted by td at 2/8/2006 1:46:43 PM In the SQL Server table the RequestDate is set to Allow Nulls. A Stored
Procedure on the table has a variable @RequestDate DateTime; however, if I
pass a parameter with a NULL:
If .RevisionDate = "" Then
cmd.Parameters.Add("@RevisionDate", Nothing)
Else
cmd.Parameters...more >>
HTML in to readable/value accessible object Posted by Joe at 2/7/2006 10:21:43 PM Can someone show me how I can correctly put the HTML code of a webpage into
an object where I can access the various values of the tages in VB.net?
I did it in VB6 with HTMLDocument, but its seems to not work for me in
VB.NET.
Thanks in advance
...more >>
Loading HTML into an HTMLDoc problem Posted by Joe at 2/7/2006 4:48:56 PM I am trying to load some HTML code in a string variable into a
mshtml.HTMLDocument object. I want to do that so I can access the various
tags and structures (<table>, <a>, using VB.NET code)
So is there a good way to load HTML to an object and access its parts with
VB.NET ?
I have an erro...more >>
Get headers from Excel Posted by Morrigan at 2/7/2006 12:22:21 PM Hello,
I'am trying to get the column headers out of an Excelfile, with the
following code i managed to get the names of the sheets that are
available in the workbook and fill a ComboBox with those names.
##CODE##
Dim DatabaseConnection As New System.Data.OleDb.OleDbConnection
...more >>
Dynamic Insert Statement Posted by Denis Correard at 2/6/2006 3:22:09 PM I have an application that create an insert statment on the fly (it would be
to complex to create stored procedures for all senarios) like:
insert into Table (field1, field2,field3 ,field4 ) VALUES
('Test','Test',0,0)
so fare so good but I would like my statement to return the new PK_ID
So ...more >>
Visual Basic 2005 CreateFile Posted by Fla at 2/6/2006 2:05:26 AM Hy!
I'm a newbie to VB 2005 and I have to connect my program to a driver
previously developed for a custom ISA card.
With my old VB 6 code I used the routine CreateFileA exported from
kernel32 with this defination:
Declare Function CreateFile Lib "kernel32" Alias "CreateFileA" (ByVal
lpFileN...more >>
Drag and Drop Posted by Tim Ferguson at 2/5/2006 10:25:03 AM I may be doing something really stupid here, but I can't see what.
Using VB.Net 2005 Express Edition, with a form and a DataSet pointed to a
database on SQL Server Express; all the fields are visible in the Data
Sources window.
The form has a load of text boxes on it.
My book says I ca...more >>
Cancelling a SQL statement in a Thread Posted by SQLScott at 2/3/2006 6:06:42 AM I have an application in which threads are used in some cases to query and
return data from a SQL Server 2005 database. I know how to cancel threads,
that is not the problem. However, the problem is I would like to be able to
cancel the execution of the SQL statement in the thread. What hap...more >>
Problem filling a dataset -> the field is not big enough for the amount of data... Posted by James at 2/2/2006 12:00:00 AM Hi,
I need to fill a dataset from a Excel datasheet but, one of the rows in
excel has a field with more than 255 character. When I try to fill de
dataset with the Excel data, I obtain an error like: too much data for the
dataset field.
Actually the field in the dataset is a string field....more >>
Problem while adding text to the last column in listview. Posted by sonali_reddy123 NO[at]SPAM yahoo.com at 2/1/2006 10:06:04 PM Hi all,
I have a listview control which has four columns like { Col1, Col2,
Col3, Col4}.
I add data in listview like this,
dim lvitem as listviewItem
lvItem = listvie1.Items.add("Text")
lvItem.SubItems.add("SubH1")
lvItem.SubItems.add("SubH2")
lvItem.SubItems.add(" ")
Now after ...more >>
Interview Questions Feb 01 2006 Posted by Jobs at 2/1/2006 7:58:01 PM
What's difference between thread and process?
A thread is a path of execution that run on CPU, a process is a
collection of threads that share the same virtual memory. A
process has at least one thread of execution, and a thread always run
in a process
Full Interview Questions for .NET ...more >>
How to get data from three tables in MDB file? Posted by Terry Olsen at 2/1/2006 1:07:11 PM I have a database that I need to get shipment information from. It is
stored in three different tables in the database.
The calPackage table has all the information for each package. One of
the fields points to another table (calShipment) where I need to pull
the m_ShipDateTime value. I also ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |