HI Jeswanth,

Thanks for the reply!! Sorry to say but your method won't work. You are just making server name dynamic.

My question was can we select multiple values for parameter with that connection string.

As it is single connection string and it can take only one database at a time. And in your given string it can take only one server name and related database name.

I hope you understand now. Some1 has any idea about selecting multiple values for parameter. Please let me know.

Thanks