Отправляет email-рассылки с помощью сервиса Sendsay

Бюллетень "Lotus Notes CodeStore"

Подписаться Бесплатная «Серебряная» новостная рассылка . Подписчиков 224 RSS
←   Февраль 2011   →
 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


За последние 60 дней 2 выпусков (1-2 раза в 2 месяца)


Сайт рассылки: http://lotusnotes.wordpress.com
Открыта: 28-03-2008

Автор
Леонид Николаевич Дорохов

Статистика

224 подписчиков
+1 за неделю
←   Все выпуски   →

Java Attach API Thread can cause High CPU Utilization


Рассылку ведет: Программист на Lotus NotesLotus CoderВыпуск No 448 от 2011-02-02
рассылка о программировании на Lotus Notes/Domino
Обсуждения на форумах, блогах. Примеры программного кода на LotusScript,@formula, Java

рассылка:выпускархивлентаблогсайт

Бюллетень "Lotus Notes CodeStore" Выпуск 13 от 21.04.2008

comp.soft.prog.lotuscodesrore

Поиск по сайтам о Lotus Notes
Тематически поиск только по сайтам о Lotus Notes.
lotus.googlecse.org.ua
Содержание выпуска

CodeStore. Примеры кодов

Еще примеры:
Больше кодов на сайтах:

Форумы.Свежи темы и обсуждения

Dim v
...
Подскажите, где можно найти вопросы с ответами для подготовки к сертификации IBM Certified Associate System Administrator - Lotus Notes and Domino 8.5
Добрый день!

Со вчерашнего дня проявилась проблема: Domino, как служба Windows начала самопроизвольно и постоянно (1 раз в час примерно) выгружаться.
Сообщение в просмотре событий системы: "Служба Lotus Domino Server... неожиданно прервана"
В чем может быть причина? До этого все нормально работало 3 года!

Заранее благодарю за помощь...
Интересные темы:
Список форумов:

Tips. Советы

NaviSite, Inc. announced the availability of new managed services for Lotus Connections 3.0 - available on cloud-based or dedicated infrastructure.

Read | Permalink


POWER TOOLS 7.0 IS A SET OF 98 ADMINISTRATIVE UTILITIES FOR LOTUS NOTES & DOMINO
Power Tools simplifies management of the Notes/Domino environment by automating routine tasks. Power Tools can manage or monitor mail files, groups, ACLs, agents, LOG.NSF, templates and more.

Download a trial version from helpsoft.com.

Trend Micro Incorporated has released its security software for all 64-bit IBM Lotus Domino platforms including the new IBM System z platform.

Read | Permalink
The Social Business Toolkit is IBM's new social network platform for enterprise applications. The toolkit allows activity streams to be displayed in a Lotus Notes client or on a mobile device.

Read | Permalink
The IBM Lotus Connections team is hosting this webcast on how to install, deploy, and customize Lotus Connections 3.0. You can submit questions via e-mail prior to the event.

Read | Permalink


LEARN XPAGES WITH TLCC, THE LEADER IN NOTES AND DOMINO TRAINING
Tap here for more information and to try a free demo course!

If you followed my lead on Friday you'll have installed everything you need to developer in ASP.NET.

Now - assuming you remembered to include it as part of the install - launch SQL Server Management Studio. First thing you'll see is a login screen, as below:

image

In the Server Name field put COMPUTERNAME\SQLEXPRESS or try LOCALHOST\SQLEXPRESS if you don't know your computer's name. Enter the password you chose during install and press connect.

Once connected. Right click the Databases folder in the left-hand pane and choose New Database. You'll see a box, like below, in which you can name it Zoo and press OK.

image

Now, find the Tables folder within your new database, right click it and add a new Table. Add some columns, like below.

image

These columns will likely change as we go along, but, for now, we just want to get up and running.

With these rudimentary columns in place, we need to configure the table's "ID" column. First thing we need to do is make it a Primary Key. To do this, right click the animal_id column and choose Set Primary Key.

image

Now, we need to tell the ID column to "auto increment". In MySQL tools, such as the brilliant HeidiSQL, this is fairly obvious how to achieve. In SQL Server it took me a while to work out that you need to find the "Identity Specification" section of the Column Properties and change "Is Identity" to Yes.

image

For those of you unfamiliar with SQL, a column that is an identity gets auto-incremented each time you add a row. When you add the first row, the ID column value is 1. For the second row it's 2. Etc. You don't need to specify these values, the SQL system does it for you.

Now, we need to add a Database Diagram to define relationships between tables. It's not really essential at this point (where we have no inter-table relationships to define) but it will come in handy later on in helping build a DataSet in Visual Studio.

