Computer Programming

Tuesday, March 25, 2014

March 25, 2014

Change Header border style as dotted of Gridview in ASP.NET

Make border dotted of GridView header row using BorderStyle property using property window. This style enumeration is applies on compile time. First bind Gridview with SqlDataSource control , after that make some changes in style properties. This example cover dotted border style. Some steps are:

Step-1 : Open Visual Studio IDE
Step-2 : Add New Webform into your project
Step-3 : Add Gridview control on design window.
Step-4 : Bind Gridview with SqlDataSource control, make changes in border style

Example of Headerstyle BorderStyle of Gridview in asp.net

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

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title></title>

</head>

<body>

<form id="form1" runat="server">

<asp:GridView ID="GridView1" runat="server" AllowPaging="True"

AutoGenerateColumns="False" DataKeyNames="Sno" DataSourceID="SqlDataSource1">

<Columns>

<asp:BoundField DataField="Sno" HeaderText="Sno" InsertVisible="False"

ReadOnly="True" SortExpression="Sno" />

<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />

<asp:BoundField DataField="address" HeaderText="address"

SortExpression="address" />

<asp:BoundField DataField="contactno" HeaderText="contactno"

SortExpression="contactno" />

</Columns>

<HeaderStyle BorderStyle="Dotted" />

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

DeleteCommand="DELETE FROM [userdataTable] WHERE [Sno] = @Sno"

InsertCommand="INSERT INTO [userdataTable] ([name], [address], [contactno]) VALUES (@name, @address, @contactno)"

SelectCommand="SELECT * FROM [userdataTable]"

UpdateCommand="UPDATE [userdataTable] SET [name] = @name, [address] = @address, [contactno] = @contactno WHERE [Sno] = @Sno">

<DeleteParameters>

<asp:Parameter Name="Sno" Type="Int32" />

</DeleteParameters>

<InsertParameters>

<asp:Parameter Name="name" Type="String" />

<asp:Parameter Name="address" Type="String" />

<asp:Parameter Name="contactno" Type="Int32" />

</InsertParameters>

<UpdateParameters>

<asp:Parameter Name="name" Type="String" />

<asp:Parameter Name="address" Type="String" />

<asp:Parameter Name="contactno" Type="Int32" />

<asp:Parameter Name="Sno" Type="Int32" />

</UpdateParameters>

</asp:SqlDataSource>

<div>

</div>

</form>

</body>

</html>

Code Generate the following output

March 25, 2014

How to use LINQ to SQL in ASP.NET

INTRODUCTION

LINQ to SQL is a component of .NET Framework, and is specifically designed for working with SQL server database. It provides a run-time infrastructure for managing relational data as objects. It allows you to write queries to retrieve and manipulate data from the SQL server. LINQ to SQL supports all the key functions that you would expect while developing SQL applications. You can retrieve the data from the database, insert, update, and also delete the information from the table. Your query expression is translated into parameterized SQL code, parameters are created, and the query is executed on the server. LINQ to SQL also supports transactions, views, and stored procedures. It also provides an easy way to integrate data validation and business logic rules into your data model.

LINQ to SQL is an object-relational mapping (ORM) framework that allows the direct 1-1 mapping of a Microsoft SQL Server database to .NET classes, and query of the resulting objects using LINQ. With the help of LINQ to SQL ORM mapping, the classes that match the database table are created automatically from the database itself and you can start using the classes immediately.

Let's take an simple Example

Step-1 : Add a LINQ to SQL class to the application

Step-2 : Right-click the Solution name in the solution explorer and select Add New Item from The context menu. This will open the Add New Item dialog box.

Step-3 : In the dialog box, select LINQ to SQL Classes and rename the file as my.dbml. Default name for LINQ to SQL class is DataClasses.dbml

Step-4 : Click Add

The object Relational Designer window opens. In this window, you can drag and drop the table from the server Explorer. The action will add the table to your application, and you can retrieve any data from the table. In this case, the products table from the database is added to the object Relational Designer window,

After you have added the table to the my.dbml file, you can find the code for the .aspx in the listing

Source code
<form id="form1" runat="server">
<div>
<asp:ListBox ID="ListBox1" runat="server" Height="97px" Width="98px"></asp:ListBox>
</div>
</form>

