assigning 2 textbox in c#

Ravindran S

2 textbox and 1 button. User cannt enter anything in first textbox and user can only enter value in 2nd textbox. now when user enter value in second textbox, i want the first textbox value(which i fixed) to be save in database. how? how i assign these both textbox in order to save both when i click button?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar6y ago
Accepted answer
Hello Ravindran S, just set disable or set readonly to first textbox thats it and there is no changes in saving textbox data to database.
// disable textbox
textBox1.Enabled = false;
Below is the sample code to save data to database
public partial class Form1 : Form
{
        public Form1()
        {
            InitializeComponent();
        }
        SqlConnection conn;
        SqlCommand comm;
        string connstring = "server=localhost;database=student;user=sa;password=wintellect";

        private void btnsave_Click(object sender, EventArgs e)
        {
            conn = new SqlConnection(connstring);
            conn.Open();
            comm = new SqlCommand("insert into student_detail(Name,Lastname) values(" +
                textbox1.Text + ",'" + textbox2.Text + "')", conn);
            try
            {
                comm.ExecuteNonQuery();
                MessageBox.Show("Saved...");
            }
            catch (Exception)
            {
                MessageBox.Show("Not Saved");
            }
            finally
            {
                conn.Close();
            }
        }
}
Rajanikant Hawaldar6y ago
Hello ravindran please post your code what you have done so far, add comments in code where what problem your facing or what you want to be get it done
Ravindran S6y ago
Hello bro so nice of you. But this i think so wont be a solution for my doubt.
There are many text boxes in my interface. In each row there are 2 textbox. So like this got many rows. the first textbox in every row are
// disable textbox
textBox1.Enabled = false;
like you said. In second textbox user will enter the value(int). [This is how my interface looks like]

Now my database. I have did 2 columns in the db. First column is for the disabled textbox and second is for the value text box. Now when a user enter a value, the value will be saved in db. My question is how to make the disabled value also to be saved in db when user enter value in the not disabled textbox and click the button. Get me ?

assigning 2 textbox in c#

Ravindran S

6y804Visual Basic .NET

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar6y ago
Accepted answer
Hello Ravindran S, just set disable or set readonly to first textbox thats it and there is no changes in saving textbox data to database.
// disable textbox
textBox1.Enabled = false;
Below is the sample code to save data to database
public partial class Form1 : Form
{
        public Form1()
        {
            InitializeComponent();
        }
        SqlConnection conn;
        SqlCommand comm;
        string connstring = "server=localhost;database=student;user=sa;password=wintellect";

        private void btnsave_Click(object sender, EventArgs e)
        {
            conn = new SqlConnection(connstring);
            conn.Open();
            comm = new SqlCommand("insert into student_detail(Name,Lastname) values(" +
                textbox1.Text + ",'" + textbox2.Text + "')", conn);
            try
            {
                comm.ExecuteNonQuery();
                MessageBox.Show("Saved...");
            }
            catch (Exception)
            {
                MessageBox.Show("Not Saved");
            }
            finally
            {
                conn.Close();
            }
        }
}
Rajanikant Hawaldar6y ago
Hello ravindran please post your code what you have done so far, add comments in code where what problem your facing or what you want to be get it done
Ravindran S6y ago
Hello bro so nice of you. But this i think so wont be a solution for my doubt.
There are many text boxes in my interface. In each row there are 2 textbox. So like this got many rows. the first textbox in every row are
// disable textbox
textBox1.Enabled = false;
like you said. In second textbox user will enter the value(int). [This is how my interface looks like]

Now my database. I have did 2 columns in the db. First column is for the disabled textbox and second is for the value text box. Now when a user enter a value, the value will be saved in db. My question is how to make the disabled value also to be saved in db when user enter value in the not disabled textbox and click the button. Get me ?