[RESOLVED] Gridview update query notworking when text field changed to yes/no in accessdatabase

i am facing one more problem in the same page when i was using my remark field as text this code  was working but when i changed the field to yes/no then this field update query is not working

                    ConnectionString="<%$ ConnectionStrings:baijuepConnectionString %>"
                    
                    SelectCommand="SELECT * FROM [tasks]"
                    DeleteCommand="delete tasks where (id = @id)"
                    
                    UpdateCommand="update tasks set Appt=@Appt,Task=@Task,Actionby=@Actionby,Complete=@Complete,Remark=@Remark where id=@id"
                    ProviderName="<%$ ConnectionStrings:baijuepConnectionString.ProviderName %>">
                    
                    
                    
                        
                    
                    
                        
                        
                        
                        
                        
                    
                

hi baiju,

i think you are having data-type miss-match issue, for details plz follow the link below,

http://msdn.microsoft.com/en-us/library/z72eefad(v=vs.100).aspx

thanks ..

Use bit datatype for your field. Set parameter type to boolean.