Comments by SadiqMohammed (Top 1 by date)

Hi Debasis,
Thanks for the answer about excel borders Smile | :)

My first requirement is that I have a table in which I have kept a set of sql queries in a column and I have an SSIS package which will run 4 times a week, say it runs on Monday, Tuesday, Wednesday and Friday. On Monday it fetches a set of query, on Tuesday it fetches different set of query and vice-versa for Wednesday and Friday. For time being I used ExecuteScalar() to fetch query
Collapse | Copy Code

Try
cmdCommand.CommandText = strSQL.ToString()
cmdCommand.CommandType = CommandType.Text
cmdCommand.Connection = ConnOledb
drReader = Nothing
newReader = Nothing
cmdCommand.CommandText = newReader.ToString()
cmdCommand.CommandType = CommandType.Text
newReader = cmdCommand.ExecuteReader()
If newReader.HasRows Then
dtDetails.Load(newReader)
End If
newReader.Close()

drReader = cmdCommand.ExecuteReader()
If drReader.HasRows Then
dtDetails.Load(drReader)
End If
drReader.Close()

Catch ex As Exception
drReader = Nothing
End Try


but if i have to fetch two rows of data ,in my case I need to fetch two queries and execute it then how do I do it?

Is my requirement clear enough?


Thanks.