get and set modifier

Question

Dear everyone

I have created a class and call it Employee. I want to call it on my aspx page using submit button. on my aspx page I have textbox which will save my data into database I called my Textbox txtemployeeNo.

how to save this data into data from my txtemployeeNo textbox

this is where I'm calling my call

protected void button1_click(object sender , EventArgs e)

{

Employee emp = new Employee();

//please add the missing code here.

}

regards

thanks in advance

Midhun T P · Answer

Hi You have to create a method in your Employee class to save data to database as below public void savedata( string name) { string connectionString= PersistSecurityInfo=False;UserID=sa;Password=123;InitialCatalog=Databasename;Server=servername ; using (SqlConnectionconnection= new SqlConnection(connectionString)) { SqlCommandcmd= new SqlCommand( INSERTINTOTablename(Name)VALUES(@Name) ); cmd.CommandType=CommandType.Text; cmd.Connection=connection; cmd.Parameters.AddWithValue( @Name name); connection.Open(); cmd.ExecuteNonQuery(); } } Then on button click you can use below code protected void button1_click( object senderEventArgse) { Employeeemp= new Employee(); emp.savedata(txtemployeeNo.Text); }