Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005
Hello,
 
Create PROCEDURE LoadAppointment
 
AS
 
SELECT * FROM [Scheduler].[dbo].[tblAppointments]
 
GO
Posted 3-Mar-13 21:27pm
Comments
Karthik Harve at 4-Mar-13 2:35am
   
This is not a question. if any thing wrong sql server would throw error. if the server is throwing any error, then paste that error message.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Looks like a Valid one. Now, you should have simply run and checked in the SQL server yourself instead of posting and asking here.
Refer: MSDN: CREATE PROCEDURE (Transact-SQL)[^]
 
Make sure this is correct table reference: [Scheduler].[dbo].[tblAppointments]
  Permalink  
Comments
ArunAmalraj at 4-Mar-13 3:43am
   
I have this code: But, my DataTable is not getting loaded with any data.
 
//var conn = new SqlConnection(ConnectionString);
//var cmd = new SqlCommand
// {
// Connection = conn,
// CommandText = "LoadAppointment",
// CommandType = CommandType.StoredProcedure
// };
////cmd.Parameters.Add(new SqlParameter("Parametr Name", "Parameter value"));
//cmd.Connection.Open();
//var dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
//var dt = new DataTable();
//dt.Load(dr);
 
Thanks for your help so far. Awaiting for a Solution to accept.

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

  Print Answers RSS
0 OriginalGriff 304
1 Sergey Alexandrovich Kryukov 255
2 Shweta N Mishra 216
3 Maciej Los 210
4 PIEBALDconsult 184
0 OriginalGriff 7,630
1 Sergey Alexandrovich Kryukov 7,022
2 DamithSL 5,586
3 Manas Bhardwaj 4,946
4 Maciej Los 4,525


Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 4 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100