Computer Programming

Wednesday, February 4, 2015

ASP.NET Projects

February 04, 2015

Online GYM application project in ASP.NET

Admin Panel:

No need of admin registration form just provide username and password change option
Admin it self will register client details. So you have to provide client registration form for admin only(Need to provide insert, update and delete option for manipulating client details for admin except username and password)

Client Registration Form Details

1. Complete name

2. Email Id

3. Phone No

4. Date

5. Address

6. Height

7. Weight

8. Programs(Drop Down List)

When admin selects the type of program i.e cardio fitness, strengths, weight loss, personal trainer, cardio+strengths in another drop down list plans should populate

9. Plans

For example. Look at below video:

After Selecting Program and plan amount should display in text box.

1. Paid Amount

2. Amount Due=Plan amount-Paid Amount

3. Upload Image

4. Date(calendar)

5. Registration button and Cancel Button

Once registration is successful with all validations espically emailed and phone number. An email should send to that particular person with a welcome note along with username and password. Username as emailed and password as phone number.

Important Note: While client registration a Qrimage along with Unique qrcode and a excel sheet has to be generated. That excel sheet should contain the fallowing columns.

Sl.No, Name ,EmailId, Phone no, Emergency contact no, Address, Height, Weight, Selected Program, Selected Plan ,Amount paid, Due Amount

When ever new client registration is successful the existing excel sheet should Update with a new row. QrImages should be generated in separate folder with client name. Once admin will login he should be able to view his clients with respect to their programs.

Example:

Select Type Of program:---Select----(Assume it’s a drop down list)

Cardio

Strength

Personal Trainer

Weight Loss

Etc etc

Once admin click any of the above program i.e Strengths or cardio or weight loss or Personal trainer or any other register client should display w.r.to that program only.

Once admin select the client it should ask for edit profile option or display client info.

Tuesday, February 3, 2015

ASP.NET

February 03, 2015

Computer Programming: How to insert data into excel file in ASP.NET, Example

This article will cover, How to insert data into Excel spreadsheet using ASP.NET. First we need to connect Microsoft Excel workbook using the OLEDB.NET data provider. Add excel file path to connectionString. Now, your connectionstring will be look like

string connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("first.xls") + ";" + "Extended Properties=Excel 4.0;";

Here, you can connect .xls file using Microsoft.Jet.OLEDB.4.0 provider also insert data in it. In Data Source, you can take .xls file path.

You can follow some steps for inserting data into excel file.

Step 1: Open Visual Studio > File > New >Website, Under Templates, click ASP.NET WebSite and choose Visual C# as the language. Select a system location and click Ok.

Step 2: We will create excel sheet and add them to the website folder. Excel sheet will be created in Office 2003(first.xls).

Step 3: Add three columns called id, name and Address to the Sheet1. Also add some data into the columns. Once this excel file is created, add it to your website folder. To add them to the solution, right click website name > Add Existing Item > Add the excel file.

Insert data into excel file using asp.net

Step 4: Add a web form called 'excelfile.aspx' into the website folder.
Step 5: Add a label control to the 'excelfile.aspx' page.
Step 6: Insert Data into excel file using OLEDB

Complete code is

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="excelfile.aspx.cs" Inherits="excelfile" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<div>

</div>

<asp:Label ID="Label1" runat="server"></asp:Label>

</form>

</body>

</html>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.OleDb;

using System.Configuration;

using System.Data;

public partial class excelfile : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

string connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("first.xls") + ";" + "Extended Properties=Excel 4.0;";

OleDbConnection oledbconn = new OleDbConnection(connString);

try

