Reply to thread

Message

<blockquote data-quote="Scrounger" data-source="post: 808194" data-attributes="member: 87610">Hi,i have started to develop my first MP Gui Plugin (vb.net). You can find the Source Code here:<a href="http://code.google.com/p/clickfinder-programguide/source/browse/Clickfinder%20ProgramGuide/Clickfinder%20ProgramGuide.vb" target="_blank">Clickfinder ProgramGuide Plugin for MediaPortal </a>Short plugin describtion:The plugin is a ProgramGuide that shows you what broadcast on our televisions at Now, PrimeTime, LateTime and so on. The Data based /sorted on / by the RatingData of the TV Movie Clickfinder Database (my imported EPG Data and the reason why the Plugin is only in German). Idea for this plugin was the smartphone App &quot;TV Spielfilm&quot;.The last few days i've learned a lot by reading the MP Source Code. Now i started to replace my &quot;manuell Database Access&quot; with the TVDatabase Class.My Problem is that i need the &quot;idChannel&quot; from the tvmoviemapping table by the key &quot;stationName&quot;, but i don't find the right Syntax.At the moment i use a manuell Connection with a sqlquery:[code]ReadTvServerDB(&quot;Select * from tvmoviemapping Inner Join channel on tvmoviemapping.idChannel = channel.idChannel where stationName = '&quot; &amp; _MappingName &amp; &quot;'&quot;) [/code]But that must also work with the TVMovieMapping Class, something like that:[code]in vb.net:tvDatabase.tvMovieMapping.RetrieveList(???????)for i = 0 to tvDatabase.tvMovieMapping.count -1idchannel = tvDatabase.tvMovieMapping.idChannelnextin c#:tvDatabase.tvMovieMapping.RetrieveList(????);for (i = 0; i &lt;= tvDatabase.tvMovieMapping.count - 1; i++) {&nbsp; &nbsp; idchannel = tvDatabase.tvMovieMapping.idChannel;}[/code]Can you give me code snippets in c# or vb.net, please.Hope you understand my problem, i know my english is not that well <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink&nbsp; &nbsp; ;)" loading="lazy" data-shortname=";)" /></blockquote>

[QUOTE="Scrounger, post: 808194, member: 87610"] Hi, i have started to develop my first MP Gui Plugin (vb.net). You can find the Source Code here: [URL="http://code.google.com/p/clickfinder-programguide/source/browse/Clickfinder%20ProgramGuide/Clickfinder%20ProgramGuide.vb"]Clickfinder ProgramGuide Plugin for MediaPortal [/URL] [U]Short plugin describtion:[/U] The plugin is a ProgramGuide that shows you what broadcast on our televisions at Now, PrimeTime, LateTime and so on. The Data based /sorted on / by the RatingData of the TV Movie Clickfinder Database (my imported EPG Data and the reason why the Plugin is only in German). Idea for this plugin was the smartphone App "TV Spielfilm". The last few days i've learned a lot by reading the MP Source Code. Now i started to replace my "manuell Database Access" with the TVDatabase Class. My Problem is that i need the "idChannel" from the tvmoviemapping table by the key "stationName", but i don't find the right Syntax. At the moment i use a manuell Connection with a sqlquery: [code]ReadTvServerDB("Select * from tvmoviemapping Inner Join channel on tvmoviemapping.idChannel = channel.idChannel where stationName = '" & _MappingName & "'") [/code] But that must also work with the TVMovieMapping Class, something like that: [code] in vb.net: tvDatabase.tvMovieMapping.RetrieveList(???????) for i = 0 to tvDatabase.tvMovieMapping.count -1 idchannel = tvDatabase.tvMovieMapping.idChannel next in c#: tvDatabase.tvMovieMapping.RetrieveList(????); for (i = 0; i <= tvDatabase.tvMovieMapping.count - 1; i++) { idchannel = tvDatabase.tvMovieMapping.idChannel; } [/code] Can you give me code snippets in c# or vb.net, please. Hope you understand my problem, i know my english is not that well ;) [/QUOTE]

Verification