Wednesday, September 25, 2019

Web development






Posted by at No comments:

Monday, September 23, 2019

Freelance business

Posted by at No comments:

Sunday, September 22, 2019

SharpDevelop.Report: using ICSharpCode.Reports.Core;

Ovde imate sasvim dovoljno elemenata da napravite poslovnu aplikaciju sa bazom podataka i odgovarajućim Report-ima (priprema za štampu tabelarnih podataka iz baze - kreiranje finansijskih i drugih poslovnih izveštaja). Ukoliko se i dalje ne snalazite sami i pored svih ovih primera, mi Vam nudimo jedan potpuno primenljiv, ozbiljan i funkcionalan primer poslovne aplikacije:
1) Aplikacija za vodjenje plata
2) Aplikacija za uredjivanje sajtova (sa FTP modulom za postavku istih)
3) Aplikacija za vodjenje finansijskog knjigovodstva, glavna knjiga, temeljnice, ulazne fakture, izlazne fakture izveštaji po kontima, sintetikama i partnerima (kupcima i dobavljačima)
4) Aplikacija za vodjenje magacina sa opcijom postavljanja cenovnika i zaliha na web sajt pomoću odgovarajućeg FTP modula
5) Aplikacija za e-mail marketing sa odgovarajućom bazom podataka (nudimo i opcionalni SPIDER za automatsko preuzimanje e-mail adresa sa google pretraživača i update baze podataka)
The SharpDevelop Reports for .NET feature tour will cover the following topics:

1 - Creating Reports using the Pull Data Model

  1. First, please click "File / New" then select "Sharp Develop Reports" and click the "Create" button. 
  2. This brings up the SharpDevelop Reports Wizard where you can set the Report Name, the Report File Name, the Report Path and select the Report Model. Please keep "Pull Data" selected, then click the "Next" button:

  1. The next page allows you to define a database connection by right clicking "database connections" and selecting "Add connection"

  1. In the upcoming Data Link Properties dialog please select "SQL Native Client" and click "Next":

  1. In the Connection dialog please fill in the values as shown below and click "OK":

  1. Your SharpDevelop Reports wizard now shows the database connection and you can display the elements of the selected datasource:

  1. Now please drag and drop the table "Categories" to the Command Text window. This will autogenerate the SELECT statement:

  1. The next step in the wizard shows you the result set for your SELECT statement:

  1. When clicking the "Finish" button now, your report will be generated and shown in the report designer:

  1. When clicking the "Preview" tab you can preview the rendered version of your report: 

  1. And last but not least, when you click the "Report Viewer" tab you can print or export your report to a PDF file:

2 - Creating Reports using the Push Data Model

  1. To create a Push Data Model based Report, please repeat the steps 1 to 8 of "Creating Reports using the Pull Data Model". Instead of clicking "Next", now please right click you result set and select "Save Result (Schema only)" and enter a file name for your .xsd file:

  1. Now please create another Report, but instead of choosing "Pull Model" in step 1 of your wizard, please choose "Push Model" and click "Next". Step 2 of your wizard now allows you to select your previously created .xsd file and check which fields should be databound to your report:

  1. After clicking the "Finish" button, your report will be shown in the report designer:

3 - Creating Reports using Pull Data Model with Stored Procedures

  1. Please repeat step 1 to 6 from "Creating Reports using the Pull Data Model".
  2. Instead of dragging a table to the Command Text window now please drag the "CustOrdersDetails" Stored Procedure to the Command Text windows and click "Next":

  1. In the ParameterDialog please enter the value for the detected Parameters for the Stored Procedure and click "OK":

  1. The Query Result window now shows a preview of the selected data:

  1. After clicking the "Finish" button the report is displayed in the Report Designer:

4 - Creating Reports using Stored Procedures with Parameters at runtime

  1. Now please create a new Windows Application in your preferred .NET IDE and add a reference to the ICSharpCode.Reports.Core which is in the \bin\AddIn folder. Also please add a reference to System.Configuration.dll which is installed in the GAC.
  2. Define a connection string named "NorthwindConnection" which contains the connection string to your Northwind database:
     connectionString="Data Source=(local)\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True;" providerName="System.Data.SqlClient"
  3. Now, please add these additional usings:
     using System.Configuration;
 using System.Data.Common;
 using ICSharpCode.Reports.Core;
 using ICSharpCode.Reports.Core.Exporter;
  4. Paste the following code snippet into your application's code and correct the reportPath according to your path:
     ReportEngine engine = new ReportEngine();
 ReportParameters pm = new ReportParameters();
 
 ConnectionStringSettings css = System.Configuration.ConfigurationManager.ConnectionStrings["NorthwindConnection"];
 DbProviderFactory factory = DbProviderFactories.GetFactory(css.ProviderName);
 DbConnection conn = factory.CreateConnection();
 
 string reportPath = @"C:\Users\AZeitler\Documents\SharpDevelopReports\Report1.srd";
 
 ReportModel reportModel = ReportEngine.LoadReportModel(reportPath);

 PageBuilder pageBuilder = engine.CreatePageBuilder(reportModel);
 pageBuilder.BuildExportList();
 
 pm.ConnectionObject = ConnectionObject.CreateInstance(conn);
 
 pm.SqlParameters.Clear();
 pm.SqlParameters.Add(new SqlParameter("OrderID", System.Data.DbType.Int32, 10480));
 
 engine.PreviewStandardReport(reportPath, pm);
  5. Please build and run your application. This should start up the Report Viewer from within your .NET Application with a preview of your previously created report:
Posted by at No comments:

Anroid Studio and Sqlite

-----------

--------------------
Posted by at No comments:

Friday, September 20, 2019

SQLITE and C#


1)

++

