MEENAU

u can save in a temp table as shown follow SELECT a.* into Temp_Table FROM svn_headline a where a.newstypeid=2 UNION SELECT b.* FROM svn_crimenews b where b.newstypeid=2 order by newsdatetime desc and then by count of temp table u get total records Select count(*) from Temp_Table

Public Function GetPhoto(ByVal filePath As String) As Byte() Dim stream As FileStream = New FileStream(filePath, FileMode.Open, FileAccess.Read) Dim reader As BinaryReader = New BinaryReader(stream) Dim photo() As Byte = reader.ReadBytes(stream.Length) reader.Close() stream.Close() Return photo End Function

u can also use identity field to auto generate ur field from sql .no need to write code.in sql select field and from properties put identity specification as yes..then it will autogenerate ur field as per ur record