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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|