C# Tutorial

I got a good tutorial about how to program with C#. This tutorial is not written by me, but this tutorial gave me a good reference when I was doing my project. This tutorial provides a basic understanding about how to program in C#. The example provided in this tutorial are using Console Application. You can download it here :

C# Tutorial

Best Regards
Admin

Inserting Data to a Table using ADO.NET in ASP.NET

I will share how to insert a row to a table using SQL Query in Microsoft SQL Server using ADO.NET and ASP.NET. In the previous course we learn about the basic of ADO.NET. We learn about how to query a data from a table in a database. The step can be summarized :

1. Open a connection to database
2. Specify the SQL Query to perform the operation
   
3. Execute the command

To insert a row we need to change the SQL Query. The general expression of SQL Query to insert a row is :

INSERT INTO table_name(fld1,fld2,...) VALUES ('value1', 'value2','value3',...)

And to perform this query, we need to use the method of ExecuteScalar(). The namespaces that need to be added to do this task are :

using System.Data.Sql;
using System.Data.SqlClient;

To summarize it, the code should be like this.

string connectionString = "Your connection String";
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();

SqlCommand command = new SqlCommand();

command.Connection = conn;
command.CommandText = @"INSERT INTO table_name(fld1,fld2)"+
"VALUES ('value1', 'value2')";

command.ExecuteScalar();
conn.Close();

At last a post again...

For a long time, I haven't updated my blog. Maybe since 1 month ago. Now, I try to update it again. There are some things I want to inform you all. I have thought this for some time. Maybe I will change the style of my blog giving tutorial or course. The course and tutorial will be posted in a post and you don't need to download the file. I will try to change this blog as a reference or maybe you can call it a simple handbook so that you can browse this web to find your solution if you have a problem.

I will also post an e-book or article or paper more actively from now on. There are some interesting e-book I got from the internet and I will share it to you all.

I hope that my blog gave benefit to you all. Also I want to apologize for the bad English that this blog used since I'm trying to improve my English by blogging.

Best Regards

Lil' Gariel

ASP.NET Web Development - Introduction

Here is a tutorial I created about Web Development using ASP.NET. This is a "step-by-step" tutorial that will explain in detail how to create a simple website using ASP.NET and Microsoft Visual Studio 2008.

For this first tutorial I explained about the basic of creating and connecting a database in ASP.NET web page.

This tutorial will provide you the basic knowledge how to use Microsoft Visual Studio 2008 in developing your website.

In this tutorial we will use the C# language to perform some function such as connecting to database when the page is loaded. We will use the System.Data.Sql and System.Data.SqlClient class to perform this function.

We will use SqlConnection class to create an object for connecting to a Database. This can be done with code :

string connectionString = "//the connection string can be obtained in database properties";
SqlConnection connect = new SqlConnection(connectionString);
connect.Open()

In this tutorial, to read a database we will use SqlCommand and SqlDataReader class.
To read data from a table in the database can be done with the code :

SqlCommand command = new SqlCommand();
command.Connection = connect;
command.CommandText = "//this is the SQL Query needed";
SqlDataReader reader = command.ExecuteReader();

while(reader.Read())
{
//The code here..., to access a data in a field use the syntax -> reader["field_name"]
}

In this tutorial, to display a content to the web page we will use the InnerHtml attribute with this code :

string HTMLcode = "//a string that contain HTML tag to display some content";
div_ID.InnerHtml = HTMLcode;

Above, is a brief explanation about the tutorial. For a complete tutorial you can download the file in pdf format and you can download the source code from the link below :

ASP.NET Tutorial1.pdf
Source Code.rar

In the mean time I also will post a notes about Operating System - Introduction. But I still need a little time to finish it.

Best Regards,

Admin

System - Description and Analysis

Well guys, this is the third notes about Linear Signal and System. The notes will gives you a brief explanation and description about System.

