Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005 C#
Hello,
 
My task is to: Load data into a Form using Stored Procedures only.
 
Mean that: By not using Dataset or Table Adapters
 
Note: My Stored Procedure selects all records from a particular table.
 
Would like to know: How to connect this through my C# code and load datas into my form.
 
Any help would be appreciated a lot!! Thanks in advance
Posted 3-Mar-13 20:35pm

1 solution

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

Solution 1

SqlConnection conn = new SqlConnection("Connectionstring....");
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "Procedurename..... ";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("Parametr Name", "Parameter value"));
cmd.Connection.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DataTable dt = new DataTable();
dt.Load(dr);
dataGridView1.DataSource = dt;
 

Please let me know if you have any doubt in
  Permalink  
Comments
ArunAmalraj at 4-Mar-13 2:15am
   
This is my StoredProcedure:
 
Create PROCEDURE LoadAppointment
 
AS
 
SELECT * FROM [Scheduler].[dbo].[tblAppointments]
 
GO
 
And the datatable doesn't load any data.
 
Note: My Table has its own records.

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

  Print Answers RSS
0 OriginalGriff 385
1 Sergey Alexandrovich Kryukov 329
2 CPallini 270
3 DamithSL 214
4 Maciej Los 192
0 OriginalGriff 5,515
1 DamithSL 4,451
2 Maciej Los 3,902
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,175


Advertise | Privacy | Mobile
Web03 | 2.8.141216.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