How to Retrieve Data from SQL Database: Windows Forms

In my previous post, I have created a connection object and then get all the records from the database table. What if we want to bind our datagridview without writing a single line of code? So in this article we will do something like this.


 Just drag-n-drop a datagridview on the form and name it, if you want. A datagridview tasks pop-up menu appears automatically as shown:

Select the Choose Data Source drop-down list and then Add Project Data Source as shown:

Now Data Source Configuration wizard will open, select Database as your data source. The wizard will look like:

By clicking on Next button, It will prompt for the database model you want to use. Select dataset, it will determines the type of data objects our application will use.

In the next step we have to choose our connection that is used by the application use to connect to the database.

Click on New Connection and it will prompt for Choose Data Source dialog box having some more options to select.

Select Microsoft SQL Server which is used to connect to MS SQL Server, and the data provider should be .NET Framework Data Provider for SQL Server. Add Connection dialog box will appear as shown:

Write the server name as given “(LocalDb)\v11.0”, and select appropriate database name from the drop down list below. I have select StockDb here. Just click on Test Connection to check our connection succeeded or not.

Press ok and it will show Data Source Configuration wizard again with the specified connection and also connection string.

Choose the table name from the tree view shown. I have select Groups table because I want to show the records of groups table. Finish now with selecting the data set name. If you will forget the dataset name, it will used the by default name.

It will show the datagridview binding with the columns names of groups table as shown in the above image. Now run the project and look out the records bind to the datagridview

As I have said above, we have not wrote a single line of code.

How to Enable Spell Check in TextBox: WPF

WPF Textbox control is used to input some value by the user at run time. Now it is not sure that the entered values are correct, it means user can write anything wrong in the textbox. So it is programmer’s job to check the value and correct it if wrong.

WPF textbox control provides a spell check functionality something same as MS Word. We have to use SpellCheck and Language property of the textbox. SpellCheck will enable the feature and language will decide the language in which spell check is to be performed.

<TextBox Width="300" Height="25" Margin="5"
Text="This si not teh correct line written by teh usre"
SpellCheck.IsEnabled="True" Language="En-Us">
</TextBox>

The code above will show a textbox with the given text. According to US English language, the textbox will place some red lines on the wrong words, as shown in the following image.

As in MS Word, when we right click on the wrong word, then it will show some help options in the context menu, as shown in the following image:

How to create user profile using Complex DataType in ASP.NET

User profile

A user profile is a collection of various properties that describes the information you want to store for a specific user. You can store the properties associated with a user in a user profile. The data that is stored in a profile can be accessed programmatically.

The profile feature in ASP.NET  allows you to define and store user-specific settings. In addition, a website can be more user friendly if it is customized according to the preferences of a user. For example, a shopping website displays the shopping cart that consists of the items that are frequently purchased by the user. To Induce such functionality, a website needs to retrieve and load the user’s data when the request for a Web page is made for the first time. After the request is completed, the current settings, such as the address and phone number of a user, must be stored on the server. Consequently, when  the same user request for the same Web page, the respective settings stored on the server corresponding to a user are retrieved.

The user’s profile is defined in the machine.config  or web.config file . The following Syntax of the web.config file contains the description of a user profile.

    <profile>

        <properties >

          <add name="Address" type ="string"/>

          <add name ="phone" type ="integer"/>

         

        </properties>      

       

       

      </profile>

The preceding syntax defines a profile by using properties in the web.config file. The <add> element defines the properties of a profile. The properties of a user profile consists of both simple data type and complex data types.

Lets take an Simple Example

Web.config file code

<system.web>
    <anonymousIdentification enabled ="true"/>
    <profile>
      <properties >
        <add name="name" type ="string" allowAnonymous ="true"/>
        <add name ="DOB" type ="dateofbirth" allowAnonymous ="true"/>

      </properties>



    </profile>
    <authentication mode="Forms" />
    <compilation debug="false" targetFramework="4.0" />

  </system.web>

Class File Code 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

/// <summary>
/// Summary description for dateofbirth
/// </summary>
public class dateofbirth
{ private string day;
        private string month;
        private string year;
        public string Day
        {
            get
            {
                return day;
            }
            set
            {
                day = value;

            }
        }
        public string Month
        {
            get
            {
                return month;
            }
            set
            {
                month = value;
            }
        }
        public string Year
        {
            get
            {
                return year;
            }
            set
            {
                year = value;
            }
        }
public dateofbirth()
{


}

}

Source code

<%@ Page Language="C#" %>

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

<script runat="server">

    protected void Button1_Click(object sender, EventArgs e)
    {
        Profile .name =TextBox1 .Text ;
            Profile .DOB.Day=TextBox2 .Text ;
            Profile .DOB.Month =TextBox3 .Text ;
            Profile.DOB.Year = TextBox4.Text;
    }
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>Your DateOfBirth is
    <%= Profile.DOB .Day %>/
    <%= Profile .DOB .Month  %>/<%= Profile .DOB .Year %><br />
    Your Profile Name is
    <%=Profile .name %>
    </div>
    Enter Name:<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

    <br />
    Enter Day:<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>

    <br />
    Enter Month: <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>

    <br />
    Enter Year : <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>

    <br />
    <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Submit" />
    <br />

    </form>
</body>

</html>

Output

Instance of class cann’t access member of the class within the class

