School Managment System

This project is based on “School Management System” is an outcome of practical work at XYZ Khan School. One can get considerable satisfaction when and when only some positive efforts are translated into some concrete things. It is relay a very pleasant task of acknowledgement the help we received while developing this website.

At last we thanks to all who supported us for making this project.

Project Profile


Project Title : School Management
System Developed For : XYZ School. Siddhpur.
Project Guide : Prof. Ritu Chaudhari
Prof. Viral Sir




Team Member : 2
Front End : Microsoft Visual Studio 2008
Back End : MS SQL Server
Web Server : IIS (Internet Information Service)
Platform : Windows XP,
Documentation Tools : Microsoft Office 2003.


Project Definition

This website is based on “School Management System”. In this project, administrator can see the different reports like text reports and different kind of graph reports like Pie Chart, Bar Chart. Administrator can also getsee these reports with total calls with percentage of row wise and column wise.

For Get this Project Please Contact hitendra.softwareengg@gmail.com

Bulk Copy Operation

Bulk Copy Operation

This code shows you how to do bulk copy operation using C#.

string connectionString = "";

 using (SqlConnection sc = new SqlConnection(connectionString))

 {

     sc.Open();

 

     SqlCommand commandSourceData = new SqlCommand("SELECT * FROM StoresBackup;", sc);

     SqlDataReader reader =  commandSourceData.ExecuteReader();

     using (SqlConnection dc = new  SqlConnection(connectionString))

     {

         dc.Open();

         using (SqlBulkCopy bulkCopy = new SqlBulkCopy(dc))

         {

              bulkCopy.DestinationTableName = "Stores";

              bulkCopy.WriteToServer(reader);

         }

     }

 }

Reading web.config from Timer Job

Reading web.config from Timer Job. to read the connection string from the Web.config of the Web Application

Configuration config=System.Web.Configuration.WebConfigurationManager.

OpenWebConfiguration("/",SPContext.Current.Web.Site.WebApplication.Name);

 

 string  _sqlConnectionString = config.ConnectionStrings.

ConnectionStrings["DBConnectionString"].ToString();

Read More......

Get The OUTPUT Paramete Value from SP Using Dot Net

Get The OUTPUT Paramete Value from SP Using Dot Net using asp.net. This code can be used to get the data from database using Out parameter

Imports System.Data

Imports System.Data.SqlClient

Partial Class SP

    Inherits System.Web.UI.Page

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)

 Handles Button1.Click

        Try

            Dim Con As New SqlConnection

            Con.ConnectionString = "Password=RR;Persist Security Info=True;

User ID=RR;Initial Catalog=RR;Data Source=RR"

            Con.Open()

            Dim INparam, OutPram As New SqlParameter

            INparam.Direction = ParameterDirection.Input

            INparam.SqlDbType = SqlDbType.Int

            INparam.ParameterName = "@ID"

            INparam.Size = 20

            INparam.Value = Textbox1.text

            OutPram.Direction = ParameterDirection.Output

            OutPram.SqlDbType = DbType.String

            OutPram.ParameterName = "@Name"

            OutPram.Size = 200

            Dim com As New SqlCommand

            com.Connection = Con

            com.CommandType = CommandType.StoredProcedure

            com.CommandText = "spGetOutput"

            com.Parameters.Add(INparam)

            com.Parameters.Add(OutPram)

            com.ExecuteNonQuery()

            Label1.Text = OutPram.Value()

        Catch ex As Exception

        End Try

    End Sub

End Class

Creating SQL Connection

Showing how to create a sql connection by code...(Basic). Type this code to create a sql connection using ADO.Net

//con is the object of SqlConnectoin_

 

 SqlConnectoin con= new SqlConnetoin();

 con.ConnectionString = "Data Source =Sqlservername ; Initial Catalog = table name; Integrated Security = True";

 con.Open();

 //Here Sqlserver name = your computer name

 

 (You can see your computer name by :

 right click on MyComputer --> Properties -->Computer Name (tab) --> Change (BUtton)

 

 //If you are connecting sql with user id and

 

 password than remove Integrated security and type :

 SqlConnectoin con= new SqlConnetoin();

 con.ConnectionString = "Data Source =Sqlservername ; Initial Catalog = table name; User id = youruserid; password = yourpassrd";

 con.Open();

Read More......