Tuesday, 12 June 2018

How to Create Excel File in Windows Form C#





using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Runtime.InteropServices;

using Excel = Microsoft.Office.Interop.Excel;



namespace WindowsFormsApplication7

{

    public partial class Form1 : Form

    {

        Excel.Application xlApp = new Excel.Application();

        public Form1()

        {

            InitializeComponent();

        }



        private void Form1_Load(object sender, EventArgs e)

        {

            if (xlApp == null)

            {

                label1.Text = "Excel Libary is not installed ";

                label1.ForeColor = System.Drawing.Color.Red;

            }

            else

            {

                label1.Text = "Excel Libary is  installed ";

                label1.ForeColor = System.Drawing.Color.Green;

         

            }

        }



        private void button1_Click(object sender, EventArgs e)

        {

            Excel.Workbook xlWorkBook;

            Excel.Worksheet xlWorkSheet;

            object misValue = System.Reflection.Missing.Value;



            xlWorkBook = xlApp.Workbooks.Add(misValue);

            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);



            xlWorkSheet.Cells[1, 1] = "StudentID";

            xlWorkSheet.Cells[1, 2] = "Student Name";

            xlWorkSheet.Cells[1, 3] = "Marks";



            xlWorkSheet.Cells[2, 1] = "1";

            xlWorkSheet.Cells[2, 2] = "Ali";

            xlWorkSheet.Cells[2, 3] = "50";



            xlWorkSheet.Cells[3, 1] = "2";

            xlWorkSheet.Cells[3, 2] = "Salman";

            xlWorkSheet.Cells[3, 3] = "60";





            xlWorkSheet.Cells[4, 1] = "3";

            xlWorkSheet.Cells[4, 2] = "Arsalan";

            xlWorkSheet.Cells[4, 3] = "100";







            xlWorkBook.SaveAs(@"C:\images\docs\salman.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);

            xlWorkBook.Close(true, misValue, misValue);

            xlApp.Quit();



            Marshal.ReleaseComObject(xlWorkSheet);

            Marshal.ReleaseComObject(xlWorkBook);

            Marshal.ReleaseComObject(xlApp);



            MessageBox.Show("Excel file created , you can find the file d:\\csharp-Excel.xls");

        }



    }

}


- 1 comment:

Sunday, 10 June 2018

How to calculate age from date of birth in c# windows application





 private void button2_Click(object sender, EventArgs e)

        {

            DateTime fdate = new DateTime(2000, 6, 1);

            DateTime sdate = new DateTime(2018, 6, 11);

            string diff = (sdate - fdate).TotalDays.ToString();

            int totaldays = Convert.ToInt32(diff);

            int year = totaldays / 365;

            int remainingdays = totaldays % 365;

            int month = Convert.ToInt32(remainingdays / 30.41);

            remainingdays = remainingdays % 30;

            label1.Text = year + " years , " + month + " months and " + remainingdays + " days";













        }
- No comments:

Wednesday, 6 June 2018

$POST Request in php







<!doctype html>

<html>

<head>

<meta charset="utf-8">

<title>post</title>

</head>



<body>



<form method="post">

Name:<input type="text"  name="name"/ >

Email:<input type="text"  name="email"/ >



<button type="submit" value="submit">  submit</button>



</form>



<?php

if($_SERVER['REQUEST_METHOD']=="POST")

{

$name=$_POST['name'];

$email=$_POST['email'];



if(empty($name) || empty($email))

{

echo "<p style='color:red'> * </p>";



}

else

{

echo "<p style='color:green'> Name: ".$name." </p>";

echo "<p style='color:green'> Email: ".$email." </p>";

}



}

?>







</body>

</html>
- No comments:

$_Get method in php (Super Global variable)





<!doctype html>

<html>

<head>

<meta charset="utf-8">

<title>Untitled Document</title>

</head>



<body>

<form method="get">

<input type="text" name="fname"/>

<input type="text" name="email"/>

<button type="submit" value="submit"> Submit </button>



