What I did wrong please?

Question

0.00/5 (No votes)

See more:

Hi Guy i need Ur Help,
what i do wrong??
Here ~~hier~~ is my code

SQL

SqlConnection connection = new SqlConnection("Data Source= .\\SQLEXPRESS;"+
            " Initial Catalog= zeit; integrated security = true");


SqlDataAdapter data = new SqlDataAdapter();

data.InsertCommand = new SqlCommand("insert into AbhängigkeitTabelle"+
    "values("+
     "Select V_ID from Netzplan where V_Name = '@VName')"+
    ",(select Vorgang_ID from Netzplan_2 where Abhängigkeiten ='@Ab' ))", connection);
data.InsertCommand.Parameters.Add("@VName", SqlDbType.VarChar).Value = VorgangNameTextBox.Text;
data.InsertCommand.Parameters.Add("@Ab", SqlDbType.VarChar).Value = AbhängigkeitenTextBox.Text;


connection.Open();
data.InsertCommand.ExecuteNonQuery();
MessageBox.Show(" Datei eingefügt");
connection.Close();

I Think something is wrong with my new SqlCommand but i don't know why.

Posted 20-Apr-12 1:18am

stefan from germany

Updated 20-Apr-12 1:20am

sravani.v

v3

Add a Solution

Comments

Prasad_Kulkarni 20-Apr-12 7:20am

Do you getting any error?? What exact problem is?? Please clarify

bhagirathimfs 20-Apr-12 7:21am

what is the error message?

stefan from germany 20-Apr-12 7:44am

Firstly i see that i forget to put a space between values and my table. after that i put the space i receve this error

Incorrect syntax near the keyword 'Select'.
Incorrect syntax near ')'.
Incorrect syntax near ')'.

how can i resolv it??

2 solutions

Add a Solution

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

bhagirathimfs · Accepted Answer · 2012-04-20T01:25:00

Solution 1

Hi
I think

SQL

Select V_ID from Netzplan where V_Name = '@VName'
select Vorgang_ID from Netzplan_2 where Abhängigkeiten ='@Ab'

the above query is returning more than one row.

please check the above query should not return more than one row in every case.
means:V_Name and Abhängigkeiten columns must be unique type.

Posted 20-Apr-12 1:25am

bhagirathimfs

Updated 20-Apr-12 1:27am

v2

Comments

sravani.v 20-Apr-12 7:29am

5!

stefan from germany 20-Apr-12 7:30am

and how can i repare it please. in SQL Server all is Ok but how can i do so that it walk in c# please?

bhagirathimfs 20-Apr-12 7:41am

In the where clause use unique value stored column.

AmitKumar89 · Accepted Answer · 2012-04-20T01:46:00

Hi there,

I caught your error..

Try this.

C#

SqlConnection connection = new SqlConnection("Data Source= .\\SQLEXPRESS;"+
            " Initial Catalog= zeit; integrated security = true");
 

SqlDataAdapter data = new SqlDataAdapter();
 
data.InsertCommand = new SqlCommand("insert into AbhängigkeitTabelle"+
    " values("+
     "Select V_ID from Netzplan where V_Name = '@VName')"+
    ",(select Vorgang_ID from Netzplan_2 where Abhängigkeiten ='@Ab' )", connection);
data.InsertCommand.Parameters.Add("@VName", SqlDbType.VarChar).Value = VorgangNameTextBox.Text;
data.InsertCommand.Parameters.Add("@Ab", SqlDbType.VarChar).Value = AbhängigkeitenTextBox.Text;
 

connection.Open();
data.InsertCommand.ExecuteNonQuery();
MessageBox.Show(" Datei eingefügt");
connection.Close();

This may help you.. All the best.

What I did wrong please?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

What I did wrong please?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us