Some of the topics covered in this notes are :
1. Brief explanation and definition of System
2. Properties of System including Homogeinity, Additivity, Time Invariance, and Invertibility
3. Explanation about Linear System, some properties of Linear System including
Stability,Causality, Incremental Linearity, and Static/Dynamic System.
4. A brief explanation about Non-Linear System
5. A brief explanation about Feedback System
6. How to perform System type checking(How to check whether a system is linear or non-linear,
time invariant or time variant, causal and non-causal.

I also will provide an e-book Schaum's Outline About Signal and System. This e-book contains some of good exercise and simple explanation that will help you to understand the concept of Linear Signal and System. Some of the exercises in the previous notes were also taken from this e-book.

Maybe I will list some of key points in this note :

- A system has excitation(input) and response(output)

- A system has some properties :
1. Homogeinity : multiplying an input by a constant simply result in multiplied output by that
constant too.
2. Additivity : summing some input simply will cause a response that is the sum of the
response of each input.
3. Time Invariance : delaying an input to a system simply will cause a delayed ouput from the
system
4. Invertibility : unique input for a unique response

- A linear system is a system that is both homogenous and additive.

- A Linear Time Invariant System is a linear system that is Time Invariant

- A system said to be stable if the system has BIBO(Bounded Input and Bounded Output)

- A system said to be Causal if the system's response doesn't depend on input from the future
time, the system's response at a time only depends from the input up to that time.

- Incremental Linearity means a Linear System that have initial condition as an offset added to
the response.

- Static System is a system said to have no memory. The response at a time only depends on
arbitrary excitation at that time

- Dynamic System is a system said to have memory. The response at a time also depends on
excitations at another time.

- Non-Linear System is a system whose the relationship of the amplitude of excitation and
response are not linear. An example of Non-Linear System is a product of 2 system(using
Analog Multiplier)

- Feedback System is a system whose have an output at a time that will act as another input
beside the excitation at another time/state.

- Linearity check use the Homogeinity and Additivity properties :
u(t) = a . x(t) + b . y(t)

- Time Invariant check use the unit advance properties :
x[n + 1] = q . x[n]

Well that's some of key point that I think were important. You can just download the notes from the link belown for more specific explanation and solution, and also the ebook Schaum's Outline of Linear Signal and System :

Description and Analysis of System(4shared.com)
Schaum's Outline of Linear Signal and System Ebook(4shared.com)



Well sorry for the late post, hope you all get benefit from it.

Best Regards,

Admin

Take A Break while Doing Project

Well for this time, I got some work to do in a company. I got some project creating a website using ASP.NET. The bad news is I can't frequently updated my blog with new course/notes. The good news is I can provide some tutorial of ASP.NET Web Application Programming after I finished my project and my work.

Well it takes a lot of stamina to do my project and I got exhausted sometime. So I can't prepare a new notes. Actually I have prepared 2 notes, 1 about Analysis and Description of Signal(Linear Signal and System notes) and a notes about Introduction to Operating System(new notes). But I still working on them and maybe it will take a little more time to finish it.

Okay I think that is all for now. From now on I will not frequently updated my blog. Maybe I will concentrate on prepared some more notes and tutorial and I will post them together in one time after I finished it.

Best Regards,

Admin

Linear Signal and System - Transformation Of Signals

Well this is the second notes of Linear Signal and System. It gives a brief description about CT Signal and DT Signal Transformation.

There are 5 types of CT Signal Transformations :
1. Time Shifting Transformations
2. Time Scaling Transformations
3. Amplitude Scaling Transformations
4. Differentiation
5. Integration

In DT Signal, there are several transformations :
1. Time Shifting Transformations
2. Time Scaling Transformations
3. Differencing
5. Accumulating

In this notes there are some exercise that will illustrate each of the transformation above. The notes will also give a brief description of Multiple Transformation in CT Signal. The Multiple Transformation in DT signal has the same characteristics as in Multiple Transformation in CT Signal, however the variable t in g(t) is changed with variable n in g[n].

Well this is the PDF version of the notes :

Linear Signal and System - Transfomation of Signals.pdf

Linear Signal and System - Introduction

Well this is the first course about Linear Signal and System. The topic covered on the notes below is the definition of Signal, System, and some mathematical description of Basic Signal. The Basic Signal consist of :

- Unit Step Function(Continous Time and Discrete Time Signal)
- Signum Function(Continous Time Signal)
- Rectangle Function(CT and DT Signal)
- Impulse Function(CT and DT Signal)
- Triangle Function(CT Signal)
- Sinc Function(CT Signal)
- Dirichlet Function(CT Signal)

There are some key points added from my notes when I attended this lecture. This is the first part of the Linear Signal and System Course. Later I will post the course about Signal Transformation, Convolution, Fourier Transform, Laplace Transform and Z-Transform. There will be some exercise too and also the solution. But I still need some time to prepare it so I hope for the patience and sorry for the inconvenience.

The notes of the course can be downloaded here. It took longer than I expected to prepare this notes. The notes I created here is based on "Fundamentals of Signal and System" book by M.J. Roberts. The notes that can be downloaded below is in PDF file.

Download Link for the notes(4shared.com) :
Introduction - Mathematical Description of Signal.pdf

Exam Finally Over !!

Well I have just finished my semester exam. At least finished. Haha.
The good news are I can start creating the content of my blog. Maybe I will write a course about Linear Signal and System first.

This is out of my plan, but I have a special interest in this topic. This topic will give you a brief explanation about signal, system, signal transformation using Fourier, Laplace and Z-Transform. Since it's my hardest exam this semester, I still remember many of the topics. I will also give some example in form of question and the solution of course to help the reader in understanding the subject.

Anyway, from now on, my blog will be active. Feel free to visit and post a comment if you have any question. Each of the post will be labelled with the subject, for example : a course of Fourier Transform will be labelled Linear Signal and System. I think that's enough for now. I had a big hope that my post on my blog will give you information that you need.

Best Regards,

Admin

Welcome to Unives !!

Well this is my first blog. And it's mean that this is also my first post.
I decided to create a blog to provide lecture course with some summary and key concept to make all the reader easier to understand about some course in university. The course will be associated with ICT(Information Communication and Technology) since it is my study subject.

Maybe for the first time, some of the topics covered will be Operating System, Cryptography, and Linear Algebra. I will post some course and tutorial related to Computer Engineering subject too. Maybe the topic covered are Linear Signal and System and Microcontroller Programming using Assembly and 8051 MCU series and also Neural Networks. If possible I will also will give you free e-book(maybe in links) about the topic I write in future.

For the time being I will concentrate about making the summary and key concept of the course above. Maybe it will took some time, so I really hope that you all can be patient for that.

I hope you can enjoy and get benefit from my blog. Sometimes I will also post some tips and trick not only in ICT Technology(e.g. internet or computer) but it will also about real life, maybe recipe haha.

Well I think this is enough for the first post. Hope you all enjoy my blog.

Best Regards,
Admin