Saturday, 5 April 2014

Insert the Data into DB in Asp.Net

Ans:-

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>InsertDataInToDB</title>
   
   
</head>
<body>
    <form id="form1" runat="server">
    <div class="demo">
        <div class="ui-widget">
            <label for="tbAuto">
                Code:
            </label>
&nbsp;<asp:TextBox ID="txtCode" runat="server" ClientIDMode="Static" Width="202px"></asp:TextBox>
            <br />
            <br />Description: <asp:TextBox ID="txtDesc" runat="server" ClientIDMode="Static" Width="210px"></asp:TextBox>
            <br />
            <br />          
            <asp:Button ID="Button1" runat="server" Text="Button" ClientIDMode="Static"
                onclick="Button1_Click" />
        </div>
    </div>
    </form>
</body>
</html>

Default.aspx.cs:-
using System;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Web.Services;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    
    public static string InsertMethod(int code, string desc)
    {
        SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=SubsDB;User ID=sa;Password=123");
        {
            SqlCommand cmd = new SqlCommand("Insert into toshfa values('" + code + "', '" + desc + "')", con);
            {
                con.Open();
                cmd.ExecuteNonQuery();
                return "True";
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        int code =Convert.ToInt32(txtCode.Text);
        InsertMethod(code, txtDesc.Text);
    }
}

Posted by at No comments:

To Check Empty TextBox and DropDownList using JavaScript Validation in Asp.Net

Ans:-
Here i have taken two TextBox and one DropDownList to check TextBoxes and DDL is Empty or not.If Empty....it will show message to Enter the Required field......See the below Codes..

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

<!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>Validation using JS</title>
    <script type="text/javascript" language="javascript">
        function validate() {
            var id = document.getElementById("txtId");
            var name = document.getElementById("txtName");
            var items=document.getElementById('<%=DropDownList1.ClientID%>')
            if (id.value == "") {
                id.focus();
                alert("Plz Enter Id..");
                return false;
            }
            else if (name.value == "") {
                name.focus();
                alert("Plz Enter Name..");
                return false;
            }
            else if (items.selectedIndex == 0) {
            items.focus();
            alert("Plz Enter Items..");
            return false;
            }
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        ID : <asp:TextBox ID="txtId" runat="server"></asp:TextBox>
        <br />
        Name : <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
        <br />
        Select Items : <asp:DropDownList ID="DropDownList1" runat="server">
         <asp:ListItem Text="Item1" Value="Item1"></asp:ListItem>
        <asp:ListItem Text="Item2" Value="Item2"></asp:ListItem>
        </asp:DropDownList>
        <br />
        <asp:Button ID="btnSubmit" OnClientClick="return validate()" runat="server" Text="Submit" />
    </div>
    </form>
</body>
</html>



Posted by at No comments:

A Small Policy Plan Application in Asp.Net

Ans:-
Here i have created 4 (.aspx).
1.For create Policy. 
  i have taken two TextBoxes (policyid & policyname), for Empty TextBoxes provide validation using JavaScript and three Buttons(Add,Clear & Save).
2.For create Plan. 
 i have taken two TextBoxes (planid & planname), for Empty TextBoxes provide JavaScript validation and three Buttons(Add,Clear & Save).
3.For save policy plan
 i have taken two DropDownList(choose policy & choose plan), provide javascript validation to DDL  and one Button(save).
4.For Show created policy wise plan
 i have taken one Gridview.
5.For GetConnection add one Class file in App_Code folder.

Means overall concept is here1. i will create one policy then 2. create plans like(Gold,Platinum,Silver,Bronze) and then 3.one policy can keep more than one plans using DropDownList and save then 4. show created policywise plans in Gridview. So for code see in below..

1.



AddPolicy.aspx:-
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="AddPolicy.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>Add Policy Page</title>
    <script type="text/javascript" language="javascript">
         function validate() {
             var id = document.getElementById("txtPolicyId");
             var name = document.getElementById("txtPolicyName");
             if (id.value == "") {
                 alert("Plz Click Add Button to generate Id..");
                 id.focus();
                 return false;
             }
             else if (name.value == "") {
                 name.focus();
                 alert("Plz Enter Name..");
                 return false;
             }
         }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <center>
    <div>
    <asp:hyperlink ID="Hyperlink1" NavigateUrl="~/AddPolicy.aspx" runat="server">AddPolicy</asp:hyperlink>
&nbsp;
<asp:hyperlink ID="Hyperlink2" NavigateUrl="~/AddPlans.aspx" runat="server">AddPlans</asp:hyperlink>
&nbsp;
<asp:hyperlink ID="Hyperlink4" NavigateUrl="~/SavePolicyPlans.aspx" runat="server">SavePolicyPlans</asp:hyperlink>
&nbsp;
<asp:hyperlink ID="Hyperlink3" NavigateUrl="~/ShowPolicyPlanDatas.aspx" runat="server">ShowPolicyPlansData</asp:hyperlink>
  
    </div>
    <div><b>Add Policy Here</b></div>
    <div>
    
    <table>
    <tr>
    <td>Policy Id</td>
    <td>:</td>
    <td><asp:TextBox ID="txtPolicyId" runat="server"></asp:TextBox></td>
    </tr>
    <tr>
    <td>Policy Name</td>
    <td>:</td>
    <td><asp:TextBox ID="txtPolicyName" runat="server"></asp:TextBox></td>
    </tr>
    </table>
   
    </div>
    <br />
    
    <asp:Label ID="lblMsg" runat="server" Text="Label"></asp:Label>
    
    <br />
    <div>
    
    <asp:Button ID="btnAdd" runat="server" Text="ADD" onclick="btnAdd_Click" />&nbsp;
     <asp:Button ID="btnClear" runat="server" Text="Clear" onclick="btnClear_Click" />&nbsp;
      <asp:Button ID="btnSave" runat="server" Text="Save" OnClientClick="return validate()" onclick="btnSave_Click" />&nbsp;
     
    </div>
     </center>
    </form>
</body>
</html>

AddPolicy.aspx.cs:-

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page 
{
    Class1 obj_Class1 = new Class1();
    SqlConnection cn;
    SqlCommand cmd;
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        cn = new SqlConnection(obj_Class1.GetConnection());
        cmd = new SqlCommand("  select isnull(MAX(policyid),0)+1 as policyid from policy", cn);
        var j="";
        try
        {
            cn.Open();
            j = cmd.ExecuteScalar().ToString();
            txtPolicyId.Text = j;
        }
        catch (Exception ex)
        {
            lblMsg.Text = ex.Message;
        }
        finally
        {
            cn.Close();
        }
        
    }
    protected void btnClear_Click(object sender, EventArgs e)
    {
        txtPolicyId.Text = string.Empty.ToString();
      txtPolicyName.Text = string.Empty.ToString();
      lblMsg.Text = string.Empty.ToString();

    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        cn = new SqlConnection(obj_Class1.GetConnection());
        cmd = new SqlCommand("insert into policy(policyid,policyname) values(@policyid,@policyname)", cn);
        cmd.Parameters.AddWithValue("@policyid", txtPolicyId.Text);
        cmd.Parameters.AddWithValue("@policyname",txtPolicyName.Text);
        int i;
        try
        {
            cn.Open();
            i = cmd.ExecuteNonQuery();
            if (i >= 0)
            {
                lblMsg.Text = "Inserted Successfully..";
            }
            else
            {
                lblMsg.Text = "Inserted Failed..";
            }
        }
        catch (Exception ex)
        {
            lblMsg.Text = ex.Message;
        }
        finally
            {
                cn.Close();
            }

    }
}

2.



AddPlans.aspx:-

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

<!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>Add Plans Page</title>
     <script type="text/javascript" language="javascript">
         function validate() {
             var id = document.getElementById("txtPlanId");
             var name = document.getElementById("txtPlanName");
             if (id.value == "") {
                 id.focus();
                 alert("Plz Click Add Button to generate Id..");
                 return false;
             }
             else if (name.value == "") {
                 name.focus();
                 alert("Plz Enter Name..");
                 return false;
             }
         }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <center>
    <div>
     <asp:hyperlink ID="Hyperlink1" NavigateUrl="~/AddPolicy.aspx" runat="server">AddPolicy</asp:hyperlink>
&nbsp;
<asp:hyperlink ID="Hyperlink2" NavigateUrl="~/AddPlans.aspx" runat="server">AddPlans</asp:hyperlink>
&nbsp;
<asp:hyperlink ID="Hyperlink4" NavigateUrl="~/SavePolicyPlans.aspx" runat="server">SavePolicyPlans</asp:hyperlink>
&nbsp;
<asp:hyperlink ID="Hyperlink3" NavigateUrl="~/ShowPolicyPlanDatas.aspx" runat="server">ShowPolicyPlansData</asp:hyperlink>
   
    </div>
    <div><b>Add Plans Here</b></div>
   <div>
    
    <table>
    <tr>
    <td>Plan Id</td>
    <td>:</td>
    <td><asp:TextBox ID="txtPlanId" runat="server"></asp:TextBox></td>
    </tr>
    <tr>
    <td>Plan Name</td>
    <td>:</td>
    <td><asp:TextBox ID="txtPlanName" runat="server"></asp:TextBox></td>
    </tr>
    </table>
   
    </div>
    <br />
     
    <asp:Label ID="lblMsg" runat="server" Text="Label"></asp:Label>
   
    <br />
    <div>
    
    <asp:Button ID="btnAdd" runat="server" Text="ADD" onclick="btnAdd_Click" />&nbsp;
     <asp:Button ID="btnClear" runat="server" Text="Clear" onclick="btnClear_Click" />&nbsp;
      <asp:Button ID="btnSave" runat="server" Text="Save" OnClientClick="return validate()" onclick="btnSave_Click" />
     
    </div>
     </center>
    </form>
</body>
</html>

AddPlans.aspx.cs:-

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class AddPlans : System.Web.UI.Page
{
    Class1 obj_Class1 = new Class1();
    SqlConnection cn;
    SqlCommand cmd;
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        txtPlanName.Focus();
        cn = new SqlConnection(obj_Class1.GetConnection());
        cmd = new SqlCommand("select isnull(MAX(planid),0)+1 as planid from plans", cn);
        var j = "";
        try
        {
            cn.Open();
            j = cmd.ExecuteScalar().ToString();
            txtPlanId.Text = j;
        }
        catch (Exception ex)
        {
            lblMsg.Text = ex.Message;
        }
        finally
        {
            cn.Close();
        }
        
    }
    protected void btnClear_Click(object sender, EventArgs e)
    {
        txtPlanId.Text = string.Empty.ToString();
        txtPlanName.Text = string.Empty.ToString();
        lblMsg.Text = string.Empty.ToString();
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
            cn = new SqlConnection(obj_Class1.GetConnection());
            cmd = new SqlCommand("insert into plans(planid,planname) values(@planid,@planname)", cn);
            cmd.Parameters.AddWithValue("@planid", txtPlanId.Text);
            cmd.Parameters.AddWithValue("@planname", txtPlanName.Text);
            int i;
            try
            {
                cn.Open();
                i = cmd.ExecuteNonQuery();
                if (i >= 0)
                {
                    lblMsg.Text = "Inserted Successfully..";
                }
                else
                {
                    lblMsg.Text = "Inserted Failed..";
                }
            }
            catch (Exception ex)
            {
                lblMsg.Text = ex.Message;
            }
            finally
            {
                cn.Close();
            }
        }
}

3.


SavePolicyPlans.aspx:-

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

<!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 Policy Plan Page</title>
    <script type="text/javascript" language="javascript">
        function validate() {

            var items1 = document.getElementById('<%=DDLPolicyNameId.ClientID%>');
            var items2 = document.getElementById('<%=DDLPlanNameID.ClientID%>')
            if (items1.selectedIndex == 0) {
                items1.focus();
                alert("Plz Enter PolicyNameId..");
                return false;
            }
            else if (items2.selectedIndex == 0) {
            items2.focus();
            alert("Plz Enter PlanNameId..");
            return false;
            }
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <center>
    <div>
    
<asp:hyperlink ID="Hyperlink1" NavigateUrl="~/AddPolicy.aspx" runat="server">AddPolicy</asp:hyperlink>
&nbsp;
<asp:hyperlink ID="Hyperlink2" NavigateUrl="~/AddPlans.aspx" runat="server">AddPlans</asp:hyperlink>
&nbsp;
<asp:hyperlink ID="Hyperlink4" NavigateUrl="~/SavePolicyPlans.aspx" runat="server">SavePolicyPlans</asp:hyperlink>
&nbsp;
<asp:hyperlink ID="Hyperlink3" NavigateUrl="~/ShowPolicyPlanDatas.aspx" runat="server">ShowPolicyPlansData</asp:hyperlink>
  
    </div>
    <div><b>Save PolicyPlans Here</b></div>
    <div>
    <table>
     <tr>
    <td>Choose Policy</td>
    <td>:</td>
    <td><asp:DropDownList ID="DDLPolicyNameId" runat="server"></asp:DropDownList></td>
    <td></td>
    <td></td>
    </tr>
     <tr>
    <td>Choose Plans</td>
    <td>:</td>
    <td><asp:DropDownList ID="DDLPlanNameID" runat="server"></asp:DropDownList></td>
    </tr>
   
    </table>
    </div>
    <br />
  <asp:Label ID="lblMsg" runat="server" Text="Label"></asp:Label>
   <br />
    <div>
      <asp:Button ID="btnSave" runat="server" Text="Save" OnClientClick="return validate()" onclick="btnSave_Click" />
    </div>
     </center>
    </form>
</body>
</html>

SavePolicyPlans.aspx.cs:-

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class AddPlans : System.Web.UI.Page
{
    Class1 obj_Class1 = new Class1();
    SqlConnection cn;
    SqlCommand cmd;
    SqlDataAdapter da;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindDDLPolicyNameId();
            BindPlanName();
        }
    }
    void BindDDLPolicyNameId()
    {
        cn = new SqlConnection(obj_Class1.GetConnection());
        cmd = new SqlCommand("select policyname+'-'+CAST(policyid as varchar) as policyname,policyid from policy", cn);
        da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        DDLPolicyNameId.DataTextField = "policyname";
        DDLPolicyNameId.DataValueField = "policyid";
        DDLPolicyNameId.DataSource = dt;
        DDLPolicyNameId.DataBind();
        DDLPolicyNameId.Items.Insert(0, "--Choose Policy--");
    }
    void BindPlanName()
    {
        cn = new SqlConnection(obj_Class1.GetConnection());
        cmd = new SqlCommand("select planname+'-'+Cast(planid as varchar) as planname,planid from plans", cn);
        da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        DDLPlanNameID.DataTextField = "planname";
        DDLPlanNameID.DataValueField = "planid";
        DDLPlanNameID.DataSource = dt;
        DDLPlanNameID.DataBind();
        DDLPlanNameID.Items.Insert(0, "--Choose Plan--");
    }

    protected void btnSave_Click(object sender, EventArgs e)
    {
        cn = new SqlConnection(obj_Class1.GetConnection());
        cmd = new SqlCommand();
        cmd.Connection = cn;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "spSavePolicyPlansData";
        cmd.Parameters.AddWithValue("@policypid", SqlDbType.VarChar).Value = DDLPolicyNameId.SelectedValue;         //Get Integer value from DDL
        cmd.Parameters.AddWithValue("@policypname", SqlDbType.VarChar).Value = DDLPolicyNameId.SelectedItem.Text;   //Get String value from DDL
        cmd.Parameters.AddWithValue("@planpid", SqlDbType.VarChar).Value = DDLPlanNameID.SelectedValue;
        cmd.Parameters.AddWithValue("@planpname", SqlDbType.VarChar).Value = DDLPlanNameID.SelectedItem.Text;;
        cmd.Parameters.AddWithValue("@mode", "insert");
        int i=0;
        try
        {
            cn.Open();
            i = cmd.ExecuteNonQuery();
            if (i >= 0)
            {
                lblMsg.Text = "Inserted Successfully..";
            }
            else
            {
                lblMsg.Text = "Inserted Failed..";
            }
        }
        catch (Exception ex)
        {
            lblMsg.Text = ex.Message;
        }
        finally
        {
            cn.Close();
        }

    }
}

