Click here to Skip to main content
   

LINQ

 
AnswerRe: LINQ PinprotectorPete O'Hanlon3-Oct-12 23:22 
AnswerRe: LINQ PinmemberProgramFOX5-Oct-12 6:33 
AnswerRe: LINQ Pinmemberemma926-Dec-12 7:23 
AnswerRe: LINQ Pinmembertunheo24-Dec-12 23:17 
GeneralMessage Automatically Removed PinmemberMahesh Sellamuthu12-Feb-13 21:09 
Suggestionlinq to sql obtain foreign key value Pinmembersc steinhayse24-Aug-12 20:40 
GeneralRe: linq to sql obtain foreign key value Pinmemberrs_engg5-Sep-12 4:43 
Questionminus returned value during executing a insert stored procedure PinmemberMember 870070423-Aug-12 6:37 
hi
I have a stored procedure in SQL Server 2005 for inserting in a table ; when I'm executing this procedure it works but also return a minus value?!why? what a minus returned value means here?
Thank you...
my code in C#:
string connSt = "Data Source=localhost;Initial Catalog=Status;Integrated Security=true;User ID=sa;Password=45637;Timeout=20000";
SqlConnection conn1 = new SqlConnection(connSt);
conn1.Open();
SqlCommand command = new SqlCommand("insertIninterface", conn1);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@interfaceName", SqlDbType.NVarChar).Value = textBox1.Text;
command.Parameters.Add("@interfaceIP", SqlDbType.NVarChar).Value = textBox2.Text;
command.Parameters.Add("@interfaceType", SqlDbType.Int).Value = textBox3.Text;
command.Parameters.Add("@maxValAllowed", SqlDbType.Int).Value = textBox4.Text;
command.Parameters.Add("@status", SqlDbType.Int).Value = textBox5.Text;
int rows = command.ExecuteNonQuery();
conn1.Close();
if (rows == 1)
{
MessageBox.Show("Success");
}
else
{
MessageBox.Show("Failed");
}
 

my stored procedure in SQL Server 2005:
 
@interfaceName nvarchar(50) ,
@interfaceIP nvarchar(50) ,
@interfaceType int ,
@maxValAllowed int ,
@status int
AS
BEGIN
SET NOCOUNT ON;
insert into interface(interfaceName,interfaceIP,interfaceType,maxValAllowed,status) values(@interfaceName,@interfaceIP,@interfaceType,@maxValAllowed,@status)
END
AnswerRe: minus returned value during executing a insert stored procedure PinmemberWes Aday23-Aug-12 7:00 
AnswerRe: minus returned value during executing a insert stored procedure PinmemberBobJanova23-Aug-12 7:14 
QuestionLINQ or ADO.NET ? Pinmemberpashmakjoon19-Aug-12 11:11 
AnswerRe: LINQ or ADO.NET ? PinmvpRichard MacCutchan20-Aug-12 0:03 
AnswerRe: LINQ or ADO.NET ? Pinmvpthatraja20-Aug-12 1:39 
GeneralRe: LINQ or ADO.NET ? Pinmembermanijasmine20-Aug-12 9:07 
AnswerRe: LINQ or ADO.NET ? PinmemberKolkata .NET8-Mar-13 6:45 
Questionhow to load and save an xml document using linq Pinmemberowobs15-Aug-12 2:57 
AnswerRe: how to load and save an xml document using linq PinmentorWayne Gaylard15-Aug-12 3:16 
QuestionCreating a dynamic where clause PinmemberSimon_Whale9-Aug-12 1:06 
AnswerRe: Creating a dynamic where clause PinprotectorPete O'Hanlon9-Aug-12 1:22 
GeneralRe: Creating a dynamic where clause PinmemberSimon_Whale9-Aug-12 1:26 
GeneralRe: Creating a dynamic where clause PinmemberBobJanova9-Aug-12 3:11 
GeneralRe: Creating a dynamic where clause PinmemberSimon_Whale9-Aug-12 4:10 
GeneralRe: Creating a dynamic where clause PinprotectorPete O'Hanlon9-Aug-12 4:40 
GeneralRe: Creating a dynamic where clause PinmemberSimon_Whale9-Aug-12 4:44 
QuestionLinq where dates question PinmemberMember 78188928-Jul-12 14:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.150123.1 | Last Updated 17 Dec 2014
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid