Member Avatar for nagarjuna9 
<using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Sql;
using System.Data.SqlClient;


namespace studentreg
{
    public partial class WebForm1 : System.Web.UI.Page
    {


        protected void Page_Load(object sender, EventArgs e)
        {

        }


        protected void Button1_Click(object sender, EventArgs e)
        {


        SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=;Integrated Security=True");
            con.Open();
            SqlCommand cmd = con.CreateCommand();
            cmd.CommandType = System.Data.CommandType.Text;


            cmd.CommandText = ("INSERT INTO  regsiter (first name,last name,course,email,address,phoneno,parentname,gender) values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + DropDownList1.SelectedItem.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "')"); 
            cmd.ExecuteNonQuery();
           con.Close();
            Label1.Visible = true;
            Label1.Text = "registered";
        }

    }
}>
Edited by nagarjuna9 because: ExecuteNonQuery: Connection property has not been initialized.
  • 2 Contributors
  • 1 Reply
  • 251 Views
  • 4 Minutes Discussion Span
  • Latest Post Latest Post by Suzie999
Member Avatar for Suzie999

Please do daniweb members the courtessy of outlining your error.

Thanks.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.