On the Database Diagrams section of your database right click and add a new diagram. Add the Animals table it and save (name isn't important really).

image

Before we finish let's quickly add some data. Right click the table and choose "Edit Top 200 Rows". You can then type in "raw" values in to each column. Press the down arrow to move to a new row.

Note that you don't need to add values to the animal_id column as it will auto increment these for us. Just leave its value as NULL.

image

There's no need to save the table after entering values. As you go the values and entries are automatically updated to the database!

In the next post we'll create a new project in Visual Studio, connect it to SQL Server and then build a DataSet.

At this point it might be worth pointing out that I don't proclaim to be an ASP.NET expert. Nor am I - by any means - a SQL (or SQL Server) guru. I'm somewhere above average, if I dare say so.

What I'm describing here is the point I'm at in my learnings. It's the approach I'm using at the moment and is constantly changing as I learn more and better ways of doing things. I'm not saying it's the best way, but it's the way I'm happy doing things after about 18 months at it. In that time I've made quite a few "mistakes", so at least if you follow along you should avoid making any of them.

If along the way you think you know a better way or see me making glaring mistakes. Please, please say.

Click here to post a response

Trilog Group has released ProjExec 5.0, a Social Project Management solution for the IBM social collaboration platform. ProjExec 5.0 uses a Web 2.0 user experience in its Project Wall, a social networking experience similar to Facebook for business.

Read | Permalink
Sherpa Software announced an updated version of Compliance Attender for Lotus Notes with cross-platform support and the ability to run on all Domino operating system platforms.

Read | Permalink

Dave Hay has been working on this problem for a while. He's finally found a fix that works for him. Dave has posted the information to help you out.

Read | Permalink
Molly Malsam wants to remind you, creating a good portal often means ignoring what the user says and paying attention to what they do.

Read | Permalink

Now our database is setup and running (SQL Server leaves a task running (the server) in the background on your PC at all times), let's connect to it from an ASP.NET application.

First off, launch Visual Web Developer Express 2010 (AKA Visual Studio or simply VS) and click on New Project. Make sure Visual C# (why bother with VB!?) is selected and then select the Web section from inside there.

image

From the list of project templates choose ASP.NET Web Application and call the project "Zoo", as above, then press Ok.

It will then create all the files needed for a basic web-site, as you can see below:

image

If you press F5 at this point it will compile and run the app in your browser and you should see this:

image

Notice there's a Login link that provides some basic account-management processes. The rest of it is static content.

Connecting To Our Data

To connect to the database we created yesterday we need to add a "connection string" to the Web.Config file. In the Solution Explorer pane of VS find the Web.Config file (normally right at the bottom and open it up).

image

We need to replace the existing connection string with this one:

<connectionStrings>
<add name="ZooConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Zoo;Persist Security Info=True;User ID=sa;Password=YourP4ssH3re" providerName="System.Data.SqlClient"/>
</connectionStrings>

Note: In production you'd want to add a new user (rather than using the "sa" account) in SQL Server and update the connection string.

Adding a DataSet

Now we're ready to tell the ASP.NET app about our database. To do this we use a DataSet to define the backend tables and the relationships between them.

image

You'll then get an empty DataSet. Right-click anywhere within it and choose to add a new TableAdapter, like so:

image

You'll then have to fill in a Wizard. First thing to do is choose the connection string (should default to the one we added to our Web.config file), like so:

image

Tell it you want to use SQL Statements:

image

Then tell it just to get all the rows from our Animals table:

image

Then just tell it to return a DataTable from the method called GetAllAnimals:

image

You will then end up with a DataSet with a single Table Adapter on it, as below:

image

And that's it. We're ready to start accessing the data from our app now!

Using Data In Our Application

Let's test our new Table Adapter by adding a data grid to the home page. Open up the Default.aspx file and make it look like this:

image

Notice we've added a GridView, which is like a table-based view of data. Now we need to bind some data to it. We do this in the Page_Load event and we code for that in the "code behind" file.

To get to the code-behind file, right-click inside the Default.aspx file and choose "View Code". This will open the Default.aspx.cs file, which is where we write the C# ("see sharp") code associated with the Default.aspx page.

Here's the code we need:

image

Notice I added a "using" statement (equivalent of import in Java). It loads the classes for the TableAdapters in our Zoo.xsd DataSet. That's why we can then refer to objects based on the AnimalsTableAdapter and use the method called GetAllAnimals, which we defined earlier, to fetch a table of data and bind it to the GridView.

With the above code in place (I purposely used an image so you need to type it in, hoping it will give you a taste for how amazing coding is in VS!) press F5 and you should see this in the browser:

image

Howza!

Summary

In practice I don't use GridViews, but, for the sake of a simple demo I've used one here. Hopefully it shows how easy it is to fetch and bind data to objects once the DataSet is in place and TableAdapters are defined. We've done most of the donkey work for now.

We'll be using the TableAdapters for all connections to the database, whether that's to query data or insert, update or delete it. They're very powerful and I much prefer using them over using hard-coded SQL from with ASPX or code-behind files.

If I'm losing any of you already or you have questions, please speak up and I'll try my best to answer.

Next? Let's create a C#-based object/class to define the Animals.

Click here to post a response

Еще советы:
Смотри советы на сайтах:

Блоги. Что обсуждают и пишут

Alistair Rennie, General Manager IBM Lotus, has just announced the winner and the finalists of the Open Source Category of the Lotus Awards. Winner: ISW - Widlfire Finalists:  Declan Lynch (fileSendr), Ferry Kranenburg ...
The XPages Mobile Controls OpenNTF project has been demonstrated in the Lotusphere Opening General Session. Watch this video to see the Expense Report app running on ...
Author: Steve Medure
Tags: calendar traveler widgets
Idea:
 On most Android based phones you can create widgets for applications.  Before Traveler was able to work with android devices we were using Nitro Desk Touchdown to sync with Traveler.  Touchdown had a Calendar widget that would allow the user to see all of there appointments without having to open the calendar app.  It was a nice feature to have, it would be nice to see this ability in the next release of Traveler.  It would also be nice to see a widget for mail too.

Bruce Elgort and I will demonstrate several OpenNTF projects today. We'll show the 15 applications below and more in action. These applications are also listed on xpages.info/downloads. BP207 Apps, Apps, and More Apps: Meet the Very Best Open Source ...
Author: Tinus Riyanto
Tags: mail rules
Idea:
Currently when a user using notes client try to send email that is blocked by the server's mail rule, they got  a prompt saying "Document has been rejected by mail rule : <server name> mail.box" . This offer no explanation to user as to what the rule is and where they should seek help. There is two possible enhacement to this 
1. Add a rule name on the mail rule configuration diaog and show the name on the prompt as requested by this idea
2. Add the an action "Show customized prompt" on the mail rule configuration and display this configuration prompt instead of the current one.
 
Any further input to address this situation is welcome

Еще записи:
Интересные блоги специалистов:

Статьи и Документация

This document contains a copy of the two most recent editions of the newsletter titled "Support Content Highlights newsletter for IBM Lotus Notes, Domino, iNotes and Notes Traveler". Each newsletter contains links to new information and current key technical support documents that are frequently requested or identified by IBM Lotus Support as valuable. It also features content provided by Lotus Development, Lotus Education, and Lotus Information Development teams.
IBM will host an Open Mic conference call with Lotus Development and Support Engineers on 16 February 2011. The topic will be "Domino Designer XPages."
Previous Table of Contents Next body a name"top" a h2 font color"00000" Topics on this page include:h2font ullia href"Page3DeployingNotes8.5.1clientsoverview"Overview General Informationa lia href"Page3DeployingNotes8.5.1clientskey"Key Upgrade ...
Table of Contents: Optimizing Lotus Domino AdministrationTable of Contents At some point, you will most likely be in the position to expand your Domino Domain. Whether this is to add a Sametime or Traveler server into your domain or add an additional mail server; when you make your first ...
Table of Contents: Optimizing Lotus Domino AdministrationTable of Contents The Domino Attachment and Object Service (DAOS) is a new feature introduced in Domino 8.5. DAOS is a mechanism which shares identical attachments between databases on the same Domino server. When configured, separate ...
Table of Contents: Optimizing Lotus Domino AdministrationTable of Contents The Domino Configuration Tuner (DCT) is just one of many tools that are included with the Domino 8.5.x server and Administration client. It can also be downloaded for free from this site: ...
table class"lotusTable lotusInfoTable"trthh2 About this Redbooks wiki series h2thtrtrtd 0.1 Preface 0.2 About the Authors tdtrtable table class"lotusTable lotusInfoTable"trthh2 Part 1: Getting Started h2thtrtrtd 1.1 Documentation ...
Table of Contents: Optimizing Lotus Domino AdministrationTable of Contents The following tips will help Administrators to optimize their NotesDomino environment. It is important for Administrators to understand that any configuration change should be closely monitored for its effects. Make ...
Также почитатай:
Найти документацию можно на сайтах:
СсылкиУтилиты и программыСайты о Lotus Notes
В избранное