Monday, June 6, 2011

Skin file in

How to apply Skin file to aspx page in

Skin file is similar to the css. But the difference between the css and skin file is that in css you create one class and assigns the class to each and every controls for which you want that kind of formatting.

For example:
If you create the following class in css file

      font-family:Arial Black;

And if you want apply this formatting to all of the textboxes in your website then you have to set the property for all the textbox like shown below.

<asp:TextBox ID="TextBox1" runat="server" CssClass="prop">asp:TextBox>

And also have to call the stylesheet file in tag as shown bellow.

<link href="StyleSheet.css" rel="stylesheet" type="text/css" />

But it is very tedious task because suppose your website contains large number of textboxes. Then it is very boring work to assign class=”prop” to each and every textboxes in website.

The solution of this problem is skin file provided by .net framework. Skin file will apply dynamically. I mean to say all the formatting will apply on run time not on designing time.

I hope now you are able to find the use of skin file over css file.

So let’s start how to use skin file and advantages of skin file.

1.To add new skin file Right click on web site-->add new item.
Select skin file. Give appropriate name to skin file. And click on ok

2.By clicking on ok it’ll ask for creating new folder for Theme. Click yes and it’ll create one new folder in Solution explorer named App_Themes under which there will be folder of your skin file.

3.It will open one file in which all the code will be in comment or in green colors. Please delete all the code.

4. Now we are ready to write a code.

Now go to your design page(.aspx). Set all the properties whichever you want to any one textbox. For example I want following formatting for all the textboxes.

Font-Names="Arial Black"
ForeColor="Blue"(Font color)

For that set these properties for any one textbox as shown below.

<asp:TextBox ID="TextBox1" runat="server" Font-Bold="True" Font-Names="Arial Black" Font-Size="Medium" ForeColor="Blue">asp:TextBox>

After assigning these property, copy this code(above textbox code) and paste in the blank skin file.

After that delete the ID property of textbox
So in skin file the code will like

<asp:TextBox runat="server" Font-Bold="True" Font-Names="Arial Black" Font-Size="Medium" ForeColor="Blue">asp:TextBox>

Then save the skin file and remove the formatting from the textbox in your designing page. So in designing file the code of textbox will be

<asp:TextBox ID="TextBox1" runat="server" >asp:TextBox>

Now skin file is ready.
Now we have to apply this skin file to our page.
So open the property of .aspx page. And set the Theme property to our skin file name.

Another way to do this is -----> go to source of page and in this code the first line will be of page directive <%@ page…………….%>

In this tag add the skin file name like Theme=”Skinfile name”

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" Theme="SkinFile" %>

After doing this you will find there is no change in the design. Property is no applied to controls. It is just because I told you earlier skin file it applied dynamically or at run time.

Now run the web site you will find that all the properties are applied to all textboxes.

Now on every page on which you want same formatting for textboxes just apply skin file for that page by either of two way i explained above.

Please try this article and let me know in case of you have any doubt about skin file or leave your doubts in comment or you can drop a mail to

Wednesday, May 25, 2011

Read Data From an Excel File (.xlsx) in ASP.NET

In this article, we will see how to display data from an Excel spreadsheet using ASP.NET. We will connect to a Microsoft Excel workbook using the OLEDB.NET data provider, extract data and then display the data in a GridView. Let us get started.

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

Step 2: We will create two excel sheets and add them to the project. One excel sheet will be created in Office 2003(.xls) and the other one using Office 2007(.xlsx). Add 4 columns called EID, EName, Age and City to the ‘Sheet1’. Also add some data into the columns. Once these excel files are created, add them to your project. To add them to the project, right click project > Add Existing Item > Add the two excel files.

Step 3: We will now create a web.config file if not already there to store the connection string information. Right click project > Add New Item > Web.config. Add the following entries to the file

            <add name="xls" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Sample1.xls;Extended Properties=Excel 8.0"/>
            <add name="xlsx" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Sample.xlsx;Extended Properties=Excel 12.0"/>

Ensure that you mentioned the whole path of the excel file i.e.c:/MyProject/sample1.xls etc..

As you can observe, the connection string for xlsx (Excel 2007) contains Microsoft.ACE.OLEDB.12.0 as the provider. This is the new Access database engine OLE DB driver and is also capable of reading Excel 2003.

