how to binding gridview with data from two different tables C# -

-

how can binding gridview data 2 different tables? have 3 tables: players, playerteam , teams. gridview has next data: playerid, name, surname, ... table players, , teamid, teamname... table teams. table playerteam marge tables players , teams via ids. i'am using tableadapter solve problem.

when want edit row in gridview, make changes in form (change data in textbox) , select team dropdownlist, can't save changes. 

using system; using system.collections.generic; using system.linq; using system.web; using system.web.ui; using system.web.ui.webcontrols;  namespace rukomet {     public partial class igracui : system.web.ui.page     {         dsigrac.tbligracrow igrac;         dsklub.tblklubrow klub;           protected void page_load(object sender, eventargs e)         {             if (this.ispostback)                 return;             this.ucitajklub();             this.dohvatiigraca();             this.prikaziigracevepodatke();          }          private void pokupipodatkesforme()         {             this.igrac.maticnibroj = this.txtmaticnibroj.text;             this.igrac.ime = this.txtime.text;             this.igrac.prezime = this.txtprezime.text;             this.igrac.brojdresa = this.txtbrojdresa.text;             this.igrac.pogoci = convert.toint32(this.txtpogoci.text);             this.igrac.opomene = convert.toint32(this.txtopomene.text);             this.igrac.dvijeminute = convert.toint32(this.txtdvijeminute.text);             this.igrac.diskvalifikacija = convert.toint32(this.txtdiskvalifikacija.text);              this.igrac.lijecnicki = convert.todatetime(this.txtlijecnicki.text);              this.klub.klubid = convert.toint32(this.ddlklubovi.selectedvalue);          }          private void prikaziigracevepodatke()         {             if (igrac.igracid == -1)                 return;              this.txtmaticnibroj.text = igrac.maticnibroj;             this.txtime.text = igrac.ime;             this.txtprezime.text = igrac.prezime;             this.txtbrojdresa.text = igrac.brojdresa;             this.txtpogoci.text = igrac.pogoci.tostring();             this.txtopomene.text = igrac.opomene.tostring();             this.txtdvijeminute.text = igrac.dvijeminute.tostring();             this.txtdiskvalifikacija.text = igrac.diskvalifikacija.tostring();              this.txtlijecnicki.text = igrac.lijecnicki.toshortdatestring();               if (this.viewstate["selected"] != null)             {                 ddlklubovi.selectedvalue = convert.tostring(this.viewstate["selected"]);             }          }          private void dohvatiigraca()         {             dsigrac.tbligracdatatable tbligrac = new dsigrac.tbligracdatatable();              if (request.params["igracid"] == null)             {                 this.igrac = tbligrac.newtbligracrow();                 this.igrac.igracid = -1;             }             else             {                 dsigractableadapters.tbligractableadapter adapterigrac = new dsigractableadapters.tbligractableadapter();                  int id = convert.toint32(this.request.params["igracid"]);                  adapterigrac.fillbyigracid(tbligrac, id);                  this.igrac = (dsigrac.tbligracrow)tbligrac.rows[0];             }         }           void ucitajklub()         {             dsigrac.tblklubdatatable klub = new dsigrac.tblklubdatatable();              dsigractableadapters.tblklubtableadapter adapterklub = new dsigractableadapters.tblklubtableadapter();              adapterklub.fill(klub);             this.ddlklubovi.datatextfield = "imekluba";             this.ddlklubovi.datavaluefield = "klubid";              this.ddlklubovi.datasource = klub;             this.ddlklubovi.databind();         }          protected void btnodustani_click(object sender, eventargs e)         {             this.response.redirect("glavnaforma.aspx");         }           protected void btnspremi_click(object sender, eventargs e)         {             this.dohvatiigraca();             this.pokupipodatkesforme();              dsigractableadapters.tbligractableadapter adapterigrac = new dsigractableadapters.tbligractableadapter();               if (this.igrac.igracid == -1)             {                 adapterigrac.insert(                     this.igrac.maticnibroj,                     this.igrac.ime,                     this.igrac.prezime,                     this.igrac.brojdresa,                     this.igrac.pogoci,                     this.igrac.opomene,                     this.igrac.dvijeminute,                     this.igrac.diskvalifikacija,                     this.igrac.lijecnicki);                     this.klub.klubid);              }             else             {                 adapterigrac.update(this.igrac);             }             this.response.redirect("glavnaforma.aspx");         }      } }

you should post code better answer think understand asking. accomplish use c# webgrid in html queries 3 tables this:

@{ var db=database.open("contracts"); var selectcommand = "select requests.*, contractors.agency+'/'"+                     "+contractors.firstname+' '+contractors.lastname contractor,programs.division "+                     "from requests, contractors, programs "+                     "where contractnumber not null "+                     "and contractnumber <> '' "+                     "and scannedcontractdate not null "+                     "and amendmentcount = 0 "+                     "and contractors.id = requests.contractorid "+                     "and requests.programid = programs.id ";  } <h2>page title</h2> <div>@grid.gethtml( tablestyle: "grid",             headerstyle: "head",             alternatingrowstyle: "alt",             columns: grid.columns(             grid.column("division"),             grid.column("contractnumber", header:"contract number"),             grid.column("contractor"),             grid.column("startdate", header:"start date", cansort: true),             grid.column("enddate", header:"end date", cansort: true),             grid.column("amount"),             grid.column("scannedcontractdate", header:"contract date", cansort: true),             grid.column("maxamend", header:"amendments")            ) )          </div>

i hope answers question!


Comments

Post a Comment

Popular posts from this blog

java - Jmockit String final length method mocking Issue -

-
using jmockit 1.2 jar, trying mock string's length method getting unexpected invocation exception: failed: test java.lang.illegalstateexception: missing invocation mocked type @ point; please make sure such invocations appear after declaration of suitable mock field or parameter @ stringdemo.testa$1.<init>(testa.java:17) @ stringdemo.testa.test(testa.java:13) i using testng: @test public void test() throws exception { new expectations() { @mocked("length") string astring; { astring.length(); result = 2; } }; system.out.println(a.showa("test")); } } actual class a: public class { public static int showa(string str){ int a= str.length(); return a; } } this wrong way of recording expected results. shouldn't mock , record string's length() method, record showa() instead. here solution @suppresswarnings("unused...
Read more

What is the difference between data design and data model(ERD) -

-
i have google question , find answer in day. know, data design many many table have list column,and mark pk , fk. why er-diagram have find this? data design process of designing database. main output of data design detailed logical data model of database. some people data design includes of needed logical , physical design choices , physical storage parameters needed generate design in data definition language. technically, database analysis, database analysts (dbas) trained do. while person can both data design , database analysis, these 2 different tasks. data design models data. database analysis takes model , applies 1 or more database engines (relational, hierarchical, nosql). a logical data model 1 of main outputs of data design. data model represented entity relationship diagram, or er diagram.
Read more

ios - Can NSManagedObject conform to NSCoding -

-
i need transfer single object across device. right converting nsmanagedobject dictionary , archiving , sending nsdata. upon receiving unarchiving it. transfer nsmanagedobject archiving , unarchiving instead of creating intermediate data object. @interface test : nsmanagedobject<nscoding> @property (nonatomic, retain) nsstring * title; @end @implementation test @dynamic title; - (id)initwithcoder:(nscoder *)coder { self = [super init]; if (self) { self.title = [coder decodeobjectforkey:@"title"]; //<crash } return self; } - (void)encodewithcoder:(nscoder *)coder { [coder encodeobject:self.title forkey:@"title"]; } @end nsdata *archivedobjects = [nskeyedarchiver archiveddatawithrootobject:testobj]; nsdata *objectsdata = archivedobjects; if ([objectsdata length] > 0) { nsarray *objects = [nskeyedunarchiver unarchiveobjectwithdata:objectsdata]; } the problem above code is. crashes @ self.title in initwithcoder sa...
Read more