{

oledbconn.Open();

OleDbCommand cmd = new OleDbCommand("insert into [Sheet1$] values('2','Jacob','USA')", oledbconn);

int a= cmd.ExecuteNonQuery();

if (a>0)

{

Label1.Text = "Data Inserted";

}

catch (OleDbException ex)

{

Label1.Text = ex.Message;

}

finally

{

oledbconn.Close();

}

Code generate following output

Data Inserted into excel file in asp.net

ASP.NET

February 03, 2015

How to bind Gridview from two Merged Data Table

Introduction

It is a combination of DataColumns and DataRow. Generally, we use it for data binding purpose. In this article we will learn how to design the DataTable , merge two DataTable and Bind the gridview control with merged DataTable. First of all, create the object of it then add some column in it. After define the columns you will enter data in the columns. We have already dicussed on this topic earlier. Today, we will focus on merge( ) method.

Add columns and rows in the DataTable (Copy and Paste)

DataTable datatable1 = new DataTable();

datatable1.Columns.Add("id", typeof(Int32));
datatable1.Columns.Add("Name", typeof(string));
datatable1.Rows.Add(1, "A");
datatable1.Rows.Add(2, "B");

Above code define, we have two column that is, id with integer DataType and Name with string DataType. Similarly, we can design code for second DataTable. Like

DataTable datatable2 = new DataTable();
datatable2.Columns.Add("id", typeof(Int32));
datatable2.Columns.Add("Name", typeof(string));
datatable2.Rows.Add(3, "C");
datatable2.Rows.Add(4, "D");

How to merge DataTable:

After preparing the DataTable, you should use Merge( ) method. Like

datatable1.Merge(datatable2);

Now, you have to bind the GridView with Merged DataTable.

GridView1.DataSource = datatable1;
GridView1.DataBind();

Now code Generate the following output:

How to bind Gridview from two Merged Data Table

Sunday, February 1, 2015

ASP.NET JavaScript

February 01, 2015

How to find controls from usercontrols in ASP.NET

Introduction

Today, when we was design a program with the help of web usercontrol. I was take two web usercontrols in the single web form (learn how to add web usercontrol in the aspx page) with a single button control. My code look like in the ASPX page:

<uc1:Register ID="Register1" runat="server" />
<uc2:login ID="login1" runat="server" />
<asp:Button ID="Button1" runat="server" Text="Find control" Width="483px" />

I want to access controls which is inside in user controls such as Button, TextBox, Label, Dropdownlist and etc. So, For this type of problem, i have a solution. Actually user control is a collection of controls or text and each control have a id property; also control have a runat attribute. So, easily we can access or find controls in the code file as well as in the <script> block. In this article i will explain you how to find the controls such as Button, Label, TextBox and etc from the user control

Find controls from user controls in the code file I-Method:

The Web User Control:

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="Register.ascx.cs" Inherits="MyControl_Register" %>

<asp:TextBox ID="usertxt" runat="server" Width="209px"></asp:TextBox>

The Page

The following HTML Markup of the ASPX Page contains the UserControl and a Button.

The button has an OnClick event handler which executes a click function which validates the TextBox usertxt present inside the UserControl Register.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default5.aspx.cs" Inherits="Default5" %>

<%@ Register src="MyControl/Register.ascx" tagname="Register" tagprefix="uc1" %>

<!DOCTYPE html>

</head>

<body>

<div>

<uc1:Register ID="Register1" runat="server" />

</div>

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Find control from user control" Width="483px" />

</form>

</body>

</html>

Code Behind file

protected void Button1_Click(object sender, EventArgs e)

{

TextBox t1 = Register1.FindControl("usertxt") as TextBox;

if(t1.Text == "")

{

Response.Write("<script>alert('please fill the username')</script>");

}

Find controls from user controls using java script II-Method:

Also we can find the controls such as Label, ListBox, etc., which is inside in user controls. But a little problem you and i face that is:

When i place an toolBox controls inside usercontrols then the HTML ID of the control which is inside in usercontrol changes. And hence Java Script is not determine the control so, it is unable to find the control. Suppose, you have a TextBox with ID usertxt in a web user control, render web form in the browser and see the html source view :

Solution of the problem

Use Embedded code block with ClientID property in the document.getElementById menthod.
Now, Your whole code look like

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default6.aspx.cs" Inherits="Default6" %>

<%@ Register src="MyControl/Register.ascx" tagname="Register" tagprefix="uc1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script>
function validate()
{
var t1 = document.getElementById('<%= Register1.FindControl("usertxt").ClientID %>');
if (t1.value=="") {
alert("Please fill username");
}
}

</script>
</head>
<body>
<form id="form1" runat="server">
<div>

<uc1:Register ID="Register1" runat="server" />

</div>
<asp:Button ID="Button1" runat="server" Text="Find control using java script" Width="451px" OnClientClick="validate()" />
</form>
</body>
</html>

If you want to see the full implementation and output, see this video:

c language Turbo C

February 01, 2015

Example programs showing pointer assignment, addition and subtractions in Data Structures through 'C'

Example programs showing pointer assignment, addition and subtractions:

1.’C’ program to read and print a dynamic array of the user required size:
#include<stdio.h>
#include<conio.h>
#include<stdlib.h>
main(),
{
int *arr, size, i;
/* arr is a pointer to store address of dynamically allocated memory*/
clrscr();
printf(“Enter the size of array :”);
scanf(“%d”,&size);
arr=(int*)malloc(size*sizeof(int));
/* dynamic memory allocation, pointer assignment operation */

If(arr= = NULL)
{
printf(“Memory allocation error!”);
exit(0); /*to terminate program execution */
} /*end of if*/
printf(“\n Enter array elements:”);
for(i=0;i<size;i++)
scanf(“%d”,arr+i); /*pointer
addition */
printf(“\nThe array is:\n”);
for(i=0;i<size;i++)
printf(“%d”,*(arr+i)); /*pointer
addition */

} /* end of main() */

NOTE: The array elements can also be referred as arr[i],
Where ’i’ is the index of the respective element.
The same program 1 for reading and displaying dynamic array can also be written with pointer subtraction as follows:

To read the array and display the array using pointer subtraction operation, the address of the last element is stored in a pointer variable and it is update accordingly by subtracting the respective index of the element to be read or displayed.
#include<stdio.h>
#include<conio.h>
#include<stdlib.h>
main(),
{
int *arr, size, i,*p;
/* arr is a pointer to store address of dynamically allocated memory*/
clrscr();
printf(“Enter the size of array :”);
scanf(“%d”,&size);

arr=(int*)malloc(size*sizeof(int));
/* dynamic memory allocation, pointer assignment operation */

if(arr= = NULL)
{
printf(“Memory allocation error!”);
exit(0); /*to terminate program execution */
} /*end of if*/

p=&a[size-1];/*address of the last element */
printf(“\n Enter array elements:”);
for(i=size-1;i>=0;i--)
scanf(“%d”,p-i); /*pointer subtraction*/

p=&a[size-1]; /*pointer assignment */
printf(“\nThe array is:\n”);
for(i=0;i<size;i++)
printf(“%d”,*(p-i)); /*pointer subtraction*/

} /* end of main() */

2.’C’ program to implement to searching using dynamic array:

#include<stdio.h>
#include<conio.h>
#include<stdlib.h>
main(),
{
float *arr, num; /*array of real numbers */
int size, i;
clrscr();
printf(“Enter the size of array :”);
scanf(“%d”,&size);
arr=(float*)malloc(size*sizeof(float));
if(arr = = NULL)
{
printf(Memory allocation error!);
exit(0); /*to terminate program execution */
} /* end of it*/
printf(“\nEnter array elements:”);
for(i=0;i<size;i++)
scanf(“%f”,arr+i); /*pointer addition */
printf(“Enter the real number to search in array:”);
scanf(“%f”,&num);
for(i=0;i<size;i++)
if(num==*(arr+i))
break; /*to terminate for loop */
if(i==size) /*if i=size then ‘break’ is not executed.
Element comparison is over */
printf(“Search unsuccessful…”);
else
printf(“Search successful…”);
} /*end of main() */

3.’C’ program to count the frequency of a number in a dynamic array.

#include<stdio.h>
#include<conio.h>
#include<stdlib.h>
main(),
{
float *arr, num; /*array of real numbers */
int size, i, count=0;
printf(“Enter the size of array :”);
scanf(“%d”,&size);
arr=(float*)malloc(size*sizeof(float));
if(arr == NULL)
{
printf(Memory allocation error!);
exit(0); /*to terminate program execution */
} /* end of it*/
printf(“\nEnter array elements:”);
for(i=0;i<size;i++)
scanf(“%f”,arr+i); /*pointer addition */
printf(“Enter the number, the freq. of which is freq.:”);
scanf(“%f”,&num);
/*finding the frequency */
for(i=0;i<size;i++)
if(num==*(arr=i))
count++; /*count incremented by 1, whenever the num is equal to
the array element */
printf(“\n Frequency of number %f is %d”,num,count);
} /*end of main() */

4.’C’ program to find the number of prime numbers stored in a dynamic array.

#include<stdio.h>
#include<conio.h>
#include<stdlib.h>
int prime(int num)
{
int i;
for(i=2;i<=num/2;i++)
if(num%i == 0) /*Non-prime */
return 0;
return 1; /*prime */
}
main()
{
int *arr, size, i, count=0;

printf(“Enter the size of array :”);
scanf(“%d”,&size);

arr=(int*)malloc(size*sizeof(int));
if(arr == NULL)
{
printf(“Memory allocation error!”);
exit(0); /*to terminate program execution */
} /* end of it*/
printf(“\nEnter array elements:”);
for(i=0;I<size;i++)
scanf(“%d”,arr+i); /*pointer addition */
for(i=0;i<size;i++)
if(prime(*(arr+i)) ==1)
count++;
printf(“\nNumber of primes = %d”,count);
} /*end of main() *

c language Turbo C

February 01, 2015

How to Perform Initialization of Two Dimensional Arrays in C language

Assigning required value to a variable before processing is called initialization. As we initialize a variable to the required value (for example, a=10), we can also initialize the individual elements of a two dimensional array. The initialization can be done at the time of declaration with the following syntax:

data_type array_name [exp1][exp2]={
                                 {a1, a2, a3, ……, an},
                                {b1, b2, b3, ……, bn},
                                {c1, c2, c3, ……, cn},
                                           .…………………………
                       };
Where

data_type can be int, float, char, etc.
array_name is the name of the array
exp1 and exp2 are enclosed within square brackets
a-1 to a-n are the values assigned to 1st row, b1 to bn are the values signed to 2nd row and so on.

Initializing all specified memory locations

Consider the initialization statement shown below:

int arr[3][3] = {{1, 2, 3},
{4, 5, 6},
{7, 8, 9}};

The declaration indicates that array arr has 3 rows and 3 columns. The pictorial representation of the two dimensional array is shown below:

How to Perform Initialization of Two Dimensional Arrays in C: Computer Programming

Note that a[0][0] = 1 and so on with increment the value of square brackets.

Partial array initialization

If the numbers of values to be initialized are less than the size of the array, then the elements are initialized from left to right one after other. The remaining locations will be initialized to zero automatically.

Example: int arr[3][3] = {(1,2),(3,4),(5,6),(7,8)};

The declaration indicates that the array arr has 3 rows and 3 columns in which only first column of each row are initialized. The 3rd column of each row bill be initialized with zeros automatically as shown in the following figure:

i.e., all arr[0][2], arr[1][2], arr[2][2] are initialized to zeros.

Example: Consider the partial initialization shown below:

int arr[3][3] = {{1,2,3,4},{5,6},{7,8}};

In this array each row should have three columns. But, in this example, we have initialized row 0 with 4 elements. This results in syntax error.

Memory Map: To represent the memory map of two dimensional array, consider the following two dimensional array declaration:
int arr[3][3] = {
            {1,2,3},
            {4,5,6},
            {7,8,9}
};

Even though we represent a matrix pictorially as a two dimensional array, in memory they are stored contiguously one after the other. Assume that address of first byte of arr (known as base address) is 12000 and size of integer is 2 byte. The memory map for the two dimensional array arr is shown in below figure:

c language Turbo C

February 01, 2015

How to Perform Initialization of Two Dimensional Arrays in C language

data_type can be int, float, char, etc.
array_name is the name of the array
exp1 and exp2 are enclosed within square brackets
a-1 to a-n are the values assigned to 1st row, b1 to bn are the values signed to 2nd row and so on.

Initializing all specified memory locations

Note that a[0][0] = 1 and so on with increment the value of square brackets.