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

Basit Khan

11y1.1kLearn iOS Programming

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

9 Replies

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

Rupali Shinde11y ago
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 Suman11y ago
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 S11y ago
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 Khan11y ago
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 Suman11y ago
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 S11y ago
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 Khan11y ago
Dear,

Please find the attached image 'dr' giving the value but not set in textbox.
Priyaranjan K S11y ago
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(sql,conn);
learerLabel.Text = (String) cmd.ExecuteScalar();

Thanks,
Priyan

If you found this useful Please mark this as Answer
Sujeet Suman11y ago
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.