Total Pageviews

20 April 2012

How to show hide sidebar



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>
        <h2 style="color: Navy; font-style: italic;">
            Wizard Example: show hide sidebar</h2>
        <asp:Wizard ID="Wizard1" runat="server" DisplaySideBar="true" BorderColor="RosyBrown"
            BorderWidth="2" HeaderText="Sample Wizard" HeaderStyle-BackColor="PeachPuff"
            HeaderStyle-ForeColor="SaddleBrown" HeaderStyle-Font-Size="Large" Height="200"
            Width="400">
            <WizardSteps>
                <asp:WizardStep Title="First Step">
                    <asp:Label ID="Label1" runat="server" Font-Bold="false" ForeColor="PaleVioletRed"
                        Font-Size="Large" Font-Names="Comic Sans MS" Text="This is first step"> 
                    </asp:Label>
                </asp:WizardStep>
                <asp:WizardStep Title="Second Step">
                    <asp:Label ID="Label2" runat="server" Font-Bold="false" ForeColor="PaleVioletRed"
                        Font-Size="Large" Font-Names="Comic Sans MS" Text="This is second step"> 
                    </asp:Label>
                </asp:WizardStep>
            </WizardSteps>
        </asp:Wizard>
        <br />
        <asp:Button ID="Button1" runat="server" ForeColor="SteelBlue" Text="Hide Wizard SideBar"
            Height="45" OnClick="Button1_Click" Font-Bold="true" />
        <asp:Button ID="Button2" runat="server" ForeColor="SteelBlue" Text="Show Wizard SideBar"
            Height="45" OnClick="Button2_Click" Font-Bold="true" />
    </div>
</asp:Content>
Deafault.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)
    {
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Wizard1.DisplaySideBar = false;
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Wizard1.DisplaySideBar = true;
    }
}

Upload and Download Files from file system



