Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

clr stored procedure object type input parameters ?

Home
Forums
Learn iOS Programming

clr stored procedure object type input parameters ?

Arjun V

8yAsked Nov 8, 2017, 2:07 AM1kLearn iOS Programming

Please give me example for clr stored procedure object type input parameters ?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Arjun V8y ago
Thank Promod but I want total store procedure my input parameter object like json object like below so how to handle it

{
"name":"arjun",
"age":30,
"cars": {
"car1":"Ford",
"car2":"BMW",
"car3":"Fiat"
}
}
0
Pramod Thakur8y ago
You can try this..
public void InsertRecord(Employee objEmployee)
{
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["mycon"].ToString());
string query = "INSERT INTO tblEmployees VALUES(@Name, @Gender, @City, @Salary) ";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@Name", objEmployee.Name);
cmd.Parameters.AddWithValue("@Gender", objEmployee.Gender);
cmd.Parameters.AddWithValue("@City", objEmployee.City);
cmd.Parameters.AddWithValue("@Salary", objEmployee.Salary);
con.Open();
cmd.ExecuteScalar();
con.Close();
}
catch
{
throw;
}
}
0
Pramod Thakur8y ago
Can you share your problem..
0