I'm pretty sure I read a while back about microsoft providing the source
code for a web based forum built using asp.net, I'm looking for this
now, if anyone can point me to it, I'd greatly appreciate it, thanks!

Alex

-----Original Message-----
From: Bhagvan Chougule [mailto:bhagvan@a...] 
Sent: Wednesday, January 22, 2003 7:17 AM
To: aspx_beginners
Subject: [aspx_beginners] problem with DataAdapter.update when DataTable
contains multiple-column primary key


Dear friends,
       I am having an access database which contains a table with
multiple 
column primary key (which i belive cannot be defined in access).
       This multiple-column primary key is defined on the table as
follows

Dim ColumnArray(2) As DataColumn
ColumnArray(0) = objDataTable.Columns("id")
ColumnArray(1) = objDataTable.Columns("Type") ColumnArray(0).AllowDBNull
= False ColumnArray(1).AllowDBNull = False Dim objUnique As New
UniqueConstraint("aa", New DataColumn()_
          {objDataTable.Columns("id"), objDataTable.Columns("Type")})
objDataTable.Constraints.Add(objUnique)
objDataTable.PrimaryKey = ColumnArray

       I have printed this displayed key using datagrid and it shows it 
in  a way it should be

DataGrid1.DataSource = objDataTable.PrimaryKey
DataGrid1.DataBind()

But when i try to upadate the DataTable using DataAdapter it gives an
error

objCommandBuilder = New OleDbCommandBuilder(objDataAdapter)
objDataAdapter.UpdateCommand = objCommandBuilder.GetUpdateCommand
objDataAdapter.Update(objDataSet, strTableName)

Error:

Dynamic SQL generation for the UpdateCommand is not supported against a 
SelectCommand that does not return any key column information.

Source Error: 

Line 124: Public Sub UpdateChange()
Line 125: objCommandBuilder = New OleDbCommandBuilder(objDataAdapter)
Line 126: objDataAdapter.UpdateCommand 
objCommandBuilder.GetUpdateCommand
Line 127: objDataAdapter.Update(objDataSet, strTableName)
Line 128: End Sub

But when i added the primary key in database itself everything works
fine.

Please help me to sort out the problem.

The website: http://www.ibuyspy.net/Forums/Download/ is probably what
you are looking for.

Joey

-----Original Message-----
From: Alex Smotritsky [mailto:alex.smotritsky@v...]
Sent: Wednesday, January 22, 2003 2:18 AM
To: aspx_beginners
Subject: [aspx_beginners] aspx forum

I'm pretty sure I read a while back about microsoft providing the source
code for a web based forum built using asp.net, I'm looking for this
now, if anyone can point me to it, I'd greatly appreciate it, thanks!

Alex

That page is currently unavailable but there's a good one here:

http://www.asp.net/, mark pointed me to it


-----Original Message-----
From: Joey Brenn [mailto:jbrenn@f...] 
Sent: Wednesday, January 22, 2003 9:27 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: aspx forum


The website: http://www.ibuyspy.net/Forums/Download/ is probably what
you are looking for.

Joey

-----Original Message-----
From: Alex Smotritsky [mailto:alex.smotritsky@v...] 
Sent: Wednesday, January 22, 2003 2:18 AM
To: aspx_beginners
Subject: [aspx_beginners] aspx forum

I'm pretty sure I read a while back about microsoft providing the source
code for a web based forum built using asp.net, I'm looking for this
now, if anyone can point me to it, I'd greatly appreciate it, thanks!

Alex

yeah both are one n the same

regards
rohit

-----Original Message-----
From: Alex Smotritsky [mailto:alex.smotritsky@v...]
Sent: Thursday, January 23, 2003 4:04 PM
To: aspx_beginners
Subject: [aspx_beginners] RE: aspx forum


That page is currently unavailable but there's a good one here:

http://www.asp.net/, mark pointed me to it


-----Original Message-----
From: Joey Brenn [mailto:jbrenn@f...]
Sent: Wednesday, January 22, 2003 9:27 AM
To: aspx_beginners
Subject: [aspx_beginners] RE: aspx forum


The website: http://www.ibuyspy.net/Forums/Download/ is probably what
you are looking for.

Joey

-----Original Message-----
From: Alex Smotritsky [mailto:alex.smotritsky@v...]
Sent: Wednesday, January 22, 2003 2:18 AM
To: aspx_beginners
Subject: [aspx_beginners] aspx forum

I'm pretty sure I read a while back about microsoft providing the source
code for a web based forum built using asp.net, I'm looking for this
now, if anyone can point me to it, I'd greatly appreciate it, thanks!

Alex