How to display the number row records in sql to textbox?

Amrul Hakim

this my code ;

Thank you

public MainDashboar_C()
{
InitializeComponent();
}
SqlConnection conn = new SqlConnection(@"Data Source=AM-PC\SQLEXPRESS;Initial Catalog=Management_Gudang;Integrated Security=True");
public SqlDataReader READER;
private void Tampikan_Label()
{
conn.Open();
SqlCommand CMD = new SqlCommand("Select COUNT(*) From Stok_Barang ", conn);
READER = CMD.ExecuteReader();
if (READER.HasRows)
{
txt_BarangMasuk.Text = READER.ToString();
}
Else
{
txt_BarangMasuk.Text = "0";
}
}

2 Replies

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