Step 4: Add a GridView to the Default.aspx page. We will extract  data from the excel file and bind it to the GridView.

Step 5: Let us now create a connection to the excel file and extract data from it. Before that add a reference to System.Data.OleDb;

Please mention the exact sheet name + $ in query as in the excel file.

    protected void Page_Load(object sender, EventArgs e)
        string connString = ConfigurationManager.ConnectionStrings["xls"].ConnectionString;
        // Create the connection object
        OleDbConnection oledbConn = new OleDbConnection(connString);
            // Open connection

            // Create OleDbCommand object and select data from worksheet Sheet1
            OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", oledbConn);

            // Create new OleDbDataAdapter
            OleDbDataAdapter oleda = new OleDbDataAdapter();

            oleda.SelectCommand = cmd;

            // Create a DataSet which will hold the data extracted from the worksheet.
            DataSet ds = new DataSet();

            // Fill the DataSet from the data extracted from the worksheet.
            oleda.Fill(ds, "Employees");

            // Bind the data to the GridView
            GridView1.DataSource = ds.Tables[0].DefaultView;
            // Close connection


All set!! Run the application and see the data getting displayed in the GridView. If you want to target the Excel 2007 sheet, just change xls to xlsx in the ConfigurationManager.ConnectionString. 

Please let me know in case of you have any query in this article.

Saturday, May 7, 2011

How Insert data in Database in PHP

Hello Friends,
            In previous two blog we studied how to create database and how to connect with that database in PHP MySql. Now in this blog we are going to learn something very important for any site and that is How to enter or store the data in the database in PHP. In very simple word fill the registration form and click on the submit button  and data is stored in the database. So in this blog we are going to do the same thing. So let's start.

To perform this task we have to follow the following steps and you will get it very easily.
1. Fetch the data from the previous page using "name" property of input tag.
2. Write the query for insert the data in the database(simple insert query).
3. Execute(Run) that query.

That's it.

Let describe each step in detail. As I said earlier we will use the "StudentMaster" as 'our database and "StudentInfo" as our table of database.First of I tell you the fields (Columns ) of the table. ID(auto increment),FName,LName,PhoneNumber,EmailId,Password.

1. Fetch the data from the previous page using "name" property of input tag.
Let me show what is meaning of name property.
For example in previous page you have written "input ytpe="text name="FName"" then you have to fetch the value using the name propery i.e.FName.

You can fetch the value using GET,POST and REQUEST.If you are passing value using GET, you can fetch using GET and REQUEST. Same as you are passing value using POST,you can fetch using POST and REQUEST. So every time we will use REQUEST to fetch value irrespective of which method we used to pass the value. To fetch value following is the syntax.
$variablename=$_REQUEST/GET/POST['name property'];

So here to fetch the value of FName 
fetch the value of ecach and every input as shown below:

2. Write the query for insert the data in the database(simple insert query).
Now we have all the value to insert in the database. All the value we have stored in the respective variable name. We will use those variable. 
Simple insert query looks like :
insert into tblname(columns name) values ('values');
So in our example
$query="insert into StudentInfo (FName,LName,PhoneNumber,EmailId,Password) values ('$fname','$lname',$phone,'$email','$pass')";
Where $query is variable to store the query.

3.Execute(Run) the query.
We created the insert query in second step and we will run in this step.
To run the query we have MySql inbuilt function mysql_query(query)
So the final statement will be
mysql_query($query) or die ( mysql_error());
Where $query is our query created in step  and die I explained in previous blog.

So the final code is 


$query="insert into StudentInfo (FName,LName,PhoneNumber,EmailId,Password) values ('$fname','$lname',$phone,'$email','$pass')";

mysql_query($query) or die (mysql_error());

So please try this code and leave the comment if you like or If you have any doubts.
I'll wait for your response.

Sunday, May 1, 2011

How To Connect with database in PHP

Hello Friends,
                In previous blog we studied how to create the database in mysql for PHP.In this blog we'll see how to connect with the database in PHP means how to make a connection with our database using PHP.

Simple step to follow for inserting the data in database using PHP.
1.Create A connection with your Database.
2.Fetch the value from the Form using the name property of input.
3.Create the query for insert.
4.Execute(Run) the query.

