Click here to Skip to main content
13,091,300 members (48,851 online)
Rate this:
Please Sign up or sign in to vote.

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 19:35pm

1 solution

Rate this: bad
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"));
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DataTable dt = new DataTable();
dataGridView1.DataSource = dt;

Please let me know if you have any doubt in
ArunAmalraj 4-Mar-13 2:15am
This is my StoredProcedure:

Create PROCEDURE LoadAppointment


SELECT * FROM [Scheduler].[dbo].[tblAppointments]


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 |
Web02 | 2.8.170813.1 | Last Updated 4 Mar 2013
Copyright © CodeProject, 1999-2017
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