</form>



<?php



if($_SERVER['REQUEST_METHOD']=="GET")

{

$name= $_GET['fname'];

$email= $_GET['email'];

if(empty($name) || empty($email) )

{

echo "<P style='color:red'> No name present..... </p>";



}

else

{

echo "<P style='color:red'> Name : ".$name." </p>";



echo "<P style='color:red'> email : ".$email." </p>";

}



}

?>





</body>

</html>
- No comments:

SUPER GLOBAL VARIABLE IN PHP $server and $Global





<!doctype html>

<html>

<head>

<meta charset="utf-8">

<title>GLOBAL</title>

</head>



<body>

<?php

$x=10;

$y=20;



function myfun()

{

$GLOBALS['x']=$GLOBALS['x']+$GLOBALS['y'];



//echo "value of x = ".$x;



}

myfun();

//echo "value of x = ".$x;

echo "PHP REFERENCE=".$_SERVER['HTTP_REFERER'];

?>







<?php

echo $_SERVER['PHP_SELF'];

echo "<br>";

echo $_SERVER['SERVER_NAME'];

echo "<br>";

echo $_SERVER['HTTP_HOST'];

echo "<br>";

echo $_SERVER['HTTP_REFERER'];

echo "<br>";



?>





</body>

</html>
- No comments:

Tuesday, 5 June 2018

workshopmanagement system 3





USE [master]

GO

/****** Object:  Database [workshops]    Script Date: 6/5/2018 3:31:02 PM ******/

CREATE DATABASE [workshops]

 CONTAINMENT = NONE

 ON  PRIMARY

( NAME = N'workshops', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\workshops.mdf' , SIZE = 3136KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )

 LOG ON

( NAME = N'workshops_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\workshops_log.ldf' , SIZE = 784KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

GO

ALTER DATABASE [workshops] SET COMPATIBILITY_LEVEL = 110

GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))

begin

EXEC [workshops].[dbo].[sp_fulltext_database] @action = 'enable'

end

GO

ALTER DATABASE [workshops] SET ANSI_NULL_DEFAULT OFF

GO

ALTER DATABASE [workshops] SET ANSI_NULLS OFF

GO

ALTER DATABASE [workshops] SET ANSI_PADDING OFF

GO

ALTER DATABASE [workshops] SET ANSI_WARNINGS OFF

GO

ALTER DATABASE [workshops] SET ARITHABORT OFF

GO

ALTER DATABASE [workshops] SET AUTO_CLOSE OFF

GO

ALTER DATABASE [workshops] SET AUTO_CREATE_STATISTICS ON

GO

ALTER DATABASE [workshops] SET AUTO_SHRINK OFF

GO

ALTER DATABASE [workshops] SET AUTO_UPDATE_STATISTICS ON

GO

ALTER DATABASE [workshops] SET CURSOR_CLOSE_ON_COMMIT OFF

GO

ALTER DATABASE [workshops] SET CURSOR_DEFAULT  GLOBAL

GO

ALTER DATABASE [workshops] SET CONCAT_NULL_YIELDS_NULL OFF

GO

ALTER DATABASE [workshops] SET NUMERIC_ROUNDABORT OFF

GO

ALTER DATABASE [workshops] SET QUOTED_IDENTIFIER OFF

GO

ALTER DATABASE [workshops] SET RECURSIVE_TRIGGERS OFF

GO

ALTER DATABASE [workshops] SET  ENABLE_BROKER

GO

ALTER DATABASE [workshops] SET AUTO_UPDATE_STATISTICS_ASYNC OFF

GO

ALTER DATABASE [workshops] SET DATE_CORRELATION_OPTIMIZATION OFF

GO

ALTER DATABASE [workshops] SET TRUSTWORTHY OFF

GO

ALTER DATABASE [workshops] SET ALLOW_SNAPSHOT_ISOLATION OFF

GO

ALTER DATABASE [workshops] SET PARAMETERIZATION SIMPLE

GO