https://stackoverflow.com/questions/29107096/fill-datagridview-from-sqlite-db-c

2)
||

http://adodotnetsqlite.sourceforge.net/

---------


https://www.majorgeeks.com/mg/getmirror/tweaking_com_repair_msi_(windows_installer),1.html
+Windows 10 midleware problem with trustedge

 https://www.youtube.com/watch?v=8YdjguVZID8
+sqlite datareader

 ||
https://stackoverflow.com/questions/16381490/binding-sqldatareader-to-gridview-c-sharp

 https://www.c-sharpcorner.com/forums/data-reader-with-gridview

 https://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-dataadapter-and-datatable-in-c-sharp1

 https://www.codeproject.com/Questions/679137/fill-gridview-from-datareader

 https://docs.microsoft.com/en-us/dotnet/api/system.data.dataset?view=netframework-4.8

https://www.dotnetperls.com/dataset

http://csharp.net-informations.com/dataset/csharp-dataset-tutorial.htm

https://sourceforge.net/projects/vdosplus/


Posted by at No comments:

SD card recover data

**


Posted by at No comments:

Thursday, September 19, 2019

Python + SQLITE + TKINTER + DbBrowser for SQLITE

Posted by at No comments:

sass

Posted by at No comments:

Wednesday, September 18, 2019

Posao

VA jobs
https://www.netokracija.rs/virtuelni-asistent-profesije-152842
https://poslovi.infostud.com/vesti/Virtuelni-asistent-kao-profesija-buducnosti-Sta-je-potrebno-da-biste-radili-taj-posao/52545

http://www.nikolinaandric.com/virtuelni-asistent-pisanje-prijava/

language learning
https://www.duolingo.com/

http://learnenglish.britishcouncil.org/online-english-level-test

https://www.cambridgeenglish.org/

emailers
https://mailchimp.com/

https://www.aweber.com/

https://www.getresponse.com/

memorize and organize
https://evernote.com/

colab
https://trello.com/

https://slack.com/intl/en-rs/

typing test
https://www.typingtest.com/

freelance
https://www.upwork.com/

https://www.freelancer.com/

**


Nivo dobrog HDL holesterola možemo da povećamo tako što ćemo ublažiti stres i u svakodnevni život uključiti sport i rekreaciju u vidu šetnje od bar 45 minuta, vožnje bicikla, plivanja, džoginga.
– Tako ćemo normalizovati telesnu težinu, što je, takođe, način da podignemo dobar holesterol. Naravno, savetuje se ishrana bogata omega-3 nezasićenim masnim kiselinama, kojih najviše ima u plavoj ribi, mnogo svežeg voća poput limuna, nara, kivija, grejpfruta, lubenica, jabuka i šljiva, zatim povrće poput artičoke, belog luka, šargarepe, paprike, paradajza. Dobro je i da se svakog dana pojede šaka badema, lešnika, oraha, da se koristi nerafinisano maslinovo ulje i da se umesto kafe pije zeleni čaj.

Glavni uzrok za nastajanje srčanog infarkta jeste oštećenje koronarne arterije, a ne odnos dobrog HDL i lošeg LDL holesterola. Bez zapaljenskog procesa prisutnog na krvnim sudovima, ne postoji način da se holesterol nakupi u zidovima krvnih sudova i da prouzrokuje srčani infarkt ili moždani udar. Bez upalnog procesa, holesterol bi slobodno cirkulisao po celom telu onako kako je to priroda odredila. Zapaljenje je to koje uzrokuje da se holestrol taloži u i na zidu oštećenog krvnog suda – kaže doktor Hadži-Tanović, i dodaje da bi odnos LDL i HDL trebalo da bude 3 : 1, a to matematički znači da, ako je LDL 3 mmol/l, onda je donja granica za HDL 1 mmol/l.

Poželjne vrednosti masnoća u krvi

Nivo ukupnih masnoća        5, 2 mmol/l
LDL (lošeg) holesterola         3,4 mmol/l
HDL (dobrog)     više od 1,6 mmol/l
*Dr Hadži-Tanović kaže da najnovija istraživanja pokazuju da je holesterol normalan do 7 mmol/l i da do te vrednosti ne treba uzimati lekove koji ga smanjuju.
Ovas


Posted by at No comments:

Tuesday, September 17, 2019

TOTAL CONTROL ON LAN NETWORK

Server and network monitoring software. Hardware monitoring: Total Network Monitor.

https://www.softinventive.com/total-network-monitor/

https://www.youtube.com/watch?v=8Xb088AFbSY



Say you have a for loop:
const list = ['a', 'b', 'c']
for (let i = 0; i < list.length; i++) {
  console.log(`${i} ${list[i]}`)
}
If you want to break at some point, say when you reach the element b, you can use the break statement:
const list = ['a', 'b', 'c']
for (let i = 0; i < list.length; i++) {
  console.log(`${i} ${list[i]}`)
  if (list[i] === 'b') {
    break
  }
}
You can use break also to break out of a for..of loop:
const list = ['a', 'b', 'c']

for (const value of list) {
  console.log(value)
  if (value === 'b') {
    break
  }
}
Note: there is no way to break out of a forEach loop, so (if you need to) use either for or for..of.
CREATE TABLE `address_book` ( `id` int(11) NOT NULL, `address` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `address_book` ADD PRIMARY KEY (`id`); ALTER TABLE `address_book` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; INSERT INTO `address_book` (`id`, `address`) VALUES (1, '560 Spadafore Drive'), (2, '4096 Locust View Drive'), (3, '3204 Sweetwood Drive'), (4, '379 Garfield Road'), (5, '4620 Clair Street');
https://code-boxx.com/simple-php-crud-application-mysql/
Posted by at No comments:
Subscribe to: Posts (Atom)