How to Update/Set the textbox value after Grid Updating.

Question

Dear I wrote below code when grid update then fire that code and set the value in TextBox/Label. I debug the below code and see the Value is getting but not showing in TextBox/Label. When it showing when the complete page getting refreshed. I called in Page_Load also. Private Sub frm_getObjectivescore() con.Open() cmd = New SqlClient.SqlCommand(select sum(Value) as T_Count from View_EmployeeAp Where Apr_No= & Request(Apr_No) &  con) dr = cmd.ExecuteReader() If dr.HasRows Then While dr.Read TextBox1.Text = Math.Round(dr(T_Count) * 0.4 2) End While End If con.Close() End Sub

Rupali Shinde · Answer

Hi Basit Below code working proper & value get save to textbox as per ur requirement. SqlCommand cmd = new SqlCommand(Select * from Student conn); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { int ans = reader.GetInt32(0); var ans2 = reader.GetString(1); Result.Text = ans.ToString(); } } else { Console.WriteLine(No rows found.); } If it works out Please Accept this as Answer

Sujeet Suman · Answer

Basit just once put a button on your form & on button click event call your _getObjectivescore(). Definitely your textbox will show text. So I think you are not calling your method properly. So either call your method on form load or on a button click event.

Priyaranjan K S · Answer

Basit  If I understand it right You are returning a single sum then why are you using Execute reader . You should be using execute scalar . Moreover use try catch mechanism to catch any error .Please try out the below code format . This is for returning the customer name . Make changes appropriately to get your query working : Public Function GetCustomerName() As String Dim query As String = SELECT CustName FROM Customers WHERE CustID = 2 Dim connString As String = Data Source=local;Initial Catalog=SampleDB;Integrated Security=True Dim conn As New SqlConnection(connString) Dim cmd As New SqlCommand(query conn) Dim custName As String =  Try conn.Open() custName = cmd.ExecuteScalar().ToString() // This is the assignment part Catch ex As Exception Response.Write(ex.Message) Finally conn.Close() End Try Return custName End Function ExecuteScalar() method is used here to retrieve a single value that is customer name for a specific customer ID. It returns object value so we have to cast it in appropriate type “string” to assign it to variable. Thanks Priyan If you found this useful Please mark this as Answer

basit khan · Answer

Dear All Many Thanks to all of you. As you can see my attached image shows that dr has value. I tired with the hard code value then also its not showing in textbox. Below is the code. con.Open() cmd = New SqlClient.SqlCommand(select sum(Value) as T_Count from View_EmployeeApraisalDetails2 Where Apr_No= & Request(Apr_No) &  con) dr = cmd.ExecuteReader() If dr.HasRows Then While dr.Read TextBox1.Text = 2 End While End If con.Close()

Sujeet Suman · Answer

Basit please once try below code: Private Sub frm_getObjectivescore() con.Open() cmd = New SqlClient.SqlCommand(select sum(Value) as T_Count from View_EmployeeAp Where Apr_No= & Request(Apr_No) &  con) dr = cmd.ExecuteReader() If dr.HasRows Then While dr.Read TextBox1.Text = Convert.ToString(Math.Round(dr[0] * 0.4 2)) End While End If con.Close() End Sub If this is helpful for you then please accept my Answer.

Priyaranjan K S · Answer

Basit Were you able to confirm if the dr was having value ? If so try out this : TextBox1.Text = Math.Round( Convert.ToDecimal( dr(T_Count)) * 0.4 2) ; Thanks Priyan If you found this useful Please mark this as Answer

basit khan · Answer

Dear Please find the attached image 'dr' giving the value but not set in textbox.

Priyaranjan K S · Answer

Hi Basit It seems you are returning only one value from the back end . In this scenario use ExecuteScalar as below : String sql = SELECT ColumnNumber FROM learer WHERE learer.id =  + index; SqlCommand cmd = new SqlCommand(sqlconn); learerLabel.Text = (String) cmd.ExecuteScalar(); Thanks Priyan If you found this useful Please mark this as Answer

Sujeet Suman · Answer

Basit please once check your dr having some value or not then try below code: TextBox1.Text = (Math.Round(dr(T_Count) * 0.4 2)).ToString() If this is helpful for you then please accept my Answer.