Total Pageviews

16 April 2012

How Create profile in crystal report with help of Asp.net

Here we are representing to make complete profile any employee or other Use. First of all if you want to make crystal report then install the setup of crystal report 2008 or 2010 as wish you want to install. If you are using .Net framework 2008 then install crystal report 2008 and when Use .Net Framework 4.0 then install crystall report 2010. Now Implement this programe hope this usefull for you.............

Add caption

Default2.aspx=>


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

  <html xmlns="http://www.w3.org/1999/xhtml">


<head runat="server">


<style type="text/css">


.Gridview


{


font-family:Verdana;


font-size:10pt;


font-weight:normal;


color:black;


}


</style>

 

 

 


    <title></title>


</head>


<body>


    <form id="form1" runat="server">


    <div>


    <table>


    <tr>


<td>


Employee Name:


</td>


<td>


<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>


</td>


</tr>


<tr>


<td>


Designation:


</td>


<td>


<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>


</td>


</tr>


<tr>


<td>


Date of Birth:


</td>


<td>


<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>


</td>


</tr>


<tr>


<td>


Date of anniversary:


</td>


<td>


<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>


</td>


</tr>


<tr>


<td>


Permanent Address:


</td>


<td>


<asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>


</td>


</tr>


<tr>


<td>


Image:


</td>


<td>


<asp:TextBox ID="txtImageName" runat="server"></asp:TextBox>


</td>


</tr>


<tr>


<td>


Upload Image:


</td>


<td>


<asp:FileUpload ID="fileuploadImage" runat="server" />


</td>


</tr>


<tr>


<td>


</td>


<td>


<asp:Button ID="btnUpload" runat="server" Text="Upload" onclick="btnUpload_Click" />


    <asp:Button ID="Button1" runat="server" onclick="Button1_Click"


        Text="Sow Profile" />


</td>


</tr>


</table>


</div>

 

 

 


    </form>


</body>


</html>

 

 

 

Default.aspx.cs=>


using System;


using System.Collections.Generic;


using System.Linq;


using System.Web;


using System.Web.UI;


using System.Web.UI.WebControls;


using System.IO;


using System.Data.SqlClient;


using System.Data;


using System.Configuration;

 

 

 


public partial class Default2 : System.Web.UI.Page


{


    string strcon = ConfigurationManager.ConnectionStrings["dbconnection"].ToString();

 

 

 


    protected void Page_Load(object sender, EventArgs e)


    {


        if (!IsPostBack)


        {


          


        }

 

 

 


    }


    protected void btnUpload_Click(object sender, EventArgs e)


    {


       


        if (fileuploadImage.HasFile)


        {


          


            int length = fileuploadImage.PostedFile.ContentLength;


           


            byte[] imgbyte = new byte[length];


          


            HttpPostedFile img = fileuploadImage.PostedFile;


          


            img.InputStream.Read(imgbyte, 0, length);


            string imagename = txtImageName.Text;


           


            SqlConnection connection = new SqlConnection(strcon);


            connection.Open();


            SqlCommand cmd = new SqlCommand("INSERT INTO Image (ImageName,Image,User_name,Designation,Date_birth,Date_anivesary,permanentadd) VALUES (@imagename,@imagedata,@User_name,@Designation,@Date_birth,@Date_anivesary,@permanentadd)", connection);


            cmd.Parameters.Add("@imagename", SqlDbType.VarChar, 50).Value = imagename;


            cmd.Parameters.Add("@imagedata", SqlDbType.Image).Value = imgbyte;


            cmd.Parameters.Add("@User_name", SqlDbType.VarChar, 50).Value = imagename;


            cmd.Parameters.Add("@Designation", SqlDbType.VarChar, 50).Value = imagename;


            cmd.Parameters.Add("@Date_birth", SqlDbType.VarChar, 50).Value = imagename;


            cmd.Parameters.Add("@Date_anivesary", SqlDbType.VarChar, 50).Value = imagename;


            cmd.Parameters.Add("@permanentadd", SqlDbType.VarChar, 50).Value = imagename;


            int count = cmd.ExecuteNonQuery();


            connection.Close();


            if (count == 1)


            {


              


                txtImageName.Text = string.Empty;


                ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert('" + imagename + " image inserted successfully')", true);


            }


        }


    }

 


