Database

There are 34 entries for the tag Database

Using ProudMonkey ConfirmBox Control in GridView

There are times that we need to prompt the users when doing certain actions on the page. One practical example is to confirm the user when deleting a certain record just like what I have demonstrated awhile back about Displaying a Confirmation Message on GridView Deleting. If you noticed on that demo I simply use plain JavaScript to display the confirmation message. In this post I’m going to demonstrate how to use the ConfirmBox control in delete scenario. Note that just for the simplicity of this...
Posted On Wednesday, February 01, 2012 12:42 AM | Feedback (0)

ASP.NET MVC 3 - Editing and Updating the Form

This demo is a continuation of my previous article about "Creating a Simple Log-in Form". Basically in this post I'm going to demonstrate the basic on how to edit and update the form with ASP.NET MVC 3. Before you go any further, I'd suggest you to check out my previous article first about "ASP.NET MVC 3: Creating a Simple Sign-Up Form" and "Creating a Simple Log-in Form". STEP 1: Creating the Model class Just for the simplicity of this demo, I'm just going to display the FirstName, LastName and...
Posted On Monday, January 09, 2012 10:13 PM | Feedback (1)

ASP.NET MVC 3 - Creating a Simple Log-In Form

This demo is a continuation of my previous article about "ASP.NET MVC 3: Creating a Simple Sign-Up Form" which I wrote few months ago. Basically in this post I'm going to demonstrate how to create a simple LogOn form in which users can supply their username and password. And how to authenticate and validate users in ASP.NET MVC 3. I will not elaborate more in details about the model, view and controllers function so before you go any further, I'd suggest you to check my previous article first about...
Posted On Friday, December 30, 2011 6:14 PM | Feedback (5)

Product Review - ComponentOne Studio for MVC Wijmo

Wijmo is an awesome tool from ComponentOne. The goal of this tool is to help us web developers rapidly develop MVC applications with interfaces richer than WebForms. Main Features: 1.Over 30 UI Widgets with everything from interactive menus to rich charts. 2.MVC scaffolding automation. This means that Wijmo generates rich interactive Views and Controllers for your entire Model. Free Trial DownLoad: http://www.componentone.com... In this review we'll take a look at Wijmo...
Posted On Monday, August 22, 2011 6:08 PM | Feedback (2)

ASP.NET MVC 3: Creating a Simple Sign-Up Form

In this article I'm going to demonstrate how to create a simple sign-up form using ASP.NET MVC 3. So basically in this demo you will learn the following: How to insert data to the database with Entity Framework How to validate the Form using Data Annotations How to Authenticate users after sign up using FormsAuthentication Note that before you continue reading this article be sure that you have the basic understanding about ASP.NET MVC in general. You can refer the following links below to learn...
Posted On Friday, June 03, 2011 8:44 PM | Feedback (36)

Entity Framework - Editing, Updating and Deleting Data in the Form

Previously we've talked about how to fetch the data from the database and populate the form with EF. In this example I'm going to demonstrate how to do Edit,Update and Delete operations in the form with Entity Framework. And oh since this is a continuation of my previous example I would suggest you to refer that first before you go any further. STEP 1: Setting up the UI Since this is a continuation of my previous example then I'm jus going to use the same layout and extend it a bit by adding some...
Posted On Monday, April 04, 2011 8:00 PM | Feedback (2)

Entity Framework - Fetching and Populating the Data in the Form

In Part 1 we've talked about how to insert data to the database with Entity Framework. In this part I'm going to demonstrate how to fetch the data from the database and populate the form fields with Entity Framework. STEP 1: Setting up the Form To get started let's go ahead and fire-up visual studio and add a new WebForm. For the simplicity of this demo I just set up the form like this: <asp:Content ID="Content2" ContentPlaceHolderID="MainC... runat="server"> <asp:DropDownList ID="ddlUser"...
Posted On Monday, April 04, 2011 7:41 PM | Feedback (8)

Entity Framework - Inserting Data to Database

Few months ago I wrote a series of articles regarding how to Insert, Update, Fetch and Delete data in the form using LINQ to SQL. You can view the series of articles below: Inserting Data to Database using LINQ to SQL Fetching Data from Database and Populating fields in the Form using LINQ to SQL Editing, Updating and Deleting Data in the Form using LINQ to SQL In this article I'm going to demonstrate the basics on how to work with MS Entity Framework. Basically in this part I'm going to show you...
Posted On Monday, April 04, 2011 11:59 AM | Feedback (10)

Dynamically Adding TextBox Control to ASPNET Table: Part 2

