how to save ascx values from aspx page to database,,?

Question

0.00/5 (No votes)

See more:

C#

MainUserControl1.Name = "";//this from ascx page
string Title;//this from aspx
 SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["dbConnection"].ToString());

        con.Open();
        SqlCommand cmd = new SqlCommand();

        cmd.Connection = con;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "usp_InsertPatientAddmission";

        SqlParameter paraTitle = new SqlParameter("@Title", SqlDbType.VarChar, 50);
        paraTitle.Value = Title;
        cmd.Parameters.Add(paraTitle);//this from aspx

        SqlParameter paraName = new SqlParameter("@Name", SqlDbType.VarChar, 50);
        paraName.Value = MainUserControl1.Name;
        cmd.Parameters.Add(paraName);//is in correct format??//this from ascx page..

hi here is my code.i want to add this values to database but title is adding and Name field is not adding to database.(name field m calling to ascx to aspx page)..can anyone solve,..

Posted 9-Jan-12 22:42pm

ythisbug

Updated 10-Jan-12 17:47pm

v4

Add a Solution

2 solutions

Solution 1

To access form field that is defined in user control, you need to define a property on that user control.
Eg.

UserControl.ascx

<asp:textbox id="NameTB" runat="server" />

in UserControl.ascx.cs:

public string Name
{
   get { return NameTB.Text; }
}

Posted 10-Jan-12 6:27am

Elina Blank

Updated 11-Jan-12 3:35am

v2

Comments

fjdiewornncalwe 10-Jan-12 13:11pm

+5. Absolutely.

Elina Blank 10-Jan-12 13:20pm

thanks :)

ythisbug 10-Jan-12 23:44pm

hi elina so no need of giving set in ascx.cs page??and wat should i write in aspx.cs file..how to call that field from ascx to aspx.cs file

ythisbug 10-Jan-12 23:49pm

public string Name
{
get { return NameTB.Value; }
}

this code is not working..Value is coming..

Elina Blank 11-Jan-12 9:36am

It is Text, not Value. And you can have set, but do not have to.

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)

ythisbug · Accepted Answer · 2012-01-10T23:19:00

aspx.cs

SqlParameter paraName = new SqlParameter("@Name", SqlDbType.VarChar, 50);
paraName.Value = MainUserControl1.Name;
cmd.Parameters.Add(paraName);

in ascx.cs

C#

public string Name
   {
       get
       {
           return txtFname.Text;
       }
       set
       {
           txtFname.Text = value;

       }

   }

this s the code to save values in database,