InfoPath or .Net which will be easier for the requirements I have

R

Reetu

Hi All,

I have a dropdown listbox which displays all the tables from a database and
the query used to do this is 'select name,id from sysobjects where xtype =
'U''.

When the user selects a table name I would like to display all the column
names(Query used is "SELECT name,id FROM syscolumns";
) from that table and a checkbox next to it. The user will select columns
via the check box and then only those columns will appear in the query
results. To acheive this I dragged Syscolumns dataSource on the form and
clicked on Repeating table. This added 4 fields of the syscolumn table-->
Name, Id, Colid and Number.
Then I added conditional formatting on Name and Number field(converted it to
checkbox from textbox) to display only those values from Syscolumns which
belongs to the table selected in the drop down. I also modified the view.xsl
file to hide the checkbox when required.

Please let me know if you see any problems till now in what I have
implemented.

I have the following problem-->

Next the user should input the values of some selected columns and click
query button to display the results in an excel file. First of all I do not
have input boxes next to each column and I am kind of confused how to proceed
further.

Also I am wondering is it possible to display query results directly in an
excel file?

I would appreciate if someone could show me some direction.

Regards,
-Reetu
 
A

amol

Hi All,

I have a dropdown listbox which displays all the tables from a database and
the query used to do this is 'select name,id from sysobjects where xtype =
'U''.

When the user selects a table name I would like to display all the column
names(Query used is "SELECT name,id FROM syscolumns";
) from that table and a checkbox next to it. The user will select columns
via the check box and then only those columns will appear in the query
results. To acheive this I dragged Syscolumns dataSource on the form and
clicked on Repeating table. This added 4 fields of the syscolumn table-->
Name, Id, Colid and Number.
Then I added conditional formatting on Name and Number field(converted it to
checkbox from textbox) to display only those values from Syscolumns which
belongs to the table selected in the drop down. I also modified the view.xsl
file to hide the checkbox when required.

Please let me know if you see any problems till now in what I have
implemented.

I have the following problem-->

Next the user should input the values of some selected columns and click
query button to display the results in an excel file. First of all I do not
have input boxes next to each column and I am kind of confused how to proceed
further.

Also I am wondering is it possible to display query results directly in an
excel file?

I would appreciate if someone could show me some direction.

Regards,
-Reetu
Click to expand...

Reetu,
I understood first part of your requirement. I am not sure what do you
mean by excel file later in second part.
Anyways, if you want to query particular tables, may be when you
create your form template select database template and then try it.
It will easily solve your problem.

Amol
 
Top