I am working on a QV report, in which I have a List Box of some string type. Each value is associated with a data connection string in sql.
e.g. My list have these values .
when I select first value connection string would be like:
OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=123_ABC_12;Initial Catalog=123_ABC_12;Data Source=server name;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=NDHD201283;Use Encryption for Data=False;Tag with column collation when possible=False];
and password is : 123_ABC_12
So I want data connection would be dynamic.