troubleshooting Question

Basic Web API to view data

Avatar of AlHal2
AlHal2Flag for United Kingdom of Great Britain and Northern Ireland asked on
C#
1 Comment1 Solution61 ViewsLast Modified:
I'm writing a basic web API.  The code below is in the values controller and should put two rows from the data table into a JSON file.
How do I amend the code, so that it produces the file?
What URLs will work?

        public DataTable Get(string EmployeeName="Joe",string EmpCode="AR")
        {

                string ConnectionString = ConfigurationManager.ConnectionStrings["WebAPIDb"].ConnectionString;
                using (SqlConnection sqlCon = new SqlConnection())
                {
                    using (SqlCommand sqlcmd = new SqlCommand())
                    {
                        using (SqlDataAdapter sqladp = new SqlDataAdapter())
                        {
                            using (DataTable dt = new DataTable())
                            {
                                sqlCon.ConnectionString = ConnectionString;
                                sqlcmd.Connection = sqlCon;
                                sqlcmd.Parameters.Clear();
                                sqlcmd.CommandType = CommandType.StoredProcedure;
                                sqlcmd.CommandText = "EmployeeTable";
                                sqlcmd.Parameters.AddWithValue("@Operation", "S");
                                sqlcmd.Parameters.AddWithValue("@FirstName", "Joe");
                                sqlcmd.Parameters.AddWithValue("@Empcode", "AR");
                                sqladp.SelectCommand = sqlcmd;
                                sqladp.Fill(dt);
                                return dt;

                            }

                        }

                    }
                }

           

        }
ASKER CERTIFIED SOLUTION
AlHal2

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros