(VB.NET)displaying row count in textbox using dataset

[venkata lakshmi prasanna]

in database primary key column is autonumber, if there are no records it should be displayed as 1 in textbox, if there records then it should display rows count+1 in textbox. please send using iif condition if possible. thank u

[Tirthadip]

whatever your SQL command....just do the following after populating your dataset with existing record.... Dim Rowcount As Integer=Dataset1.Tables(0).Rows.Count TextBox1.Text=Rowcount+1

Tirtha "A man can ride on your back only when it is bent....."

[venkata lakshmi prasanna]

if db is empty textbox1.text=1 else if db is having 3 records textbox1.text=ds.tables("emp").rows.count+1. how we can do this using if condition and as well as iif ternary operator. thank u