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 ON ROW DATA BOUND EVENT

 Database Create  Student : roll , name , city , cost  Fix 6 Value  in Database Record  ====================================================...

  • 30. MVC ALL ACTION CONCEPT
      100% Placement Training Program   Mr. Nilesh Gupta Founder , NRsolution4u https://nileshsir.com/ http://...
  • Komal Student Notes
     .net framework framework is a collection of tools and library which is used to applications development .net environment 1) programming env...
  • Final Email Programming
      Email programming 1)     Email is provide a communication between one system to an other system 2)     Types of email-   1.generic mai...