4.


ShowPolicyPlanDatas.aspx:-

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

<!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>Show Policy Plan Data Page</title>
</head>
<body>
    <form id="form1" runat="server">
     <center>
     <div>
      <asp:hyperlink ID="Hyperlink1" NavigateUrl="~/AddPolicy.aspx" runat="server">AddPolicy</asp:hyperlink>
&nbsp;
<asp:hyperlink ID="Hyperlink2" NavigateUrl="~/AddPlans.aspx" runat="server">AddPlans</asp:hyperlink>
&nbsp;
<asp:hyperlink ID="Hyperlink4" NavigateUrl="~/SavePolicyPlans.aspx" runat="server">SavePolicyPlans</asp:hyperlink>
&nbsp;
<asp:hyperlink ID="Hyperlink3" NavigateUrl="~/ShowPolicyPlanDatas.aspx" runat="server">ShowPolicyPlansData</asp:hyperlink>
  
    
     </div>
     <div><b>Show PolicyPlan Data</b></div>
    <div>
   
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
       
    </div>
     </center>
    </form>
</body>
</html>

ShowPolicyPlanDatas.aspx.cs:-

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class ShowPolicyPlanDatas : System.Web.UI.Page
{
    Class1 obj_Class1 = new Class1();
    SqlConnection cn;
    SqlCommand cmd;
    SqlDataAdapter da;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGvData();
        }
    }
    void BindGvData()
    {
        cn = new SqlConnection(obj_Class1.GetConnection());
        cmd = new SqlCommand("select * from policyplans", cn);
        da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        GridView1.DataSource = dt;
        GridView1.DataBind();

    }
}

