c# - How to get 10 last rows inserted in gridview -


i want take 10 last rows inserted gridview sql server , show them in page. query:

select cause.cause_name        ,city.city_name        ,injuryscenario.injuryscenario_id        ,injuryscenario.injuryscenario_name        ,injuryscenario.injuryday        ,injuryscenario.injurymonth        ,injuryscenario.injuryyear        ,place.place_name     injuryscenario     inner join cause         on injuryscenario.cause_id = cause.cause_id     inner join placedet         on injuryscenario.injuryscenario_id = placedet.injuryscenario_id     inner join city         on placedet.city_id = city.city_id     inner join place         on injuryscenario.place_id = place.place_id)

and code in aspx:

 <asp:gridview id="gridview1" runat="server" autogeneratecolumns="false" datakeynames="injuryscenario_id" datasourceid="sqldatasource30" showheaderwhenempty="true">      <columns>          <asp:boundfield datafield="injuryscenario_id" headertext="injuryscenario_id" readonly="true" sortexpression="injuryscenario_id"  />          <asp:boundfield datafield="injuryscenario_name" headertext="injuryscenario_name" sortexpression="injuryscenario_name" />          <asp:boundfield datafield="cause_name" headertext="cause_name" sortexpression="cause_name" />          <asp:boundfield datafield="city_name" headertext="city_name" sortexpression="city_name" />          <asp:boundfield datafield="place_name" headertext="place_name" sortexpression="place_name" />          <asp:boundfield datafield="injuryday" headertext="injuryday" sortexpression="injuryday" visible="false"/>          <asp:boundfield datafield="injurymonth" headertext="injurymonth" sortexpression="injurymonth" visible="false"/>          <asp:boundfield datafield="injuryyear" headertext="injuryyear" sortexpression="injuryyear" visible="false"/>          <asp:templatefield headertext="date">                       <itemtemplate>          <asp:label runat="server"><%#(int)eval("injuryday")+"/"+ eval("injurymonth")+"/"+ eval("injuryyear") %></asp:label>       </itemtemplate>       </asp:templatefield>       </columns>     </asp:gridview>

here insert code:

dbmanager db = new dbmanager(); db.insert("injuryscenario", "injuryscenario_id,"+"cause_id," + "causetype_id," +  "causechar_id," + "place_id," + "placetype_id," + "injuryyear," + "injurymonth," +  "injuryday," + "injurydate_id," + "injuryinschool," + "injurydesc," + "almostinjury,"  + "injurycomments," + "productinjury","'"+ num_id + "'" + cause_namedd.selectedvalue +  "','" + causetypedd.datavaluefield + "','" + causechardd.selectedvalue + "','" +  placedd.selectedvalue + "','" + placetypedd.selectedvalue + "','" +  yeardd.selectedvalue + "','" + monthdd.selectedvalue + "','" + daydd.selectedvalue +  "','" + injurydatedd.selectedvalue + "','" + injuryinschoolcbl.selectedvalue + "','" +  injurydesctb.text + "','" + almostinjurytb.text + "','" + injurycommenttb.text + "','"  + productinjurycbl.text + "'");

we need see insert statement , know how uniquely identifiying each case help. things this, have unique id each new case auto-increment. id used enfore referential integrity across tables.

then retireve last ten cases create statement like

select ... from... id in ( select case_ids.id case_ids order case_ids.id desc rownum < 11 )

hope helps.


Comments

Post a Comment

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

i using signpost oauth access data magento server. have read various tutorials on same , reach point open browser user can enter credentials. however, per requirement have automate part. hence, user should not browser page. have set-up done on server side ( magento ), hit url , returned call page. same through program in android. i have tried below, consumer = new commonshttpoauthconsumer(key, secret); provider = new commonshttpoauthprovider(oauth_init_url,access_token_url, authorize_url); try { provider.retrieverequesttoken(consumer, oauth.out_of_band); log.d("tokens" , consumer.gettoken() + " -- " + consumer.gettokensecret()); } and request tokens. dont know how bypass next step. tried directly accessing accesstoken (stupid of me) provider.retrieveaccesstoken(consumer, "mycallback://callback"); no luck, ends in oauth.signpost.exception.oauthnotauthorizedexception: authorization failed (server replied 401). ...
Read more

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

getting error org.mockito.exceptions.misusing.invaliduseofmatchersexception: invalid use of argument matchers! 1 matchers expected, 2 recorded. exception may occur if matchers combined raw values: //incorrect: somemethod(anyobject(), "raw string"); when using matchers, arguments have provided matchers. example: //correct: somemethod(anyobject(), eq("string matcher")); at when( getprogramservice .callservice(any(getprogramtype.class))) .thenreturn(jaxbresponse); please explain error , possible resolution the code posted looks fine; don't see problem it. code before or above causing exception. key here: invalid use of argument matchers! 1 matchers expected, 2 recorded. any , used above, doesn't return "special kind of null" or "special kind of getprogramtype"; don't exist. instead, returns null , side effect puts matcher on stack. whe...
Read more

google shop client API returns 400 bad request error while adding an item -

i'm working on solution add items in google shopping market java application. following tutorial real mess because of missing classes of laste release, after setting 1.5-beta maven managed make base example typecheck correctly classes. still can make simple task of adding 1 item. instead of posting whole code i'm posting part creates product feed. private product createproduct(string id) { product product = new product(); product.title = "red wool sweater"; product.content = new content( "text", "comfortable , soft, sweater keep warm on " + "cold winter nights. red , blue stripes."); product.appcontrol = new appcontrol(); product.appcontrol.addrequireddestination("productads"); product.externalid = id; product.lang = "it"; product.country = "it"; product.condition = "nuovo"; product.price = new price("eu...
Read more