Thursday, August 17, 2023

SQL REPLACE FUNCTION IN A CODE

 string update1 = "update picdb  set pic=Replace(pic,'" + Label3.Text + "' , '" + newpic1.Text + "') 


    where pic like '%" + Label3.Text + "%'  and  id='" + rowid.Text + "'"; 

    

     cm = new SqlCommand(update1, cn);

     

      cm.ExecuteNonQuery();

       

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Gridview send email

 using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; ...

  • GRIDVIEW ON ROW DATA BOUND EVENT
     Database Create  Student : roll , name , city , cost  Fix 6 Value  in Database Record  ====================================================...
  • Store Procedure Notes
      Store   Procedure   CREATE PROCEDURE mytest2 AS BEGIN     SELECT         name ,         city     FROM         student...
  • 30. MVC ALL ACTION CONCEPT
      100% Placement Training Program   Mr. Nilesh Gupta Founder , NRsolution4u https://nileshsir.com/ http://...