Default.aspx=>
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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">
<title>Save and Download Files from file system</title>
<style type="text/css">
.modalBackground
{
background-color: Gray;
filter: alpha(opacity=80);
opacity: 0.8;
z-index: 10000;
}
.GridviewDiv {font-size: 100%; font-family: 'Lucida Grande', 'Lucida Sans Unicode', Verdana, Arial, Helevetica, sans-serif; color: #303933;}
Table.Gridview{border:solid 1px #df5015;}
.Gridview th{color:#FFFFFF;border-right-color:#abb079;border-bottom-color:#abb079;padding:0.5em 0.5em 0.5em 0.5em;text-align:center}
.Gridview td{border-bottom-color:#f0f2da;border-right-color:#f0f2da;padding:0.5em 0.5em 0.5em 0.5em;}
.Gridview tr{color: Black; background-color: White; text-align:left}
:link,:visited { color: #DF4F13; text-decoration:none }
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:FileUpload ID="fileUpload1" runat="server" /><br />
<asp:Button ID="btnUpload" runat="server" Text="Upload" onclick="btnUpload_Click" />
</div>
<div>
<asp:GridView ID="gvDetails" CssClass="Gridview" runat="server" AutoGenerateColumns="false" DataKeyNames="FilePath">
<HeaderStyle BackColor="#df5015" />
<Columns>
<asp:BoundField DataField="Id" HeaderText="Id" />
<asp:BoundField DataField="FileName" HeaderText="FileName" />
<asp:TemplateField HeaderText="FilePath">
<ItemTemplate>
<asp:LinkButton ID="lnkDownload" runat="server" Text="Download" OnClick="lnkDownload_Click"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
Default.aspx.cs=>
using System;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    private SqlConnection con = new SqlConnection("Data Source=AMRIT;Initial Catalog=dct;Integrated Security=True");
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack)
        {
            BindGridviewData();
        }
    }
    // Bind Gridview Data
    private void BindGridviewData()
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("select * from FilesTable",con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        con.Close();
        gvDetails.DataSource = ds;
        gvDetails.DataBind();
    }
    // Save files to Folder and files path in database
    protected void btnUpload_Click(object sender, EventArgs e)
    {
        string filename = Path.GetFileName(fileUpload1.PostedFile.FileName);
        fileUpload1.SaveAs(Server.MapPath("Files/"+filename));
        con.Open();
        SqlCommand cmd = new SqlCommand("insert into FilesTable(FileName,FilePath) values(@Name,@Path)",con);
        cmd.Parameters.AddWithValue("@Name",filename );
        cmd.Parameters.AddWithValue("@Path", "Files/"+filename );
        cmd.ExecuteNonQuery();
        con.Close();
        BindGridviewData();
    }
    // This button click event is used to download files from gridview
    protected void lnkDownload_Click(object sender, EventArgs e)
    {
        LinkButton lnkbtn = sender as LinkButton;
        GridViewRow gvrow = lnkbtn.NamingContainer as GridViewRow;
        string filePath = gvDetails.DataKeys[gvrow.RowIndex].Value.ToString();
        Response.ContentType = "image/jpg";
        Response.AddHeader("Content-Disposition", "attachment;filename=\"" + filePath + "\"");
        Response.TransmitFile(Server.MapPath(filePath));
        Response.End();
    }
}

18 April 2012

How to send Online mail in asp.net


About.aspx=>
<%@ Page Title="About Us" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
    CodeFile="About.aspx.cs" Inherits="About" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
   
    <table class="style5">
    <tr>
        <td class="style7">
            &nbsp;</td>
        <td class="style8">
            <asp:Label ID="dsl" Runat="server" ForeColor="#CC0000"></asp:Label>
        </td>
        <td>
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style7">
            <strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; To&nbsp;</strong></td>
        <td class="style8">
            <asp:TextBox ID="t6" runat="server" Width="175px"></asp:TextBox>
        </td>
        <td>
            &nbsp;</td>
    </tr>
    <tr>
        <td class="style7">
            <strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; From</strong></td>
        <td class="style8">
            <asp:TextBox ID="t7" runat="server" Height="23px" Width="176px"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style7">
            <strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Subject</strong></td>
        <td class="style8">
            <asp:TextBox ID="t8" runat="server" Height="20px" Width="176px"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style7">
            <strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Body</strong></td>
        <td class="style8">
            <asp:TextBox ID="t9" runat="server" Height="88px" TextMode="MultiLine"></asp:TextBox>
        </td>
    </tr>
    <tr>
        <td class="style5" colspan="2">
            <div>
                <strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Attachment:</strong>&nbsp;<asp:FileUpload
                    ID="fp0" runat="server" />
                <br />
            </div>
        </td>
    </tr>
    <tr>
        <td align="center" colspan="2">
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <asp:Button ID="Button2" runat="server" BorderStyle="None" Font-Bold="True"
                Font-Italic="True" ForeColor="#990033" onclick="Button2_Click"
                Text="Send Email" />
        </td>
    </tr>
</table>
   
</asp:Content>
About.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.Net;
using System.Net.Mail;
using System.IO;
public partial class About : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        String s = t6.Text;
        String[] toId = s.Split(',');
        MailMessage mail = new MailMessage();
        for (int i = 0; i <= toId.Length - 1; i++)
        {
            mail.To.Add(toId[i].ToString());
        }
        mail.To.Add(new MailAddress(t6.Text));
        mail.From = new MailAddress("ownEmailid");
        mail.IsBodyHtml = true;
        mail.Subject = t8.Text;
        mail.Body = t9.Text;
        SmtpClient smtp1 = new SmtpClient();
        smtp1.Host = "smtp.gmail.com";
        smtp1.Port = 587;
        smtp1.UseDefaultCredentials = false;
        smtp1.Credentials = new NetworkCredential("Own Emailid", "pass");
        smtp1.EnableSsl = true;
        byte[] data = new byte[102400];
        //System.IO.MemoryStream stream = new System.IO.MemoryStream(data);
        //Attachment attach = new Attachment(stream, "Attachment file name");
        //mail.Attachments.Add(attach);
        if (fp0.HasFile)
   {
      mail.Attachments.Add(new Attachment(fp0.PostedFile.InputStream, fp0.FileName));
       }
        smtp1.Send(mail);
        t6.Text = "";
        t8.Text = "";
        t9.Text = "";
        dsl.Visible = true;
        dsl.Text = "Message sent.";
    }
}

How to upload Large file in Asp.net


How upload Large file in Asp.net programme

To make the above modifications to your application for large file uploads you need to:
1.Open the Solution Explorer, navigate to the application web.config file and open it.
2.Under the <configuration> element locate the <system.web> element. Add it if it does not exist.
3.Under the <system.web> element locate the <httpRuntime> element. Add it if it does not exist.
4.In the <httpRuntime> element locate the maxRequestLength and executionTimeout attributes. If they do not exist, add them and set their values:
Webconfig=>
<configuration>
...
    <system.web>
      <httpRuntime maxRequestLength="102400" executionTimeout="3600" />
      ...
    </system.web>
</configuration>
For IIS7=><system.webserver>
...
<security >
    <requestFiltering>
        <requestLimits maxAllowedContentLength="1024000000" />
    </requestFiltering>
</security>
</system.webserver>•Open the file C:\Windows\System32\inetsrv\config\applicationHost.config and find the line:
<section name="requestFiltering" overrideModeDefault="Deny" />
•Set the overrideModeDefault property to Allow. So now the line should look like:
<section name="requestFiltering" overrideModeDefault="Allow" />

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"/>

 



 

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)
)

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

Contact Form

Name

Email *

Message *