<?xml version="1.0" encoding="utf-8"?>

<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/">
	<channel>
		<title>Форум программистов и сисадминов Киберфорум - Блоги - Jlovenpk1</title>
		<link>https://www.cyberforum.ru/blogs/316594/</link>
		<description>КиберФорум - форум программистов, системных администраторов, администраторов баз данных, компьютерный форум, форум по электронике и бытовой технике, обсуждение софта. Бесплатная помощь в решении задач по программированию и наукам, решение проблем с компьютером, операционными системам</description>
		<language>ru</language>
		<lastBuildDate>Sun, 13 Sep 2026 11:46:37 GMT</lastBuildDate>
		<generator>vBulletin</generator>
		<ttl>60</ttl>
		<image>
			<url>https://www.cyberforum.ru//cyberstatic.net/images/misc/rss.jpg</url>
			<title>Форум программистов и сисадминов Киберфорум - Блоги - Jlovenpk1</title>
			<link>https://www.cyberforum.ru/blogs/316594/</link>
		</image>
		<item>
			<title><![CDATA[Пустота в шапке сайт или &#65279;]]></title>
			<link>https://www.cyberforum.ru/blogs/316594/5935.html</link>
			<pubDate>Tue, 23 Jul 2019 05:53:48 GMT</pubDate>
			<description>Редко встречаюсь с этой проблемой и забываю, как её решать. 
Памятка для меня: 
Ссылка...</description>
			<content:encoded><![CDATA[<div>Редко встречаюсь с этой проблемой и забываю, как её решать.<br />
Памятка для меня:<br />
<a rel="nofollow noopener noreferrer" href="https://simplamarket.com/blog/bom-ili-tainstvennyj-simvol-65279" target="_blank" title="https://simplamarket.com/blog/bom-ili-tainstvennyj-simvol-65279">Ссылка</a><br />
<br />
Или если в кратце - просто пересохранить документ в UTF8 в том же NotePad++</div>

]]></content:encoded>
			<dc:creator>Jlovenpk1</dc:creator>
			<guid isPermaLink="true">https://www.cyberforum.ru/blogs/316594/5935.html</guid>
		</item>
		<item>
			<title>OpenServer отправка почты SMTP</title>
			<link>https://www.cyberforum.ru/blogs/316594/5716.html</link>
			<pubDate>Fri, 01 Mar 2019 05:54:16 GMT</pubDate>
			<description>Сразу к делу. 
 
Это настройки....</description>
			<content:encoded><![CDATA[<div>Сразу к делу.<br />
<br />
Это настройки.<br />
<img src="https://www.cyberforum.ru/blog_attachment.php?attachmentid=5240&amp;st= c=1&amp;d=1551419531" border="0" alt="" style="max-width: 800px; margin: 5px 0px 5px 0px;" /><br />
<br />
Посмотреть данные у мэйлов тут:<br />
<a rel="nofollow noopener noreferrer" href="https://help.mail.ru/mail-help/mailer/popsmtp" target="_blank" title="https://help.mail.ru/mail-help/mailer/popsmtp">https://help.mail.ru/mail-help/mailer/popsmtp</a><br />
<br />
После сохранения, перезагружаем Open Server.<br />
<br />
И используем для теста такой кусок кода:<br />
<br />
<div class="codeblock"><table class="phphtml"><thead><tr><td colspan="2" id="760222320"  class="head">PHP/HTML</td></tr></thead><tbody><tr class="li1"><td><div id="760222320" style="height: 46px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
</pre></td><td class="de1"><pre class="de1"><span class="kw0">mail</span><span class="br0">&#40;</span><span class="st0">'Jlovenpk1@mail.ru'</span><span class="sy0">,</span> <span class="st0">'fdsfdsfds'</span><span class="sy0">,</span> <span class="st0">'Текст письма'</span><span class="sy0">,</span> <span class="st0">'From: Jlovenpk1@mail.ru'</span><span class="br0">&#41;</span><span class="sy0">;</span></pre></td></tr></table></div></td></tr></tbody></table></div>Письмо должно придти.<br />
<br />
Сообщение больше для себя, как памятка.</div>


<!-- attachments -->
	<div style="margin-top:10px">

		
			<fieldset class="fieldset">
				<legend>Миниатюры</legend>
				<div style="padding:3px">
				
	<a href="https://www.cyberforum.ru/blog_attachment.php?attachmentid=5240&amp;d=1551419531" target="attachment" rel="Lightbox" id="attachment5240"><img loading="lazy" decoding="async" class="thumbnail" src="https://www.cyberforum.ru/blog_attachment.php?attachmentid=5240&amp;stc=1&amp;thumb=1&amp;d=1551419531" border="0" alt="Нажмите на изображение для увеличения
Название: Screenshot_1.png
Просмотров: 3280
Размер:	46.9 Кб
ID:	5240" /></a>
	&nbsp;
	

				</div>
			</fieldset>
		
		
		
		

	</div>
<!-- / attachments -->
]]></content:encoded>
			<dc:creator>Jlovenpk1</dc:creator>
			<guid isPermaLink="true">https://www.cyberforum.ru/blogs/316594/5716.html</guid>
		</item>
		<item>
			<title>GMap получаем от Yandex координаты и выводим на карту</title>
			<link>https://www.cyberforum.ru/blogs/316594/5646.html</link>
			<pubDate>Wed, 30 Jan 2019 06:16:30 GMT</pubDate>
			<description>Поделюсь куском кода из своего проекта, который вскоре выложу тут и возможно на хабре, т.к я...</description>
			<content:encoded><![CDATA[<div>Поделюсь куском кода из своего проекта, который вскоре выложу тут и возможно на хабре, т.к я стеснительный человек и оцениваю свои навыки всегда на уровне junior и middle, мне не всегда удается сохранить тот объем текста и кода, который я уже вот-вот выложу, а писать с нуля, желание пропадает. <br />
Хотя может я слишком самокритичен?<br />

<table width="95%"  class="bbcode_maincontainer"><tr><td>
	<div class="bbcode_container">
	  <div class="bbcode_quote">
	    <div class="btbtbt">
		<div class="quote_container">
	      	<div class="bbcode_quote_container"></div>
	       	<div class="bbcode_postedby">
	         	
	        </div>
	        <div class="message">В чем разница между делегатом и событием?</div>
	      </div>
			</div> 
		</div>
	</div>
</td></tr></table>И так, GMap на самом деле полезная вещь, но у нее настолько узкое направление, что просто печально, но при должном желании и напильнике можно делать интересные вещи, но если не жалко времени и сил. <br />

<table width="95%"  class="bbcode_maincontainer"><tr><td>
	<div class="bbcode_container">
	  <div class="bbcode_quote">
	    <div class="btbtbt">
		<div class="quote_container">
	      	<div class="bbcode_quote_container"></div>
	       	<div class="bbcode_postedby">
	         	
	        </div>
	        <div class="message">Время хорошего программиста стоит хороших денег.</div>
	      </div>
			</div> 
		</div>
	</div>
</td></tr></table>И так, у нас имеется список адресов. В моем случае адреса лежат в базе данных, но реализацию мы будем выполнять на тестовых настройках для проверки отправляемых данных и получаемого результата.<br />
<br />
Для одиночного запроса на один адрес получаем такой код:<br />
<br />
<div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="373924831"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="373924831" style="height: 350px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
</pre></td><td class="de1"><pre class="de1"><span class="kw4">class</span> YandexAction
&nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; HttpWebResponse response<span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; StreamReader sr_<span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; XDocument doc<span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; HttpWebRequest request<span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">double</span> x <span class="sy0">=</span> 0<span class="sy0">.</span>0f<span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">double</span> z <span class="sy0">=</span> 0<span class="sy0">.</span>0f<span class="sy0">;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw4">void</span> YandexRequest<span class="br0">&#40;</span><span class="kw4">string</span> adres, <span class="kw1">out</span> <span class="kw4">double</span> lng, <span class="kw1">out</span> <span class="kw4">double</span> lngl<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lng <span class="sy0">=</span> 0<span class="sy0">.</span>0f<span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lngl <span class="sy0">=</span> 0<span class="sy0">.</span>0f<span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; request <span class="sy0">=</span> <span class="br0">&#40;</span>HttpWebRequest<span class="br0">&#41;</span>HttpWebRequest<span class="sy0">.</span><span class="me1">Create</span><span class="br0">&#40;</span><span class="st0">&quot;https://geocode-maps.yandex.ru/1.x/?geocode= &quot;</span> <span class="sy0">+</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class="st0">&quot;Россия, Астрахань,&quot;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class="sy0">+</span> adres <span class="sy0">+</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="st0">&quot;kind=house&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp;
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; response <span class="sy0">=</span> <span class="br0">&#40;</span>HttpWebResponse<span class="br0">&#41;</span>request<span class="sy0">.</span><span class="me1">GetResponse</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sr_ <span class="sy0">=</span> <span class="kw3">new</span> StreamReader<span class="br0">&#40;</span>response<span class="sy0">.</span><span class="me1">GetResponseStream</span><span class="br0">&#40;</span><span class="br0">&#41;</span>, Encoding<span class="sy0">.</span><span class="me1">GetEncoding</span><span class="br0">&#40;</span><span class="st0">&quot;utf-8&quot;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; doc <span class="sy0">=</span> XDocument<span class="sy0">.</span><span class="me1">Parse</span><span class="br0">&#40;</span>sr_<span class="sy0">.</span><span class="me1">ReadToEnd</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>doc <span class="sy0">==</span> <span class="kw1">null</span> <span class="sy0">||</span> doc<span class="sy0">.</span><span class="me1">Root</span> <span class="sy0">==</span> <span class="kw1">null</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">throw</span> <span class="kw3">new</span> ApplicationException<span class="br0">&#40;</span><span class="st0">&quot;LoL This Fucking shit, maybe Yandex Poslal nas nahui?&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IEnumerable<span class="sy0">&lt;</span>XElement<span class="sy0">&gt;</span> xElements <span class="sy0">=</span> doc<span class="sy0">.</span><span class="me1">Descendants</span><span class="br0">&#40;</span><span class="st0">&quot;{http://www.opengis.net/gml}pos&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">string</span><span class="br0">&#91;</span><span class="br0">&#93;</span> coord<span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">//var res = dt.Rows[i][0].ToString().Replace(&quot;,&quot;,&quot;&quot;).Replace(&quot; &quot;,&quot;&quot;).Replace(&quot;/&quot;,&quot;&quot;);</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">foreach</span> <span class="br0">&#40;</span>XElement xnode <span class="kw1">in</span> xElements<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; coord <span class="sy0">=</span> xnode<span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">Split</span><span class="br0">&#40;</span><span class="kw3">new</span> <span class="kw4">char</span><span class="br0">&#91;</span><span class="br0">&#93;</span> <span class="br0">&#123;</span> <span class="st0">' '</span> <span class="br0">&#125;</span>, StringSplitOptions<span class="sy0">.</span><span class="me1">RemoveEmptyEntries</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw5">System.<span class="me1">Threading</span></span><span class="sy0">.</span><span class="me1">Thread</span><span class="sy0">.</span><span class="me1">CurrentThread</span><span class="sy0">.</span><span class="me1">CurrentCulture</span> <span class="sy0">=</span> <span class="kw3">new</span> <span class="kw5">System.<span class="me1">Globalization</span></span><span class="sy0">.</span><span class="me1">CultureInfo</span><span class="br0">&#40;</span><span class="st0">&quot;en-US&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lng <span class="sy0">=</span> 0<span class="sy0">.</span>0f<span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lngl <span class="sy0">=</span> 0<span class="sy0">.</span>0f<span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lng <span class="sy0">=</span> <span class="kw4">double</span><span class="sy0">.</span><span class="me1">Parse</span><span class="br0">&#40;</span>coord<span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lngl <span class="sy0">=</span> <span class="kw4">double</span><span class="sy0">.</span><span class="me1">Parse</span><span class="br0">&#40;</span>coord<span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; <span class="br0">&#125;</span></pre></td></tr></table></div></td></tr></tbody></table></div>Вызывать мы будем вот так:<br />
<br />
<div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="886152576"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="886152576" style="height: 190px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
2
3
4
5
6
7
8
9
10
</pre></td><td class="de1"><pre class="de1"><span class="kw1">private</span> <span class="kw4">void</span> gMapControl1_KeyDown<span class="br0">&#40;</span><span class="kw4">object</span> sender, KeyEventArgs e<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">double</span><span class="br0">&#91;</span><span class="br0">&#93;</span> coord <span class="sy0">=</span> <span class="kw3">new</span> <span class="kw4">double</span><span class="br0">&#91;</span><span class="nu0">2</span><span class="br0">&#93;</span> <span class="br0">&#123;</span><span class="nu0">0</span>,<span class="nu0">0</span><span class="br0">&#125;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>e<span class="sy0">.</span><span class="me1">KeyCode</span> <span class="sy0">==</span> Keys<span class="sy0">.</span><span class="me1">Enter</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox<span class="sy0">.</span><span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;LoL&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Request <span class="sy0">=</span> <span class="kw3">new</span> YandexAction<span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Request<span class="sy0">.</span><span class="me1">YandexRequest</span><span class="br0">&#40;</span><span class="st0">&quot;Улица Вильнюсская дом 76а&quot;</span>, <span class="kw1">out</span> coord<span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span>, <span class="kw1">out</span> coord<span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox<span class="sy0">.</span><span class="me1">Show</span><span class="br0">&#40;</span>coord<span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span> <span class="sy0">+</span> <span class="st0">&quot; &quot;</span> <span class="sy0">+</span> coord<span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span></pre></td></tr></table></div></td></tr></tbody></table></div>И так, по нажатию на enter мы получаем координаты на тестовый адрес, выводим на карту. <br />
<br />
<div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="349847529"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="349847529" style="height: 286px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
</pre></td><td class="de1"><pre class="de1"><span class="kw4">double</span><span class="br0">&#91;</span><span class="br0">&#93;</span> coord <span class="sy0">=</span> <span class="kw3">new</span> <span class="kw4">double</span><span class="br0">&#91;</span><span class="nu0">2</span><span class="br0">&#93;</span> <span class="br0">&#123;</span><span class="nu0">0</span>,<span class="nu0">0</span><span class="br0">&#125;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>e<span class="sy0">.</span><span class="me1">KeyCode</span> <span class="sy0">==</span> Keys<span class="sy0">.</span><span class="me1">Enter</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox<span class="sy0">.</span><span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;LoL&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Request <span class="sy0">=</span> <span class="kw3">new</span> YandexAction<span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Request<span class="sy0">.</span><span class="me1">YandexRequest</span><span class="br0">&#40;</span><span class="st0">&quot;Улица Вильнюсская дом 76а&quot;</span>, <span class="kw1">out</span> coord<span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span>, <span class="kw1">out</span> coord<span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox<span class="sy0">.</span><span class="me1">Show</span><span class="br0">&#40;</span>coord<span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span> <span class="sy0">+</span> <span class="st0">&quot; &quot;</span> <span class="sy0">+</span> coord<span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; gMapControl1<span class="sy0">.</span><span class="me1">MarkersEnabled</span> <span class="sy0">=</span> <span class="kw1">true</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GMapOverlay markersOverlay <span class="sy0">=</span> <span class="kw3">new</span> GMapOverlay<span class="br0">&#40;</span><span class="st0">&quot;markers&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GMarkerGoogle marker <span class="sy0">=</span> <span class="kw3">new</span> GMarkerGoogle<span class="br0">&#40;</span><span class="kw3">new</span> PointLatLng<span class="br0">&#40;</span>coord<span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span>, coord<span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="br0">&#41;</span>,
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw3">new</span> Bitmap<span class="br0">&#40;</span>Application<span class="sy0">.</span><span class="me1">StartupPath</span> <span class="sy0">+</span> <span class="st0">&quot;//very_bad.png&quot;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; marker<span class="sy0">.</span><span class="me1">ToolTipMode</span> <span class="sy0">=</span> GMap<span class="sy0">.</span><span class="me1">NET</span><span class="sy0">.</span><span class="me1">WindowsForms</span><span class="sy0">.</span><span class="me1">MarkerTooltipMode</span><span class="sy0">.</span><span class="me1">OnMouseOver</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; marker<span class="sy0">.</span><span class="me1">ToolTipText</span> <span class="sy0">=</span> <span class="st0">&quot;наш дом&quot;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; markersOverlay<span class="sy0">.</span><span class="me1">Markers</span><span class="sy0">.</span><span class="kw1">Add</span><span class="br0">&#40;</span>marker<span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; gMapControl1<span class="sy0">.</span><span class="me1">Overlays</span><span class="sy0">.</span><span class="kw1">Add</span><span class="br0">&#40;</span>markersOverlay<span class="br0">&#41;</span><span class="sy0">;</span></pre></td></tr></table></div></td></tr></tbody></table></div><img src="https://www.cyberforum.ru/blog_attachment.php?attachmentid=5172&amp;st= c=1&amp;d=1548828928" border="0" alt="" style="max-width: 800px; margin: 5px 0px 5px 0px;" /></div>


<!-- attachments -->
	<div style="margin-top:10px">

		
			<fieldset class="fieldset">
				<legend>Миниатюры</legend>
				<div style="padding:3px">
				
	<a href="https://www.cyberforum.ru/blog_attachment.php?attachmentid=5172&amp;d=1548828928" target="attachment" rel="Lightbox" id="attachment5172"><img loading="lazy" decoding="async" class="thumbnail" src="https://www.cyberforum.ru/blog_attachment.php?attachmentid=5172&amp;stc=1&amp;thumb=1&amp;d=1548828928" border="0" alt="Нажмите на изображение для увеличения
Название: Screenshot_1.png
Просмотров: 1696
Размер:	51.3 Кб
ID:	5172" /></a>
	&nbsp;
	

				</div>
			</fieldset>
		
		
		
		

	</div>
<!-- / attachments -->
]]></content:encoded>
			<dc:creator>Jlovenpk1</dc:creator>
			<guid isPermaLink="true">https://www.cyberforum.ru/blogs/316594/5646.html</guid>
		</item>
		<item>
			<title>Сравнить два DataGridView C#</title>
			<link>https://www.cyberforum.ru/blogs/316594/5645.html</link>
			<pubDate>Tue, 29 Jan 2019 07:59:25 GMT</pubDate>
			<description>---Цитата--- 
Зачем вы мучаетесь с контролом? Не проще сделать через словарь/лист/массив 
---Конец...</description>
			<content:encoded><![CDATA[<div>
<table width="95%"  class="bbcode_maincontainer"><tr><td>
	<div class="bbcode_container">
	  <div class="bbcode_quote">
	    <div class="btbtbt">
		<div class="quote_container">
	      	<div class="bbcode_quote_container"></div>
	       	<div class="bbcode_postedby">
	         	
	        </div>
	        <div class="message">Зачем вы мучаетесь с контролом? Не проще сделать через словарь/лист/массив</div>
	      </div>
			</div> 
		</div>
	</div>
</td></tr></table>Очень долго мучался с DataGridView, хотел сравнить их, удалить множественные дубликаты, а потом производить выгрузку в базу с проверкой данных.<br />
В общем говоря сделал, название топика обманчиво. <br />
Буду рад, если кто-то предложит вменяемый способ сравнения двух DataGridView C# с расчетом на то, что строк будет свыше 1000. <br />
<br />
Мое решение:<br />
<div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="94993917"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="94993917" style="height: 350px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
</pre></td><td class="de1"><pre class="de1">&nbsp;preLoad <span class="sy0">=</span> <span class="kw3">new</span> Load_Grid<span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; preLoad<span class="sy0">.</span><span class="me1">Connect</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co2">#region удаляем дубли из пришедшего экселя</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dictionary<span class="sy0">&lt;</span><span class="kw4">int</span>, <span class="kw4">string</span><span class="sy0">&gt;</span> mainData <span class="sy0">=</span> <span class="kw3">new</span> Dictionary<span class="sy0">&lt;</span><span class="kw4">int</span>, <span class="kw4">string</span><span class="sy0">&gt;</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dictionary<span class="sy0">&lt;</span><span class="kw4">int</span>, <span class="kw4">string</span><span class="sy0">&gt;</span> secondData <span class="sy0">=</span> <span class="kw3">new</span> Dictionary<span class="sy0">&lt;</span><span class="kw4">int</span>, <span class="kw4">string</span><span class="sy0">&gt;</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">for</span> <span class="br0">&#40;</span><span class="kw4">int</span> i <span class="sy0">=</span> <span class="nu0">0</span><span class="sy0">;</span> i <span class="sy0">&lt;</span> ViewGridActive<span class="sy0">.</span><span class="me1">Rows</span><span class="sy0">.</span><span class="me1">Count</span><span class="sy0">;</span> i<span class="sy0">++</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mainData<span class="sy0">.</span><span class="kw1">Add</span><span class="br0">&#40;</span>i, ViewGridActive<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; secondData<span class="sy0">.</span><span class="kw1">Add</span><span class="br0">&#40;</span>i, ViewGridActive<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">var</span> test <span class="sy0">=</span> mainData<span class="sy0">.</span><span class="me1">Values</span><span class="sy0">.</span><span class="me1">Union</span><span class="br0">&#40;</span>secondData<span class="sy0">.</span><span class="me1">Values</span><span class="br0">&#41;</span><span class="sy0">.</span><span class="me1">Distinct</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co2">#endregion</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; test<span class="sy0">.</span><span class="me1">ToArray</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">bool</span> LogicCheck <span class="sy0">=</span> <span class="kw1">false</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; List<span class="sy0">&lt;</span><span class="kw4">string</span><span class="sy0">&gt;</span> adresForInsert <span class="sy0">=</span> <span class="kw3">new</span> List<span class="sy0">&lt;</span><span class="kw4">string</span><span class="sy0">&gt;</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">for</span> <span class="br0">&#40;</span><span class="kw4">int</span> i <span class="sy0">=</span> <span class="nu0">0</span><span class="sy0">;</span> i <span class="sy0">&lt;</span> ViewGridActive<span class="sy0">.</span><span class="me1">Rows</span><span class="sy0">.</span><span class="me1">Count</span><span class="sy0">;</span> i<span class="sy0">++</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">for</span> <span class="br0">&#40;</span><span class="kw4">int</span> x <span class="sy0">=</span> <span class="nu0">0</span><span class="sy0">;</span> x <span class="sy0">&lt;</span> ViewGridBaza<span class="sy0">.</span><span class="me1">RowCount</span><span class="sy0">;</span> x<span class="sy0">++</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>ViewGridActive<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">Equals</span><span class="br0">&#40;</span><span class="br0">&#40;</span>ViewGridBaza<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>x<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co2">#region Мутим переменные для отправки</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">var</span> object_ <span class="sy0">=</span> <span class="kw4">int</span><span class="sy0">.</span><span class="me1">Parse</span><span class="br0">&#40;</span>ViewGridBaza<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>x<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">var</span> trouble <span class="sy0">=</span> ViewGridActive<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">var</span> type_trouble <span class="sy0">=</span> ViewGridActive<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">2</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">var</span> size <span class="sy0">=</span> <span class="kw4">int</span><span class="sy0">.</span><span class="me1">Parse</span><span class="br0">&#40;</span>ViewGridActive<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">3</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">var</span> dt <span class="sy0">=</span> preLoad<span class="sy0">.</span><span class="me1">ConvertTextToDateTime</span><span class="br0">&#40;</span>ViewGridActive<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">4</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co2">#endregion</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGridActive<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">DefaultCellStyle</span><span class="sy0">.</span><span class="me1">BackColor</span> <span class="sy0">=</span> Color<span class="sy0">.</span><span class="me1">Orange</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; preLoad<span class="sy0">.</span><span class="me1">InsertInformation</span><span class="br0">&#40;</span>object_, trouble, type_trouble, size, dt<span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co2">#region для теста преобразование даты</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">//var Test = preLoad.ConvertTextToDateTime(ViewGridActive.Rows[i].Cells[4].Value.ToString()); </span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">//MessageBox.Show(preLoad.ConvertTextToDateTime(ViewGridActive.Rows[i].Cells[4].Value.ToString()).ToString());</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">//MessageBox.Show(preLoad.ConvertDateTime(Test).ToString());</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co2">#endregion</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LogicCheck <span class="sy0">=</span> <span class="kw1">false</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">break</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">else</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span> LogicCheck <span class="sy0">=</span> <span class="kw1">true</span><span class="sy0">;</span> <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>LogicCheck <span class="sy0">==</span> <span class="kw1">true</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; adresForInsert<span class="sy0">.</span><span class="kw1">Add</span><span class="br0">&#40;</span>ViewGridActive<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGridBaza<span class="sy0">.</span><span class="me1">Rows</span><span class="sy0">.</span><span class="me1">Clear</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">foreach</span> <span class="br0">&#40;</span><span class="kw4">string</span> txest <span class="kw1">in</span> adresForInsert<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGridBaza<span class="sy0">.</span><span class="me1">Rows</span><span class="sy0">.</span><span class="kw1">Add</span><span class="br0">&#40;</span>txest<span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co2">#region Проверяем есть ли чо грузить</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>adresForInsert<span class="sy0">.</span><span class="me1">Count</span> <span class="sy0">&gt;</span> <span class="nu0">1</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DialogResult result <span class="sy0">=</span> MessageBox<span class="sy0">.</span><span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;Окно загрузки&quot;</span>, <span class="st0">&quot;Начать загрузку новых адресов?&quot;</span>, MessageBoxButtons<span class="sy0">.</span><span class="me1">YesNo</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>result <span class="sy0">==</span> DialogResult<span class="sy0">.</span><span class="me1">Yes</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">foreach</span> <span class="br0">&#40;</span><span class="kw4">string</span> txest <span class="kw1">in</span> adresForInsert<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; preLoad<span class="sy0">.</span><span class="me1">InsertAdres</span><span class="br0">&#40;</span>txest<span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">else</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox<span class="sy0">.</span><span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;Обновление базы адресов отменено&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span></pre></td></tr></table></div></td></tr></tbody></table></div></div>

]]></content:encoded>
			<dc:creator>Jlovenpk1</dc:creator>
			<guid isPermaLink="true">https://www.cyberforum.ru/blogs/316594/5645.html</guid>
		</item>
		<item>
			<title>MySQL C# Insert не добавляет данные</title>
			<link>https://www.cyberforum.ru/blogs/316594/5615.html</link>
			<pubDate>Thu, 10 Jan 2019 12:56:49 GMT</pubDate>
			<description><![CDATA[MySql C# Insert into не добавляет данные? 
sqlCommand = new MySqlCommand("INSERT INTO...]]></description>
			<content:encoded><![CDATA[<div>MySql C# Insert into не добавляет данные?<br />
<div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="76253955"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="76253955" style="height: 46px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
</pre></td><td class="de1"><pre class="de1">sqlCommand <span class="sy0">=</span> <span class="kw3">new</span> MySqlCommand<span class="br0">&#40;</span><span class="st0">&quot;INSERT INTO gissystem.object(Adres) VALUES(@adress);&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span></pre></td></tr></table></div></td></tr></tbody></table></div>Может ты забыл добавить после строки запроса сам коннект?<br />
<br />
<div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="256694537"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="256694537" style="height: 46px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
</pre></td><td class="de1"><pre class="de1">sqlCommand <span class="sy0">=</span> <span class="kw3">new</span> MySqlCommand<span class="br0">&#40;</span><span class="st0">&quot;INSERT INTO gissystem.object(Adres) VALUES(@adress);&quot;</span>,sqlConnect<span class="br0">&#41;</span><span class="sy0">;</span></pre></td></tr></table></div></td></tr></tbody></table></div>Больше не забывай и не потеряешь полтора часа жизни.</div>

]]></content:encoded>
			<dc:creator>Jlovenpk1</dc:creator>
			<guid isPermaLink="true">https://www.cyberforum.ru/blogs/316594/5615.html</guid>
		</item>
		<item>
			<title>Ошибка CS026 Не удалось найти тип или имя пространства</title>
			<link>https://www.cyberforum.ru/blogs/316594/5603.html</link>
			<pubDate>Thu, 27 Dec 2018 10:59:12 GMT</pubDate>
			<description><![CDATA[---Цитата--- 
Ошибка CS0246 Не удалось найти тип или имя пространства имен "MySql" возможно,...]]></description>
			<content:encoded><![CDATA[<div>
<table width="95%"  class="bbcode_maincontainer"><tr><td>
	<div class="bbcode_container">
	  <div class="bbcode_quote">
	    <div class="btbtbt">
		<div class="quote_container">
	      	<div class="bbcode_quote_container"></div>
	       	<div class="bbcode_postedby">
	         	
	        </div>
	        <div class="message">Ошибка CS0246 Не удалось найти тип или имя пространства имен &quot;MySql&quot; возможно, отсутствует директива using или ссылка на сборку</div>
	      </div>
			</div> 
		</div>
	</div>
</td></tr></table>Такая вот ошибка с утра на работе появилась. При этом все есть-все подключено, проект и Visual Studio все видит.<br />
Что делать?<br />
Правильно, <s>гуглить</s> удалить библиотеку полностью из проекта и по новой добавить.<br />
Мне помогло.<br />
=-O<br />
<br />
Всех с наступающим новым годом! :friends::drink:</div>

]]></content:encoded>
			<dc:creator>Jlovenpk1</dc:creator>
			<guid isPermaLink="true">https://www.cyberforum.ru/blogs/316594/5603.html</guid>
		</item>
		<item>
			<title>C# Window Forms DataGridview заполнение и удаление клонов</title>
			<link>https://www.cyberforum.ru/blogs/316594/5593.html</link>
			<pubDate>Wed, 19 Dec 2018 05:41:48 GMT</pubDate>
			<description>Привет читатель моего скромного блога, пишу я сюда редко, но в основном я храню тут свои заметки на...</description>
			<content:encoded><![CDATA[<div>Привет читатель моего скромного блога, пишу я сюда редко, но в основном я храню тут свои заметки на те вещи, которые точно не буду запоминать и использую редко.<br />
В будущем надеюсь закончить проект и написать большую статью о GMap, как его модифицировать, о своих модификациях напишу, о кликабельных домах, но пока вернемся к основной теме.<br />
<br />
DataGridView - много решений, разных решений, по этому не побоюсь если кто-то сделать code - review и укажет на лучшие способы, я буду только благодарен.<br />
<br />
И так, я выгружаю данные из базы. <br />
<br />
<div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="267339814"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="267339814" style="height: 158px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
2
3
4
5
6
7
8
</pre></td><td class="de1"><pre class="de1">preLoad <span class="sy0">=</span> <span class="kw3">new</span> Load_Grid<span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="co1">// эт мой недокласс подключения</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">//FindingPoint(); // в будущем расскажу об этом</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">//ParsingExcel(); // для парсинга экселя, так же в будущем расскажу зачем это </span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; preLoad<span class="sy0">.</span><span class="me1">Connect</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="co1">// коннект к базе</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; preLoad<span class="sy0">.</span><span class="kw1">Select</span><span class="br0">&#40;</span><span class="st_h">@&quot;SELECT information.ID, object.adres, trouble, type_trouble, size,date </span>
<span class="st_h"> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM gissystem.information</span>
<span class="st_h"> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;inner join gissystem.object</span>
<span class="st_h"> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;where Object = object.ID;&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="co1">// делаем запрос</span></pre></td></tr></table></div></td></tr></tbody></table></div>Получив ответ и данные едем к основной теме, среди полученных данных есть повторение адресов, которые мне нужно объединять и выводить новую инфу - Количество аварий на адресе. <br />
<br />
<div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="644609989"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="644609989" style="height: 350px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
</pre></td><td class="de1"><pre class="de1"><span class="kw1">while</span><span class="br0">&#40;</span>preLoad<span class="sy0">.</span><span class="me1">dataRead</span><span class="sy0">.</span><span class="me1">Read</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="sy0">.</span><span class="kw1">Add</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>index<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span> <span class="sy0">=</span> preLoad<span class="sy0">.</span><span class="me1">dataRead</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>index<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span> <span class="sy0">=</span> preLoad<span class="sy0">.</span><span class="me1">dataRead</span><span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>index<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">2</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span> <span class="sy0">=</span> preLoad<span class="sy0">.</span><span class="me1">dataRead</span><span class="br0">&#91;</span><span class="nu0">2</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>index<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">3</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span> <span class="sy0">=</span> preLoad<span class="sy0">.</span><span class="me1">dataRead</span><span class="br0">&#91;</span><span class="nu0">3</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>index<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">4</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span> <span class="sy0">=</span> preLoad<span class="sy0">.</span><span class="me1">dataRead</span><span class="br0">&#91;</span><span class="nu0">4</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>index<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">5</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span> <span class="sy0">=</span> preLoad<span class="sy0">.</span><span class="me1">dataRead</span><span class="br0">&#91;</span><span class="nu0">5</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>index<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">6</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span> <span class="sy0">=</span> <span class="nu0">1</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; index<span class="sy0">++;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">for</span> <span class="br0">&#40;</span><span class="kw4">int</span> i <span class="sy0">=</span> <span class="nu0">0</span><span class="sy0">;</span> i <span class="sy0">&lt;</span> ViewGrid<span class="sy0">.</span><span class="me1">RowCount</span><span class="sy0">;</span>i<span class="sy0">++</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">for</span> <span class="br0">&#40;</span><span class="kw4">int</span> j <span class="sy0">=</span> <span class="nu0">1</span><span class="sy0">;</span> j <span class="sy0">&lt;</span> ViewGrid<span class="sy0">.</span><span class="me1">RowCount</span><span class="sy0">;</span> j<span class="sy0">++</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">string</span> check_ <span class="sy0">=</span> ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">string</span> check__ <span class="sy0">=</span> ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>j<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">string</span> checkid <span class="sy0">=</span> ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">string</span> checkid_ <span class="sy0">=</span> ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>j<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span> <span class="sy0">==</span> ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>j<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">1</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span> <span class="sy0">&amp;&amp;</span> 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span> <span class="sy0">!=</span> ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>j<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">int</span> count <span class="sy0">=</span> <span class="kw4">int</span><span class="sy0">.</span><span class="me1">Parse</span><span class="br0">&#40;</span>ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">6</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">2</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span> <span class="sy0">+=</span> <span class="st0">&quot; &quot;</span><span class="sy0">+</span>ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>j<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">2</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">3</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span> <span class="sy0">+=</span> <span class="st0">&quot; &quot;</span><span class="sy0">+</span>ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>j<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">3</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">4</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span> <span class="sy0">+=</span> <span class="st0">&quot; &quot;</span><span class="sy0">+</span>ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>j<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">4</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">5</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span> <span class="sy0">+=</span> <span class="st0">&quot; &quot;</span><span class="sy0">+</span>ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>j<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">5</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">6</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span> <span class="sy0">=</span> count <span class="sy0">+</span> <span class="nu0">1</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="sy0">.</span><span class="me1">RemoveAt</span><span class="br0">&#40;</span>j<span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Refresh</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; j <span class="sy0">=</span> <span class="nu0">0</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">6</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span> <span class="sy0">==</span> <span class="st0">&quot;4&quot;</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">DefaultCellStyle</span><span class="sy0">.</span><span class="me1">BackColor</span> <span class="sy0">=</span> Color<span class="sy0">.</span><span class="me1">DarkRed</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">else</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">6</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span> <span class="sy0">==</span> <span class="st0">&quot;2&quot;</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">DefaultCellStyle</span><span class="sy0">.</span><span class="me1">BackColor</span> <span class="sy0">=</span> Color<span class="sy0">.</span><span class="me1">DarkOrange</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">Cells</span><span class="br0">&#91;</span><span class="nu0">6</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="kw1">Value</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span> <span class="sy0">==</span> <span class="st0">&quot;1&quot;</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ViewGrid<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">DefaultCellStyle</span><span class="sy0">.</span><span class="me1">BackColor</span> <span class="sy0">=</span> Color<span class="sy0">.</span><span class="me1">DarkGreen</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span></pre></td></tr></table></div></td></tr></tbody></table></div>Вот такой здоровый кусок кода получаем, он еще крехтит - пыхтит и его скорость мне не нравится на 100 строк, боюсь представить если строк будет 50 000 тысяч.<br />
Да под это дело можно написать тест и точно проверить скорость работы, руки пока не дошли, сроки жмут.<br />
<br />
Буду рад комментариям с поправками для кода и способами ускорить и улучшить код х)<br />
<br />
Всех с наступающим годом :drink:</div>

]]></content:encoded>
			<dc:creator>Jlovenpk1</dc:creator>
			<guid isPermaLink="true">https://www.cyberforum.ru/blogs/316594/5593.html</guid>
		</item>
		<item>
			<title>DataTable to Excel или загрузка из DataTable в Excel</title>
			<link>https://www.cyberforum.ru/blogs/316594/5468.html</link>
			<pubDate>Fri, 21 Sep 2018 11:05:42 GMT</pubDate>
			<description>Была ситуация, нужно было огромное количество данных загрузить в Excel, естественно с этим делом...</description>
			<content:encoded><![CDATA[<div>Была ситуация, нужно было огромное количество данных загрузить в Excel, естественно с этим делом опыта у меня, как у Самурая опыт в разработке калькулятора на C#. <br />
<br />
И так, порысквал в гугле нашел интересную либу, а именно ClosedXML.<br />
С помощью нее, я смог очень легко и быстро залить данные в Excel из DataTable.<br />
<br />
И как прикладываю код:<br />
<div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="940382955"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="940382955" style="height: 206px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
</pre></td><td class="de1"><pre class="de1">&nbsp;
<span class="kw1">using</span> <span class="co3">ClosedXML.Excel</span><span class="sy0">;</span>
&nbsp;
<span class="co2">#region Закгрузка в Excel</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">private</span> <span class="kw4">void</span> ExcelUpload<span class="br0">&#40;</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; XLWorkbook warkbook <span class="sy0">=</span> <span class="kw3">new</span> XLWorkbook<span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; warkbook<span class="sy0">.</span><span class="me1">AddWorksheet</span><span class="br0">&#40;</span>DT, <span class="st0">&quot;Test&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="co1">// берем наш DataTable забитый информацией и даем название листу.</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; warkbook<span class="sy0">.</span><span class="me1">SaveAs</span><span class="br0">&#40;</span><span class="st_h">@&quot;D:\Excel\&quot;</span><span class="sy0">+</span><span class="st0">&quot;S_S_S_S_S_S_S_S_S_S_S.xlsx&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="co1">// указываем пусть сохранение и имя сохранения</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="co2">#endregion</span></pre></td></tr></table></div></td></tr></tbody></table></div><br />
Ииии, на этом все, вот ссылочка на либу:<br />
<a rel="nofollow noopener noreferrer" href="https://github.com/closedxml/closedxml" target="_blank" title="https://github.com/closedxml/closedxml">https://github.com/closedxml/closedxml</a></div>

]]></content:encoded>
			<dc:creator>Jlovenpk1</dc:creator>
			<guid isPermaLink="true">https://www.cyberforum.ru/blogs/316594/5468.html</guid>
		</item>
		<item>
			<title>ExcelDataReader немного заметок</title>
			<link>https://www.cyberforum.ru/blogs/316594/5466.html</link>
			<pubDate>Wed, 19 Sep 2018 12:28:01 GMT</pubDate>
			<description>Читаем наш Excel документ и работает позже с полученными данными. 
Листинг кода: 
FileStream stream...</description>
			<content:encoded><![CDATA[<div>Читаем наш Excel документ и работает позже с полученными данными.<br />
Листинг кода:<br />
<div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="957856034"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="957856034" style="height: 110px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
2
3
4
5
</pre></td><td class="de1"><pre class="de1">FileStream stream <span class="sy0">=</span> File<span class="sy0">.</span><span class="me1">Open</span><span class="br0">&#40;</span><span class="st_h">@&quot;test.xlsx&quot;</span>, FileMode<span class="sy0">.</span><span class="me1">Open</span>, FileAccess<span class="sy0">.</span><span class="me1">Read</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="co1">//открываем наш документ</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IExcelDataReader reader <span class="sy0">=</span> ExcelReaderFactory<span class="sy0">.</span><span class="me1">CreateOpenXmlReader</span><span class="br0">&#40;</span>stream<span class="br0">&#41;</span><span class="sy0">;</span> <span class="co1">// грузим</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DataSet result <span class="sy0">=</span> reader<span class="sy0">.</span><span class="me1">AsDataSet</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span> 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DataTable dt <span class="sy0">=</span> result<span class="sy0">.</span><span class="me1">Tables</span><span class="br0">&#91;</span><span class="st0">&quot;ForTest&quot;</span><span class="br0">&#93;</span><span class="sy0">;</span> 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; richTextBox1<span class="sy0">.</span><span class="me1">AppendText</span><span class="br0">&#40;</span>dt<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span><span class="nu0">4</span><span class="br0">&#93;</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span></pre></td></tr></table></div></td></tr></tbody></table></div>Подробности.<br />
<br />
<div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="16197043"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="16197043" style="height: 46px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
</pre></td><td class="de1"><pre class="de1">DataTable dt <span class="sy0">=</span> result<span class="sy0">.</span><span class="me1">Tables</span><span class="br0">&#91;</span><span class="st0">&quot;ForTest&quot;</span><span class="br0">&#93;</span><span class="sy0">;</span></pre></td></tr></table></div></td></tr></tbody></table></div>Тут мы открываем страницу нашей книги, у меня первая страница Excel документа называлась ForTest.<br />
<br />
<div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="978339735"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="978339735" style="height: 46px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
</pre></td><td class="de1"><pre class="de1">&nbsp;richTextBox1<span class="sy0">.</span><span class="me1">AppendText</span><span class="br0">&#40;</span>dt<span class="sy0">.</span><span class="me1">Rows</span><span class="br0">&#91;</span><span class="nu0">4</span><span class="br0">&#93;</span><span class="br0">&#91;</span><span class="nu0">0</span><span class="br0">&#93;</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span></pre></td></tr></table></div></td></tr></tbody></table></div>Тут мы добавляем в richtextbox информацию, которую хотим достать.<br />
4: Это строка<br />
0: Это столбец. <br />
<br />
Будьте в этом моменте внимательнее, т.к я по началу вызывал 1 0 и получал пустоту, 2 0 и получал пустоту, мои данные начинались с 4 строки 0 столбца.</div>

]]></content:encoded>
			<dc:creator>Jlovenpk1</dc:creator>
			<guid isPermaLink="true">https://www.cyberforum.ru/blogs/316594/5466.html</guid>
		</item>
		<item>
			<title>Youtube Download + C# + Youtube extractor</title>
			<link>https://www.cyberforum.ru/blogs/316594/5353.html</link>
			<pubDate>Wed, 18 Jul 2018 17:40:51 GMT</pubDate>
			<description>Всем привет, загорелся идей сделать свой Youtube Downloader. Тема старая, мне кажется каждый уже...</description>
			<content:encoded><![CDATA[<div>Всем привет, загорелся идей сделать свой Youtube Downloader. Тема старая, мне кажется каждый уже экспериментировал и делал. <br />
И так, что нужно для того, что бы сделать свой уникальный Youtube Downloader.<br />
1 Сам Youtube Extractor, скачать можно через Manager NuGet Packages. <br />
2 Накидать компоненты на форму.<br />
3 Сам код.<br />
<br />
И так, сам код:<br />

			   <div class="spoiler-wrap">
				   <div class="spoiler-head folded clickable">Кликните здесь для просмотра всего текста</div>
				   <div class="spoiler-body">
					   <div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="10381352"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="10381352" style="height: 350px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
</pre></td><td class="de1"><pre class="de1"><span class="kw1">using</span> <span class="co3">System</span><span class="sy0">;</span>
<span class="kw1">using</span> <span class="co3">System.Collections.Generic</span><span class="sy0">;</span>
<span class="kw1">using</span> <span class="co3">System.ComponentModel</span><span class="sy0">;</span>
<span class="kw1">using</span> <span class="co3">System.Data</span><span class="sy0">;</span>
<span class="kw1">using</span> <span class="co3">System.Drawing</span><span class="sy0">;</span>
<span class="kw1">using</span> <span class="co3">System.Linq</span><span class="sy0">;</span>
<span class="kw1">using</span> <span class="co3">System.Text</span><span class="sy0">;</span>
<span class="kw1">using</span> <span class="co3">System.Threading.Tasks</span><span class="sy0">;</span>
<span class="kw1">using</span> <span class="co3">System.Windows.Forms</span><span class="sy0">;</span>
<span class="kw1">using</span> <span class="co3">YoutubeExtractor</span><span class="sy0">;</span>
<span class="kw1">using</span> <span class="co3">System.Threading</span><span class="sy0">;</span>
<span class="kw1">using</span> <span class="co3">System.IO</span><span class="sy0">;</span>
<span class="kw1">using</span> <span class="co3">System.Net</span><span class="sy0">;</span>
&nbsp;
<span class="kw1">namespace</span> Youtube_Downloader
<span class="br0">&#123;</span>
&nbsp; &nbsp; 
&nbsp; &nbsp; <span class="kw1">public</span> <span class="kw1">partial</span> <span class="kw4">class</span> Form1 <span class="sy0">:</span> Form
&nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw4">int</span> res<span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> <span class="kw4">string</span> path<span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">public</span> Form1<span class="br0">&#40;</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; InitializeComponent<span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">private</span> <span class="kw4">void</span> comboBox1_SelectedIndexChanged<span class="br0">&#40;</span><span class="kw4">object</span> sender, EventArgs e<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">private</span> <span class="kw4">void</span> button1_Click<span class="br0">&#40;</span><span class="kw4">object</span> sender, EventArgs e<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">// Юзаем трай катч, если пользователь забыл выбрать разрешение</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">try</span> <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; res <span class="sy0">=</span> Int32<span class="sy0">.</span><span class="me1">Parse</span><span class="br0">&#40;</span>comboBox1<span class="sy0">.</span><span class="me1">SelectedItem</span><span class="sy0">.</span><span class="me1">ToString</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="co1">// Из нашего комбобокса айтемы в инт</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">catch</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox<span class="sy0">.</span><span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;Вы забыли выбрать разрешение&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; progressBar1<span class="sy0">.</span><span class="me1">Minimum</span> <span class="sy0">=</span> <span class="nu0">0</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; progressBar1<span class="sy0">.</span><span class="me1">Maximum</span> <span class="sy0">=</span> <span class="nu0">100</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">//юзаем трай катч, если вдруг пользователь забыл ссылку </span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">try</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IEnumerable<span class="sy0">&lt;</span>VideoInfo<span class="sy0">&gt;</span> videos <span class="sy0">=</span> DownloadUrlResolver<span class="sy0">.</span><span class="me1">GetDownloadUrls</span><span class="br0">&#40;</span>textBox1<span class="sy0">.</span><span class="me1">Text</span><span class="br0">&#41;</span><span class="sy0">;</span> <span class="co1">// наша ссылка</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VideoInfo video <span class="sy0">=</span> videos<span class="sy0">.</span><span class="me1">First</span><span class="br0">&#40;</span>info <span class="sy0">=&gt;</span> info<span class="sy0">.</span><span class="me1">VideoType</span> <span class="sy0">==</span> VideoType<span class="sy0">.</span><span class="me1">Mp4</span> <span class="sy0">&amp;&amp;</span> info<span class="sy0">.</span><span class="me1">Resolution</span> <span class="sy0">==</span> res<span class="br0">&#41;</span><span class="sy0">;</span> 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">// тут мы указываем тип нашего видео(mp4) и разрешение, которое мы получаем из комбобокса</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>video<span class="sy0">.</span><span class="me1">RequiresDecryption</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DownloadUrlResolver<span class="sy0">.</span><span class="me1">DecryptDownloadUrl</span><span class="br0">&#40;</span>video<span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">// тут мы указываем путь куда будет сохранен ролик+его название. Сам path, мы получаем через FolderBrowserDialog</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VideoDownloader downloader <span class="sy0">=</span> <span class="kw3">new</span> VideoDownloader<span class="br0">&#40;</span>video,Path<span class="sy0">.</span><span class="me1">Combine</span><span class="br0">&#40;</span>path,video<span class="sy0">.</span><span class="me1">Title</span><span class="sy0">+</span>video<span class="sy0">.</span><span class="me1">VideoExtension</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; downloader<span class="sy0">.</span><span class="me1">DownloadProgressChanged</span> <span class="sy0">+=</span> Downloader_ProgressChanged<span class="sy0">;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">// мутим поток </span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Thread threading <span class="sy0">=</span> <span class="kw3">new</span> Thread<span class="br0">&#40;</span><span class="br0">&#40;</span><span class="br0">&#41;</span> <span class="sy0">=&gt;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">// тут с вебклиентом, что бы нас не выбивала ошибка 403(вроде работает)</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WebClient webcl <span class="sy0">=</span> <span class="kw3">new</span> WebClient <span class="br0">&#123;</span> Encoding <span class="sy0">=</span> Encoding<span class="sy0">.</span><span class="me1">UTF8</span> <span class="br0">&#125;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; webcl<span class="sy0">.</span><span class="me1">Headers</span><span class="sy0">.</span><span class="kw1">Add</span><span class="br0">&#40;</span><span class="st0">&quot;user-agent&quot;</span>, <span class="st0">&quot;Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; .NET CLR 1.0.3705;)&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; downloader<span class="sy0">.</span><span class="me1">Execute</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IsBackground <span class="sy0">=</span> <span class="kw1">true</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">//Запускаем</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; threading<span class="sy0">.</span><span class="me1">Start</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">catch</span> 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox<span class="sy0">.</span><span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;Вы забыли ссылку&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">private</span> <span class="kw4">void</span> Downloader_ProgressChanged<span class="br0">&#40;</span><span class="kw4">object</span> sender, ProgressEventArgs e<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">// Наш прогресс бар во время скачивания + данные выводятся в Label4</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Invoke<span class="br0">&#40;</span><span class="kw3">new</span> MethodInvoker<span class="br0">&#40;</span><span class="kw4">delegate</span> <span class="br0">&#40;</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; progressBar1<span class="sy0">.</span><span class="kw1">Value</span> <span class="sy0">=</span> <span class="br0">&#40;</span><span class="kw4">int</span><span class="br0">&#41;</span>e<span class="sy0">.</span><span class="me1">ProgressPercentage</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; label4<span class="sy0">.</span><span class="me1">Text</span> <span class="sy0">=</span> $<span class="st0">&quot;{string.Format(&quot;</span><span class="br0">&#123;</span><span class="nu0">0</span><span class="sy0">:</span><span class="nu0">0</span><span class="sy0">.</span><span class="co2">##}&quot;, e.ProgressPercentage)}%&quot;;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; progressBar1<span class="sy0">.</span><span class="me1">Update</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>label4<span class="sy0">.</span><span class="me1">Text</span> <span class="sy0">==</span> <span class="st0">&quot;100%&quot;</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox<span class="sy0">.</span><span class="me1">Show</span><span class="br0">&#40;</span><span class="st0">&quot;Готово! :)&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">private</span> <span class="kw4">void</span> button2_Click<span class="br0">&#40;</span><span class="kw4">object</span> sender, EventArgs e<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">// тут мы указываем путь сохранения через FolderBrowserDialog</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; folderBrowserDialog1<span class="sy0">.</span><span class="me1">ShowDialog</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; path <span class="sy0">=</span> folderBrowserDialog1<span class="sy0">.</span><span class="me1">SelectedPath</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; textBox2<span class="sy0">.</span><span class="me1">Text</span> <span class="sy0">=</span> folderBrowserDialog1<span class="sy0">.</span><span class="me1">SelectedPath</span><span class="sy0">;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">private</span> <span class="kw4">void</span> label5_Click<span class="br0">&#40;</span><span class="kw4">object</span> sender, EventArgs e<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">//Уходим из программы</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Application<span class="sy0">.</span><span class="me1">Exit</span><span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">private</span> <span class="kw4">void</span> label6_Click<span class="br0">&#40;</span><span class="kw4">object</span> sender, EventArgs e<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">//Прячем программу</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">this</span><span class="sy0">.</span><span class="me1">WindowState</span> <span class="sy0">=</span> FormWindowState<span class="sy0">.</span><span class="me1">Minimized</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="co1">//Код без стыда и совести стырил, помогает управлять формой при bsNone</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">private</span> Point MouseHook<span class="sy0">;</span> 
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">private</span> <span class="kw4">void</span> Form1_MouseMove<span class="br0">&#40;</span><span class="kw4">object</span> sender, MouseEventArgs e<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>e<span class="sy0">.</span><span class="me1">Button</span> <span class="sy0">!=</span> MouseButtons<span class="sy0">.</span><span class="me1">Left</span><span class="br0">&#41;</span> MouseHook <span class="sy0">=</span> e<span class="sy0">.</span><span class="me1">Location</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Location <span class="sy0">=</span> <span class="kw3">new</span> Point<span class="br0">&#40;</span><span class="br0">&#40;</span>Size<span class="br0">&#41;</span>Location <span class="sy0">-</span> <span class="br0">&#40;</span>Size<span class="br0">&#41;</span>MouseHook <span class="sy0">+</span> <span class="br0">&#40;</span>Size<span class="br0">&#41;</span>e<span class="sy0">.</span><span class="me1">Location</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp; &nbsp; <span class="br0">&#125;</span>
<span class="br0">&#125;</span></pre></td></tr></table></div></td></tr></tbody></table></div>
				   </div>
			   </div><br />
<br />
Будут вопросы по коду, обращайтесь, исходник оставил. <br />
<a href="https://www.cyberforum.ru/blog_attachment.php?attachmentid=4941&amp;d=1531935310" rel="Lightbox" id="attachment4941" ><img src="https://www.cyberforum.ru/blog_attachment.php?attachmentid=4941&amp;thumb=1&amp;d=1531935310" class="thumbnail" border="0" alt="Нажмите на изображение для увеличения
Название: Screenshot_2.png
Просмотров: 740
Размер:	5.0 Кб
ID:	4941" style="margin: 5px" /></a><br />
<a href="https://www.cyberforum.ru/blog_attachment.php?attachmentid=4942&amp;d=1531935638" rel="Lightbox" id="attachment4942" ><img src="https://www.cyberforum.ru/blog_attachment.php?attachmentid=4942&amp;thumb=1&amp;d=1531935638" class="thumbnail" border="0" alt="Нажмите на изображение для увеличения
Название: Screenshot_3.png
Просмотров: 587
Размер:	27.9 Кб
ID:	4942" style="margin: 5px" /></a><br />
<a href="https://www.cyberforum.ru/blog_attachment.php?attachmentid=4944&amp;d=1531935864" >Youtube_Downloader.zip</a></div>

]]></content:encoded>
			<dc:creator>Jlovenpk1</dc:creator>
			<guid isPermaLink="true">https://www.cyberforum.ru/blogs/316594/5353.html</guid>
		</item>
		<item>
			<title><![CDATA[расставлено 8 ферзей или добавить ввод ферзей вручную[Pascal.ABC]]]></title>
			<link>https://www.cyberforum.ru/blogs/316594/5268.html</link>
			<pubDate>Thu, 24 May 2018 00:02:02 GMT</pubDate>
			<description>Дело было в 2-а часа ночи, в паблике ВК парень написал, что нужна помощь в паскале. 
Надо идти...</description>
			<content:encoded><![CDATA[<div>Дело было в 2-а часа ночи, в паблике ВК парень написал, что нужна помощь в паскале.<br />
Надо идти спать, но интерес к задаче был выше, учитывая, что паскаль нюхал последний раз в 14 году, взялся помочь.<br />
В онлайн компиляторе все получалось, но ABC не хотел компилировать.<br />
Скачал.<br />
Сделал.<br />
<br />
Вот код:<br />
<div class="codeblock"><table class="pascal"><thead><tr><td colspan="2" id="283922395"  class="head">Pascal</td></tr></thead><tbody><tr class="li1"><td><div id="283922395" style="height: 350px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
</pre></td><td class="de1"><pre class="de1"><span class="kw1">program</span> TestProject<span class="sy1">;</span> 
<span class="kw1">uses</span> crt<span class="sy1">,</span> Utils<span class="sy1">;</span> 
<span class="kw1">const</span> Sz<span class="sy3">=</span><span class="nu0">100</span><span class="sy1">;</span> 
<span class="kw1">var</span> s<span class="sy1">,</span>i<span class="sy1">,</span>f<span class="sy1">,</span>ms<span class="sy1">:</span><span class="kw4">integer</span><span class="sy1">;</span> 
vert<span class="sy1">:</span><span class="kw4">array</span><span class="br0">&#91;</span><span class="nu0">1</span><span class="sy1">..</span><span class="me1">Sz</span><span class="br0">&#93;</span> <span class="kw1">of</span> <span class="kw4">boolean</span><span class="sy1">;</span> <span class="co1">// проверка вертикалей </span>
hor<span class="sy1">:</span><span class="kw4">array</span><span class="br0">&#91;</span><span class="nu0">2</span><span class="sy1">..</span><span class="me1">Sz</span><span class="br0">&#93;</span> <span class="kw1">of</span> <span class="kw4">boolean</span><span class="sy1">;</span> <span class="coMULTI">{сумма координат клетки 1+1=2 8+8=16, </span>
<span class="coMULTI">проверка горизонталей и диагоналей, доступна или нет}</span> 
diag<span class="sy1">:</span><span class="kw4">array</span><span class="br0">&#91;</span><span class="sy3">-</span><span class="nu0">7</span><span class="sy1">..</span><span class="me1">Sz</span><span class="br0">&#93;</span> <span class="kw1">of</span> <span class="kw4">boolean</span><span class="sy1">;</span> <span class="co1">// в сумме с b дает проверку диагоналей </span>
rasst<span class="sy1">:</span><span class="kw4">array</span><span class="br0">&#91;</span><span class="nu0">1</span><span class="sy1">..</span><span class="me1">Sz</span><span class="br0">&#93;</span><span class="kw1">of</span> <span class="kw4">integer</span><span class="sy1">;</span> <span class="co1">// номера горизонталей ферзей, собственно расстановка </span>
vyvod<span class="sy1">:</span><span class="kw4">array</span><span class="br0">&#91;</span><span class="nu0">1</span><span class="sy1">..</span><span class="me1">Sz</span><span class="sy1">,</span><span class="nu0">1</span><span class="sy1">..</span><span class="me1">Sz</span><span class="br0">&#93;</span><span class="kw1">of</span> <span class="kw4">char</span><span class="sy1">;</span> <span class="co1">//матрица - вывод расположения ферзей </span>
&nbsp;
&nbsp;
<span class="kw1">procedure</span> print<span class="sy1">;</span> <span class="co1">// вывод результатов на экран </span>
<span class="kw1">var</span> i<span class="sy1">,</span>j<span class="sy1">,</span>k<span class="sy1">:</span><span class="kw4">integer</span><span class="sy1">;</span> 
<span class="kw1">begin</span> 
s<span class="sy1">:</span><span class="sy3">=</span>s<span class="sy3">+</span><span class="nu0">1</span><span class="sy1">;</span> 
<span class="kw3">writeln</span><span class="br0">&#40;</span><span class="st0">'Решение номер '</span><span class="sy1">,</span>s<span class="sy1">:</span><span class="nu0">2</span><span class="sy1">,</span><span class="st0">' : '</span><span class="sy3">+</span>Milliseconds<span class="sy3">/</span><span class="nu0">1000</span><span class="sy3">+</span><span class="st0">'c'</span><span class="br0">&#41;</span><span class="sy1">;</span> 
ms<span class="sy1">:</span><span class="sy3">=</span>Milliseconds<span class="sy1">;</span> 
<span class="kw1">for</span> i<span class="sy1">:</span><span class="sy3">=</span><span class="nu0">1</span> <span class="kw1">to</span> f <span class="kw1">do</span> 
<span class="kw1">for</span> j<span class="sy1">:</span><span class="sy3">=</span><span class="nu0">1</span> <span class="kw1">to</span> f <span class="kw1">do</span> 
vyvod<span class="br0">&#91;</span>i<span class="sy1">,</span>j<span class="br0">&#93;</span><span class="sy1">:</span><span class="sy3">=</span><span class="st0">'*'</span><span class="sy1">;</span> <span class="co1">//заполним матрицу нолями </span>
<span class="kw1">for</span> k<span class="sy1">:</span><span class="sy3">=</span><span class="nu0">1</span> <span class="kw1">to</span> f <span class="kw1">do</span> 
vyvod<span class="br0">&#91;</span>f<span class="sy3">-</span>rasst<span class="br0">&#91;</span>k<span class="br0">&#93;</span><span class="sy3">+</span><span class="nu0">1</span><span class="sy1">,</span>k<span class="br0">&#93;</span><span class="sy1">:</span><span class="sy3">=</span><span class="st0">'#'</span><span class="sy1">;</span> <span class="co1">//клетки с ферзями, номер по вертикали, номер по горизонтали </span>
<span class="kw1">for</span> i<span class="sy1">:</span><span class="sy3">=</span><span class="nu0">1</span> <span class="kw1">to</span> f <span class="kw1">do</span> 
<span class="kw1">begin</span> 
<span class="kw1">for</span> j<span class="sy1">:</span><span class="sy3">=</span><span class="nu0">1</span> <span class="kw1">to</span> f <span class="kw1">do</span> 
<span class="kw3">write</span><span class="br0">&#40;</span>vyvod<span class="br0">&#91;</span>i<span class="sy1">,</span>j<span class="br0">&#93;</span><span class="sy1">,</span><span class="st0">' '</span><span class="br0">&#41;</span><span class="sy1">;</span> 
<span class="kw3">writeln</span><span class="sy1">;</span> 
<span class="kw1">end</span><span class="sy1">;</span> 
ms<span class="sy1">:</span><span class="sy3">=</span>round<span class="br0">&#40;</span>Milliseconds<span class="br0">&#41;</span><span class="sy3">-</span>ms<span class="sy1">;</span> 
<span class="kw3">writeln</span><span class="br0">&#40;</span><span class="st0">'Время работы: '</span><span class="sy3">+</span>ms<span class="br0">&#41;</span><span class="sy1">;</span> 
<span class="kw3">write</span><span class="br0">&#40;</span><span class="st0">'Press &lt;Enter&gt;'</span><span class="br0">&#41;</span><span class="sy1">;</span> 
<span class="kw3">readln</span><span class="sy1">;</span> 
<span class="kw1">end</span><span class="sy1">;</span> 
&nbsp;
&nbsp;
&nbsp;
<span class="kw1">procedure</span> addFerz<span class="br0">&#40;</span>i<span class="sy1">:</span><span class="kw4">integer</span><span class="br0">&#41;</span><span class="sy1">;</span> <span class="co1">//рекурсивная процедура расстановки ферзей </span>
<span class="kw1">var</span> j<span class="sy1">:</span><span class="kw4">integer</span><span class="sy1">;</span> 
<span class="kw1">begin</span> 
<span class="kw1">for</span> j<span class="sy1">:</span><span class="sy3">=</span><span class="nu0">1</span> <span class="kw1">to</span> f <span class="kw1">do</span> 
<span class="kw1">if</span> <span class="br0">&#40;</span>vert<span class="br0">&#91;</span>j<span class="br0">&#93;</span> <span class="sy3">=</span> <span class="kw2">TRUE</span><span class="br0">&#41;</span> <span class="kw1">and</span> <span class="br0">&#40;</span>hor<span class="br0">&#91;</span>i<span class="sy3">+</span>j<span class="br0">&#93;</span> <span class="sy3">=</span> <span class="kw2">TRUE</span><span class="br0">&#41;</span> <span class="kw1">and</span> <span class="br0">&#40;</span>diag<span class="br0">&#91;</span>i<span class="sy3">-</span>j<span class="br0">&#93;</span> <span class="sy3">=</span> <span class="kw2">TRUE</span><span class="br0">&#41;</span> <span class="kw1">then</span> <span class="co1">//если поле не бъется </span>
<span class="kw1">begin</span> 
rasst<span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy1">:</span><span class="sy3">=</span>j<span class="sy1">;</span> <span class="co1">//займем его </span>
vert<span class="br0">&#91;</span>j<span class="br0">&#93;</span><span class="sy1">:</span><span class="sy3">=</span><span class="kw2">false</span><span class="sy1">;</span> hor<span class="br0">&#91;</span>i<span class="sy3">+</span>j<span class="br0">&#93;</span><span class="sy1">:</span><span class="sy3">=</span><span class="kw2">false</span><span class="sy1">;</span> diag<span class="br0">&#91;</span>i<span class="sy3">-</span>j<span class="br0">&#93;</span><span class="sy1">:</span><span class="sy3">=</span><span class="kw2">false</span><span class="sy1">;</span> <span class="co1">//делаем битым </span>
<span class="kw1">if</span> i&lt;f <span class="kw1">then</span> addFerz<span class="br0">&#40;</span>i<span class="sy3">+</span><span class="nu0">1</span><span class="br0">&#41;</span> <span class="kw1">else</span> print<span class="sy1">;</span> <span class="co1">//если не последняя вертикаль, то проверяем следующую, иначе вывод </span>
vert<span class="br0">&#91;</span>j<span class="br0">&#93;</span><span class="sy1">:</span><span class="sy3">=</span><span class="kw2">true</span><span class="sy1">;</span> hor<span class="br0">&#91;</span>i<span class="sy3">+</span>j<span class="br0">&#93;</span><span class="sy1">:</span><span class="sy3">=</span><span class="kw2">true</span><span class="sy1">;</span> diag<span class="br0">&#91;</span>i<span class="sy3">-</span>j<span class="br0">&#93;</span><span class="sy1">:</span><span class="sy3">=</span><span class="kw2">true</span><span class="sy1">;</span><span class="coMULTI">{если не получилось до конца, освобождаем поле </span>
<span class="coMULTI">возвращаемся назад, проверяем следующий вариант}</span> 
<span class="kw1">end</span><span class="sy1">;</span> 
<span class="kw1">end</span><span class="sy1">;</span> 
&nbsp;
&nbsp;
<span class="kw1">begin</span> 
clrscr<span class="sy1">;</span> 
<span class="kw3">write</span><span class="br0">&#40;</span><span class="st0">'Число Ферзей: '</span><span class="br0">&#41;</span><span class="sy1">;</span> 
<span class="kw3">readln</span><span class="br0">&#40;</span>f<span class="br0">&#41;</span><span class="sy1">;</span> 
<span class="kw1">for</span> i<span class="sy1">:</span><span class="sy3">=</span><span class="nu0">1</span> <span class="kw1">to</span> f <span class="kw1">do</span> vert<span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy1">:</span><span class="sy3">=</span><span class="kw2">true</span><span class="sy1">;</span> <span class="co1">//все поля свободны </span>
<span class="kw1">for</span> i<span class="sy1">:</span><span class="sy3">=</span><span class="nu0">2</span> <span class="kw1">to</span> f<span class="sy3">*</span><span class="nu0">2</span> <span class="kw1">do</span> hor<span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy1">:</span><span class="sy3">=</span><span class="kw2">true</span><span class="sy1">;</span> <span class="co1">//нет угроз ни по горизонталям, ни по вертикалям </span>
<span class="kw1">for</span> i<span class="sy1">:</span><span class="sy3">=-</span>f <span class="kw1">to</span> f <span class="kw1">do</span> diag<span class="br0">&#91;</span>i<span class="br0">&#93;</span><span class="sy1">:</span><span class="sy3">=</span><span class="kw2">true</span><span class="sy1">;</span> <span class="co1">//нет угроз по диагоналям </span>
s<span class="sy1">:</span><span class="sy3">=</span><span class="nu0">0</span><span class="sy1">;</span> 
addFerz<span class="br0">&#40;</span><span class="nu0">1</span><span class="br0">&#41;</span><span class="sy1">;</span> <span class="co1">//начинаем с первой вертикали </span>
<span class="kw3">readln</span> 
<span class="kw1">end</span><span class="sy1">.</span></pre></td></tr></table></div></td></tr></tbody></table></div></div>

]]></content:encoded>
			<dc:creator>Jlovenpk1</dc:creator>
			<guid isPermaLink="true">https://www.cyberforum.ru/blogs/316594/5268.html</guid>
		</item>
		<item>
			<title><![CDATA[Удаление строк. [Для новичков]]]></title>
			<link>https://www.cyberforum.ru/blogs/316594/3672.html</link>
			<pubDate>Mon, 03 Aug 2015 09:03:13 GMT</pubDate>
			<description>Всем привет. 
Сам я новичок в C#, перекочевал с Delphi. 
 
По ТЗ, требовалось открывать файл и...</description>
			<content:encoded><![CDATA[<div>Всем привет.<br />
Сам я новичок в C#, перекочевал с Delphi.<br />
<br />
По ТЗ, требовалось открывать файл и удалять из него строки.<br />
Долго и муторно я тыкался, но книга Г.Шилдта помогла.<br />
<br />
И так, код:<br />
<div class="codeblock"><table class="csharp"><thead><tr><td colspan="2" id="217716359"  class="head">C#</td></tr></thead><tbody><tr class="li1"><td><div id="217716359" style="height: 350px" class="codeframe"><table><tr class="li1"><td class="ln" style="padding: 0px 10px 0px 5px;"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
</pre></td><td class="de1"><pre class="de1"><span class="co1">// действие по кнопке</span>
<span class="kw1">private</span> <span class="kw4">void</span> start_Click<span class="br0">&#40;</span><span class="kw4">object</span> sender, EventArgs e<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OpenFileDialog opf <span class="sy0">=</span> <span class="kw3">new</span> OpenFileDialog<span class="br0">&#40;</span><span class="br0">&#41;</span><span class="sy0">;</span> 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; opf<span class="sy0">.</span><span class="me1">Multiselect</span> <span class="sy0">=</span> <span class="kw1">true</span><span class="sy0">;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">int</span> i<span class="sy0">=</span><span class="nu0">0</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class="co1">// открываем файл</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">if</span> <span class="br0">&#40;</span>opf<span class="sy0">.</span><span class="me1">ShowDialog</span><span class="br0">&#40;</span><span class="br0">&#41;</span> <span class="sy0">==</span> DialogResult<span class="sy0">.</span><span class="me1">OK</span><span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TextBox<span class="sy0">.</span><span class="me1">AppendText</span><span class="br0">&#40;</span>File<span class="sy0">.</span><span class="me1">ReadAllText</span><span class="br0">&#40;</span>opf<span class="sy0">.</span><span class="me1">FileName</span><span class="br0">&#41;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;
&nbsp;
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#125;</span>
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; <span class="kw1">private</span> <span class="kw4">void</span> button1_Click<span class="br0">&#40;</span><span class="kw4">object</span> sender, EventArgs e<span class="br0">&#41;</span>
&nbsp; &nbsp; &nbsp; &nbsp; <span class="br0">&#123;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="kw4">string</span> data<span class="sy0">;</span> <span class="co1">// объявляем переменную </span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class="co1">// и с помощью переменная = текст из текстбокса(Richeditbox)</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; data <span class="sy0">=</span> TextBox<span class="sy0">.</span><span class="me1">Text</span><span class="sy0">;</span>
<span class="co1">// ищем и удаляем не нужные нам слова переменая = переменая.реплейс (&quot;старое значение&quot;, &quot;новое знаниче&quot;);</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; data <span class="sy0">=</span> data<span class="sy0">.</span><span class="me1">Replace</span><span class="br0">&#40;</span><span class="st0">&quot;&lt;Request&gt;&lt;Zapros&gt;&quot;</span>, <span class="st0">&quot;&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; data <span class="sy0">=</span> data<span class="sy0">.</span><span class="me1">Replace</span><span class="br0">&#40;</span><span class="st0">&quot;&lt;/Zapros&gt;&lt;/Request&gt;&quot;</span>, <span class="st0">&quot;&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; data <span class="sy0">=</span> data<span class="sy0">.</span><span class="me1">Replace</span><span class="br0">&#40;</span><span class="st0">&quot;&lt;?xml version=&quot;</span> ,<span class="st0">&quot;&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; data <span class="sy0">=</span> data<span class="sy0">.</span><span class="me1">Replace</span><span class="br0">&#40;</span><span class="st0">&quot;1.0&quot;</span>,<span class="st0">&quot;&quot;</span><span class="br0">&#41;</span><span class="sy0">;</span>
<span class="co1">// обновляем данные в текстбоксе</span>
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TextBox<span class="sy0">.</span><span class="me1">Text</span> <span class="sy0">=</span> data<span class="sy0">;</span></pre></td></tr></table></div></td></tr></tbody></table></div>Easy peasy lemon squeze :3</div>

]]></content:encoded>
			<dc:creator>Jlovenpk1</dc:creator>
			<guid isPermaLink="true">https://www.cyberforum.ru/blogs/316594/3672.html</guid>
		</item>
	</channel>
</rss>