“Clubing data member and member function known as class.”

lets take an Example

Class A

{

Data member;

Member function;

}

If we create instance of the class in other class, that instance cannot access member of the class

lets take an Example

Class B

{

A  obj=new A();

A.Datamember;  // Error  instance member cann’t access datamember within the class

}

Solution :

Every executable statementmust be in a definition block( inside a function , constructor)

Class B

{

A obj =new A();

Public B()

{

Obj.DataMember=value; // you can access the datamember

}

How to Use TextBox Control in WPF

The previous controls i.e. Label, TextBlock and etc. are used to display fix text in a window. Their text can be changed but through the programming, not by the user. Now to input some value by the user, or enable text editing, the text box control is used. The textbox control can contain only unformatted text in its text property.

<TextBox Width="200" Height=”25” Text="WPF Textbox control"></TextBox>

The above code will place a textbox control having width two hundred and above text in the textbox. The textbox is shown in the following image:

In the above textbox only one line can be written, means we can’t either enter a new line in to the textbox or cant inset more lines by default. To enable multiline, it have two properties to do that i.e. TextWrapping and AcceptReturn. To insert a multiline textbox, write following code:

<TextBox Width="200" Height="40" Margin="5" Text="WPF Textbox control" TextWrapping="Wrap" AcceptsReturn="True"></TextBox>

Now when we run and write some more lines, then it will show something like this:

In the next post we will enable spell check for this textbox control.

How to Apply style on control at runtime.

CSS introduction

CSS is a new web page layout method that has been added to HTML to give we developer more control over their desing and content layout. CSS allows a designer to create a standard set of commands(either embeded inside web page or from an external page) that controls the style of all subsequent pages.

With CSS you can add style (fonts , spacing, colors, size and links ) to web documents . Its more advanced techniques that controls the layout of the page without the use of tables or other cumbersome HTML.

 Lets take an simple example 

<%@ Page Language="C#" %>

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

<script runat="server">

    protected void Button1_Click(object sender, EventArgs e)
    {
        BulletedList1.Style.Add(" background-color", "blue");
        BulletedList1.Style.Add(" font-size", "xx-large;");
    }
 
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Button ID="Button1" runat="server" Text="Apply style"
            onclick="Button1_Click" Width="154px" />
        <asp:BulletedList ID="BulletedList1" runat="server">
            <asp:ListItem>Apple </asp:ListItem>
            <asp:ListItem>Mango</asp:ListItem>
            <asp:ListItem>Orange</asp:ListItem>
        </asp:BulletedList>
    </div>
    </form>
</body>
</html>

Output

How to access Html select tag in code file

HtmlSelect Class

The HtmlSelect class creates an HTML select control, which can display either a list box or a drop-down list box depending on its attribute. The items of the select control are stored in <option>elements inside the <select> element. As soon as you add a list box or drop-down list box to a Web form using HTML server controls, ASP.NET adds a default , empty <option> element to the <select> element. The HtmlSelect class gives you access to the HTML <select> element s in server code.

Properties of the HtmlSelect Class

DataMember  : Obtains or sets the set of data to bind to the HtmlSelect control from a DataSource with multiple sets of Data.

DataSource : Obtains or sets the source of information to bind to the HtmlSelect control.

DataSourceId : Obtains or sets the ID of the Data source control that the HtmlSelect control should use to retrieve its data source.

DataTextField : Obtains or sets the field from the data source to bind to the System.Web.UI.WebControls.ListItem.Text property of each item in the HtmlSelect control.

DataValueField : Obtains or sets the field from the data source to bind to the System.Web.UI.WebControls.ListItem.value property of each item in the HtmlSelect control.

InnerHtml : Obtains or sets the conect between the opening and closing tags of the control without automatically converting special characters to their equivalent HTMl entities.

Items : Obtains a collection that contains the item listed in an HtmlSelect control.

Multiple : Obtains or sets a value indicating whether multiple items can be selected concurrently in the HtmlSelect control.

Name : Obtains or sets the unique identifier name associated with the HtmlSelect control.

SelectedIndex : Obtains or sets the ordinal index of the selected item in an HtmlSelect control.

Size : Obtains or sets the height (in row ) of the HtmlSelect control.

Value : Obtains the value of the selected item in the HtmlSelect control or sets the SelectedIndex property of the control to the index of the first item in the list with the specified value.

Event of the HtmlSelect Class

ServerChange : Occurs when the select control is changed. You can handle this event on the server.

<%@ Page Language="C#" %>

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

<script runat="server">
    protected void click_server(object server, EventArgs e)
    {
        sp1.InnerHtml = Select1.Value.ToString();
        int i = 0;
        for(i=0;i<Select1 .Items.Count;i++)
        {
            if (Select1 .Items [i].Selected)
            {
                sp2.InnerHtml += Select1.Value.ToString();
            }
        }
    }

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    Please Select Item : <br />
        <select id="Select1" runat ="server" >
            <option value ="Apple" selected ="selected">Apple</option>
            <option value ="Mango">Mango</option>
                   <option value ="Orange">Orange</option>
        </select>
        <span runat ="server" id="sp1">
        </span>
        <span runat ="server" id="sp2">
        </span>
        <input id="Submit1" type="submit" value="submit" runat ="server" onserverclick ="click_server" />
    </div>
    </form>
</body>
</html>

Output