Re: Error on Update - Connection already Open()

[Frank]

DABolle is a private field inside the Form class that contains the bound 
textboxes (hope this is what you asked). The code I posted is an handler of 
a button click event also contained in the form.
Thanks for the answer,
Frank

----- Original Message ----- 



> Ok, my next question is as follows:  Is the DABolle DataAdapter declared 
> publicly?  If it is how did you give it it's Update Command?
>
> Brandon Schenz
> www.schenzcustomdesigns.com
>
> -----Original message-----
>> Here's the code (I'm trying to update using bound textboxes and 
>> dataadapter
>> with commandbuilder):
>>
>> private void btnF9_Click(object sender, System.EventArgs e)
>> {
>>    try
>>    {
>>     //ConnBolle.Close();
>>     ConnBolle.Open();
>> 
>> DSBolle.Tables[0].Rows[this.BindingContext[DSBolle].Position].EndEdit();
>>     DABolle.Update(DSBolle.Tables[0]);
>>     ConnBolle.Close();
>>    }
>>    catch (DBConcurrencyException exc)
>>    {
>>     MessageBox.Show(exc.Message);
>>     ConnBolle.Close();
>>    }
>> }
>>
>>