Code Behind Code
protected void Page_Load(object sender, EventArgs e)
{
myDataContext dc = new myDataContext();
var query = dc.usertables;
foreach (usertable item in query)
{
ListBox1.Items.Add(item.id.ToString() + " " + item.name);
}
}

Code generate the following output

If your .dbml name is my then your DataContext name is myDataContext. After adding the table into dbml file , your table name look in the dbml file.

c language

March 25, 2014

C program to sort 10 elements of an array and a list of 11 names in ascending order using selection sort technique

C program to sort 10 elements of an array in ascending order using selection sort technique.

#include<stdio.h>
#include<conio.h>
void se1_sort_ao(int arr[],int n)
{
int i, j, min, mops;
for(i=0;i<n-1;i++)
{
min = arr[i]; mpos = 1;
for(j=i+1; j<n; j++)
if(arr[j] < min)
{
min = arr[j]; mops = j;

}
arr[mpos] = arr[i]; arr[i] = min;
}
}
main()
{
int a[10], i;
printf("Enter 10 element of the array:\n \n");
for(i=0;i<10;i++)
scanf("%d",&a[i]);
printf("The array before sorting:\n \n");
for(i=0;i<10;i++)
printf("%d",a[i]);
sel_sort_ao(a,10);
printf("\n \n The array after sorting:\n \n");
for(i=0;i<10;i++)
printf("%d",a[i]);
}

C program to sort a list of 11 names in ascending order using selection sort technique.

#include<stdio.h>
#include<conio.h>
#include<string.h>
void se1sortstrao(char a[][20],int n)
{
int i, j, mops, k; char min[20];
for(i=0;i<n-1;i++)
{
strcpy( min,a[i]); mpos=i;
for(j=i+1; j<n; j++)
if(strcmp(a[j],min)<0)
{
strcpy(min,a[j]); mpos=j;

}
strcpy(a[mpos],a[i]); strcpy(a[i],min);
}
}
main()
{
char a[11][20];
int i;
clrscr();
printf("Enter List of 11 names:\n \n");
for(i=0;i<11;i++)
gets(a[i]);
selsortstrao(a,11);
clrscr();
printf("The List after sorting:\n \n");
for(i=0;i<11;i++)
puts(a[i]);
}

Monday, March 24, 2014

c language

March 24, 2014

'C' Function to implement 'selection sort' in ascending and descending order

‘C’ function to implement ‘selection sort’ in ascending order.

void se1_sort_ao(int arr[],int n)
{
int i, j, min, mpos;
for(i=0;i<n-1;i++)
{
min = arr[i]; mpos = i;
for(j=i+1;j<n;j++) /*selection of min element */
if(arr[j] < min)
{
min = arr[j]; mpos =j;
}
arr[mpos] = arr[i]; /*replacing min element */
arr[i] = min;
}
}

‘C’ function to implement ‘selection sort’ in descending order.

void se1_sort_ao(int arr[],int n)
{
int i, j, max, mpos;
for(i=0;i<n-1;i++)
{
max = arr[i]; mpos = i;
for(j=i+1;j<n;j++) /*selection of max element */
if(arr[j] > max)
{
max = arr[j]; mpos =j;
}
arr[mpos] = arr[i]; /*replacing max element */
arr[i] = max;
}
}

c language

March 24, 2014

Algorithm to implement selection sort ascending and descending order

Algorithm to implement selection sort (ascending order):

SELECTIONSORTAO(arr,n)
Repeat For I =1 to n-1 [n-1 passes]
MIN <-- arr[I]
POS <-- I
Repeat for J=I+1 to n [to select minimum element]
If arr[J]< MIN Then:
MIN <-- arr[J]
POS <-- J
[ End of if ]
[ End of for J ]
arr[pos] <-- arr[I]
arr[I] <-- MIN
[End of For I ]
Exit.

Algorithm to implement selection sort (descending order):

SELECTIONSORTDO(arr,n)
[‘arr’ is an array of n elements]
Repeat For I =1 to n-1
MAX <-- arr[I]; POS <-- I
Repeat for J=I+1 to n
If arr[J]>MAX Then:
MAX <-- arr[J]; POS <-- J
[ End of if ]
[ End of for J ]
arr[pos] <-- arr[I]; arr[I] <-- MAX
[End of For I ]
Exit.

