|
|
|
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 |
Filter by week: 1 2 3 4 5 How do I obtain a list on DSN's on as machine. Posted by Tim Marsden at 4/29/2004 1:56:50 PM Hello,
How do I obtain a list of the "ODBC" DSN's on a machine.
Tim
...more >>
problem adding child records Posted by Tony Martini at 4/28/2004 6:08:32 PM Hello all
I have a VB.Net Windows Forms application that is using bound controls. I
have datarelations defined for the parent and child tables with the Update,
Delete and accept/reject rules all set to default ( which is cascade). I can
modify and delete records. I can add records to the parent ...more >>
vb and a select statement Posted by Stephen at 4/28/2004 12:56:12 PM I have two tables ( Authors and Titles) related on a field called pubId. I
want to know what Authors do NOT have a book in the titles table.. Im stuck,
dazed and confused.... what is the sql statement i should be using to return
just the authors?
Steve
...more >>
Dataset/Datagrid/Update problems Posted by Chris Barnard at 4/28/2004 11:52:13 AM Hi,
What's the correct way to add new rows of data to a dataset when using a
datagrid? It looks like if the user adds some new records on a datagrid, I
should be able to simply run the update command from my data adapter and the
extra data will get inserted. Is that correct?
I get the follo...more >>
Value cannot be null Posted by Paul at 4/28/2004 10:17:29 AM Hi,
I'm new to .NET and I'm trying to run through the tutorial
"Creating a Web Application Using VB"
As I follow the directions, It seems to work just fine
because I can preview the data from the SQLDataAdapter
but when I try to view the data in the browser I get the
error:
Value c...more >>
System information via vb.net??????????????????????????????? Posted by John T. Howard at 4/28/2004 12:16:20 AM How can I get the System Information via vb.net? At a minimum, I need
that data supplied in Start|All Programs|Accessories|System
Tools|System Information and, preferably the Office Applications
subheader.
Thanks in advance,
John...more >>
Determining the greatest of a number of variables Posted by Jesse Gibbs via .NET 247 at 4/26/2004 10:33:02 PM Please help.
I am currently trying to write code for reports in a simple sales program.
One report is for highest selling product, and I need to know how to sort through all the inNoOfSales for each product to determine which one has the highest no of sales.
Urgent help needed, thanks in adva...more >>
DataSet to Access Posted by T Cordon at 4/26/2004 7:16:35 PM How can I insert all records from a DataSet to an Access Table.
Thanks
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
[ANN] April 27, "Working with the DataGrid Control in Visual Basic .NET" chat Posted by Jason Cooke [MSFT] at 4/26/2004 3:55:46 PM Join members of the Visual Basic .NET and SQL teams for a discussion on how
to effectively use the Windows Forms DataGrid control with Visual Basic
..NET.
Date:
April 27, 2004
Time:
Time:
1:00 - 2:00 P.M. Pacific time
4:00 - 5:00 P.M. Eastern time
20:00 - 21:00 GMT
(For a list of loc...more >>
Storing Objects Posted by Brian Mitchell at 4/25/2004 9:05:05 PM I am new to using SQL and am wondering if it's possible to store entire VB
objects (Like a Class) in a table? I know you can create custom data types
but am not sure if what I am asking is possible.
...more >>
DataTable Find method... Posted by Perry Ogletree at 4/23/2004 5:12:24 PM I'm trying to use the datatable find method to retrieve information from an
Access database. I retrieve the Access data into a dataset using:
daStationData.Fill(dsStationData,"dtblStationData")
The data is then displayed in a sorted datagrid via:
dgDisplay.SetDataBinding(dsStationData, ...more >>
HOWTO: Modify default Stored Proc. template in VS.NET database project Posted by ES at 4/23/2004 11:00:36 AM Does anyone know how to modify the default Stored Procedure template that
exists in a VS.NET database project? I know how to with Enterprise Manager,
but need the same functionality in VS.NET.
Thanks,
ES
...more >>
Using CurrentUser Function in Access from VB Posted by Steve Dowling via .NET 247 at 4/22/2004 9:56:36 PM I have been writing a program that accesses an Access database and I am having problems with a query.
The query selects records from a table based on the the user that is logged it to access. This works using the 'CurrentUser' function.
There are no problems running the query in Access but as so...more >>
Jet Won't Open Posted by Curt Emich at 4/22/2004 12:52:46 AM I get the following error when I write any code against a connection that is
hooked to an Access database:
The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\TimeTracker\Data\TimeTracker.mdb'. It is already opened
exclusively by another user, or you need permission to...more >>
Insert command failed when using DataAdapter in VS.Net Posted by Norton at 4/20/2004 6:41:43 PM Hi all,
When i try inner join tables using VS.Net's Data Adapter Configuration
Wizard, it always return generate insert, update, delete statement failed
and it said
"The original query has a select list that has columns from multiple tables.
The statement cannot be generated automatically for t...more >>
Comparing Two Records of a Table for Add, Changes, Deletes Posted by rmorvay at 4/20/2004 10:44:39 AM I need to compare a table each day to detect deltas. Is there an easy way
to compare a table for all changes each day and send those changes (Adds,
Update, and Changes) to an outbound system for processing?
Thanks in advance
--
rmorvay
...more >>
Acessing two database files...... Posted by Wayne Taylor at 4/19/2004 6:09:18 PM Hello All
I'm new to the world of database and T-SQL......I'm using VB.NET (I hope I'm
in the right place)......
The client has accessing control in there building. I have looked at the
software and it writes it's data to access databases.
There are two files seprate database files, I can...more >>
VB.Net Panels Posted by Keith Kowalski at 4/19/2004 11:48:25 AM New to Programming
I am creating a windows form in VB.Net using Visual Studio 2003, What I am
looking to do is hide a panel, and if it is hidden move the next panel up
in its place, if it is shown then move the next panel down. I an do it on a
webpge, how is it done on a windows form?
...more >>
Reading a large number of records Posted by John at 4/17/2004 12:28:28 AM Hi
Could someone please provide a code example of how to read records from an
access table into a grid, the fastest possible way, for read-only view?
Thanks
Regards
...more >>
Adding a new record Posted by Steve at 4/16/2004 11:45:51 AM Hi all
I am using DataBinding in my project. I need to be able to add a new record
through using the Me.BindingContext(m_oDataSet.SecGroup).AddNew() and then
set the values for the record programatically rather than using Textboxes,
ComboBoxes etc. How do I get a reference to the new record th...more >>
Save Text file to "My Documents" Posted by Ben at 4/15/2004 9:06:30 AM Hello,
I need to save some information into a text file.
For this, I use :
FileOpen(1, "c:\MyFile.txt", OpenMode.Output)
For I = 0 To iCpt - 1
WriteLine(1, myDs.Tables(0).Rows(I).Item("MyText"))
Next
FileClose(1)
This is running...
BUT I would like to save the text file into "My Doc...more >>
Connection handling Posted by John at 4/13/2004 10:28:15 PM Hi
Should I dispose connection after every close in my app and re-create it
when opening it or would this have some adverse effect? My app
(vb.net+access backend) seems to be stressing the server a little bit and I
wonder if disposing the connection will help the server.
Thanks
Regards
...more >>
Using the Excel Object in VB.NET Posted by Terry Olsen at 4/10/2004 4:12:27 PM Is there a good reference on the Excel Object in VB.NET? I can create the
object, send data to a sheet, open, save & print files, but I want to format
the cells (border, shading, font, merging, etc.). So far I haven't been
able to figure that part out. Any help is appreciated. Thanks!
...more >>
vb.net/sql server speed issue Posted by Chandler Dickinson at 4/10/2004 7:31:13 AM I have a vb.net application running with sql server... All calls to the
database are hit and drop.... i keep no connections open.... there are two
timers in the application that hit the database to check for new/changed
information (small hits)... here is the problem...
this one has be whippe...more >>
DataGrid delete row question... Posted by Steve at 4/8/2004 9:55:08 PM Struggling with what seems should be easy. How do you programmatically
delete selected row(s) from a DataGrid bound to a DataSet?
I created a DataTable, added two columns to it, and added rows via the
NewRow method. The grid displays the data fine. I have the row headers
turned off. I ca...more >>
Need search routine Posted by Jim Hess at 4/8/2004 10:21:45 AM I need help creating a find procedure for my database. I
am displaying records individually as opposed to using a
datagrid. As the user moves through the records, a
referenced multi-page scanned document is displayed and
the user can browse through the pages. I can't seem to
grasp the c...more >>
Password protected Access database. Posted by news.microsoft.com at 4/7/2004 1:30:49 PM Greetings! I am having a lovely issue creating an OLE connection.. When I
make an attempt to test the connection in the app I'm writing, I receive an
error as follows:
Cannot start your application. The workgroup information file is missing
or opened exclusively by another user.
This a...more >>
Updating Data Posted by Gary at 4/6/2004 9:03:44 PM I have the following code to populate some textboxes on a form. This query
only brings in one record.
strSQL = "Select * from Contact WHERE sysID = '" & g_sysID & "'"
Dim DA As New SqlClient.SqlDataAdapter(strSQL, CN)
DA.Fill(objDS, "Contact")
Me.txtFirstName.DataBindings.Add("Text", o...more >>
The string was not recoginzed as a valid datetime. There is a unknown word starting at index 1 Posted by Siva Badari Narayana at 4/5/2004 9:58:01 AM getting an error
"The string was not recoginzed as a valid datetime. There is a unknown word
starting at index 1"
the code snippet is
cmd.Parameters.Add(New System.Data.OleDb.OleDbParameter("DATEOFLOADING02",
System.Data.OleDb.OleDbType.DBTimeStamp, 0, "DATEOFLOADING02"))
cmd.parameters(0).v...more >>
Problem executing a make table query in vb.net Posted by Neil Robbins at 4/4/2004 8:35:53 PM I am trying to execute a make table query in my vb.net program. The db that
I am accessing is an Access 2000 format db. The SQL code that I am using has
been cut and pasted from the SQL View having designed the query in the
design view of Access.
The code in question is below, I apologise for ...more >>
Option Explicit and Code Syntax Posted by John at 4/4/2004 12:35:14 PM Hi
I have option explicit on and I am getting an "Option Strict On disallows
late binding." error on the following code;
UpdateCategories(bmCompanyDetails.Current("ID"))
bmCompanyDetails is the currency manager for the client table (defined as
Private WithEvents bmCompanyDetails As System...more >>
Application Speed Dilemma Posted by John at 4/3/2004 3:51:50 PM Hi
We have a database app with two front ends to handle different areas of the
application. One front end is in access 97 and the other in vb.net. The
backend is a single access 97 database.
The access side relies on access forms to handle the data while the vb.net
app, using dataset/dataa...more >>
Passing null to SQL using Data Reader. Posted by Willie Neal at 4/2/2004 5:28:59 PM How can I pass a Null value to a SQL statement from vb.net. I'm using a
command object to execute a stored procedure to populate a data reader, but
I need to pass in a null value how can I accomplish this.
Thanks,
Wil
...more >>
A Strange Issue with DataGrid Posted by sajid_yusuf NO[at]SPAM yahoo.com at 4/1/2004 12:21:34 AM Hello,
I am trying to bind a DataTable to a Grid which will allow users to
Edit data and then submit the changes back to the Database. I want to
display values in the Grid satisfying a particular criteria like
follows:
Dim tbl as new DataTable
For Each row As DataRo...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |