Computer Programming

Sunday, August 9, 2015

August 09, 2015

How to bind Dropdownlist from all countries name in asp.net c#

In this article i will show you how to bind the dropdownlist to countries name. You can say load dropdownlist from countries names like United State, United Kingdom etc in asp.net c#. By the System.Globalization namespace you can bind dropdownlist to countries name in asp.net c#.
In previous article i explained some topics on dropdownlist:

Source code of this article:

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

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="DropDownList1" runat="server" Height="28px" Width="118px"></asp:DropDownList>
</div>
</form>
</body>
</html>

Code Behind:

using System;
using System.Collections.Generic;
using System.Globalization;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class BindCountries : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
List<string> countries = new List<string>();
CultureInfo[] culture = CultureInfo.GetCultures(CultureTypes.SpecificCultures);
foreach (CultureInfo item in culture)
{
RegionInfo region = new RegionInfo(item.LCID);
if(!(countries.Contains(region.EnglishName)))
{
countries.Add(region.EnglishName);
}
}
countries.Sort();
DropDownList1.DataSource = countries;
DropDownList1.DataBind();
}
}
}

Above mentioned code define the following:
I have a list with string type, bind this English name of all countries name using System.Globalization namespace. First to bind array with the all cultures, now from all cultures you can get specific region.

Code generate the following output

How to bind Dropdownlist from all countries name in asp.net c#

Thursday, July 30, 2015

WPF

July 30, 2015

How to bind a TextBox to an instance of a custom class object in WPF

If you want to bind the text box with the instance of customer class object also call one way binding in wpf. first to add a cs class in the project. In which you should take one or more public properties , i will take two public properties and one static method. That static method will return class object. Now, your code look like:

1. Add a Class in the project also paste the below mentioned code. But remember that your class name is match with csharp file name; namespace name match with code.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SplashSCreen
{
public class Student
{
public string Name { get; set; }
public string Email { get; set; }
public static Student GetRecord()
{
var student = new Student();
{
student.Name = "Jacob";
student.Email = "narenkumar851@gmail.com";
};
return student;
}
}
}

2. Add a new window in the project.
3. Paste this code inside the grid of window class.

<Grid>
<TextBox x:Name="textBox" HorizontalAlignment="Left" Height="23" Margin="49,45,0,0" TextWrapping="Wrap" Text="{Binding Path=Name}" VerticalAlignment="Top" Width="120"/>

<TextBlock x:Name="textBlock" HorizontalAlignment="Left" Margin="49,21,0,0" TextWrapping="Wrap" Text="Name:" VerticalAlignment="Top"/>

<TextBlock x:Name="textBlock_Copy" HorizontalAlignment="Left" Margin="52,73,0,0" TextWrapping="Wrap" Text="Email:" VerticalAlignment="Top"/>

<TextBox x:Name="textBox_Copy" HorizontalAlignment="Left" Height="23" Margin="49,107,0,0" TextWrapping="Wrap" Text="{Binding Path=Email}" VerticalAlignment="Top" Width="120"/>

</Grid>

4. Add the business logic code in csharp file

namespace SplashSCreen
{
/// <summary>
/// Interaction logic for bindtext.xaml
/// </summary>
public partial class bindtext : Window
{
public bindtext()
{
InitializeComponent();

DataContext = Student.GetRecord();

}

}
}

Now , code generate the following output

How to bind a TextBox to an instance of a custom class object in WPF

Wednesday, July 29, 2015

WPF

July 29, 2015

Splash Screen in WPF example

The means of splash screen is a screen through which we can show the booting process of a thread. When you start your computer then first to load booting process after then load operating system. I will do the same thing in wpf. This screen appear before loading the start page. So lets to start it:

1. First to add a new window in the project.
2. Add these properties inside window tag.

Title="SplashScreen"
Height="300"
Width="300"
ResizeMode="NoResize"
WindowStyle="None"
WindowStartupLocation="CenterScreen"
Background="Green"
BorderThickness="8"
BorderBrush="Black"

3. Now, you complete code is:

<Window x:Class="SplashSCreen.SplashScreen"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:local="clr-namespace:SplashSCreen"
mc:Ignorable="d"
Title="SplashScreen" Height="300" Width="300" ResizeMode="NoResize" WindowStyle="None" WindowStartupLocation="CenterScreen" Background="Green" BorderThickness="8" BorderBrush="Black">

4. Add a label control in the page with content, like

<Grid>
<Label x:Name="label" Content="Data Uploading......." HorizontalAlignment="Left" Margin="37,128,0,0" VerticalAlignment="Top" Width="187"/>

</Grid>

5. Now, add this code in the app.xaml.cs file

App.xaml.cs file

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Diagnostics;
using System.Linq;
using System.Threading;
using System.Threading.Tasks;
using System.Windows;

namespace SplashSCreen
{
/// <summary>
/// Interaction logic for App.xaml
/// </summary>
public partial class App : Application
{
private const int min_spl_time = 4000;
protected override void OnStartup(StartupEventArgs e)
{
SplashScreen splash = new SplashScreen();
splash.Show();
Stopwatch timer = new Stopwatch();
timer.Start();
base.OnStartup(e);
MainWindow main = new MainWindow();
timer.Stop();
int remaining_time = min_spl_time - (int)timer.ElapsedMilliseconds;
if (remaining_time > 0)
Thread.Sleep(remaining_time);
splash.Close();
}
}
}
Here SplashScreen is the name of window or you can say class name.

WPF

July 29, 2015

Delete DataGrid row from DataGrid using entity framework(EDMX file) in WPF

Before deleting the data from the dataGrid, first to load the DataGrid using Edmx file. This is done in previous article. In this article we have new column that is DataGridTemplateColumn , in which we have cell template. When we click on button then row is deleted from DataGrid. Before deleting data from DataGrid , access emp_id from selected row .

<Window x:Class="SplashSCreen.bindgridpanel"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:local="clr-namespace:SplashSCreen"
mc:Ignorable="d"
Title="bindgridpanel" Height="300" Width="300">
<Grid>
<DataGrid CanUserDeleteRows="True" AutoGenerateColumns="False" ColumnWidth="*" x:Name="dataGrid" HorizontalAlignment="Left" Margin="54,56,0,0" VerticalAlignment="Top" Height="178" Width="173">
<DataGrid.Columns>
<DataGridTextColumn Binding="{Binding Emp_Id}" Header="Emp_Id" />

<DataGridTextColumn Binding="{Binding Emp_Name}" Header="Emp_Name" />
<DataGridTemplateColumn>
<DataGridTemplateColumn.CellTemplate>
<DataTemplate>
<Button Content="Delete" x:Name="dlt_button" Click="dlt_button_Click"></Button>

</DataTemplate>
</DataGridTemplateColumn.CellTemplate>
</DataGridTemplateColumn>
</DataGrid.Columns>

</DataGrid>

</Grid>
</Window>

Codebehind model

using System.Linq;

using System.Windows;

namespace SplashSCreen