    protected void Button1_Click(object sender, EventArgs e)


    {


        Response.Redirect("User.aspx");


    }


}

 

 

Web config=>

 <add name="dbconnection" connectionString="Data Source=AMRIT;Initial Catalog=AMBROSIA;Integrated Security=True" providerName="System.Data.SqlClient"/>

 



 

Posted by at No comments:

how to use trigger process between three tables in sql server

Complete process to use trigger
create table adminassign
(
Com_name Varchar(50),
pm_name Varchar(50),
Project_code int,
Email_id Varchar(50),
Received_date varchar(50),
Deadline  varchar(50),
Project_status varchar(50),
Expected_date varchar(50),
Source_language varchar(50),
Target_language varchar(50),
Volume_project varchar(50),
Job_type Varchar(50),
File_attached varchar(200),
Instruction_file  varchar(200)
)
Ven_assign
create table ven_assign
(
Com_name Varchar(50),
pm_name Varchar(50),
Project_code int,
Email_id Varchar(50),
Received_date varchar(50),
Deadline  varchar(50),
Project_status varchar(50),
Expected_date varchar(50),
Source_language varchar(50),
Target_language varchar(50),
Volume_project varchar(50),
Job_type Varchar(50),
File_attached varchar(200),
Instruction_file  varchar(200)
)
Project_id
create table project_id
(
Com_name Varchar(50),
pm_name Varchar(50),
Project_code int,
Email_id Varchar(50),
Received_date varchar(50),
Deadline  varchar(50),
Project_status varchar(50),
Expected_date varchar(50),
Source_language varchar(50),
Target_language varchar(50),
Volume_project varchar(50),
Job_type Varchar(50),
File_attached varchar(200),
Instruction_file  varchar(200)
)
assign_prcocreate table assign_prco
(
Com_name Varchar(50),
pm_name Varchar(50),
Project_code int,
Email_id Varchar(50),
Received_date varchar(50),
Deadline  varchar(50),
Project_status varchar(50),
Expected_date varchar(50),
Source_language varchar(50),
Target_language varchar(50),
Volume_project varchar(50),
Job_type Varchar(50),
File_attached varchar(200),
Instruction_file  varchar(200)
)
Trigger Ven_assign
create trigger Venassigntrigger
on Ven_assign
for
Insert as
declare @Com_name Varchar(50)
declare @pm_name Varchar(50),
declare @Project_code int,
declare @Email_id Varchar(50),
declare @Received_date varchar(50),
declare @Deadline  varchar(50),
declare @Project_status varchar(50),
declare @Expected_date varchar(50),
declare @Source_language varchar(50),
declare @Target_language varchar(50),
declare @Volume_project varchar(50),
declare @Job_type Varchar(50),
declare @File_attached varchar(200),
declare @Instruction_file  varchar(200)
select @Com_name=Com_name from inserted
select @pm_name=pm_name from inserted
select @Project_code =Project_code  from inserted
select @Email_id=Email_id from inserted
select @Received_date=Received_date from inserted
select @Deadline=Deadline from inserted
select @Project_status=Project_status from inserted
select @Expected_date=Expected_date from inserted
select @Source_language=Source_language from inserted
select @Target_language=Target_language from inserted
select @Volume_project=Volume_project from inserted
select @Job_type=Job_type from inserted
select @File_attached=File_attached from inserted
select @Instruction_file=Instruction_file from inserted
begin
insert adminassign values(+@Com_name,@pm_name,@Project_code, @Email_id,@Received_date,@Deadline,@Project_status,@Expected_date, @Source_language, @Target_language,@Volume_project,@Job_type, @File_attached,@Instruction_file)
end
trigger project_idcreate trigger project_idtrigger
on project_id
for
Insert as
declare @Com_name Varchar(50)
declare @pm_name Varchar(50),
declare @Project_code int,
declare @Email_id Varchar(50),
declare @Received_date varchar(50),
declare @Deadline  varchar(50),
declare @Project_status varchar(50),
declare @Expected_date varchar(50),
declare @Source_language varchar(50),
declare @Target_language varchar(50),
declare @Volume_project varchar(50),
declare @Job_type Varchar(50),
declare @File_attached varchar(200),
declare @Instruction_file  varchar(200)
select @Com_name=Com_name from inserted
select @pm_name=pm_name from inserted
select @Project_code =Project_code  from inserted
select @Email_id=Email_id from inserted
select @Received_date=Received_date from inserted
select @Deadline=Deadline from inserted
select @Project_status=Project_status from inserted
select @Expected_date=Expected_date from inserted
select @Source_language=Source_language from inserted
select @Target_language=Target_language from inserted
select @Volume_project=Volume_project from inserted
select @Job_type=Job_type from inserted
select @File_attached=File_attached from inserted
select @Instruction_file=Instruction_file from inserted
begin
insert adminassign values(+@Com_name,@pm_name,@Project_code, @Email_id,@Received_date,@Deadline,@Project_status,@Expected_date, @Source_language, @Target_language,@Volume_project,@Job_type, @File_attached,@Instruction_file)
end
 trigger assign_prcocreate trigger assign_prcotrigger
