Hi All,
Code is:
Dim SubsSQLConnection As SqlConnection
SubsSQLConnection = New SqlConnection(db_connection)
Dim DASubsEmailCreation As SqlDataAdapter
Dim dsSubsEmailCreation As DataSet
DASubsEmailCreation = New SqlDataAdapter("select * from subscribers
where (emailusername is not null or len(emailusername) > 0) AND
MailAcctCreated=0", SubsSQLConnection)
DASubsEmailCreation.UpdateCommand.CommandText = ("Update Subscribers
set MailAcctCreated = 1 where ID = @Original_ID")
DASubsEmailCreation.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@Original_ID",
System.Data.SqlDbType.Int, 4, "ID"))
DASubsEmailCreation.Fill(dsSubsEmailCreation, "subsbribers")
What I am trying to do is that I will read all records in a dataset, then
extract all info I need, after that I wil run the updatecommand where a
particular field Mailacctcreated is set to 1. I am getting error
"Additional information: Object reference not set to an instance of an
object." On line DASubsEmailCreation.UpdateCommand.CommandText = ("Update
Subscribers set MailAcctCreated = 1 where ID = @Original_ID")"
Pls help me on this.
Thanks.
Usman
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/
