if you want Tutorails for insert,update and deletethis is perfect link.
and another one if you want to count the rows in the table you can simply fire a query of "SELECT Count(*) from table" and pass it to SqlCommand. and then exeuct this command with Execute Scalar you will get your result.
how to pass it to SQL comand?
could u give me the key code?
first see that link which i give you. it's a complete solution for answer. and pass query to command like this.
dim con as new SqlConnection("your connection string") con.open() dim cmd as new SqlCommand("Select Count(*) from TableName",con) dim i as integer=Cmd.ExecuteScalar() MeaageBox.Show(i) cmd=nothing con.close()
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.