Accessing the value from usercontrol in windows app

Question

0.00/5 (No votes)

See more:

I have a usercontrol called AddRow and a form called TimeSheet ,Timesheet has a save_btn event, on click of save_btn the value enter in usercontrol should be written to database,but I am not able to access the value from usercontrol

below is the code

C#

public void save_btn_Click(object sender, EventArgs e)
    {

        SqlCommand cmdinsert = new SqlCommand("insert into TimeSheet (Project_Name ,Activity_Name,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday) values (@Project_Name,@Activity_Name,@Monday,@Tuesday,@Wednesday,@Thursday,@Friday,@Saturday,@Sunday) ", con);
        cmdinsert.Parameters.AddWithValue("@Project_Name",  add.project_cbox.SelectedIndex);
        cmdinsert.Parameters.AddWithValue("@Activity_Name", activity_cb.SelectedIndex);
        cmdinsert.Parameters.AddWithValue("@Monday", add.monday_txt_val);
        cmdinsert.Parameters.AddWithValue("@Tuesday", add.tuesday_txt_val);
        cmdinsert.Parameters.AddWithValue("@Wednesday", add.wednesday_txt.Text);
        cmdinsert.Parameters.AddWithValue("@Thursday", add.thursday_txt.Text);
        cmdinsert.Parameters.AddWithValue("@Friday", add.friday_txt.Text);
        cmdinsert.Parameters.AddWithValue("@Saturday", add.saturday_txt.Text);
        cmdinsert.Parameters.AddWithValue("@Sunday", add.sunday_txt.Text);
        con.Open();
        cmdinsert.ExecuteNonQuery();
        con.Close();  

    }

this event is in timesheet but the value is empty string...I just cant access the value,is there a solution? this is window application

C#

public string monday_txt_val
    {
        get
        {
            return monday_txt.Text;
        }

        set
        {
            monday_txt.Text = value;
        }
    }

monday_txt is a textbox that is created dynamically,after the value is entered ,but it is reading a empty string,despite me entering a value in textbox,when it is passed to form value of monday_txt is empty string,how to fix this?

only way I can think of accessing monday_txt is by creating a instance of AddRow in Timesheet..but When new instance is created I will not be able to get the value, kindly help

Posted 17-Jan-13 23:50pm

arsr24

Add a Solution

1 solution

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)

OriginalGriff · Accepted Answer · 2013-01-17T23:58:00

Solution 1

You don't want to create an new instance - you need to get the actual instance of the UserControl that you created dynamically and presented to the user for him to fill in. There are two ways:
1) Keep a class level reference in your form class when you call new AddRow() to add the control,
2) Look through the Form.Controls collection to find the AddRow instance - remember that if you add it to a panel or other container, you will need to recurse through containers to find it.

Posted 17-Jan-13 23:58pm

OriginalGriff

Comments

arsr24 18-Jan-13 6:24am

