TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Shomen Deb
NA
43
0
Pass parameter for stored procedure in crystal report
Jan 28 2009 5:58 AM
I have stored procedure like: CREATE PROCEDURE dbo.item_type (@LC_No nvarchar(250)) AS select (Type_yarn + Count_yarn) as Yarn_Type from LC_Statement_Yarn_View where LC_No=@LC_No GO I want to pass parameter value to stored procedure. Part of my coding is like that: SqlCommand comm01 = new SqlCommand("item_type", conn); comm01.CommandType = CommandType.StoredProcedure; //comm01.Parameters.Add(new SqlParameter("@LC_No", yarn_LC)); ParameterFields paramFields = new ParameterFields(); ParameterField param_yarn_LC = new ParameterField(); param_yarn_LC.ParameterFieldName = "@LC_No"; //year is Crystal Report Parameter name. ParameterDiscreteValue dis_yarn_LC = new ParameterDiscreteValue(); dis_yarn_LC.Value = yarn_LC;//Import_Register.Program.Bank_name.Bank01; param_yarn_LC.CurrentValues.Add(dis_yarn_LC); paramFields.Add(param_yarn_LC); crystalReportViewer1.ParameterFieldInfo = paramFields; -------------------------------- But it is not working. Parameter is not taken by crystal report. Is there any process to pass parameter to stored procedure?
Reply
Answers (
1
)
tree view control - selected node Parent node should be bold
DataGridView and application freeze problem