title: how to get datagridview current row column value?
body: <p>I have a winform which has a gridview that is populating through a stored procedure the stored procedure is</p>
  
  <pre><code>    ALTER PROCEDURE [dbo].[spGetAllCustumer]
  
      AS
      SET NOCOUNT ON 
  SET XACT_ABORT ON  
      BEGIN TRAN
    BEGIN
  SELECT     Customer.CustID, Customer.CustName, Customer.CompanyName, Customer.CompanyRealtion, Contract.ContractID, Contract.ContractDate, 
                    '$'+ CONVERT(varchar,Contract.totalPayment,1), '$'+ CONVERT(varchar,Contract.monthlyInstallment,1), '$'+ CONVERT(varchar,Contract.totalCommission,1), Contract.ContractDuration, Contract.PaymentMode, Contract.Description, 
                    Customer.Disable
  FROM         Customer INNER JOIN
                    Contract ON Customer.CustID = Contract.CustID
  WHERE     (Customer.Disable = 'false')
  
   END
  commit
  </code></pre>
  
  <p>and I'm populating the gridview dynamically with this code</p>
  
  <pre><code>    con.ConnectionString = "Data Source=MRDEVELOPER;Initial Catalog=Crystal_Accounts;Integrated Security=True";
              SqlCommand com = new SqlCommand();
              com.Connection = con;
              com.CommandText = "spGetAllCustumer";
              com.CommandType = CommandType.StoredProcedure;
              com.Parameters.Clear();
              con.Open();
              SqlDataReader dr = com.ExecuteReader();
              DataTable dt = new DataTable();
              dt.Load(dr);
              dataGridView1.DataSource = dt;
  </code></pre>
  
  <p>I want to select the custID, contractID, totalpayment of the selectedRow i don't know how can i do it and second question is about the currency sign that i used in the storedprocedure is it right way or what is the best way to do that?</p>