{

/// <summary>

/// Interaction logic for bindgridpanel.xaml

/// </summary>

public partial class bindgridpanel : Window

{

TutorialEntities TE = new TutorialEntities();

public bindgridpanel()

{

InitializeComponent();

loadgrid();

}

private void loadgrid()

{

var data = from d in TE.emps select d;

dataGrid.ItemsSource = data.ToList();

}

private void dlt_button_Click(object sender, RoutedEventArgs e)

{

int empid = (dataGrid.SelectedItem as emp).Emp_Id;

emp employee = (from r in TE.emps where r.Emp_Id == empid select r).SingleOrDefault();

TE.emps.Remove(employee);

TE.SaveChanges();

dataGrid.ItemsSource = TE.emps.ToList();

}

}

Code Generate the following output

Delete DataGrid row from DataGrid using entity framework(EDMX file) in WPF

Tuesday, July 28, 2015

WPF

July 28, 2015

Bind DataGrid using Entity framework (EDMX model) in wpf

In this article we will learn how to bind DataGrid using EDMX file in wpf. I already bind dataGrid in window form using EDMX. In both article, i notice that only one difference between both that is xaml file. Lets to start to design this in wpf:

<Window x:Class="SplashSCreen.bindgridpanel"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:local="clr-namespace:SplashSCreen"
mc:Ignorable="d"
Title="bindgridpanel" Height="300" Width="300">
<Grid>
<DataGrid AutoGenerateColumns="False" ColumnWidth="*" x:Name="dataGrid" HorizontalAlignment="Left" Margin="54,56,0,0" VerticalAlignment="Top" Height="178" Width="173">
<DataGrid.Columns>
<DataGridTextColumn Binding="{Binding Emp_Id}" Header="Emp_Id" />

<DataGridTextColumn Binding="{Binding Emp_Name}" Header="Emp_Name" />

</DataGrid.Columns>

</DataGrid>

</Grid>
</Window>

Above mentioned code define the binding structure. I have one dataGrid control in the window. x:Name is a property of each control which is define the class instance , through which we can access other property of control in business logic. I have two Text column in dataGrid which take two attribute first one is Binding and another one is Header. Header represent the DataGrid column name and binding define the actual name of database table column's name.

Note : Before going to code behind must to add EDMX file in the project.

using System.Linq;
using System.Windows;

namespace SplashSCreen
{
/// <summary>
/// Interaction logic for bindgridpanel.xaml
/// </summary>
public partial class bindgridpanel : Window
{
TutorialEntities TE = new TutorialEntities();
public bindgridpanel()
{
InitializeComponent();
loadgrid();
}

private void loadgrid()
{

var data = from d in TE.emps select d;
dataGrid.ItemsSource = data.ToList();
}
}
}

Code generate the following output

Bind DataGrid using Entity framework (EDMX model) in wpf

After add the edmx file in the project , you can access the public property of context class (here i have 'emps'). Through which we can apply operation on dataGrid.

Monday, July 27, 2015

WPF

July 27, 2015

Add image in wpf window background

If you want to add image in window background of WPF application then you should use Window.Background tag in xaml. Before set the image in background you must to add the image in the solution explorer. If you add image in the subfolder then specified the path of the folder like below example.

Now, code generate the following output:

WPF

July 27, 2015

How to bind ListBox in wpf

Today i am taking about listBox in WPF. In previous articles of windows form and web form i already discussed about ListBox. In this article i will use same control in different technology(WPF). We know that ListBox is a container of Objects. Listbox contain ItemsSource property of it which is used to bind it with the database table. You can manually define the listbox items using ListBox itemTemplate. Look at this example :

<Grid>
<ListBox ItemsSource="{Binding Path=emp}" x:Name="listBox" HorizontalAlignment="Left" Height="225" Margin="58,48,0,0" VerticalAlignment="Top" Width="218">
<ListBox.ItemTemplate>
<DataTemplate>
<StackPanel>
<TextBlock Text="{Binding Path=Emp_Id}"/>
<TextBlock Text="{Binding Path=Emp_Name}" />
</StackPanel>
</DataTemplate>
</ListBox.ItemTemplate>

</ListBox>

</Grid>

Code behind code

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;

namespace SplashSCreen
{
/// <summary>
/// Interaction logic for bindlist.xaml
/// </summary>
public partial class bindlist : Window
{
public bindlist()
{
InitializeComponent();
loadlist();
}

private void loadlist()
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["connsetting"].ToString();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from [emp]";
cmd.Connection = con;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds, "emp");
listBox.DataContext = ds;

}
}
}

Binding process in the code behind model are same in windows form as well as web forms. Only one difference that is DataSource, here we use DataContaxt.

Code generate the following output: