Geeks With Blogs

News

Microsoft MVP


Moderator at CodeASP.NET


Quiz Master




free counters
Free counters
Added on January 19,2012


Follow Me @vmsdurano

A bit About Me



Disclaimer
The opinions expressed herein are my own personal opinions and does not represent the opinions of my employers. Nor does it represent the opinion of my dog, because I don’t have one.


Vinz' Blog (ProudMonkey) "Code, Beer and Music ~ my way of being a programmer" SQL Server There are 8 entries for the tag SQL Server
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 4, 2011 8:00 PM

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 4, 2011 7:41 PM

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 3, 2011 5:03 PM

Save Dynamic TextBox Values from GridView to Database
In my previous article, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes. Now, seems that most of the developers are asking if how to save all the data that was entered from the dynamic textbox in the GridView to the database. So in this example, I’m going to show on how to save them all in the database. To get started then lets create a sample Table in SQL Server. In this example, I named the table as “SampleTable” with the following fields below: Note: I set the ......

Posted On Sunday, August 2, 2009 1:54 PM

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 6, 2009 9:15 PM

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

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

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

Copyright © Vincent Maverick Durano | Powered by: GeeksWithBlogs.net | Join free