Click here to Skip to main content
13,398,090 members (33,884 online)
   

LINQ

 
AnswerRe: LINQ Pin
Pete O'Hanlon3-Oct-12 23:22
protectorPete O'Hanlon3-Oct-12 23:22 
AnswerRe: LINQ Pin
ProgramFOX5-Oct-12 6:33
memberProgramFOX5-Oct-12 6:33 
AnswerRe: LINQ Pin
emma926-Dec-12 7:23
memberemma926-Dec-12 7:23 
AnswerRe: LINQ Pin
tunheo24-Dec-12 23:17
membertunheo24-Dec-12 23:17 
GeneralMessage Closed Pin
12-Feb-13 21:09
memberMahesh Sellamuthu12-Feb-13 21:09 
Suggestionlinq to sql obtain foreign key value Pin
sc steinhayse24-Aug-12 20:40
membersc steinhayse24-Aug-12 20:40 
GeneralRe: linq to sql obtain foreign key value Pin
rs_engg5-Sep-12 4:43
memberrs_engg5-Sep-12 4:43 
Questionminus returned value during executing a insert stored procedure Pin
Member 870070423-Aug-12 6:37
memberMember 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 Pin
Wes Aday23-Aug-12 7:00
memberWes Aday23-Aug-12 7:00 
AnswerRe: minus returned value during executing a insert stored procedure Pin
BobJanova23-Aug-12 7:14
memberBobJanova23-Aug-12 7:14 
QuestionLINQ or ADO.NET ? Pin
pashmakjoon19-Aug-12 11:11
memberpashmakjoon19-Aug-12 11:11 
AnswerRe: LINQ or ADO.NET ? Pin
Richard MacCutchan20-Aug-12 0:03
mvpRichard MacCutchan20-Aug-12 0:03 
AnswerRe: LINQ or ADO.NET ? Pin
thatraja20-Aug-12 1:39
mvpthatraja20-Aug-12 1:39 
GeneralRe: LINQ or ADO.NET ? Pin
manijasmine20-Aug-12 9:07
membermanijasmine20-Aug-12 9:07 
AnswerRe: LINQ or ADO.NET ? Pin
Kolkata .NET8-Mar-13 6:45
memberKolkata .NET8-Mar-13 6:45 
Questionhow to load and save an xml document using linq Pin
owobs15-Aug-12 2:57
memberowobs15-Aug-12 2:57 
AnswerRe: how to load and save an xml document using linq Pin
Wayne Gaylard15-Aug-12 3:16
mentorWayne Gaylard15-Aug-12 3:16 
QuestionCreating a dynamic where clause Pin
Simon_Whale9-Aug-12 1:06
memberSimon_Whale9-Aug-12 1:06 
AnswerRe: Creating a dynamic where clause Pin
Pete O'Hanlon9-Aug-12 1:22
protectorPete O'Hanlon9-Aug-12 1:22 
GeneralRe: Creating a dynamic where clause Pin
Simon_Whale9-Aug-12 1:26
memberSimon_Whale9-Aug-12 1:26 
GeneralRe: Creating a dynamic where clause Pin
BobJanova9-Aug-12 3:11
memberBobJanova9-Aug-12 3:11 
GeneralRe: Creating a dynamic where clause Pin
Simon_Whale9-Aug-12 4:10
memberSimon_Whale9-Aug-12 4:10 
GeneralRe: Creating a dynamic where clause Pin
Pete O'Hanlon9-Aug-12 4:40
protectorPete O'Hanlon9-Aug-12 4:40 
GeneralRe: Creating a dynamic where clause Pin
Simon_Whale9-Aug-12 4:44
memberSimon_Whale9-Aug-12 4:44 
QuestionLinq where dates question Pin
Member 78188928-Jul-12 14:23
memberMember 78188928-Jul-12 14:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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 |
Web02 | 2.8.180216.1 | Last Updated 13 Feb 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid