vb.net - How can I join data like this in SQL Server, then display in my app? -


i trying figure out how query 2 columns table , join results records different table , display these items in gridview using visual studio (express 2013 web).

additional explanation:

i have several projects in project_table each have unique project_id. project_id project_table foreign key project_codes_table. each project_code has unique project_code_id. each project can have several different project_codes associated it. results in gridview should similar 

| project id | projcode1 | projcode2 | projcode3 |

but, if project_id found in project_codes table.

i assuming can each project_code in own query getting value if project_code_id matches value ... each query tied project_table display values in row. have pretty idea how in microsoft access have little clue how attempt using sql or visual studio.

use linq sql, , set datagridview.datasource = query result

  1. right click on project in solution explorer, , click add new item... select linq sql classes.
  2. from server explorer, either use existing data connection or right click , add new data connection. connect sql database.
  3. navigate through data connection until see tables want query from. drag each table included in query data classses pane.

in code want populate datatable, put similar code

using dc new dataclasses1     dim res = pt in dc.project_table               join pc in dc.project_codes on pc.id equals pt.project_code_id               select new {                   .projectid = pc.id,                   .projectcode1 = pc.projcode1                   } ' etc.     datagridview1.datasource = res end using

Comments

Post a Comment

Popular posts from this blog

javascript - RequestAnimationFrame not working when exiting fullscreen switching space on Safari -

request animation frame stops working when exiting fullscreen clicking on original space's safari window. fine if fullscreen mode canceled escape key or calling cancelfullscreen(). steps reproduce: open https://dl.dropboxusercontent.com/u/769042/prezi/safari-fullscreen.html click "draw raf", kittie appears click "fullscreen", go fullscreen click "draw raf", kittie appears go space original safari was, showing "click exit fullscreen mode", click anywhere, out fullscreen click "draw raf", nothing happens what handling click calling: window.requestanimationframe(draw); which draws on canvas context: function draw() { ctx.drawimage(img, math.random()*500|0, math.random()*400|0, 100, 100); } i checked .hidden , .visibilitystate, updated correctly. tested on osx 10.9.3, safari 7.0.4 (9537.76.4). has workaround/solution other switching old settimeout? this sounds webkit bug 88940 : using reque
Read more

Python ctypes access violation with const pointer arguments -

i have api i'm trying wrap in python (2.7.6 on win7) code using ctypes. here's api: client_dllfunc bool clientapi search_exporttoclipcopy(clienthsearch handle, int channel, lpctstr filename, const time_t& from, const time_t& to, const bool* cameras, int length, bool usepassword, lpctstr password, bool includetextin = false, bool excludeplayer = false); the issue i'm having cameras argument; , i've had issue other const pointer arguments well. here's how i'm wrapping api: def search_exporttoclipcopy(self, hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, password, includetextin=true, excludeplayer=false): exporttoclipcopy = self.sdkdll.search_exporttoclipcopy exporttoclipcopy.argtypes = [c_int, c_int, c_wchar_p, c_long, c_long, pointer(c_bool), c_int, c_bool, c_wchar_p, c_bool, c_bool] exporttoclipcopy.restype = c_bool exporttoclipcopy(hsearch, csearch, filename, tfrom, tto, cameras, length, usepassword, pass
Read more