Well i didfix the original error with
When calling:
objDataAdapter.Fill(objDataSet, "BTC MEMBERS")
I was asking the DataAdapter to create a table called "BTC MEMBERS". So
later on when I do this:
objDataTable = objDataSet.Tables("tblBTC")
I am asking for a table from the DataSet that's not there. Changing to this
fix the problem:
objDataAdapter.Fill(objDataSet, "tblBTC")
but now im getting an error on the Line were it updates.
objDataAdapter.Update(objDataTable)
Server Error in '/btcNET' Application.
--------------------------------------------------------------------------------
Update requires a valid InsertCommand when passed DataRow collection with
new rows.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Update requires a valid
InsertCommand when passed DataRow collection with new rows.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Have a nice day.
----- Original Message -----
From: "Scott Phelps" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, January 12, 2005 4:34 AM
Subject: RE: [AspNetAnyQuestionIsOk] Form wil not submit. UPDATE
>
>
> Make sure you have the proper permissions on the database.
>
> _____
>
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 12, 2005 1:29 AM
> To: [email protected]
> Subject: Re: [AspNetAnyQuestionIsOk] Form wil not submit. UPDATE
>
>
> It does though. That same code I took from a working page. All the way to
>
>>>> objDataTable = objDataSet.Tables("tblBTC")
>>>>
>>>> objDataRow = objDataTable.NewRow()
>
>
> works on another page. Also if i comment the datarow items out it wil
> display in the repeater a recod from the dataset and tblBTC. It is on that
> one line that it says the error.
>
>
> Have a nice day.
> ----- Original Message -----
> From: "Dean Fiala" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Tuesday, January 11, 2005 11:34 PM
> Subject: Re: [AspNetAnyQuestionIsOk] Form wil not submit. UPDATE
>
>
>>
>> Odds are objDataTable has not been instantiated Could be the DataSet
>> did not fill or the table tblBTC doesn't exist.
>>
>> HTH,
>> --
>> Dean Fiala
>> Very Practical Software, Inc
>> http://www.vpsw.com
>>
>>
>>
>> Yahoo! Groups Links
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
> <http://us.ard.yahoo.com/SIG=129o1oam9/M=298184.5639630.6699735.3001176/D=gr
> oups/S=1705006764:HM/EXP=1105608668/A=2495208/R=0/SIG=11egg01lg/*http://www.
> netflix.com/Default?mqso=60188914> click here
>
> <http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=groups/S=
> :HM/A=2495208/rand=919136888>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
>
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]
> e>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
