پرس جو

[amirghadiri]

مرسی از دوستان که جواب دادین متشکرم.
خودم پیداش کردم

            SqlCommand ocm = new SqlCommand("SELECT joziat,SUM(mablq) as ghj FROM tblcash where joziat=N'" + textBoxX1.Text + "' group by joziat");

            //SELECT joziat,SUM(mablq) as ghj FROM tblcash where joziat='a' group by joziat;

            ocm.Connection = objconnection;

            objconnection.Open();

            SqlDataReader sdr = ocm.ExecuteReader();

            if (sdr.Read())

            {

                string Name = sdr["ghj"].ToString();

                textBoxX2.Text = Name;

            }  

            // panel4.Visible = true;

            objconnection.Close();