Click here to Skip to main content
12,069,857 members (49,073 online)
Rate this:
 
Please Sign up or sign in to vote.
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 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160208.1 | Last Updated 4 Mar 2013
Copyright © CodeProject, 1999-2016
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