- After Successfull Installation of MonoDevelop We will start with making our first Hello World App in MonoDevelop . If you have not Installed MonoDevelop you can get Installation Guide here
Installation Guide For MonoDevelop - Start you M onoDevelop that you have installed already. It opens with following screen
Gtk# version 2.12.9 or greater must be installed
- Now to create a simple app in MonoDevelop Click on File Menu --> Then click on Solution
Gtk# version 2.12.9 or greater must be installed
- Then a window appears Click on Gtk# project and give Project a Name and click oK
Gtk# version 2.12.9 or greater must be installed
- Now your project open with a code window with Main.cs file as below
Gtk# version 2.12.9 or greater must be installed
- Now right click on your proect in sidebar then click on Add and in Submenu click on New File
Gtk# version 2.12.9 or greater must be installed
- Then click on Window give it a name and click ok
Gtk# version 2.12.9 or greater must be installed
- You can see you have two views Designer and source view .Designer view will be used for Designing GUI for your application and source will be used for coding
Gtk# version 2.12.9 or greater must be installed
- Now open new window file you have added and goto design view
- now from Toolbar in right sidebar Go to containers section and double click on Fixed Container to get it on your window
Gtk# version 2.12.9 or greater must be installed
- Now take a button from Toolbar
Gtk# version 2.12.9 or greater must be installed
- select the button Now click on properties window and click on Signals Tab
Gtk# version 2.12.9 or greater must be installed
- Now click on Clicked property and give a valid name for click event function and Hit Enter
Gtk# version 2.12.9 or greater must be installed
- Now first add reference to system.windows.forms Namespace for that Right click on project in sidebar and click on Edit Reference
Gtk# version 2.12.9 or greater must be installed
- Search for system.windows.forms in search box and click check mark on check Box and click ok
Gtk# version 2.12.9 or greater must be installed
- Now come to Souce view and you will see code like below
protected void clickevent (object sender, EventArgs e)
{
throw new System.NotImplementedException ();
} - Remove " throw new System.NotImplementedException ();" line and Add line as below
MessageBox.Show("Hello Welcome To Mono World"); - Now Save All your project change by pressing Ctrl + s
- Now Press F5 To Run your project and It will show output below
Gtk# version 2.12.9 or greater must be installed
Tuesday 3 June 2014
Gtk# version 2-12-9 or greater must be installed
- If you are suffering from this error during start of installation of MonoDevelop then main cause of this error is wrong installation of Gtk# . The best solution for this problem with which i have solved this error is to Download and Install Gtk Version 2.12.9 . The Download link is given below :-
Download Gtk version 2.12.9
All GTK Versions
Complete Installation Guide For MonoDevelop Install
MonoDevelop Cross Platform Using Csharp
MonoDevelop is a revolution in the era of Cross development by using Microsoft .NET programming language like Csharp ( C# ) , Visual Basic and Jsharp ( J# ) . Monodevelop has removed blame that Microsoft .NET software can only run on Windows platforms This makes possible to run .net applications and to build a .Net Application on any platform
MonoDevelop is a cross-platform IDE developed for Csharp ( C# ) programming language and other .NET programming languages. MonoDevelop allows programmers to program desktop softwares and ASP.NET Web applications and websites on Linux, Windows and Mac OSX. MonoDevelop makes possible for .net programmers to run , create and deploy their .net software applications on cross-platforms Any .NET application developed with Visual Studio can be used in linux or Mac with the help of MonoDevelop
Windows platform is fully supported for running MonoDevelop and it is fully accepted. In past there were many issues regarding Mono Development but now Many Windows specific issues have been fixed, and ome add-ins such as debugging and subversion support have been written specifically for Windows and it is fully supported by windows
By developing with mono specifically, you will be able to run your executable on any platform that has mono available for it. That in and of itself is mono's biggest advantage over developing on MSFT's .Net platform. Said differently: If you build you assembly with mono, you're guarantee cross-platform support
Features Of MonoDevelop
-
Multi-platform support
It Supports Linux ( ubuntu etc ) , Windows( xp,7,8 etc ) and Mac OS X operating systems
-
Advanced Text Editing Facilities
It provides Code completion support for Csharp 4 that is lastest version for csharp
It also provides code templates and code folding. -
Configurable workbench
Fully customizable window layouts, user defined key bindings, external tools -
Multi-language programming Facilities
Monodevelop supports various programming languages like - C#, Visual Basic.Net, C/C++, Vala
-
GTK# Visual Designer
Easily build GTK# applications
Installation Steps for MonoDevelop in Windows
- First you need to install GTK# for .NET, because the GTK# included with Mono is in Mono's GAC
- Then After successfull Installation of Gtk# Now install Monodevelop. You can download Monodevelop from link below
Download Monodevelop
Installation Steps For Gtk# for MonoDevelop
1. After Downloaded the Gtk# setup from link given in above section . Double click on setup and you will see the following startup screen
- Click Next to proceed the installation
- Now here comes License Agreeement Click on Check Box to accept the license and click on Next Button
MonoDevelop Cross Platform Using Csharp
- Now Choose or browse directory for Gtk# installation and click Next
MonoDevelop Cross Platform Using Csharp
- In Next Window click install and you will the installtion progress
MonoDevelop Cross Platform Using Csharp
Installation Steps for Monodevelop
- After Downloaded the MonoDevelop setup from link given in above section . Double click on setup and you will see the following startup screen
MonoDevelop Cross Platform Using Csharp
- Click Next to proceed the installation
-
Now here comes License Agreeement Click on Check Box to accept the license and click on Next Button
MonoDevelop Cross Platform Using Csharp
- Now Choose or browse directory for MonoDevelop installation and click Next
MonoDevelop Cross Platform Using Csharp
-
In Next Window click install and you will the installtion progress
MonoDevelop Cross Platform Using Csharp
MonoDevelop Cross Platform Using Csharp
-
After full installation click on Finish
MonoDevelop Cross Platform Using Csharp |
POSSIBLE ERRORS DURING MONO INSTALLATION
ERROR :- Gtk# version 2.12.9 or greater must be installed
Gtk# version 2.12.9 or greater must be installed |
Go Here For Solution To this Error Fix Gtk# version 2.12.9 or greater must be installed
Wednesday 21 May 2014
How to use mysql database in csharp
INTRODUCTION
In this article i am going to show how to connect a csharp database with mysql database and how to perform basic operations like inserting record in database , delete a specific record from database , updating a specific record and viewing all data and binding the data to datagridview . Mostly with Csharp Applications you have used MSSQL database but we can also use mysql database for this purpose
DOWNLOAD MYSQL WITH CSHARP APP
REQUIREMENTS
- Visual Studio 2010 or Visual Studio 2012
- MYSQL Database installed with admin roles
- Dot/connector connec
WHAT WE ARE GOING TO COVER
In this Article we are going to cover the following points
- Connect Csharp with mysql
- Insert data in mysql database with Csharp code
- Delete data in mysql database with Csharp code
- Update data in mysql database with Csharp code
- Select data in mysql database with Csharp code
CREATING DATABASE
First of Start your Wamp server or Xamp server services This will start Phpmyadmin where all database or SQL related work will be done . Phpmyadmin will be used for create new database schemas and other database oprations are done.
- Start Wamp / xampp server
How to use mysql database in csharp |
- Then Click on phpMyAdmin as shown in Image above .
- Now you will get a screen like the image below
How to use mysql database in csharp - If you are using default password for Phpmyadmin then directly click on Go button . Then you will get a screen like below
- Then click on Databases as shown in image below to create a new database that will be required for this Application
How to use mysql database in csharp - Then you will get window as shown below Fill up the Database name and Click on Create button
How to use mysql database in csharp - After database is created Now Run the database script we have provided in this tutorial in next steps and run this script as shown in image below ........Just go to sql Tab and paste full script there.
How to use mysql database in csharp - Remember one thing use same name of database as i have given in the snapshot
DOWNLOAD DATABASE SCRIPT FILE
Database Script File
DOWNLOAD FULL PROJECT WITH CODE
Download Complete project How to use mysql database in csharp
DOWNLOAD MYSQL CONNECTOR DLL's FOR DOTNET
For connecting Mysql with Csharp in dotnet you must have connector . you require Connector/NET for mysql connectivity with csharp . you can download Mysql connector / Net from link below :-Download Dotnet connector for mysql and csharp
HOW TO USE MYSQL DLL's
STEPS :-
- Right Click on Solution Name
- In pop-up menu click on Add Reference
How to use mysql database in csharp - Now select Mysql.Data and Click ok
How to use mysql database in csharp - you can also browse for dll downloaded from Browse Tab
How to use mysql database in csharp - Now MySQL.Data dll file will be added successfully to solution .
INSERT RECORD IN MYSQL DATABASE USING CSHARP CODE
How to use mysql database in csharp |
con.Open();
MySqlCommand cmd = new MySqlCommand("insert into table1(name,branch,phone) values(@name,@branch,@phone)", con);
cmd.Parameters.AddWithValue("@name", textBox1.Text);
cmd.Parameters.AddWithValue("@branch", textBox2.Text);
cmd.Parameters.AddWithValue("@phone", Convert.ToInt32(textBox3.Text));
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Inserted");
EXPLANATION :-
- First Connection is opened to mysql connection using connection string
- Then Using MySqlCommand class we are passing insert query to mysql database using con object that is used for establishing connection to mysql database
- Then @name,@branch,@phone are parameters given to query to dynamically pass data to query
- Then parameters are passed to query dynamically using following line of code
cmd.Parameters.Addwithvalue('parametername' , 'value' ); - cmd.ExecuteNonQuery is used to execute the query in cmd object to database
- con.close closes the connection to the database
DELETE RECORD IN MYSQL DATABASE USING CSHARP CODE
How to use mysql database in csharp |
CODE :-
con.Open();
if (comboBox1.Text != "")
{
MySqlCommand cmd = new MySqlCommand("delete from table1 where id=@id", con);
cmd.Parameters.AddWithValue("@id", comboBox1.Text);
if (comboBox1.Text != "")
{
MySqlCommand cmd = new MySqlCommand("delete from table1 where id=@id", con);
cmd.Parameters.AddWithValue("@id", comboBox1.Text);
cmd.ExecuteNonQuery();
con.close();
EXPLANATION :-
- First Connection is opened to mysql connection using connection string
- Then Using MySqlCommand class we are passing insert query to mysql database using con object that is used for establishing connection to mysql database
- Then @id is parameter given to query to dynamically pass data to query
- Then parameters are passed to query dynamically using following line of code
cmd.Parameters.Addwithvalue('parametername' , 'value' ); - cmd.ExecuteNonQuery is used to execute the query in cmd object to database
- con.close closes the connection to the database
UPDATE RECORD IN MYSQL DATABASE USING CSHARP CODE
How to use mysql database in csharp |
CODE :-
MySqlCommand cmd = new MySqlCommand("update table1 set name=@name,branch=@branch,phone=@phone where id=@id", con);cmd.Parameters.AddWithValue("@name",textBox6.Text );
cmd.Parameters.AddWithValue("@branch",textBox5.Text );
cmd.Parameters.AddWithValue("@phone",textBox4.Text);
cmd.Parameters.AddWithValue("@id",comboBox2.Text );
cmd.ExecuteNonQuery();
MessageBox.Show("Record Updated");
EXPLANATION :-
- First Connection is opened to mysql connection using connection string
- Then Using MySqlCommand class we are passing insert query to mysql database using con object that is used for establishing connection to mysql database
- Then @name,@branch,@phone,@id are parameters given to query to dynamically pass data to query to state which field value are to be replaced
- Then parameters are passed to query dynamically using following line of code
cmd.Parameters.Addwithvalue('parametername' , 'value' ); - cmd.ExecuteNonQuery is used to execute the query in cmd object to database
- con.close closes the connection to the database
SELECT RECORD IN MYSQL DATABASE USING CSHARP CODE
How to use mysql database in csharp |
CODE :-
MySqlCommand cmd = new MySqlCommand("select * from table1 where id=@id", con);
cmd.Parameters.AddWithValue("@id", comboBox2.Text);
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
textBox6.Text =dt.Rows [0][1].ToString ();
textBox5.Text =dt.Rows [0][2].ToString ();
textBox4.Text = dt.Rows[0][3].ToString();
}
EXPLANATION :-
- First Connection is opened to mysql connection using connection string
- Then Using MySqlCommand class we are passing insert query to mysql database using con object that is used for establishing connection to mysql database
- Then @name,@branch,@phone,@id are parameters given to query to dynamically pass data to query to state which field value are to be replaced
- Then parameters are passed to query dynamically using following line of code
cmd.Parameters.Addwithvalue('parametername' , 'value' ); - Then we have used MySqlDataAdapter that act as a pipeline between database and csharp app . It takes or select query from csharp application and then make interface or link to database and execute the query in database and get result returned by query executed in database
- Then it fill the returned result in placeholder called DataTable that saves data returned from or retrieved from database into tabulated form
- Now if (dt.Rows.Count >0) checks if dt contains some item then put the data in respective text fields
Full Code For Insert update delete and select Data from Mysql in Csharp Application ( C# )
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql;
using MySql.Data;
using MySql.Data.MySqlClient;
namespace mysql
{
public partial class Form1 : Form
{
public MySqlConnection con = new MySqlConnection("server=localhost;Uid=root;pwd=;Database=sqldotnet");
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
retrieve();
}
public void retrieve()
{
{
MySqlCommand cmdsel = new MySqlCommand("select * from table1 ", con);
MySqlDataAdapter dasel = new MySqlDataAdapter();
dasel.SelectCommand = cmdsel;
DataTable dtsel = new DataTable();
dasel.Fill(dtsel);
dataGridView1.DataSource = dtsel;
}
{
int cnt = comboBox1.Items.Count;
for (int counter = 0; counter < cnt; counter++)
{
comboBox1.Items.RemoveAt(0);
comboBox2.Items.RemoveAt(0);
}
}
MySqlCommand cmd = new MySqlCommand("select id from table1 ", con);
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
int cnt = dt.Rows.Count;
for (int counter = 0; counter < cnt; counter++)
{
comboBox1.Items.Add(dt.Rows[counter][0].ToString());
comboBox2.Items.Add(dt.Rows[counter][0].ToString());
}
}
comboBox1.Text = "";
comboBox2.Text = "";
}
//Delete Record
private void button2_Click_1(object sender, EventArgs e)
{
con.Open();
if (comboBox1.Text != "")
{
MySqlCommand cmd = new MySqlCommand("delete from table1 where id=@id", con);
cmd.Parameters.AddWithValue("@id", comboBox1.Text);
cmd.ExecuteNonQuery();
retrieve();
}
MessageBox.Show("Record Deleted");
}
//select Data
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
MySqlCommand cmd = new MySqlCommand("select * from table1 where id=@id", con);
cmd.Parameters.AddWithValue("@id", comboBox2.Text);
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
textBox6.Text =dt.Rows [0][1].ToString ();
textBox5.Text =dt.Rows [0][2].ToString ();
textBox4.Text = dt.Rows[0][3].ToString();
}
}
//Update Data
private void button3_Click_1(object sender, EventArgs e)
{
MySqlCommand cmd = new MySqlCommand("update table1 set name=@name,branch=@branch,phone=@phone where id=@id", con);
cmd.Parameters.AddWithValue("@name",textBox6.Text );
cmd.Parameters.AddWithValue("@branch",textBox5.Text );
cmd.Parameters.AddWithValue("@phone",textBox4.Text);
cmd.Parameters.AddWithValue("@id",comboBox2.Text );
cmd.ExecuteNonQuery();
MessageBox.Show("Record Updated");
retrieve();
}
//Insert Data
private void button1_Click_1(object sender, EventArgs e)
{
con.Open();
MySqlCommand cmd = new MySqlCommand("insert into table1(name,branch,phone) values(@name,@branch,@phone)", con);
cmd.Parameters.AddWithValue("@name", textBox1.Text);
cmd.Parameters.AddWithValue("@branch", textBox2.Text);
cmd.Parameters.AddWithValue("@phone", Convert.ToInt32(textBox3.Text));
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Inserted");
retrieve();
}
}
}
Wednesday 7 May 2014
sql insert , Update , delete using c#
To connect Database from your Windows Application is required to make Application for querying the database and retrieve the desired result from database . Database in widely used in management software's and various applications to save record and search the record .
Database dependent applications are widely used in the market . ERP projects of organisation are highly Database dependent applications . The main two types of databa se that are widely used in .NET Applications :-
* Microsoft Access Database
Database dependent applications are widely used in the market . ERP projects of organisation are highly Database dependent applications . The main two types of databa se that are widely used in .NET Applications :-
* Microsoft Access Database
* MSSQL Server ( Microsoft Structured Query Language )
The main Languages used in .NET Platform for connecting windows application to database are :-
* C#
* C#
* VB#
Sql ( Structured Query Language ) is most widely used Database . It is free and Opensource Database . It has simple query structure to Manipulate data from database in Database applications
To Learn About SQL and how to learn SQL you can go to following links first then go forward :-
SQL Tutorial with Examples and snapshots
insert , update , delete , select queries sql
Download Database Script file and execute it in your SQL Server
Steps To Execute this Script file -
1. Download Script file from link below .
2. Now open it with MsSql .
3. Now Create Database Named 'Accounts_database' in MsSql server
4. Now select this database from Dropdown
5. And Execute the Script code by clicking F5 .
Design of Form
Download Complete Project File
1. In Design We have some Fields to be filled to insert Data To database
2. We are having 3 Buttons - One for Update and Insert Operation , Second For Delete Operation and Third for Exit or close form
3. We are using Datagrid View to Instantly Showing The data in database and it is updated when we insert new data to database or we delete data from database
Insertion/Updation In Database
1. For insertion of data Fill the fields on form Only Code and Agency Name is required and rest of the fields are optional fields
2. Now you can see filled data is successfully inserted and it is immediately shown in below datagridview
CODE For Insert/Update
try
{
SqlCommand cmd1 = new SqlCommand("select * from Agency_detail where Agency_code=" + textBox1.Text, con);
SqlDataAdapter da1 = new SqlDataAdapter();
DataTable dt1 = new DataTable();
da1.SelectCommand = cmd1;
da1.Fill(dt1);
if ((dt1.Rows.Count > 0) && (dt1.Rows[0][0].ToString() != ""))
{
if (MessageBox.Show("ID Already Exist Do you want to Update It", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
SqlCommand cmdupdate = new SqlCommand("update Agency_detail set Agency_Name=@p1,Phone=@p2,fax=@p3,Mobile_Number=@p4,DOJ=@p5,opening=@p6,Remark=@p7,Address=@p8,city=@p9,state=@p10,zip_code=@p11,email=@p12 where Agency_code=" + textBox1.Text, this.con );
cmdupdate.Parameters.AddWithValue("@p1", textBox2.Text);
cmdupdate.Parameters.AddWithValue("@p2", textBox4.Text);
cmdupdate.Parameters.AddWithValue("@p3", textBox3.Text);
cmdupdate.Parameters.AddWithValue("@p4", textBox8.Text);
cmdupdate.Parameters.AddWithValue("@p5", dateTimePicker1.Value.Date);
cmdupdate.Parameters.AddWithValue("@p6", textBox6.Text);
cmdupdate.Parameters.AddWithValue("@p7", textBox5.Text);
cmdupdate.Parameters.AddWithValue("@p8", textBox17.Text);
cmdupdate.Parameters.AddWithValue("@p9", textBox16.Text);
cmdupdate.Parameters.AddWithValue("@p10", textBox15.Text);
cmdupdate.Parameters.AddWithValue("@p11", textBox14.Text);
cmdupdate.Parameters.AddWithValue("@p12", textBox13.Text);
//con.con.Open();
cmdupdate.ExecuteNonQuery();
MessageBox.Show("Updated");
retrieve_data();
clearall();
}
else
{
}
}
else
{
if ((textBox1.Text != "") && (textBox2.Text != ""))
{
SqlCommand cmd = new SqlCommand("insert into Agency_detail values(@para1,@para2,@para3,@para4,@para5,@para6,@para7,@para8,@para9,@para10,@para11,@para12,@para13)", con);
cmd.Parameters.AddWithValue("@para1", Convert.ToInt64(textBox1.Text));
cmd.Parameters.AddWithValue("@para2", textBox2.Text);
cmd.Parameters.AddWithValue("@para3", Convert.ToInt64(textBox4.Text));
cmd.Parameters.AddWithValue("@para4", Convert.ToInt64(textBox3.Text));
cmd.Parameters.AddWithValue("@para5", Convert.ToInt64(textBox8.Text));
cmd.Parameters.AddWithValue("@para6", dateTimePicker1.Value);
cmd.Parameters.AddWithValue("@para7", Convert.ToDouble(textBox6.Text));
cmd.Parameters.AddWithValue("@para8", textBox5.Text);
cmd.Parameters.AddWithValue("@para9", textBox17.Text);
cmd.Parameters.AddWithValue("@para10", textBox16.Text);
cmd.Parameters.AddWithValue("@para11", textBox15.Text);
cmd.Parameters.AddWithValue("@para12", Convert.ToInt64(textBox14.Text));
cmd.Parameters.AddWithValue("@para13", textBox13.Text);
//con.con.Open();
cmd.ExecuteNonQuery();
retrieve_data();
clearall();
}
else { MessageBox.Show("Agency ID and Name Must Required"); }
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Deletion Of Data
To Delete data or record from database :-
1. Enter the Required fields :- ID and Agency Name of Record to be deleted
2. Then press delete button and data will be deleted
3. It will be immediately shown as deleted in datagridview
CODE For DELETE
try
{
SqlCommand cmd = new SqlCommand("delete from Agency_detail where Agency_code =@code", this.con);
cmd.Parameters.AddWithValue("@code", Convert.ToInt32(textBox1.Text));
//con.con.Open();
cmd.ExecuteNonQuery();
retrieve_data();
clearall();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
{
SqlCommand cmd = new SqlCommand("delete from Agency_detail where Agency_code =@code", this.con);
cmd.Parameters.AddWithValue("@code", Convert.ToInt32(textBox1.Text));
//con.con.Open();
cmd.ExecuteNonQuery();
retrieve_data();
clearall();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Tuesday 18 March 2014
Implementing Search Functionality in ASP.NET MVC 4
What we are Going To cover
* In this Tutrial we are going to cover how to implement search functionality in Asp.Net MVC 4 . In our web applications in MVC we often need to add the functionality to search the database objects for specific data based on some creteria like to find employees with name starting with 'N' or to find data of employees that have Gender Male
Download Demo App With Database Link Below
Creating Database For This Application
1. First create Database* Open Microsoft Sql server . Click on New Query . Now execute the query below to create database
Create Database searchingInmvc
Create Database Searching in Asp.net MVC 4 |
2. Then Press F5 . This will create Database successfully
Create Table And Inserting Demo Data
create table tblEmployee //creating table
(
ID int identity primary key,
Name nvarchar(50),
Gender nvarchar(50),
Email nvarchar(50)
)
Creating Table In database |
//Inserting Demo Data
Here , we are inserting 4 Rows in Database tableinsert into tblEmployee values('John','Female','john@geeksprogrammings.blogspot.in')
insert into tblEmployee values('funky','Male','funky@geeksprogrammings.blogspot.in')
insert into tblEmployee values('wiley','Male','wiley@geeksprogrammings.blogspot.in')
insert into tblEmployee values('ceren','Female','ceren@geeksprogrammings.blogspot.in')
Inserting Data in Table |
Showing All Inserted Data
Download Database script fileCreate New MVC 4 Application in Visual Studio
1. Start Visual Studio with language selected as C#2.Click on File --> Then click on New Project
3. Scroll down and select ASP.NET MVC 4 Web Application
Implementing Search Functionality in Asp.Net MVC 4 |
4. Give appropriate Name,Path and solution Name and Hit Enter
5. choose Empty Template
6. Choose Razor View Engine and Hit Enter
7. Now New MVC 4 web application is started
Adding Models to MVC 4 Application
1. In solution Explorer -- > Right click on Models --> Then click on New item2. Then select ADO.NET Entity Data Model --.> Give it a valid name like 'sampledatamodel'
3. Click Add
Implementing Search Functionality in Asp.Net MVC 4 |
4. Now A dialog box appears choose database connection to sql server and give your connection string a name that will be give to connection string in web.config file
Implementing Search Functionality in Asp.Net MVC 4 |
5. click next
6. Now in next dialog box you will be presented with tables available in database table select you table
Implementing Search Functionality in Asp.Net MVC 4 |
7. Now click Finish
8. Now Entity model of table is generated you can rename your database here to 'Employee'
Implementing Search Functionality in Asp.Net MVC 4 |
9. Now Model is successfully Added
Adding Controller and Views To MVC 4 Application
To add controller to database --1. Right click on Controllers folder in solution folder
2. click on Add --> Then click on Controller
Implementing Search Functionality in Asp.Net MVC 4 |
3. Now Add controller Dialog Box appears
4. Give your controller a name like 'HomeController'
5. In template choose 'MVC controller with read/write and views using Entity Framework'
6. The Reason behind choosing this is it will automatically generate some pages to insert,delete , update data of model to which we are associating this controller
7. Now give the Model name that we have added in previous step 'Employee'
8. Now Choose dbcontext class from dropdown menu and finally click ADD
9. This autimatically add Views for insert , update, delete and index view in views folder under controller named folder
Implementing Search Functionality in Asp.Net MVC 4 |
Implementing Search Functionality in Asp.Net MVC 4 |
Adding Style And Look To Application
So we are going to search the database and retrieve data from database and then show the retrieved result to user. For this we have to get some controls and code . The GUI design that are going to give to this application is as below :-
1. In solution Explorer under Index view Double click on Index.cshtml
2. Now just before the line '<h2>Index</h2>' add a line
<div style='font-family:Arial'>
and close this div right below the code after table tag
Other UpdationAre in Demo Project Downlao And Use it
3. Update your Index.cshtml file under view folder in solution Explorer with the code below
@model IEnumerable<SearchInMVC.Models.Employee>
@{
ViewBag.Title = "Index";
}
<div style="font-family:Arial ">
<h2>Index</h2>
<p>
@Html.ActionLink("Create New", "Create")
</p>
<p>
@using (Html.BeginForm ("Index","Home",FormMethod.Get ))
{
<b>Search by:</b>@Html.RadioButton("searchBy","Name")<text> Name</text>
@Html.RadioButton("searchBy","Gender")<text>Gender</text><br />
@Html.TextBox("Search");<input type="submit" value="Search" />
}
</p>
<table border="1">
<tr>
<th>
@Html.DisplayNameFor(model => model.Name)
</th>
<th>
@Html.DisplayNameFor(model => model.Gender)
</th>
<th>
@Html.DisplayNameFor(model => model.Email)
</th>
<th>Action</th>
</tr>
@if (Model.Count() == 0)
{
<tr>
<td colspan ="4">No Rows Match Search Criteria</td>
</tr>
}
else
{
foreach (var item in Model)
{
<tr>
<td>
@Html.DisplayFor(modelItem => item.Name)
</td>
<td>
@Html.DisplayFor(modelItem => item.Gender)
</td>
<td>
@Html.DisplayFor(modelItem => item.Email)
</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id = item.ID }) |
@Html.ActionLink("Details", "Details", new { id = item.ID }) |
@Html.ActionLink("Delete", "Delete", new { id = item.ID })
</td>
</tr>
}
}
</table>
</div>
Now Run your Application and you can see the change with output below :-
Implementing Search Functionality in Asp.Net MVC 4 |
Code Description
In code above we have used Razor code and instead of using <form> tag that we usually use in html we have used Html Helper below
@using (Html.BeginForm ("Index","Home",FormMethod.Get ))
{
<b>Search by:</b>@Html.RadioButton("searchBy","Name")<text> Name</text>
@Html.RadioButton("searchBy","Gender")<text>Gender</text><br />
@Html.TextBox("Search");<input type="submit" value="Search" />
}
In Html.BeginForm ("Index","Home",FormMethod.Get )
Here, Html.BeginForm is used in place of using form tag . Html.BeginForm Received 3 arguments .
Here, "Index" is Name of action that will be executed on posting form to server
Here, "Home" is name of controller to which this link will be redirected when clicked
Here, " FormMethod.Get" type of encoding method that applied on data we are posting
Now Open Controller And Add code below to Index Action of home controller
if (searchby == "Gender")
{
return View(db.Employees.Where(x => x.Gender == search || search ==null).ToList());
}
else
{
return View(db.Employees.Where(x => x.Name.StartsWith(search)).ToList());
}
Subscribe to:
Posts (Atom)
Followers
Popular Posts
-
Sqlite Database is the best way of providing portability to our database . Sqlite database is well know for the conditions when developers ...
-
Necessity is the advent of everything today while doing some project i got requirement from my client to show the categories of the product...
-
Quick Sort is a Sorting Algorithm based on Divide And Conquer Technique. In this at every step element is placed in its proper position....