CODEWITHSUNDEEP
asp.net-core.net-core
Rahul Patil
Rahul Patil

Reputation: 142

How to Insert In .net core?

I want to insert data using ssms but not inserted data in ssms using .net core??

Insertion code, WebForm1.aspx.cs:

namespace InsertUpdateDelete.scripts
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void btninsert_Click(object sender, EventArgs e)
        {
            string name = txtName.Text;
            string address = txtAddress.Text;
            Insert_Click(name, address);
        }

        void Insert_Click(string name, string address)
        {
            SqlConnection con = new SqlConnection(connstring);

            string query = "Insert into DemoInUpDelete (Name, Address) values (@Name,@Address)";
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.CommandType = CommandType.Text;
            //Pass values to Parameters
            cmd.Parameters.AddWithValue("@Name", name);
            cmd.Parameters.AddWithValue("@Address", address);
            try
            {
                con.Open();
                int validateOperation = cmd.ExecuteNonQuery();
                if (validateOperation > 0)
                {
                    //Message insert succesfully
                }
                else
                {
                    //Error
                }
            }
            catch (SqlException e)
            {
                //Exception
            }
            finally
            {
                con.Close();
            }

        void Update_Click(object sender, EventArgs e)
        {
               //update
        }

        void Delete_Click(object sender, EventArgs e)
        {
                   //delete
        }


    }
}

WebForm.aspx:


<body>


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

    <table>
         <tr>  
            <td>Name:</td>  
            <td><asp:TextBox ID="txtName" runat="server"></asp:TextBox></td>  
        </tr>  

        <tr>  
            <td>Address:</td>  
            <td><asp:TextBox ID="txtAddress" runat="server"></asp:TextBox></td>  
            <td> </td>  
        </tr>  

        <tr>  
            <td>  
               <asp:Button ID="btninsert" runat="server" Text="Insert" OnClick="btninsert_Click" />
               <asp:Button ID="btnUpdate" runat="server" Text="Update" OnClick="Update_Click" />  
               <asp:Button ID="btnCancel" runat="server" Text="Delete" OnClick="Delete_Click" />
            </td>  
        </tr>  
  </table>

    </form>
</body>

I m new in.net how to insert data in sql server SQL Server Management Studio? I m creating a simple new->project but not insert data?? DataBase: I m creating database and Id(primarykey) name(varchar(20) address(varchar(20)

.net give error

SqlConnection con = new SqlConnection(connstring); connstring does not exist the current context

web.config.cs:

<configuration>

  <connectionStrings>
    <add name="ConnStringName" connectionString="Data Source= DESKTOP-U3PB1TF\SA; Integrated Security=true;Initial Catalog= InUpDelete; uid=sa; Password=admin@123; " providerName="System.Data.SqlClient" />
  </connectionStrings>

</connectionStrings>

Upvotes: 0

Views: 716

Answers (1)

Divyesh patel
Divyesh patel

Reputation: 987

@Jeremy Thompson Stated as comment you miss the Insert operation code

Below code may help you.

aspx Code:

 <asp:Button ID="btninsert" runat="server" Text="Insert" OnClick="btninsert_Click" />

C# code:

 protected void btninsert_Click(object sender,EventArgs e)
 {
   string name=txtName.Text;
   string address=txtAddtess.Text;
   Insert_Click(name,address);
 }


 void Insert_Click(string name,string address)
    {
        string connstring=System.Configuration.ConfigurationManager.
ConnectionStrings["ConnStringName"].ConnectionString;

        SqlConnection con = new SqlConnection(connstring);

        string query = "Insert into DemoInUpDelete (Name, Address) values (@Name,@Address)";           
        SqlCommand cmd = new SqlCommand(query, con);
        cmd.CommandType=CommandType.Text;            
        //Pass values to Parameters
        cmd.Parameters.AddWithValue("@Name", name);
        cmd.Parameters.AddWithValue("@Price", address);         
        try
        {
            con.Open();
            int validateOperation=cmd.ExecuteNonQuery();
    if(validateOperation>0)
    {
        //Message insert succesfully
            }
            else
            {
             //Error
             }               
        }
        catch (SqlException e)
        {
           //Exception
        }
        finally
        {
            con.Close();               
        }
}

Upvotes: 3

Related Questions