Skip to main content

How to make Database table in visual studio 2012

Introduction

Database table is a collection of "data-column and data-rows". If you want to make table in visual studio 2010 then you must save table using save icon. Also give name of the table, which is related to table data. In Visual Studio 2013 you must to update table after preparing structure.

Following some steps for creating Database table in visual studio 2012


Step-1 : Right click on website name in solution explorer
Step-2 : Click  Add --> Add New Item
Step-3: Select Sql Server Database

choose sql data base

Step-4: Show new pop up window
folder in App_data
Step-5: Click "Yes" in Microsoft visual Studio pop
and add Database.mdf file in App_Data folder

Step-6: In Server Explorer Expand "+" icon of database.mdf file 

server explorer

Step-7: Right Click on Tables --> Click Add new Table

data base table property

Step-8: make Id as  IsIdentity column.
Step-9: Right click on id column-->Properties 
Step-10: Set Is Identity to "true"
Column property

Step-11 : Add new Column to table 

query design view

Step-12: Before Click on Update button  chnage table name
update and save data base

Step-13 : Insert item into table
Step-14 : Right click on Table name in server explorer
Step-15 : Click show table data 
Step-16 : Insert item into table

assign value to column

Comments

  1. Education without values, as useful as it is, seems rather to make man a more clever devil. See the link below for more info.

    #clever
    www.mocsbar.com

    ReplyDelete

Post a Comment

Popular posts from this blog

Unformatted Input/Output Functions with Example: C Language

In our earlier post i have discussed about sequential and compound statements. Now in this post we will discuss about unformatted i/o functions. There are several standard library functions available in this category - those that can deal with a single character and those that can deal with a string of characters. The various unformatted input/output functions in C are shown below:


getchar( ) and putchar( ) Even though getchar( ) and putchar( ) looks like functions, they are not. They are the macros that are used to read and display a character. The syntax to read a character shown below:

“ch = getchar( )” will reads a character from the keyboard and copy it into memory area which is identified by the variable ch. No arguments are required for this macro. Once the character is entered from the keyboard, the user has to press Enter key.

“putchar(ch)” outputs a character stored in a variable on the monitor. The variable should be passed as parameter as shown in the above syntax.

Example1

Memory representation of Linked List Data Structures in C Language

Memory representation of Linked List

             In memory the linked list is stored in scattered cells (locations).The memory for each node is allocated dynamically means as and when required. So the Linked List can increase as per the user wish and the size is not fixed, it can vary.

               Suppose first node of linked list is allocated with an address 1008. Its graphical representation looks like the figure shown below:


      Suppose next node is allocated at an address 506, so the list becomes,



  Suppose next node is allocated with an address with an address 10,s the list become,


The other way to represent the linked list is as shown below:




 In the above representation the data stored in the linked list is “INDIA”, the information part of each node contains one character. The external pointer root points to first node’s address 1005. The link part of the node containing information I contains 1007, the address of next node. The last node …

Online Examination System Project in ASP.NET

Introduction:
You can conduct your examination online using online Examination system project. Basically this project is designed for helping conductor. This application is designed for college level project its not used for education purpose.

Login Control

This module provide interface with admin login also provide security to your project. Your admin can see your result or update your questions.

<%@ Page Language="C#" Theme="all" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<!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 btnLogin_Click(object sender, EventArgs e)
    {
        // check whether credentials are valid
        SqlConnection con = new SqlConnection(DBUtil.ConnectionString );
        try
        {
            con.O…