asp.net mvc using string id on details view

Question

Please help me to find error on my code

public ActionResult Details(string id) { String connectionString = ConfigurationManager.ConnectionStrings["SAPB1"].ConnectionString; SqlConnection conn = new SqlConnection(connectionString); String sql = "Select a.[CardCode] As CCODE,a.[CardName] As Name from ocrd a where a.CardCode = " + id; SqlCommand cmd = new SqlCommand(sql, conn);

        BPModel BP = new BPModel();
        using (conn)
        {
            conn.Open();
            
            if (string.IsNullOrEmpty(id))
            {
                

            }

            SqlDataReader rdr = cmd.ExecuteReader();

            while (rdr.Read())
            {
                BP.CCODE = rdr["CCODE"].ToString();
                BP.Name = rdr["Name"].ToString();

            }




        }

        return View(BP);
    }

Karan · Accepted Answer · 2022-06-16 08:09:50Z

0

You need to wrap your id values inside single quote ('). Try like below.

String sql = "Select a.[CardCode] As CCODE,a.[CardName] As Name from ocrd a where a.CardCode = '" + id + "'";

answered Jun 16, 2022 at 8:09

Karan

12.7k3 gold badges31 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

asp.net mvc using string id on details view

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related