3
Answers

MVC CRUD Operations using Modal - Latest version JQUERY

Rohan Laghate

Rohan Laghate

8y
626
1
Hello,
 
I am new to MVC and I am trying to develop a sample application wherein I need to display the Create/Details/Edit views (Partial Views) in a modal.
 
I did find many examples on net including this forum. However, with the latest version of JQUERY things seems to be difficult as lot of things seems to have been modified. Somehow, I am stuck and not able to proceed. eg. 'live' has also being deprecated in the latest version of JQUERY.
 
Lot of confusion around, Can someone please give me a clean approach on how can I achieve my above requirement ?
 
Help me learn :) 
 
Thanks!
Rohan 
 
Answers (3)
0
Sam Hobbs
NA 28.7k 1.3m 13y
The easiest and most reliable way is to create an auto-incrementing database field and then when you insert a new customer, get the number of the new customer record. The number will be only the number part; it would not include the "E" part. The E could be added whenever it is needed for formatting. Will the "E" part ever be something other than E? If so, then what is the meaning of it?
0
magesh manavalan
NA 244 423.5k 13y
Hi dear thanx for ur co operations and help ur codings.


Thanks&Regs

Magesh.A
0
Satyapriya Nayak
NA 53k 8m 13y
Hi Magesh,



 

Create table employee(empid varchar(50),empname varchar(50),sal int)

 
Default.aspx code

 

<%@ 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>Untitled Page</title>

</head>

<body>

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

    <div>

  

        <asp:Label ID="Label1" runat="server" Text="EmpId" Font-Bold="True"

            Width="100px"></asp:Label>

    <asp:TextBox ID="txt_empid" runat="server"></asp:TextBox><br />

    <asp:Label ID="Label2" runat="server" Text="EmpName" Font-Bold="True" Width="100px"></asp:Label>

    <asp:TextBox ID="txt_empname" runat="server"></asp:TextBox><br />

    <asp:Label ID="Label3" runat="server" Text="Salary" Font-Bold="True" Width="100px"></asp:Label>

    <asp:TextBox ID="txt_sal" runat="server"></asp:TextBox><br />

    </div>

  

    <asp:Button ID="btn_insert" runat="server" onclick="btn_insert_Click"

        Text="Insert Data" /><br />

    <asp:Label ID="Label4" runat="server"></asp:Label>

  

    </form>

</body>

</html>

 
Default.aspx.cs code

 

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

{

    string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

    string str;

    SqlCommand com;

    int count;

    protected void Page_Load(object sender, EventArgs e)

    {

        SqlConnection con = new SqlConnection(strConnString);

        str = "select count(*) from employee";

        com = new SqlCommand(str, con);

        con.Open();

        count = Convert.ToInt16(com.ExecuteScalar()) + 1;

        txt_empid.Text = "E000" + count;

        con.Close();

    }

    protected void btn_insert_Click(object sender, EventArgs e)

    {

        SqlConnection con = new SqlConnection(strConnString);

        con.Open();

        str = "insert into employee values('" + txt_empid.Text.Trim() + "','" + txt_empname.Text.Trim() + "'," + txt_sal.Text.Trim() + ")";

        com = new SqlCommand(str, con);

        com.ExecuteNonQuery();

        con.Close();

        Label4.Text = "Records successfully Inserted";

    }

}

Thanks
If this post helps you mark it as answer