ALTER DATABASE [workshops] SET READ_COMMITTED_SNAPSHOT OFF

GO

ALTER DATABASE [workshops] SET HONOR_BROKER_PRIORITY OFF

GO

ALTER DATABASE [workshops] SET RECOVERY FULL

GO

ALTER DATABASE [workshops] SET  MULTI_USER

GO

ALTER DATABASE [workshops] SET PAGE_VERIFY CHECKSUM 

GO

ALTER DATABASE [workshops] SET DB_CHAINING OFF

GO

ALTER DATABASE [workshops] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )

GO

ALTER DATABASE [workshops] SET TARGET_RECOVERY_TIME = 0 SECONDS

GO

USE [workshops]

GO

/****** Object:  StoredProcedure [dbo].[sp_insert_instructor]    Script Date: 6/5/2018 3:31:02 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE proc [dbo].[sp_insert_instructor]

(



@i_name nvarchar(20)  ,

@i_designation  nvarchar(20)  ,

@i_image nvarchar(max) ,

@ad_fk_ad int

)

as

begin



insert into  tbl_instructor

values(@i_name   ,

@i_designation   ,

@i_image ,

@ad_fk_ad)

end







GO

/****** Object:  Table [dbo].[Employee]    Script Date: 6/5/2018 3:31:02 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Employee](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Name] [varchar](20) NULL,

[Salary] [float] NULL,

[Department] [varchar](20) NULL

) ON [PRIMARY]



GO

SET ANSI_PADDING OFF

GO

/****** Object:  Table [dbo].[tbl_admin]    Script Date: 6/5/2018 3:31:02 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tbl_admin](

[ad_id] [int] IDENTITY(1,1) NOT NULL,

[ad_name] [nvarchar](20) NOT NULL,

[ad_password] [nvarchar](20) NOT NULL,

PRIMARY KEY CLUSTERED

(

[ad_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED

(

[ad_name] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]



GO

/****** Object:  Table [dbo].[tbl_batch]    Script Date: 6/5/2018 3:31:02 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tbl_batch](

[b_id] [int] IDENTITY(1,1) NOT NULL,

[b_name] [nvarchar](20) NOT NULL,

PRIMARY KEY CLUSTERED

(

[b_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED

(

[b_name] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]



GO

/****** Object:  Table [dbo].[tbl_feedbackform]    Script Date: 6/5/2018 3:31:02 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tbl_feedbackform](

[f_id] [int] IDENTITY(1,1) NOT NULL,

[f_comment] [nvarchar](max) NOT NULL,

[f_marks] [int] NULL,

[f_wr_id_fk] [int] NULL,

[wr_id_fk_s] [int] NULL,

PRIMARY KEY CLUSTERED

(

[f_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



GO

/****** Object:  Table [dbo].[tbl_instructor]    Script Date: 6/5/2018 3:31:02 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tbl_instructor](

[i_id] [int] IDENTITY(1,1) NOT NULL,

[i_name] [nvarchar](20) NOT NULL,

[i_designation] [nvarchar](20) NOT NULL,

[i_image] [nvarchar](max) NOT NULL,

[ad_fk_id] [int] NULL,

PRIMARY KEY CLUSTERED

(

[i_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



GO

/****** Object:  Table [dbo].[tbl_student]    Script Date: 6/5/2018 3:31:02 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tbl_student](

[s_id] [int] IDENTITY(1,1) NOT NULL,

[s_name] [nvarchar](20) NOT NULL,

[s_enrollment] [nvarchar](20) NOT NULL,

[s_image] [nvarchar](max) NOT NULL,

[s_batchcode] [int] NULL,

PRIMARY KEY CLUSTERED

(

[s_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED

(

[s_enrollment] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]



GO

/****** Object:  Table [dbo].[tbl_workshopname]    Script Date: 6/5/2018 3:31:02 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tbl_workshopname](

[w_id] [int] IDENTITY(1,1) NOT NULL,

[w_name] [nvarchar](20) NOT NULL,

PRIMARY KEY CLUSTERED

(

[w_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED

(

[w_name] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]



GO

/****** Object:  Table [dbo].[tbl_workshoprecord]    Script Date: 6/5/2018 3:31:02 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tbl_workshoprecord](

[wr_id] [int] IDENTITY(1,1) NOT NULL,

[wr_date] [date] NULL,

[wr_id_fk_w] [int] NULL,

[wr_id_fk_i] [int] NULL,

PRIMARY KEY CLUSTERED

(

[wr_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]



GO

/****** Object:  Table [dbo].[tbl_workshoprecordforstudent]    Script Date: 6/5/2018 3:31:02 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tbl_workshoprecordforstudent](

[wr_id] [int] IDENTITY(1,1) NOT NULL,

[wr_date] [date] NULL,

[wr_id_fk_w] [int] NULL,

[wr_id_fk_s] [int] NULL,

PRIMARY KEY CLUSTERED

(

[wr_id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]



GO

ALTER TABLE [dbo].[tbl_feedbackform] ADD  DEFAULT ((0)) FOR [f_marks]

GO

ALTER TABLE [dbo].[tbl_feedbackform]  WITH CHECK ADD FOREIGN KEY([f_wr_id_fk])

REFERENCES [dbo].[tbl_workshoprecord] ([wr_id])

GO

ALTER TABLE [dbo].[tbl_feedbackform]  WITH CHECK ADD FOREIGN KEY([wr_id_fk_s])

REFERENCES [dbo].[tbl_student] ([s_id])

GO

ALTER TABLE [dbo].[tbl_instructor]  WITH CHECK ADD FOREIGN KEY([ad_fk_id])

REFERENCES [dbo].[tbl_admin] ([ad_id])

GO

ALTER TABLE [dbo].[tbl_student]  WITH CHECK ADD FOREIGN KEY([s_batchcode])

REFERENCES [dbo].[tbl_batch] ([b_id])

GO

ALTER TABLE [dbo].[tbl_workshoprecord]  WITH CHECK ADD FOREIGN KEY([wr_id_fk_w])

REFERENCES [dbo].[tbl_workshopname] ([w_id])

GO

ALTER TABLE [dbo].[tbl_workshoprecord]  WITH CHECK ADD FOREIGN KEY([wr_id_fk_i])

REFERENCES [dbo].[tbl_instructor] ([i_id])

GO

ALTER TABLE [dbo].[tbl_workshoprecordforstudent]  WITH CHECK ADD FOREIGN KEY([wr_id_fk_w])

REFERENCES [dbo].[tbl_workshoprecord] ([wr_id])

GO

ALTER TABLE [dbo].[tbl_workshoprecordforstudent]  WITH CHECK ADD FOREIGN KEY([wr_id_fk_s])

REFERENCES [dbo].[tbl_student] ([s_id])

GO

USE [master]

GO

ALTER DATABASE [workshops] SET  READ_WRITE

GO


- No comments:

Monday, 4 June 2018

comparison operator in php





<!doctype html>

<html>

<head>

<meta charset="utf-8">

<title>comparison operator..</title>

</head>



<body>

<?php

$a=10;

$b=5;

$c=10;







if($a === $b)

{

echo " <p style='color:green'>success </p>" ;

}



else

{

echo "<p style='color:red'> failure </p>" ;

}

echo "<h1> >= Operator </h1>";



echo "a>=b =".($a>=$b);



echo "<h1> <= Operator </h1>";



echo "a<=b =".($a<=$b);



echo "<h1> == Operator </h1>";



echo "a==b =".($a==$b);



echo "<h1> != Operator </h1>";



echo "a!=b =".($a!=$b);







echo "<h1> === Operator </h1>";



echo "a===c =".($a===$c);







?>





</body>

</html>
- No comments:
Subscribe to: Posts (Atom)

Pass Dynamically Added Html Table Records List To Controller In Asp.net MVC

Controller Code: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using ...