GilaMonster (3/18/2014)

---

Insert a new row?

So, if the user selects all 25 columns one by one, then you want to have 25 separate rows in the database table, each with a...

Wenn I click the item 'User Name' from the listbox(assigned to the Textbox), I want to insert a value into the 'user_name' column in the DB. That's all. I have...

use env

go

create proc [SP$insert2](

@p1 nvarchar(100),

@p2 nvarchar(100),

@id int output

)

as

begin

set nocount on

INSERT INTO env.dbo.Base(user_name) VALUES (@p1)

SELECT @id = SCOPE_IDENTITY()

SELECT @p2

WHERE @p2 = 'User Name'

INSERT INTO env.dbo.Base(ser_num) VALUES (@p1)

SELECT @id=...

That's...

Sean Lange (3/17/2014)

---

You could greatly simplify this proc and remove about 40% of the lines which don't really provide anything.

create proc [SP$insert]

(

@p1 nvarchar(100),

@p2 nvarchar(100),

@id int output

)

as

set nocount on

select @p2...

Sean Lange (3/17/2014)

---

How do you know that the users are entering the right values in your textbox?

Your C# code is passing the value from a textbox...

GilaMonster (3/17/2014)

---

Remove the error handling (database side and client side, since both hide the errors) and have a look at exactly what is being returned

Also try running the stored proc...

Nothing. The message is 'Inserted' but any values can be inserted.

It still works same.

I doesn't give any error. The message is 'Inserted' but the...

No, it's the right value. Wenn I insert only...