Is it possible 2 make 2 sql staments in the same repeater without use UNION or INNER JOIN

Question

0.00/5 (No votes)

See more:

Hi
I have one repeater and 2 tables, and I want to eval the two tabels at the same time but without melting them together.

Could I do it in the codebehind, when I bind the data to the repeater??

C#

SqlConnection conn = new SqlConnection();
            conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = @"SELECT * FROM frugt??? Can I have 2 select here?
 
ORDER BY Type";

            conn.Open();
            DataTable visProdukter = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            adapter.Fill(visProdukter);
            cmd.ExecuteNonQuery();
            conn.Close();
            VisProdukt.DataSource = visProdukter;
            VisProdukt.DataBind();

/Tina

Posted 18-Oct-13 0:35am

tina_overgaard

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdy Moini · Accepted Answer · 2013-10-18T05:59:00

Solution 2

I Suggest to change repeater's header to general name for fruit and vegetable
like productid, produtname, varedi
then your select statement will be:

SQL

SELECT  frugt_id AS Product_id, frugt_navn AS ProductName, vaerdi AS vaerdi, FROM frugt UNION SELECT groent_id AS ProductID, groent_navn AS ProductName, groent_vaerdi AS Varedi FROM groent

then you will not have 0 value in your repeater.
Hope it helps

Posted 18-Oct-13 5:59am

Mehdy Moini

Comments

tina_overgaard 18-Oct-13 15:29pm

Thank you very much for your help

Mehdy Moini 18-Oct-13 16:02pm

Welcome

Thomas ktg · Accepted Answer · 2013-10-18T01:13:00

Solution 1

Yes. It is possible to write two select statements using DataReader and DataAdapter

Refer here for more details,
Executing multiple SQL statements as one against SQL Server[^]

Posted 18-Oct-13 1:13am

Thomas ktg

Comments

tina_overgaard 18-Oct-13 7:35am

I cannot use the datatable??

Thomas ktg 18-Oct-13 7:42am

How do you want it to be done then?

tina_overgaard 18-Oct-13 11:09am

I want to use the repeater that I know.
I have to get this SELECT * FROM frugt and SELECT * FROM groent inside the same repeater is that possible? I really hope so or else I have a problem

Mehdy Moini 18-Oct-13 8:27am

VisProdukt is a grid with two table?

tina_overgaard 18-Oct-13 9:52am

It is a repeater with to tables. The one is fruits and the another one is vegetables.

You can only choose 14 fruits and only 7 vegetables. Therefor I need both textbox to get the user information in a session to another page

tina_overgaard 18-Oct-13 9:53am

I have tried this one:

SELECT '0' AS groent_id, frugt_id AS frugt_id, '0' as groent_navn, frugt_navn AS frugt_navn, vaerdi AS vaerdi, '0' AS groent_navn FROM frugt
UNION
SELECT groent_id AS groent_id, '0' AS frugt_id, groent_navn AS groent_navn, '0' AS frugt_navn, '0' AS vaerdi, groent_vaerdi AS groent_navn FROM groent

But then I get empty things where the rows is 0, Dont know if I can hide them or something

Mehdy Moini 18-Oct-13 11:42am

Remove rows you don't wont by where clause!
How do you want to bind a repeater with unique Column name header with two tables which they have different column name?

tina_overgaard 18-Oct-13 11:45am

I dont know how i solved this one

tina_overgaard 18-Oct-13 11:48am

Can I do something in the sql statement? I am really blank on this one. I have made the code when you insert something in the textbox you Will be going to the next page where there stand how much you have orderd and then you insert name and adress.

Mehdy Moini 18-Oct-13 11:49am

Why don't you use two repeaters?

tina_overgaard 18-Oct-13 11:52am

Can I use neasted repeater or just two repeaters?
Can i write when i try this?

Is it possible 2 make 2 sql staments in the same repeater without use UNION or INNER JOIN

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Is it possible 2 make 2 sql staments in the same repeater without use UNION or INNER JOIN

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us