Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
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
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
all groups > dotnet ado.net > august 2003 > threads for monday august 18

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

MSDE: create new Login and Password
Posted by Giuseppe Pezzella at 8/18/2003 11:53:26 PM
Can I create new login and password in MSDE without know any previous login and password?? Can I Change password to sa account in MSDE? ...more >>


DataRow.Select Weirdness!
Posted by Lucas Tam at 8/18/2003 10:38:50 PM
Hi all, I'm doing something really simple with my datarows: Dim DIAL As DataTable DIAL = DS.Tables("Dial") ' Define the whereClause as a string to select the record by refno Dim whereClause As String = ("refno = " + CType(Me.refno, String) _ + " AND campaignID = " + CType(Me.campaignID, ...more >>

dataGrid
Posted by John Shaw at 8/18/2003 6:39:14 PM
When I load the datagrid with data using sqlDataAdapter2.Fill(dataSet21,"Table"); The Data is loaded with and extra (empty)line at the bottom of the grid. It has an * to the left of the line. Is there a way to prevent this empty line from appearing? I get an exception error when this line is ...more >>

MSDE Most Misterious of Egipt Pyramid.......
Posted by Giuseppe Pezzella at 8/18/2003 6:04:47 PM
Dear friend, I'm using MSDE and VB.Net My problem is that when try to connect at database message box say me: "SQL server don't exist or denide access". Now: I have reistall Msdn but nothing is changed I have manually change login autentication mode from Windows NT to SQL (article 2850...more >>

Exclusive lock in SELECT
Posted by Rodrigo Meneses at 8/18/2003 5:32:30 PM
Hi. When I execute a SELECT using the Fill method of SqlDataAdapter class, there is a exclusive lock on all the tables that apperas in the SELECT clause. I ain't using transactions. Therefore, while the SELECT is executing, I can't have interaction with the tables. Hope someone has an answer ...more >>

Retrieving a value from the database
Posted by Tom Archer at 8/18/2003 5:25:41 PM
When handling a concurrency conflict, is there a way to get the value currently in the database without having to manually create a command object? Someone here pointed to the MS site where they have a "walkthrough" on handling concurrency issues. However, their demo uses two datasets in...more >>

Custom DataAdapter Class
Posted by Jeverson at 8/18/2003 12:23:37 PM
Hi All, I'm tryin' to create a new DataAdapter class. This class inherits from System.Data.Common.DbDataAdapter and implements the following interfaces: IDbDataAdapter and ICloneable. Here is the class declaration and a simplified version of the constructor called by VS.NET: [Seria...more >>

DataView not writing changes to DataSet????
Posted by twsmith at 8/18/2003 12:13:11 PM
Greetings, I have a textbox control with has a binding to a DataView (which always has only one row). Changes to the row are persisted during the lifetime of the DataSet/DataTable which underlies the DataView. However when I use MyDataAdaptor.update() the change is ignored. When I progr...more >>



Passing Null Values via a SQLCommand.Parameter
Posted by Thomas Ficker at 8/18/2003 11:08:16 AM
I use stored procedures in most of my programs and in many instances one or more of the parameters being passed can be null. I am looking for the most efficent way to test for a null value then pass it to the parameter object. Here is an example of what I do now, paying special attention to the ...more >>

Using Strongly Typed Datasets
Posted by Wayne Wengert at 8/18/2003 9:22:40 AM
Environment: VS.NET 2003; VB, Access 2003 database. The application allows users to specify the path/filename and the table name at runtime. I am trying to figure out how I can use a strongly typed dataset in this environment. If I add an OleDBDataAdapter to my project and then create a datase...more >>


DevelopmentNow Blog