assigning 2 textbox in c#

Question

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?

Rajanikant Hawaldar · 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 Hawaldar · Answer

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 S · Answer

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 ?