5.

In Class.cs:- file for GetConnection..

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

/// <summary>
/// Summary description for Class1
/// </summary>
public class Class1
{
          public Class1()
          {
                   //
                   // TODO: Add constructor logic here
                   //
          }
    public string GetConnection()
    {
        string strCon = "server=.;database=subsdb;user id=sa;pwd=123";
        return strCon;
    }
}

Create Tables &  Stored Procedures:-

1.create table policy(policyid int constraint pr primary key ,policyname varchar(30))

2.create table plans(planid int constraint pr2 primary key,planname varchar(30))   
  
  --using on cascade delete & on cascade UPDATE
 3. create table policyplans(policypid int constraint fr1 foreign key references policy(policyid) on delete cascade on update cascade,policypname varchar(30),planpid int constraint fr2 foreign key references plans(planid) on delete cascade on update cascade,planpname varchar(30) )

4. insert into policy values(1,'subspolicy');
    insert into plans values(101,'Gold');

 --system generating policyid
  5.select isnull(MAX(policyid),0)+1 as policyid from policy
  
  --append string & integer
 6. select policyname+'-'+CAST(policyid as varchar) as policyname,policyid from policy
  
  --using mode as insert & update
7.create proc spSavePolicyPlansData(@policypid int,@policypname varchar(30),@planpid int,@planpname varchar(30),@mode varchar(30)) 
as 
begin
if @mode='insert'
begin 
insert into policyplans(policypid,policypname,planpid,planpname) values(@policypid,@policypname,@planpid,@planpname)
end
else if @mode='update'
begin
update policyplans set planpname=@planpname,policypname=@policypname  where policypid=@policypid and planpid=@planpid
end
end
Posted by at No comments:
Subscribe to: Comments (Atom)