@OriginalGriff-hey!!,I know I shouldnt create a new instance,I am adding usercontrol dynamically,on a click_event the control is added,problem is if I dont create a instance of usercontrol error message is thrown,will you please explain it to me with code,it will help me great deal,also this is a windows app,I tried using findcontrol ,but I couldn`t find it..it would be easy for me to understand if you will explain with code..thank you

OriginalGriff 18-Jan-13 6:36am

I can't because I don't know what you are doing when you add the control in the click event - but at that point you want to save the instance you create, because that is (probably, I can't see how your system works from here) the instance you need to query for the values - if you query any other instance, you will get blank values (or the wrong values if you have created more than one)

arsr24 18-Jan-13 6:41am

@Griff,how do I do it Griff? please help me,if I dont create new instance of my usercontrol in my form how will I get to access the textboxes created in usercontrol?

OriginalGriff 18-Jan-13 6:51am

You have to create an instance, but =when you create it you should keep a reference to it somewhere - or otherwise you don't know which one is which if you need a second at some point.
So in your click event handler you either need to save the new instance of a AddRow in a class (i.e. form) level variable as you create them, or perhaps in a class level List of AddRows if you can add more than one (and using a click event to add one does sound like you do - I'm guessing these are new rows of data for your user to enter and you need to save them all in a database when he says "ok")

arsr24 18-Jan-13 6:34am

@OriginalGriff - Will you please elaborate,I keep a reference variable called count,but then I just dont know how to go about solving this issues,I am stuck here,any help would be much appreciated

arsr24 18-Jan-13 7:04am

@Griff,That is correct Griff,but when a row is created (which are textboxes) user enters the value ,but when I trigger the click_event in the form ,all I get in "monday_txt.Text" is a empty string..but if I create a click event in the usercontrol it works fine,I am stuck with this part from four days,how do I use the reference variable value? and how do I write it to database?

OriginalGriff 18-Jan-13 7:08am

Post your click event handler and I'll have a quick look.

arsr24 18-Jan-13 7:11am

private void Edit_btn_Click(object sender, EventArgs e)
{

AddRow add = new AddRow();
show_pnl.Controls.Add(add);
show_pnl.Show();
count++;
Edit_btn.Hide();
Submit_btn.Hide();
save_pn.Show();
recshow.Hide();
//save_pn.BringToFront();
save_pn.Location = new Point(294, 523);

}

///
private void Add_Row_Click(object sender, EventArgs e)
{
var add = new AddRow();
add.Top = count * (add.Height-50) ;
add.AutoScroll = true;
show_pnl.Controls.Add(add);
count++;
remove_btn.Enabled = true;
}
also the Save_btn posted in my code above is the event using which I have to write into database,the code with the queries

arsr24 18-Jan-13 7:23am

@griff,sir,please help me fix this issue

OriginalGriff 18-Jan-13 7:50am

Ok - you are adding the new control instances into a panel - the show_pnl.
So, you could run through them:
foreach (Control cin show_pan.Controls)
{
AddRow ar = c as AddRow;
if (ar != null)
{
// ar is an instance of the AddRow controls you added - look at the monday_txt_val property of that.
...
}
}

How would you normally save into a database? And which database system?

arsr24 19-Jan-13 3:06am

@griff,mysql 2008,on save_btn click it should be saved into database,that is how I try adding to database

OriginalGriff 19-Jan-13 3:09am

Yes, but what code would you normally use? I don't want to suggest a solution involving SqlCommand objects if you normally use an SqlDataAdapter for example.

arsr24 19-Jan-13 3:55am

what code I use, as in? I didnt understand what you meant Griff?

arsr24 19-Jan-13 4:01am

@Griff,If I create a local click_event the values gets saved to database,say ,I create a save_btn in the user control,but when I create a save event in the form the value of the textbox is empty,I debugged ,the value is passed to the form when I trigger the save_event in the usercontrol but otherwise it a empty string

OriginalGriff 19-Jan-13 4:12am

I mean, show the code you use to save the data to teh database - probably the "local click event" is that is what is working.

arsr24 19-Jan-13 6:39am

@griff ,the above code posted in the question,when I paste the the same code in usercontrol, it adds to the database

OriginalGriff 19-Jan-13 6:52am

The chances are that when you use the code in the UserControl "add" is defined and refers to the active instance in some way.
When you execute it outside the Control, you have to refer to the control instance in order to get the textbox with info in it. If you create a new one, or look at a different instance it will likely be blank (or wrong)

arsr24 19-Jan-13 12:54pm

@griff,how do I do that? I really dont know how I do it,I know it`s because I am creating a new instance,I know why the problem is ,I just dont know how to work around it...can you please help?

OriginalGriff 20-Jan-13 5:10am

Not really - I can't see your code, or your screen, so I have no idea what you are doing with your controls.
It may be that you need to look through the panels Controls list as I suggested yesterday to find the instance.

arsr24 19-Jan-13 3:07am

@Griff,But save_btn is in the form,AddRow is my usercontrol