In this whole blog,we'll use the "StudentMaster" as database and "StudentInfo" as table.And mind the whatever starts with $ sign is variable for temporary use.

So let's start with the first step.

1.Create A Connection With Your Database.
    In this step there are two steps.
    A. Create the connection with MySql server.
           For that there is code of only on line and that is.
            Here $con is variable.We are storing this connection in this variable for further use.
            --"mysql_connect" is mysql function for making connection with MySql server.
            --"localhost" is that where you are running your application.
            --If you are running in your system itself,it will always localhost.
            --"root" is user name.By default when you install the wamp server one user is creates that is root.
            --"" is the password for "root" user. By default is "";
            --Now we have connection with MySql server.
      B.Select your database from MySql server and make connection.
            For that the code is as follows.
                      $db=mysql_select_db("StudentMaster",$con) or die ( mysql_error());
            Here as I explained above $db is just a variable to store the value.
            --"mysql_select_db" is MySql is a function for selecting our database from MySql server.
            --"StudentMaster" is our database name.Type your database name whatever it is.
            --$con is our connection with MySql server as explained above.
            --or is the "or" operator means either left side or right side will run.
            --It means that either "mysql_select_db" will run or "mysql_error()" will run.
            --If "mysql_select_db" fails to run then "mysql_error()" (inbuilt error function of MySql) will run and  tell you the exact error what it is.

Whole code looks like
       $db=mysql_select_db("StudentMaster",$con) or die (mysql_error());

------->How we are connected with the database and ready to use.In next blog we'll learn how to insert data in the database.
------->In this blog if you have any problem or you face any problem while connecting with database let me know.
------->Please leave a comment if it is useful to you.

------->We'll meet soon again.

Saturday, April 30, 2011

How To Create Databse in MySql for PHP

Simple steps for creating the database in MySql for PHP.Just follow the below steps.

1.Start the wamp server and then select the localhost from wamp server pop menu as shown in below figure or just type the http://locahost/ .

2.After selecting localhost or typing http://localhost you'll get the home page of the PHP as shown in figure.

3.Select the phpmyadmin from the Tools and you will get the phpmyadmin home page.

4. Write down the your database name and click on create as shown below.

5.After clicking on the create button you will get the new window in which you will have to enter the Table name and number of columns in the table as shown in figure.Enter the Table Nameand Column Name and click on the GO.

6.After clicking the GO you will get the screen in which you will have to enter the all information of each and every column(column name,data type and size).
Sample is given below.

Field Type Length/Values
Mobile_No DECIMAL 10,0

7.Rules for the field name.
  1. Field name should be start with a-z,A-Z or _.
  2. Field name should not be start with 0-9 or any other special character like @,#,$.
  3. Field name should not be a any reserved words of the mysql like int,varchar,decimal etc...
  4. If the data type of the field are INT,TINYINT,BIGINT,DATE,DATETIME,then there is no need to give a size.Just leave the Length/Values column blank for those field as shown in the example for the ID field.
  5. If the data type of the field is the DECIMAL, then enter the size as shown in example.Digits before point,digits after point.
  6. If you want to define any field as Primary key then select the primary key radio button on the right side.
8. After inserting details of all the field the just click on the Save.

9.After clicking on the Save button your data base is ready to use with PHP page.

I'll explain you how to use database in the PHP page in the next BLOG.

If you like this blog and helpful to you then leave the comment for this blog that will help me to continue with BLOG .Waiting for response.

Also let me know in case of you have any problem in creating the database using these steps.

Saturday, March 5, 2011

Stored Procedure In

1.Add using Syste.Data.SqlClient namespace.

2.Create a connection string for that.
Right click on your database(in server emplorer) and properties.
Copy the connection string property of database.

3.In your code right SqlConnection con=new SqlConnection(@"copy connection string here");

4.Now create a command
SqlCommand cmd=new ("StoredProcedureName",con);

5.Set commandtype of cmd

6.Add the parameter one by one
For example My stored procedure accepts two parameter name and address then pass as follows:
cmd.Parameters.add(new parameters("@name",SqlDbType.Varchar,size).value=textbox1.text;
cmd.Parameters.add(new parameters("@address",SqlDbType.Varchar,size).value=textbox2.text;

6.Now Open the connection by con.Open();

7.Execute the command by cmd.ExecuteNonQuery();

8.Close the connection by con.close();