on assign_prco
for
Insert as
declare @Com_name Varchar(50)
declare @pm_name Varchar(50),
declare @Project_code int,
declare @Email_id Varchar(50),
declare @Received_date varchar(50),
declare @Deadline  varchar(50),
declare @Project_status varchar(50),
declare @Expected_date varchar(50),
declare @Source_language varchar(50),
declare @Target_language varchar(50),
declare @Volume_project varchar(50),
declare @Job_type Varchar(50),
declare @File_attached varchar(200),
declare @Instruction_file  varchar(200)
select @Com_name=Com_name from inserted
select @pm_name=pm_name from inserted
select @Project_code =Project_code  from inserted
select @Email_id=Email_id from inserted
select @Received_date=Received_date from inserted
select @Deadline=Deadline from inserted
select @Project_status=Project_status from inserted
select @Expected_date=Expected_date from inserted
select @Source_language=Source_language from inserted
select @Target_language=Target_language from inserted
select @Volume_project=Volume_project from inserted
select @Job_type=Job_type from inserted
select @File_attached=File_attached from inserted
select @Instruction_file=Instruction_file from inserted
begin
insert adminassign values(+@Com_name,@pm_name,@Project_code, @Email_id,@Received_date,@Deadline,@Project_status,@Expected_date, @Source_language, @Target_language,@Volume_project,@Job_type, @File_attached,@Instruction_file)
end
Complete trigger process
for use primary key/
create table assign_prco
(
Project_code int primary key,
Com_name Varchar(50),
pm_name Varchar(50),
Email_id Varchar(50),
Received_date varchar(50),
Deadline  varchar(50),
Project_status varchar(50),
Expected_date varchar(50),
Source_language varchar(50),
Target_language varchar(50),
Volume_project varchar(50),
Job_type Varchar(50),
File_attached varchar(200),
Instruction_file  varchar(200)
)
Posted by at No comments:

How to use Flash clock in asp.net

Default.aspx=>
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
    CodeFile="Default.aspx.cs" Inherits="_Default" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <div>
     <embed src="a.swf" width="200" height="200" wmode="transparent" type="application/x-shockwave-flash"></embed>
     <embed src=http://flash-clocks.com/free-flash-clocks-blog-topics/free-flash-clock-175.swf width=200 height=200 wmode=transparent type=application/x-shockwave-flash></embed>
     </div>

</asp:Content>
Default.aspx.cs=>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
}
Blogger TemplatesMy Blogger TricksAll Blogger Tricks
Posted by at No comments:
Subscribe to: Posts (Atom)

Contact Form

Name

Email *

Message *