March 24, 2014

How to use LINQ projection Operators in ASP.NET

Introduction

Projection operators are used to transform an object into a new object of a different type. By using the Projection operators, you can construct a new object of a different type that is built from each object. The Select and SelectMany clauses are the Projection operators used in LINQ.

The Select operator performs a projection over a sequence and projects the value that is based on a transform function. The Select operator in LINQ performs function just as the Select statement in SQL. The Select operator specifies which elements are to be retrieved. For example, you can use the Select clause to project the first letter from each string in a list of strings. The syntax of using the Select clause is:

public static lEnumerable<S> Select<T, S>( this IEnumerable<T> source, Function<T, S> selector);

The second type of Projection operator used in LINQ is the SelectMany operator. The SelectMany operator projects a sequence of values that are based on a transform function and then organize them into one sequence. The syntax of using the SelectMany clause is:

public static IEnumerable<S> SeIectMany<T, S>( this IEnumerable<T> source, Function<T, IEnumerable<S»selector);

You must be wondering about the difference between the Select and SelectMany operators. The Select and

SelectMany operators are both used to produce a result value from a source of values. The difference lies in

the result value. The Select operator is used to produce one result value for every source value. The result

value is a collection that has the same number of elements from the query.

In contrast, the SelectMany operator produces a single result that contains a concatenated collection from the query.

Let's take an simple example of SelectMany Clause

Source view

<form id="form1" runat="server">

<div>

<asp:Button ID="Button1" runat="server" Text="Select Many Clause"

onclick="Button1_Click" />

<br />

</div>

<asp:ListBox ID="ListBox1" runat="server" Height="169px" Width="108px">

</asp:ListBox>

</form>

Code Behind View
protected void Button1_Click(object sender, EventArgs e)
{
string[] mytext = new string[] { "Hello world", " this is simple", "example of projection operator" };
IEnumerable<string[]> myword = mytext.Select(x => x.Split(' '));
foreach (string[] item in myword)
foreach (string wr in item)
ListBox1.Items.Add(wr);

}
Code Generate the Following Output

ASP.NET

March 24, 2014

How to make custom password change control in asp.net

Introduction

This control is designed for authenticated user, he/she can change own profile password. Basically, it have three fields, such as old password field, New password field, and retype password field. Looking like

If your old password doesn't match with stored data then new password will not update. Id password match with stored data then your new password will be updated.

Algorithm behind the program

Step-1 : First of all match your old password with table data using user_id, which is unique. For that, we will create a SELECT query.
Step-2 : Result of Select Query match with Text Box, which is defined for old password.
Step-3 : If Your inputted password is matched with fetched data, which is fetched from select query.
Step-4 : Design update query and will change your old password with new one.

Programming code

Step-1 : Create connection from SqlEngine using SqlConnection class, which is inside in System. Data. SqlClient namespace.

SqlConnection con;
con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();

Step-2 : After establishing connection, check data which is inside in database table. Check data using SqlDataReader , if data is already exist in table, will not update new password with old. If doesn't exist data in table , update database table

private void checkold()
{
con.Open();
cmd.CommandText = "select * from Register";
cmd.Connection = con;
rd = cmd.ExecuteReader();
while (rd.Read())
{
if (rd["Password"].ToString() == oldpwd.Text && rd["Email"].ToString() == Session["email"].ToString ())
{
flag = false;
break;
}

}
if (flag == false)
{
con.Close();
updatepassword();
}
else
{
Label1.Text = "Password doesn't match";
Label1.ForeColor = System.Drawing.Color.Red;
}
}

Step-3 : Update database table with new one password

private void updatepassword()
{
con.Open();
cmd.CommandText = "update register set Password=@pass where email=@em";
cmd.Parameters.AddWithValue("@pass", pass.Text);
cmd.Parameters.AddWithValue("@em", Session["email"].ToString());
cmd.Connection = con;
int update = cmd.ExecuteNonQuery();
if (update >0)
{
Label1.Text = "Password Update";
Label1.ForeColor = System.Drawing.Color.Green;
}
else
{

Label1.Text = "Error";
Label1.ForeColor = System.Drawing.Color.Yellow;

}
}

Code Generate the following output

How to make custom password change control in asp.net