Inserting data into database using user control

Question

4.00/5 (1 vote)

See more:

this is my control.ascx page

XML

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="control.ascx.cs" Inherits="control" %> <table> <tr> <td align="right">Name:</td> <td align="right"><asp:TextBox runat="server" ID="txtName"></asp:TextBox></td> </tr> <tr> <td align="right">LastName:</td> <td align="right"><asp:TextBox runat="server" ID="txtLastName"></asp:TextBox></td> </tr> <tr> <td align="right">PhoneNo:</td> <td align="right"><asp:TextBox runat="server" ID="txtPhone"></asp:TextBox></td> </tr> </table>

this is my control.ascx.cs page

C#

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; public partial class control : System.Web.UI.UserControl { public string name { get { return txtName.Text; ****************-here am getting error"""Object reference not set to an instance of an object"************** } set { txtName.Text = value; } } public string lastname { get { return txtName.Text; } set { txtName.Text = value; } } public string phoneno { get { return txtPhone.Text; } set { txtPhone.Text = value; } } protected void Page_Load(object sender, EventArgs e) { } }

this is my default.aspx page

XML

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <%@ Register src="control.ascx" tagname="control" tagprefix="uc1" %> <!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> <uc1:control ID="control1" runat="server" /> </div> <br /> <asp:Button runat="server" ID="btnInsert" Text="insert" onclick="btnInsert_Click" /> </form> </body> </html>

this is my default.aspx.cs page

C#

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 { SqlConnection con = new SqlConnection("user id=sa;password=123;database=srikanth;data source=sri"); SqlCommand cmd = new SqlCommand(); protected void Page_Load(object sender, EventArgs e) { } protected void btnInsert_Click(object sender, EventArgs e) { control c = new control(); con.Open(); cmd = new SqlCommand("insert into emp(name,lastname,phone) values('" +c.name + "','" + c.lastname + "','" + c.phoneno + "'", con); cmd.ExecuteNonQuery(); con.Close(); } }

Posted 5-Dec-12 2:23am

Member 9560415

Updated 5-Dec-12 3:18am

Herman<T>.Instance

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Teenustar · Answer 1 · 2012-12-05T04:58:00

The problem is in your Default.aspx.cs

In the button click event, you must use the control ID ie. control1.name which you have used in your Default.aspx page.

the code should be as below

C#

protected void btnInsert_Click(object sender, EventArgs e)
          {
          con.Open();
          cmd = new SqlCommand("insert into emp(name,lastname,phone) values('" + control1.name + "','" + control1.lastname + "','" + control1.phoneno + "'", con);
          cmd.ExecuteNonQuery();
          con.Close();
          }

Krunal Rohit · Answer 2 · 2012-12-05T02:28:00

Solution 1

make this kind of change in your control.ascx.cs

C#

string name = txtName.Text;
public string _name
   {
       get
       {
           return name;
       }
       set
       {
           name = value;
       }
   }

Hope this will work (blindly assumption)

Posted 5-Dec-12 2:28am

Krunal Rohit

Comments

Teenustar 5-Dec-12 11:03am

This solution won't solve the problem.

Hiteshforu2007 · Answer 3 · 2012-12-05T02:28:00

Solution 2

Are you getting any error. You have not mentioned what you exactly want.

Posted 5-Dec-12 2:28am

Hiteshforu2007

Comments

Member 9560415 5-Dec-12 8:38am

ya am getting error..... i mentioned error message in default.aspx.cs page

Member 9560415 5-Dec-12 8:40am

sorry control.ascx.cs page