.net - refresh data with sqldataadapter.fill - not seeing new data -

-

i have timer runs in background keep data updated datagridview object. timer calling sqldatadapter.fill fill local scoped dataset.

if go on sql server , delete row table call fill dataset not reflect change database.

if update value of non primary key field @ database , timer runs changes picked , shown in datagridview.

how need set sqldataadapter find when rows added or deleted other backend process?

this in form_load

if ds nothing         ds = new dataset()     end if     try         sqldataadapter = new sqlclient.sqldataadapter(selectquery, parentconnectionstring)         sqldataadapter.missingschemaaction = missingschemaaction.addwithkey         sqlcommandbuilder = new sqlclient.sqlcommandbuilder(sqldataadapter)         sqldataadapter.fill(ds)         mydata = ds.tables(0).defaultview     catch ex exception         exceptionhandler(ex)     end try      if mydata.table.rows.count > 0         bindingsource.datasource = mydata         dgvsystemweightconfig.datasource = bindingsource         updatelastupdatetime()     end if

and refresh routine

 public sub refreshdata()     disableupdatetimer()     try         if dgvsystemweightconfig.iscurrentcellineditmode             debug.writeline("tried refresh system weight data user had cell in edit mode")         else             debug.writeline("system weight - refreshing data")              sqldataadapter.fill(ds, mydata.table.tablename)             dgvsystemweightconfig.focus()             updatelastupdatetime()         end if     catch ex exception         exceptionhandler(ex)             enableupdatetimer()     end try end sub

don't assume sqldataadapter not have correct records. apparently datatable implements inotifypropertychanged not implement inotifycollectionchanged. bind observablecollection.

debug , count on ds.
bet source correct , ui control not picking changes.

for ui pick inserts , deletes need have source implements inotifycollectionchanged.

observablecollection implements inotifycollectionchanged.

datatable lot of stuff need replace.
need class or struct hold rows , need define columns.
autogeneratecolumns works datatable.


Comments

Post a Comment

Popular posts from this blog

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

-
i read alot other solution still confused should mine... #include <opencv2/objdetect/objdetect.hpp> #include <opencv2/highgui/highgui.hpp> #include <opencv2/imgproc/imgproc.hpp> #include <iostream> #include <stdio.h> using namespace std; using namespace cv; int main(int argc, const char** argv) { //create cascade classifier object used face detection cascadeclassifier face_cascade; //use haarcascade_frontalface_alt.xml library face_cascade.load("haarcascade_frontalface_alt.xml"); //setup video capture device , link first capture device videocapture capturedevice; capturedevice.open(0); //setup image files used in capture process mat captureframe; mat grayscaleframe; //create window present results namedwindow("outputcapture", 1); //create loop capture , find faces while (true) { //capture new image frame capturedevice >> captureframe; ...
Read more

The canvas has been tainted by cross-origin data in chrome only -

-
uncaught securityerror: failed execute 'getimagedata' on 'canvasrenderingcontext2d': canvas has been tainted cross-origin data i getting above error in chrome. code(following) works fine in mozilla. have not corss domain issue. why above error in chrome? var wheel_canvas, wheel_context, can_w, can_h, wheel_grd; var large_radius = 160; var small_radius = 120; var wheel_canvas = document.getelementbyid('wheel_canvas'); var wheel_context = wheel_canvas.getcontext('2d'); var can_w = $(wheel_canvas).width(); var can_h = $(wheel_canvas).height(); var centerx = can_w / 2, centery = can_h / 2; var wheel_grd = null; test('#ff0000'); function test(hex) { $('#clrpicker').css({'left': 210, 'top': 210 }); inverted = hexbw(hex); $('#color_val_show').val(hex); current_color_hex_val_selected = hex; $('#color_val_show').css({'color':inverted,'background':hex}); fillgradient...
Read more