29-06-15, 08:58 AM
(آخر تعديل لهذه المشاركة : 30-06-15, 01:07 AM {2} بواسطة Genius Live.
تعديل السبب: method of writing
)
try this
Dim num As String = "SELECT MAX(ID_kh) + 1 AS Expr1 FROM Daily"
Dim OleDBDR As OledbDataReader
With OleDBC
.Connection = con
.CommandText = num
End With
OleDBDR = OleDBC.ExecuteReader
If OleDBDR.HasRows Then
While OleDBDR.Read
If OleDBDR.IsDBNull(0) = True Then
TextBox1.Text = 1
Else
TextBox1.Text = (OleDBDR.Item("Expr1"))
End If
End While
Else
TextBox1.Text = 1
End If
{ يَرْفَعِ اللَّهُ الَّذِينَ آمَنُوا مِنكُمْ وَالَّذِينَ أُوتُوا الْعِلْمَ دَرَجَاتٍ }
" Mohamed M. Bedair - " Abu Anas
Genius Live , Egypt