Few months ago I wrote an example about Dynamically Adding TextBox Control to ASPNET Table. As a recap that example demonstrate how to generate rows of TextBoxes in a Table control based on the number of rows and number of columns provided and as well as print the values entered by the user using the Request.Forms collections.. Recently,one of the user is asking if how are we going to accomplish the same thing by generating the TextBox in the Table based on the data from the database. So in this...
Posted On Tuesday, January 25, 2011 5:24 PM | Feedback (1)

Uploading Image to a Folder and Display the Image after Upload

I wrote a series of blog posts awhile back before that demonstrates the following: Uploading and Storing Images to Database in ASP.NET Displaying Image to Image Control based on User Selection in ASP.NET FAQ: Displaying Image from Database to GridView Control Uploading and Storing Image Path to Database and Image to Folder - Part 1 Uploading and Storing Image Path to Database and Image to Folder - Part 2 (Displaying of Images) Validate Image extensions upon Upload In this post I'm going to demonstrate...
Posted On Thursday, January 20, 2011 10:29 PM | Feedback (12)

Inserting and Deleting Sub Rows in GridView

A user in the forums (http://forums.asp.net) is asking how to insert sub rows in GridView and also add delete functionality for the inserted sub rows. In this post I'm going to demonstrate how to this in ASP.NET WebForms. The basic idea to achieve this is we just need to insert row data in the DataSource that is being used in GridView since the GridView rows will be generated based on the DataSource data. To make it more clear then let's build up a sample application. To start fire up Visual Studio...
Posted On Tuesday, January 04, 2011 5:52 PM | Feedback (6)

Uploading and Importing CSV file to SQL Server in ASP.NET WebForms

Few weeks ago I was working with a small internal project that involves importing CSV file to Sql Server database and thought I'd share the simple implementation that I did on the project. In this post I will demonstrate how to upload and import CSV file to SQL Server database. As some may have already know, importing CSV file to SQL Server is easy and simple but difficulties arise when the CSV file contains, many columns with different data types. Basically, the provider cannot differentiate data...
Posted On Monday, January 03, 2011 5:03 PM | Feedback (27)

Inserting Data to Database using LINQ to SQL

Few months ago, I’ve created a simple demo about “Creating a Simple Registration Form using the ADO.NET way”. In this article, I'm going to demonstrate how to create a simple form that would allows users to insert data to the database using L2S. As an overview, LINQ to SQL is a technology that allow you to query sql server. LINQ to SQL is an O/RM (object relational mapping) implementation that ships in the .NET Framework "Orcas" release, and which allows you to model a relational database using .NET...
Posted On Thursday, March 11, 2010 3:12 PM | Feedback (20)

BASIC: Binding ListBox and DropDownList using LINQ

This example shows the basic way on how to populate a data from database to a ListBox/DropDownList control using LINQ to SQL. Note that I used Northwind database here just for the simplicity of this example. To get started then let’s go ahead and add a new item in your website application in Visual Studio 2008 or VWD Express 2008. To do this, just right click on the web site -> select Add New Item -> and on the Templates select LINQ to SQL Classes as shown below and click ok: Now open up Server...
Posted On Tuesday, September 01, 2009 6:33 PM | Feedback (3)

Sorting GridView Manually with TemplateFields

I decided to write this example because this has been asked many times at the forums. In this article, I will show on how to sort GridView columns manually using a DataTable. Note that in this example, I used my own database for populating the GridView. See Adding Rows in GridView for more info. Now to get started lets set up the GridView with TemplateField columns. Since we are working with TemplateFields then we need to handle sorting manually by adding a LinkButton control inside the HeaderTemplate...
Posted On Sunday, July 12, 2009 4:58 PM | Feedback (6)

FAQ: How to Get Hidden Column values in GridView

I decided to write this simple demo because this issue has been asked many times at the forums. Hidden columns are fields in GridView that you don’t want to expose or show in the page, usually this field is the primary key of the data. Since a primary is a confidential data then you might want to hide it to the users. Most people usually use BoundField columns for displaying the data and just hide the field that contains the primary key. In this example, I will demonstrate two ways on how to access...
Posted On Monday, June 22, 2009 5:57 AM | Feedback (34)

Adding Rows in GridView

This example shows on how to add rows of data in the GridView control. In this example, I created a simple database table called “Table1” for storing the data. The Table has the following columns: Id – PK Employees Position Team Note that I added some dummy data in table that I have created so that we can display something in the GridView when the page is loaded for the first time. To get started, let’s grab a GridView Control from the Visual Studio ToolBox and place it in the webform. Then set up...
Posted On Tuesday, June 09, 2009 10:37 PM | Feedback (18)

Pre-Select Multiple ListBox items based on Database Value

I decided to write a simple demo about this because I always encounter this issue at the forums. Basically, this demo shows how to pre select multiple list items in the ListBox control based from database value. Assuming that we have this table definition with data below: As you can see, the Table has a "IsSelected" boolean field which indicates that a particular employee name is selected or not. Note that in this demo, I named the Table above as "Table1". Now lets set up our ListBox at the ASPX...
Posted On Monday, June 01, 2009 1:45 PM | Feedback (0)

ListBox Control: Save Multiple Selected Items in the Database

This example shows the basics on how to save multiple selected items from the ListBox control to the database. Please note that this example requires a basic knowledge of ADO.NET. STEP 1: Setting up the User Interface (GUI) For the simplicity of this demo, I just set up the web form like below: <html xmlns="http://www.w3.org/19... <head runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> Employee...
Posted On Sunday, May 31, 2009 7:11 PM | Feedback (9)

Pivot Data in GridView - A Generic Pivot Method with DataTable

This example shows how to “PIVOT” the original data that is displayed in the GridView. To start then lets grab two GridViews from the Visual Studio Toolbox and place it to your webform. The ASPX source would look something like this: ORIGINAL Table: <asp:GridView ID="GridView1" runat="server"> </asp:GridView><br /><br /> PIVOTED Table: <asp:GridView ID="GridView2" runat="server" ShowHeader="false"> </asp:GridView> Now, lets create the Generic method for Pivoting...
Posted On Sunday, May 10, 2009 9:04 PM | Feedback (10)

Filter GridView Data based from Date Ranges

This example shows how to filter data in GridView based from two given dates. For example you have two Calendar Control which is allows you to select the Start Date and End Dates accordingly. These selected dates will then be displayed in TextBoxes and later on you wish to Grab the data from the database based from the dates (StartDate and EndDate) that is displayed in the TextBox and bind the result to a GridView control. Here are the code blocks below: private string GetConnectionString(){ //call...
Posted On Thursday, May 07, 2009 5:11 PM | Feedback (0)

Save CheckBoxList Selected Items and Retain them on PostBacks.

I decided to write this example because I always encounter this kind of issues at http://forums.asp.net . This demo basically shows how to save the CheckBoxList selected items in the database and retain its selected items on postbacks or when the page is loaded again. To get started then lets start by creating the database for storing the data. STEP 1: Creating the database. Launch Sql Server Management Studion Express and then connect Expand the Databases folder from the Sql Server object explorer...
Posted On Wednesday, May 06, 2009 9:15 PM | Feedback (10)

Creating a Simple Registration Form in ASP.NET

This example shows how to create a very simple registration form in ASP.NET WebForms. STEP1: Creating the Database. The following are the basic steps on how to create a simple database in the Sql Server: Launch Sql Server Management Studion Express and then connect Expand the Databases folder from the Sql Server object explorer Right click on the Databases folder and select “New Database” From the pop up window, input the database name you like and click add Expand the Database folder that you have...
Posted On Thursday, April 30, 2009 8:09 AM | Feedback (124)

FAQ: Displaying Image from Database to GridView Control

I wrote this demo because I observed that lots of people in the forum (forums.asp.net) always ask questions on how to display Image that was stored in the database to GridView control. Before reading this example, be sure that you have already know how to upload image to the database. If you are not familiar with it then I would suggest you to read my previous example about “Uploading and Storing Images to Database in ASP.NET”. In this demo, we are going to use a Handler.ashx file for fetching the...
Posted On Friday, April 24, 2009 8:52 AM | Feedback (8)

Displaying Image to Image Control based on User Selection in ASP.NET

This example is a continuation of my previous example about “Uploading and Storing Images to Database in ASP.NET”. In this demo, I’m going to show how to display image (binary format) from database to ASP Image control and display its corresponding image information based on user selection. In this demo, we are going to use a Handler.ashx file for fetching the binary data from the database and then stream it. What is a Handler? A handler is responsible for fulfilling requests from a browser. Requests...
Posted On Friday, April 24, 2009 3:15 AM | Feedback (23)

Uploading and Storing Images to Database in ASP.NET

This example demonstrates how to upload image using the FileUpload control and store the uploaded file in the database in binary format. STEP 1: Creating the Database. The following are the basic steps on how to create a simple database in the Sql Server: Launch Sql Server Management Studion Express and then connect Expand the Databases folder from the Sql Server object explorer Right click on the Databases folder and select “New Database” From the pop up window, input the database name you like...
Posted On Thursday, April 23, 2009 11:13 AM | Feedback (24)

ASP.NET WebPart with Skins

This example demonstrates on how to apply Skins to ASP.NET WebParts. Before we begin let us first understand the concept of the skins in ASP.NET. What is a Skin file? A Skin enables us to modify any of the properties applied to the server controls in our ASP.NET page. Skins can work in conjunction with CSS files or images. To create a Theme we can use a single skin file in the Theme Folder. The skin file extension should be always .skin. For more information about ASPNET Themes and Skins then have...
Posted On Tuesday, April 14, 2009 6:51 AM | Feedback (0)

Displaying two Column Fields in DropDownList Control

There are two basic ways on how to display two fields from database in the DropDownList. The first one is concatenating it in the sql query and the second one is concatening it programmatically in codes. Manipulating the sql query to concatenate two fields. Here’s the code block below. private void BindDropDownList() { DataTable dt = new DataTable(); SqlConnection connection = new SqlConnection(GetConnection... try { connection.Open(); string sqlStatement = "SELECT CustomerID + ' ---- ' +...
Posted On Wednesday, March 11, 2009 4:15 PM | Feedback (1)

Creating a Simple ShoutBox with MultiLine TextBox

Overview This demo explains how to create a simple ShoutBox using the ASP.NET MultiLine TextBox. A “ShoutBox” basically allow end users to post commentsin the page. To begin let’s create a WebUserControl and implement our ShoutBox there. Why UserControl? We used WebUserControl so that we can re-use and place the control anywhere in your page by simply dragging it to the WebForm. Step 1: Creating the Database In this demo, I presumed that you already have a basic background on how to create a simple...
Posted On Tuesday, February 24, 2009 5:50 PM | Feedback (13)

Binding DropDownList, ListBox and CheckBoxList Control the ADO.NET way.

This example shows how to bind DropDownList, ListBox and CheckBoxList control with data from database using the ADO.NET way. Note that in this demo, I’m using the Northwind database. Now let’s set up the connection string. STEP 1: Setting up the Connection string In your web.config file set up the connection string there as shown below: <connectionStrings> <add name="DBConnection" connectionString="Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirec... Integrated Security=True;User...
Posted On Tuesday, February 24, 2009 5:31 PM | Feedback (15)

Adding ASPNETDB.mdf file to SQL Server 2005

By default ASPNETDB will be automatically created under App_data directory in your application if personalization is use for the first time.If you wanted to locate ASPNETDB file in your Own Database (SQL Sevrer 2005) then just simply do the following -Copy the ASPNETDB that is located at the App_data Folder in your Apps and paste it anywhere in your drives.. the after copying -Remove the ASPNETDB in your App_Data folder -Open SqlServer 2005 or Studio Management Express -Right Click on Database Folder...
Posted On Monday, February 23, 2009 4:40 PM | Feedback (8)

GridView Multiple Delete with CheckBox and Confirm

This demo describes how to implement multiple delete in GridView using CheckBox control and display a confirmation message upon deletion. Assuming that we have this GridView column mark up below <Columns> <asp:TemplateField> <HeaderTemplate> <asp:Button ID="ButtonDelete" runat="server" Text="Delete" /> </HeaderTemplate> <ItemTemplate> <asp:CheckBox ID="CheckBox1" runat="server" /> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="CustomerID"...
Posted On Sunday, February 22, 2009 2:01 AM | Feedback (88)

GridView Insert, Edit, Update and Delete – The Ado.Net way

This demo is a continuation of my previous example “Binding GridView with Data”. If you are not familiar of binding the GridView the ado.net way then I would suggest looking at my previous example first before you proceed to this example. Basically, this demo describes the basic way to do INSERT, EDIT, UPDATE and DELETE data in ASPNET GridView Control using the ADO.NET way. STEP 1: Creating a DataBase Table In this demo, I presumed that you already have a basic background on how to create a simple...
Posted On Sunday, February 22, 2009 1:34 AM | Feedback (93)

Binding GridView with Data - The ADO.NET way

This example demonstrates how to populate GridView with data from the database using the ADO.NET way. Before you proceed reading this example be sure that you know the basics of ADO.NET manipulation. If you are not familiar with ADO.NET then I would suggest you to refer at the following link below: ADO.NET Tutorial STEP 1: Setting up the Connection String - Open your Web.config file and set up your connection string like below: <connectionStrings> <add name="MyDBConnection" connectionString="Data...
Posted On Thursday, February 19, 2009 9:35 PM | Feedback (13)

 
Powered by:

Copyright © Vincent Maverick Durano